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

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:

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

  1. Assuming the spreadsheet satisfies your state. It might, it might not. Check the handbook before you stop keeping the format your state specifies.
  2. Over-collecting sensitive data in the business file. More data in an unprotected spreadsheet is more risk, not more compliance.
  3. 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.
  4. 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.

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.

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