This guide covers the Reconciliation View in Accounting. You can find the Reconciliation View by navigating through Financial Management > Accounting > Accounting Reconciliation.
CONTENTS
- Using the Reconciliation View
- Finding and Correcting Reconciliation Differences
- Tips for Using the Reconciliation View
Using the Reconciliation View
In the Reconciliation View, ledgers and accounting are compared for potential reconciliation differences. You can monitor during a desired period if there are discrepancies between the sales and purchase ledgers and the accounting 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 accounting 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 accounting 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 > Accounting > Accounting 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 accounting 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.
Tips for Using the Reconciliation View
Detailed instructions for reconciliation and finding differences can be found here: Reconciliation
- Applying a credit invoice 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 invoices again, ensure that both payment/receipt entries are definitely removed. Detailed instructions here: Credit Invoices and Creating and Handling a Credit Invoice (incl. reversing application)
Keywords: Reconciliation View, accounting reconciliation, reconciliation differences
Did you find it helpful? Yes No
Send feedback