Xero - beautiful accounting software

Xero Business Community

Xero Business Community

Hi everyone, Come on over to the new discussions in Xero Central. It’s a more intuitive way to connect and chat all things business with one another. Ask questions, dish out answers, and get involved.

You can still view topics in the Xero Business Community to see all the useful knowledge that’s been shared there; and you can restart conversations you feel have been of huge value to you on Xero Central.

If you have brilliant ideas for innovations, you can keep on adding feature requests in the Xero Business Community, and voting on existing requests. There’s more in store, as we come up with the best way to take on your thoughts and share developments
Community > Payroll Feature Requests >

Payroll Activity Reports Mashup (Summary vs Details)

Started by Jennifer Mackenzie in Payroll Feature Requests | Idea

While the Payroll Details Report contains all of the information I require, it is not formatted in a way to make data manipulation at all easy in Excel. I really need the earnings information contained in the Employee Activity Summary, but in a grid format like the Payroll Activity Summary, allowing a line for each employee and a column for each earnings type, for what ever period selected

Annual Leave Ordinary Hours Overtime Travel Allowance
Fred 200 500 50 12
Jack 500 250 0 15
Cliff 0 600 90 12
Thanks for coming into the Community, Jennifer 👋

Totally understand that the layout of the Payroll Activity Details report isn't formatted in a way for you to easily manipulate the data in a spreadsheet.

There's no plans to make any adjustments to the layout of the report coming up however we'll continue to keep an eye on this thread to gauge the interest, and let you know if anything changes 😊

Cassidy H (Community Manager)

Is there any way that I can create a custom report myself?

Jennifer Mackenzie