Chapter 11.4
Payroll reports
Payroll reports answer two kinds of question. Some are about people: who was paid what, for how many hours. Others are about the government: what each tax built up, and the figures for each line of a return. This chapter runs them for Summit Gear Repair's first paycheck and shows how the figures tie to each other and to the books.
When you finish this chapter you will be able to:
- Choose the payroll report that answers a question.
- Read the payroll register and prove that gross less taxes is net.
- Use Tax liability and Employer totals to explain the taxes owed.
- Read the Form 941 worksheet, including its fractions-of-cents line.
- Read the W-2 and W-3 worksheet, and know what its full-number data sheet is for.
- Use Skipped taxes as a control.
The reports page
Payroll → Reports has two groups. Pay covers what people were paid. Taxes covers figures for deposits and returns; three of them are marked Worksheet, not the form: they give the figures to copy onto the government's form, which is filed at the agency.

| Question | Report |
|---|---|
| What did each paycheck in a stretch of time pay and withhold? | Payroll register |
| What has one employee earned this month, quarter and year? | Employee earnings |
| How many hours were paid, of which kind? | Hours |
| What was taken besides taxes? | Deductions |
| What did each tax build up, and how much was deposited? | Tax liability |
| What did the company itself pay in taxes? | Employer totals |
| What goes on Form 941, Form 940, the W-2s? | 941 worksheet, other worksheets, W-2 summary |
| Was any tax typed by hand or left at 0.00? | Taxes changed by hand, Skipped taxes |
Every report counts a paycheck on its check date, like Owed and paid. A report run for a range that ends before 11/06/2026 shows nothing for Casey; the register said so plainly when first opened, with a Show this quarter button.
What people were paid
- 1
Run the payroll register for the quarter
Open Payroll register and press This quarter. The dates become 10/01/2026 to 12/31/2026 and the report runs. Tick Show each tax in its own column to split the two tax columns.

Proving the row. Federal taxes are 153.03 + 122.39 + 28.62 = 304.04. State taxes are 157.92 + 11.84 + 1.97 = 171.73. Then 1,974.00 − 304.04 − 171.73 − 0.00 = 1,498.23, the net on the check. The register prints this rule under the table: gross less federal taxes, state taxes and deductions is net, on every row.
- 2
Employee earnings
Open Employee earnings and press This year. Each employee gets one row with four windows side by side: the period chosen, month to date, quarter to date and year to date. The windows are cumulative statutory figures, so they are each employee's whole-company totals.

- 3
Hours
Hours lists the hours actually paid, by employee, department and kind of hour, with where they came from. Casey's are typed: 80.00 regular and 1.50 overtime. Approved hours not yet paid are on the Timekeeping Payroll Feed report instead (Chapter 12.4).

What the taxes came to
- 1
Tax liability
Open Tax liability, choose Quarter, 2026, Q4, and press Show. Each tax appears under the deposit it belongs to, with the employee's share, the employer's share, the total and the wages it was worked on, then a line of what was accrued and deposited for the deposit.

The total, 686.00, is the same figure as Not yet deposited on Owed and paid and the credit to Payroll Taxes Payable in the paycheck's journal entry. Three views, one number: that is what tying out means. Each Oregon tax sits under its own deposit and carries its full name: Oregon unemployment insurance, Oregon statewide transit tax and Paid Leave Oregon.
- 2
Employer totals
Employer totals shows only the company's own taxes, for the month, the quarter and the year to a chosen day. To 11/06/2026: FUTA 11.84 + Medicare 28.62 + Oregon unemployment insurance 47.38 + Paid Leave Oregon 0.00 + Social Security 122.39 = 210.23. This is the business's payroll tax expense.

The return worksheets
- 1
The Form 941 worksheet
Open 941 worksheet, choose Form 941 and October to December 2026, and press Show. Each line carries the form's line number.

