QuickBooks Reconciliation: A Month-End Walkthrough for Bookkeepers

title: "QuickBooks Reconciliation: A Month-End Walkthrough for Bookkeepers" slug: quickbooks-reconciliation meta: title: "QuickBooks Reconciliation: A Month-End Walkthrough for..." description: "The QuickBooks Online reconcile routine, step by step. Plus a copy-paste month-end checklist and a worked example that traces a stuck difference to zero." featuredImageQuery: "bank statement month end"

It's the third business day of the month. You have twelve client files open. Each one has a checking account and a card or two that need to tie to the statement before you can call the month closed. That tie-out lives on one screen in QuickBooks Online: Reconcile. It's the last gate in any QuickBooks automation workflow, because no rule or feed can prove the books match the bank. Only the statement can.

This guide is the QBO reconcile routine, click by click. You get a checklist to copy into every client file. You also get a worked example of a difference that won't clear, traced to its causes with the numbers shown.

If you want the general theory of matching books to a bank, read our guide to bank reconciliation basics first. This page is only about doing it inside QBO.

What is QuickBooks reconciliation?

QuickBooks reconciliation is the month-end check that the transactions in a QuickBooks Online bank or credit card account match the bank's statement. You enter the statement's ending date and ending balance. Then you tick each transaction that also appears on the statement. When the difference between the statement balance and the cleared balance in QBO reaches $0.00, you finish, and QBO saves a reconciliation report. If the difference won't reach zero, the cause is almost always one of six things: a duplicate, a missing item, a wrong amount, a wrong date, a sign reversal, or a change to a transaction reconciled in an earlier month.

Key Takeaways

• Two numbers drive it: the statement's ending date and ending balance. Get either wrong and nothing else will tie.
• Check the beginning balance first: it must equal the prior statement's ending balance. If it doesn't, fix that before you tick anything.
• Finish only at $0.00: QBO can post an adjustment to force a finish. That hides the problem instead of fixing it.
• The cause list is short: duplicates, missing items, wrong amounts, wrong dates, sign reversals, and edits to earlier months.
• Two quick math tests: a difference that is twice one transaction points to a sign reversal. A difference divisible by 9 points to swapped digits.
• Keep the report: save each month's reconciliation report with the client's close file.

Before you open the reconcile screen

Reconcile goes faster when the feed work is already done. Before you start, check these for each account:

1. You have the bank or card statement for the month as a PDF.
2. Every bank feed item dated in the month is categorized or matched. If the feed queue still has a backlog, clear it first. Our guide to automating QuickBooks bookkeeping covers how to shrink that queue.
3. Last month is reconciled. You can't reconcile March cleanly on top of an open February.
4. You know the statement's opening balance, ending balance, and ending date.

That last point matters more than it looks. Card statements often close mid-month, like on the 17th. Use the date printed on the statement, not the calendar month end.

How to reconcile an account in QuickBooks Online, step by step

These steps follow the current QBO reconcile flow. Menu placement shifts a little between QBO navigation layouts, so look for Reconcile in the Settings (gear) menu or under your accounting or transactions menu.

Step 1: Open Reconcile and pick the account

Go to Reconcile. Choose the bank or credit card account from the account list. Do one account at a time. Finish it before you start the next.

Step 2: Enter the statement ending date and ending balance

Type the ending balance and ending date exactly as the statement shows them. QBO shows a beginning balance for you. Compare it to the opening balance on the statement.

If they match, click Start reconciling. If they don't match, stop here. Something reconciled in an earlier month has changed. Skip to the section on prior-month discrepancies below and fix that first.

Some statements list bank fees or interest earned. If the screen gives you fields for them, enter them there. If not, record them as normal transactions before you reconcile.

Step 3: Tick the items that cleared

QBO lists every transaction in the account up to the ending date. Tick each one that also appears on the statement. Leave items that haven't hit the bank yet, like a check the vendor hasn't cashed. Those stay open and show up again next month.

Work from the statement, top to bottom, not from the QBO list. Filter or sort by amount when the list is long. It's faster to find $1,650.00 in a sorted list than to scroll.

Step 4: Get the difference to $0.00 and finish

QBO shows a running difference as you tick. When it reads $0.00, click Finish now. If you get pulled away halfway, choose Save for later. Your ticks are kept.

If the difference isn't zero, don't finish. QBO can post an adjustment entry to force it through. That entry books the gap to an expense account, and next month's work starts from a wrong number. Trace the cause instead. The next two sections show how.

Step 5: Save the reconciliation report

After you finish, QBO offers the reconciliation report. You can also open it later from the reconcile history for that account. Save it as a PDF in the client's month-end folder. It lists what cleared, what's still open, and the statement balance you tied to. That report is your proof the month closed clean.

When the difference won't clear: the short list of causes

A stuck difference feels random. It isn't. Check these causes in this order.

On credit card accounts, sign reversals are the most common. A card refund entered as a charge is off by twice the refund.

Worked example: tracing a $1,247.50 difference

This example is synthetic. The client, the account, and the numbers are made up to show the method.

A landscaping client's March checking statement shows:

