Mechanical contractor · 22 staff · Toowoomba
NOBODY KNOWS WHAT A JOB MADE UNTIL IT IS FINISHED.
The problem
Job costs were retyped from the job system into a spreadsheet once a month, four days after the month closed.
What we built
An API pipeline from simPRO and Xero into a Power BI model. The job-cost pack builds itself overnight.
The result
- Before
- 41,900keystrokes a year
Four days late, every month.
- After
- keystrokes a year
06:00 AEST on the 1st: the report is there.
A keystroke is one thing a person had to type or click.
| Job | Cost to date | Invoiced | Margin |
|---|---|---|---|
| J-2291 Plant room refit | 48,210 | 61,400 | 21% |
| J-2304 Chiller swap | 12,960 | 15,300 | 15% |
| J-2310 Ductwork, stage 2 | 87,450 | 96,000 | 8% |
| J-2318 Service contract | 6,120 | 9,800 | 37% |
| J-2325 Cold room | 31,700 | 33,100 | 4% |
| J-2331 Rooftop units | 22,840 | 29,500 | 22% |
An illustration of the build running, with sample data.
Every job is quoted individually after a free consultation.
Book a free consultation