Bank Reconciliation Statement: Step-by-Step Format with Solved Example
Bank Reconciliation Statement: Step-by-Step Format with Solved Example
Learn how to reconcile your Cash Book balance with the Bank Statement balance, handle timing differences, and record adjusting journal entries.
A Bank Reconciliation Statement (BRS) is an internal control report prepared to explain the difference between the cash balance shown on a company’s Cash Book (General Ledger) and the balance reported on its Bank Statement.
The differences fall into three categories: Timing differences (deposits in transit, outstanding checks), items known only by the bank (bank service fees, interest earned, NSF checks), and bookkeeping errors.
The 2-Section Reconciliation Framework
In standard accounting practice and on exams, the most widely accepted layout is the Adjusted Balance Method, which reconciles both the Bank Statement and the Cash Book to the exact same True Adjusted Cash Balance:
Master Adjustment Cheat Sheet: What Goes Where?
| Section | Add (+) | Deduct (−) |
|---|---|---|
| Bank Statement Side (Items company knows, but bank hasn’t processed yet) |
• Deposits in Transit: Cash collected and recorded by the business, but deposited after the bank statement cut-off. | • Outstanding Checks: Checks written and recorded by the business, but not yet presented to or cleared by the bank. |
| Company Books (Cash Book) Side (Items bank processed, but company hasn’t recorded yet) |
• Interest Earned on bank account. • Notes Receivable collected directly by the bank on your behalf. • Electronic funds transfers (EFT) received. |
• Bank Service Charges & Fees. • NSF Checks (Bounced Checks) from customers. • Auto-debit payments (utilities, loan payments). |
Full Worked Numerical Problem with Solution
Let’s solve an actual exam problem together step-by-step.
- Balance per Bank Statement: $15,800
- Balance per Cash Book (General Ledger): $14,250
- Deposit in Transit: $2,400 mailed to the bank on July 31, not yet on the bank statement.
- Outstanding Checks: Check #402 for $1,600 and Check #405 for $2,100 have not cleared.
- Bank Service Charge: The bank deducted a monthly maintenance fee of $50.
- Interest Earned: The bank credited $100 in interest to the account.
- NSF Check: A $300 check from customer J. Doe bounced due to insufficient funds.
The Bank Reconciliation Statement
| Bank Reconciliation Statement as of July 31 | Amount ($) | Total ($) |
|---|---|---|
| 1. Reconciliation of Bank Balance | ||
| Cash balance per Bank Statement | $15,800 | |
| Add: Deposit in Transit | $2,400 | |
| Subtotal: | $18,200 | |
| Less: Outstanding Checks (#402: $1,600 + #405: $2,100) | ($3,700) | |
| True Adjusted Bank Balance | $14,500 | |
| 2. Reconciliation of Cash Book (Company Records) | ||
| Cash balance per Cash Book | $14,250 | |
| Add: Interest Earned | $100 | |
| Subtotal: | $14,350 | |
| Less: Bank Service Charge | ($50) | |
| Less: NSF Check (Customer J. Doe) | ($300) | |
| True Adjusted Book Balance | $14,500 | |
Result: Both the Bank side and Book side equal $14,500. The reconciliation is complete!
Crucial Step: Adjusting Journal Entries
You ONLY record journal entries for items on the COMPANY (Book) side!
You do NOT make entries for outstanding checks or deposits in transit because the company already recorded them when the checks were issued or deposits were made. Only items the bank initiated (interest, service fees, NSF checks) must be entered into your general ledger.
| Date | Account Title & Explanation | Debit ($) | Credit ($) |
|---|---|---|---|
| July 31 | Cash (To record interest earned credited by the bank) |
100 | – |
| Interest Revenue | – | 100 | |
| July 31 | Bank Fees Expense (To record monthly bank maintenance charge) |
50 | – |
| Cash | – | 50 | |
| July 31 | Accounts Receivable (J. Doe) (To restore receivable for NSF bounced check) |
300 | – |
| Cash | – | 300 |
Frequently Asked Questions (FAQ)
How often should a business reconcile its bank account?
Companies should reconcile bank statements monthly at a minimum. High-transaction businesses perform daily or weekly reconciliations using automated bank feeds in modern accounting software.
What is a stale-dated check?
A stale-dated check is an outstanding check that has not been presented for payment within six months of its date. Banks are generally not obligated to cash it, and the company should reverse the check entry.
Why is an NSF check deducted from the cash book?
When the customer originally paid you, you debited Cash and deposited the check. When the check bounced due to non-sufficient funds, the bank subtracted the money from your account. Therefore, you must deduct it from your Cash Book and reinstate the customer’s Accounts Receivable balance.
Practice more accounting problems
Check our free interactive flashcards and problem-solving guides.