PROMPT BRO
Accounts desk

Loan interest and principal schedule checks

EMI debited. The loan statement splits it differently from the spreadsheet. Time for another call.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand1–2 hrs
With AI15 min
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get approved loan terms

Use opening principal, agreed periodic interest rate and EMI from your loan schedule. Copy month and bank charged interest, without account details.

First time? Try it on fake data first:

Confirm calculation basis

This sample uses fixed monthly interest on opening balance, not a daily or floating rate loan. Ask bank/accountant if your terms differ.

Privacy Use dummy or masked loan figures; remove account number and personal borrower details. Delete bank account numbers; replace customer UPI IDs and phone numbers.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
loan-interest.xlsx

I'm attaching month and bank interest list. Opening principal ₹[Opening principal], monthly rate [Agreed monthly rate %]%, EMI ₹[Approved monthly EMI]. A. In month order compute expected interest = opening × monthly rate/100 rounded to paise, principal = EMI minus expected interest (cap at remaining principal), closing = opening minus principal. Stop if EMI cannot cover interest; no assumed charges. B. Compare bank interest to expected per month; flag differences and missing bank charge; keep expected schedule independent of bank differences. C. Sum expected interest and principal, show final closing and questions for bank/accountant. No loan advice or payment. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
₹54,091closing approx
₹4,091interest approx
2bank flags
  • Month 3₹80.90 difference. ₹900 charged vs ₹819.10 expected.
  • Month 5Charge missing. Expected ₹634.56; ask bank for record.
  • ₹54,090.95Exact closing. Expected schedule after 5 EMIs; not confirmed bank balance.
Before you trust it

Then send this: Recalculate each month from prior closing with paise rounding; reconcile principal reduction to final balance and check each bank difference.

If it goes wrong
It uses annual rate

Reply: "My supplied rate is monthly."

It assumes missing charge zero

Reply: "Missing is unknown."

It adds charges

Reply: "Use only EMI and agreed interest."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?