Fortnight's Gross Wage Report: one row per pay component per employee.
No file loaded
Required
2. Employment records
Employee master: rate, bank account, IRD number, one row per employee.
No file loaded
Optional
3. Pay period → store
Maps period code to store name.
Not loaded, will show store codes
Optional
4. Transaction categories
Maps transaction code to pay category.
Not loaded, using built-in fallback
Payroll Reconciliation / Compliance Report
Upload pays and employment records to begin
Files 1 and 2 are required and matched on Employee Code. Files 3 and 4 are optional but improve readability and categorisation, without them the dashboard falls back to cost centre codes and a built-in category map.
Key metrics
Anomalies by category
Employment records data quality
Missing critical fields
Active employees only
Employee
Store
Missing field
Detail
Flagged items
Severity
Check
Employee
Store
Detail
Amount / rate
PAYE validation
PAYE issues
Ordinary pay: NZ progressive brackets + ACC + IETC, on taxable gross only. Bonuses, leave cash-ups, termination and redundancy payouts: IRD's extra pay method (flat marginal rate).