92 results found
-
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.
-
Reporting - Add a 'Today' filter option to reports
We would like to automatically transfer daily sales data (excluding GST) from Xero into our custom system. However, the current sales reporting options in Xero do not allow us to select a “Today” filter.
At present, we have to manually set the date each day to get the daily sales amount, which makes automation difficult and time-consuming.
Idea / Request:
Please add a “Today” filter option (similar to existing options like “This Month” or “Last Month”) so that businesses can easily pull daily sales data without manual date entry.This would:
Enable easier automation with integrations and custom systems
Save…
1 voteThank you for your valuable contribution and for providing a clear, detailed explanation of your need for a "Today" filter in sales reporting. We appreciate you highlighting how this feature would significantly improve the automation of daily sales data transfers to your custom system.
We have completed our initial review of your idea, and it is now open for community feedback and voting. We understand that enabling more efficient, real-time data access is crucial for many businesses.
To help your suggestion gain traction, we encourage you to share it with colleagues and other professionals who would also benefit from this change. Their votes and comments will provide essential insight into how this improvement could enhance the Xero experience for everyone.
-
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.
-
Profit & Loss - customise comparison dates
Customise comparison dates
When running a P&L or any other report with comparison data, it would be handy to be able to customise the date range of the comparison data. Some reports have an option of custom date range, but it's greyed out.
2 votesWe understand that customising comparison dates in the Profit & Loss report would give you more control over how you view and analyse business performance, especially when you're working with non-standard reporting periods.
Currently in Xero, if you run the P&L for a custom date range (e.g. 1 Jan 2025 to 27 Jan 2025), you can compare that period with the previous:
- Year – shows 1 Jan 2024 to 27 Jan 2024
- Quarter – shows 1 Oct 2024 to 27 Oct 2024
- Custom – automatically sets the comparison period to the same length (in this case, 27 days) immediately before your selected range, so it would show 5 Dec 2024 to 31 Dec 2024
This idea’s now in Gaining Support. If this would be helpful for your workflow, feel free to add a vote or comment to share how you’d use it. Your input helps the team better understand what…
-
Reporting - Ability to filter by one tracking category and display columns by another on reports
I would LOVE to be able to produce tracking reports where I can select ALL items within CATERGORY A, but then display them in columns by CATEGORY B.
Eg. I use Department and Job.
I would like to see all Jobs for a particular Department in a P&L.
Is this something that may be possible in the future or would behelpful to others?
Thanks x1 voteThanks for sharing your idea, and letting us know the changes that matter most for you.
We've reviewed your idea and now it's up to the community to get behind and support it. Make sure you 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.
-
VAT - VAT report by box number for monthly/periodic analysis
We have clients where a sigificant proportion of their sales are Zero rated, which can significanly affect both net and VAT totals in certain boxes as well as the overall value in box 5 to be paid/repaid.
Could you create a report that allows the totals in boxes 1-9 to be listed, allowing comparison with prior months or periods or years.
This will be useful to see, say, the last 3 months or the corresponding prior year amounts so that percentages can be reviewed.
1 voteThanks for sharing your idea, and letting us know the changes you would like to see to the VAT reporting available.
We've reviewed your idea and now it's up to the community to get behind and support it. Make sure you 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 - 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.4 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!
-
A report that includes price, quantity and account fields for both customer invoice and receive money transactions
A report that includes price, quantity and account fields for both customer invoice and receive money transactions. Perhaps add price and quantity fields to the account transactions report
1 voteWe understand that a single report for all invoices and receive money transactions, including key details like Quantity and Unit Price, would be a big help 🤔. We know it can be time-consuming to switch between different reports to get a full view of a contact’s activity. While this specific report isn't on our immediate development roadmap, we're always looking to improve Xero's reporting. For now, you can use the Contact Transactions Summary report for a quick overview or combine exported data from multiple reports into a spreadsheet. We'll keep monitoring this idea and use your votes and comments to help prioritise our future work.
-
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.
-
Delete discontinued tracking categories from reports
It would assist to have discontinued tracking categories no longer showing on drop down menus for reports. We have several categories that are no longer in use but still show up on reporting options.
4 votesThanks for your idea and sharing in the forums here, Rachel.
Consideration would need to be given to how this behaves before and after a report date or date range is set, incase running for an older period that would include transaction lines that were categorised to an archived tracking option.
Being upfront, this isn't something we have any plans around for the time being, but we'll source interest from the community in this here, and share if there are any updates.
-
Tracking Summary Report - Add quantity Column
Hi there, would be awesome to be able to have a column in the Xero Tracking Summary Report which would sum up the quantities from what you entered in the quantity column in the Receive Money/Spend Money when you reconcile the transactions. This is especially important when organisations are measuring the quantities (eg. number of trips taken; number of food parcels handed out) are used with Xero. As it takes a lot of time to go into each transaction and see what the quantities are to get the group total, this feature would save people a lot of time.
*Screenshot…
8 votesWe're grateful for your engagement and letting us know the changes that matter to you.
We're continuing to track the interest for adding quantity as a column to the Tracking Summary report. This isn't something we have any plans for at present. If there are any updates we'll share with you here.
-
Blank Report - Ability to change layout of rows and columns (e.g Tracking Options and Dates in rows, and Account Codes in columns)
The Blank Report only allows Account Codes in rows. It would be good to have the option to Tracking Options for a particular Tracking Category, and Dates in the rows, and Account Codes in the columns. This would be particularly useful as the current Tracking Summary report is quite inflexible (you can't filter for a particular Account Code, nor edit report titles and labels).
1 voteHi Lee, we appreciate your engagement and letting us know how we could improve the Blank report for you.
We've reviewed your idea and now it can gain 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.
-
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
2 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.
-
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.
1 voteThanks 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. 🙂
-
Reports - GL Summary comparison periods to show net movement per period
Reinstate the 'Compare With' drop down.
The key benefit of the old General Ledger Summary report was it's ability to show the net movement for multiple periods.
Xero is now without a single report to perform this core function.
1 voteHi Phil, thank you for this important feedback on the General Ledger Summary report.
We understand your point about the previous version's functionality. Losing the ability to easily show the net movement for multiple periods in a single report is a significant change, and we recognise how valuable this core function was for analysis.
We're grateful for your engagement and for letting us know the changes that matter to you.
We've reviewed your idea to reinstate the "Compare With" feature to show net movement per period, and now it can gain support from other community members. Along with votes, others can now comment to share how they used this comparative reporting feature for their financial analysis.🙂
-
Reporting | Publishing - option to include cover & contents by default
Small request: Include the cover & contents page by default, please.
The following is info from a Support webpage... Publish a report from the Drafts tab. In the Accounting menu, select Reports. Select the Drafts tab. Click the menu icon kebab style menu icon to the right of the report you want to publish, then select Publish.
(Optional) You can apply different publishing style options depending on the type of report:
[Include a cover and contents page] < Can this be marked to include by default instead of having to check mark them to be included every time that I…
1 voteThanks again for your idea, John. Appreciate I reviewed this a few months ago, and while we still don't have any plans at this stage it'll be good to get a sense of interest from others here.
Make sure to share with any colleagues that may also find this helpful, so they can vote too!
-
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…
1 voteHi 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 - Re-order columns and rows using cut & paste
Instead of dragging rows and columns (which takes forever when you have long reports), can you implement a cut and paste instead?
1 voteHey Rachael, we’ve updated this idea's status to Gaining Support. This feature could simplify customising reports by offering an alternative to drag-and-drop, saving time when working with larger reports.
If you’d like to see this improvement, please vote or comment to add your voice. Community feedback is essential for ongoing enhancements at Xero.
Thanks for participating in the Xero Product Ideas community.
-
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…
2 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. 🙂
- Don't see your idea?