Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Fees/Reconcile receipts with the bank statement and Razorpay settlements/Script

    Recording script: Reconcile receipts with the bank statement and Razorpay settlements

    7 shots · about 1 min 10 s of finished video · lesson 12 of Fees

    Record as

    Accountant (demo_accountant)

    Sign in at /demo on a demo-mode build

    Screens

    /fees/settlements /fees/receipts/[paymentId]

    Length

    1 min 10 s

    narration at ~150 words/min + screen time

    Status

    Not yet recorded

    Before recording

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

    Intro voice-over

    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.

    #ScreenAction (on screen)Must be visibleVoice-over~s
    1/fees/settlementsOpen Fees → Settlements and pick the Month in the header, then Go.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.Collected is what the desk receipted; settled is what the bank actually shows. The gap is what you reconcile.12
    2/fees/settlementsChoose the CSV file and click Import & match.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.Auto-match needs an exact amount, then scores the UTR or receipt number in the narration and the date within three days.12
    3/fees/settlementsOpen Unmatched lines.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.Unmatched lines are bank credits the system could not pair with a receipt.9
    4/fees/settlementsClick Match on a line.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).Interest credits, grants and multi-cheque deposits are not fee receipts; ignore them so they stop appearing.10
    5/fees/settlementsPick a receipt (or paste the id) and click Match; for non-fee credits click the eye icon to Ignore."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.Pick the matching receipt, or ignore credits that are not fees at all.9
    6/fees/settlementsOpen Receipts not yet settled.

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

    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".This view flips the question: which receipts has the bank not shown yet?9
    7/fees/settlementsIf online payments run through Razorpay, click Sync Razorpay settlements.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.If you collect online, one click pulls the settlement report from Razorpay.9

    Outro voice-over

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

    After the video is published

    Add its YouTube id under fees-settlements in src/lib/help/videos.ts, with a chapters map of step number → seconds. The lesson page then shows the video and a “Watch this step” link on every step. See the video production guide.