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.
![](https://secure.gravatar.com/avatar/80164ca1913fc231fa40d74b0f9dc7d8?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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