QuickBooks Bank Reconciliation Statement: What It Shows

A QuickBooks bank reconciliation statement is the saved evidence that a QuickBooks bank-account balance was matched with a bank statement for a specific period. It explains which recorded transactions cleared, which valid items remained outstanding, and whether the matched balance agreed to the statement.

Current QuickBooks terminology often uses a reconciliation report rather than a standalone manually prepared statement. The accounting control is the same: beginning balance plus recorded activity, adjusted for timing and corrections, must reproduce the bank’s closing position with a zero reconciliation difference.

Illustrative reconciliation bridge

The example is illustrative. In QuickBooks, properly recorded statement items become part of the ledger, while valid outstanding items remain uncleared until a later statement.

What the final package should contain

• The complete bank statement and account identity.
• The final QuickBooks reconciliation report for the same ending date.
• Beginning and ending balances and a zero difference.
• Outstanding checks, payments, and deposits in transit.
• Support for bank fees, interest, returned items, and corrections.
• Explanation of old or unusual outstanding transactions.
• Preparer and reviewer names and completion dates.

Reconciliation report versus transaction report

A transaction report lists activity. A reconciliation report identifies the status of activity within a completed reconciliation and preserves the period result. A bank-feed screen shows downloaded items but does not prove agreement with a statement.

Save the final report soon after completion and protect previously reconciled transactions from unsupported edits. Product report availability and permissions may vary by QuickBooks version or plan.

Outstanding items

Deposits in transit and outstanding payments are timing differences recorded in the books but not yet shown by the bank as of the statement date. They should clear on later statements. Review stale items for duplicate entries, failed deposits, voids, unclaimed-property obligations, or other needed action.

Book corrections

Statement fees, interest, returned payments, and bank corrections may need to be recorded before completion. Classify each item according to its substance. Do not create a reconciliation adjustment simply because the current difference is inconvenient.

How to produce the report

1. Complete or match transactions through the statement date.
2. Select the correct account and enter the statement ending information.
3. Verify the beginning balance.
4. Match cleared deposits and withdrawals.
5. Record supported statement items missing from the books.
6. Investigate every remaining difference.
7. Finish at zero and save the final report and support.

Review questions

Does the report use the correct bank account and statement? Does the beginning balance connect to the previous period? Do the ending balance and date agree? Are outstanding items real, current, and supported? Were prior reconciled transactions changed? Do corrections have the correct account and approval?

Illustrative outstanding-item review

Age alone does not determine the accounting action. The reviewer evaluates the obligation, payment method, later clearing, correspondence, legal requirements, and whether the entry is duplicated or void.

Separation of duties

Where staffing allows, separate cash handling, transaction entry, reconciliation preparation, and review. The reviewer should receive statements independently of the preparer and inspect new vendors, electronic-payment changes, unusual transfers, manual checks, and transactions near period end.

A small owner-managed business may not have four people. The owner can perform a documented compensating review of statements, canceled-check images, deposits, outstanding items, and the final reconciliation report.

Changes after completion

If a reconciled transaction must change, record why, who approved it, which periods and reports are affected, and how the next beginning balance was restored. Reissue material reports when appropriate. Do not silently edit a closed cash period and leave the saved reconciliation inconsistent with the ledger.

How the schedule supports financial reporting

The adjusted book balance should agree to the general-ledger cash account and the balance sheet for the same entity, date, and basis. When several bank accounts exist, each reconciliation supports one ledger balance and the sum supports total cash, subject to presentation classifications.

Restricted cash, overdrafts, foreign-currency accounts, and cash held by processors may require separate presentation or schedules. Do not combine them merely to simplify reconciliation. Preserve the nature and ownership of each balance.

Label every supporting schedule with the same closing date.

Common errors

• Reconciling to a live online balance instead of the statement.
• Adding bank-feed items that already exist.
• Marking a transaction cleared solely to reach zero.
• Changing valid dates to force items into a period.
• Posting transfers as revenue or expense.
• Deleting stale items without resolving the underlying obligation.
• Saving no report or reviewer evidence.

Use the QuickBooks bank reconciliation FAQ for procedural questions and the general bank reconciliation guide for the control framework. For recurring support, review QuickBooks services.