Written from ten years of industrial construction work, on both the contractor side and the
client/PMC side. Every worked example uses a fabricated demonstration project — no real project, client
or employer appears anywhere in it.
01The folder structure that keeps every bill findable
02The monthly sequence, in the order the work actually happens
03Six checks that catch most of what goes wrong
04Two registers worth keeping from day one: the JMR and no-drawing work record, and the hindrance and rain log
Only your name and email are saved — nothing else. Never sold or shared.
Ask to be removed any time. Privacy notice.
The month, as it actually goes
Six things that eat the billing month
Most of a billing month goes into keeping the bill from breaking. The Billing OS handles the first five — it works on a demonstration project and is not out yet. The sixth is next.
01
Previous and cumulative stop agreeing
A digit gets transposed in “less previous”. The cumulative is right, the footer adds up, and
nothing on the face of the bill shows it.
The systemThe figure is derived, not re-entered — so a transposed digit has nowhere to get in.
02
RA-1 setup eats a week
Building the MB and abstract from drawings, then linking them, before a single bill goes out.
The systemSet up once from the PO. Every later bill continues from it instead of starting over.
03
The workbook grows until it is unusable
By RA-8 the file is a sheet per bill, old bills must stay visible, and only the current MB should print.
The systemThe file grows without the old bills getting in the way, and only the current cycle prints.
04
PO amendments re-set everything
A new item or a revised quantity arrives and the abstract has to be rebuilt around it.
The systemAn amendment or a new item is absorbed without rebuilding what is already billed.
05
The PO quantity runs out before the work does
Executed, measured, and unbillable until the amendment lands.
The systemFlagged when you claim it, not discovered when it comes back cut.
06
Every client wants their own format
Same figures, someone else’s column order, every single month.
Building nextThe same figures in someone else's column order, without re-keying. Not built yet — if this is
the wrong next thing, tell me what is.
In the workshop
Billing OS — planned. Hear first when it opens.
Excel. No macros, no login, nothing leaves your machine. Runs on Excel 2016 and later.
Planned · commercial control
Billing OS — the workbook this all runs on
The workbook that keeps a running bill from breaking. Previous and cumulative stay in
agreement, earlier bills stay intact as the project grows, and only the current cycle prints.
A PO amendment or a new item is absorbed instead of forcing a rebuild, and a set of checks
runs before you submit — so the things that get a bill cut are caught on your desk.
Tell me when it’s ready
You get one email when it is. Nothing else.
Only your name and email are saved — nothing else. Never sold or shared.
Ask to be removed any time. Privacy notice.