# The Construction Accountant: companion files

Julian R. Sterling

## What is here

- **Construction_Accountant_Model.xlsx**: the workbook that rebuilds the Quillmore Construction year, fiscal 2026, from the job ledger figures to the statements the surety and the bank read, with live formulas. Sheets: WIP, Loss, Fade, Billing, Payroll, Overhead, Statements, Checks.
- **Construction_Accountant_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapters 5 to 7: WIP (nine contracts at 30 September 2026: revenue earned to date $49,043,204, billed $48,785,000, net underbilled $258,204; the prior year-end; J03 with and without its uninstalled rooftop units, $8,504,908 and $8,515,412)
- Chapter 9: Loss (J04: a total loss of $220,000, a provision of $99,000, and the pending change order switch)
- Chapter 8: Fade (margin at bid, at the prior year-end and now, job by job: total fade $932,000)
- Chapter 11: Billing (J03 pay application No. 11, current payment due $675,000)
- Chapter 13: Payroll (the J06 certified payroll week, gross pay $6,063.70, and the misclassification found in October)
- Chapters 4 and 14: Overhead (G&A of $1,800,000, the equipment pool $28,000 under-absorbed, break-even revenue $32,978,234)
- Chapters 15 and 16: Statements (net income $43,204, working capital $4,083,204, the case surety's aggregate program $34,025,000, the case bank's borrowing base $2,516,000)
- Appendix A: 12 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Loss, raise the estimated total cost of J04 from $8,520,000 to $8,700,000: the total loss becomes $400,000 and the year's net income turns into minus $136,796, whatever the percent complete.
2. On WIP, set the uninstalled materials of J03 to 0: J03 recognizes $10,504 of revenue before the work it depicts. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. The inputs sit on the sheet that uses them: J04's contract value, estimate and cost on Loss, and the contract value and final cost of the three closed jobs (J01, J07, J09) on Fade; the WIP sheet links to them. Calculated cells are protected against overtyping, with no password (Review, Unprotect Sheet, if you want to change a formula). No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs. Amounts are in US dollars.

Quillmore Construction, the Tarrow Valley and every owner in the case are fictional. Contract values, costs, wage rates, burden, retainage, the surety guideline and the bank terms are teaching assumptions, not market figures, real wage determinations or the terms of any surety or bank. Standards, wage rules and contract forms change: check the current texts, the contract and your outside CPA before relying on any of them.
