Companion files · The Private Markets Career Guides
How to Start a Bookkeeping Business and Grow It into a Profitable Practice: Monthly Fees by Tier, Catch-Up Work, Payroll, Capacity, Contract Bookkeepers, Getting Paid, Churn and Valuation.
These are the companion files of the book. Five workbooks follow Kelderwick Bookkeeping, the fictional practice of the case, across two fiscal years: tiers and hours, the catch-up quote, capacity and people, billing and cash, and earnings and sale. Each keeps the case’s figures in one column, an empty column for yours, and a cell that chooses which one the formulas read. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 4 to 6
Fee per client hour and margin per client for each tier, before and after the fee increase, the gap when actual hours drift from the budget, and the payroll add-on per hour. Sheets: Inputs, Per tier. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 115 KBChapter 7
A catch-up quoted from the rate card with its hour budget, deposit and stop point, and a running catch-up tracked against its budget, with the change order and the write-off. Sheets: Inputs, Quote, Tracking. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 216 KBChapters 10 and 14
Client hours against capacity month by month, clients per staff bookkeeper, churn, and the clients lost by reason with a register of your own. Sheets: Inputs, Capacity, Churn, Clients lost. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 320 KBChapter 13
Days of revenue owed at year end, the cash released by debits in advance, and the cash against the practice’s floor. Sheets: Inputs, Days owed, Cash released. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 414 KBChapters 15 and 16
Seller’s discretionary earnings, net income per principal hour, transferable earnings, annualized recurring fees and their concentration, and a buyer’s indication with its terms. Sheets: Inputs, SDE, Recurring fees, Indication. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 517 KBAppendix B
Client intake; The engagement letter; The monthly close; Review; A catch-up quote; A payroll run; A bank-detail change; Onboarding a contract bookkeeper and removing access when anyone leaves; Collections; The client exit; The monthly review of the practice.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to try first.
Download the read-me4 KB| One tier | $340 - $131.76 = $208.24 a month left by an Essentials client from January 2026 |
| The write-off | $3,500 - $1,750 = $1,750 written off on the Varrowmede change order |
| The indication | $36,050 x 12 = $432,600 of annualized recurring fees, x 0.8 to 1.1 = $346,080 to $475,860 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Kelderwick Bookkeeping, Kelderwick, Varrowmede, Kestlow, Drummaline, the buyer and every party are fictional, and the fees, hours, salaries, counts, delays and multiples are the book’s assumptions, not market terms or the practice of any real company. Rules change and differ by state: check the current texts, your insurance broker, your outside CPA and your counsel.