Profit & Loss report - Filter by project
Project reports are very difficult to follow and understand. The ability to click a transaction and open the source is not possible unlike all standard Xero reports. A Profit and Loss by project is crucial. Project transactions need to be combined into the audit trail so that standard reports can be ran to include project information.
Karen Garrattley
shared this idea
Really appreciate those who’ve taken the time to share how this’d help in your day-to-day. We know being able to filter a Profit & Loss report by project would make it easier to understand how your jobs are performing.
Right now, the best workaround is to export your data and make adjustments for this in Excel, but we get that it adds extra steps.
There’s also the Profitability dashboard feature in Xero Projects, which gives a quick view of how each job is tracking, and may be helpful.
We’ll keep an active eye on the interest this idea continues to build through votes, but do want to be transparent that this is not in our roadmap for the foreseeable future. Thanks again for your input through Xero product ideas.
-
Victoria Elmsly
commented
Yes, that would be how we run the report, thank you! How can I free up some categories please? I have archived them in the tracking category area and we have less than 200 active projects.
-
Karen Garrattley
commented
Hi Victoria, the filter available in the P&L is for Tracking Categories and not Projects. You are possibly using Tracking Categories for your projects and you may have ran out of Tracking Categories available for reporting. Xero has a maximum number of 200 in Tracking Categories and although Xero allows you to create more, it won’t report on them.
-
Victoria Elmsly
commented
Hi, we have been able to run a P&L for a project, using the filter to choose the project. This had been available for us for over three years but this past month the income is not pulling all invoices for a handful of projects.
How far up the 'Critical' list is this please?
We are a registered Charity and are required to report to our funders and require this report to do so. Therefore, this report is critical to our business.