Integrity check: finding and scheduling financial inconsistencies
How to run the financial integrity checks, get from a finding to the place of the fix, and set which check runs automatically when.
The integrity check looks for contradictions in the financial data: for example a settlement pointing to a deleted document, a bank import row that differs from the statement, or a duplicate invoice number. The check changes nothing; every finding has a button that takes you to the place of the fix.
Running a check
- Open Reports → Integrity check.
- Choose Company group and Client company and a check in Check; left empty, every active check runs.
- Click Run check (play icon).
- Findings appear row by row. Use the row button to open the affected item: Open the transaction, Open the import row or Open the document; the button only appears if you have access to that list.
The checks
| Check | Area |
|---|---|
| Settlement of a missing/deleted document | bank and cash document |
| Transaction line of a missing/deleted document | bank and cash document |
| Settled recovery fee, base paid on time | bank and cash document |
| Advance invoices: fulfilment date and issue deadline | bank and cash document |
| Booked import row with different balance | bank import |
| Unbooked import row with transactions | bank import |
| Periodic settlement invoices: dates (VAT Act 58. §) | invoice |
| Open cash invoices | invoice |
| Invoices without customer or supplier | invoice |
| Advance – final invoice pairs incomplete | invoice |
| Invoice tax number differs from the partner master | invoice |
| Storno invoice differs from its base invoice | invoice |
| Invoices with the technical partner (by invoice number) | invoice |
| Duplicate customer invoice number at a client | invoice |
| Invoice recorded for another client than where its document is stored | invoice |
Setting and scheduling checks
- Click the gear button on the check page (Integrity check settings), or open Reports → Integrity check settings.
- Each row shows the check's schedule and last runs.
- Click the Edit icon in a check's row. Set Status (whether it appears in the selector), Order in the selector, Automatic run, Frequency, Time, Day of the week and Day of the month, then save. Next scheduled run shows the next time.
- You can also run a check at once with the row's Run now icon; Open the results takes you to the result.
Checks cannot be created or deleted, only switched on and off. The automatic run appears among the scheduled tasks. If a scheduled run finds no inconsistency, no result e-mail is sent.
Example
Sample Ltd.'s accountant runs "Duplicate customer invoice number at a client" every week. A finding shows two outgoing invoices with the same number; Open the document takes her to one of them to correct it. To avoid running it by hand, she schedules the check for Monday mornings.