Profit & Loss | Tracking - Ability to drill down
The previous Profit & Loss report allowed you to filter by multiple categories. There was an add t report function which allowed users to drill down into secondary categories and export ALL of the data into one report which showed 1. A P&L Summary, 2. Detailed expenditure for the chosen secondary category. The "Add to report" function allowed the user to export the entire category details as a whole.
For our business this is critical. We are a bespoke project based company and use this filter constantly & No the project feature does not work for our business....I have tried!
Without this feature the user will need manually export everything individually to be able to build a detailed report for the chosen category...the timing of this would be insane. Please Xero bring back this functionality.
I have added an example with screenshots here for your perusal. NB: Sensitive information has been redacted.
Cherron Christie
shared this idea
-
Rebecca Lodge
commented
Hi Xero,
Tracking is really limited given it can't be used for month by month P&L and budgeting reporting. We are having to figure out manual work arounds for our client.
Your consideration on this matter would be greatly appreciated. -
Simon MacGregor
commented
The above is essential in our business as well and we currently use workrounds and manual solutions to track it.
-
Jaimee Aguilar
commented
Hi Support,
This feature is essential for our client, particularly in relation to Profit & Loss reporting and budgeting.
We hope this can be considered for inclusion in your future roadmap.
Warm regards,
Jaimee -
Cyrus Yong
commented
Currently, the monthly P&L report does not support the inclusion of tracking categories for month-by-month comparison. It only allows viewing by a single month or a single period, which limits its usefulness for comprehensive analysis.
A P&L Report with Tracking Categories by Month is essential for our analysis and reporting purposes. Without this functionality, the report does not meet our operational and reporting needs effectively.
-
Gill Fitzpatrick
commented
I use month by month P&L reports all the time and I manually add a total column. It would be great to be able to drill into the total amount for each category to review the expenses all at one time, rather than either having to generate a further account transactions report or drill into them month by month
-
David Kim
commented
I agree with Cherron. I have no idea why Xero got rid of this function with the new report update. I am having to rebuild the P&L customized statement it is frustrating this drill down capability function is not available.. We have multiple revenue and expense categories for each division and it would be a mess to see detailed transactions whenever you click on categories without filtering option.
-
Jennifer Tryggvason
commented
It would be very helpful to be able to filter report rows by tracking category.
For instance, if I was to use a tracking category as department with options of A, B, C, D:
Sales dept A & B [formula takes GL codes 100-500 dept A&B)
Sales dept C & D [formula takes GL codes 100-500 dept C&D)Clients often want to see one or two account broken down by department but not all. For example, a non profit board often wants to see a single column profit and loss with the wages broken down by dept between admin, fundraising, and programs.
This would add a much needed new dimension and flexibility to the Xero reports