PROMPT BRO
Accounts desk

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

By hand4–6 hrs
With AI1 hr
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get job-level amounts

Use job code, revenue, direct material, labour and other approved allocated cost. Use one reporting period and basis.

First time? Try it on fake data first:

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.

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

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.

What you'll get back (example, from the practice files)
₹3 Lknown revenue
₹50,000known profit
2held rows
  • 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.
Before you trust it

Then send this: Re-add cost and profit per complete job, reconcile totals, verify margins and excluded rows.

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