Find dispatches that are not billed
Truck left. Challan signed. Invoice is waiting for someone to find the challan.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Export both line lists
Use unique challan line ref and item code, dispatched quantity and invoiced quantity. Include cancelled or non-billable lines only with their approved status. Include item code, unit, linked PO/order line ref, approved billable status and evidence. Do not assume all dispatched goods are billable.
Confirm the period
Use the same cut-off; check actual dispatch and unit of measure.
Privacy Use business line refs and quantities only; remove delivery contact details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send challan and invoice line lists up to [Cut-off date], match by challan line ref and item code. Scope: [Scope]. A. Validate unique challan line refs, invoice line IDs, item codes, units and numeric nonnegative quantities. Hold all occurrences of duplicated/conflicting IDs and item/unit mismatch; do not let duplicate invoice rows inflate billed qty. Show approved billable dispatched and valid billed qty by unique challan line, remaining = approved billable qty minus billed. Scope must confirm which dispatches are billable; otherwise hold for accounts. If several unique valid invoice rows reference one challan, sum those quantities. No invented qty. B. List unbilled, overbilled and invoice-only refs; count quantities by item and status. Don't combine different units as a meaningful total. C. List checks for accounts and stores before billing. For each unbilled approved line give a copyable handoff: challan line ref, linked PO/order line ref if supplied, item/SKU, unit, approved billable qty remaining, prior valid billed qty and evidence reference. Mark missing PO/order link or billing approval [confirm]; no invoice posted. 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 line matching instructions. 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 day's challan and invoice exports.
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.
Challans A:F unique challan line, item/SKU, dispatched qty, unit, linked PO line, approved billing evidence; Invoice A:E invoice line, challan line, item/SKU, billed qty, unit. Give formulas or Power Query for duplicate/invalid IDs, item/unit match, sum unique valid invoice quantities, approved billable remaining, unbilled/overbilled and invoice-only flags, missing approval/link held. Use same cutoff; no posting. Tell me where to paste.
Run the checks in your own workbook; reconcile to the source export and have accounts approve any correction before posting.
- D23 unbilled. 10 dispatched, 7 billed.
- D32 overbilled. 8 dispatched, 10 billed.
- D45 unbilled. No invoice line supplied.
Then send this: Recheck each reference and quantity sum, verify each invoice line used once and flag missing challan refs. Reconcile unique source lines, hold duplicate/conflicting IDs, confirm item/unit and billing scope. Do not treat physical dispatch as automatically approved for billing.
It matches item only
Reply: "Match challan line ref and item."
It ignores partial billing
Reply: "Sum billed quantity per challan; show balance."
Cancelled dispatch included
Remove or mark approved non-billable records before rerun.
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.