Reconcile a Bank Statement in QuickBooks: Common Questions Answered

To reconcile a bank statement in QuickBooks, compare transactions in the QuickBooks bank account with the bank’s statement for the same period. Confirm the beginning balance, enter the statement closing date and balance, match cleared activity, investigate differences, and finish only when the difference is zero.

Downloaded bank transactions support data entry, but they are not the reconciliation. The bank feed may omit older activity, suggest the wrong match, or import a duplicate. The official statement remains the control document.

What should I do before starting?

Obtain the complete statement and confirm the bank account, beginning date, ending date, and ending balance. Add or match all transactions through the closing date. Record bank fees, interest, returned items, transfers, and corrections supported by the statement.

If reconciling several months, start with the oldest unreconciled statement. Do not combine months merely to make a difference disappear. Each statement period should have a reproducible report.

What are the current QuickBooks steps?

1. Open the current reconciliation area and select the correct account.
2. Enter the statement ending date and ending balance.
3. Verify the QuickBooks beginning balance agrees to the statement.
4. Match deposits and withdrawals that cleared during the period.
5. Investigate missing, duplicated, altered, or incorrectly dated entries.
6. Confirm the matched balance equals the statement and the difference is zero.
7. Finish and save the reconciliation report with the statement.

Menus and plan features can change. Use current official QuickBooks help for the screen path while preserving this accounting objective.

Why is the beginning balance different?

A previously reconciled transaction may have been deleted, changed, moved to another account, or given a different amount or date. An opening balance may also have been entered incorrectly. Review the prior reconciliation report and discrepancy information before posting an adjustment.

Correct the supported underlying record. A plug can force the current screen to zero while causing cash, revenue, expense, liability, or equity to be wrong.

How do bank-feed transactions affect reconciliation?

Match a downloaded item to an existing recorded transaction when it represents the same event. Adding it instead creates a duplicate. Transfers should connect the two balance-sheet accounts rather than creating revenue and expense. Split transactions when one bank amount contains several supported accounting components.

What are outstanding checks and deposits?

An outstanding check or payment is recorded in the books but has not cleared the statement date. A deposit in transit is recorded but not yet shown by the bank. Valid timing items remain unmatched in the reconciliation and should clear later.

Review old items. Stale checks, failed deposits, duplicate entries, and unclaimed-property considerations need documented follow-up under applicable policies and law.

Why is the ending difference not zero?

• The statement ending balance or date is wrong.
• A transaction is missing, duplicated, or assigned to another account.
• A deposit or payment has the wrong amount or sign.
• A transfer was categorized as revenue or expense.
• Bank fees, interest, returned items, or corrections were omitted.
• A prior reconciled transaction changed.
• The wrong statement or QuickBooks account was selected.

Compare one statement section at a time and search exact amounts. Do not mark an uncleared transaction as cleared solely to reach zero.

Can I use an adjustment?

An adjustment should not replace investigation. If a real, supported difference remains after research, document its origin, accounting treatment, approver, and effect before recording it. Material or old differences deserve professional review.

What should the reviewer inspect?

The reviewer should confirm the statement identity, dates, beginning and ending balances, zero difference, unusual reconciling items, old outstanding items, corrections, and agreement between the final report and the ledger. Save the statement, final report, outstanding-item detail, correction support, and signoff.

Illustrative difference investigation

Suppose QuickBooks is $1,425 above the statement. First confirm the ending balance was typed correctly. Then search for $1,425 on both sides. If no exact item exists, compare statement sections and look for combinations, transposed digits, wrong signs, or a deposit recorded twice.

If the difference includes a $1,200 transfer added as income, a $200 bank fee not recorded, and a $25 interest credit not recorded, correct each supported item. Recalculate and confirm the final report reaches zero. Preserve the source and correction rather than entering one unexplained $1,425 adjustment.

Review after reconciliation

Agreement with the bank does not prove correct classification. Scan deposits for loans, owner contributions, customer advances, and transfers mistakenly posted to revenue. Scan withdrawals for loan principal, asset purchases, owner activity, and transfers mistakenly posted to expense.

Compare the reconciled cash balance with the balance sheet and cash-flow information for the same date and entity. If a customized management report excludes or combines accounts, keep a mapping so its cash total can still be reproduced.

Record open items with an owner and expected clearing date. A reconciliation is not complete operationally when material outstanding transactions have no follow-up.

Review that follow-up at the next close and preserve later clearing evidence.

Escalate items that remain unresolved beyond the stated expectation.

See how to reconcile a bank statement for the general control, or review QuickBooks bookkeeping services for recurring support.