PROMPT BRO
Accounts desk

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

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

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.

First time? Try it on fake data first:

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.

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

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.

What you'll get back (example, from the practice files)
₹650interest
2held rows
1not due
  • 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.
Before you trust it

Then send this: Show day count and interest arithmetic for every valid row, sum rounded amounts and exclude held rows.

If it goes wrong
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?