A mobile notary working from an average fee per signing can turn any monthly revenue goal into a concrete number of signings to book. It is one division — goal divided by average fee — but the rounding direction matters: round up, because 33.3 signings is really 34 signings if you actually want to clear the goal, not fall a third of a signing short.
A $3,000 goal at a $75 average fee needs 40 signings for the month.
The example
Three notaries with different goals and average fees, based on their typical mix of loan signings and general notarizations.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Notary | Monthly goal | Avg fee | Signings needed |
| 2 | A. Reyes | 3000 | 75 | 40 |
| 3 | B. Chen | 4500 | 90 | 50 |
| 4 | C. Diallo | 2000 | 60 | 34 |
The formula
Divide, then round up:
How it works
Two steps:
B2/C2divides the dollar goal by the average dollar fee, giving a raw signings count that is usually a fraction — $2,000 / $60 is 33.33.ROUNDUP(...,0)rounds that up to 34, because 33 signings at $60 only brings in $1,980 — $20 short of the $2,000 goal.
Divide the monthly signings-needed number by working days in the month to see the daily booking pace required to stay on track.
Try it: interactive demo
Enter the monthly revenue goal and the average fee per signing.
Variations
Average fee from a real mix of jobs
Instead of guessing an average fee, calculate it from last month's actual signings so the goal is based on your real mix of loan packages and simple acknowledgments.
Signings needed per week, not per month
Divide the monthly signings-needed figure by weeks in the month to pace bookings evenly instead of front- or back-loading the month.
Pitfalls & errors
An average fee blended from very different job types (a $40 acknowledgment and a $150 loan signing) can hide the fact that hitting the goal with all-acknowledgment bookings takes far more appointments than the blended average suggests. Break the goal out by job type if the mix varies a lot.
Subtract fixed monthly costs (E&O insurance, printer supplies, mileage) from the revenue goal before this formula runs if the number you actually care about is profit, not gross fees collected.
If average fee is ever 0 or blank (a new notary with no history yet), the formula returns a #DIV/0! error. Default to a reasonable starting average fee until real data accumulates.
Practice workbook
Frequently asked questions
Should travel time factor into the goal at all?
What if fees vary a lot by distance or job complexity?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class