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
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.
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.
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.
Build the expected schedule locally in Excel.
Opening principal ₹[Opening principal], monthly rate [Agreed monthly rate %]%, EMI ₹[Approved monthly EMI]. Excel A = month, B = bank interest. Give formulas for C opening (first month input, then prior close), D expected rounded interest, E principal capped at balance, F closing, G difference if bank interest numeric, H flag. Stop if EMI less than interest. Tell me where to paste.
Fill down, check exact closing and bank differences with accountant.
- 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.
Then send this: Recalculate each month from prior closing with paise rounding; reconcile principal reduction to final balance and check each bank difference.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.