Blue Raven Fabrication, Inc. runs payroll every other Friday, and the first paycheck of 2026 goes out on 01/09/2026. Before we can deposit and file correctly, we need a compliance file that starts with the payroll register and ends with forms that tie to each other without unexplained differences. In this lesson, we use BRF’s Q1 2026 pay calendar and employee facts to build that file’s backbone and work one small wage base example that later drives Form 941 reporting.
If the payroll register is right but the deposits are logged wrong, Form 941 can show the right liability with the wrong cash history, which is how missed deposit penalties start. The compliance file solves that by forcing each step to feed the next step and by leaving proof of work that an independent reviewer can follow from the paycheck to the quarter totals.
For BRF, the file is easiest to think of as six deliverables that connect in one direction. We decide whether each deliverable answers a calculation question or a tie out question, then we save it in a place where it can be updated every payroll and closed each quarter. Here is the flow we want for Q1 2026 pay dates 01/09, 01/23, 02/06, 02/20, 03/06, and 03/20. Please map each item to where it sits in the flow:
When the flow is built in this order, the tie outs become mechanical. A quarter liability rollforward explains how per payroll withholdings become quarter totals, deposits reduce the liability, and any balance due or overpayment is identified before filing.
A simple set of tie outs anchors the file, and each one points to a specific error type when it does not agree.
Deposits equal liabilities paid: The deposit log total for the quarter should match what was actually paid toward federal employment tax liabilities for the quarter, and differences are usually timing, an input error, or a deposit posted to the wrong period.
Form 941 equals the rollforward: Form 941 quarter totals for wages and taxes should match the quarter liability rollforward totals, and differences are usually a missing payroll, a voided check not backed out, or a taxable wage definition error.
W-2 totals equal 941 totals over the year: W-2 and W-3 annual totals should reconcile to the sum of the four Forms 941, and differences are usually fringe benefits recorded late, third party sick pay reporting issues, or a prior quarter adjustment not reflected in W-2.
Tip Name the tie out directly in the workpaper tab name so it gets done every quarter.
A payroll run creates multiple tax obligations at once. The compliance file stays readable when we group each obligation into a bucket and label the authority that tells us how to compute, deposit, and report it.
At the federal level, the practical framework is three regimes that hit most employers every payroll. We decide which bucket a payroll item belongs in because the bucket controls the wage base and where the number shows up later.
Federal income tax withholding: Withholding is computed from the employee’s Form W-4 using the methods in IRS Pub. 15-T (2026), and the result is reported and paid with other employment taxes through Form 941.
FICA taxes: Social Security and Medicare taxes apply to taxable wages, with 2026 rates of 6.2% Social Security for employee and employer and 1.45% Medicare for employee and employer, and the 2026 Social Security wage base limit is $184,500 under IRS Pub. 15 (2026).
FUTA tax: Federal unemployment tax is computed and reported annually on Form 940 using the wage and tax rules in IRS Pub. 15 (2026), even though we track it throughout the year for cash planning and year end tie out.
BRF also operates in Pennsylvania and New Jersey, so the file needs state level buckets that stay separate from federal buckets. For state withholding, state unemployment insurance, and any local payroll taxes, the governing rules live with the state revenue and labor agencies, so we keep the state forms and rate notices in a state subfolder and reference them from the quarter rollforward.
To keep the file reviewable, we store the authority documents beside the workpapers that rely on them. For BRF, that means Pub. 15 (2026) near the deposit log and Form 941 workpaper, and Pub. 15-T (2026) near the per payroll federal income tax withholding support, since the withholding method is where reviewers most often ask for traceable inputs. Please sort the listed items into the correct bucket for the compliance file: