528 results found
-
Reporting - Calculate % from invoices for payment report to Contractors
We pay contractors based on sales reports for each contractor. Getting this report is easy. In fact, Xero does that well. However, to get that same report and deduct a % value or any other value to work out what the contractor payment will be. Then being able to save & print & Email that report. Currently, we export to Excel, and whilst that works great, it is fiddly and time consuming. Probably not for everyone, but handy for some.
2 votesTHi Steven 👋, thanks for raising this idea. We appreciate its not straightforward calculating the percentage of invoices paid to contractors, which we know creates extra manual work. Although this is not on our current roadmap, we will monitor this idea for votes and other comments. However, for now, a workaround would continue to be to export the report and use a spreadsheet application to calculate the percentages. 📈
-
Reports - Add quantity column to reports
It isn't possible to add a quantity column to a report, nor is it possible to pull through Qty data entered in Xero or create a cell the Qty can be manually typed into.
You can add a note column but this would be to link to a section of the report pack, not a quantity loaded into Xero or a box we could manually type the quantity into. Further the notes section functionality is unable to be renamed and can only be linked to other reports in the report pack. It does not work to bring through Qty data.
…
261 votesHi everyone, thanks for your engagement and support for adding a quantity column to reports in Xero. We understand there are differing reasons around wanting to add quantity to a report, like being able to track fuel for tax credits, livestock numbers, or hours worked for carbon reporting.
There's a specific idea for Livestock reporting that we'd recommend anyone interested in this joins.
To highlight, quantity can be added within the following reports within Xero right now;
- Inventory Item Details - will allow you to view quantity on hand of tracked inventory items
- Inventory Item summary - lets you view quantities purchased and sold for all items, as well as opening closing and adjusted quantities for tracked items
- Sales by Item report - will show you quantities sold for inventory items
- Payable Invoice Details report - will give you quantities purchased for all line items
- Receivable Invoice Details report -…
-
Reporting | Add multiple FY'S as common date selections
Report dates
On financial reports. Instead of last financial year of this financial year wouldn’t it be better to have the years as the selection ie 2024/25 2023/24 2022/23. it will be much quicker to select the year especially is going back further than the current year.3 votesThanks for sharing here, Kerri. Understand why you'd find this helpful and we'll start to get a sense from others that'd like to see this here, too.
I know it's a little different to what you're directly asking here, but perhaps comparison columns and saving as custom could help where you can run the report for multiple date ranges at once and view the comparison across each?
-
Account transactions report - Comparatives
Essential for cash flow and projections, an annual report divided by month that includes source and base currencies.
The "Account Transactions" report currently enables us to overview all accounts (Balance Sheet and P&L) in both currencies (source and base) but lacks a feature to display 12 months alongside each other.
6 votesWe're grateful for your engagement and letting us know how adding comparative options in the Account Transactions report could benefit you.
This isn't something we have direct plans of right now, however we'll continue to gather community interest in this and share if there are any updates.
In terms of cashflow projections, if not already you may want to check out Short term cashflows with Xero Analytics.
-
Reporting - Filter the Profit and Loss by Contact
When exporting the profit and loss transactions it would be amazing for one of the columns to show the Contact in isolation rather than merging the contact and description into one field. This would allow much easier spreadsheet analysis by contact.
66 votesHi everyone, thanks for being a part of the conversation on filtering Profit and Loss reports by contact. We understand how this could make digging into profitability a bit easier.
There is currently the Income & Expenses by Contact report that’ll show where you’ve incurred expenses or received income or funds for each contact. You could also Group or Filter this report by contact with the ability to drill down to the transactions related to each amount.
Alternatively, some people in the discussion have also kindly shared their method which may help others.
Our product team has reviewed this idea, and while this may be a development we consider in the longer term it isn’t roadmapped at this stage. We’ll continue to keep an ear on the ground here and share if there are any updates.
-
Report Templates - Option to bulk mark codes as reviewed
Report codes that are in the For Review category need a button so after changing the ones that need changing the rest can be marked as reviewed. Currently it looks like you have to click into each one to review it and no-one is going to have time do that when you can see most of them dont need changing.
Its always an extra click to view all the report codes as Xero defaults you the the codes that are For Review. If they have all been reviewed we wouldnt have to do an extra click each time we want…
6 votesHi Gay, just wanted to return from my last update. While this is something our teams took a look into, it's not something that's been planned for the time being.
For now, we'll continue to get a sense of the interest from your idea here. 🙂
-
Reporting - Option to remove the Date from the Footer of all reports
The print date that now appears at the bottom of reports is useful for some reports and circumstances, and I understand this date is now turned off for Published Reports.
However we do not 'publish' our financial statements - we send our financial statements to clients in a practical and informative pack instead. This is a more efficient, professional and streamlined approach for us.
Showing the print date on these financial statements is of concern, due to various issues including the lag time between preparing and approving the report. It is also not ideal when preparing the directors resolution and…
78 votesHi team, while this may be something we look to do in the future unfortunately we were not able to move along with the work the team had started exploring here.
We'll move to Accepted for now and if there are any updates I'll be back to share with you all. Thanks and continue to support this idea if it's something you'd like to see.
-
Reports - Shortcuts for navigating Financial Statement Reports
Shortcuts for Financial Statement Reports
It would be extremely helpful to have shortcuts to navigate financial statements.
E.g. 1 would go to the first page of the report, 2 would go to profit and loss, 3 to balance sheet etc. this would assist with quickly switching between different reports in the financial statements.5 votesHi Emile, appreciate you sharing this suggestion for specific shortcuts that would improve efficiency when working in reports. This idea is open for fellow community members to support through voting and comments.
We also have an existing idea for more shortcuts in Xero - we'd encourage you to also add your vote to that broader idea here: Navigation - More keyboard shortcuts in Xero.
Voting on both helps us in two ways: it shows our Reporting team the specific need you have, and it also contributes to the overall demand for more keyboard efficiency across all of Xero.
Thanks again for your valuable contribution to the community!
-
Short term cash flow include repeat quarterly transaction
Would love that within money out/in and repeating the transaction that 'quarterly option' was included.
example: BAS, Super & PAYGIt would be great if this was an option for those using the short-term cash flow regularly.
6 votes -
Reports - Add original currency in the Aged Payables and Summary Payables reports
Kindly would like to suggest adding Original Currency in the Aged Payables and Aged Payable Summary. Would make our reporting preparation easier. Thank you!
112 votesThanks for sharing and engaging with product ideas here. We appreciate the desire to run more reports in Xero in a different currency.
To confirm what is currently available in Xero for multi currency reporting - Right now the aged reports will run in the organisation's base currency. However, for any invoice or bill that has been created in a foreign currency you'll see an icon next to that line in your report which provides notation of the exchange rate details, and these will all be listed at the bottom of the report.
With the Payable and Receivable summary and detail reports you can add an 'Original currency' column along with other foreign exchange details.
It's also possible to add a filter to these reports to only show invoices of a particular status for example Awaiting payment.
I know this doesn't accomplish all that's being asked in this idea and…
-
Reporting - Allow monthly figures to be time-adjusted based on reporting period in custom reports ratios
In my custom income statement, I'd like to create a calculation for a debt service coverage ratio. However, I don't there's a way to set a P&I payment as "per month" in the custom features. Is there a feature to set a formula that adjusts my debt service based on the number of months the income statement covers? (E.g. monthly P&I is $5,000 per month. So a 6-month year-to-date statement would adjust P&I to be $30,000 on my printed report).
1 voteHi Michael, thanks for sharing your idea, and letting us know the changes that matter most for you.
We've reviewed your idea for custom report ratio formula and now it's up to the community to get behind and support it. Be sure to share your idea with any colleagues that this could benefit so they can add their vote too!
Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Reports/Tracking - Add filter to P&L Comparison to hide zero balance tracking columns (projects)
When comparing the Profit & Loss by projects, it would be very helpful to have an option such as “Hide zero balance projects” after selecting all projects. Currently, when we select all projects (we have more than 100), the report also shows those with zero balances (no transactions). This makes the report slower to display and download, and we have to manually remove those projects afterwards. Would it be possible to add such a feature to improve efficiency and reporting usability?
1 voteThanks for sharing this valuable idea and detailing the specific improvements you're targeting!
Our internal review is now complete, and this feature proposal is live for community engagement!
To push this forward, please share it with colleagues who would benefit, to cast their vote.
-
Account Transactions Report - Show all categories when grouped by tracking
Reports eg Transaction reports, should be able to be summarised by tracking category. Currently if a bank transaction is spread across a number of tracking categories, the transaction report will report this as 'multiple categories'. This is very unhelpful.
2 votesAppreciate what you're asking here, Simon. However when grouped or summarised by tracking and a bank transaction has multiple lines that are coded to different categories its not possible to show these all on the report.
On the flip side of this, if you run the report on a Grouped by basis you'll be able to see the transactions related to the multiple categories and can drill into the transaction to view the detail.
Alternatively, adding a Related account column to the report you'll be able to see the account the transaction is coded to. Then, running the report for the related accounts e.g Sales would give you the line by line breakdown so you can view each tracking option the transaction has been allocated to.
-
Reporting: Excel Export - Adjust default row height on exported reports
When exporting reports to Excel they are coming in with very narrow row heights. By Default Excel will create a row height 4 points larger than the font. Eg: default font is 11 points and row height is 15 points. If I increase the point size, the row height increases.
My exported reports have the general data at 9 points but the row height is at 11 points - and I'm constantly having to modify my spreadsheets.
It appears that Xero believes that a 2 point difference between font size and row height gives enough white space to make the…
3 votesHi Karen, we wanted to share a quick update regarding the idea to adjust the default row height on exported Excel reports.
This idea is now classified as Gaining Support, and we’re continuing to monitor it as part of our ongoing efforts to improve reporting features.
To the community, if this improvement would benefit your workflow, please feel free to vote and share your thoughts.
Thank you for contributing your ideas!
-
Reports - Option to specify which months to include when generating YTD monthly reports
Ability to run YTD reports where there is monthly columns totalling to the YTD column which automatically adds additional months as needed.
2 votesHi Bethany, thanks for sharing this suggestion for improving our reports.
We've reviewed your idea for an option to have Year-to-Date reports automatically generate columns for each month, which then total to the YTD figure. We can see how this dynamic layout would make monthly analysis much clearer and save time on report setup.
Your suggestion is now ready to gain support from other community members. Along with votes, others can now comment to share how a report that automatically adds monthly columns as the year progresses would improve their own financial analysis.
-
Reports - Edit spend money transactions from the Transaction Report
Would like a pop out screen to view and edit transactions from the transaction report without having to arrow back to the report after each view/edit. Currently it is extremely time consuming with appx 7 back clicks to return to the report after each individual view/edit.
2 votesThanks for your engagement and for sharing this idea about editing Spend Money transactions directly from the Transaction Report.
We've reviewed your suggestion, and it's now open to gain support from other community members. We can definitely see how having to click back and forth to the report after each edit is a time-consuming process.
Along with votes, others can now comment to share additional detail about how your idea for a more direct editing workflow could improve their experience with Xero. 🙂
-
Account transactions report - Option to Group by year
In the Account Transactions report, the Grouping / Summarising box should allow you to group/summarise by Financial Year.
For example so you can look at multiple years in a row, but you still get subheadings/ breaks for each financial year. This would be really helpful when looking at recurring expenses like finance / insurance payments.
Thanks
3 votesThanks for your engagement and sharing your idea here, Phil.
We've reviewed your idea and will now watch as it gains support from other community members.
Along with votes, others can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Business snapshot - Link to default custom Profit & Loss Report
Business snapshot - link to default custom Profit & Loss Report
We use a custom Profit & Loss Report which is default.
Unfortunately the Business snapshot links to the standard xero Profit & Loss Report not the custom default Profit & Loss report.
Can the Business snapshot be changed to link to the custom default reports?5 votes -
Management Reports - Allow flexible average comparison periods
Currently, when generating management reports in Xero, users have the ability to compare data across prior months and multiple periods. Some reports, like the Cash Summary, also include an “Average” option, which is a helpful feature for identifying trends.
It would be highly beneficial to extend this “Average” functionality to all relevant reports—particularly the Profit & Loss report—to provide more consistent and insightful analysis.
Additionally, the current average is calculated based on the financial year to date. This approach becomes less useful at the start of a new financial year when only limited data is available. To improve this, it…
2 votesThanks for sharing your idea with us! We've reviewed it, and now it's in the hands of the community. 😁
To get your idea supported, please share it with colleagues who could also benefit. They can add their votes and comments, which helps us understand how this change would improve their experience with Xero.
-
Reporting - Unrealised Gains and losses report for tracking category
Running Unrealised Gain and losses report for tracking categories
7 votes
- Don't see your idea?