QuickBooks Reconciliation Differences: What to Check First

Illustration accompanying a guide to QuickBooks bookkeeping workflows
Practical guide

A clearer path from records to decisions

Organize the evidence, reconcile the activity, and preserve a review trail before relying on the reports.

Accounting Software
01

Organize

Collect complete source records for the period.

02

Verify

Reconcile balances and investigate unusual activity.

03

Use

Turn the reviewed records into clear next actions.

What good looks likeFinancial records that are easier to understand and hand off.

A QuickBooks reconciliation difference is a reason to investigate the records, not a reason to add an unexplained adjustment. Begin with the account, statement period, and last reliable reconciliation. Then identify which supported transaction or balance explains the difference.

This guide is a diagnostic checklist for business owners preparing questions for their bookkeeper. If a change affects a closed period or a filed return, get the accountant’s approval before editing the historical records.

Bank matching and reconciliation answer different questions

Bank-feed matching connects downloaded activity with transactions in the ledger. Reconciliation compares the account with a complete statement for a defined period. Intuit’s account reconciliation instructions describe entering the statement information, matching transactions, and retaining the resulting reconciliation report.

Even a zero reconciliation difference does not prove every cost has the correct category or project code. Those need separate bookkeeping review.

Check the starting information before the transactions

Confirm that the selected account is the one shown on the statement. Check its ending date and ending balance against the document rather than the bank’s current online balance. The two balances may describe different dates.

Compare the beginning position with the previous completed reconciliation. If it has changed, investigate edits or deletions affecting previously reconciled transactions. Keep the previous report and relevant audit history before changing anything.

Work through these possible causes

What you see What to inspect Evidence to retain
Difference appears before current-period matching Previous reconciliation and opening position Prior report, statement, and relevant edit history
Same amount appears twice Manual entry plus downloaded or imported entry Original transaction and the import or matching trail
Transfer looks like income or expense Both sides of the transfer and their dates Statements from the sending and receiving accounts
Credit card payment is missing Paying bank account and card account Payment confirmation and both statement entries
Small remaining difference Fees, interest, refunds, and transposed amounts The statement line and corresponding ledger entry
Payout does not equal sales Processor fees, refunds, reserves, and cutoff Settlement report and clearing-account reconciliation

These are investigation paths, not proof that a particular entry should be deleted. Amounts that happen to match can refer to different transactions.

A simple duplicate-payment example

Suppose a 250 supplier payment appears on the bank statement once but in the ledger twice. One entry may have been created manually and another added from the bank feed. Before removing either, check whether an entry is linked to a bill, included in a previous reconciliation, or supported by a separate payment.

The correction should preserve the real payment and its bill relationship. Record what changed and why. Deleting the first matching amount without reviewing those links can create an unpaid bill or disturb a closed period.

This is an illustrative example, not a description of a client account.

Record timing differences separately

An outstanding check or deposit can explain why the ledger and statement look different at a date. Keep a list of outstanding items, their dates, support, and follow-up owner. An old item is not automatically an error, but it needs an explanation before being left in the reconciliation indefinitely.

For processor payouts, use the processor’s transaction and settlement reports rather than treating the payout as gross sales. Our ecommerce bookkeeping workflow explains this bridge.

Prepare a useful handoff

Send your bookkeeper the account name, statement period, difference amount, previous reconciliation report, and any recent changes you know about. Use the agreed secure channel for financial records; do not put banking passwords or authentication codes in a website enquiry.

For recurring help, see bank and credit card reconciliation services. For several unreliable historical periods, start with cleanup and catch-up bookkeeping. The accountant handoff checklist helps organize the wider record set.

When the reconciliation is ready

A completed review should leave the statement, reconciliation report, supported corrections, and remaining questions together. If evidence is missing, label the limitation. A tidy report is useful only when another person can retrace the explanation.

Contact