Skip to content

Reconcile a bank statement

This guide shows you how to bring your bank statement into TrackBooks and reconcile it, confirming that every line on your bank statement is accounted for in your books, and posting anything that is not.

What this is

Reconciliation is the process of matching what your bank says happened (the statement) against what your books say happened (your ledger entries), so the two agree. In TrackBooks the workspace has two sides:

  • In Books: bank-ledger entries you have already recorded (for example a customer payment you posted).
  • In Bank: transactions imported from your bank statement.

Reconciling means pairing each In Bank line with its In Books entry. Anything on the bank statement that has no book entry yet (bank charges, interest, a direct deposit you never recorded) gets posted to the books from right inside the workspace. When the Difference reaches ₹0.00, you are reconciled.

Before you begin

  • Role required: Admin or Accountant.
  • Prerequisites: A bank account must exist and be linked to a ledger in your Chart of Accounts. If you have not added one yet, go to Banking → Cash and Bank Accounts → Add bank account, fill in the Account Name, Bank Name, Account Number, Account Type and the Ledger Account it posts to (you can create that ledger on the spot), and click Create Bank Account.
  • Settings/flags: None specific.
  • AI credits: Only the AI Scan import method uses credits. Local Scan and Excel Import are free.

The Cash and Bank Accounts page

Banking → Cash and Bank Accounts lists every cash and bank account in a table with the columns Account, Account No, Type, Books Balance (what your ledger says), Stmt Balance (the balance from the latest imported statement, or a dash until one is imported), Statements, Transactions and Actions. The balances are as of today; click Balances as of Today to pick an earlier date and see both balances as on that day, then Reset to Today. The search box filters by account name, bank or account number. A gap between the two balance columns is your first sign that an account needs reconciling.

Open an account to see its statements, transactions and an Upload Statement button. A cash account (type Cash (Petty Cash / Cash Book)) shows only a books balance, since there is no statement to import.

The Cash and Bank Accounts page with the Books Balance and Stmt Balance columns and the Balances as of Today button

Step 1: Import your bank statement

Go to Banking → Transactions, open Import and pick a method, or click Upload Statement on the account's page. The Import Bank Statements screen has three tabs:

  • AI Scan: reads a PDF of up to 20 pages, or a JPG, PNG, WEBP or GIF image, using AI (uses credits). Use it for scanned or image-based statements and for banks Local Scan does not support.
  • Local Scan (marked Free): reads the text of a PDF downloaded from your bank's internet banking. The bank is detected from the PDF; the tab lists the supported Indian banks.
  • Excel Import: for a spreadsheet (.xls or .xlsx) exported from your bank. The most reliable option when your bank offers one.

Files are limited to 10 MB each. On every tab, choose the Bank Account (required) first, then add the files. A password-protected PDF takes its password in the field provided. Click Process Statements, Scan Statements or Import Transactions depending on the tab.

The Excel Import tab showing the three import methods and the expected columns

Expected columns

For Excel, TrackBooks looks for Date, Description, Reference Number, Debit, Credit, Balance and recognises common bank column names (Narration, Particulars, Withdrawal, Deposit). Duplicate rows are detected and skipped on every method. Use Download Template if you are unsure of the format.

After import you see a processing summary with the number of files that succeeded and the transactions imported.

Step 2: Open the reconciliation workspace

Go to Banking → Bank Reconciliation. Pick your bank account from the selector at the top and set the date range next to it. Refresh reloads the figures and BRS Report opens the statement described in Step 6. The summary cards show, at a glance:

  • Book Balance: total of your bank-ledger entries.
  • Bank Statement: total from the imported statement.
  • Difference: the gap you are working to close.
  • Matched and Progress: how many items are reconciled and how many are still unmatched.

Below the cards sit the Run Auto-Match button and two tabs, In Books and In Bank, each showing its count. Under the tabs a search box, a type filter and an amount filter narrow the list, and every row shows the date, description, party, invoice, journal reference and amount, with its actions on the right.

The reconciliation workspace: summary cards, Run Auto-Match, and the In Books and In Bank tabs

Mind the date range

The workspace only lists entries within the selected date range. A book entry dated just outside the statement window will not appear under In Books, a common surprise when you record a customer's payment on the day you raise the receipt but the bank shows the credit a day later. If an entry seems missing, widen the from date.

Switch to the In Bank tab to see the imported transactions waiting to be reconciled. The type filter separates Deposits from Withdrawals.

The In Bank tab listing imported statement transactions

Step 3: Match transactions

Try Auto-Match first

Click Run Auto-Match. TrackBooks pairs bank lines to book entries automatically when it is confident (it looks at reference numbers, amounts and dates). Confident pairs are matched for you. Pairs it is less sure about appear in a Suggested matches panel, each with a Confirm button; Dismiss all clears the panel.

Match the rest manually

On the In Books tab, click Match bank transaction on an unmatched entry. TrackBooks shows the candidate bank line(s) with the amount and party. Click Match to confirm the pair.

The manual match panel showing a candidate bank transaction

The entry is now reconciled: the Matched count goes up, the bank line disappears from In Bank, and the matched book row gains an Unlink match action in case you need to undo it.

A confirmed match: Matched count increased, one item reconciled

Step 4: Post bank-only transactions

Some bank lines have no book entry: bank charges, interest credited, a payment that was never recorded. These stay under In Bank and keep the Difference non-zero. Post them straight from the workspace using a bank line's actions:

  • Split Post: post the amount to one or more ledger accounts (for example bank charges to an expense account). You can split a single bank line across several accounts.
  • Payment Post: book a receipt or payment against a party account, and link it to one or more open invoices or bills in the same step.

For a bank charge, open Split Post, search the Bank Charges expense account, confirm the amount, and click Post & Match. This creates the book entry and reconciles the line in one step.

The Split Post dialog posting a bank charge to the Bank Charges expense account

Many similar lines? Post them together

Tick several bank lines on the In Bank tab and click Post to Ledger to post them all to one ledger account in one go, with an optional Narration Prefix.

Step 5: Confirm you are reconciled

When every line is matched or posted, the Difference reads ₹0.00, Progress shows 0 unmatched, and the In Bank tab says "All bank transactions have been posted to books."

The fully reconciled workspace with a zero difference

Step 6: Generate the Bank Reconciliation Statement (BRS)

Click BRS Report (or go to Reports → Bank Recon Statement), pick the Bank Account and an As of Date, and click Generate. The BRS starts from the Balance as per Books, adds and subtracts the items still in transit, and compares the result with the bank's actual balance. When they agree it reads Fully Reconciled, Difference: NIL. You can Print it for your records.

The Bank Reconciliation Statement showing Fully Reconciled, Difference NIL

Tips & common issues

Reconcile regularly

Import and reconcile each statement as it arrives (monthly is typical). Small, frequent reconciliations are far easier than one giant year-end catch-up.

Difference won't go to zero?

The usual culprits: a book entry dated outside the date range (widen it), a bank-only line not yet posted (Split Post or Payment Post it), or a duplicate. The Difference card always equals the sum of what is still unreconciled.

Made a wrong match? Unlink it

Matches are not permanent. Use Unlink match on a reconciled row to separate the pair and try again. For an entry you created from the workspace with Payment Post or Split Post, the row offers Undo Post instead: it reverses that journal entry and returns the bank line to In Bank.


Last checked against TrackBooks on 24 October 2026.