Notary Signing Agent Income Tracker Spreadsheet
This spreadsheet works out what each signing actually paid you an hour after the printing and the driving, and how long the money took to arrive.
Most signing logs stop at what you billed, and a fee recorded on the day of the appointment makes every month look the same whether or not anybody has paid you yet. The paper, the drive and the wait are all real costs, and none of them appear anywhere on the invoice.
What is in it
- Seven linked tabs, from Start Here through to a one-screen Overview.
- Setup — mileage rate, printing per page, what your hour is worth, the date to count to, and the overheads: bond, insurance, commission, printer, dues.
- Companies — 30 rows, one per payer with the terms you agreed; signings, billed, collected, still owed and the days they really take all calculate.
- Signings — 400 rows: eight columns you type, eight that work themselves out.
- Getting Paid — every unpaid fee aged against that company’s own terms, not one blanket figure.
- By Assignment — every kind of job ranked by what it paid you an hour, with the whole period totalled on the Overview.
Who it is for
Mobile notaries and loan signing agents working for signing services, title companies and direct clients — anyone paid a flat fee per appointment who prints the package and drives to the table.
The worked example
The worked half-year holds 103 signings for six companies: 156.8 hours door to door, 2,119 miles and 16,478 printed pages. $11,170.00 billed, less $741.51 of printing and $1,419.73 of driving, leaves $9,008.76; after $1,805.00 of overheads she kept $7,203.76 — a 64.5% net margin, and $45.93 an hour against the $60.00 she had decided her hour was worth.
Ranked by the hour, the fee scale runs backwards. A $45.00 general notarisation pays $76.06 an hour; a $175.00 reverse mortgage, at 317 pages and 2.9 hours, pays $47.11. And at the end of June $1,950.00 was still owed across fifteen signings, $835.00 of it past the terms agreed and $535.00 more than sixty days past.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. WhatsApp’tan sipariş ver — $9
Orders are taken on WhatsApp: message me and I’ll send the payment details, then the files as soon as the payment is confirmed.
A look inside the file
Questions people actually ask
How do I work out what a signing actually paid me per hour?
The file takes the fee, subtracts the printing at your per-page rate and the drive at your mileage rate, and divides what is left by the door-to-door hours. In the worked half-year that reverses the fee scale: a $45.00 general notarisation pays $76.06 an hour while a $175.00 reverse mortgage — 317 pages, 2.9 hours — pays $47.11. Across 103 signings the owner billed $11,170.00, kept $9,008.76 after printing and driving, and $7,203.76 after $1,805.00 of overheads.
Can I use it for direct clients as well as signing services?
Yes — put a direct client in as a company with terms of zero, and in the worked half-year the direct clients are the best-paid work in the book. The file holds 30 companies, 20 kinds of assignment and 400 signings, which is a busy year. Each company gets its own agreed terms, so networks on 45 days and 60 days sit in the same list.
What if I do not print anything, or do not know how long a company really takes to pay?
Leave the pages column at zero and the printing line goes to zero — everything else works exactly the same. The days-to-pay figure is not something you estimate: the file works it out from the payment dates you enter and writes the sentence for you, either "pays within terms" or "takes 17 days longer than agreed". At the end of the worked half-year, $1,950.00 was owed across fifteen signings, $835.00 of it past the terms agreed.
Does it need Excel, or can I run it in Google Sheets?
Either — it is a .xlsx workbook that opens in Excel 2016 or newer on Windows and Mac, in Google Sheets through File then Import then Upload, and in LibreOffice. No macros, no add-ons, nothing to install, no account and no subscription. You download the file and it is yours.
Where do I record the borrower's name and document details?
Nowhere, on purpose — there is no field for names, addresses or document details, so your journal stays where it belongs and this file stays about the money. It does not invoice anybody or chase anybody, it is not a calendar or scheduling app, and it connects to no signing portal or platform: nothing syncs and nothing logs in. It is not legal, tax or accounting advice.
Need it built around your business?
This file assumes a flat fee per appointment, your own mileage and a printing cost per page. If your work is arranged differently — print-and-ship fees billed as a separate line, remote online notarisation where there is no drive at all, or an assistant you pay per appointment out of the same fee — I can build the same arithmetic around the way you are actually booked and paid.
All other templates are listed on the Excel & Google Sheets Templates page.