How to reconcile your bank account
The Continia Statement Intelligence module for Continia Payment Management allows you to reconcile your bank accounts automatically.
Once a bank account statement is imported in Payment Management, Statement Intelligence will try to find the corresponding bank entries in Dynamics NAV or Business Central on-premises. If the bank entry is posted, it is reconciled automatically. If the bank entry is not posted, a proposal for posting the bank entry is automatically created, for example, payments, interest, fees, and more. If there are several reconciliation options, proposals for reconciliation are created, which must be approved by you.
How to reconcile your bank account
- Select the icon or press Ctrl-F3, enter Bank Accounts, and select the related link.
- To access the Bank Account Card, you must either select the New action if you want to create a new bank account, or select an existing bank account and select the Edit action.
- On the bank account card, select the action Reconciliation (PM). This opens the window Bank Account Reconciliation Payment Management window.
- Select the action Import Account Statement. Read more about what options you have at the bottom of this page, where the function Import Account Statements is described in more detail. Once you have selected the correct account statement it is imported, after which the function Reconcile Account Statement starts automatically. You can read more about what the feature does at the bottom of the page.
- Now reconcile or apply the individual lines. Use the features described below to apply and reconcile your bank records. If there are several reconciliation proposals, you should select the function Choose Reconciliation.
- Below you will find descriptions of the individual fields and functions in the window, and what consequences they have for the use of Payment Management.
- When all bank entries have been applied and reconciled, you must post the reconciliation with the function Post Account Reconciliation or Post and Print.
- Select OK to finish the reconciliation.
General
Bank Acc. Recon. Line Payment Management
Actions on lines
At the top of the bank entry lines window, you will find the following functions that are specific to Payment Management:
Lower part of the window
Action on the window
At the top of the window, you will find the following features that are specific to Payment Management:
How the reconciliation works
Each account statement line is reviewed independently and if there are several proposals, it will appear in the field Number of Recon. Suggestions, after which you must select the correct line.
First, try to find bank records that match the bank statement lines for direct reconciliation. Statement Intelligence searches for posted payment entries from the Sender Reference field.
The field Sender Reference will, for all payments made via Payment Management, be optimally filled in with the unique UPR number. Filling in the field is defined as described via the Sender Reference code on the bank account card, under Payment.
The transaction number of the payment entry found will then be used to find the associated bank entry, which will then be marked for reconciliation.
Attempts are then made to find closed accounts receivable that correspond to the information in the account statement line; this is done on the basis of Customer No., Payment ID or Document No. - and of course the amount and date. If there is a closed customer entry, and the corresponding bank record is found, the line is marked for reconciliation.
After this, an attempt is made to find a reconciliation proposal by searching directly for bank entries with the amount and date as the search key.
If a bank entry has still not been found for the posting line, the open customer entries will be searched again with Customer No., Payment ID or Document No. as search key - this is done in order to find customer entries that has been paid without it being registered in Dynamics NAV or Business Central on-premises.
For open accounts receivable entries found from the last way, Statement Intelligence simultaneously creates a proposal to insert the payments in the cash receipt journal, ready to post. After posting, the associated bank entry will be reconciled on the account statement line.
Eventually, all non-reconciled account statement lines will be scanned to see if there are any that match the reconciliation rules defined on the bank account. If there is such a rule, posting proposals are created for expense or income posting lines in the cash receipt journal.
When the cash receipt journal is posted, the corresponding payment lines will be created as payment entries, and the associated bank entry will be able to be reconciled with the account statement.
Lines that have not yet been reconciled correctly must be handled manually via the button Reconcile Bank Entries.