Skip to main content
Book a Free Call

Bookkeeping Basics

Reconcile QuickBooks: A Beginner’s Guide

Reconcile QuickBooks Online to a complete bank or credit-card statement, resolve opening and transaction differences, and preserve the final report.

  • Reviewed
  • Reading time7 min
  • FormatBeginner's Guide

To reconcile QuickBooks Online, use the complete bank or credit-card statement for one defined account and period, confirm the opening information, enter the statement ending date and balance, match the statement transactions, research every difference, and finish only when the difference is zero. Save and review the reconciliation report.

Bank feeds can download activity, but downloading is not reconciliation. The independent statement still provides the period cutoff and ending balance. Interface labels can change, so use Intuit’s current help instructions for the exact navigation in your subscription.

Before starting

  • Obtain the complete statement, not a live online balance or transaction export alone.
  • Confirm the company, legal entity, account, currency, and statement period.
  • Enter or review all transactions through the statement ending date.
  • Finish the oldest unreconciled period before later periods.
  • Preserve the prior reconciliation and investigate any changed beginning balance.
  • Back up or export important reports when the file is undergoing cleanup.

QuickBooks Online reconciliation steps

  1. Open All apps, choose Accounting, and open Reconcile under Intuit’s current workflow.
  2. Select the bank or credit-card account.
  3. Review the last statement ending date and opening information.
  4. Enter the statement ending date and ending balance exactly.
  5. Start the reconciliation and compare QuickBooks with the statement.
  6. Select only transactions that cleared within the statement period.
  7. Record valid statement items missing from the books with the correct account and support.
  8. Leave valid deposits, checks, or payments that clear later outstanding.
  9. Research duplicates, wrong dates, wrong accounts, changed transactions, and missing transfers.
  10. When the difference is $0.00, finish and save the reconciliation report.

Intuit’s June 18, 2026 instructions state that QuickBooks Online can automatically enter the starting balance and download transactions for connected accounts. Automation helps with entry, but it does not replace review of completeness, classification, support, or cutoff.

Match, add, transfer, or exclude

Match a downloaded line to an existing invoice payment, bill payment, expense, deposit, or transfer when that record already represents the activity. Adding the line instead creates a second transaction. Use transfer treatment only when money moved between two balance-sheet accounts owned by the business, and verify both sides.

Excluding a bank-feed line does not remove it from the statement. Exclusion may be appropriate for a true duplicate feed record or an item already captured another way, but it needs a documented reason. Every real statement item must still be represented in the books.

Opening-balance differences

If the beginning balance does not agree with the prior reconciliation, do not enter a plug. Review the prior reconciliation report, account register, audit log, opening-balance entries, deleted transactions, date changes, amount changes, and reconciliation status. A prior reconciled transaction may have been edited or unreconciled.

Correct the underlying record with approval and preserve why the change was necessary. If historical books are unreliable, define the last dependable statement, cleanup scope, tax-return tie-out, and opening-balance method before moving forward.

Why the difference is not zero

Symptom Possible cause Next check
Difference equals one statement item Fee, interest, deposit, or payment is missing Search by exact amount and date
Difference is twice an amount Sign error or selected item should be cleared or uncleared Compare debit and credit direction
Book item appears twice Downloaded line was added instead of matched Inspect linked source and audit trail
Transfer affects income or expense Only one side or wrong category was recorded Trace both accounts
Beginning balance changed Prior reconciled history was edited Review reconciliation history and audit log

Outstanding transactions

A check or payment recorded before the statement end may clear later. A deposit may be in transit. Leave valid items uncleared and carry them forward. Review old items for duplicates, lost checks, failed deposits, wrong accounts, stop payments, payee contact, or other required action.

Do not change a transaction date solely to remove it from a reconciliation. Dates affect reporting and cutoff. Correct only when source evidence supports the change.

Credit-card accounts

Use the issuer’s statement ending balance and date. Match purchases, refunds, fees, interest, and payments. A payment from checking reduces the card liability; it is not an additional expense. If several employee cards roll into one issuer statement, make sure the QuickBooks structure agrees with the consolidated liability.

