PROMPT BRO
Accounts desk

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

By hand2–3 hrs
With AI20 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get trip and bill working

Use trip ref, actual weight, agreed rate per kg and billed freight before GST. Match units and rate basis.

First time? Try it on fake data first:

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.

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

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.

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.

What you'll get back (example, from the practice files)
₹9,500billed
₹3,000pass checks
3held trips
  • 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.
Before you trust it

Then send this: Recalculate all comparable trip values, sum billed by status and verify missing data held.

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