Notary Journal Spreadsheet vs Paper Journal: What to Keep
Search “notary journal spreadsheet” and you’ll find two different needs mixed together. One is the official notarial journal, the record your state may require you to keep of every notarial act. The other is a business log, the record you need to get paid, track mileage and work out your profit. They overlap, but they aren’t the same thing, and confusing them causes trouble in both directions.
This guide compares the two, shows what belongs in each, and explains how to keep them aligned without writing everything twice.
Notary rules are set by each state. This is general information, not legal advice. Your commissioning authority’s handbook is the final word on your journal.
The short answer
- Official journal: follow your state’s rules on whether one is required, what format is allowed (some states specify a bound paper journal or an electronic journal that meets set standards), what each entry must contain, whether a signature or thumbprint is needed, how it’s secured and how long it’s kept.
- Business log: a spreadsheet is the right tool. It holds fees, clients, miles, print costs, invoice status and profit, which an official journal isn’t designed to track.
- Most mobile notaries keep both, with a shared entry number or date so either can be traced to the other.
Side-by-side comparison
| Official notarial journal | Business log (spreadsheet) | |
|---|---|---|
| Purpose | Legal record of each notarial act | Run and get paid for the business |
| Who sets the rules | Your state | You |
| Typical contents | Date/time, type of act, document, signer name and address, ID method, fee, signer signature/thumbprint where required | Date, client or signing service, city, signing type, fee, miles, print cost, paid status, invoice due date |
| Format | As your state allows (paper or compliant electronic) | Excel or Google Sheets |
| Answers the question | “Was this act properly performed and recorded?” | “Did I make money, and who still owes me?” |
| Sensitive data | Whatever your state requires, kept secure | Keep to a minimum (mask ID numbers) |
| Calculations | None | Totals, mileage deduction, overdue invoices, tax set-aside |
What a journal-style tab in a spreadsheet is good for
Even if your official journal has to be on paper or in a specific app, a journal-style tab in your business workbook is useful:
- Cross-referencing. When a signing service asks about an appointment from three months ago, you can find the date, signer and document type in seconds and then go to the official entry.
- Counting notarial fees separately from loan signing fees. In many states the fee per notarial act is capped, so it helps to see stamp fees apart from the signing agent fee for the overall appointment.
- Spotting gaps. If the Signing Log shows a completed signing with no matching journal entries, something hasn’t been recorded.
Keep it lean. A masked reference such as “Driver License ****4821” is enough to match the official record. There’s no reason to put full ID numbers into a file that lives on a laptop or in cloud storage.
A layout that keeps both in sync
Signing Log (business): # | Date | Client | City | Type | Fee | Miles | Print | Status
Journal tab (reference): # | Date | Time | Signer name | Document type | ID type | Masked ID | Fee charged | Thumbprint taken?
Keep the Date the same in both, and you can match rows with a lookup. A quick check for signings with no journal entries:
=IF(COUNTIF(Journal!B:B,'Signing Log'!B5)=0,"No journal entry","")
And total notarial fees separately from signing fees:
=SUM(Journal!H5:H204)
Mistakes to avoid
- Assuming the spreadsheet satisfies your state. It might, it might not. Check the handbook before you stop keeping the format your state specifies.
- Over-collecting sensitive data in the business file. More data in an unprotected spreadsheet is more risk, not more compliance.
- Keeping the journal and never the business log. The journal won’t tell you that a signing service owes you for four jobs on net-45 terms.
- Ignoring retention. States often set how long journals must be kept and what happens to them when a commission ends. Business records have their own retention needs for tax purposes. Keep both for as long as the longer rule requires.
Keep the business side done for you
The Notary & Loan Signing Agent Business Tracker includes a Notarial Journal tab (date, time, signer, document type, ID type, masked ID reference, fee and a thumbprint flag) next to the Signing Log, Mileage Log, Expenses, Clients CRM, Invoices and a Dashboard. Fees from journal entries feed the Tax Summary alongside your signing income. The template is clear about its role: it’s for organizing your business, and you confirm your state’s journal requirements yourself. For a walk-through of every tab and a worked month, see the loan signing agent spreadsheet guide.
Featured on ReadySheetGo
Notary & Loan Signing Agent Business Tracker — $15.99
A notarial journal tab beside your signing log, plus mileage, expenses, a title company CRM, overdue invoice flags and a profit dashboard. Works in Excel and Google Sheets.
General information only, not legal advice. Journal requirements vary by state; confirm format, contents, security and retention rules with your commissioning authority.
Frequently Asked Questions
Can I use a spreadsheet as my notary journal?
It depends on your state. Some states require a journal and set rules on its format, contents, security and retention; some require a bound paper journal or an electronic journal meeting specific standards. A spreadsheet works well as a business record of your notarizations, but check your commissioning authority's rules before treating any spreadsheet as your official journal.
What is the difference between a notary journal and a business log?
An official notarial journal is a legal record of each notarial act, kept to your state's requirements. A business log is your own record of the work as a business: client, fee, miles, print costs, invoice status and profit. Most mobile notaries need both, and they answer different questions.
What do notaries usually record in a journal?
Common entries include the date and time, the type of notarial act, the document type, the signer's name and address, how identity was verified and the fee charged. Some states also require a signature or thumbprint from the signer for certain acts. Your state's notary handbook lists exactly what yours must contain.
Should I store full ID numbers in a spreadsheet?
Avoid it unless your rules require it and the file is properly secured. In a business-side spreadsheet, a masked reference such as the ID type plus the last four digits is usually enough to cross-reference your official journal without keeping sensitive numbers in an unprotected file.