https://store-images.s-microsoft.com/image/apps.14811.eb73e122-168b-4544-87a2-d5141fc96888.44b7e44b-7552-494f-96b0-e33b19b41ddc.63edcff8-7c82-4d57-9aae-47acfad4579c

CitiBank Integration

by d365.Global Pty Ltd

Used to export PAIN files using SFTP, Encrypt files, Bank Account Reconciliation

CitiBank integration with azure storage for exporting payment files or import bank statement for bank account reconciliations.

Integrated with azure storage, the extension can be used to export PAIN files, i.e. export bank payment files to azure SFTP, encrypt the file as per bank format, import bank statement for bank account reconciliation on a daily basis.
This solution involves the secure exchange of payment files from Business Central to CitiBank via Azure containers and encrypted using PGP. Additionally, statement files are received from CitiBank, decrypted, and imported into the relevant bank accounts in Business Central instance.​


Architecture​

Business Central Overview​

  • Payment Journal (Pain)​

    • Business Central Payment Journal generates pain.001 format files under Business Central instance.​
    • Payment file is based on vendor bank account selection in payment journal.​
    • Mandatory checks are done before generating, like date must be always today, bank account no., IBAN no., city, country should be present.​
    • System checks if the file has already been exported if it is system will alert user if they want to again export the file.​
    • After successful export user can preview post the document in business central or post the document for accounting purpose.​
    • Duplicate checking is based on:​
      • #Total​
      • No of Transactions​

​

  • Statement (CAMT) (CitiBank to Client (BC)):​

    • Bank reconciliation.​
    • You can import the CAMT or Bank statement file into bank reconciliations via manually uploading the statement or importing it directly from container where bank has uploaded the statement.​
    • Bank reconciliation can be done daily as per the statement received from bank or can be done monthly, there is flexibility based on statement received from bank.​
    • After importing the statement business central can auto match the transactions based on description, amount. User can also manually match the statement line with bank ledger into system.​
    • Once the balance has matched with statement, user needs to post the bank reconciliation.​

At a glance

https://store-images.s-microsoft.com/image/apps.61412.eb73e122-168b-4544-87a2-d5141fc96888.44b7e44b-7552-494f-96b0-e33b19b41ddc.b67391dd-90eb-41cc-8c0d-8df41134cbed
https://store-images.s-microsoft.com/image/apps.15967.eb73e122-168b-4544-87a2-d5141fc96888.44b7e44b-7552-494f-96b0-e33b19b41ddc.3d31743a-5f62-4a6b-b572-6407614e3055
https://store-images.s-microsoft.com/image/apps.32315.eb73e122-168b-4544-87a2-d5141fc96888.44b7e44b-7552-494f-96b0-e33b19b41ddc.95526510-ee43-4f63-a4e7-7702e0ce461e