Paychex payroll journal
Paychex's per-check payroll journal listing earnings, taxes, deductions, and the employer liability for a run, wrongly read as interchangeable with the net-pay register or as the year-to-date tax record.
The shape, how the file is really laid out
Exported to Excel/PDF, the file leads with company and pay-period banner rows
(client name, period begin/end, check date, run number) above the header
grid. Detail is one block per employee, and many Paychex journals print a
Current column beside a Year-to-Date column for each earning and tax, the
two live side by side and are easily conflated. Employer-liability lines
(employer FICA, FUTA, SUTA) appear as their own section or columns distinct
from employee withholding. Department and company TOTAL rows share the grid.
Amounts are USD; the check date sets the tax period; adjustments and manual
checks carry their own rows, sometimes with negatives.
The traps
Current and Year-to-Date columns sit adjacent, summing the wrong one either triple-counts (adding YTD across every run) or understates.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: Paychex Flex payroll reports documentation · Paychex payroll journal report reference