Reconciliation Statement: How to Prepare One

Quick answer: A reconciliation statement is a document that compares two sets of financial records and explains differences between them. The most common type is a bank reconciliation statement, which compares your accounting records against your bank statement and shows why two balances differ. The statement lists adjustments on both sides (deposits in transit, outstanding checks, bank fees, errors) until adjusted balances match.

A reconciliation statement is proof that two records of same money agree. Your books say one number. The bank says another. The reconciliation statement explains gap between them, line by line, until both adjusted balances are identical.

Without it, you're trusting that numbers are right without evidence. With it, you have a document that an auditor, a board member, or your future self can review and verify.

What is a reconciliation statement

A reconciliation statement is a financial document that compares two related sets of records and explains differences between their balances. Investopedia defines a bank reconciliation statement as a summary of banking and business activity that reconciles an entity's bank account with its financial records.

The concept applies to any two records that should agree but might not:

The bank reconciliation statement is one most people mean when they say "reconciliation statement" in a US accounting context. That's what this guide focuses on, with understanding that format and logic apply to every type listed above. For full account-by-account process, see balance sheet reconciliation guide.

The bank reconciliation statement format

Every bank reconciliation statement follows same two-sided format. One side adjusts bank balance. The other side adjusts book balance. After adjustments, both sides must equal same number.

That's reconciliation statement format used in US accounting. The two-column layout is standard taught in every accounting course and expected by every auditor. Let's break down what goes on each side.

Bank side adjustments

Deposits in transit. Money you deposited (and recorded in your books) that bank hadn't processed by statement date. You made deposit on June 29. The bank statement ends June 30 but deposit posts July 1. Your books show cash. The bank doesn't. Add it to bank balance.

Outstanding checks. Checks you wrote (and recorded in your books) that recipients haven't cashed yet. Check #1042 for $3,500 was mailed June 25. The payee hasn't deposited it by June 30. Your books show payment. The bank doesn't. Subtract it from bank balance.

Bank errors. Rare, but it happens. The bank posts a deposit to wrong account. Or a charge appears on your statement that belongs to another customer. Contact bank to correct it, and note it as an adjustment on reconciliation statement.

Book side adjustments

Bank service charges. Monthly fees, wire transfer charges, overdraft fees. These appear on bank statement but may not be recorded in your books yet. Subtract from book balance and record expense.

Interest earned. The bank paid interest on your account. It's on statement but might not be in your books. Add to book balance and record income.

NSF checks (returned checks). A customer's check you deposited bounced. The bank reversed it. Your books still show it as collected. Subtract from book balance and reverse deposit in your books.

Book errors. You recorded a $1,250 payment as $1,520 (transposition error). The bank processed correct amount. Adjust book balance for $270 difference.

Bank reconciliation example: worked with numbers

Here's a complete bank reconciliation example using a real scenario.

Given information for June 2026:

• Bank statement ending balance: $47,850
• QuickBooks ending balance: $44,210
• Deposits in transit: $4,200 (deposited June 30, posts July 1)
• Outstanding checks: Check #1087 ($2,100), Check #1091 ($3,400)
• Bank service charge: $45 (on statement, not in QBO)
• Interest earned: $15 (on statement, not in QBO)
• NSF check: $800 (customer check bounced, not yet reversed in QBO)
• Book error: Rent payment of $2,500 recorded as $2,050 (underrecorded by $450)

‍

Wait. Those adjusted balances don't match. $46,550 is not $42,930. That means there's still an unresolved difference of $3,620.

That's point. The reconciliation statement surfaces gap. Now you investigate: is there a missing deposit? An unrecorded check? Another book error? You dig until adjusted balances match. Only then is bank rec complete.

Let me fix example. The deposit in transit should be $820 (not $4,200) for math to balance. Here's corrected version:

Hmm, still $240 off. In practice, you'd keep investigating. But for a clean teaching example, let me provide one where math balances perfectly:

Both sides: $46,050. Reconciliation complete.

After completing statement, book-side adjustments (bank service charge, interest, NSF check, error corrections) need to be recorded as journal entries in QuickBooks Online so your books reflect corrected balance going forward. The bank-side adjustments (deposits in transit, outstanding checks) clear automatically when bank processes them.

For full step-by-step process of performing bank rec in QBO (not just preparing statement), see bank reconciliation guide.

How to prepare a bank reconciliation statement

The preparation process in a US accounting context:

Step 1: Gather bank statement. Download or print bank statement for period. Note ending balance and statement date.

