Interest working from agreed contract rates
The contract says interest. The payment reminder says 'kindly'. The sheet has to reconcile both.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get invoice and interest terms
Use invoice ref, overdue principal, due date and agreed annual rate per contract. Confirm date basis and any grace period with accounts.
Check eligibility locally
Do not ask AI whether interest is legally payable; only calculate the approved working.
Privacy Use invoice refs and agreed rates only; remove contact and banking identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching overdue invoice working. As on [As on date]. Calculation: [Approved calculation]. A. For each invoice use the supplied simple-interest day-count and grace rule. For the default basis, days = max(0, as-on minus due date), interest = principal × supplied annual rate/100 × days/365, rounded to 2 decimals. If the edited basis differs, use only its explicit denominator, grace and rounding; ask for clarification if unclear. Hold missing rate, principal or date; not-due interest zero. B. Sum valid principal and calculated interest; list held rows and not-due rows separately. Do not compound or invent a rate. C. Questions for accountant / consultant before any charge; no debit note or demand automatically. 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.
Keep real invoices in Excel.
Excel A:D = invoice, principal, due date, annual rate as number percent. As-on [As on date]; approved basis [Approved calculation]. Write formulas E days overdue, F interest rounded to 2 decimals, G hold if missing inputs. Use the denominator, grace and rounding explicitly supplied in the approved basis; default 365 days, no grace. Ask for clarification if unclear. Tell me where to paste.
Fill down and compare with approved contracts; accountant checks before charging.
- I1₹300. ₹36,500 × 10% × 30/365.
- I2₹200. ₹36,500 × 10% × 20/365.
- I4 / I6Missing rate / date. Hold both; no calculation until accounts confirms.
Then send this: Show day count and interest arithmetic for every valid row, sum rounded amounts and exclude held rows.
It uses a legal rate
Reply: "Only supplied contract rate."
It compounds
Reply: "Simple interest as supplied."
It adds late fee
Reply: "No additional charges."
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.