Accounting learning tool
Bank Reconciliation Calculator
Reconcile book and bank cash balances after timing differences, fees and interest.
Inputs and results stay in this browser. Currency symbols are illustrative; use any consistent currency.
Understand Bank reconciliation
One idea, three depths
Choose how deeply to explain Bank reconciliation
Bank reconciliation: Reconcile book and bank cash balances after timing differences, fees and interest.
Age 5Explain it to a 5-year-oldStart with a picture
Imagine using Bank reconciliation to answer this question: reconcile book and bank cash balances after timing differences, fees and interest? Enter Cash balance in books, Cash balance on bank statement, Deposits in transit, and 3 other inputs; the calculator shows Unreconciled difference. Try changing one number and watch what happens to Unreconciled difference. The answer tells you Unreconciled difference.
Age 15Explain it to a 15-year-oldConnect it to the formula
A reconciliation separates timing differences from transactions missing in the ledger. The two adjusted balances should agree before the period is closed. The rule is Adjusted bank = bank + deposits in transit − outstanding checks; adjusted books = books − fees + interest. Its input values are Cash balance in books, Cash balance on bank statement, Deposits in transit, Outstanding checks, Unrecorded bank fees, Unrecorded bank interest, and the main result is Unreconciled difference. Try changing one number and watch what happens to Unreconciled difference.
CollegeExplain it at college levelState the model precisely
This calculator evaluates one accounting relationship within a consistent entity, currency, reporting period and recognition policy. The implemented relation is Adjusted bank = bank + deposits in transit − outstanding checks; adjusted books = books − fees + interest, evaluated from Cash balance in books, Cash balance on bank statement, Deposits in transit, Outstanding checks, Unrecorded bank fees, Unrecorded bank interest to produce Unreconciled difference. A reconciliation separates timing differences from transactions missing in the ledger. The two adjusted balances should agree before the period is closed. Recognition, measurement, tax, consolidation, foreign-currency and disclosure rules may require adjustments under the accounting framework that applies to the entity.
What this accounting tool does
Reconcile book and bank cash balances after timing differences, fees and interest.
Why the relationship works
A reconciliation separates timing differences from transactions missing in the ledger. The two adjusted balances should agree before the period is closed.
The accounting formula
Adjusted bank = bank + deposits in transit − outstanding checks; adjusted books = books − fees + interest
Inputs and period consistency
This model uses Cash balance in books, Cash balance on bank statement, Deposits in transit, Outstanding checks, Unrecorded bank fees, Unrecorded bank interest. Use the same reporting period, currency, entity boundary and accounting policy for every input.
What the result means
The primary output is Unreconciled difference; supporting outputs include Adjusted bank balance, Adjusted book balance, Book adjustment required. Trace each amount back to the relevant ledger or statement line before relying on it.
Limits of this compact model
The calculator teaches one relationship. Recognition, measurement, tax, consolidation, foreign-currency and disclosure rules may require additional adjustments under the framework that applies to the entity.
Supporting sourcesAcademic referencesPrimary standards, textbooks and complete citations
Standards, reading and academic references
Use the calculator as the worked interaction, then consult the primary standards and academic textbooks listed below. MW SysArc links to the original sources; the explanation on this page is original and does not reproduce them.
Principles of Accounting, Volume 1: Financial Accounting
Read the free OpenStax financial accounting textbookCite this book
- APA 7
- Franklin, M., Graybeal, P., & Cooper, D. (2019). Principles of accounting, volume 1: Financial accounting. OpenStax. https://openstax.org/books/principles-financial-accounting/pages/1-why-it-matters
- MLA 9
- Franklin, Mitchell, et al. Principles of Accounting, Volume 1: Financial Accounting. OpenStax, 2019, https://openstax.org/books/principles-financial-accounting/pages/1-why-it-matters.
- Chicago author-date
- Franklin, Mitchell, Patty Graybeal, and Dixon Cooper. 2019. Principles of Accounting, Volume 1: Financial Accounting. Houston, TX: OpenStax. https://openstax.org/books/principles-financial-accounting/pages/1-why-it-matters.
OpenStax entries are free to read online. Follow the licence shown on each linked source before redistributing or adapting its content.
Reuse the page responsiblyCite this pageAPA, MLA, Chicago, Harvard, BibTeX and RIS
These formats cite this calculator page itself. They are separate from the academic references above, which support the mathematical method and terminology.
APA 7
MW SysArc. (2026, July 21). Bank Reconciliation Calculator. MW SysArc Tools. https://accounting.mwsysarc.com/bank-reconciliation-calculator
MLA 9
MW SysArc. “Bank Reconciliation Calculator.” MW SysArc Tools, 21 July 2026, https://accounting.mwsysarc.com/bank-reconciliation-calculator. Accessed 26 Aug. 2026.
Chicago 17
MW SysArc. “Bank Reconciliation Calculator.” MW SysArc Tools. Published July 21, 2026. Accessed August 26, 2026. https://accounting.mwsysarc.com/bank-reconciliation-calculator.
Harvard
MW SysArc (2026) ‘Bank Reconciliation Calculator’, MW SysArc Tools. Published 21 July 2026. Available at: https://accounting.mwsysarc.com/bank-reconciliation-calculator (Accessed: 26 August 2026).
BibTeX and RIS records
BibTeX
@misc{mwsysarc_bank_reconciliation_2026,
author = {{MW SysArc}},
title = {Bank Reconciliation Calculator},
howpublished = {MW SysArc Tools},
year = {2026},
url = {https://accounting.mwsysarc.com/bank-reconciliation-calculator},
note = {Published July 21, 2026; accessed August 26, 2026}
}RIS
TY - ELEC
AU - MW SysArc
TI - Bank Reconciliation Calculator
T2 - MW SysArc Tools
PY - 2026
DA - 2026-07-21
Y2 - 2026-08-26
UR - https://accounting.mwsysarc.com/bank-reconciliation-calculator
N1 - Published July 21, 2026
ER -Clear answers
Frequently asked questions
What does the Bank reconciliation do?
Reconcile book and bank cash balances after timing differences, fees and interest.
How does the Bank reconciliation work?
The calculator applies Adjusted bank = bank + deposits in transit − outstanding checks; adjusted books = books − fees + interest. A reconciliation separates timing differences from transactions missing in the ledger. The two adjusted balances should agree before the period is closed.
What can I learn from the Bank reconciliation?
You will connect Cash balance in books, Cash balance on bank statement, Deposits in transit, Outstanding checks, Unrecorded bank fees, Unrecorded bank interest to Unreconciled difference, then see how the relationship belongs in the accounting process.
Does MW SysArc receive or store what I enter?
No. The calculation runs locally in your browser. MW SysArc does not receive or store your calculation inputs.
How should I use the result?
Use the result as an educational or reconciliation reference. Confirm the reporting period, accounting policy and source records before relying on it.
Last reviewed . Calculations tested .