Banking and reconciliation
What it's for
Banking keeps your bank, cash and escrow accounts, and reconciliation proves that the books match the bank: every deposit and payment in the ledger is matched to a line on the bank statement.
Before you start
The Accounting module and permission to manage bank accounts. Your bank's statement as a CSV file.
Add an account
- Open Finance → Accounting → Banking and press Add account.
- Choose the Kind: Operating (current) account, Escrow / RERA designated account or Cash in hand.
- Enter the Display name, Bank, Branch, Account number (stored encrypted; only the last 4 digits are shown) and IFSC / SWIFT.
- For escrow: the Project (required) and Escrow % — the share of collections that must be deposited.
- Either Link to existing ledger account (for example the default Bank account receipts already post to) or create a new one.
- Enter an Opening balance and its date if the account is new to the books; leave it empty when linking an account that already has history.
Each account shows its book balance and the number of unmatched statement rows. Switch an account to inactive to hide it from payment and voucher choices.
Reconcile a statement
- Open the account and its reconciliation page. Press Import statement and choose the CSV.
- Map the columns once: date (and its format, or Detect automatically), description, reference, deposit and withdrawal (or one signed amount) and balance. Title rows are skipped, and rows already imported are never imported twice.
- Press Auto-match. A row is matched when exactly one ledger entry has the same amount within 7 days, or carries the same reference.
- For each remaining row: Match it to a suggested entry, Create entry for charges or interest the books do not have yet (choose the account, Post & match), or Ignore it. Unmatch and Restore undo.
The reconciliation statement
It shows Balance as per books, less deposits not yet cleared, add payments not yet cleared, the Expected bank balance and the Balance as per statement. Aim for a difference of zero.
What happens automatically
- Matching marks ledger lines as cleared on the bank date; it never changes a posting.
- The Accounting overview shows escrow compliance: required against deposited, and any shortfall.
Tips and common questions
- Amounts in brackets, with Dr / Cr, or with Indian digit grouping are read correctly.
- Unmatched rows appear on the month-end checklist.
Related: Month-end close · Manual vouchers