Reconcile the bank with a live outstanding-items desk
Reconcile your statement ending balance against your GL book balance with live outstanding check tracking, deposits in transit, bank and book adjustments, variance detection, and dual sign-off.
1. Reconciliation Header & Balances
2. Outstanding Checks (Deducted from Bank)
| Check # * | Payee * | Check Date | Amount ($) * | Cleared? | Notes |
|---|
3. Deposits in Transit (Added to Bank)
| Deposit Ref * | Source / Description * | Deposit Date | Amount ($) * | Cleared? | Notes |
|---|
4. Bank & Book Adjustments
| Date | Description * | Side * | Type * | Amount ($) * | Effect * | Notes |
|---|
5. Formal Sign-Off & Period Lock
How the Bank Reconciliation Formula Works
A bank reconciliation ensures your general ledger cash balance reflects reality by proving that timing differences, bank charges, and unrecorded credits account for every dollar of difference between your monthly bank statement and internal book records.
• Adjusted Bank Balance = Statement Ending Balance + Deposits in Transit − Outstanding Checks ± Bank Net Adjustments
• Adjusted Book Balance = GL Book Cash Balance ± Book Net Adjustments
• Reconciliation Variance = Adjusted Bank Balance − Adjusted Book Balance (Target = $0.00)
Outstanding Checks vs. Deposits in Transit
Understanding the distinction between these two primary timing differences is fundamental to business accounting:
- Outstanding Checks (Uncleared Checks): Payments made to vendors, contractors, or employees that have been written and deducted in your general ledger, but have not yet processed through the banking system. Because the bank balance does not yet reflect these debits, they are subtracted from the bank statement ending balance.
- Deposits in Transit (Uncredited Deposits): Customer cash, check, or credit card payments received and recorded in your GL book before the statement cutoff date, but deposited or credited by the bank after the cutoff date. Because the bank balance is missing these deposits, they are added to the bank statement ending balance.
Common Causes of Variance & Adjusting Entries
When your initial statement balance minus book balance does not equal zero, common items requiring journal adjustments include:
- Bank Service Charges: Monthly maintenance fees, wire transfer fees, or check printing fees deducted directly by the bank. (Book adjustment: Decrease book cash, Debit Expense).
- Earned Interest: Interest income paid on business checking or money market accounts. (Book adjustment: Increase book cash, Credit Interest Income).
- NSF (Bounced) Checks: Customer checks deposited but returned unpaid due to non-sufficient funds. (Book adjustment: Decrease book cash, Debit Accounts Receivable).
- Encoding / Transposition Errors: Mistakes made by the bank or your bookkeeper (e.g., recording Check #1039 as $540.00 instead of $450.00). Depending on who made the error, adjust either the Bank side or Book side.
When to Reconcile Your Bank Accounts
US small businesses and accounting teams should execute bank reconciliations on two primary cadences:
- Month-End Close: Formal monthly reconciliation is mandatory before closing the GL, filing sales tax reports, or issuing monthly financial statements (P&L and Balance Sheet).
- Weekly / Bi-Weekly Cash Control: High-volume businesses (retail, e-commerce, restaurants) run weekly reconciliations to catch fraudulent check activity, wire errors, or uncollected deposits early.
Frequently Asked Questions
What is a bank reconciliation statement?
A bank reconciliation statement is an accounting schedule that proves your company cash ledger matches your bank statement ending balance after accounting for timing differences like outstanding checks, deposits in transit, bank fees, interest, and errors.
What is the difference between outstanding checks and deposits in transit?
Outstanding checks are payments written and recorded in your GL book that have not yet cleared the bank statement. Deposits in transit are funds received and recorded in your book that were deposited near month-end but have not yet appeared on the bank statement.
How do bank vs. book adjustments work?
Bank-side adjustments fix bank errors or uncredited items. Book-side adjustments record items on the bank statement that are not yet in your general ledger, such as monthly service charges, interest earned, NSF returned checks, and bank wire fees.
What causes a bank reconciliation variance?
A variance occurs when adjusted bank balance minus adjusted book balance does not equal $0.00. Common causes include unrecorded bank fees, unposted interest income, transposition errors in check entry, omitted deposits, or uncleared checks mistakenly marked as cleared.
Is my business bank account data saved on a server?
No. This bank reconciliation desk operates 100% client-side inside your web browser. Your entity name, account numbers, check amounts, and notes are never transmitted to any external server. Saved drafts stay strictly in your browser local storage.