Two terms appear constantly in accounting: "bank statement reconciliation" and "account reconciliation." They're related but not interchangeable. Beginners use them synonymously. Auditors and accountants use them precisely. Getting the distinction right matters more at year-end, audit time, or during a business financing process — when someone asks you to "reconcile your accounts" and they mean all of them.
This guide defines both terms clearly, explains the differences with real examples, and walks through the complete reconciliation process for both scenarios.
Definitions: What Each Term Actually Means
Bank Statement Reconciliation
Bank statement reconciliation (often shortened to "bank rec" or "bank reconciliation") is the process of comparing your internal bookkeeping records for a specific bank account against the bank's own statement for that account, for the same period, and explaining every difference between the two balances.
The goal is to arrive at two adjusted balances — one starting from your books, one starting from the bank statement — that agree with each other. The differences are explained by timing items (deposits you recorded that the bank hasn't posted yet, checks you wrote that haven't been cashed) and recording differences (bank fees, interest, errors).
Account Reconciliation
Account reconciliation is a broader term. It means verifying that any balance sheet account balance in your records is accurate, supportable, and can be traced to underlying source documents. Bank reconciliation is one specific type of account reconciliation — applied to the cash/bank account line on the balance sheet.
Other accounts that get reconciled as part of a full account reconciliation:
- Accounts Receivable: The AR balance should reconcile to an aged receivables report — every dollar owed should be traceable to an outstanding invoice.
- Accounts Payable: Every dollar owed should match an unpaid vendor invoice or bill.
- Inventory: The inventory balance should reconcile to a physical count or perpetual inventory system.
- Fixed Assets: The asset balance should reconcile to an asset register (list of all assets, acquisition costs, and accumulated depreciation).
- Prepaid Expenses and Accrued Liabilities: Each balance should reconcile to the underlying contracts or calculations.
Why the Distinction Matters
The confusion between these terms causes real problems in practice:
| Scenario | What Was Said | What Was Meant | Risk of Confusion |
|---|---|---|---|
| Bank loan application | "Please provide reconciled financial statements" | All balance sheet accounts reconciled (full account rec) | Submitting only bank-reconciled statements misses AR/AP/inventory issues |
| Year-end audit | "We need account reconciliations for all balance sheet items" | Supporting schedules for every balance sheet line | Only providing bank rec leaves the auditor with unverified AR, AP, inventory balances |
| Monthly bookkeeping | "Did you reconcile the accounts?" | Usually means bank accounts only (informal usage) | Low risk — context usually clear |
| Controller review | "The accounts aren't reconciled" | Full balance sheet reconciliation | High — could mean anything from bank rec missing to no supporting schedules for any account |
The practical rule: when someone in a formal accounting context (audit, financing, tax) asks you to "reconcile accounts," assume they mean all balance sheet accounts unless they specifically say "bank reconciliation."
The Bank Reconciliation Formula
The reconciliation formula is the mathematical foundation of the bank rec. There are two sides — the book side and the bank side — and both must arrive at the same adjusted balance.
Common Reconciling Items Explained
Reconciling items are the specific differences between your book balance and the bank statement balance. They fall into two categories: normal timing differences (expected and harmless) and recording differences (require a journal entry to fix).
Normal Timing Differences
Deposits in Transit Book only
A deposit you've recorded in your books but that hasn't yet appeared on the bank statement. Classic example: you deposit a check at 4:30 PM on a Friday. Your books record it that day. The bank doesn't post it until Monday morning — so it doesn't appear on the Friday statement. It's not an error; it's just a timing difference. It will appear on next month's statement as a cleared deposit.
Outstanding Checks Book only
Checks you've written and recorded as expenses in your books, but that the payee hasn't cashed yet. The amount is deducted from your book balance but still appears in the bank's records. Outstanding checks are the most common reconciling item. They clear when the payee deposits them — which might be days, weeks, or occasionally months after you write the check.
Recording Differences (Require Journal Entry)
Bank Service Charges Bank only
Monthly account maintenance fees, wire transfer fees, NSF processing fees, and other charges the bank deducts directly from your account. These appear on the bank statement but you haven't recorded them as expenses in your books yet. You need a journal entry: debit Bank Charges (expense), credit Cash. Once recorded, your book balance decreases to match.
Interest Earned Bank only
Interest the bank credits to your account — common on interest-bearing checking accounts and savings accounts. The bank adds this to your balance; your books don't know about it until you record it. Journal entry: debit Cash (increases your book balance), credit Interest Income. Small amounts ($2–$15 on most business accounts), but required for accurate reconciliation.
NSF (Non-Sufficient Funds) Returned Checks Bank only
You deposited a customer's check, recorded it as a payment received (increasing your book balance), and the bank posted the deposit. Then the check bounced — the bank reversed the deposit, reducing your balance by the check amount plus an NSF fee. Your books still show the deposit as received. You need to reverse the original deposit entry and record the NSF fee. The receivable goes back to AR — the customer still owes you.
Book Errors Book only
Mistakes in your own records — the most common being transposition errors (recording $654 as $645, or $1,350 as $1,530). Also includes recording the same transaction twice, recording a transaction to the wrong account (doesn't affect the bank balance but does affect the category), or forgetting to record a transaction. Journal entry required to correct. Book errors explain differences that are exactly $X or exactly 2×$X (the doubled-entry version of a transposition).
Bank Errors Bank only
Rare, but real. The bank posts the wrong amount, applies a transaction to the wrong account, or posts a duplicate entry. If you find what appears to be a bank error, document it immediately with screenshots and the statement page, then call the bank. Banks correct errors but require timely notification — most have a 60-day window to dispute statement errors. Do not adjust your books for a bank error; wait for the bank to correct the statement.
Step-by-Step Bank Reconciliation Process
- Gather both records. You need: (1) the bank statement for the period (the one you downloaded or received in the mail), and (2) your bookkeeping records for the same account and same period — this is the general ledger, QuickBooks transaction list, or Excel ledger showing every transaction and the ending book balance.
- Note both ending balances. Write down the statement ending balance (from the bank statement) and your book ending balance (from your records). These will almost certainly differ. That's the difference you're about to explain.
- Mark cleared transactions. Go through the bank statement line by line. For each transaction on the statement, find the corresponding entry in your books and mark it as "cleared" (checkmark, highlight, or flag in your system). Cleared = it's on the statement AND in your books.
- Identify outstanding checks. Any check you recorded in your books that is NOT on the bank statement = outstanding check. List each one: check number, date, payee, amount. Sum them up.
- Identify deposits in transit. Any deposit you recorded in your books that is NOT on the bank statement = deposit in transit. List each one: date, source, amount. Sum them up.
- Identify bank-only items. Any transaction on the bank statement that is NOT in your books = recording difference. Common items: service fees, interest earned, NSF returned checks, ACH debits you didn't know about. List each. You'll need to record journal entries for these.
- Record journal entries for bank-only items. For service charges: debit Bank Charges, credit Cash. For interest earned: debit Cash, credit Interest Income. For NSF checks: reverse the original deposit entry. After these entries, your book balance changes.
- Correct any book errors found. If you spot a transposition or duplicate entry in your books, correct it with an adjusting journal entry. This changes your book balance.
- Calculate adjusted balances. Book side: Book balance ± journal entries = Adjusted book balance. Bank side: Bank balance + Deposits in transit - Outstanding checks = Adjusted bank balance.
- Verify they match. Adjusted book balance = Adjusted bank balance. If they're equal, the reconciliation is complete. If not, return to step 3 — something was missed or calculated wrong.
Reconciliation in Excel
For simple accounts or bookkeepers who prefer working outside of accounting software, Excel handles bank reconciliation effectively.
The Two-Column Matching Approach
Place your bank statement transactions in column A (Date, Description, Amount) and your bookkeeping ledger transactions in column B (same columns). The goal is to match each transaction in A to a transaction in B.
Use MATCH to find corresponding amounts:
Rows returning "NOT FOUND" on the bank side are in your books but not on the statement (outstanding checks or deposits in transit). Rows returning "NOT FOUND" on the books side are on the statement but not in your books (fees, interest, NSF items — need journal entries).
Conditional Formatting to Highlight Unmatched
Select the Amount column → Conditional Formatting → New Rule → "Use a formula" → enter your MATCH formula → set fill color to orange for unmatched items. Matched transactions appear normal; unmatched appear highlighted — your reconciling items are visually obvious.
Reconciliation Summary Section
Create a summary section below the transaction lists:
+ Deposits in Transit: $1,200.00
- Outstanding Checks: -$850.00
= Adjusted Bank Balance: $12,800.00
Book Balance: $12,920.00
- Bank Service Charges: -$120.00
= Adjusted Book Balance: $12,800.00
Difference: $0.00 ✓
Reconciliation in QuickBooks Online
QuickBooks Online has built-in reconciliation that automates much of the manual process — especially transaction matching.
- Go to Accounting → Reconcile. Select the account you want to reconcile from the dropdown (e.g., "Business Checking - Chase").
- Enter statement information. Enter the Ending Balance from your bank statement and the Statement Ending Date. Click Start Reconciling.
- Match transactions. QBO shows two lists: Payments and Credits (left), Deposits (right). Each item has a checkbox. Check off each transaction that appears on your bank statement. As you check items, the "Difference" counter updates.
- Work toward $0 difference. When all cleared transactions are checked and the Difference = $0, you're done. Click Finish Now.
- Handle unmatched items before finishing. If the difference isn't $0, unchecked items on your QBO list are outstanding (not yet cleared). Review to confirm they're genuinely outstanding (outstanding checks) vs. errors or missing transactions. Items on the statement but not in QBO need journal entries before you can reconcile to $0.
How Often to Reconcile
| Account Type | Recommended Frequency | Why |
|---|---|---|
| Active business checking (100+ tx/month) | Weekly or with each statement | Errors compound quickly; fraud is caught sooner; review queue stays manageable |
| Moderate business checking (30–100 tx/month) | Monthly — within 10 days of statement receipt | Standard — balances timeliness vs. frequency |
| Business savings / low-activity accounts | Monthly | Fewer transactions but still need to catch fees, interest, errors |
| Personal accounts (used by sole proprietors) | Monthly minimum | Mixed transactions require consistent review |
Red Flags During Reconciliation
- Difference equals exactly $X or exactly 2×$X. A difference of $100 often means $100 was entered once (missed transaction) or twice (duplicate entry). A difference of $189 that equals double of $94.50 suggests a transposition where a transaction was accidentally entered twice. Systematically: any difference that's divisible into a clean amount suggests a single-transaction error.
- Outstanding checks older than 6 months. A check from 8 months ago that still hasn't cleared is a stale check. In most US states, checks older than 180 days are "stale-dated" and banks may refuse to honor them. Additionally, uncashed checks above certain thresholds may need to be reported to the state as unclaimed property (escheatment).
- Deposits in transit for more than 5–7 business days. A deposit marked "in transit" for 2 weeks suggests it may not have actually been deposited (recording error), was deposited to the wrong account, or was a returned deposit that your books haven't captured yet.
- The same reconciliation difference every month. If you always have a $35 difference that you just accept and "force close" the reconciliation, stop. That recurring difference is a symptom — a missing recurring transaction, a bank fee you keep forgetting to record, or a systematic error. Find the root cause once and fix it permanently.
- Large unexplained adjustments. If someone has been closing reconciliations with large manual adjustments ("just make it balance"), those adjustments mask errors, missing transactions, or fraud. Reconciliation should never require an adjustment — every difference should be explainable as a specific transaction.
When to Call Your Accountant
Certain reconciliation situations call for professional judgment rather than continued self-investigation:
- Difference unexplained after 30 minutes. An experienced accountant can often spot a pattern in minutes that a business owner would spend hours on. At $150–$300/hour for accounting help, 30 minutes of professional time is cheaper than 3 hours of your own time.
- You've found what looks like a bank error. Don't just adjust your books. Document exactly what you found (statement amount vs. your records), then call your bank's business services line. If the bank confirms an error, they'll issue a correction entry. Your accountant can help prepare the journal entry to record the correction once the bank confirms it.
- Outstanding check older than 180 days. Escheatment rules vary by state but generally require businesses to report and surrender unclaimed funds held for 3–7 years. For checks you issued that were never cashed, your accountant knows the specific reporting requirements for your state.
- Pattern of small unauthorized transactions. Small amounts taken regularly (under $50) are a classic fraud signature — small enough to avoid casual review, large enough to add up significantly. If you find unexplained debits that follow a pattern, call your accountant and your bank simultaneously.
Get Your Bank Statements Ready for Reconciliation
Convert your bank statement PDF to CSV in 30 seconds — clean Date, Description, Debit, Credit, Balance columns ready for Excel or QuickBooks reconciliation.
Convert Statement Free →Frequently Asked Questions
What is the difference between bank reconciliation and account reconciliation?
Bank reconciliation is the process of comparing your internal bookkeeping balance for a bank account against the bank's statement balance and explaining every difference. Account reconciliation is broader — it means verifying any balance sheet account balance (AR, AP, inventory, fixed assets, prepaid expenses) is accurate and traceable to source documents. Bank reconciliation is one specific type of account reconciliation. When an auditor asks for "account reconciliations," they mean supporting schedules for every balance sheet line item, not just bank accounts.
What is the bank reconciliation formula?
Bank side: Bank Statement Balance + Deposits in Transit − Outstanding Checks = Adjusted Bank Balance. Book side: Book Balance − Bank Service Charges + Interest Earned ± Errors = Adjusted Book Balance. These two adjusted balances must be equal. They won't equal each other before adjustment — the unadjusted balances almost always differ. The goal is to show that all differences are explainable timing or recording items.
What are deposits in transit and outstanding checks?
Deposits in transit: you've recorded a deposit in your books (e.g., Friday afternoon check deposit), but it hasn't posted to the bank yet — so it's in your books but not on the statement. It will appear on next month's statement. Outstanding checks: you've written and recorded a check as an expense, but the payee hasn't cashed it yet — it's in your books but not on the statement. Both are normal timing differences, not errors. They're expected reconciling items and will clear in the following period.
How often should I reconcile my bank statements?
Monthly is the standard minimum for business accounts — reconcile within 10 business days of receiving the statement. For high-transaction accounts (100+ transactions/month) or accounts with high fraud risk, reconcile weekly. Never skip more than one month — a 2-month gap means deposits in transit and outstanding checks from month 1 compound with month 2's timing differences, making it exponentially harder to untangle. A 6-month backlog is a project, not a task.
What red flags should I watch for during bank reconciliation?
Key red flags: (1) Difference equals exactly $X or 2×$X — transposition error or duplicate entry. (2) Outstanding checks older than 6 months — stale checks, may need escheatment. (3) Deposits in transit older than 5–7 business days — possibly a recording error or returned deposit. (4) Same unexplained difference every month — a systematic issue hiding a recurring error. (5) Pattern of small unauthorized transactions — potential fraud. Any of these warrant investigation before closing the reconciliation.
When should I call my accountant about a reconciliation problem?
Call your accountant if: (1) The difference is unexplained after 30 minutes — professional time is usually cheaper than extended self-investigation. (2) You find what looks like a bank error — document it, contact the bank, and have your accountant prepare the correcting journal entry. (3) An outstanding check is more than 180 days old — escheatment rules may apply. (4) You find a pattern of small unexplained debits — potential fraud that needs immediate action from both the bank and possibly law enforcement.