Payroll reconciliation

Hi. I am having issues with my payroll being reconciled to my general ledger. When I process a payrun, I pay each staff member individually and then the PAYE, Kiwisaver etc to IRD as a lump sum (I'm not using electronic filing).

When the transactions come through on the bank feed I then match them to the Payroll entry created by the system, however it keeps working out incorrectly, as when I match the staff members pay from the bank feed transaction to the payroll transaction, the bank feed amount is the Nett amount paid to the staff member, but the payroll entry is the Gross amount including the PAYE.

This then means that when I pay the lumpsum of the PAYE to the IRD it comes through as an additional amount on the bank feed but I can't link it to the Payroll entry because its already been used for the individual staff pay amounts.

This means that each fortnight, double the amount of PAYE is being recorded so my expenses are incorrect.

Thanks