A bookkeeping pricing calculator is a spreadsheet that turns a client's statements and habits into a monthly fee. You enter accounts and transaction lines from sample statements, add multipliers for slow replies and missing receipts, separate review time, and multiply the estimated hours by your hourly target. One sheet per prospect, reused for every quote.
What inputs does a bookkeeping pricing calculator need?
A bookkeeping pricing calculator needs two kinds of inputs: counts taken from the client's statements, and ratings of the client's habits. Statement counts give the volume of work. Habit ratings adjust for how hard that volume will be to handle. Your own hourly target and logged minutes complete the sheet.
Inputs from the statements:
- Number of accounts, split by type: checking, savings, credit card, loan, payment processor.
- Transaction lines per month for each account, taken from two sample months.
- Share of lines with repeat vendors, such as rent, software and utilities, which code quickly once a rule exists.
Inputs from the call or the client's history:
- Reply speed, how quickly the owner answers questions.
- Receipt habits, whether receipts are kept and matched or missing.
- Personal spending mixed in, how often business accounts carry personal charges.
- Reports wanted, beyond a profit and loss statement and balance sheet.
Your own inputs:
- Minutes per line and minutes per account, from your logged time.
- Hourly target, the rate each billable hour must earn.
Keep inputs in one block at the top of the sheet, in a different color from formulas. Anyone using the calculator then knows which cells to touch and which to leave.
Converting statement counts into minutes in the calculator
The calculator converts statement counts into time with two rates: minutes per transaction line and fixed minutes per account. Line minutes cover categorizing; account minutes cover reconciling and downloading each statement, which takes time whatever the line count. Both rates should come from your own logged closes, not from a published figure.
A practical way to set the rates:
- Pick three existing clients whose closes you timed.
- For each, note the total lines and accounts for one month.
- Split the logged time into categorizing and reconciling.
- Divide categorizing minutes by lines, and reconciling minutes by accounts.
- Average the three results.
Use separate line rates where the difference is large. Card statements full of repeat vendors code faster than a checking account full of transfers, cash deposits and checks. Two rates, one for card lines and one for bank lines, are usually enough.
The line rate is the input most affected by your tools. When lines arrive already extracted and coded by client rules, as they do after a batch run through AutoBankConvert, the minutes per line drop to checking rather than entering. Update the rate when your process changes, or the calculator will keep quoting yesterday's hours.
Client habit multipliers in a pricing spreadsheet
Habit multipliers are factors the pricing spreadsheet applies to the base hours to reflect how difficult the client is to work with. A client who answers within a day and keeps receipts gets a factor of 1.0. Slow replies, missing receipts and mixed personal spending each raise the factor, because each adds time the line counts do not show.
Example multipliers, to be tuned against your own clients:
| Habit | Good (1.0) | Fair | Poor |
|---|---|---|---|
| Reply speed | Within 2 days | 1.05 (within a week) | 1.15 (chasing needed) |
| Receipts | Kept and matched | 1.05 (partly kept) | 1.15 (rarely kept) |
| Personal spending in business accounts | Rare | 1.05 (monthly) | 1.10 (weekly) |
Multiply the factors together rather than adding them. A client poor on all three gets 1.15 x 1.15 x 1.10, about 1.45, which is closer to what that client really costs than a simple sum suggests.
Rate habits on evidence where you can. A prospect's sample statements show personal spending directly. Reply speed shows in how quickly they sent those statements. Asking "do you keep receipts?" on a call gets an optimistic answer more often than an accurate one.
The hourly target cell that drives the pricing calculator
The hourly target is the single cell every fee in the pricing calculator depends on. It is the amount each billable hour must earn to cover your pay, the practice's costs and a margin. Set it from your yearly numbers, not competitors' hourly rates, and keep it in one named cell so a change flows through every quote.
To set it, add the pay you need for the year, the practice's yearly costs and a margin, then divide by the billable hours you can really deliver. The method is laid out step by step in how to price bookkeeping services for profit.
Include software in the costs. Accounting software seats, a document portal and a statement converter all count. AutoBankConvert's early-access plans, for example, are monthly and listed on the homepage pricing section; split a tool's monthly price across the clients it serves to find its cost per client, and include it in the costs that feed the target.
The full calculator layout
The table shows a working layout with example values for an example client: a cafe with one checking account and two cards. Cell references assume the labels in column A and values in column B.
| Row | Label | Example value | Formula |
|---|---|---|---|
| 2 | Bank lines per month | 140 | input |
| 3 | Card lines per month | 90 | input |
| 4 | Accounts | 3 | input |
| 5 | Minutes per bank line | 1.0 | input |
| 6 | Minutes per card line | 0.6 | input |
| 7 | Minutes per account | 15 | input |
| 8 | Entry and coding hours | 3.98 | =(B2B5+B3B6+B4*B7)/60 |
| 9 | Habit factor | 1.10 | =1.051.051.0 |
| 10 | Adjusted hours | 4.39 | =B8*B9 |
| 11 | Review hours | 0.75 | input |
| 12 | Client communication hours | 0.5 | input |
| 13 | Total monthly hours | 5.64 | =B10+B11+B12 |
| 14 | Hourly target | $80 | input |
| 15 | Calculated fee | $451.33 | =B13*B14 |
| 16 | Quoted fee | $455 | =CEILING(B15,5) |
The habit factor of 1.05 x 1.05 is 1.1025, shown here to two places; the sheet keeps the full value in its formulas. Rounding the quote up to the next $5 keeps fees tidy without discounting by accident.
Why does a pricing calculator need a separate review line?
A pricing calculator needs a separate review line because review time does not scale with transactions the way entry time does. Checking that a month makes sense, looking at unusual balances and reading the reports before they go out takes a steady amount of time per client. Folding it into minutes per line underprices small clients and overprices large ones.
Review is also the step most likely to be squeezed when a fee is tight. If the calculator hides it inside line minutes, a busy month cuts review first, and errors reach the client. A visible review line makes it a priced part of the service.
Typical items in the review hours:
- Comparing each account's balance to the prior month for anything odd.
- Scanning the profit and loss statement for categories that moved sharply.
- Clearing items the converter or rules held back for review.
- A last look at the balance sheet before the reports go out.
A separate communication line works the same way. A client who wants a call every month needs that time priced explicitly.
Tuning the calculator's fee against three months of real hours
A pricing calculator is only as good as its rates, and the way to improve them is to compare its estimate with the hours a client really takes. After three months, put the estimated hours beside the logged hours. If they differ by more than a tenth, find which input was wrong and correct the rate for future quotes.
The comparison usually points to one of three things:
- The minutes per line were off for this kind of client, often a business type you had not quoted before.
- The habit rating was too kind. The owner who promised receipts did not send them.
- The client's volume changed after the quote, which is a pricing conversation rather than a calculator fix.
Profit per client is the wider version of this check. Once every client has a few months of logged hours, ranking them by effective hourly rate shows which fees need attention; measuring bookkeeping client profitability gives the method.
Keep in mind that a fee the calculator says is profitable does not mean the money arrives on time. A client can show a healthy margin in the sheet and still pay sixty days late, leaving your practice short of cash; profit vs cash in the bank explains that gap the way you would explain it to a client, and it applies to your own practice just as well.
When a pricing calculator should not set the bookkeeping fee
A pricing calculator should not set the bookkeeping fee when the work is not routine monthly bookkeeping, or when the inputs are guesses. Catch up projects, cleanups, advisory work and clients with no statements to sample need judgment. A formula fed with invented numbers gives a precise-looking fee that is wrong.
Cases where the sheet is a starting point at best:
- Catch up and cleanup work, which has setup and investigation time the monthly model does not include.
- A prospect who will not share statements before signing, so every input is an estimate from the call.
- Advisory or forecasting work, where the value to the client matters more than the hours.
- A strategic client you want for referrals or a niche, where you may choose a fee below the sheet on purpose.
The last case is a decision, not a calculator output. If you price below the sheet, record why and for how long, so the gap does not become permanent by accident. Whether bookkeepers should offer discounts covers when that choice pays and how to put an end date on it.