Companion files · The Private Markets Career Guides

The Construction Accountant

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 workbook, the toolkit and the read-me, in one archive83 KB

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.

The files

Three numbers to reproduce first

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 nowJ04, 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 readingWorking 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.