679 results found
-
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.
59 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.
-
Short term cash flow - Expected payment date based on history
It would help if the expected settlement dates for invoices (and bills) were based on past history rather than due dates
6 votes -
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…
75 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.
-
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 - Suggestion for matching/filtering Balance Sheet items to show 'open' amounts
Only show 'open items' on Balance sheet
Have an ability to match items in a balance sheet account, so only the 'open amounts' (which make up the total) are visible eg for accruals - don't have to see all the old accruals, and the invoices that have cleared these out. Would be able to see summary of just the 'open amounts'
1 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.
-
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 -
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 | 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?
-
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!
-
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.
-
Short term cashflow - Option to include draft invoices
Option to include draft invoices in the short term cash flow
10 votes -
Custom Reports - Include Balance sheet accounts to report movements
Hey - when making a custom report it would be really useful to be able to show the movement in balance sheet codes. For example, when preparing our month end summary we can't bring in the capitalised wages cost automatically because it brings in the cumulative balance, rather than the balance for the period. To be honest it's crazy to me that this doesn't exist, but would be great if it could!
3 votesThanks for submitting your idea on Xero Product Idea's, Ryan. We appreciate you taking your time to share changes that would be most meaningful to you.
Being open, we don't have any current plans for changing the Custom report behaviour but we'll continue to track the interest through your idea here and will update if there is any changes to share.
-
Reporting - Unrealised Gains and losses report for tracking category
Running Unrealised Gain and losses report for tracking categories
6 votes -
Reports - Quotes track invoicing
Have a Report that shows all Quotes that have been accepted, but not invoiced. That shows any part invoices that have been raised. We frequently invoice a % upfront, % mid project and then % at the end.
4 votes
- Don't see your idea?