Setting up bank account reconciliation on bank accounts
Before you can use Continia Statement Intelligence, each of your bank accounts must be configured so the necessary information is available in order for Statement Intelligence to do the reconciliation automatically, as well as automatic creation of expense entries such as accrued fees and interest.
All the necessary information is found at the the bank account card. If you have not already created your bank accounts, you can read more in the section Create a bank account. If you have created your bank accounts, just follow the instructions below, which explain which fields you need to fill out on the bank account card. Remember to set up all your bank accounts.
- Select the icon or press Ctrl-F3, enter Bank Accounts, and then select the related link.
- To get to the Bank Account Card, you must either select the action New, if you want to create a new bank account, or select an existing bank account and select the action Edit.
- This opens the Bank Account Card.
- Below you will find descriptions of the fields and functions that are important in relation to setting up a bank account for Statement Intelligence. Other fields on the bank account card are not described here but can be found in section Create a bank account.
- Select the OK to complete the setup.
|Cash Rcpt. Jnl. Temp. Name||Specifies the name of the cash receipt journal type to use for the cash receipt journal, selected below.|
|Cash Rcpt. Jnl. Batch Name||Specifies the name of the cash receipt journal used for importing FIK / GIK payments. |
When importing the bank account reconciliation automatically, FIK/GIK payments are transferred to this journal for closure. Read more on How to reconcile your bank account.
|Gen. Jnl. Template Name||Specifies the name of the journal general journal type, to use for the general journal, selected below.|
|Gen. Jnl. Batch Name||Specifies the name of the general journal to be used when a bank ledger entry does not have an open entry for closure. In this case a posting suggestion must be created in the general journal. |
Entries could be coverings, interests and fees, etc. The entries are transferred to a general ledger journal, ready for posting, and reconciliation in the bank account reconciliation. Read more under How to reconcile your bank account.
|Diff before Auto Suggestion||Specifies the amount that an entry may differ in the automatic account reconciliation for an suggestion to be created automatically. |
An entry will not automatically be reconciled if the entry on the bank account statement is 100.00, and your customer invoice 100.30 - a difference will appear instead. This difference must be settled manually
If you specify a deviation of e.g. 5.00, the above posting will be included in the reconciliation automatically, however, the difference must be posted manually.
|Last Statement No.||Specifies the internal account statement number in your Dynamics NAV or Business Central on-premises. If you have not imported a bank account statements before, enter 0.|
|Sender Ref.-def.Code||When you send a payment an entry is made in the bank with an entry text. When you import an electronic account statement from the bank, the entry's text is used to find the balance entry e.g. the vendor payment that you have paid. With Payment Management it is possible to design the posting text yourself by filling in the field Sender reference code. |
We recommend that you always enter a sender reference on the bank account. If you import the bank account statement electronically, you should choose a Sender Ref. Def. Code which includes a "UPR number", e.g. "SEND REF2" (see description field when selecting Sender Ref Def Code).
If the sender reference contains a UPR number, Payment Management will automatically generate a posting text on the payment, containing a unique reference number. The payment entry in your Dynamics NAV or Business Central on-premises will also have the unique UPR number registered, so we can find our way back to the record. The bank then receives the payment file and uses the posting text as posting text in their internal systems.
When you later import the electronic account statement from the bank with the posting text, the account statement line can now be matched with your payment entry in Dynamics NAV or Business Central on-premises.
Sender reference on the bank account always overwrites the sender reference on the vendor. It is possible to make different kinds of automatic sender references. You can read more on how to build these in the section Define payment definitions.
If the sender reference is not filled in on the bank account, Vendor name + UPR number will be used as standard posting text.
Remember to close old payment entries before using the Statement Intelligence module. See how in the section Starting bank account reconciliation