Reconcile Accounts in QuickBooks: A Beginner’s Guide

To reconcile accounts in QuickBooks Online, compare transactions in each bank or credit-card register with an external statement for the same period. Select the correct account, enter the statement ending date and balance, confirm the beginning balance, match cleared items, research differences, and finish when the difference is zero.

Current Intuit guidance describes reconciliation as matching QuickBooks transactions with bank and credit-card statements. Connected feeds can import activity and suggest matches, but the statement remains the external control. A feed is not a completed reconciliation.

Which accounts should be reconciled?

Reconcile every bank, savings, credit-card, and other account that has a reliable external statement. Other balance-sheet accounts also require reconciliation, although they may use schedules rather than the QuickBooks reconciliation screen. Examples include receivables, payables, payroll liabilities, debt, fixed assets, inventory, clearing accounts, and owner or intercompany balances.

Assign each account an owner, reviewer, frequency, source, due date, and materiality threshold. High-volume cash and clearing accounts may need daily monitoring in addition to monthly close.

Prepare the statement period

• Obtain the complete statement from an authorized source.
• Confirm account identity, entity, currency, beginning balance, ending balance, and dates.
• Enter or match valid transactions through the statement closing date.
• Record supported fees, interest, returns, transfers, and corrections.
• Resolve obvious duplicate bank-feed items before starting.
• Preserve prior reports and restrict unnecessary changes to closed periods.

If several periods are behind, begin with the oldest complete unreconciled statement. Combining months removes the ability to reproduce each period and can hide when an error arose.

QuickBooks Online reconciliation steps

1. Open the current reconciliation area and choose the correct account.
2. Review the last statement ending date.
3. Enter the statement ending balance and ending date exactly.
4. Confirm the displayed beginning balance agrees to the statement.
5. Compare QuickBooks activity with each statement section.
6. Select only transactions that cleared on or before the statement date.
7. Investigate missing, duplicate, altered, misdated, or misclassified activity.
8. Confirm the cleared balance agrees to the statement and the difference is zero.
9. Finish and retain the reconciliation report with the statement.

Menus and plan features change. Use current Intuit support for the interface path. Preserve the control objective even when automation or AI-assisted matching is available.

Beginning balance differences

The beginning balance normally carries forward from the prior completed reconciliation. If it differs, a previously reconciled transaction may have been edited, deleted, moved to another account, re-dated, duplicated, or changed from reconciled to uncleared. The original opening balance may also be wrong.

Review reconciliation history, discrepancy information, the audit log where available, and the prior report. Correct the supported underlying transaction. An unexplained adjustment can restore the screen while leaving cash, revenue, expense, liability, or equity wrong.

Ending difference research

Check	Question	Action
Statement setup	Are the ending date and balance exact?	Correct the statement information
Missing activity	Is a fee, interest item, deposit, or payment absent?	Record from valid support
Duplicates	Was an imported item added instead of matched?	Preserve the valid record and remove the duplicate correctly
Wrong account	Is the transaction in another bank or card register?	Move or correct with an audit trail
Wrong sign or amount	Does a credit appear as a charge or contain a typo?	Compare source and correct
Prior change	Was reconciled history altered?	Research the audit trail and prior report

Search exact amounts and common combinations. A difference divisible by nine may suggest transposed digits, but treat that only as a clue. Compare deposits and withdrawals separately and stop after each supported correction to recalculate.

Downloaded transactions and matching

When a bank-feed item represents a transaction already recorded, match it rather than adding a second transaction. A transfer should connect two balance-sheet accounts, not create income and expense. One withdrawal may need a split among several supported accounts.

Review excluded and pending items. Exclusion prevents a line from being added through the feed but does not erase the actual bank activity. Pending online transactions may not belong to the closed statement and should not be marked cleared prematurely.

Outstanding items

Outstanding payments are in the books but not on the statement by the closing date. Deposits in transit are recorded receipts that have not reached the statement. Valid timing items remain uncleared and should clear later.

Age them. Investigate stale checks, failed deposits, duplicate entries, voided payments, chargebacks, and legal requirements such as unclaimed-property rules. Assign an owner and expected resolution date.

Credit-card accounts

Match purchases, fees, interest, refunds, credits, and payments to the issuer statement. Record a card payment as a transfer from cash that reduces the card liability when the underlying purchases were already recorded. Posting the payment as expense duplicates cost.

If employee cards feed one master statement, design the QuickBooks accounts to reproduce that statement. Reconcile all subaccounts or cardholder activity exactly once and connect the master payment correctly.

Reconciliation adjustments

Do not use an adjustment simply to reach zero. Exhaust statement setup, missing activity, duplicates, prior changes, wrong accounts, wrong dates, and opening-balance research. If a supported residual remains, document the cause, amount, account, date, materiality, approval, and financial-statement effect.

Track recurring adjustments. They reveal upstream problems in bank-feed review, transaction entry, access, cutoff, or month-end procedures.

Review after finishing

QuickBooks saves a reconciliation report after completion. The reviewer should verify the account and period, statement balances, zero difference, outstanding items, adjustments, prior changes, and agreement between the final report and ledger.

Then review classification. Cash receipts may be customer payments, loans, owner contributions, transfers, or advances. Withdrawals may be expenses, assets, loan principal, distributions, card payments, or transfers. Reconciliation proves amount agreement, not category accuracy.

Reconcile clearing and transfer activity

Payment processors, payroll providers, merchant accounts, and marketplace platforms often need clearing accounts. The source report should explain the opening balance, gross additions, fees or deductions, cash settlements, reserves, and ending balance. Reconcile both the cash payout and the remaining clearing balance.

Transfers require both sides. A withdrawal from one bank and deposit into another should connect the two balance-sheet accounts. Timing can leave an in-transit balance at month-end, but it needs a source, destination, amount, initiation date, expected clearing date, and later evidence.

Illustrative difference investigation

Suppose the reconciliation difference is $2,760. Confirm the statement information, then search for $2,760. If no exact amount appears, compare the deposit and withdrawal sections separately. A $3,000 transfer added as income, a $215 fee omitted, and a $25 interest credit omitted create a net $2,760 overstatement.

Correct the transfer, fee, and interest from source evidence, then recalculate. This preserves correct classifications and an understandable audit trail. One unexplained adjustment for $2,760 might force zero while overstating revenue and omitting bank activity.

Handling a backlog

For many unreconciled months, collect all statements, protect the current file, and start with the oldest period. Resolve opening balances before moving forward. Maintain a correction log and avoid changing later periods until the earlier statement is complete. If source records are missing or differences are material, involve a qualified professional.

After catching up, establish a close calendar that names the preparer, reviewer, statement source, due date, follow-up owner, and evidence location for every account. Monitor completion and unresolved differences centrally so one delayed reconciliation cannot disappear inside the broader month-end process.

Monthly close package

• External statement and final reconciliation report.
• Outstanding payment and deposit detail with aging and owner.
• Support for fees, interest, transfers, corrections, and adjustments.
• Evidence of prior-period change review.
• Classification review for unusual or material activity.
• Preparer and reviewer signoff with completion date.

Review reconciling a bank statement in QuickBooks for common questions, or reconcile QuickBooks Desktop for the desktop workflow. Businesses needing a repeatable close can review QuickBooks services.