Bank Reconciliation โ Smart Financial Analysis
Financial Detective โ Find every missing dollar. Reconcile your cash book with bank statements, catch errors and fraud.
Did our AI summary help? Let us know.
Bank reconciliation is the process of matching your company's cash book (internal records) with the bank statement. Outstanding checks are checks you have written and recorded in your books but that have not yet been cashed or cleared by the bank. Deposits in transit are deposits you have recorded in your books but that have not yet been processed and credited by the bank. 1) Compare bank statement to cash book.
Ready to run the numbers?
Why: Bank reconciliation is the process of matching your company's cash book (internal records) with the bank statement. It ensures your books match the bank โ the most fundamen...
How: Enter Book Balance ($), Bank Statement Balance ($), Outstanding Checks ($) to get instant results. Try the preset examples to see how different scenarios affect the outcome, then adjust to match your situation.
Run the calculator when you are ready.
๐ Scenario Examples โ Click to Load
Starting Balances
The 5 Usual Suspects
Reconciliation Waterfall (Bank Balance Adjustments)
Discrepancy Breakdown
Monthly Reconciliation Trend
Outstanding Items Aging
For educational purposes only โ not financial advice. Consult a qualified advisor before making decisions.
๐ก Money Facts
Bank Reconciliation analysis is used by millions of people worldwide to make better financial decisions.
โ Industry Data
Financial literacy can increase household wealth by up to 25% over a lifetime.
โ NBER Research
The average American makes 35,000 financial decisions per yearโmany can be optimized with calculators.
โ Cornell University
Globally, only 33% of adults are financially literate, making tools like this essential.
โ S&P Global
Bank reconciliation ensures your books match the bank โ it's the most fundamental internal control in accounting. The process: start with bank statement balance, subtract outstanding checks, add deposits in transit โ adjusted bank balance should equal adjusted book balance. 60% of small businesses that fail had poor cash management โ bank reconciliation catches errors, fraud, and unauthorized transactions. Common discrepancies: outstanding checks (issued but not cashed), deposits in transit (deposited but not processed), bank fees, NSF checks, and recording errors. GAAP recommends monthly reconciliation.
Sources: AICPA, GAAP, QuickBooks, Journal of Accountancy.
Key Takeaways
- โข Adjusted bank balance must equal adjusted book balance
- โข Common differences: outstanding checks, deposits in transit, bank fees, errors
- โข Reconciliation should be done monthly โ the longer you wait the harder it gets
- โข SOX compliance requires documented reconciliation for public companies
Did You Know?
How It Works
Reconciliation Process
Compare bank statement to cash book, add deposits in transit, subtract outstanding checks, adjust for fees and interest, correct errors.
Common Discrepancies
Outstanding checks, deposits in transit, bank fees, interest, book errors, bank errors. Timing items clear next period; errors require correction.
Month-End Close
Reconcile promptly, document adjustments, segregate duties, keep records for audit.
Tips
- โข Reconcile promptly after receiving the bank statement โ don't let it pile up
- โข If the difference is divisible by 9, suspect a transposition error (e.g., $540 vs $450)
- โข The person who handles cash should not reconcile โ segregation of duties reduces fraud
- โข Void or follow up on checks outstanding more than 6 months (stale checks)
Reconciliation Item Types
| Item Type | Adjust Bank | Adjust Book | Notes |
|---|---|---|---|
| Outstanding Checks | Subtract | โ | Written, not yet cleared |
| Deposits in Transit | Add | โ | Recorded, not yet by bank |
| Bank Fees | โ | Subtract | Service charges |
| Interest Earned | โ | Add | Credited by bank |
| Book Errors | โ | Add/Subtract | Correct your records |
| Bank Errors | Add/Subtract | โ | Contact bank to correct |
Frequently Asked Questions
What is bank reconciliation?
Bank reconciliation is the process of matching your company's cash book (internal records) with the bank statement. It ensures your books match the bank โ the most fundamental internal control in accounting. Start with bank statement balance, subtract outstanding checks, add deposits in transit. The adjusted bank balance should equal adjusted book balance. 60% of small businesses that fail had poor cash management.
What is a bank reconciliation statement?
A bank reconciliation statement is a document that explains the differences between the balance shown on your bank statement and the balance in your cash book. It lists adjustments such as outstanding checks, deposits in transit, bank fees, interest earned, and errors. The goal is to reconcile both balances to the same figure.
What are outstanding checks?
Outstanding checks are checks you have written and recorded in your books but that have not yet been cashed or cleared by the bank. They reduce your actual available balance. On the bank reconciliation, you subtract outstanding checks from the bank statement balance to arrive at the adjusted bank balance.
What are deposits in transit?
Deposits in transit are deposits you have recorded in your books but that have not yet been processed and credited by the bank. They increase your actual balance. On the bank reconciliation, you add deposits in transit to the bank statement balance to arrive at the adjusted bank balance.
By the Numbers
Sources
- โข AICPA โ Accounting standards and best practices
- โข GAAP โ Generally Accepted Accounting Principles
- โข QuickBooks โ Reconciliation workflows
- โข Journal of Accountancy โ Reconciliation guidance
Disclaimer: This calculator is for educational purposes. Consult a CPA or accounting professional for official reconciliation and audit requirements. Not a substitute for professional advice.
Related Calculators
Adding Machine Calculator
Virtual adding machine with running paper tape, memory functions, subtotals, and tax calculations. Print or copy the tape for your records.
FinanceWorking Capital Calculator
Calculate and analyze your company's working capital with comprehensive cash flow analysis, industry benchmarks, forecasting scenarios, and optimization strategies. Features advanced ratio analysis, visualization tools, and actionable recommendations for improved financial management.
FinanceInternal Rate of Return Calculator
Calculate the internal rate of return (IRR) for an investment based on its initial cost and projected cash flows.
FinanceInternal Rate of Return (IRR) Calculator
Calculate the Internal Rate of Return (IRR) for any series of cash flows. Analyze investment profitability with detailed visualizations.
FinancePayback Period Calculator
Calculate how long it takes for an investment to recover its initial cost using standard and discounted payback methods.
FinanceCash Ratio Calculator
Calculate and analyze your company's cash ratio with advanced industry benchmarking, trend analysis, and actionable recommendations for optimal liquidity management.
Finance