Job profit report and cost gaps
The project made a profit. Until someone remembered the freight bill.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get job-level amounts
Use job code, revenue, direct material, labour and other approved allocated cost. Use one reporting period and basis.
Confirm cost allocation
Use only approved costs. Keep unassigned costs separate; do not spread them without a rule.
Privacy Use job codes and approved costs; remove customer contacts and personal details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching job-level revenue and costs for [Period]. Basis: [Approved basis]. A. For each complete named job calculate total cost, profit = revenue minus cost, and margin % if revenue >0. Flag loss, missing amount or job code; do not treat blanks as zero. B. Sum complete job revenue, costs and profit; show unassigned/incomplete rows separately and label total partial. C. Facts and suggested questions for management on loss, allocation and missing costs. No invented reasons or pricing 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.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Calculate in your own Excel.
Excel A:E = job, revenue, material, labour, other. Basis [Approved basis]. Write formulas for F complete flag, G cost, H profit, I margin if revenue positive, J loss flag. Blank calculations for missing data; show complete-only totals. Tell me where to paste.
Fill down, resolve unassigned costs with accounts, and review complete totals against ledger.
- J2₹10,000 loss. ₹80,000 revenue minus ₹90,000 cost.
- J4Labour missing. No margin until cost confirmed.
- Unassigned₹20,000 cost. No job code; don't spread across jobs.
Then send this: Re-add cost and profit per complete job, reconcile totals, verify margins and excluded rows.
It distributes unassigned cost
Reply: "Keep separate until approved."
It treats missing labour zero
Reply: "Hold incomplete job."
It explains loss as fact
Reply: "Only numbers; suggested questions separate."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. 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.
If your whole team does this, we'll set it up for all of them in one session.