Projects - Allow projects reporting to show project costs split by nominal codes
I need to create a report per project which shows the total costs split into nominal codes. I do not want to also use tracking - duplication of work.
Project reporting is extremely limited on Xero
Hi team, thanks for your engagement and support on this idea. We appreciate the need to have account codes allocated to projects. We will open this idea up for the community to add their votes/support on it. Feel free to share this with your peers and others who may find this feature beneficial. Cheers!
-
Andy Beard
commented
Also just piggybacking on this suggestion:
would it be possible to also show supplier name and invoice number reference on project profitability reports as would help massively when we reconcile projects ?
-
Shamien Wallis
commented
We assign a unique project number to each of our projects, and we currently use this same number as the item code when creating purchase orders (POs) and sales invoices.
We would like to know if there is a way to link all transactions to this project number so that we can easily view all related sales, purchases, and expenses in one place.
Ideally, we would like to be able to enter a project number and see all financial transactions associated with that project, including purchase orders, supplier invoices, expenses, and sales invoices.
I have tried using the existing Projects section, but I find it is not very user-friendly when it comes to assigning sales and expenses to a specific project.
Having a simpler system based on a single unique project number would make managing and tracking our projects much easier.
We would also like to have this functionality in the Reports section, allowing us to filter transactions by project number and generate reports showing the total sales, purchases, expenses, and profitability of each project.
Additionally, it would be extremely helpful to have a field where we can enter the expected delivery date for each project.
This could make it much easier to generate Work in Progress (WIP) reports by identifying projects that have not yet been completed or delivered.
Ideally, we would like to be able to generate a report showing all purchase invoices and associated costs for projects that are still in progress, based on their project numbers and delivery dates.
-
Laurence Richardson
commented
Agree 100% with Dani Bennett on this. We have to track a lot of expenses and associated revenue on a per project basis via excel spreadsheets - with duplication of data entry and potential for manual mistakes - because the tools I need are not built into Projects.
It's the biggest challenge I have with Xero and the only reason I have to consider what accounting software options we might have elsewhere.
-
Dani Bennett
commented
Yes please invest more in Projects! Many clients opt out of Xero Projects and purchase other subscriptions as the functionality (including reporting to show project costs split by nominal codes) is limited.
-
Lucy Edmonds
commented
We use Xero Projects to manage work in progress (WIP) for our clients. At present, there is no report that shows project expenses broken down by the nominal account (general ledger account) they have ultimately been allocated to.
Description of the problem
Preparing our management accounts currently involves a significant amount of manual work. For each reporting period, I have to spend around three hours manually reconciling reports by:
Running an account transactions report for our WIP account.
Going through each individual project to identify which expenses relate to that project.
Determining which expense account each cost should ultimately be transferred to.
Manually reconciling multiple reports to calculate the correct WIP balance.This process is time-consuming and increases the risk of manual error.
How we would use this feature
We would like a report that lists project expenses by both project and general ledger account code.
This would allow us to:
See the total costs incurred on each project.
Identify which nominal account each expense belongs to.
Calculate the true work in progress balance for each project.
Produce more accurate monthly management accounts without relying on manual reconciliations.Impact on our business
A report with this functionality would provide significant time savings by removing around three hours of manual reconciliation each reporting period.
It would also improve the accuracy of our financial reporting by reducing manual intervention and ensuring that work in progress is allocated correctly between the balance sheet and profit and loss account. This would enable us to produce more reliable management accounts and make the month-end process considerably more efficient.
-
Kiera Sheppard
commented
also piggybacking off this one,
**Feature suggestion: Draft invoices should not appear as “Invoiced” in Xero Projects until approved**
In Xero Projects, invoice line items assigned to a project currently appear as “Invoiced” even when the invoice is still in **draft** status.
This creates a major reporting issue for construction businesses and any business that uses staged billing, contract milestones, progress claims, or forward-planned invoicing.
For staged construction contracts, we often need to prepare draft invoices in advance for agreed contract stages, such as deposit, slab, frame, lock-up, fixing, practical completion, or variations. Drafting these invoices ahead of time is part of good project administration.
However, a draft invoice is not an invoiced amount.
It has not been approved, issued, sent to the client, or become payable. It is only a prepared document.
When Xero Projects counts draft invoices as “Invoiced”, the project report becomes misleading. It makes it look like the project has already been invoiced when it has not. This can distort project tracking, confuse staff, and make the project financial position inaccurate.
This is especially problematic where the project budget, costs, invoiced amount, and profitability are being monitored throughout the job.
A better solution would be for Xero Projects to separate invoice statuses inside project reporting, for example:
* Draft invoices
* Approved invoices
* Sent invoices
* Paid invoicesThe “Invoiced” total in Xero Projects should only include approved and/or sent invoices, not draft invoices.
Alternatively, Xero could allow users to choose whether draft invoices are included in project invoiced totals.
This would make Xero Projects much more accurate and useful for businesses that rely on staged billing, contract milestones, progress claims, and advance invoice preparation.
**Business impact:**
For construction businesses, this affects live job reporting, staged contract administration, internal decision-making, and financial visibility. Draft invoices being treated as invoiced income can make a project appear further progressed financially than it actually is.
Please update Xero Projects so draft invoices are clearly separated from actual invoiced amounts.
-
Rowland Gear
commented
This is essential to reconcile project transactions back to the nominal ledger, to ensure this reconciles to the work in progress calculations.