This topic includes information about CODA, which is a report format used in the Belgian electronic banking system.
For Belgian bank statement imports, you'll use the CODA file format. This feature lets you verify company bank account opening and ending balances, and reconcile imported transactions based on reconciliation rules.
Import transactions from a bank statement
To import a bank statement file for a bank account, complete the following steps. Note: Before you import a bank statement file, you must have already completed the following:
- Import the CODA configurations from Lifecycle Services (LCS). For more information, see Download Electronic reporting configurations from Lifecycle Services.
- Select the imported CODA configuration on the CODA parameters page.
- Go to the Bank accounts page.
- Click Reconcile > CODA.
- Click CODA > Import from file, and then select the path to the bank statement file.
After you import transactions, you can do the following on the Bank statement page.
- Verify the opening and ending balances.
- View the imported transactions as a bank statement report that you can print.
- View imported transactions with additional lines, such as lines with an Account type of "None". Click CODA > Details.
Process imported bank statement transactions
Complete the following steps to process the bank statement transactions.
- Process details lines (CODA > Process detail lines). Start automatic matching based on CODA definitions. These rules determine which ledger, customer, or vendor account should be used for this transaction. Comparison is based on which Transaction group code, Transaction code, and Transaction category code are specified in CODA file for each transaction.
- Transactions with a customer and vendor account type can be matched with the invoices. If necessary, imported transactions can be manually changed at any time after processing, before transferring to the ledger.
- If there are any transactions with errors (generally, if there are no rules set up), these can be referred to the special ledger account, specified on the CODA parameters **page (CODA** > Clear errors).
- After all transactions in the bank statement are settled, they are ready to be transferred to the general ledger journal (CODA >Transfer to ledger). Journal settings should be specified for the bank account. Journals can be opened on the Bank accounts **page for the selected record by clicking **Set up > CODA journal.
After processing bank statement transactions is complete, a new general ledger journal is created and ready for posting.