How to reconcile your bank account without the jargon
Match your statement to your records, explain timing gaps, and leave each month with a balance you trust.
A bank reconciliation is a check that your records and your statement are telling the same story. It is not an exam, and it does not ask for a finance qualification. If you do it on an ordinary weekday, rather than the night before a deadline, most differences are small and have a plain explanation.
You can follow the method below in software or on a spreadsheet. It assumes you already note money in and money out. If that habit is still forming, the notes on what to record and why are a sensible place to begin.
What you are actually comparing
On one side is the closing balance on the bank statement for a date you choose. On the other is the balance in your books for that same date. They often disagree at first, and that does not mean cash has vanished. It usually means some items are in one list and not yet in the other.
Pick a period you can finish in one sitting. A calendar month suits most sole traders. A quarter can work if you have very few transactions, though a shorter gap makes odd lines easier to spot. Write the statement date and the statement balance on a piece of paper, or in a cell at the top of the sheet, before you start ticking.
Gather one complete set of records
You need the statement, or a downloaded list of transactions, and your own list of income and spending for the same dates. You also need invoices you have already counted as income even though the client has not paid, and bills you have entered but not yet paid. Those items are not on the statement yet. They are a common reason the two totals differ.
If personal and business spending share one account, the job becomes a sorting exercise as well as a matching exercise. Many owners eventually open a separate business account for that reason. The case for keeping the two pots apart is practical, not theoretical.
Match line by line, then the other way
Work down the statement. For each line, find the same amount in your records and tick both. Shared lines are fine. A line that appears only on the statement needs a decision: bank charge, forgotten direct debit, client receipt, or a personal transfer?
Enter the missing item before you move on. A small fee that never reaches the books will nag you every month. A client receipt you forgot to log will make income look lower than it was.
Then reverse the check. Look at records that have no tick. A cheque you wrote last week may not have cleared. An invoice is not cash until it is paid. These are timing differences. List them. They explain the gap, and they are not errors if you have described them honestly.
The sum that should agree
A simple layout is enough. Start with the statement balance. Add receipts you have recorded that have not cleared. Subtract payments you have recorded that have not left the bank. The result should equal the balance in your books.
Software may do this sum for you. Still read the unmatched list. Two mistakes can cancel each other: a duplicated invoice and a missing receipt of the same size will leave the total looking tidy while both lines are wrong.
When the adjusted figures agree, note the date you checked them. A monthly money routine is a natural home for the job, so it does not depend on memory.
When the figures still refuse to match
Look for the usual culprits before you invent a balancing entry. A duplicated line. A figure typed as 54 instead of 45. A payment put in the wrong month. A transfer between your own accounts logged once as income. A refund entered as a fresh sale.
Search for the size of the difference. If you are a particular amount out, look for a line of that amount, or for two lines that differ by it. A gap that is exactly double a transaction often means you entered it twice. A gap divisible by nine is a hint to glance at reversed digits, such as 72 instead of 27.
If a focused half hour does not find it, stop. Come back later, or ask a bookkeeper to look. A made-up line called miscellaneous only buries the problem until the next month, when the gap is larger and harder to explain.
A habit rather than a rescue
Monthly reconciliation keeps the hunt small. It also makes your cash position more believable, because you stop treating unpaid invoices as money you can spend today. Keep the statement and a short note of outstanding items with that month's papers. You do not need a formal report. You need to show, later, that the numbers were checked by a person and not only by a green tick on a screen.
Frequently asked questions
How often should a sole trader reconcile? Once a month suits most people. Weekly is reasonable if you take a lot of card payments. Leaving it until the year end turns a short job into a long one, usually at the least convenient time.
Do I need accounting software to reconcile? No. A spreadsheet with a tick column works. Software can suggest matches, which saves time, but you still review the suggestions. A bank feed is not a substitute for reading the statement.
What if business and personal spending share one account? Reconcile the whole account, then mark which lines are personal. Personal spending is not a business expense. A separate account, once you can open one, makes the monthly check shorter and reduces the chance of claiming the wrong thing.
Steps
- Fix the period and the statement balance: Choose a month you can finish, and write down the statement date and closing balance before you start matching lines.
- Tick every shared line: Work down the statement and tick each amount that also appears in your records. Enter anything missing, such as a bank charge or a forgotten receipt.
- List timing differences: Note invoices you have recorded that are unpaid, and payments you have recorded that have not yet left the bank.
- Close only when the adjusted figures agree: Compare the adjusted statement balance with your book balance. Investigate any remaining gap before you mark the month as reconciled.