Match the bank to the books in minutes – and prove it with a signed-off reconciliation
Secure checkout. Your download link is sent as soon as payment clears.
A bank reconciliation proves that the bank balance in your books is right. It takes the balance on the bank statement, adjusts it for items that are in your cash book but haven't reached the bank yet (unpresented cheques and payments, outstanding lodgements), and checks the result against your cash book after you've added the items the bank has processed that you haven't recorded yet (bank charges, interest, direct debits). If the two adjusted balances agree, the books are right. This workbook does the matching for you: paste up to 2,000 lines from each side and it pairs them automatically, lists everything that's left, builds the formal statement at any month-end and gives a clear green or red result.
See how it works
The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.
Step 1
Your statement lines and the matching result for each one. What you do: paste the statement; use Manual match where needed.
Step 2
Your cash book lines, running balance and matching result. What you do: paste the cash book; use Manual match where needed.
Step 3
The formal reconciliation statement, review checks and sign-off – fits one A4 page. What you do: enter preparer, reviewer, dates and notes.
Step 4
Unpresented cheques and payments, and outstanding lodgements, at the month-end. What you do: review the flags – stale, large, duplicate, delayed.
Who it is for
Quick start
Your file is only released once payment has cleared.
You are taken to our secure checkout.
Checkout takes a minute and you get a receipt by email.
Your download link arrives as soon as payment clears.
We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.
Part of AML Finance Group
Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.
Visit AML Accountancy Solutions
