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
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.
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.
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.
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.
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.
Keep your actual accounting records in Excel. Ask AI for the method using only column headings and approved rules.
Excel A:E invoice line, item, qty, billed rate, approved rate. Basis [Rate basis]. Write formulas for billed and approved value, difference only for numeric approved rate, status higher/lower/missing/match; show comparable totals and separate missing rates. No correction to source invoice. Tell me exactly where to paste the formulas or how to set up the local steps. Use made-up examples only; do not ask for actual company data.
Run the checks in your own workbook; reconcile to the source export and have accounts approve any correction before posting.
- I2₹200 higher. 10 × (₹120 − ₹100).
- I3₹50 lower. 5 × (₹90 − ₹100).
- I4Rate missing. ₹1,000 billed; no comparison until approved rate found.
Then send this: Recalculate qty × rate per row; reconcile comparable totals and separate missing rate.
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?
If your whole team does this, we'll set it up for all of them in one session.