Accountant Reconciliation – do the numbers match?
On the Accountant Reconciliation page you compare your accountant's monthly ledger extract with your own books. For each account the system shows what matches, where there is a difference, and what appears on one side only. After approving the reconciliation you can close the month.
Your accountant keeps the official books in their own system. This page helps you find out whether their figures differ from yours.
How it works
- Select the year and month.
- Drop your accountant's monthly ledger extract (Excel) on the upload area, or click Upload Accountant Extract.
- For each account, the system compares the extract's monthly debit and credit turnover with the turnover calculated from your own confirmed bookings.
If your accountant needs a sample, download it with Download Excel template (for accountant).
The result
Summary cards at the top show the number of accounts, matches, differences and missing items. You can filter the list:
- Matching – turnover is the same on both sides. Nothing to do.
- Difference – the account appears on both sides but the turnover differs. Typical causes are rounding, a different date, or an item present on one side only.
- Accountant only – your accountant has turnover on this account, you don't. For example, an invoice wasn't classified, or it was booked to another account.
- Ours only – you have turnover, your accountant doesn't. For example, you already processed month-end invoices they haven't received yet.
What to do with differences
- Click a row to see both sides' figures and your own entries on that account.
- Note – record what you clarified (e.g. "Rounding difference, acceptable").
- Correct to accountant data – create a correction entry with a counter-account of your choice so your figures match your accountant's.
- Add account to chart – if your accountant uses an account that isn't in your chart of accounts.
- If your own booking is wrong, fix it on the Booking Review page.
Approval and closing the month
When everything looks right, click Approve reconciliation. The system then offers to close the month (Close period). For closed months with an approved reconciliation, the ledger extract, the P&L and the Accountant final column on Plan vs Actual show your accountant's figures. An approved reconciliation cannot be deleted; approving a new one for the same month supersedes the old one.
Several months at once: if the Excel file has several worksheets, a dialog lets you assign each worksheet to a month. When uploading earlier years you can also tick Approve and close periods.
Previous Reconciliations at the bottom lists earlier uploads, and Reconciliation export saves the result to Excel.