Loan Signing Agent Spreadsheet: Track Signings, Mileage and Profit
You finished a refinance in the next town over, drove home, scanned back the package and dropped it at the courier. The signing service said $150. But what did you actually make once the miles, the toner, the two hours of your evening and the 30 days you’ll wait to be paid are counted? Most new loan signing agents don’t know, because the fee lands in one app, the miles live in another, and the expenses sit in a bank statement.
A loan signing agent spreadsheet fixes that by putting every signing, mile, expense and invoice in one place, so the profit number calculates itself. This guide shows you what to track, how the tabs connect, and a full worked month you can copy, then hands you the finished template if you’d rather not build it.
All figures in this guide are example assumptions chosen to show the arithmetic. They are not industry averages. Replace them with your own.
Why a notary business needs its own tracker
A general budget or bookkeeping sheet misses the things that make this business different:
- Most of your income is billed, not paid on the spot. Signing services and title companies often pay on net-30 or longer terms. You can be “busy” and broke at the same time if nobody is chasing the unpaid list.
- Your car is your biggest hidden cost. A signing 35 miles away is a 70-mile round trip. Untracked miles are both a cost you underprice and a deduction you lose.
- Every package has a print cost. Loan packages run long, and many are printed in duplicate. Paper and toner are small per job and large per year.
- The fee alone hides your hourly rate. A $75 signing next door can beat a $150 signing an hour away. You only see that when fee, miles and time sit on the same row.
- You also keep a notarial record. A journal-style tab keeps your business log and your notarization record side by side (with the caveat that your state may set its own journal requirements).
The 8 parts of a complete notary business spreadsheet
1. Settings
One tab holds the numbers everything else reads: your default signing fee, your reference fees for refinance and purchase packages, your general notarization fee, the mileage rate you’re using, and the percentage of profit you reserve for tax. Change a setting once and every tab updates.
2. Signing Log (the engine)
One row per appointment:
| Date | Client / Signing Service | City | Type | Fee | Miles | Mileage Value | Print/Scan | Status |
|---|---|---|---|---|---|---|---|---|
| Jun 2 | Signing service A | Austin | Refinance | $150 | 18 | =Miles × rate | $2.50 | Paid |
| Jun 4 | Title company B | Round Rock | Purchase | $175 | 32 | =Miles × rate | $3.50 | Paid |
| Jun 9 | Direct client | Austin | General Notary | $30 | 6 | =Miles × rate | $2.50 | Paid |
Use a dropdown for Type (Refinance, Purchase, HELOC, Seller Package, Reverse Mortgage, Loan Mod, General Notary) and for Status (Scheduled, Completed, Paid, Cancelled, No-Show). Those two dropdowns are what let the dashboard break income down by signing type and keep cancelled jobs out of your revenue.
3. Mileage Log
Rather than typing miles twice, the Mileage Log pulls each trip from the Signing Log and multiplies it by your rate. Add rows for business trips that aren’t signings, such as a supply run or a courier drop. For what to record and why, see the notary mileage log guide.
4. Expenses
Every cost with a date, vendor, category and amount. Categories that fit this business: E&O Insurance, Supplies, Printer/Ink, Mileage/Fuel, Background/NNA, Commission Renewal, Phone, Marketing, Software/Apps, Bank Fees. Matching categories to how you’ll report them saves an afternoon at tax time.
5. Clients & Services CRM
One row per signing service, title company or direct client: contact, payment terms (net-30, net-45, per order) and default fee, with formulas that count how many signings each one gave you and how much they’ve paid you this year. This is where you find out which company sends steady work and which one sends low fees and slow payments.
6. Invoices & Payments
Invoice number, date billed, client, amount, due date, status and a Days Overdue column. The overdue column is the reason this tab exists. A formula like =IF(OR(Status="Paid",DueDate=""),"",MAX(0,TODAY()-DueDate)) turns your unpaid list into a follow-up list.
7. Notarial Journal
Date, time, signer, document type, ID type, a masked ID reference and fee. Treat this as a business record. Many states have specific requirements for an official notarial journal, and some specify the format. Read notary journal spreadsheet vs paper journal before relying on any spreadsheet as your official journal.
8. Tax Summary and Dashboard
The Tax Summary rolls everything into a profit-and-loss view: gross signing income, print costs, expenses by category, mileage, net profit, tax set-aside and a quarterly estimate. The Dashboard puts the headline numbers on one screen: total signings, gross income, net profit, outstanding invoices, miles driven, mileage deduction, average fee per signing, and income by signing type and by month.
A worked month, start to finish
Here is one example month for a part-time signing agent. Every number is an assumption, so change them to match your own.
Signings:
| Type | Count | Fee each | Income |
|---|---|---|---|
| Refinance | 8 | $150 | $1,200 |
| Purchase | 5 | $175 | $875 |
| HELOC | 3 | $125 | $375 |
| Seller package | 2 | $125 | $250 |
| Reverse mortgage | 1 | $200 | $200 |
| General notary (direct) | 3 | $30 | $90 |
| Total | 22 | $2,990 |
Miles: 19 loan signings averaging 25 round-trip miles (475) plus 3 local general notary jobs at 8 miles (24) = 499 miles. At an illustrative $0.70 per mile (the default in the template’s Settings tab; use the IRS standard mileage rate for the current year), that’s $349.30.
Print and scan: 19 loan packages at about $4 each = $76.
Monthly overhead (example figures):
| Expense | Amount |
|---|---|
| E&O insurance (annual premium ÷ 12) | $11 |
| Signing platform subscriptions | $30 |
| Business share of phone | $40 |
| Paper, envelopes, supplies | $25 |
| Toner | $35 |
| Total | $141 |
Net profit: $2,990 − $76 − $141 − $349.30 = $2,423.70
Tax set-aside at 25% (illustrative): $2,423.70 × 0.25 = $605.93 this month, or about $1,817.78 if every month of the quarter looked like this.
Your real hourly rate: if each loan signing takes about 2.25 hours door to door (printing, driving, the appointment, scan-back and drop-off) and each general notary job about 45 minutes, the month took 19 × 2.25 + 3 × 0.75 = 45 hours. $2,423.70 ÷ 45 = about $53.86 an hour before tax.
That last number is the one most agents never calculate, and the one that should decide which signings you accept. How much a loan signing agent makes per signing shows the same math one signing at a time, including the fee where a long drive stops being worth it.
What the worked month tells you
Average fee isn’t average profit. The average fee here is $2,990 ÷ 22 = $135.91, but a 70-mile purchase signing and a 10-mile refinance at the same fee are very different jobs. Put miles on every row so you can see it.
The unpaid list matters more than the busy calendar. If half this month was billed to companies on net-30 or net-45, roughly $1,500 of it won’t arrive until next month. The Invoices tab is what tells you whether you can cover a slow week.
Mileage is a cost and a deduction. Ignore it and you underprice far signings. Fail to log it and you can lose a meaningful deduction. In this example, 499 miles is $349.30 at the illustrative rate, in a single month.
Small costs add up. $76 of printing and $141 of overhead look minor next to $2,990. Over a year it’s more than $2,600 of expenses you’d otherwise have to rebuild from bank statements in April. Common gaps are listed in loan signing agent bookkeeping mistakes.
Copy-ready layout: build the core yourself
If you want to start with a blank sheet, these formulas cover the core:
Signing Log (row 5 onward): A # | B Date | C Client | D City | E Type | F Fee | G Miles | H Mileage Value | I Print/Scan | J Status
- Mileage value:
=IF(G5="",0,G5*Settings!$C$9)(C9 holds your per-mile rate)
Tax Summary:
- Gross signing income:
=SUM('Signing Log'!F5:F204) - Collected so far:
=SUMIF('Signing Log'!J5:J204,"Paid",'Signing Log'!F5:F204) - Print/scan costs:
=SUM('Signing Log'!I5:I204) - Expenses by category:
=SUMIF(Expenses!C:C,"E&O Insurance",Expenses!D:D) - Net profit:
=Income − Print − Expenses − MileageDeduction - Tax set-aside:
=MAX(0,NetProfit)*Settings!$C$10 - Quarterly estimate:
=SetAside/4for a full-year figure split into four payments
Dashboard:
- Signings:
=COUNTA('Signing Log'!B5:B204) - Average fee:
=IFERROR(SUM(Fees)/COUNTA(Dates),0) - Income by type:
=SUMIF('Signing Log'!E5:E204,"Refinance",'Signing Log'!F5:F204) - Income by month:
=SUMPRODUCT((TEXT('Signing Log'!B5:B204,"yyyy-mm")="2026-06")*'Signing Log'!F5:F204)
Build that and you have a working tracker. What takes the time is everything around it: dropdowns, a mileage log that fills itself, a CRM that counts and totals per company, an overdue flag, a journal tab, locked formulas and a dashboard that reads cleanly.
Get the finished version
The Notary & Loan Signing Agent Business Tracker is the complete workbook described above, with 10 tabs and sample data already filled in. Set your fees, mileage rate and tax percentage once in Settings, log each signing as you finish it, and the Mileage Log, Clients CRM, Tax Summary and Dashboard update on their own. Invoices flag themselves overdue, the Notarial Journal sits beside your business log, and income is broken down by signing type and month. It works in Excel and Google Sheets with no macros and no add-ons.
Featured on ReadySheetGo
Notary & Loan Signing Agent Business Tracker — $15.99
Signing log, automatic mileage log, expenses by category, title company CRM, overdue invoice tracker, notarial journal, Schedule C-style tax summary and a profit dashboard. Works in Excel and Google Sheets.
Keep reading
- How much does a loan signing agent make per signing after costs?: net per signing and your minimum acceptable fee
- Notary mileage log for taxes: what to record for each signing: the trips that count and the details to keep
- Notary journal spreadsheet vs paper journal: what to keep: business log versus official journal
- Loan signing agent bookkeeping mistakes that cost you money: eight leaks and a monthly checklist
General information only, not legal, tax or financial advice. Notary rules vary by state; confirm journal and record-keeping requirements with your commissioning authority, and ask a tax professional about deductions and estimated payments. All figures are example assumptions.
Frequently Asked Questions
What should a loan signing agent spreadsheet track?
At minimum: every signing (date, client or signing service, type, fee, miles, print costs and paid status), business expenses by category, a mileage log, invoices with due dates, and a summary that turns all of it into net profit and a tax set-aside. A notarial journal tab is useful as a business record, but check your state's rules on what an official journal must be.
How do I calculate profit as a mobile notary?
Start with total signing and notary fees, then subtract print and scan costs, your business expenses (E&O insurance, supplies, toner, software, phone share, marketing) and your vehicle cost. In the worked month in this guide, $2,990 of fees becomes $2,423.70 of net profit after $76 of printing, $141 of overhead and a $349.30 mileage allowance.
Can I use Google Sheets for my notary business?
Yes. A well-built workbook runs the same in Excel and Google Sheets as long as it avoids macros and add-ons. Upload the file to Google Drive and open it with Sheets; the formulas, dropdowns and dashboard keep working.
How much should a loan signing agent set aside for taxes?
It depends on your total income, state and filing situation, so confirm a figure with a tax professional. Many self-employed people reserve a fixed percentage of net profit every month and pay quarterly estimates from that reserve. This guide uses 25% purely as an illustration.