Set up reconciliation
This page is for administrators and consultants who set up reconciliation in Banking. You create reconciliation settings, connect them to bank accounts, and set up mapping of bank categories to G/L accounts, currency difference posting and the credit card settings.
Purpose
After the setup, an accountant can import entries from the bank in RdN Reconcile, match them automatically or by hand, move bank entries to a payment journal and post currency differences. Each bank account uses the settings connected to it, so you can have different rules for different accounts.
Prerequisites
- A bank service and a bank user are set up.
- The bank account is connected to the bank.
- A number series for reconciliation exists, for example starting at AF000001.
- If you post currency differences: a journal template and batch exist, and the realized gains and losses accounts are filled in on the currencies.
Permissions
You need permission to change RdN Reconcile Setup, bank accounts and number series.
Steps
You can use RdN Bank Recon. Setup Assist, which walks you through the general settings and automatic reconciliation, or open RdN Reconcile Setup directly. Every field is explained in Reconciliation setup.

Create the settings
- Search for RdN Reconcile Setup List and choose Assisted Setup, or create a new line and open it.
- Enter a Code, for example GENERAL.
- Select a number series in Reconciliation Nos.. Each match gets a number from it in Reconciliation ID.
- Keep Safe Statement Import turned on. Only confirmed entries are then imported from the bank.
- Select a bank account in Default Bank Account if RdN Reconcile should open with it.

Automatic reconciliation
- Enter in Max Date Diff. in Rec. how many days a bank entry and an entry in Business Central may be apart, for example 3D. The default is 3D, which covers a payment on a Friday that the bank posts on Monday.
- Keep Allow Unsafe Suggestions turned on if the system should suggest a match even when more than one bank entry is possible. Turn it off if it should only match when exactly one entry fits.
- Turn on One Matchnumber per Run if all matches in one run should get the same Reconciliation ID.
- Turn on Use New Reconcile Method if automatic matching should use the faster method.

Bank entries moved to a journal
These settings apply when bank entries are moved to a payment journal from RdN Reconcile.
- Turn on One Doc. No. per Journal if all lines should get the same document number.
- Turn on Skip Auto Apply Cust Ledg Entry if the system shouldn't apply a customer payment to an open entry automatically.
- Turn on Empty Amount If Applies To Doc Is Missing if lines with no document to apply to should come in with an empty amount.
Bank categories to G/L accounts
The bank marks every entry with a category code. With a mapping, bank charges, for example, go straight to the right G/L account when the entries are moved to a payment journal.
- Turn on Route Bank Acc. lines to G/L Accounts.
- Choose the number in Recon GL Mappings. The page RdN Recon G/L Mapping opens.
- Enter a Category Code and a GL Account for each category. Only fill in Payor ID if the mapping applies to entries from one payer only.

Currency difference
- Select a template in Currency Difference General Journal Template.
- Select a batch in Currency Difference General Journal Batch No..
The currency difference is posted to the realized gains or losses account on the currency.

Credit cards
- Turn on Import Credit Card Attachments if receipts that cardholders have registered in the bank should be imported.
- Select number series in Purchase Invoice Nos. and Posted Purchase Invoice Nos. if purchase invoices from card transactions should get other number series than other purchase invoices.
- Register the API key for the bank:
- Arion banki: choose Set Arion API Key and enter the key that Rue de Net provides.
- Landsbankinn: choose Set LI API Key and enter the key. You create a system access and get the key in the company's online bank or from Landsbankinn.
- Íslandsbanki: no API key. The bank user signs in with electronic ID on the page Your RdN Bank Users.
- Check that Arion API Key Status or LI API Key Status shows Configured.
Never put API keys in descriptions, comments or documents.

This example shows the settings before configuration: attachment import is off and both API key statuses are Not configured. It does not show a connection ready to import receipts.
Connect the settings to a bank account
- Open the bank account card.
- Select the settings in the field RdN Reconciliation Setup.
- Repeat for every bank account you reconcile, including the bank accounts of credit cards.
Verify
- Open RdN Reconcile, select the bank account and choose Import Statements. Entries from the bank show in Bank Statement Lines.
- Choose Automatic Match and check that the system shows the number of matched entries.
- If Reconcile setup not found for bank account %1 shows, the field RdN Reconciliation Setup is empty on the bank account. See Help.