Bank Reconciliation in QuickBooks: A Controlled Step-by-Step Process

A bank rec in QuickBooks compares the transactions recorded in QuickBooks with an independent bank or credit-card statement for the same account and period. The goal is not merely to make the difference display zero. The goal is to prove the ending balance, identify timing items, find missing or duplicated activity, and preserve a reviewable record.

A connected bank feed does not replace reconciliation. It helps import activity, but transactions can be missing, duplicated, delayed, misclassified, or posted to the wrong account. Use the actual statement as the controlling source.

Prepare before opening the reconciliation screen

Gather the complete statement, including every page, and confirm the account number or last digits, statement beginning date, ending date, beginning balance, and ending balance. If the bank provides check images, deposit detail, or a separate fee or interest notice, retain those records too.

In QuickBooks, verify that you selected the correct bank or credit-card ledger. Record known transactions through the statement date, but do not create entries solely to force the difference to zero. Confirm that transfers were entered to both correct accounts and that opening-balance or conversion entries are understood.

Enter the statement information exactly

Current QuickBooks Online instructions direct users to the Reconcile area, select the account, review the last statement ending date, and enter the current statement ending date and balance. The current statement should normally begin after the prior reconciled statement.

Before matching, compare the QuickBooks beginning balance with the statement beginning balance. If they differ, stop and investigate. A beginning-balance difference often means a previously reconciled transaction was changed, deleted, moved, or unreconciled. Continuing can bury the earlier problem in the current period.

Match transactions through the statement date

1. Match statement deposits and other credits to QuickBooks amounts, dates, and descriptions.
2. Match checks, electronic payments, card charges, withdrawals, fees, and other debits.
3. Use statement detail to resolve grouped deposits, batch settlements, and payments containing several transactions.
4. Leave legitimate outstanding checks or deposits uncleared when they are absent from the statement.
5. Investigate items on the statement that are missing from QuickBooks and items in QuickBooks that should have cleared but do not appear.
6. Finish only when the difference is zero and the remaining uncleared items are valid.

QuickBooks may show downloaded transaction information beside accounting entries, but the reviewer still confirms that the correct accounting transaction was matched. Matching a bank line to the wrong invoice payment, transfer, or expense can make cash agree while another account becomes wrong.

Illustrative processor deposit

Assume an illustrative card processor reports $9,000 of gross customer charges, $300 of refunds, and $180 of fees, then deposits $8,520. The statement shows one $8,520 deposit.

The bank rec should match the $8,520 cash deposit. The accounting detail should separately preserve the $9,000 of sales, $300 of refunds, and $180 of fees and clear the processor balance. Recording one $8,520 sales transaction makes the bank reconciliation easy but leaves revenue and fees incomplete.

For each processor, reconcile its settlement report to gross activity, adjustments, fees, reserves, and the bank deposit. The bank statement proves cash, not the composition of the sale.

How to investigate a nonzero difference

A reconciliation adjustment should not be the first response. Identify what the difference represents and use the appropriate transaction type and date. An unexplained adjustment can place the error in a suspense or expense account without fixing the underlying customer, vendor, loan, transfer, or revenue record.

Do not undo a completed reconciliation casually

Changing or undoing prior reconciliations can remove evidence of completed work and shift differences into later periods. Current QuickBooks guidance recommends checking the beginning balance and resolving discrepancies before deleting completed work.

If a prior transaction truly requires correction, document what changed, why, who approved it, and which periods or reports are affected. Reperform the necessary reconciliation and retain both the original issue and corrected result. Review whether financial statements, tax filings, lender reports, or customer and vendor records need follow-up.

Review the reconciliation report

After finishing, save or retain the reconciliation report and statement under the company’s policy. Review the statement ending balance, reconciled balance, outstanding checks, outstanding deposits, and any unusual or old items. A zero difference does not prove that old uncleared items are valid.

The reviewer should also scan the general ledger for entries posted directly to cash, transactions dated after the statement but cleared early, duplicate transfers, large round-number items, and changes after reconciliation. Restrict who can alter closed periods when practical.

Common failures

• Using the bank-feed balance instead of the formal statement ending balance.
• Forcing the difference to zero with an unexplained adjustment.
• Recording processor net deposits as revenue.
• Deleting old outstanding items without investigating their history.
• Matching transfers to income or expense rather than the other account.
• Finishing without saving and reviewing the statement and reconciliation report.

Decision rule

A bank rec in QuickBooks is complete only when the statement balance agrees, every cleared amount is supported, legitimate outstanding items are identified, differences are resolved to their real cause, related clearing accounts reconcile, and the statement and report can be reviewed later.

Continue with the Accounting Software and Tools hub, the guide to QuickBooks Online, and the overview of the QuickBooks general ledger.

Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.

If reconciliations are incomplete or prior balances have changed, review Steady’s bookkeeping services.