Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Fees/Lesson 12

    Reconcile receipts with the bank statement and Razorpay settlements

    Import the bank statement CSV, let Unibandh match UPI and NEFT receipts by amount and UTR, resolve the rest by hand, and sync Razorpay settlements.

    Open /fees/settlementsRecording script
    8 min7 stepsOwner, Admin, AccountantDemo: sign in as Accountant

    Before you start

    Finish first: Collect fees at the counter (record a fee payment)

    • A CSV export of the fee collection bank account for the month (Date, Narration, Ref/UTR, Credit columns; most Indian net-banking exports work).

    Steps

    0 of 7 done
    1. You should see: Tiles Collected, Settled / reconciled, Pending settlement and Cash in hand; an import bar (Bank statement CSV, Import & match, Re-run auto-match, Sync Razorpay settlements); views Unmatched lines, Matched, Receipts not yet settled and Ignored.

      Open /fees/settlements
    2. You should see: A toast "N line(s) imported · M auto-matched · D already imported · S non-credit rows skipped". Debit rows are ignored; re-importing the same file adds nothing.

    3. You should see: Each bank credit with Date, Narration, Reference, Credit and a badge: Needs review (score) when a candidate exists or No candidate. Actions Match and an ignore (eye) icon.

    4. You should see: The dialog Match ₹… to a receipt: receipts of the same amount within ±3 days that are not yet matched, or "No receipt of this amount within ±3 days. The line may be a non-fee credit (ignore it) or a deposit of several cheques." You can also paste a Payment id (from the receipt URL).

    5. You should see: "Matched" or "Line ignored". The receipt's settled date is set and the Settled / reconciled tile grows. Unmatch on the Matched view reverses a mistake.

    6. You should see: Non-cash receipts of the month with no bank line or Razorpay settlement yet: Date, Receipt, Student, Mode, Reference, Amount. Empty means "Everything is settled".

      Cash receipts are not reconciled here; they are counted in Cash in hand and handled through the Accounts module's cash book.

    7. You should see: A toast "N payment(s) marked settled · M recon rows from Razorpay for <month>". The button is disabled with "Razorpay keys not configured" when the gateway is missing.

    What you have now

    • Every non-cash receipt of the month matched to a bank line or a Razorpay settlement, with the leftovers explained or ignored.

    If something goes wrong

    "No credit lines found in the file."
    The CSV has no recognisable Date / Narration / Credit columns, or contains only debits. Export the statement again with headers.
    "File is larger than 2 MB."
    Export one month at a time.
    "That payment is already matched to another bank line."
    Unmatch the earlier line first if it was wrong, or the bank line is a duplicate; ignore it.
    "Razorpay keys are not configured; import a bank statement instead."
    Without gateway keys, reconcile online receipts from the bank statement like any other credit.

    Related guides

    • Day book, collection and outstanding reports, Tally export
    • How a parent pays online from the pay link
    Refund a payment or keep it as a credit noteNext: Offer parents fee financing (Jodo, GrayQuest or a custom partner)