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.
How to set up account reconciliation on 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.
Posting
| Field | Description |
|---|---|
| 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. |
| 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. |
| Diff before Auto Suggestion | Specifies the amount that an entry may differ in the automatic account reconciliation for an suggestion to be created automatically. |
| 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. |
Transfer
| Field | Description |
|---|---|
| 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. |
Note
Remember to close old payment entries before using the Statement Intelligence module. See how in the section Starting bank account reconciliation