Client Portal for Accountants: Build Free from One Sheet
Every February, some accountant somewhere sends the year's first "just checking in on those documents" email. By March it has become a genre: the polite nudge, the firmer nudge, the phone call, the client swearing the W-2 went out last Tuesday. One small firm counted the thread behind a single 1040 — forty-seven emails, most of them about locating three pieces of paper.
The traffic runs the other direction too. The same clients who owe you paperwork still want answers: is my return done, did it get filed, what do I still owe? Each question takes thirty seconds to answer and each one lands mid-workpaper, during the exact ten weeks when your attention is worth the most.
The irony is that both problems are already solved inside your practice — in the tracking spreadsheet where you log every client's status, missing documents, and deadline. The only piece missing is a version of that sheet each client can safely see. That is exactly what AI can build: a private portal per client, generated from the workbook you keep anyway.
Step 1: Set Up the Master Workbook
Two layers do all the work. First, a master list with one row per client. Second, a tab for each client holding their document checklist and anything they upload. The master list needs these columns:
| Field | Sample entry |
|---|---|
| Client | Hobart Dental LLC |
| Entity type | S-corp |
| Return type | 1120-S |
| Status | Docs needed |
| Docs outstanding | 1099-INT, Dec bank statement |
| Deadline | Sep 15 |
| Fee | $1,850 |
| Portal user | hobart-dental |
Status runs Docs needed → In prep → Review → E-filed — the four answers to every "where's my return?" call. The Portal user column matters later: it becomes each client's login.
Step 2: Open a Free Account
Head to lovespreadsheets.com and create an account — building costs nothing. Two things sit on the paid tier: private client logins and running the portal on your own domain. For a tool holding tax information, the logins are non-negotiable, so budget for that upgrade.
Step 3: Describe the Portal in Plain English
Pick the Website template and write out what a client should find when they sign in, in an accountant's words:
"Every client on my master list gets a private page. Show them their return status as read-only, their outstanding documents as a checklist, their filing deadline, and their fee. Give them an upload box for tax documents, and route anything they submit into their own tab. No client can ever open another client's page."
Three requests worth adding for a tax practice:
- A checklist that ticks itself — when a client uploads their 1099, that line on their outstanding-docs list flips to received, so they always know what's still on them
- Deadline reminder emails — as a filing date approaches with documents still missing, the portal nags the client so you don't have to
- Strictly read-only status — clients watch the return move from Docs needed to E-filed but can't touch anything except the upload box
Attach the master workbook and start the build. The AI Optimize button tightens loose wording, the AI may come back with a clarifying question or two, and the finished portal set arrives in roughly 15–20 minutes.
Step 4: Each Client Gets a Login, You Get February Back
Every client now has a unique URL. Open Share, switch access to Private, and load the usernames from your Portal user column — passwords are stored hashed, and a login opens only that client's page. Add your logo and firm colors, and point a domain like clients.yourfirm.cpa at it for the full white-label effect.
From here the loop is closed. A client drags in a W-2; it lands in their tab and their checklist updates. You move their status to E-filed in the sheet; their portal reflects it instantly. Forty clients, one workbook, zero status emails.
Why Accountants Keep the Sheet
Tax season runs on the workbook already. Your preparers live in that spreadsheet from January to April. A portal generated from it means no second system to reconcile at 11 p.m. on April 14.
Document chasing becomes self-service. Clients can always see exactly which three documents are missing — which converts "did you get my stuff?" calls into uploads that arrive on their own.
Per-client pricing never bites. Practice-portal vendors charge by the client, which punishes the 200-return shop. A sheet-driven portal costs the same whether you serve 30 clients or 300.
Common Questions from Accountants
Is this secure enough for tax documents? The workbook never leaves your own Google account, access runs through private logins with hashed passwords, and each login exposes exactly one client's tab. Apply the same vendor diligence you'd give any tool in the return workflow.
What happens after April 15? The portal keeps earning its keep — extensions, quarterly estimates, bookkeeping deliverables. Add a row and a tab for anything a client should watch or upload year-round.
Will my less technical clients actually use it? They receive one link and one login, and the page shows four things in plain language. Dropping a PDF into a labeled box is a lower bar than attaching it to the correct email thread.
Build Yours
The tracking sheet you'll open tomorrow morning is the whole foundation. Bring it to lovespreadsheets.com, choose the Website template, and describe the page your clients should see. Before the next deadline cycle, the document chase can become something clients handle themselves.
The team turning other people's spreadsheets into software they actually trust — one sheet at a time.