Why line 7 says −0.01. The form works Social Security and Medicare out on the quarter's total wages: 1,974.00 × 12.4% = 244.78 and 1,974.00 × 2.9% = 57.246, rounded to 57.25, so line 5e is 302.03. The paychecks rounded each half separately: 28.62 + 28.62 = 57.24, so they carry 302.02. Line 7 adjusts the one-cent difference, and line 10 comes to 153.03 + 302.02 = 455.05, the amount deposited. This is normal on every 941 and is exactly what line 7 is for.
- 2
The W-2 and W-3 worksheet
Choose W-2 and W-3 and the year. The W-3 totals come first, then one row per employee with every box. Prepare W-2 data with full numbers makes a data sheet with each employee's full Social Security number for the filing; it is kept in the secure store for 24 hours, and each employee included is logged.

The page says box 12 TT is the overtime premium only. Casey's 1.50 overtime hours carried a premium of 1.50 × 12.00 = 18.00, yet the worksheet shows 0.00. The cause is paycheck 1001 itself: its overtime rate was typed on the paycheck with no pay rate on file (Chapter 11.2), and the overtime line took that rate as its own base, so no premium was split out. That cause is fixed for new paychecks; one made the same way today takes the paycheck's Regular rate, 24.00, as the base and shows a premium of 18.00 in box 12 TT. Paycheck 1001 stays as it was, so an owner in this position would reclass the 18.00 to overtime premium and add it to box 12 TT at year end. Ask your accountant before the W-2s are filed.2
- 3
Other worksheets
Other worksheets lists Form 940 and the two Oregon worksheets for Form OQ, the quarterly combined return: Form OQ, Oregon withholding (compensation 1,974.00, Oregon income tax withheld 157.92) and Form OQ, Oregon unemployment insurance (taxable wages 1,974.00 × 2.4% = 47.38, with each employee's credit weeks and its own data sheet with full numbers; its last line reads The employer rate is the newest one entered for 2026: 2.4%., the rate typed on Rates we use in Chapter 11.1). Neither lists the statewide transit tax or Paid Leave Oregon; take those two figures from Tax liability.
Two control reports
Taxes changed by hand lists every tax someone typed on a paycheck instead of the worked-out one, with who typed it and why. Skipped taxes lists every tax left at 0.00 because it was turned off or local taxes had not started (Chapter 11.3). For Summit Gear Repair both are empty, which is the result you want to see each quarter.

A typed rate is not a typed tax: the 24.00 and 36.00 typed in Chapter 11.2 changed gross pay, and every tax was still worked out from it. The reason typed with the rate stays on the paycheck. Two more places complete the picture: Reconciliation compares imported history with the books, so it stays empty for books that never used another provider, and the Timesheet Tie-out (Chapter 11.2, Section 6) compares paychecks with approved timesheets.
Save as PDF, in this order: the payroll register for the quarter, Tax liability, the 941 worksheet, Skipped taxes and Taxes changed by hand. Clip them to the copy of the filed return. Next year's questions are answered before they are asked.
Quarter-end payroll reports
- [x] Payroll register: gross less taxes and deductions is net on every row.
- [x] Tax liability total equals Not yet deposited plus deposits, and the liability account in the books.
- [x] Employer totals agree with the payroll tax expense account.
- [x] 941 worksheet line 10 equals the quarter's 941 deposits; any line 7 cents understood.
- [x] Skipped taxes and Taxes changed by hand empty, or every line explained.
- [x] Year end: W-2 worksheet checked box by box before the data sheet is made.
Check your understanding
1. Why did the register first show no paychecks when opened on November 1?
Answer
Reports count a paycheck on its check date, 11/06/2026, which was after the range's end.
2. Show where 171.73 comes from.
Answer
Oregon income tax 157.92 + Paid Leave Oregon 11.84 + transit tax 1.97.
3. Name three places 686.00 appears.
Answer
Tax liability's total, Owed and paid's Not yet deposited, and the credit to Payroll Taxes Payable in journal entry 2.
4. Line 7 of the 941 worksheet shows −0.01. Is something wrong?
Answer
No. The form rounds the quarter's total; the paychecks rounded each half. Line 7 is the one-cent adjustment for that.
5. Which report is for the employer's own tax cost?
Answer
Employer totals: 210.23 for Casey's paycheck.