The primary purpose of this document is to provide all parties with guidance within regards to the core functionality in relation to the COINS – Cash Book – Bank Statement Load Integration with bank and COINS.
General Information of Functionality
The functionality will load bank statement files in the BAI-2 format, containing multiple bank accounts for multiple companies in COINS.
The functionality allows to download the bank statements from a bank’s secure file transfer server and the statements will be placed in the Shared Folder.
The functionality allows to rerun the bank statement file, any statements that have already been loaded into COINS will be skipped during the reprocessing.
Configuration/Setup of Functionality
Cash Book – Extended Functionality – BAI-2 Transaction Types
BAI-1 transaction types are to be loaded onto COINS. COINS technical team will load the transaction types.
Unique Key – Same as BAI-2 Transaction Types
Description – Description of transaction type
BAI-2 Transaction Types - Transaction Types
Statement Transaction Type – Can be used this statement transaction for auto bank reconciliation.
Debit – Debit/Credit transaction line
2. Bank Accounts (Statement Type)
The statement types on bank accounts should be defaulted to X-Generic for the bank statement loading process.
Note: The bank account name should be unique on the bank account setup for this functionality.
See details below:
Bank | Bank Name | Currency | Account Name | BSB | Account | GL Account | Bank Charges |
01 | NAB – Trading Account | AUD | Demo Pty Ltd – Trading | xxxxxx | xxxxxxxxx | 10.6X01 | 90.2690 |
02 | NAB – Savings Account | AUD | Demo Pty Ltd – Savings | xxxxxx | xxxxxxxxx | 10.6X02 | 90.2690 |
|
|
|
|
|
|
|
|
3. Shared Folders (System Module/System Setup)
Two shared folders to be created:
Bank Statements – Ready to Process (cbstat_ready) – Bank statements will be downloaded from a bank’s secure file transfer serve and will be placed in this folder. Also, if the bank statements file needs to be reprocessed, it can be moved from Bank Statements – Processed to Bank Statements – Ready to Process.
Bank Statements – Processed (cbstat_done) – Once the statement file has been processed, it will be moved onto the Bank Statements – Processed shared folder.
4. Global Standard Text
The Global Standard Text token needs to be updated CB-BANKINT-LOGIN with the value: [email protected]
Process
Get Statements From - Bank
The process will download bank statements from bank’s secure file transfer server, and the statements will be placed in the Bank Statements – Ready Shared folder.
Once the statement file has been processed, it will be moved onto the Bank Statements – Processed shared folder. This process will load bank statements files in the BAT-2 format, containing multiple bank accounts for multiple COINS companies.
Process BAI-2 Bank Statement Load (From Bank)
The summary will be reported on the report log file. (Such as statements loaded successfully; accounts with no transactions; statements failed due to processing errors).
Review the BAI-2 Bank Statement Load Report
If new files are not available in bank’s secure file transfer server, the report log will have the below details:
Schedule the Bank Statement Load Process
The process can be scheduled on a daily/weekly basis and email will be notified to the respective person.
Note: The opening bank statement balance for bank accounts must be entered in COINS (Bank Statements) before starting the integration process.
2. Get Statements From – Process Existing Files Only
To reprocess the statement file, it needs to be moved back into the Bank Statements – Ready shared folder and then rerun ‘Process existing files only’. Any statements that have already been loaded into COINS will be skipped during re-processing.
Note: If the statement must be loaded into COINS, then first delete the statement load within the Cash Book module.
To process the existing file – Transfer the files from Bank Statements – Processed – Folder to Bank Statements – Ready folder.
Since the statement for 20/03/24 is already loaded into COINS, the COINS will skip those statement files. Refer to the below report log.