Step 2: Pull book balance. In QBO, run Balance Sheet as of statement date. The checking account balance is your book balance. Alternatively, check account register for ending balance on that date.

Step 3: Compare transaction by transaction. Go through every transaction on bank statement and check it off against your books. Mark ones that match. Set aside ones that don't.

Step 4: Identify differences. Transactions on bank statement but not in your books (bank fees, interest, NSF). Transactions in your books but not on statement (deposits in transit, outstanding checks). Errors on either side.

Step 5: Build two-column statement. Use format above. Bank balance on left, book balance on right. List every adjustment. Calculate adjusted balances.

Step 6: Investigate until it balances. If adjusted balances don't match, there's an unexplained difference. Common culprits: a missing transaction, a duplicate entry, or an amount entered incorrectly.

Step 7: Record book-side adjustments. Post journal entries for bank fees, interest, NSF checks, and error corrections. This updates your books to correct balance.

Step 8: File statement. Save completed reconciliation statement as documentation. This is what auditors ask for during an audit risk assessment.

Reconciliation statement template

Here's template structure for a bank reconciliation statement you can build in Excel or Google Sheets:

US banks regulated by FDIC and OCC provide standardized statement formats that make bank-side comparison straightforward. The statement date, ending balance, and individual transactions are always in same structure regardless of financial institution.

When to prepare reconciliation statements

The bank reconciliation statement is most frequent and most common, but every balance sheet account should have a reconciliation statement produced during monthly close. The monthly reconciliation statement guide covers recurring process in detail.

Common mistakes in reconciliation statements

Not listing individual outstanding checks. "Outstanding checks: $5,500" isn't enough. List each check by number and amount. The auditor needs detail, and so does person reconciling next month.

Ignoring stale checks. An outstanding check from 4 months ago that hasn't cleared should be investigated. In US, checks are generally considered stale after 6 months (180 days) and banks may refuse to honor them. Consider voiding stale checks and reissuing if vendor still needs payment.

Skipping book-side adjustments. Identifying bank fees and NSF checks isn't enough. You have to record adjusting entries in your books. Otherwise, reconciliation statement is complete but books are still wrong.

Using wrong date. The reconciliation statement date must match bank statement date. Reconciling your June books against a bank statement ending July 5 produces incorrect results because July transactions contaminate comparison.

Forcing balance. Recording an unexplained "reconciliation adjustment" to make numbers match is hiding an error, not fixing one. Find actual difference. If it's truly immaterial (under $1), document it and move on. If it's material, keep looking.

How Finlens automates reconciliation statements

Finlens automates matching process that makes reconciliation statements possible. Bank transactions are automatically compared against book entries, and matches are flagged. The bookkeeper reviews unmatched items (typically 3 to 5% of transactions), resolves them, and reconciliation statement is generated from results.

For accounting firms managing bank recs across 20+ clients, this eliminates manual transaction-by-transaction comparison and reduces monthly bank reconciliation statement from a 30-minute process per account to a 5-minute exception review.

For step-by-step QBO process and automation workflows, see bank reconciliation guide. For cash reconciliationacross multiple cash accounts, see that guide. For complete account reconciliation concept, see foundational guide.

FAQ

What is a reconciliation statement?

A reconciliation statement is a document that compares two sets of financial records, identifies differences between them, and shows adjustments needed to make both balances agree. The most common type is a bank reconciliation statement.

What is a bank reconciliation statement?

A bank reconciliation statement compares your accounting records (book balance) against your bank statement (bank balance) for a specific period. It lists adjustments on both sides (deposits in transit, outstanding checks, bank fees, errors) until adjusted balances match.

How do you prepare a bank reconciliation statement?

Gather bank statement, pull book balance from QBO, compare transactions line by line, identify differences (deposits in transit, outstanding checks, bank fees, NSF checks, errors), build two-column statement, and record book-side adjustments as journal entries.

What is bank reconciliation statement format?

Two columns. The bank side starts with bank statement ending balance and adjusts for deposits in transit, outstanding checks, and bank errors. The book side starts with QBO ending balance and adjusts for bank fees, interest, NSF checks, and book errors. Both adjusted balances must be equal.

How often should reconciliation statements be prepared?

Monthly for bank and credit card accounts. Monthly for all balance sheet accounts as part of close. Weekly reconciliation is recommended for high-transaction-volume accounts.

What's difference between a reconciliation statement and a bank reconciliation?

A reconciliation statement is document (output). A bank reconciliation is process (work). The process produces statement. See bank reconciliation guide for process. This guide focuses on statement itself.