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.

Set up this job

You approve every report · Free to start

How it runs

One agent does the work. Its department head reviews it, then you approve.

  1. 1Business analyst

    Runs monthly at 08:00 and prepares the report from your connected sources.

  2. 2COO · Review

    The department head reviews the report before it reaches you.

  3. 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 dataSample, not live data

Sample, not live data. Invented jobs and amounts in your reporting currency.

JobRevenueMaterialsLabourOther directDifferenceDirect margin
A500012001500300200040%
B30001000120020060020%

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

Start with one report

Set up this job

You approve every report · Free to start