Practical Systems for Engineers
Most of a billing month goes into keeping the bill from breaking.
Practical Excel systems for contractor-side billing and QS engineers — built by a project manager who still runs bills. Start with the free RA Bill Playbook.
The month, as it actually goes
Six things that eat the billing month
Each one has a system behind it. Five of them are built; 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.
Free · the first system
The RA Bill Playbook — free
The folder structure, the monthly sequence, the six checks that catch most of what goes wrong, and two registers worth keeping from day one: the JMR and no-drawing work record, and the hindrance and rain log.
Written from ten years of industrial and EPC 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.
Free · no signup
Check a bill’s gap in 90 seconds
A quick check on where a bill stands. It gives you the size of the gap — the Playbook and the Billing OS are about not creating one.
- You need
- Your latest RA bill’s top sheet and your contract’s retention %
- Time
- Under 90 seconds
- Signup
- None
RA Bill Gap Check
Runs entirely in your browser. Nothing you type is sent anywhere or saved.
Cumulative, as claimed in your latest RA bill · ₹
Cumulative, as certified by your client · ₹
The percentage your contract states · %
Everything recovered against advances so far · ₹ · empty if none
Recovered for material your client issued · ₹ · empty if none
This is an analytical check based only on the figures you enter. It is not a legal, tax or contractual opinion. Verify every item against your own contract before raising anything with your client.
Result · on the figures entered
The size of the gap
Fabricated example — not a real project, client or bill
Based on the figures entered, there is a variance of between your claimed value and your certified value.
Some of this is normally explained by held quantities, disallowed items, rate disputes, unapproved deviations and pending approvals. The question is whether you can account for all of it, line by line. The deductions below are taken from the certified value, not from this gap — review them for any applied without a clear contract basis, and for calculation errors.
This gives you the size of the gap. Finding which items it sits in needs your item-wise data — that is what the Billing OS is built for.
| No. | Line | ₹ | Basis |
|---|
In development
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.
Excel. No macros, no login, nothing leaves your machine. Runs on Excel 2016 and later.
In development
Industrial BBS Master — a bar bending schedule that adds itself up
One Excel workbook for the steel in footings, columns, beams, slabs and walls. You enter the member size and the bars; cutting lengths, bend deductions, dia-wise totals and the TMT order list are worked out for you, and a checks sheet flags a missing bar or a typed-over formula before the schedule goes to site.
Excel. No macros, no login, nothing leaves your machine. Runs on Excel 2016 and later. Nothing to download yet — this list is how you hear when it opens.
Who built this
Built from billing work, not from a course
- WhoCivil engineer, 10+ years on industrial and EPC packages — turnkey factory builds, PEB, heavy machine foundations, industrial flooring.
- BilledBoth sides of the desk since 2017: RA bills prepared and checked before they go to the client, and subcontractor and PC bills certified against joint measurement records.
- DataEvery example on this page and in the Playbook uses fabricated demonstration data. Nothing comes from a real project, client or employer.
Fit
Who this is not for
Built for contractor-side billing and QS engineers who prepare RA bills and subcontractor bills for a larger client. It is not for:
- Students and freshers — it assumes you already prepare RA bills.
- Anyone looking for a general civil engineering course.
- Structural design or modelling tutorials — STAAD, ETABS, Revit.
- Client-side and PMC engineers — this is the contractor’s side of the table.
- Government department engineers.
- Billing under Gulf or UK standards — it follows Indian contract practice.
- Anyone after AI tools for their own sake — this is about the bill.