532 results found
-
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.
…
258 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 - Display Custom Report Names in Report Packs
When I create a new Report Pack, I can name it. When I add a custom report, that report shows as the Xero Standard Report Name, not as my Custom Report Name. Please can the Custom Report Name be shown, rather than the Xero Standard Report Name. If I add two different Custom Reports (both based on the Xero Standard Report), I don't know which is which.
1 voteThanks for highlighting the value of this idea, John.
We’ll see how many others in the community would find it helpful as well.
Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero! ☺️
-
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.
-
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…
77 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 -
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.
-
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!
108 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…
-
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.
-
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…
5 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. 🙂
-
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.
-
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.
-
Aged receivable summary - Include prepayments/deposits for future invoices.
For the Aged Receivables it would be helpful to know what customers owe us as well as what we owe them. We take deposits for future invoices and they don't show on the Aged REceivable Summary.
8 votesPerhaps the Receivable Invoice Summary or Detail reports would accommodate your needs here? Omitting the aging periods this report can be filtered to only show the Status and Source(Receivable Prepayment, Receivable Invoice etc.) of transactions you'd like to see.
-
Reporting - Unrealised Gains and losses report for tracking category
Running Unrealised Gain and losses report for tracking categories
6 votes -
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…
9 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.
-
Receivable Invoice Detail report - Add the Project Name
Add the Project Name to the Receivable Invoice Detail report
7 votesThanks for sharing your idea in the community here, Trevor. We don't have plans for adding Projects to other reports in Xero at present but we'll start to get a sense of the interest for this in your idea here and share if there are any changes.
- Don't see your idea?