What Is Bank Reconciliation in QBO?

Bank reconciliation in QuickBooks Online, or QBO, compares transactions recorded in a bank or credit-card register with an external statement for the same period. The user confirms the account, ending date and balance, matches cleared activity, investigates differences, and finishes when the difference is zero.

Current Intuit guidance states that QuickBooks saves a reconciliation report after completion. A connected bank feed can download activity, but the statement comparison remains a separate control.

Prepare before reconciling

• Obtain the complete bank or card statement.
• Confirm account, entity, currency, and statement dates.
• Review and match downloaded transactions.
• Enter supported fees, interest, returns, and transfers.
• Check the prior reconciliation and beginning balance.
• Resolve obvious duplicates before starting.

When months are behind, start with the oldest unreconciled statement. A later beginning balance depends on earlier completed periods.

QBO reconciliation steps

1. Open the current reconciliation area and select the correct account.
2. Review the last statement ending date.
3. Enter the statement ending date and ending balance exactly.
4. Start the reconciliation and compare statement activity with QBO.
5. Select transactions that cleared within the statement period.
6. Research missing, duplicate, misdated, or altered items.
7. Confirm valid outstanding items remain uncleared.
8. Continue until the cleared balance agrees and difference is zero.
9. Finish and retain the report with the statement.

Menus and assisted features can change. Use current Intuit support for the interface path and preserve the control objective.

Matching before reconciliation

If a downloaded line represents an invoice payment, bill payment, check, expense, deposit, or transfer already recorded, match it rather than adding another entry. One combined statement deposit may need several customer payments grouped through Undeposited Funds.

A feed status is not the same as reconciliation status. The bank-feed review determines how activity enters the books; reconciliation determines whether the register agrees with the statement.

Beginning balance problems

The beginning balance usually carries from the prior completed reconciliation. If it changed, a reconciled transaction may have been edited, deleted, re-dated, moved to another account, duplicated, or changed from reconciled to uncleared.

Review reconciliation history, discrepancy information, audit history, and the prior report. Correct the supported transaction rather than entering a balancing amount without explanation.

Ending difference research

• Confirm the ending date and balance entered from the statement.
• Compare deposits and withdrawals separately.
• Search exact difference amounts and likely combinations.
• Check bank fees, interest, returns, and automatic payments.
• Look for duplicates created from downloaded activity.
• Check wrong account, wrong sign, wrong date, and transposed digits.
• Review outstanding checks and deposits in transit.

Intuit’s current difference guidance includes opening and ending balance review, combined deposits, missing transactions, and transactions absent from the statement. Use source evidence for every correction.

Outstanding transactions

A valid check, payment, or deposit may be in QBO but not on the statement by the closing date. Leave it uncleared, list it on the reconciliation, and confirm it clears later. Age stale items and investigate failed deposits, stopped payments, duplicates, or unclaimed obligations.

Statement attachments

Some supported banks can make statements available through QuickBooks, and Intuit also documents attaching a statement when completing reconciliation. Availability varies. Retain the official statement under the business’s record policy even when QBO stores an attachment.

Reconciliation reports

After finishing, review the report for the account, period, beginning and ending balances, cleared and uncleared transactions, and any adjustment. Save a period-end copy because later changes can affect what a current report displays.

The reviewer should compare the report with the statement and inspect old outstanding items, unusual changes, and manual adjustments.

Adjustments

Do not use a reconciliation adjustment merely to reach zero. Exhaust statement setup, duplicates, missing entries, wrong accounts, dates, signs, transfers, and prior changes. A justified residual adjustment needs purpose, support, materiality, approval, and financial-statement review.

What zero does not prove

A transfer recorded as revenue, a loan payment recorded entirely as expense, or an owner deposit recorded as sales can all clear the bank. After reaching zero, review transaction classification and documentation.

Credit-card and clearing accounts

QBO reconciliation can also apply to credit-card accounts with issuer statements. Match purchases, fees, interest, refunds, credits, and payments. A card payment is usually a transfer from cash that reduces the liability when the purchases were already recorded, not a second expense.

Payment processors and merchant accounts may require a separate clearing-account reconciliation. Tie gross sales, fees, refunds, disputes, reserves, and net bank deposits to the processor statement. Reconciling only the checking account can leave the processor balance wrong.

Reviewer checklist

The reviewer should verify account and period, obtain or confirm the statement, compare ending balances, inspect the zero difference, review old outstanding items and adjustments, and check prior-period changes. Save evidence of review rather than relying on a verbal confirmation. Follow up in the next period to confirm significant outstanding checks, deposits, and transfers cleared as expected, with documented owners and firm deadlines for exceptions.

Common QBO mistakes

• Reconciling to the live online balance instead of the statement.
• Adding downloaded items that should be matched.
• Combining several statement periods.
• Marking valid outstanding items as cleared.
• Deleting a difference without tracing the source.
• Editing closed transactions without review.
• Finishing with an unsupported adjustment.

Review bank-statement reconciliation and the QuickBooks reconciliation statement. For help with QBO setup and close, explore QuickBooks services.