PROMPT BRO
Accounts desk

Vendor bill rows ready for checking

Reading a crumpled bill photo at 7 pm

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

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

Collect bill and order data

Use bill line ref, linked PO/GRN, item/unit, current billed qty, rate and GST, approved PO rate/ordered qty, inspection-approved accepted qty and prior billed qty. Try the sample Excel first.

First time? Try it on fake data first:

Check the source

If a bill is a photo, make sure numbers are readable. Do not send bank or personal details.

Privacy Remove bank details and personal information from the bill copy. 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)
vendor-bill.xlsx

Whenever I send bill lines for [Vendor] in [Bill period], prepare purchase entry working. I'm attaching bill lines with approved PO rate, ordered qty, inspection-approved accepted qty, prior billed qty and source refs. A. Validate unique bill line refs, linked PO/GRN, item/unit and positive numeric qty, nonnegative rate and supplied GST; hold invalid/missing fields and duplicates. Show taxable, tax and gross only for calculable rows. Flag missing GST instead of inventing it. B. Compare billed rate to approved PO rate and prior + current billed qty to approved ordered and inspection-accepted quantity; physical receipt alone is not bill approval. Hold missing inspection evidence, rejected/pending goods, excess cumulative billing, mismatches or missing rate/tax. Do not post. C. Totals of calculable gross amounts, held rows and rows passing checks; list proposed purchase voucher references for review only. 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 purchase line and check format. Pick your tool at the top to see how.

After that, each time: send the new bill lines and PO/GRN references.

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)
5bill lines
2pass checks
₹2,242passing gross
  • B102Rate mismatch. ₹110 billed vs ₹100 PO.
  • B103Qty mismatch. 10 billed vs 8 received.
  • B104GST missing. No gross total until confirmed.
Before you trust it

Then send this: Recheck unique line refs, approved rate and cumulative bill qty vs ordered/accepted; recalculate taxable/GST/gross and complete/held totals. No posting or inferred tax.

If it goes wrong
It reads a scan wrongly

Reply: "Mark unreadable cells; do not guess."

It treats missing GST as zero

Reply: "Hold row and leave gross blank."

It ignores received qty

Reply: "Compare each line with received quantity."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?