Reimbursing mileage through payroll
I need to set a payroll item to reimburse mileage to employees; because we claim the GST on that mileage, I had to figure out a work around which is as follows:
- Payroll Item was set up as "Addition" and used a Clearing Account rather than an expense account; a journal entry is then done to reverse the amount from the Clearing Account and expense it (minus the GST)
Up until this point, everything looks fine -- the problem is when I have to do a monthly Payroll Reconciliation, (this is mandatory as part of our company's audit requirements).
The Payroll Summary and Trial Balance do not match because of the GST; the Payroll Summary shows the entire payroll amount including GST because that's the actual amount that was paid out -- the Trial Balance only shows the expense accounts therefore the GST portion isn't there.
Does anyone have a better way to set up KM reconciliation through payroll that would still ensure the Payroll Summary and Trial Balance match? (Reimbursing through Accounts Payable isn't an option for reasons that are too much to get into).