Own vehicle cents per kilometre tracking
Has anyone found a way to enter/record own vehicle cents per kilometre allowances in a way that also allows you to report on how many have been paid per employee so we can monitor if someone is close to the 5,000km limit before the tax rate changes?
We have the allowance set as an hourly item at the cents per km rate and the quantity in the pay entry screen is the number of kilometres.
On the standard Payroll Summary report, we can see the total quantity paid to everyone but can't filter by employee. On the Payroll Activity Detail and Payroll Category Transaction reports, we can filter by employee but only get the dollar value. I guess we could manually divide by the rate to get the number of km but surely there's a way to get this onto a report?
It's seems like it should be pretty standard for any software claiming to be payroll software.
We don't use the browser version but I did check the report options there too. If there is a useful report there, I'm open to that suggestion too.
The data is all there, I just can't get it onto a report. I've contacted support and was told it's not possible but I know there have been other instances where I've found workarounds so I'm hoping this brains trust will have a better answer.
(Please don't suggest third party report providers - we'll just track it manually if it can't be done in MYOB.)
