Xero - beautiful accounting software

Xero Business Help Center

Xero Business Community

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)