Freight bills checked against trip rates
Transporter bill says 'extra loading'. The dispatch register has no such chapter.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get trip and bill working
Use trip ref, actual weight, agreed rate per kg and billed freight before GST. Match units and rate basis.
Confirm extras
Only approved extras count. Keep unknown freight or missing dispatch evidence on hold.
Privacy Use trip references, weight and approved charges; remove driver/recipient phone numbers and payment details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send freight working for [Trip period], compare using [Approved basis]. A. For each trip calculate weight × approved rate, compare billed freight and flag missing weight/rate or difference. If dispatch not confirmed, hold even if arithmetic matches. B. Sum billed amount, passing and held values; show known expected vs billed difference for comparable rows. C. List questions for transporter and stores. No payment approval. 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 freight 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 the new trip and bill working.
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 actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:E trip, kg, approved rate, billed, dispatch confirmed. Basis [Approved basis]. Give formulas for expected weight × rate if numeric, difference, missing data and unconfirmed dispatch flag; sum billed passing and held and known comparable differences. Tell me exactly where to paste formulas and how to verify totals. Use made-up examples only; do not ask for actual company data.
Run locally, reconcile totals to your source records and have accounts approve any correction or payment before acting.
- T2₹500 excess. 500 kg × ₹4 = ₹2,000; billed ₹2,500.
- T3Rate missing. ₹2,000 billed; cannot compare.
- T4Dispatch pending. ₹2,000 held until confirmed.
Then send this: Recalculate all comparable trip values, sum billed by status and verify missing data held.
It assumes rate
Reply: "Missing rate held."
It uses tonnes as kg
Confirm unit and convert only with known basis.
It invents extra fees
Reply: "No extras unless approved."
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.