Business
Bank Reconciliation
Match a bank statement against the bank ledger from your books — Tally, Zoho, QuickBooks or a spreadsheet — and get the unmatched entries on each side, the matched pairs, and the closing balances explained. Runs in your browser; nothing is uploaded.
Privacy
Your file never leaves your device. It is read and converted by your own browser, so nothing is uploaded, queued or logged — which is what makes this safe for a client’s books.
Tips
- Export the bank ledger from your books with dates, particulars and the debit and credit columns; download the statement from the bank as Excel or CSV. Columns are matched by name and can be corrected.
- Direction matters and the tool keeps it straight: money in on the statement (a credit) matches money in on the ledger (a debit to the bank account). Map "money in" and "money out" on each side and the rest follows.
- A date window of three days covers cheques and weekend clearing. Widen it for a statement from a slow-clearing account; narrow it if you get false matches.
- Where two entries share an amount, a reference that appears in both descriptions — an invoice number, a UTR, a cheque number — decides which pairs with which.
- The "Only on statement" sheet is usually bank charges, interest and direct debits nobody entered. The "Only in books" sheet is usually cheques issued but not yet presented.
Frequently asked questions
What counts as a match?
Same amount to the paisa, same direction, dates within the window, and — if several candidates qualify — the one sharing a reference with the description, then the nearest date. Each entry matches at most once.
Does it handle a ledger with a single signed amount column?
Yes. Map that column as money in and leave money out empty; negative values are taken as money out. The same works for the statement.
Is my bank data uploaded?
No. Both files are read and compared in your browser and the report is written there. Nothing leaves your device.