Payroll Reconciliation v1.6

Workforce roster → reconciled monthly payroll · advance/arrears transition aware

1 · Pay period & mode

Arrears mode: pay = hours ACTUALLY WORKED (Timesheet Hours) in the period. No variance reconciliation. Use this once fully migrated.

2 · Data files (CSV exported from Workforce)

Arrears mode needs only this month's CSV. Transition and Hybrid modes also need last month's submitted estimate and last month's actuals, to reconcile the advance.
⚠ The dates above do NOT filter the data. Export the CSV from Workforce for exactly the same period as the dates selected — the tool pays whatever period the CSV covers.

3 · Salaried employees & advances (optional)

4 · Calculate

Click any white hours cell to edit (for manual adjustments like half-day sick). Edited rows highlight amber.