# The Bookkeeping Practice Owner: companion files

Julian R. Sterling

## What is here

- BKPO_1_Tiers_and_Hours.xlsx (Chapters 4 to 6; Tiers and Hours workbook of Appendix A): sheets Inputs, Per tier, then Checks. Fee per client hour and margin per client for each tier, before and after the January 2026 increase (a Complete client-month: $79.17 a budgeted hour, then $91.67), the gap when actual hours drift from the budget, and the payroll add-on per hour.
- BKPO_2_Catch_Up_Quote.xlsx (Chapter 7; Catch-Up Quote workbook): sheets Inputs, Quote, Tracking, then Checks. A quote and its hour budget from the rate card, the deposit and the stop point, and a running catch-up tracked against its budget (Varrowmede: 140 hours budgeted, 210 used, $1,750 written off), with a monthly log that turns red past the budget.
- BKPO_3_Capacity_and_People.xlsx (Chapters 10 and 14; Capacity and People workbook): sheets Inputs, Capacity, Churn, Clients lost, then Checks. Client hours against capacity month by month (84.2 then 86.3 percent), clients per staff bookkeeper, churn (14.0 then 17.9 percent), the clients lost by reason and a register of your own.
- BKPO_4_Billing_and_Cash.xlsx (Chapter 13; Billing and Cash workbook): sheets Inputs, Days owed, Cash released, then Checks. Days of revenue owed (50.1 then 4.7), the cash released by debits in advance ($31,497) and the cash against the floor.
- BKPO_5_Earnings_and_Sale.xlsx (Chapters 15 and 16; Earnings and Sale workbook): sheets Inputs, SDE, Recurring fees, Indication, then Checks. Seller's discretionary earnings ($112,228 then $170,409), net income per principal hour, transferable earnings ($87,449), annualized recurring fees ($432,600) and the fictional buyer's indication with its terms.
- BKPO_Bookkeeping_Practice_Checklists.docx: the 11 checklists of Appendix B, editable (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).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two columns side by side: Case, with the case's figures in blue on a light blue background, and Your practice, an empty yellow column for yours. A cell at the top of the sheet chooses which column the formulas read; the Used column applies that choice (a blank yellow cell falls back to the case figure), and every other sheet reads the Used column. The Note column is yours: write the date and the document of each input. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the top cell reads Case. Each of the 12 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In BKPO_1_Tiers_and_Hours.xlsx, on Inputs, type in the note cell beside a tier's budgeted hours the actual hours of your last full quarter: Per tier shows the gap and the fee per actual hour.
2. In BKPO_2_Catch_Up_Quote.xlsx, on Tracking, enter the hours of a running catch-up month by month: the log marks the stop point and turns red past the budget.

To use a workbook on your own practice, set the top cell to Your practice and fill the yellow column from your fee schedule, your time records, your bank and card statements, your aging report and your income statement, in the order Appendix A gives, and keep a dated copy at each year end. The workbooks are separate files with no link between them.

## A word of caution

Kelderwick Bookkeeping, LLC, the town of Kelderwick, Varrowmede Dental Group, Kestlow Plumbing & Heating, Drummaline Cafes and the regional accounting firm that gave an indication are fictional. Fees, hours, salaries, rates, counts, payment delays, premiums, draws and multiples are teaching assumptions, not market norms or recommendations. Federal and state rules on tax returns, payroll taxes, client data, contractors and debits change and may or may not reach a given practice: read them in their current text, with your outside CPA, your insurance broker and your counsel. No company, software or vendor is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