Undoing or changing a reconciliation

Undoing can reopen many transactions and alter later periods. Before doing it, preserve the reports, identify the exact error, measure the affected periods and reports, check tax filings and closed books, and obtain appropriate approval. Often a targeted correction with a clear audit trail is safer than undoing an entire historical sequence.

Access to undo or change prior reconciliations may depend on the QuickBooks product and user role. Follow Intuit’s current instructions and involve the accountant responsible for the books when historical reporting is affected.

Reconciliation adjustments

A generic adjustment should not be the first response. Search for wrong statement data, missing items, duplicates, transposed digits, opening-balance changes, payment direction, transfers, and account selection. If an adjustment is ultimately justified under policy, document the source, cause, amount, accounts, period, materiality, approver, and plan to prevent recurrence.

Review the reconciliation report

  • The report names the correct account and statement period.
  • The statement ending balance matches the source statement.
  • The difference is zero.
  • Outstanding checks, payments, and deposits are plausible and supported.
  • Old items have owners and resolution dates.
  • Unusual, owner, payroll, tax, loan, and transfer activity was reviewed.
  • Any changes after close are controlled and visible.

Reconciliation proves agreement with the statement, not that every account classification is correct. Review the balance sheet, profit and loss, receivables, payables, payroll liabilities, loans, fixed assets, and equity as part of the close.

First-time reconciliation

When reconciling an account for the first time, verify the QuickBooks opening balance against the actual account opening or a dependable prior statement. Identify transactions dated before the first statement period and decide whether they belong to the opening balance, an earlier cleanup period, or the current books. Do not select old transactions merely to make the starting difference disappear.

If historical transactions exist, build a bridge from the last reliable external balance to the first reconciliation. Document uncleared checks, deposits in transit, outstanding card activity, conversion entries, and differences from any prior accounting system or tax return.

Transfers and credit-card payments

When money moves between business accounts, record a transfer or linked entries so one account decreases and the other increases. Do not categorize the withdrawal as expense and the deposit as income. Match each side during the reconciliation of its own statement period.

A credit-card payment is a transfer from cash to the card liability. The purchases create expenses or assets. If the bank side and card side were both added from feeds without matching, duplicate transfers or expenses may result.

Cleanup of old unreconciled periods

Work chronologically from the oldest complete statement. Reconcile one period, save its report, and roll valid outstanding items forward. Track missing statements, unrecoverable support, deleted history, duplicate feed entries, and assumptions in a cleanup log. Reconcile tax-return and financial-statement balances before changing closed years.

A large one-time adjustment can hide several errors with different effects. Break differences into identifiable transactions or supported opening-balance corrections and obtain review before finalizing them.

Example

The statement ends at $31,500. QuickBooks shows $31,690 after selected transactions. A $240 check in QuickBooks has not cleared and a $50 bank fee is absent from the books. Unclear the valid outstanding check and record the supported fee. The adjusted book and statement comparison then reaches zero while the check remains on the outstanding list for next month.

Continue with reconciling accounts in QuickBooks, bank statements in QuickBooks, and QuickBooks support.

Frequently asked questions

Do bank-feed matches mean the account is reconciled?

No. Matching organizes transactions. Reconciliation separately proves the books agree with a complete statement for a defined period.

Should the QuickBooks difference be zero?

Yes. Finish only when the difference is zero and every remaining outstanding item is valid and supported.

What date and balance should I enter?

Use the ending date and ending balance printed on the complete statement for the account being reconciled.

Why did my opening balance change?

A previously reconciled transaction may have been deleted, edited, moved, or unreconciled, or an opening-balance record may have changed.

Can I make an adjustment to force zero?

Research the cause first. Use an adjustment only when justified by policy, supported, approved, and documented with its financial-statement effect.

What should I save after finishing?

Retain the statement, reconciliation report, outstanding-item detail, corrections, exception support, and preparer and reviewer approval.

Turn this guide into action

Want a clearer, more dependable financial process?

Talk through your bookkeeping needs