Automate a monthly job profitability report
Compare revenue with direct materials, labour and other assigned expenses for each job, using files you share and showing missing inputs before you review the monthly report.
What you’ll set up
Connections
Works from files you share
Inputs
Target direct margin percent · Required
Number, default 30
Revenue basis · Required
Choice of invoiced or collected, default invoiced
Brief · Required
Text, prefilled and editable during setup.
Runs
Runs monthly at 08:00
Done by Business analyst
Email to new contacts, and follow-ups nobody has answered, waits for your approval by default. Replies in threads a contact has answered, and email to your own team, can send automatically depending on your settings.
You approve every report · Free to start
How it runs
One agent does the work. Its department head reviews it, then you approve.
- 1Business analyst
Runs monthly at 08:00 and prepares the report from your connected sources.
- 2COO · Review
The department head reviews the report before it reaches you.
- 3You
Email to new contacts, and follow-ups nobody has answered, waits for your approval by default. Replies in threads a contact has answered, and email to your own team, can send automatically depending on your settings.
What you get
Sample, not live data. Invented jobs and amounts in your reporting currency.
| Job | Revenue | Materials | Labour | Other direct | Difference | Direct margin |
|---|---|---|---|---|---|---|
| A | 5000 | 1200 | 1500 | 300 | 2000 | 40% |
| B | 3000 | 1000 | 1200 | 200 | 600 | 20% |
Flag: B is below the sample target of 30%. Overhead is excluded. Unpriced hours remain exceptions.
Define what the report measures
A job profitability report is useful when each revenue and expense row has a job identifier. Share the reporting period, revenue by job, direct materials, labour hours and the rates you want applied. Include subcontractor charges and other assigned expenses where relevant. State whether revenue means invoiced or collected amounts and keep that basis consistent across jobs. This management report measures revenue less the direct amounts you supply. It does not represent net business profit unless your inputs also include an explicit allocation of overhead and the adjustments your accountant requires.
Calculate comparable results from your files
On its monthly cadence, the Business analyst agent groups the shared rows by job identifier. It calculates labour from hours multiplied by the supplied rate, adds the other assigned expenses and subtracts the total from revenue. It divides that difference by revenue to show a direct margin percentage when revenue is positive. Zero revenue receives an exception rather than a percentage. The agent flags missing job identifiers, duplicate document references and unpriced hours so an incomplete job does not quietly look profitable. It lists unmatched rows separately instead of allocating them to a job by guesswork.
Use exceptions before ranking the jobs
The COO agent reviews the calculations against source rows and checks that the revenue basis and labour rates match your instructions. You approve, edit or skip the report before using it to make a commercial decision. Begin with missing inputs, then compare completed jobs with the target margin you supplied. Treat active jobs separately because a partial invoice can distort the apparent result. IRS publications discuss supporting business records, inventories and gross profit; they provide recordkeeping context rather than endorsing this job-level calculation. The report is an AI-written management aid, and your bookkeeper remains responsible for accounting classifications and tax treatment.
Questions
Related jobs
Weekly business report from your till and accounts
One weekly page that joins till or POS sales with your accounting figures, compares last week and the same week last year, and notes anything odd.
Connects to: Till or POS system (read access) (required), Accounting tool (read access) (required)
Categorise bank transactions on a schedule
Each week, new bank and card transactions get a draft category, uncertain or unusual lines are flagged for you, and spend is summed by category.
Connects to: Accounting tool or bank feed (read access) (required)
Automate failed payment follow-ups for subscriptions
A daily list of failed payments that retries have not fixed, with a drafted follow-up for each.
Connects to: Remote MCP server with Stripe read access (required)