Skip to main content
Illustrative data model

Trades Business Data Model

A structured data model connecting customers, quotes, jobs, materials, time, and invoices, so you can see true profitability per job.

← Back to work & examples
Illustrative model only. This is not a delivered client engagement, a testimonial or evidence of a financial outcome.
The starting point

The work needed
a clearer structure.

Most trades businesses track jobs in spreadsheets or even paper, making it impossible to know which jobs actually make money.

A structured data model connecting customers, quotes, jobs, materials, time, and invoices, so you can see true profitability per job.

The approach

Make the connections useful.

01

One record per customer, linked to every quote, job and invoice they touch

02

Materials and hours logged against the job they belong to, not a separate list

03

Live margin on every job: labour, materials and overhead in one view

04

The invoice builds itself from the job record the day the work completes

What changed

A more practical
way to work.

A starting point for discussing the data and relationships a business might need. Final scope and fields depend on the organisation.

A CLEARER WORKING DAYScheduledJob 1043Job 1045In progressJob 1044CompleteJob 1042Job 1046
Illustrative view / fictional records
What this could mean for you

A useful principle.
Applied to your business.

Start with the records and the work around them. Then choose the interfaces, automation and reporting that make the next step easier for your team.

Talk about your own workflow
A useful first conversation

Bring us the
messy bit.

Tell Adam what takes too long, what keeps going wrong, or what you wish your systems could do.

Let’s make sense of it Small fixes welcome. Bigger ideas too.