This guide covers the Reconciliation View in Bookkeeping. You can find the Reconciliation View by navigating through Financial Management > Bookkeeping > Bookkeeping Reconciliation.
CONTENTS
- Using the Reconciliation View
- Finding and Correcting Reconciliation Differences
- Sales Prepayments and the Reconciliation View
- Tips for Using the Reconciliation View
Using the Reconciliation View
In the Reconciliation View, ledgers and bookkeeping are compared for potential reconciliation differences. You can monitor during a desired period if there are discrepancies between the sales and accounts payable ledgers and the bookkeeping balances. It is recommended to monitor bank account reconciliations directly in the bank statement view (Financial Management > Bank Statements.)
The Netvisor Reconciliation View has been updated. We have improved the performance and appearance of the view and sped up the page's functionality. Deviating vouchers and transactions have been moved under their own button and are now more clearly viewable. The difference is highlighted with an attention mark. You can directly examine bookkeeping transactions by drilling down from the sum.
When first entering the Reconciliation View, you select the period for which you want to examine balances. By default, the system offers the current month as an option, but the review period can be changed.
You can also select a shorter time period. If there are reconciliation differences in a month, it is advisable to search day by day to find out on which day or days the difference occurs. This greatly facilitates finding the differences. In this case, the start and end date are set to the same date, so only the reconciliation differences for that day are searched.
In the Reconciliation View for the month, attention is always paid to the change occurring in the month. The Reconciliation View shows only one accounts receivable and one accounts payable account. The account appears in the Reconciliation View based on which account is selected as the default account in the bookkeeping settings. If you use accounts other than the system's default accounts (Accounts Receivable and Accounts Payable), note that the Reconciliation View only uses default accounts, so for example, intercompany debts and receivables must be monitored manually.
Finding and Correcting Reconciliation Differences
1. Navigate to the Reconciliation View via the following path: Financial Management > Bookkeeping > Bookkeeping Reconciliation
2. Enter the period you want to monitor reconciliation for in the search field of the Reconciliation View. If a reconciliation difference has occurred, first find the oldest month with a difference, as these reconciliation differences accumulate in later periods. The month's reconciliation difference is visible in the Change column on the Difference row in the Reconciliation View.
3. Once the first differing month is found, you can narrow the month's view to a daily view on the Reconciliation View search page. For example, if the oldest differing month is June, search the Reconciliation View daily from 1.6.-1.6. After this, buttons << previous day and next day >> appear at the top of the Reconciliation View, allowing you to search day by day for the first differing date. The daily reconciliation difference is visible in the column for that day on the Difference row.
4. The Reconciliation View can provide hints about possible causes of the difference. Additionally, you can drill down from the blue links directly to the account-specific entries in the bookkeeping for the selected review period or, for example, to the ledger invoice report.
5. It is recommended to correct reconciliation differences for the specific period and events causing the difference. If the event to be corrected belongs to a closed fiscal year or a VAT-locked period, these must be open before correction.
Sales Prepayments and the Reconciliation View
Sales prepayments can cause temporary reconciliation differences if they are recorded on an invoice dated later with their original date. For example, if a prepayment is received on 2.9.2025 and the invoice date is 5.10.2025, the Reconciliation View will show a difference between 2.9. - 5.10.2025. A good practice is to record the prepayment in bookkeeping, for example, to the account for received advances, on its original date. It is advisable to create a new payment method for this bookkeeping account. When the invoice is then brought or created in the system, a manual payment is recorded on the invoice using the previously created payment method and dated the same day as the invoice. This way, the prepayment is in bookkeeping for the time between its and the invoice's date, and does not interfere with reconciliation in any way. In these entries, it is possible to use internal transaction tracking for the account of prepayments, which allows linking the two bookkeeping entries related to this example. However, if prepayments are allocated to the sales invoice on their original date, it is advisable to keep track of them manually, for example, in Excel.
You can conveniently check if prepayments have been recorded on sales invoices for a specific month. Open the Sales Invoice List and from there the Extended Search, then you can check, for example, the situation for September with these search criteria:
Tips for Using the Reconciliation View
Detailed instructions for reconciliation and finding differences can be found here: Reconciliation
- Applying a credit note can cause so-called false hits that do not require action. Unfortunately, these cannot be excluded from listings because the comparison and inspection logic is made in a certain way. The system performs basic checks on dates and amounts in the background and cannot distinguish credits and other exceptional situations.
- If you have had to reverse and apply credit notes again, ensure that both payment/receipt entries are definitely removed. Detailed instructions here: Credit Notes and Creating and Handling a Credit Note (incl. reversing application)
Keywords: Reconciliation View, bookkeeping reconciliation, reconciliation differences
Did you find it helpful? Yes No
Send feedback