Tax Season Data Preparation: Collect Client Documents Without the Email Chase
Every January it starts again: organizers go out, documents trickle back by email, text and drop-off, and someone keeps a spreadsheet of who still owes what. Most of that tracking can run itself in the Microsoft 365 your firm already pays for.
For a tax or accounting practice, tax season data preparation is everything before preparation starts: sending organizers, collecting each client's documents, chasing what's missing, and knowing which returns are ready to begin. Lightray Solutions automates that intake with Microsoft Forms, OneDrive or SharePoint file requests, Power Automate reminders and a Power BI status board. We build the workflow; we don't touch tax positions or give tax advice.
Each setup is quoted at a fixed price after a short discovery of how your firm handles intake today. Build it in the fall: the IRS opened the 2026 filing season on January 26, with the individual deadline on April 15, and a new intake process is easiest to test before the first organizers go out. The first step is a free 30-minute strategy call.
How do you automate client data collection with tax organizers?
Split the organizer in two. The questions (life changes, new dependents, new accounts) go into a Microsoft Forms questionnaire anyone can open from a link. Documents go to a file request for that client in OneDrive or SharePoint. Power Automate records each response and upload against your client list and sends reminders for whatever is still missing.
The split matters because of a Microsoft limit: Forms only offers file-upload questions when the form is restricted to people inside your organization, so clients can't attach documents to a form. File requests fill that gap. Anyone with the link can upload, and nobody needs a Microsoft account; the file request documentation covers the details.
What does each Microsoft 365 piece do?
Five pieces, linked so one client list shows every return's status. Forms, SharePoint, OneDrive and standard Power Automate flows come with most Microsoft 365 business plans; viewing the Power BI board needs a Power BI Pro license per viewer. None of it replaces your tax software; it covers intake and tracking up to the point a preparer opens the file.
- Client list (SharePoint list). One row per return: client, preparer, organizer sent, questionnaire back, documents complete, ready to prepare, extension flag.
- Questionnaire (Microsoft Forms). The organizer questions, with branching so a client without rental property never sees the rental section.
- Document drop (file request). One link per client folder. Uploaders can't see or download what's already there, each file is prefixed with the uploader's name, and the firm gets an email for each upload. Your Microsoft 365 administrator has to enable the feature.
- Reminders (Power Automate). A scheduled flow checks the list each week, emails clients whose items are outstanding, and alerts the preparer when a client has gone quiet too long.
- Status board (Power BI). Returns by stage and preparer, how long documents have been outstanding, and how many files are ready to start this week.
| Intake step | Typical manual way | Automated in Microsoft 365 |
|---|---|---|
| Send organizers | PDFs emailed one client at a time | A flow sends each client their questionnaire and upload link |
| Collect answers | Client prints, fills in and scans | Forms questionnaire; answers land in the client list |
| Collect documents | Email attachments, texts and drop-offs | A file request link per client, upload-only |
| Track who owes what | A shared spreadsheet updated by hand | Client list updated by the flow on each response and upload |
| Chase missing items | Staff work through call and email lists | Weekly scheduled reminders to clients with items outstanding |
| See what's ready to prepare | Ask around the office | Power BI board by stage and preparer |
Is Microsoft 365 secure enough for client tax documents?
It can be, when it's set up deliberately. Files stay in your firm's own tenant under your access and retention settings, and file-request uploaders can't see anyone else's files. What it doesn't remove is your own obligation: the IRS reminds tax professionals that a written data security plan is required by federal law under the FTC Safeguards Rule.
Rules built into the setup: no Social Security or bank account numbers in a form, since those belong in your tax software; one request folder per client; request links removed once a client's documents are in; and multifactor sign-in for staff. Everything configured is documented, so your written security plan can list it.
When does this make sense for a firm?
When the firm already runs on Microsoft 365 and still tracks intake in a spreadsheet that takes someone hours a week to keep current. If your tax software's client portal already handles organizers, uploads and reminders well, keep it; the better project then is a status board fed from the portal's exports, where the software allows them.
For analytics on the practice itself (utilization, realization, WIP), see Power BI for accounting firms. For other workflows such as engagement letters or month-end checklists, see Power Automate consultants.
How does the project run?
Discovery of your current intake and client list in the fall; build and test with a handful of willing clients before the new year; go live with organizers in January; and a review after the deadline to adjust for the following season. All of it runs remotely by video and inside your own Microsoft 365 tenant.
Edward Pinela, MBA, builds it himself, with 20+ years of business experience and more than 200 delivered projects behind him, and Lightray holds a 4.9★ Google rating. You hear back within 4 business hours of getting in touch.
Further reading: IRS — What tax preparers need to know about a data security plan.
Want next season's intake running before the first organizer goes out?
Book a free 30-minute call with Edward Pinela, MBA. You get an honest read on what to fix first — and if we are not the right fit, you will hear that on the call.
Frequently asked questions
Will this work with our tax software?
It works alongside it. Intake and tracking happen in Microsoft 365, and returns are prepared in your tax software as now. Where the software can export a client or status list, that export can feed the Power BI board so the whole season sits in one view.
Do clients need a Microsoft account?
No. Anyone with the file request link can upload documents without OneDrive or a Microsoft account, and the questionnaire opens from its own link. Clients see a simple upload page, never your firm's folders.
Can you tell us which documents each client needs?
No. Lightray isn't a CPA firm and doesn't give tax advice. Your firm decides the organizer questions and the document checklist; we turn them into forms, folders, reminders and a status board.
Is it too late to set this up for the coming season?
Fall is the ideal time, but a smaller version, document requests plus a reminder flow, can still go live mid-season. The status board can follow once the basics are working.
You Won’t Get Handed Off to Junior Staff.
At most consulting firms, the senior person who sold you shows up for the kickoff — then you get handed to a team of juniors learning on your dime. That’s not how we work.
When you hire Lightray Solutions, you work directly with Edward Pinela, MBA — a principal consultant with 20+ years of experience across Power BI, web development, SEO, and CRM systems. Edward architects every engagement personally, stays involved through delivery, and answers his own phone.
Read Edward’s Full Bio“Mid-market companies deserve senior-level expertise without paying enterprise-agency prices. That’s the gap Lightray fills.”
Simple. Transparent. Proven.
No black-box processes. No endless discovery phases. A straightforward three-step approach designed to deliver measurable results fast.
Discovery Call
Free 30-minute strategy session where we assess your data landscape, website, marketing — and where AI would genuinely pay off versus where it's hype.
Free · No ObligationCustom Roadmap
You receive a tailored plan with clear deliverables, realistic timelines, and expected ROI. You approve every detail before we start.
Fixed Scope · Clear PricingMeasurable Results
We execute, measure, and optimize. You get dashboards, regular check-ins, and full visibility — so you always know the impact.
Data-Driven · TransparentGet a clear plan in one free call.
Tell us what you are trying to fix. Your request goes to Edward Pinela, MBA — the principal consultant who would do the work — and you hear back within 4 business hours.
Prefer to call? +1 (714) 872-9606