Companion files · The Private Markets Career Guides
The Practitioner's Guide to Construction Accounting, from Job Costing and the WIP Schedule to ASC 606, Retainage, Certified Payroll and the Surety Package.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook carries Quillmore Construction, the fictional general contractor of the case, through its fiscal year to 30 September 2026: the WIP schedule of nine contracts, the J04 loss and its provision, profit fade, the J03 pay application, the J06 certified payroll week, overhead and break-even, and the statements, ratios and case surety and bank tests. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 4 to 9, 11, 13 to 16, and Appendix A
One sheet follows each step of the book, with its inputs on the sheet: WIP, Loss, Fade, Billing, Payroll, Overhead, Statements. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 12 exercises of Appendix A run on it.
Download the workbook46 KBAppendix B
Monthly close; WIP review; Estimate-at-completion meeting; Loss contract test; Pay application review; Retainage tracking; Weekly certified payroll review; Surety and bank package.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Billing is not revenue | $49,043,204 earned to date against $48,785,000 billed: the company is $258,204 underbilled net at year-end |
| The loss lands now | J04, bid with $580,000 of margin, now carries a total loss of $220,000, of which $99,000 is a provision for work not yet done |
| The surety's reading | Working capital of $4,083,204 becomes $3,402,500 once prepaid expenses and underbillings are removed, for an aggregate program of $34,025,000 under the case guideline |
The files are provided as they are, without warranty of any kind. The model is illustrative: Quillmore Construction, the Tarrow Valley and every owner are fictional, and the contract values, costs, wage rates, burden, retainage, the surety guideline and the bank terms are the book’s assumptions, not market figures or real wage determinations. Standards, wage rules and contract forms change: check the current texts and the contract.