AU Payroll - Monthly payroll tax report
An automatic monthly payroll tax report would be fantastic. I've noticed Xero cannot do an automatic calculation of Payroll Tax like MYOB can. MYOB allows you to select pay categories (pay items) to exclude and run a monthly payroll tax report.
Hi everyone, thanks for sharing your thoughts on having a payroll report that calculates payroll state tax. We understand some of you are required to calculate tax across multiple states.
While we don't currently have a report which calculates earnings based on state, some of you have mentioned workarounds such as using the Payroll Activity Summary report. This report includes earnings totals and can be filtered by a date range and employee groups.
We recognise the value a report of this nature could have for our customers and it’s been added to the wider pool of ideas for our product team to consider for future development.
While it’s not on our immediate roadmap, we’ll be sure to keep you looped in if there’s any progress.
-
Peejay Moody
commented
Is there any update on this?
-
Jan Ren
commented
@ Xero Administrator, can you please provide step by step process, ie add the State field into the payroll. thank you in advance
-
Xero Administrator
commented
All you really need to do is add the State field into the payroll report that can be run. That would make life 10x easier and doesn't even need to be a new report.
-
Tania Petrolo
commented
Agreed - would make life much easier when doing grouped payroll tax returns
-
Suman Devkota
commented
This is ridiculous to me - Xero doesn't have any report that can be used to calculate payroll tax, let's forget about the payroll tax calculation itself.
I don't really understand how the software that's way behind on many of the (useful) reports come to be a leader in Australia. -
Jodie Everhart
commented
Any movement on this? Would be great to stop using spreadsheets to calculate payroll tax in 5 different states! I would think in 2025 that this would be a standard offering by now
-
Karen Rees
commented
State based compliance for Payroll Tax and Workers Compensation means being able to report on employees by state would save a great deal of time / manual collation.
I also agree that a column in the Payroll Employee Summary report that shows the sum of gross Wages and Superannuation would be useful (unlike the reimbursement column).
-
Tasha Palmer
commented
I process payroll with employees in 3 states. I have to separate out their wages for payroll tax and workcover. I export the employee summary to excel and manually calculate. I also add a formula to the reimbursement column to sum the wages and super. Would be great to have that as an option to calculate as well as the employees state included.
-
Sharon Johnson
commented
MYOB has this function why doesn't Xero, its frustrating to have to export to excel to try and figure out these requirements. Its an important monthly obligation that Xero doesn't fill.
-
Meagan Black
commented
Yes please! Not sure why it isn't part of the reports already as most medium sized companies need to report and pay payroll tax
-
Natasha Tonkin
commented
Agree, Xero needs to have a Payroll report for Portable LSL, Workcover and Payroll tax clients. which includes - Full name of employee, type of employment (FT, PT, apprentice or casual) Aust State they live in, Pay run 'Group' and 'Tracking' codes, capable of being selected in any date range (not just annually), Gross wages, tax, super, allowances and show 'quantity of employees' somewhere for those that have a lot of employees (100+).
-
Natalie Ters
commented
very disappointed that XERO doesn't have capability to assist in calculating payroll tax liability. MYOB does have this function hence shouldn't be difficult for XERO to add for users.
-
Sue Temple
commented
I use STP finalisation report to do my annual reconciliation but if I could have a similar report that shows everything in payroll items in columns it would be great. This is a function that is so important it really needs to be acted on as a matter of urgency. If the STP finalisation report can do it why can there be a similar report in the payroll section
-
Ali Kronk
commented
This would make things a lot easier for any state-based obligations, payroll tax in particular
-
Steven Di Bartolo
commented
Is this live yet? Any updates? Need this ASAP!
-
Robyn Welch
commented
Any updates on this? New to me client has staff in several states and Payroll Tax in both states to be reported. I gather no reports to be run to make this simpler?
-
Freya Pieroz
commented
This would be amazing. Being able to designate which employee belongs to which state for the month (instead of having to use one of the two tracking categories) would also be amazing, especially for businesses in border towns like Canberra.
(if an employee lives 5 minutes across the border into NSW, but usually works in Canberra, then usually the employer would be counting them in their ACT payroll tax. But if they work one week of the month in Queensland, then that month they're not working exclusively in one state so you have to go to the tiered tests to see which state they count for, and the first of those tests is where the employee's permanent place of residence is, so for that month that the employee worked one week in Queensland and three weeks in Canberra, the employer gets to include them in their NSW payroll tax lodgement. Fun.)
-
Freya Pieroz
commented
Yeah - the big problem for me with my own workaround is that we can only have two active tracking categories, so if I use one for payroll tax then I only have one for everything else. I'd rather have a report.
-
Janet Shen
commented
Thank you.
We already use tracking category for employee cost centres and cost centres can cover different states.
-
Freya Pieroz
commented
We get around this by manually assigning a tracking category to each employee, but that is subject to user error. An automatic report based on postcode would be easier (some of us would still have to adjust it for cross-border employees, like those that live in nearby NSW but work in Canberra, but it would give us a starting point).