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:

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

Tax Summary:

Dashboard:

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.

Keep reading

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.

See What Each Signing Really Pays After Miles and Printing

The Notary & Loan Signing Agent Business Tracker — 10 tabs for a mobile notary or loan signing agent: Settings for your default signing fee, refinance and purchase reference fees, general notarization fee, mileage rate and tax set-aside %; a Signing Log for every appointment with client, city, signing type, fee, miles, print/scan cost and status; a Mileage Log that pulls every trip automatically and values it at your rate; Expenses by notary-specific category (E&O insurance, supplies, printer/ink, background/NNA, commission renewal, phone, software); a Clients & Services CRM that counts signings and totals what each title company or signing service has paid you; Invoices & Payments with days-overdue flags for net-30 payouts; a Notarial Journal record; a Tax Summary with net profit, tax set-aside and a quarterly estimate; and a Dashboard with total signings, gross income, net profit, outstanding invoices, miles, average fee and income by signing type and month. Sample data pre-filled. Works in Excel and Google Sheets.

View on Etsy — $15.99