Reconcile balance-sheet accounts every month
Here you prove each balance-sheet account's balance at month end.
How to
- Open Account reconciliations and pick the month next to the title.
- Click an account « To justify » and choose its source.
- Fill in the open items or confirm the document amount, until the difference is zero.
- Click « Mark justified »; the reviewer clicks « Approve review ».
- At month end, « Reconciliation pack (ZIP) » gathers everything.
Learn more
Account reconciliation proves, account by account, that the balance-sheet balance matches something real. The balance comes from the posted ledger, it is never typed in. The justified balance comes from a source, and the difference must be zero (or below the book's tolerance, with an explanation).
Which accounts
Each class 1 to 5 account with a balance or a movement in the month. In « Settings », an administrator excludes an account or sets its risk: high or normal (monthly), low (quarterly), with a default owner and reviewer.
Sources of a justified balance
Subledger (automatic): the aged balance for 411 and 401, the fixed asset register for 2x and 28x, the bank statement balance for 52x (a reconciliation dated in the month's last week). Open items list: typed in or imported from a CSV or Excel file (columns Label, Amount, Date). Supporting document: a PDF or photo whose total is read and suggested; you confirm the amount.
Auto-certification
An account is auto-certified, with the reason shown, when its balance is zero with no movement, when it has not moved since the last reviewed month, or when the subledger ties to the unit. « Always require a review », in the settings, turns it off.
Rolling open items forward
Open items not cleared carry over to the next month with their age. Beyond 90 days they are flagged in red. « Cleared » removes an item settled this month: it no longer counts and will not carry over.
The reconciliation pack
« Account reconciliation (PDF) » prints one account: balance, source, items, attachments and sign-offs. « Reconciliation pack (ZIP) » gathers the month: a summary, one PDF per account and the attachments. That is what the statutory auditor or the firm's reviewer asks for.
Frequently asked questions
The statement balance comes from a bank reconciliation dated in the month's last week (Bank). Without one, justify the account with a document: the month-end statement.