From the contractor’s BOQ to the certificate they sign.
PRJ-2601 — guest bedroom wardrobes and dressing room joinery for Al Tamayuz Fit-Out Contracting, on a 342,500.00 contract. Followed here from the estimate to the payment certificate, using the figures the system actually produces.
The estimate starts in their spreadsheet, not yours.
The main contractor sends a bill of quantities as a spreadsheet. ProLedger detects the header row and the serial, description, quantity and price columns, and lets you remap any of them before importing. Every save snapshots a version, so when the QS asks what changed between revision B and revision C, there is an answer.
- Excel or CSV import, columns auto-detected and remappable per file
- Version history you can list side by side
- Submit for approval, then approve or reject — with who, and when
- Converts straight to an invoice, or to an agreement that pulls the BOQ through
| Guest bedroom wardrobes — laminate | 184,200.00 |
| Dressing room joinery — veneered | 118,400.00 |
| Ironmongery & accessories | 24,650.00 |
| On-site installation | 15,250.00 |
| Contract sum | 342,500.00 |
The bill of materials is a cutting list.
Each line carries a quantity and its own waste percentage, because a back panel and a run of edge-banding do not waste alike. The optimiser nests panels onto 8×4 sheets with the blade kerf taken out — so the sheet count you buy against is the one the saw will actually produce.
Work-order costing then sets the estimate — BOM quantity times order quantity, plus planned labour — against materials actually issued and hours actually booked, and shows the variance. Scrap & yield records what was scrapped per work order, with the yield percentage and its cost.
This template is one of three seeded into a new company, alongside a 600mm base kitchen cabinet and a flush door.
| Material | Part | Qty | Waste |
|---|---|---|---|
| MAT-PLY18 | Carcass panels (sides/shelves) | 4.0000 | 12% |
| MAT-MDF06 | Back panel | 1.0000 | 8% |
| MAT-LAM | Door + exterior laminate | 3.0000 | 10% |
| MAT-EDGE | Edge-banding | 40.0000 | 10% |
| MAT-HINGE | Door hinges | 8.0000 | — |
| MAT-HANDLE | Handles | 6.0000 | — |
| SRV-FAB | Workshop fabrication | 16.0000 | — |
| SRV-INST | On-site installation | 6.0000 | — |
A fit-out is delivered in pieces, so it is signed for in pieces.
Deliveries are raised against a quotation or sales order, signed off by the customer, and claimed as partial deliveries by component stage — frame, leaf, architrave, fixing, ironmongery, touch-up. The delivery register is what the claim is built from, so nobody reconstructs a month’s work from photographs in a WhatsApp group.
| Delivery note | Scope | Status | Value |
|---|---|---|---|
| DN-5119 | Levels 2-4 | Signed | 62,110.00 |
| DN-5188 | Levels 2-5 | Signed | 112,570.00 |
| DN-5196 | Levels 2-6 | Signed | 94,680.00 |
| DN-5204 | Level 5 | On site | 73,140.00 |
Work done and not yet claimed is the most expensive number in the business.
Revenue is recognised on percentage of completion and set against what has actually been billed. Over-billed is cash you hold against work you still owe; under-billed is work you have already paid your people to do and have not asked for. A spreadsheet shows neither.
| Project | Scope | Contract | % complete | Over / under billed |
|---|---|---|---|---|
| PRJ-2601 | Guest bedroom wardrobes | 342,500.00 | 78.4% | 14,220.00 |
| PRJ-2603 | Boardroom table & panelling | 196,400.00 | 41.2% | -8,940.00 |
| PRJ-2605 | Reception counter, solid surface | 88,750.00 | 96.0% | 3,110.00 |
Run your own contract through it.
Import a real bill of quantities, price a claim with the retention held back, and see whether the VAT ties out. The cutting-list templates above are waiting in the workspace on the day you sign up.