Raiffeisenbank for Stormware Pohoda

It downloads PDF statements from Raiffeisen Premium API for a specified period and uploads them to Sharepoint.

It downloads the corresponding XML statements and parses them. It imports the bank movements obtained in this way via mServer into Stormware Pohoda.

After importing all items, document liquidation is initiated and they are automatically matched.

When using PohodaSQL, links to PDF statements are attached to all movements.

Requirements

• php 8.1+
• Pohoda (Pohoda SQL for full functionality) + mServer
• Sharepoint User or Application Account
• MSSQL login and password
• php-sqlsrv

Setup command

Check certificate presence yet.

Transactions tool

Import Bank movements from RaiffeisenBank (using getTransactionList as source) to Pohoda using mServer

Configuration

EASE_LOGGER=syslog|console
CERT_FILE='RAIFF_CERT.p12'
CERT_PASS=CertPass
XIBMCLIENTID=PwX4bOQLWGiuoErv6I
ACCOUNT_NUMBER=666666666
ACCOUNT_CURRENCY=CZK

IMPORT_SCOPE=last_two_months
IMPORT_SCOPE=yesterday

API_DEBUG=True
APP_DEBUG=True
STATEMENT_LINE=ADDITIONAL
STATEMENT_SAVE_DIR=/tmp/rb

POHODA_ICO=12345678
POHODA_URL=http://10.11.25.25:10010
POHODA_USERNAME=mServerXXX
POHODA_PASSWORD=mServerXXX
POHODA_TIMEOUT=60
POHODA_COMPRESS=false
POHODA_DEBUG=true
POHODA_BANK_IDS=RB

DB_CONNECTION=sqlsrv
DB_HOST=192.168.25.23
DB_PORT=1433
DB_DATABASE=StwPh_12345678_2023
DB_USERNAME=pohodaSQLuser
DB_PASSWORD=pohodaSQLpassword
DB_SETTINGS=encrypt=false

Import Scopes

• today
• yesterday
• last_week
• last_month
• last_two_months
• previous_month
• two_months_ago
• this_year (statements only)
• January (statements only)
• February (statements only)
• March (statements only)
• April (statements only)
• May (statements only)
• June (statements only)
• July (statements only)
• August (statements only)
• September (statements only)
• October (statements only)
• November (statements only)
• December (statements only)
• auto
• 2024-08-05>2024-08-11 - custom scope
• 2024-10-11 - only specific day

Sharepoint Integration

Login based auth

OFFICE365_USERNAME=me@company.tld
OFFICE365_PASSWORD=xxxxxxxxxxxxxx

ClientID based auth

OFFICE365_CLIENTID=78842b49-651d-516e-0f2g-f979956aa620
OFFICE365_SECRET=09f04vbd-cfbc-5d78-afb7-2dfbebc4c385
OFFICE365_CLSECRET=8FR8Q~3Rab4-5o8dVd~1vDRId9oYiqEtMJB.Ucb2

Destination options

OFFICE365_TENANT=yourcomapny
OFFICE365_SITE=YourSite
OFFICE365_PATH='Shared documents/statements'

Into configuration file .env please put ClientID OR Login/Password values.

Powered by

• https://github.com/VitexSoftware/php-vitexsoftware-rbczpremiumapi
• https://github.com/Spoje-NET/PohodaSQL
• https://github.com/VitexSoftware/PHP-Pohoda-Connector

See also

• https://github.com/Spoje-NET/pohoda-client-checker
• https://github.com/Spoje-NET/raiffeisenbank-statement-tools

MultiFlexi

Pohoda RaiffeisenBank is ready for run as MultiFlexi application. See the full list of ready-to-run applications within the MultiFlexi platform on the application list page.

Debian/Ubuntu installation

Please use the .deb packages. The repository is availble:

   echo "deb http://repo.vitexsoftware.com $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/vitexsoftware.list
   sudo wget -O /etc/apt/trusted.gpg.d/vitexsoftware.gpg http://repo.vitexsoftware.com/keyring.gpg
   sudo apt update
   sudo apt install pohoda-raiffeisenbank

Po instalaci balíku jsou v systému k dispozici tyto nové příkazy:

• pohoda-raiffeisenbank-setup - check and/or prepare Bank account setup in Pohoda
• pohoda-raiffeisenbank-transactions - Import transactions. From latest imported or within the given scope
• pohoda-raiffeisenbank-statements - Import transactions from Account Statements.
• pohoda-raiffeisenbank-xml-statement - Import transactions from XML Statements file.
• pohodasql-raiffeisenbank-statements-sharepoint - Import transactions from Account Statements with link to Sharepoint