Bank reconciliation statement from Tally and the bank statement
For CAs closing the month or the year. Paste the bank statement and the Tally bank ledger, and get the BRS as on your date with every unpresented cheque, uncredited deposit, bank charge, interest credit and bounce listed, and a clear answer on whether it ties.
Free. No sign-up.Rules last reviewed 2 Oct 2026
Add both files or try the sample
You will get the bank reconciliation statement as on your date, with every unmatched cheque, deposit, charge and bounce listed.
Reconcile every bank account from statements you upload: Charter AI bookkeeping and Tally export.
Charter reads bank statements you upload, PDFs included, books the entries, keeps each account reconciled through the year and exports to Tally, so the BRS is ready when you need it.
Use this inside Charter
Signed-in users get this tool in the Tools area, with saved runs. This page stays free without an account.
Open Bank reconciliation in CharterStart free 14-day trial
14 days free · No card required
How this is worked out
- On the bank statement a deposit is money in; in the Tally bank ledger a debit is money in. The two are compared by direction and amount, never by column name.
- Entries are matched first on a cheque number, UTR or UPI reference with the same amount, then on the same amount with the bank posting up to 7 days after the books date (change the window under Options). Matches on amount and dates alone are marked Suggested for you to check.
- Unmatched books entries become cheques issued but not presented, or deposits not yet credited. Unmatched bank lines become bank charges, interest or direct credits not in the books. A debit that reverses a credit of the same amount within 15 days, with a return or bounce narration, is shown as bounced.
- The BRS starts from the balance as per books, adds and deducts the reconciling items, and compares the result with the statement balance on the as-on date. Entries after the as-on date are left out on both sides.
- The free tool reconciles up to 100 statement lines per run. All amounts are worked out in paise, never rounded through decimals.
Questions CAs ask
Which bank statement formats does it read?
A CSV or tab-separated file exported from net banking, or rows copied from the Excel statement. It needs a header row with the date, the narration, and either separate withdrawal and deposit columns or one amount column with Dr or Cr. The bank's title lines above the header and the summary rows below are skipped. Dates are read day first. Statement PDFs are read inside Charter AI, not on this free page.
How do I export the bank ledger from Tally?
In TallyPrime, open Display More Reports, then Account Books, then Ledger, pick the bank ledger and set the period. Use Export and choose Excel or CSV, keeping the opening balance row. The tool reads Date, Particulars, Vch Type, Vch No., the instrument or cheque number, Narration, Debit and Credit.
How are entries matched?
First on reference: same amount and direction, and a cheque number, UTR or UPI reference found on both sides within 90 days. Then on dates: same amount and direction with the bank date within the window after the books date, marked Strong when the narrations share words or the dates are three days apart or less, and Suggested otherwise. Each line is matched once. Several books entries that add up to one bank line are only suggested, never applied.
Why does my BRS not tie?
The usual causes are cheques issued or deposited before the statement start that are still pending, a closing balance typed for a different date, an entry posted twice, or an amount posted on the wrong side. When the BRS does not tie, the tool lists any reconciling item equal to the difference or to half of it, and checks whether the gap equals the difference between the opening balances.
Are my bank statement and ledger uploaded anywhere?
No. Both files are read and matched in your browser. Nothing is sent to Charter AI or stored, and the page works the same if you go offline after it loads.