Manaz Afzal Book a consultation

Work snippet

Job profitability report for a service business

Concept DesignIllustrative integration walkthrough. Business details, figures and records are worked examples.

A job-by-job view of what each job earned: invoiced revenue from Xero, materials and subcontractor bills coded to the job, and labour from timesheets, each compared with a target margin.

The problemNobody can say which jobs make money.

What changesMargin by job against a target, from invoices, bills and timesheets.

Area
Management reporting
Tools
Xero · ServiceM8 or Jobber · Google Sheets
Typical scope
US$300-700
Timeline
About 4 weeks · fixed milestones

The problem

The accounts show a profit for the year without showing which kinds of job earned it, and underquoted jobs disappear inside a good month. Job-management systems such as ServiceM8 and simPRO report margin per job only when costs carry the job number.

  • Quotes priced on feel, not on what similar jobs cost
  • Bills that are not coded to a job
  • Labour that never reaches the job number
  • Margin only known at year end

Approach

  1. Look

    Review how jobs, invoices, bills and timesheets are numbered and where the job number is missing.

  2. Code

    A simple rule for coding bills and timesheets to a job, and a backfill for the last three months.

  3. Report

    A Sheets report by job and by job type with margin against a target margin.

  4. Use

    Quote prices are checked against the margin report, starting with the lowest-margin job types.

Exhibit

Job profitability, jobs completed in the month (AUD, ex GST)
JobDescriptionRevenueLabourMaterialsSubcontractProfitMargin
20401Switchboard upgrade6,8502,1401,760-2,95043.1%
20405Hot water replacement3,4208801,340-1,20035.1%
20412Split system install, two units5,9801,2602,910-1,81030.3%
20418Bathroom rough-in9,4003,3502,1201,8002,13022.7%
20423Commercial lighting fit-out14,2004,6805,4301,2002,89020.4%
20430Blocked drain call-out68021040-43063.2%
20437Monthly maintenance visit1,12054095-48543.3%
20441Kitchen renovation plumbing11,7503,8203,9602,9501,0208.7%
Total, 8 jobs53,40016,88017,6555,95012,91524.2%

Margin by job, against a target

20430 Blocked drain63.2%20437 Maintenance visit43.3%20401 Switchboard upgrade43.1%20405 Hot water system35.1%20412 Split systems (2)30.3%20418 Bathroom rough-in22.7%20423 Lighting fit-out20.4%20441 Kitchen plumbing8.7%Target 25%

Revenue from Xero invoices. Costs from Xero bills coded to the job and from timesheets at cost rate.

Job profitability: margin by job for eight jobs against a 25% target, with one job at 8.7%.

How to read it

  1. Each job shows revenue, labour, materials and subcontract cost, so the margin can be traced line by line.
  2. Jobs under 15% are marked, and the chart shows each job against a 25% target.
  3. The total ties to the profit and loss report for the same jobs.

Scope

AreaIncluded
ReviewHow jobs, invoices, bills and timesheets are numbered, with findings
Job codingA rule for coding bills and timesheets to a job, and a backfill of three months
ReportA Sheets report by job and by job type, with margin against a target
Tie-outThe report totals agreed to the Xero profit and loss for the same period
Quote checkA short review of pricing on the lowest-margin job types
HandoverA walkthrough, the files and a monthly routine
Not includedChanges to pricing itself, which stay with the owner

Milestones and fee

MilestoneDeliverableTimingShare of fee
M1 Review and rulesFindings and job-coding ruleWeek 120%
M2 BackfillThree months coded to jobsWeeks 1 to 230%
M3 Report builtJob and job-type report, tied to XeroWeeks 335%
M4 HandoverQuote check and walkthroughWeek 415%

Typical scope for this kind of project: US$300-700

About 4 weeks · fixed milestones. The systems health check (US$150, fixed) comes first and confirms the scope. Extra hourly work is US$35 per hour, agreed before it starts.

Discuss an engagement.

Outline the operational problem through the contact form. I respond with a recommended starting point, including whether the US$150 systems health check is the appropriate first step.

Related work snippets

Next step

Bring me the work that repeats.

I scope it in writing, test it against your current process on your own data and hand over everything I build.

Book a consultation