Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Accounts/Lesson 7

    Add a bank account, import the statement and reconcile

    Register the school's bank accounts (last four digits only), import a statement CSV, auto-match lines to voucher lines, and resolve the rest by hand.

    Open /accounts/bankRecording script
    8 min7 stepsOwner, Admin, AccountantDemo: sign in as Accountant

    Before you start

    Finish first: Load and edit the chart of accounts

    • A CSV export of the bank statement with date, description, ref, debit, credit (balance optional).

    Steps

    0 of 7 done
    1. You should see: Bank & petty cash with a table of banks (Bank, Ledger account, Ledger balance, Statement lines badges such as 3 unmatched or All reconciled, Reconcile →) and a Petty cash funds card. The demo school has State Bank of India ••4821.

      Open /accounts/bank
    2. You should see: A toast "Bank account added". A ledger account is created under Cash & bank when none was chosen.

    3. You should see: Tiles Statement balance, Unmatched inflows and Unmatched outflows; a toggle Unmatched (n) / All (n); an Auto-match button; the statement table (Date, Statement line, In, Out, Ledger match); and a collapsible Ledger entries not on any statement line.

    4. You should see: A toast "N lines imported, M auto-matched" with "duplicates skipped" / "unreadable rows" when relevant. Lines already imported are skipped.

    5. You should see: "Matched" or "Ignored". Matched lines show the voucher number; the tiles shrink.

      An unmatched inflow usually means a receipt was never recorded; an unmatched outflow, a missing payment voucher. Post the voucher first, then match. Use the undo icon on a matched or ignored line to reset it.

    6. You should see: "N matched, M left".

    7. You should see: Vouchers on this bank's ledger that the bank has not shown yet (cheques issued but not presented, deposits in transit); each links to its voucher.

    What you have now

    • Every statement line matched or ignored and a short list of ledger entries still in transit: a bank reconciliation statement.

    If something goes wrong

    "The CSV has no data rows."
    The file needs a header row and at least one line; check the export.
    "That voucher line is not on this bank's ledger account."
    The voucher was posted to a different bank/cash account; correct the voucher (cancel and repost) and match again.
    "Only posted vouchers can be reconciled."
    Post the draft first.
    "That voucher line is already matched to another statement line."
    The bank line is a duplicate; ignore it, or unmatch the earlier line if it was wrong.
    "Pick an asset (bank) ledger account."
    When linking an existing ledger account it must be an asset with subtype bank.

    Related guides

    • Run a petty cash fund: top up and record spends
    • Record an expense or any entry: create and post a voucher
    • Read an account ledger and export it
    Trial balance, income & expenditure, balance sheet and the booksNext: Run a petty cash fund: top up and record spends