PROMPT BRO
Accounts desk

Invoice rates checked against agreed prices

The rate card changed. The invoice template didn't get the memo.

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

By hand30 min
With AI5–10 min
Per day · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make the rate check sheet

Use invoice line ref, item, quantity, billed rate and approved applicable rate from your contract. Match the date and unit locally.

First time? Try it on fake data first:

Confirm approved rates

If no applicable rate exists, leave it blank. Do not ask AI for a market price.

Privacy Use approved business rates and refs; remove private contacts. 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)
rate-check.xlsx

Whenever I send invoice rate working for [Invoice period], compare on this basis: [Rate basis]. A. Show billed value, approved value if rate present and difference = qty × (billed minus approved). Flag rate missing, higher and lower rates. B. Sum billed values for all rows, compare approved and billed totals only for comparable rows, and list deviations. C. Draft questions for sales/accounts to confirm approved changes. No discount or credit note decision. 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.

Set it up once. Save the rate comparison format. Pick your tool at the top to see how.

After that, each time: send new invoice lines with current approved rates.

First time? Try it in a normal chat: paste and send.

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)
₹5,450billed total
₹150net over
3rate flags
  • I2₹200 higher. 10 × (₹120 − ₹100).
  • I3₹50 lower. 5 × (₹90 − ₹100).
  • I4Rate missing. ₹1,000 billed; no comparison until approved rate found.
Before you trust it

Then send this: Recalculate qty × rate per row; reconcile comparable totals and separate missing rate.

If it goes wrong
It assumes missing rate

Reply: "Flag it; leave comparison blank."

It uses GST-inclusive rate

Reply: "Compare before GST on same unit."

It changes invoice

Reply: "Only show the difference; don't adjust."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?