Read model only: parse the three document layers, replay a pay week against the net-$0 standard, classify variances. No payment execution — Chase upload stays a human step.
Type the pay week ending (a Saturday, e.g. 03/14/2026). The server finds the week's three files under the accounting folder — payroll_<PWE+6>.xlsx, Direct Deposit_<PWE>.csv, Check_<PWE>.csv — and replays the week against the net-$0 standard. Hourly nets are computed from the sheet's own rates and hours; salaried (WEEKLY) amounts come from the payment export; deduction-only rows are expected to be unpaid.
payroll_MM_DD_YYYY.xlsx (the master pay record) straight in — or its CSV export, or a pay-report PDF
"1R001 DETAIL REPORT.xlsx" (2026) or Carter "NNNNN DETAIL REPORT.pdf" directly, or CSV: Invoice, Week Ending, EMP#, Name, REGHRS, OTHRS, RATE, OTRATE, TOTAL
Week ending for PDF/xlsx detail reports — the real 1R files ship with an EMPTY Invoice Date, so set this BEFORE adding files. (If this box is empty and a sheet does carry a usable Invoice Date, that date is used automatically and noted next to the file.):
flattened NACHA CSV (1/5/6 records, amounts in cents) — load ALL files for the day
no header: i|c, account, check#, MMDDYY, amount, payee
Contractor, Originating Week, Correction Week, Hours, Owed, Paid, Executable Ref, Invoice Ref, Resolution
Name, Week Ending, Claimed Hours — triggers hours-variance detection