Companion files · The Private Markets Career Guides

The Financial Controller

How to Run the Close, Recognize Revenue, Explain Variances, Report to Lenders and Owners, Pass the Audit and Build a Career in Corporate Accounting.

These are the companion files of the book. One workbook rebuilds the Harlan Instruments case: the June 2026 close corrections, the allocation of a bundled hospital contract with its deferred revenue, the third-quarter volume, price and cost variances, and the covenant certificate with its add-backs, cap and cushion. A toolkit holds the checklists and templates of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive54 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

CloseFreight not accrued and an accrual booked twice turn second-quarter EBITDA of $10.4 million into $9.8 million
RevenueA $1,500,000 contract allocates $352,941 to a three-year service plan: $1,215,686 of revenue in 2026, $284,314 deferred
CovenantCovenant EBITDA of $39.1 million gives leverage of 3.07x against 3.50x, a cushion of $4.8 million

The files are provided as they are, without warranty of any kind. The models are illustrative: Harlan Instruments, Westbrook Equity and Marrick Credit Partners are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting advice.

Also by Julian R. Sterling

More in fund operations, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.

Also available as a standalone free template: month-end close and covenant model.