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 > UK Payroll >

New Expenses - no equivalent report to 'Expense Claim Summary Report'

Started by Sarah White -   in UK Payroll

In the existing Payroll there is a really useful report 'Expense Claim Summary Report' which groups employees' expense claims by the account to which they have been posted eg business entertainment, travel etc. We use this report for each employee every month to prepare their payslips.

There does not appear to be an equivalent report that is easy to access in the new expense process - to obtain the same information it appears that I need to do the following

• Change the settings of the Account Transactions Report
• Export the resulting report into Excel
• Convert the data into a table
• Filter the results to extract the data for an individual employee
• Sort the results by account code used
• Total the amounts by account code used.

If anyone knows a quicker way please will they post it - otherwise please can Xero introduce an equivalent report in the new expense process?
Hiya Sarah, appreciate you raising this and having a bit of a play around in Xero. As you know, new Expenses create Bills instead of Expense Claims. Based on the steps you've outlined, it sounds like the new Payable Invoice Detail report would be handy here. You can refine the display settings to group by account/employee, or simply add in a filter to narrow down the data you see. Keen to hear what you think. :)

Kavi S (Community Manager)  

Hi Kavi, thanks for your reply - that does the job perfectly and is an improvement on the old report! I filtered by contact to select the employee and grouped by account so I had a list of the expenses by account. It also meant that I could include the VAT claim which is useful for my VAT reporting and I couldn't get this amount of detail in the old report. Problem solved.

Thanks again :)

Sarah White  

Yay! That's great to hear, Sarah. Cheers for coming back and letting me know that sussed it out. :)

Kavi S (Community Manager)