Lighthouse Bookkeeping · Practical Guide

How to Reconcile Bank Accounts in QuickBooks Online

Bank reconciliation is a check between your accounting records and an account statement. It helps you identify differences before they become part of the financial reports you rely on.

By Lighthouse Bookkeeping

By Lighthouse Bookkeeping · Reviewed by Bosco Tanson, Founder & Managing Director · Published October 2, 2026 · Last reviewed October 2, 2026

The Short Version

Have your statement and prior reconciliation ready first.

Match each transaction to the statement, then investigate differences.

Avoid forcing a balance with an unsupported adjustment.

Save the result and review it afterward.

Prepare Before You Begin

Gather the statement for the account and period you want to reconcile. Check that the prior period and beginning balance are reliable. If an earlier balance is wrong, beginning another reconciliation can make the problem harder to understand.

Keep a separate list of missing statements and unclear activity. Start with complete information rather than assuming the bank feed has supplied everything.

The Basic QuickBooks Online Process

Intuit’s workflow uses the account statement’s ending date and balance, then matches statement activity with transactions in QuickBooks Online. Review the selected account carefully. Match the listed transactions and work toward a zero difference before completing the reconciliation.

The interface can change, so use Intuit’s current instructions linked below for the exact navigation and labels.

When the Numbers Do Not Agree

Check the account and period first. Then look for duplicate or missing transactions, amounts entered incorrectly, activity from a different period, and changes to an earlier reconciliation. An unexplained beginning balance also deserves attention.

A useful investigation note identifies the transaction, the statement evidence, and what is different in the books. That is more helpful than repeatedly changing balances until the result looks right.

Avoid an Unsupported Shortcut

A correction should reflect the underlying record. If the reason for a difference is unknown, keep the issue visible and investigate it. A balancing adjustment without supporting information can make the next report look complete while leaving the real problem unresolved.

Save the Result and Review What Remains

After completing the period, keep the reconciliation record and any supporting notes. Review uncleared items to understand whether they represent normal timing or something needing correction. Do not assume an old unresolved item will disappear in a later month.

When a Reconciliation Needs Cleanup

Missing prior periods or altered historical records may need more than a routine monthly check. Lighthouse can review the situation and quote historical cleanup separately. Ongoing reconciliation can then become part of a consistent monthly process.

A Worked Reconciliation Example

Suppose the bank statement and the books show different balances at the end of the month. A reconciliation explains the difference line by line.

LineAmount
Bank statement ending balance$8,000.00
Less: check #1042 not yet cleared($900.00)
Plus: deposit made but not yet on the statement$250.00
Adjusted bank balance$7,350.00
Balance in the books$7,350.00
Difference$0.00
Hypothetical example. The figures above are invented to illustrate the idea and do not describe a real client.

Common Questions

What is a bank reconciliation?

A comparison of your bookkeeping records with the bank or card statement to confirm they agree.

What if the difference is not zero?

Look for missing, duplicated or misdated transactions and timing differences before making any adjustment.

Should I use an adjustment to make it balance?

Avoid unsupported adjustments. Find the cause first, because a forced match can hide a real problem.

Where can I find the official instructions?

The guide links to Intuit’s own help article on reconciling accounts in QuickBooks Online.

You May Also Find These Useful

Bank Reconciliation

Learn more →

Guides & Resources

Learn more →

Let’s Get Your Books in Order

Start with a free conversation about your records, reporting needs, and the support that fits.

Book a Free Consultation