This guide covers the reconciliation view in bookkeeping. Open the view by selecting Financial management > Bookkeeping > Bookkeeping reconciliation.

CONTENTS

Using the reconciliation view

In the reconciliation view, you reconcile ledgers and bookkeeping and check for possible reconciliation differences. For the selected period, you can monitor whether there are differences between the balances of the sales and accounts payable ledgers and bookkeeping. Monitor bank account reconciliation directly in the bank statement view by selecting Financial management > Bank statements.

Take advantage of the renewed Netvisor reconciliation view. Use the improved performance, layout and faster page actions. View deviating vouchers and payments under their own button. Detect a difference from the attention mark. Open bookkeeping account transactions by drilling down directly from the amount.


When using the reconciliation view for the first time, proceed as follows:

  • Select the period for which you want to examine balances. Accept the default current month period offered or change the review period as needed.

Use a shorter period if needed:

  • If there are reconciliation differences in a month, search the reconciliation view day by day and find out on which day or days the difference occurs.
  • Set the same date as both the start and end date when you want to search only the reconciliation differences for a single day.

In the reconciliation view, pay attention to changes occurring during the month:

  • Examine the monthly change in the reconciliation view.
  • Note that the reconciliation view shows only one accounts receivable and one accounts payable account. These accounts are determined based on the default accounts selected in bookkeeping settings.
  • If you use accounts other than the system default accounts (Accounts receivable and Accounts payable), monitor these accounts manually, as the reconciliation view uses only the default accounts. For example, monitor intercompany debts and receivables manually.

Finding and correcting reconciliation differences

  1. Open the reconciliation view by selecting: Financial management > Bookkeeping > Bookkeeping reconciliation.
  2. Enter in the reconciliation view search field the period for which you want to monitor reconciliation.
    • First find the oldest month in which a reconciliation difference has occurred, as reconciliation differences accumulate in later periods.
    • Check the reconciliation difference for the month in the Change column on the Difference row in the reconciliation view.
  3. Narrow the monthly view to a daily view once you have found the first differing month.
    • For example, if the oldest differing month is June, search the reconciliation view for the range 1.6.–1.6.
    • Use the buttons at the top of the reconciliation view << previous day and next day >> and move day by day to find the first differing date.
    • Check the daily reconciliation difference in the column for that day on the Difference row.
  4. Use the hints provided by the reconciliation view about possible causes of the difference.
    • Drill down from the blue links directly to the account-specific entries in bookkeeping for the selected review period.
    • If necessary, open the ledger invoice report for more detailed inspection.
  5. Correct the reconciliation differences:
    • Correct reconciliation differences in the period and for the transactions that cause the difference.
    • Open a closed financial period or VAT-locked period before correction if the transaction to be corrected belongs to such a period.

Sales prepayments and the reconciliation view

Sales prepayments can cause temporary reconciliation differences if you allocate them to an invoice dated later using the original date of the prepayment.

  • If a prepayment is received on 2.9.2025 and the invoice date is 5.10.2025, the reconciliation view will show a difference for the period 2.9.–5.10.2025.

Handle prepayments as follows so that they do not interfere with reconciliation:

  • Record the prepayment in bookkeeping, for example, to the account for received advances on the original date of the prepayment.
  • Create a new payment method for this bookkeeping account.
  • When you import or create the invoice in the system, record a manual payment on the invoice and use the payment method you created.
  • Date the payment on the same day as the invoice so that the prepayment is in bookkeeping for the time between the prepayment and invoice dates and does not cause reconciliation differences.

Use internal transaction tracking for the prepayments account:

  • Link the two bookkeeping entries related to the prepayment to each other using transaction tracking.
  • If you allocate prepayments to the sales invoice using the original date of the prepayment, keep track of these manually, for example in Excel.

Check whether prepayments have been recorded on sales invoices for a specific month as follows:

  • Open the Sales invoice list.
  • Select Extended search.
  • Enter the desired month as search criteria, for example to check the situation for September.


Tips for using the reconciliation view

Read more detailed instructions for reconciliation and finding differences here: Reconciliation

  • Note that allocating a credit note can cause so-called false hits that do not require action. These cannot be excluded from listings, because the comparison and inspection logic is based on dates and amounts, and the system cannot distinguish credit notes and other exceptional situations.

Frequently asked questions

Where can I find the bookkeeping reconciliation view?

Open the reconciliation view by selecting Financial management > Bookkeeping > Bookkeeping reconciliation.

How do I search for and narrow reconciliation differences within a month?

First search for the oldest month with a difference, and then narrow the view to a daily level by setting the same date as both the start and end date. Move day by day with the << previous day and next day >> buttons and check the Difference row.

Why does the reconciliation view show only one accounts receivable and one accounts payable account?

The reconciliation view uses the default accounts selected in bookkeeping settings. If you use other accounts, such as intercompany debts and receivables, monitor them manually.

How do sales prepayments affect the reconciliation view?

Prepayments can cause temporary reconciliation differences if you allocate them to an invoice using the original date of the prepayment. Avoid this by recording the prepayment to the account for received advances and allocating it to the invoice using the invoice date.

How do I check whether prepayments have been recorded on sales invoices in a specific month?

Open the Sales invoice list, select Extended search and enter the search criteria for the month you want to review, for example for September.

What should I do if allocating credit notes causes false hits in reconciliation?

Note that some false hits do not require action, because the system cannot distinguish credit notes from other exceptional situations. If you have released and allocated credit notes again, make sure that all payment and receipt entries have been removed according to the instructions "Credit notes" and "Creating and handling a credit note (incl. releasing allocation)".

Keywords: Reconciliation view, bookkeeping reconciliation, reconciliation differences




This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.