Bank Reconciliation Explained for Business Owners Who Hate Accounting
If the word "reconciliation" makes your eyes glaze over, you're in good company. Most business owners I talk to know they should reconcile. Far fewer know what reconciling does or why skipping it causes so much trouble.
Here is bank reconciliation in plain English, plus a step-by-step walkthrough for QuickBooks Online.
What reconciliation means
Your bank sends a statement every month. The statement lists every deposit and withdrawal, and an ending balance.
QuickBooks keeps its own list of the same transactions. Reconciling means checking the two lists against each other, line by line, until the ending balance in QuickBooks matches the ending balance on the statement.
When they match, you know your books include every transaction, once, for the right amount.
Why the bank feed isn't enough
Many owners assume the bank feed handles this. The feed only imports transactions. Errors still creep in:
Someone enters an expense by hand, then adds the same charge from the feed.
A transaction gets deleted by accident.
The feed disconnects for two weeks and nobody notices.
A deposit gets matched to the wrong invoice.
Reconciling catches each of these. Without it, your reports drift a little further from reality every month.
What you need before you start
The bank or credit card statement for the month, as a PDF or paper copy
The ending balance and ending date from that statement
About 20 to 30 minutes for a typical month
Reconcile one account and one month at a time, oldest first.
How to reconcile in QuickBooks Online
Open the Reconcile tool. Search "reconcile" in the QuickBooks search bar if you can't find the menu.
Pick the account. Choose the bank or credit card account that matches your statement.
Enter the statement details. Type the ending date and the ending balance exactly as they appear on the statement.
Check the beginning balance. QuickBooks shows a beginning balance. The number should match the beginning balance on your statement. If it doesn't, stop. A past month has a problem, and it needs fixing first.
Check off each transaction. Go down your statement. For each line, find the matching transaction in QuickBooks and check it off.
Watch the Difference number. When every statement line is checked, the Difference should read $0.00.
Click Finish now. Only finish when the difference is zero.
What to do when the difference isn't zero
This is where most owners get stuck. Work through these checks in order:
Look for a missing transaction. Is a line on the statement with no match in QuickBooks? Add it.
Look for an extra transaction. Is a checked item in QuickBooks not on the statement? Uncheck it and find out why it exists. Duplicates show up here.
Look for wrong amounts. A $1,250 charge entered as $125 throws off the total by $1,125.
Divide the difference by 9. If the answer is a whole number, you probably swapped two digits somewhere, like $54 entered as $45.
Check the date range. A transaction dated one day after the statement ending date belongs to next month.
Never force a reconciliation
QuickBooks lets you finish with a difference and posts an adjustment to make the numbers match. Don't do it. The adjustment hides the real problem, and it lands in Reconciliation Discrepancies or Opening Balance Equity, where it confuses your CPA later.
If you find old forced adjustments in your file, they're a sign the books need a closer look.
How often to reconcile
Every month, for every bank account, credit card, and loan. Set a reminder for the week after statements arrive. Ten minutes on a clean month beats ten hours sorting through a year.
When reconciliation turns into a cleanup
If your beginning balance doesn't match, or you're several months behind, or the file has forced adjustments, one-month-at-a-time fixes stop working. You need someone to rebuild the history.
I reconcile every account back to the last correct balance, fix what's hiding underneath, and hand back a file that matches the bank to the penny.
Frequently asked questions
How long should a reconciliation take?
A clean month with a few dozen transactions takes 15 to 30 minutes. If a single month takes hours, something earlier in the file needs fixing first.
Do I need to reconcile credit cards and loans too?
Yes. Every account with a statement should be reconciled: bank accounts, credit cards, lines of credit, loans, and payment accounts like PayPal. Credit cards are often where duplicates and personal charges hide.
Why doesn't my beginning balance match the statement?
Someone changed, deleted, or added a transaction in a month that was already reconciled. QuickBooks keeps reports of past reconciliations. Comparing those reports to the current transactions shows what changed.
Can I undo a reconciliation?
A ProAdvisor working in QuickBooks Online Accountant can undo a full reconciliation. As the business owner, you can only unmark transactions one at a time, which gets slow for a full month.
What if I've never reconciled at all?
Start with the oldest month you have statements for and work forward. If that means a year or more of reconciling, a cleanup will get you there faster and with fewer mistakes.
Is reconciling the same as matching in the bank feed?
No. Matching connects a bank feed transaction to one already in QuickBooks, so you don't record it twice. Reconciling checks the whole month against the statement and proves the ending balance is right. Matching happens every week. Reconciling happens once a month, after the statement arrives.
Should I reconcile even if the bank feed looks right?
Yes. The bank feed shows what the bank sent. Reconciliation proves nothing was deleted, doubled, or skipped after it arrived.
Get your accounts reconciled
Tell me which accounts are behind and for how long. I'll reply within one business day to set up a review of your books, then send a fixed quote.
Comments