Bank Reconciliation — what it does
Matches your Tally ledger entries against the bank statement by amount and shows three things: entries that agree, entries in your books missing from the statement, and bank lines you have not posted. That last list is the one that turns into a BRS statement.
How to use Bank Reconciliation
- Export the ledger from Tally and download the bank statement, as CSV or Excel.
- Load both. Amounts are the match key; dates are used to break ties when the same amount appears more than once.
- Review the three buckets and clear the obvious timing differences — cheques issued but not presented, deposits in transit.
- Work through the unmatched bank lines and post missing entries, then re-run to confirm the lists shrink.
- Use the remaining differences for the BRS statement and keep the run as your working paper.
Worked example: the cheque that reconciled itself
A cheque for ₹2,35,000 issued on the 28th is in your books but not in the statement. It sits in the outstanding bucket, which is exactly what the BRS needs — and when it clears next month, the same run matches it and the bucket empties without you editing anything.
At a glance
| Input | Tally ledger export + bank statement (CSV/XLS) |
|---|---|
| Match key | Amount, with dates used to disambiguate duplicates |
| Output | Matched pairs, outstanding entries, unposted bank lines |
| Where it runs | In your browser — bank data is never uploaded |
Frequently asked questions
- What is Bank Reconciliation?
- Match Tally ledger entries against bank statement lines by amount — see matched pairs, entries not in the statement and bank lines not yet in the books.
- Is Bank Reconciliation free to use?
- Yes — Bank Reconciliation is free to use, with no sign-up, no install and no account.
- Does Bank Reconciliation upload or store my data?
- No — Bank Reconciliation runs entirely in your browser, so your text, files and results never leave your device.
- Do I need to install anything to use Bank Reconciliation?
- No — it works in any modern browser (Chrome, Edge, Firefox, Safari) with no downloads, accounts or plugins.
- What if my statement is a PDF?
- Convert it to CSV or Excel from your net-banking download first — banks offer this for almost every account type and it removes the need for OCR, which is where amount matching gets unreliable.
- Does it handle multiple bank accounts?
- Run each account against its own ledger separately. Keeping a run per account keeps the outstanding list meaningful.