• Opening balance: $18,420.00
• Deposits: 9 items, $14,880.25 total
• Withdrawals: $11,994.85 total
• Ending balance: $21,305.40

Check the math: $18,420.00 + $14,880.25 − $11,994.85 = $21,305.40. The statement ties to itself.

In QBO, the beginning balance shows $18,420.00. It matches, so no prior-month problem. After ticking, QBO shows a cleared balance of $22,552.90. The difference is $21,305.40 − $22,552.90 = −$1,247.50.

First test: is it one item? No transaction is $1,247.50. Half of it is $623.75, and no item is that either. So it's not one simple sign reversal.

Second test: compare the totals. In QBO, the ticked deposits total $16,329.00 across 10 items. Ticked withdrawals total $12,196.10. Against the statement:

• Deposits: $16,329.00 in QBO vs. $14,880.25 on the statement. QBO is $1,448.75 high, with one extra item.
• Withdrawals: $12,196.10 in QBO vs. $11,994.85 on the statement. QBO is $201.25 high.

Cause 1: a sign reversal. The withdrawal gap is $201.25. The statement shows a $201.25 vendor refund as a deposit. In QBO it was entered as an expense, so it sits on the wrong side. Fix it to a deposit. QBO withdrawals drop by $201.25 and deposits rise by $201.25. The cleared balance moves up by $402.50, to $22,955.40. The new difference is $21,305.40 − $22,955.40 = −$1,650.00.

Cause 2: a duplicate. Deposits are now $16,530.25 in QBO against $14,880.25 on the statement. That's $1,650.00 high, with 10 items against the statement's 9. Two ticked deposits are $1,650.00 each. One came in from the bank feed. The other was a manual deposit of the same customer payment. The statement shows it once. Untick the manual one and delete it, or match it to the feed item. The cleared balance drops to $21,305.40.

Difference: $21,305.40 − $21,305.40 = $0.00. Click Finish now and save the report.

Two errors that point in opposite directions made the gap look bigger than either one alone. Comparing deposit and withdrawal totals separately split them apart in two steps.

Undo and prior-month discrepancies

Sometimes last month's reconciliation is the problem. The tell is a beginning balance that doesn't match the statement's opening balance.

That happens when someone edits, deletes, or un-reconciles a transaction that was already reconciled. To find it, open last month's reconciliation report and compare it to the account register today. Look for changed amounts, missing items, and changed dates. QBO also warns you before you change a reconciled transaction, so ask the client or your team who ignored that warning.

To back out a whole reconciliation, QBO lets accountant users undo it from the reconcile history, through QuickBooks Online Accountant. Other users can change the reconciled status on single transactions in the account register. Undo one month at a time, newest first, and re-reconcile forward. Undoing a reconciliation doesn't delete any transactions. It just marks them as not reconciled again.

Month-end reconciliation checklist (copy per account)

Copy this list into each client's close file. Run it once per bank and card account.

• Statement PDF saved for the month
  
• Bank feed items for the month categorized or matched
  
• Prior month reconciled, report on file
  
• QBO beginning balance equals the statement opening balance
  
• Statement ending date and ending balance entered exactly
  
• Fees and interest recorded
  
• Items ticked from the statement, top to bottom
  
• Deposit count and withdrawal count match the statement
  
• Difference is $0.00, with no forced adjustment
  
• Reconciliation report saved as PDF
  
• Open items older than 60 days flagged for the client
  

The same close discipline applies past the bank. Payables need their own tie-out too. See our walkthrough on accounts payable reconciliation.

Where Growthy fits in the month-end close

Growthy doesn't reconcile accounts inside QuickBooks, and it doesn't replace the QBO reconcile screen. It does the work around it.

Growthy categorizes transactions, tracks your approvals, reconciles against the bank statement, and closes the period in its own ledger. Approved lines post back to QuickBooks Online. Bank access is read-only, and Growthy never moves money. A multi-client dashboard shows which client months are stuck, so you know which files need you first. See how Growthy's monthly close works.

Frequently asked questions

Common questions about QuickBooks reconciliation from bookkeepers closing client months.

How often should I reconcile in QuickBooks Online?

Once per statement, for every bank and credit card account. For most accounts that means monthly. Reconcile in order. Don't skip a month.

Can I undo a reconciliation in QBO?

Yes. Accountant users can undo a full reconciliation from the reconcile history. Other users can change the reconciled status on single transactions in the register. Undo newest first.

Why did my beginning balance change?

A transaction reconciled in an earlier month was edited, deleted, or un-reconciled. Compare last month's reconciliation report to the register to find it.

Do credit cards reconcile the same way?

Yes. Use the card statement's closing date, which is often mid-month. Watch for refunds entered as charges. They cause a difference of twice the refund.

Conclusion

Reconciliation in QBO is the same routine every month: statement balance and date, tick what cleared, get to zero, save the report. When it won't tie, work the short cause list and compare deposits and withdrawals separately. Copy the checklist into every client file so the routine runs the same way each time.

Get started with Growthy and see which client months are still open before you open QBO.

Growthy is bookkeeping software, not a CPA firm. This content is educational, not professional advice.