Reconciliation
How to get started and collect lines for reconciliation
To start the reconciliation module, click on the "Reconciliation" tile from the Role Center (AutoBank is located in the Role Center of "Business Manager"):
The number shown in this tile is the number of lines that are not reconciled. In order for some lines to appear in this tile, you must first have imported the lines. You can read more about the procedure in this document.
When you have opened the reconciliation module, set the filter for which bank account you are going to reconcile and for which period; a day, a week or a month:
To browse between periods, you can find "Previous Set" and "Next Set" under "Actions":
In this example, we want to reconcile the entire month of September 2022. To retrieve all unreconciled lines for the selected period, click on "New" and "Get BankAccountStatement":
--- Picture ---
Bank reconciliation lines will appear in the left column, and accounting entries will appear in the right column. Please note that accounting entries are entries entered via bank 1920, and cannot be posted directly to financial account 1920.
All deposits and withdrawals made via AutoBank receive an archive ID which is stored in BC. As the first step in reconciling, we use "auto-match". When you use "auto-match", the system will find matches on references and match on amount and date of reconciling these lines automatically.
Select “Process” and “AutoMatch”:
--- Picture ---
After the system has finished the job, you will most likely be left with some entries from either the bank or the accounts that must be reconciled manually.
To reconcile lines manually, click on the text or on the amount on the line, when the line is marked with a line below it you can mark it and it will turn green, see the image below. Please make sure to always start marking on the right side. The system will then try to sum lines to the right automatically, whether it is one or more lines.
--- Picture ---
Mark the text that you want to reconcile in the image on the right-hand side
To reconcile more than one line, please feel free to mark several lines at the same time
Mark the matching line on the left-hand side
Mark the matching line on the left-hand side
In the summary fields, please make sure that you have zero deviations (if you have deviations, you will find information below on how to easily post it directly from this window)
Click “Match” on the line or on the menu
How to post bank charges etc. that have not already been posted
If you have fixed types of fees, small deviations in øre etc., you can set up a direct accounting for these under "Actions" - "Setup post as":
--- Picture ---
SetupCode: Description of what is to be posted
Divergence Account No.: Look up the desired financial account, and please make sure that you have allowed direct posting to the account
Dimensions: If you wish, you can set a fixed dimension. The field is not required.
Close the window when you're done, you can always go back and add more accounts if needed.
Post as…
The "Post as..." button enables you to post a marked bank item line that is not already posted in the accounting:
--- Picture ---
Select the desired line and check the sum in the "Bank Ledgers" field: this is the amount that will be posted.
Click on “Post as…” in the top menu.
--- Picture ---
Select the appropriate posting and click OK.
The line will now be reconciled automatically against each other and disappear from the window.
Post deviation as…
If you have a deviation after marking an entry from the bank and one from the accounting, please click the button "Post deviation as...". See the field “Deviation” You will find the amount that will be posted in the field “Deviation”:
--- Picture ---
In this scenario, 205 will be posted against the selected posting.
After the deviation are posted, a new line will appear in accounting entries. The line will also be marked green which makes it possible to press "Reconcile" directly:
--- Picture ---
The attachment will have the same description as you have set up in the setup for "Setup as", in this case we chose to post the deviation as "Bank fee" as you can see from the text.
If you want to correct an attachment that has been posted manually, you can do this via "Reverse transaction":
--- Picture ---
Select the line you want to reverse, select "Accounting entries" and "Reverse transaction".
The lines will be reconciled against each other and closed from the window.
Explanation - other menu buttons
New - Get Bank Account Statement, retrieves the latest statements for the selected period, use this if you have made entries after you retrieved statements the first time
New - Bank Balance By Date, retrieves balance from the bank per weekday. It happens during some transition periods that the balance may be incorrect, it is possible to correct the balance directly here if needed. You can also delete all the lines to collect the balance again.
Process - Previous and Next Set, use these buttons to scroll back and forth between periods
Process - AutoMatch, automatically reconciles lines that match on archive ref, amount and date
Process - Post as..., post amounts automatically from bank entries via predefined accounts (set up under actions "Setup post as")
Process - Transfer To Journal, add a line from the bank to journal to post it against e.g. vendor, is used when you cannot use "Post as..." or "Post deviation as..."
Process - Post deviation as..., automatically posts the deviation between a marked amount from bank entries and accounting entries via predefined accounts (set up under actions "Setup post as").
Process - Deviation to Journal, transfers the deviation between bank entry and accounting entries to journal
Reports - Print, create a settlement report for the period you want, can be printed as a PDF
Reports - Reconciled Entries, shows entries that have already been reconciled, here you can also choose to reopen lines that you want to reconcile a second time. The image shows all reconciled entries for the period you are in.
Cancel Line - cancel a line that you have reconciled
Cancel All Lines - cancel the entire period you are in
--- Picture ---
Reports - Show Only Period, shows only unreconciled entries in the selected period
Reports - Show to period, shows unreconciled entries up to and including the period you are in.