Extract data from Form 941
Unstract reads Form 941 quarterly returns and the annual 940, 943, 944 and 945, scanned, faxed or exported from any payroll system, and delivers wages, withholding and deposits as checked data to your payroll or tax software.
June deposit short? check EFTPS
Form 941 (2026) · Page 1
{ "form": "941", "employer": "Ridgeway Mechanical Services LLC", "tax_year": 2026, "quarter": 2, "wages": 214600, "income_tax_withheld": 25752, "ss_medicare_tax": 32833.8, "total_deposits": 56400, "balance_due": 2185.66, "confidence": 0.94}
Trusted by tax and accounting teams around the globe
Payroll tax returns come in from every payroll system and every quarter
A firm with fifty employer clients sees two hundred 941s a year, and few of them arrive as clean exports. Most look like this.
Signed copies faxed or rescanned by the employer
Lines added and retired as the IRS revises the form
Deposit totals corrected in pen before filing
A year of quarters, amendments and the 940 in one file
Schedule B liabilities and register exports with no fixed layout
Staff key each quarter's wages, taxes and deposits by hand to tie them out, so a short deposit often surfaces only when an IRS notice arrives with penalties already added.
Unstract reads every 941 and the annual returns beside it, extracts the lines you name, ties them to the payroll register and deposit history, and posts the result to your payroll or tax software.
Parse, extract and automate payroll tax returns every quarter
LLMWhisperer, Document Studio and Flow work alone or together. Read filed 941s first, then automate the quarterly tie-out once the reads hold up.
Parse Form 941 and the annual payroll returns into text that keeps every line
LLMWhisperer reads each 941, 940, 943, 944 and 945 page, whether it came from a payroll provider's export, a scanner or a fax, and keeps the layout. Column 1 wages stay beside their column 2 tax on lines 5a to 5d, the quarter checkbox keeps its mark, and the Part 2 monthly liabilities stay in their three rows.
Pass the text to your own LLM, or use it as the first step in a quarterly close.
Learn more about LLMWhispererA Form 941 data extractor that checks the math and the deposits
Name the lines you need, and Document Studio returns every 941 as one JSON record per employer per quarter, whichever payroll system printed it. It recomputes the 12.4% and 2.9% columns, adds lines 3 and 5e back to line 6, and compares line 13 with the deposits on record. A total that disagrees with the payroll register or the deposit history comes back flagged.
Deploy it as an API or an ETL pipeline, or run it as one step of a larger quarterly workflow.
Learn more about Document StudioRun the quarterly 941 tie-out for every employer you file for
Describe your Form 941 review in plain English and Flow's agents build the workflow: filed returns collected from the payroll export, the client portal and email, each one read and matched to its employer and quarter, wages and taxes tied to the payroll register, line 13 tied to the deposit history, and the figures recorded in your payroll or tax software. You approve the workflow once, and every quarter runs it the same way.
The run hands a return to a preparer only at the points you set: a deposit total that trails the quarter's liability, wages that differ from the register, a 941-X that changes an earlier quarter, or a line the model read with low confidence.
Learn more about FlowRead this quarter's 941s now. Automate the tie-out next.
Start for free to parse and extract your own payroll tax returns. Automating the quarterly review starts with a consultation.
Form 941, the annual employer returns and the records behind them
Documents
- Form 941 Employer's quarterly federal tax return
- Schedule B (Form 941) Semiweekly depositor tax liability
- Schedule R (Form 941) Allocation schedule for aggregate filers
- Form 941-X Adjusted quarterly federal tax return
- Form 940 Employer's annual federal unemployment (FUTA) tax return
- Schedule A (Form 940) Multi-state employer and credit reduction
- Schedule R (Form 940) Allocation schedule for aggregate filers
- Form 943 Annual federal tax return for agricultural employees
- Form 943-A Agricultural employer's record of tax liability
- Form 944 Employer's annual federal tax return
- Form 944-X Adjusted annual federal tax return
- Form 945 Annual return of withheld federal income tax
- Form 945-A Annual record of federal tax liability
- Forms W-2 and the W-3 transmittal
- EFTPS deposit confirmations and payment history
- Payroll registers and quarterly payroll summaries
- State withholding and unemployment returns
- IRS balance-due notices for payroll tax periods
Fields captured
Built for the teams that file and tie out employer returns
Client 941s and their Schedule R allocations read back after filing, so each worksite's wages and deposits match what the platform reported.
Every employer client's four quarters tied to the W-3 and the 940 before year-end, with the differences listed for the preparer.
Years of filed 941s and 941-Xs read side by side, so the unpaid quarters behind a payroll tax balance are on one screen.
Each quarter's return checked against the payroll register and the deposits paid, before a short deposit becomes a penalty.
Quarter-end tie-outs without the rekeying
Built to hold employer EINs and payroll totals
A Form 941 carries the employer's EIN, the quarter's total payroll, the tax withheld from every paycheck and the deposit history behind it. Unpaid payroll tax is the fastest route to IRS penalties, and the trust fund recovery penalty can reach the owners personally, so these returns need the same care as a bank file.
- Encrypted in transit and at rest.
- No employer's payroll return is ever used to train a model.
- Access by role and employer client: staff open only the EINs assigned to them, and every correction is logged against the quarter it changed.
- Retention is yours to set, and processed 941s are deleted on the schedule your firm or payroll team chooses.
- Self-hosted deployment keeps payroll data inside your own environment for providers and PEOs whose contracts require it.
What payroll and tax teams ask about Form 941
It should read any revision of the form from any payroll system without a template, recompute the Social Security and Medicare columns, and compare line 13 with the deposits actually made. A Form 941 data extractor that returns only the numbers leaves the tie-out to your staff.
Yes. LLMWhisperer straightens skewed scans, cleans up faxes and reads figures corrected in pen, and it keeps each amount beside its line number. Document Studio then sends any value it reads with low confidence to a reviewer, with the page beside it.
Yes. It adds lines 5a, 5b and 5c across the four quarters and compares them with Social Security wages, tips and Medicare wages on the W-3. Line 2 rarely matches W-3 box 1 because pre-tax deferrals leave box 1, so that gap is shown for the preparer to explain, not marked as an error.
It compares line 13 with line 12, with the monthly liabilities in Part 2 or on Schedule B, and with your EFTPS deposit history. A quarter where deposits trail the liability comes back flagged with the months involved, while there is still time to pay before a notice.
Yes. Form 940 data extraction covers total payments, exempt payments, FUTA taxable wages, the tax before adjustments, state unemployment adjustments and the Schedule A credit reduction for multi-state employers. The 940 is then checked against the four 941s for the same year.
The payroll tax form OCR reads Form 941 with Schedules B and R, the 941-X, Form 940 with Schedules A and R, Forms 943, 943-A, 944, 944-X, 945 and 945-A, the W-2 and W-3, and state withholding and unemployment returns. Each form comes back as its own record, linked to its employer and period.
Yes. LLMWhisperer works as the Form 941 parser, and Document Studio deploys one API endpoint per document type: POST a return, get the record back as JSON. The same extraction also runs as an ETL pipeline that collects returns from a folder or S3 bucket.
Yes. Filed 941s and 941-Xs for every open quarter are read together, and each amendment is applied to the quarter it corrects. A resolution team sees the reported liability, deposits and balance for each period before it compares them with the IRS account transcript.
Yes. Describe the review in plain English and Flow's agents build it: collect the filed returns, read them, tie wages to the register and deposits to EFTPS, and record the results. You approve the workflow before it runs, and it pauses for a preparer only where you said so.
Unstract is SOC 2, ISO 27001, GDPR and HIPAA compliant. Payroll returns stay encrypted, no model is trained on them, and they are kept only as long as you decide. Self-hosted deployment is available for teams that keep payroll data in-house.
Bring one employer's four quarters to the consultation
Filed 941s, the 940, a Schedule B and the deposit history behind them. We read them live and show every line, tie-out and flag.