Bank reconciliation is the process of confirming that every transaction in your bank account matches an entry in your books — and vice versa. Booksmor offers two ways to do it:
- From a statement (upload) — drop in a CSV/PDF from your bank and let Booksmor match what it can. You confirm the rest.
- Manual ticking (no upload) — Tally-style: tick each book entry as cleared once it’s shown up on your bank app. No file needed.
Pick whichever fits your workflow. Many SMBs use a hybrid — upload statements monthly, tick ad-hoc entries in between.
Time to read: ~12 minutes. You’ll need: at least one Bank account in your Chart of Accounts, and either a CSV/PDF statement from your bank, OR access to your bank app to verify clearance dates.
What you get when this is done
- Confidence that your book balance matches your real bank balance (after timing items).
- A clean record of which book entries have actually cleared the bank.
- Early detection of mistakes — missing entries, duplicated entries, wrong-amount entries.
- A mismatch report that tells you exactly why your book balance differs from your statement balance on any given date.
Where to find the screen
From the sidebar: Daily → Bank Reconcile.
At the top, two tabs let you switch modes: From statement (upload) vs Manual (no upload).
Mode 1 — From statement (upload)
Best when you have a downloadable statement from your bank (most banks let you export CSV from net banking).
Step-by-step
- Daily → Bank Reconcile → From statement (upload) tab.
- Bank account — pick which book account this statement is for. (Or leave as Default bank ledger if you only have one.)
- Statement file — click the file input and pick your CSV or PDF. Booksmor reads:
- CSV — most net banking exports work out of the box.
- PDF — text-based PDFs (most modern statements are). Scanned-image PDFs won’t work; export CSV instead.
- Click Import statement. A status line tells you how many lines were read.
- Click Reconcile. Booksmor matches each statement line against your book entries.
What you’ll see
A Reconciliation summary card shows four numbers:
| What it means | |
|---|---|
| Ledger balance | Total balance on your books as of the statement period. |
| Matched | Statement lines that auto-matched to book entries by date + amount + descriptor. |
| In bank, not books | Statement lines with no matching book entry — these need to be booked. |
| In books, not bank | Book entries not on the statement — usually unpresented cheques or deposits still in transit. Not errors. |
Below the summary, four tables let you act on each category:
- On the statement, not in your books — for each row, either pick an account from the dropdown and click Book (creates a new ledger entry), or pick an existing book entry from the second dropdown and click Match (links them without creating a new entry).
- Probable matches — Booksmor thinks these might be the same transaction (same amount, close date, similar description). Click Confirm match to accept, ignore otherwise.
- Matched — already reconciled. Click Unmatch to break the link if Booksmor got it wrong.
- In books, not on statement — timing items. Leave as-is; they’ll match next month when they appear.
Re-running
You can re-import a longer statement (e.g. a fresh download covering a wider date range) at any time. Already-matched entries stay matched; the new lines fall into the “in bank, not books” bucket for you to deal with.
Mode 2 — Manual (no upload)
Best for the Tally-style workflow: open your bank app on the side, tick each book entry as you see it clear.
Step-by-step
- Daily → Bank Reconcile → Manual (no upload) tab.
- Account — pick one bank account (or All bank/cash accounts to see everything).
- Status — Unreconciled to see only what’s pending. Switch to Reconciled or All when you need to.
- From / To — narrow to a date range.
- Click Refresh. The grid below lists each book entry with a tickbox.
Ticking entries
- Tick the entries you want to mark cleared.
- Reconciled on — pick the date the entry actually cleared the bank (often the entry date if it cleared the same day, or a later date for cheques).
- Click Mark N selected reconciled.
The selected rows move out of the unreconciled view (assuming Status filter is Unreconciled) and their counts update in the summary.
To reverse, set Status to Reconciled, tick what you want to undo, and click Unreconcile.
Bulk-tick a range
Catching up months of statement? After picking a single Account and both From and To dates:
- Click Mark whole range reconciled.
- Every unreconciled entry for that account in the date range gets ticked with the Reconciled on date you picked.
A toast confirms how many entries were swept.
Opening balance + mismatch report
Once you’ve picked an account, an Opening balance & mismatch report card appears:
- Opening balance ₹ + Opening balance date — what your bank balance was on a known starting date (e.g. “₹50,000 as of 2026-04-01”). Click Save opening balance. Booksmor uses this to compute a running balance forward.
- Statement balance ₹ + As of — the bank’s reported balance on a date you choose.
- Click Compare.
Booksmor calculates (opening balance + sum of reconciled entries up to the as-of date) and compares it to your statement balance. The difference, broken down by category, tells you exactly why they don’t match — usually unreconciled entries, missing entries, or a forgotten transfer.
When to use which mode
| Situation | Use |
|---|---|
| Bank gives you a downloadable CSV | From statement (upload) — fastest |
| Bank only has PDF statements that are scanned images | Manual (no upload) |
| You reconcile daily or weekly by ticking off entries as they hit your bank app | Manual (no upload) |
| Catching up months of unreconciled entries at once | From statement if you have a CSV; otherwise Manual with Mark whole range reconciled |
| You just want to verify the closing balance matches without touching individual entries | Manual + Mismatch check |
Common questions
Where do the entries in the manual list come from? Every voucher that touches a bank/cash account creates a ledger entry. Receipt, Payment, Journal — they all flow into this list. Sales/Purchase vouchers contribute only when Paid now via was used; otherwise their cash flows live in the linked Receipt/Payment voucher.
A statement line shows “in bank, not books” but I know I recorded it. Booksmor matches on date + amount + description. If your book entry has a very different description (e.g. “April invoice” vs the bank’s “NEFT IN ICICI”), the auto-matcher might miss it. Use the Match to ledger entry dropdown on the statement row to manually link them.
The mismatch report says “₹500 difference” but I can’t see where. Common culprits:
- An entry in your books that you forgot to mark reconciled (so the running balance is “behind”).
- A duplicated book entry (e.g. you recorded the same payment twice).
- Bank charges or interest that the bank applied but you didn’t record yet — book them and re-run.
Can I undo a mass reconcile? Yes. Set the Status filter to Reconciled, find the entries, tick them, click Unreconcile. The opening balance and book entries stay untouched.
Does Booksmor flag entries that look suspicious? The Operations → Anomalies page surfaces unusual transactions — round-tripping cash, duplicate vouchers, missing references. It’s separate from bank reconciliation but useful to run periodically.
Can I import statements from multiple bank accounts in one go? No — pick one bank account at a time. Importing a multi-account statement would risk attributing entries to the wrong book account. Run a separate import per account.
Do the timing items (“in books, not on statement”) count toward my book balance? Yes — they’re real ledger entries that you posted, just not yet showing on the bank statement (e.g. an unpresented cheque). Your book balance is correct; the bank is “behind” until those clear.
Can I rename what Booksmor calls something on the statement before booking it? No — the statement description is captured verbatim. When you click Book for a previously-unbooked statement line, Booksmor creates a Journal voucher with the statement description in the narration; you can edit the voucher’s narration afterwards via Transactions if you want a cleaner record.
Troubleshooting
Import says “no lines read” / “0 imported”. Either the file format isn’t recognised, or it’s a scanned-image PDF. Try downloading the statement as CSV from your net banking. If CSV is your only option and still fails, contact support — your bank’s CSV format may need a parser update.
“Reconcile” button does nothing. You haven’t imported a statement yet (in From statement mode), or the selected bank account has no statement on file. Import first, then reconcile.
The matched count is way lower than expected. Auto-matching relies on date + amount + descriptor similarity. If your bank’s descriptors are very different from your narrations, expect more manual matching. Most banks settle into a consistent format after a month or two of reconciliation.
My opening balance is ₹0 in the side panel even after I typed it. Click Save opening balance explicitly — the field doesn’t auto-save on blur.
“In books, not on statement” has entries from years ago. These are stale unpresented cheques or deposits in transit that never cleared. Either chase the counterparty to clear them, or post a reversing Journal voucher to write them off, then reconcile both sides.
Need more help? Email support@booksmor.com with: the bank statement file (CSV preferred), your bank account name in Booksmor, and a screenshot of where it’s going wrong.