Wages Reconciliation workpaper (WRC)

The Wages Reconciliation (WRC) workpaper reconciles wages and related deductions recorded in the General Ledger against the PAYE returns submitted to Inland Revenue.

Data extraction

Note: The wages guideline document supplied for this rebuild was flagged, on receipt, as more of a summary than production-level detail, and not fully aligned with the current extraction logic already live in production. Current production logic is confirmed working and is retained here rather than replaced.

●        Actual Gross: the monthly total of account codes mapped to Wages in CoA Mapping.

●        Return to IRD: picked from the PAYE Return Summary uploaded under Data Sources (IRD), covering PAYE, KiwiSaver Employee, KiwiSaver Employer, Employer Superannuation Contribution Tax (ESCT), Student Loan, and Child Support figures.

●        Additional information: users can add data manually in the highlighted section where required.

Requested changes (non-extraction)

●        The processed wages file no longer needs its own separate workpaper, it should be inserted as supporting documentation within WRC.

●        The WRC IRD statement should similarly be attached as supporting documentation within WRC, rather than as a separate workpaper.

Balance per GL

Sum of Wages, Salaries and KiwiSaver account codes mapped in CoA Mapping.

How to access

●        Go to Jobs and open the relevant job.

●        Click the Workpapers icon or navigate to Job Results then Workpapers.

●        Select WRC on the Workpapers Dashboard.