Below is a user guide how to setup automatic reconciliation of bank accounts. This is only possible for your Treasury accounts
where you have all transactions for the bank in in Treasury system. Note if some rtansactions are missing such as bank charges, fees, interests this can be set up to be imported automatically.
In order to do an automatic reconciliation of bank accounts imported from the bank statements the following setting must be ticked in Integrations > Bank account statement import > tab 'Settings'.
Tick "Run Reconciliation Automatch", and choose the begin date for your auto- match.
This will allow for a automatic match for
- 1:1 match
- one to many match or many to one match. No support for many to many match yet.
- 1 unit in rounding differance
comparing transactions in TS to imported entries from the bank.
First step is to configure which bank accounts to be reconciled.
In Back Office > Bank Account Reconciliation, click on "Configure"-button.
A list of all accounts in TS will be presented. Tick all accounts you want to do an automatic reconciliation - by ticking the "Reconciliation Active" check-box. Set a date from when the system should reconcile by setting a date in "Reconciliation Begin Date".
The Accounts you have selected for reconciliation will now appear in the list to the left. .
In Settings / System settings / System reconciliation
You need to enter a start date from when you want to start the automatic reconciliation.
The date in system settings will be suggested as begin date but it s also possible to change this in the reconciliation view.
The Widget will also use the same selection and show you number of matched/unmatched transactions.
Bank account Reconciliation
Manually matching entries.
On the left side all processed payments in Treasury systems will be shown and on the right side the transaction imported from the bank are shown.
Unmatched Payments (Treasury systems side)
Treasury Systems side. Payments that have not found a match from imported statements. Note; only transactions that are created as actual payments in TS will be shown here and automatched.
Unmatched Entries (Banks side)
Banks side. Entries imported through the statements that are not yet matched automatically will show up here. Also entries that do not have any Entry transaction rules will show up here.
If you have 2 deals with the same amount the same day on both sides a suggested match of the 2 transactions will be shown. You can either accept or revert and change the suggested match.
Here all entries imported from the bank that found a match will be shown.
Automatic matching are done on following parameters;
- Value Date
- Bank account
Deviating entries can be matched manually in this view e.g. different payment date.