223 results found
-
Reporting - Show date and time stamp report was run
Ability to show date and time stamps, to see when the report was run.
Purpose: This will help users to do their Audit Trail.
242 votesHey community, thanks for your continued interest in this idea. Earlier this year we delivered some updates to reports, so that they’ll now show page numbers and date stamps when exported to PDF.
This is an idea that was seeded by the community team when we launched Product Ideas back in 2022.
The Product team has done some great work to address the original request but reading the commentary here, the scope of the idea has grown a bit since then!
We’re confident that this release solves the original request so I’ll be marking this as delivered.
There are additional improvements that have picked up some momentum in the comments: to make the date stamp toggle-able, and to extend the field to include time as well. To be open we don't have plans to progress these specific asks.
-
Profit & Loss - Filter Tracking Report by second tracking category
Filter Compare Tracking Report by second tracking category - run the compare P&L report with the P&L down the left and the categories across the columns but then be able to filter the transactions within this report by the second tracking category.
136 votesHot anticipation for this idea - We're pleased to share that this change is going live! (If you don't quite have it yet it'll be with you in the next 2 days)
If you use Tracking in your org we've added a new 'Compare tracking categories' option on the front page of the newer Profit & Loss.
While the older version had a limitation of selecting 100 options at a time, the team have doubled this, so now you can select up to 200 tracking categories to view at once.
In terms of activity
- Archived tracking options won't be shown by default but there is a switch to view and select these if you choose.
- When run, the report is designed to only show columns for tracking options that have had activity within the date range the reports run which should help you zone-in, and get a better view of…
-
Bank Reconciliation Report - Ability to run for multiple bank accounts at once
In the new format Bank Reconciliation report, can we please add a 'select' option for the bank account field, similar to the 'Account Transactions' report and how we can 'select' multiple CoA codes to look at at the same time?
I have a client that has 30+ bank accounts, and having to run the bank reconciliation report 30 times to check if they are reconciling/have errors is very painful.
123 votesHey community, just following on from Kelly’s update a few weeks ago, you can now add multiple bank accounts to the Bank Reconciliation report 🎉
In the new Bank Reconciliation report pack, you can now click ‘Add report’ to add in a new Bank Rec Summary report for each of your accounts - removing the need to run the report again each time you change bank accounts.
Thanks again for all your feedback on this one 😊
-
New invoicing - Display the item code
Display the item PRODUCT CODE (similar to the old invoicing) - we have a lot of similarly named products, so need to see the product code to differentiate.
103 votesQuick turn around on this one, team. Today we've released a change, and you'll now find item code is shown when viewing an invoice with new invoicing. Thank you for your feedback and voting on this idea.
-
FX rates used on Balance Sheet report
The 'old' balance sheet showed the fx rates as a note at the bottom - can we have the option to add this to the new balance sheet layout.
99 votesHi everyone, we've just released disclosures for foreign currency in Balance Sheet, Profit & Loss, Trial balance, Movements in equity, Budget Variance and the Blank reports.🙂
When you run one of these reports in base currency you'll see indicators next to amounts that have been translated that show the exchange rate that was used.
Where applicable and you run one of these reports in a foreign currency there will be an indicator next to the currency sub heading that links to a note which display the exchange rates at which the base currency has been translated to foreign currency as at the report date, and any comparative dates.
We'll be extending this feature across more reports and I'll return to share as these come available. Thanks! -
Purchase Orders - Report on outstanding
Ability to get reports on outstanding purchase orders.
Purpose: User can get the detailed information on outstanding purchase orders.
80 votesHi everyone, our reporting team have released enhancements to both Payable Invoice Summary and Details reports to enable you to be able to bring Purchase Orders in to view as a Source.
Along with this, they've also provided common formats to easily view all Purchase Orders, or outstanding Purchase Order at once!
Thanks again for your feedback. We know this has been a highly anticipated feature for community and we appreciate your contributions. -
Trial Balance - Ability to run for a date range
The ability to run a date range in a Trial Balance report.
Purpose: Having more flexibility when running the report by having the date range function.
71 votesHi team, we're grateful for your contributions and support in the ability to run the Trial Balance report for a date range. In the last few months we released our new version of Xero's General Ledger report which can solve the underlying needs of what's being asked here.
With the General Ledger Summary and Detail reports you'll be able to get a view of all accounts with a balance. Mentioned by a few in comments there's the ability to include or exclude opening and closing balances from these reports.
Most fundamentally asked here - these reports can both be run across a common date range or a custom date range for extended periods.
- Worth noting in difference to the Trial Balance YTD column, when running the new GL reports across a change of FY date range will show Net movement in the period and does not capture roll-over journals
…
-
New Invoicing - Show Branding theme on an approved invoice
With the new invoicing the branding theme is not available which is an important feature for us since for different clients we had different branding theme. Can this be added to the new invoicing system? Please refer to the attached. We cannot switch to this new invoicing if branding them is not added and it seems in September we will not have a choice. Clicking on edit invoice is not a solution. This info was available with the old system without clicking edit invoice
68 votesUnderstand the sentiment and urgency in wanting this feature available. We've just released an update so now you can view the branding of an invoice when viewing. This is visible on invoices with Awaiting Payment and Paid status 🙂
Thanks for your feedback and staying across the progress with us here.
-
Trial Balance - Ability to see current month figure along with YTD
The ability to see current month figures together with year to date on a trial balance report. This was possible on the old version of the trial balance but not on the new version.
68 votesThanks for adding input and sharing how this idea could help with your business.
Taking on board feedback, and considering some of the changes we've made across reporting recently we wanted to highlight the General Ledger Summary report that can be set up to meet your needs here. 🙂
You can set up the new General Ledger Summary report to run for a 'Month' date range, and select to include Opening and Closing balances.
With this run, Debit and Credit columns will only show the movement within the period, while the closing balance will be the YTD figure for the account (showing as positive or negative).
If you find this handy, you can save it as a Custom report rather than having to set up the layout each time you'd like to run the report.
-
New Aged debtors report - Full monthly aging periods
The 'old version' Aged Debtors report 'aged' the figures into months (as it should).
The new 'Aged Debtors' report does not.
If you run it at month end 'such as June' then the 'current' period' picks up 30th June, then the next period picks up 1st to 29th June.
It was reported to Xero support and their suggestion was......
"As you’ve found, right now it's not possible to show the full month for the first month on the New Style report for Aged Receivables Summary. This is working as expected. Please continue to use the Old Style report as that…51 votesThanks for all your feedback on this one, community 🙂
Good news! Recently, we rolled out an update to all our ‘as-at’ type reports.
Now, you’ll notice that the report runs as at the end of the current month by default, and all of the invoices for the month will appear in the column you expect them to. The Current column will still contain any future dated invoices when ageing by Due Date, but will always be empty now when ageing by Invoice Date - See our before and afters
-
General Ledger Exceptions report
General Ledger Exception Report
Getting new updates and new reports is fine but can you please keep this GL Exception report (old version) or else make arrangements to create the same report in the updated versions of General Ledger Reports.
This report is very useful and crucial for setting up work papers.
50 votesHey community, thanks for your interest in this idea, and for sharing your feedback on the new reporting experience.
We’ll be rolling out a new version of the General Ledger exceptions report, and you should see start to see it pop up in your reporting centre from today 🎉
Unlike the older exceptions report, this is a dedicated report. So you'll no longer need to navigate to the GL Summary to find it - saving you a couple of clicks!
-
BAS - Undo a failed Activity Statement lodgement
There needs to be the ability to undo/unlock a submitted ATO Activity Statement when lodgement has failed with the ATO and it has been rejected. When submitting an Activity Statement with a variation, they are often rejected by the ATO as the ATO recaclulates its own amounts and the submitted AS is rejected. This results in an AS that is listed as "Failed" un the Needs attention section of the Activity Statement page. There is currently no way for an end user to undo the failed AS to correct any issues for resubmission.
The failed statements now remain in the…46 votesHi community, as promised I'm back to confirm that the ability to revert a failed business activity statement back to draft is now live to all users.
Now, if your statement has failed to lodge with the ATO, you'll find an option to "Revert to draft" in the 3 dot menu icon next to the failed statement. When selected, the statement will be reverted to Draft status allowing you to correct it and re-lodge to the ATO.
Thanks for your input for this change 😁
-
General Ledger Detailed Report - Automatically show Opening and Closing Balance
To be able to see both opening and closing balance in the General Ledger Detailed report.
Purpose: Opening and Closing balance will make users easily analyse their transactions.
42 votesThanks to everyone, that got in to have a try of the new General Ledger Summary and Detail reports. I'm pleased to share that this is now live to all and available in Reports centre!
Just a reminder - to add Opening and closing balances click 'More' where you'll see this option. Once added save the report as Custom to access with this format any time. 🙂
-
Reporting - Include journal ID
Include the unique transaction ID (from the Journal Report) on other reports including Account Transactions / General Ledger reports / Project reports / Inventory Item Details report.
Purpose: So we can easily see which transactions have gone through since the last month end / close, as the transaction ID's are unique and incremental. We cannot rely on the dates of transactions as invoices will come in with old dates which will appear like they were posted in a previous month, but are a new transaction. I believe having the transaction ID's on reports will be a significant improvement for the…
39 votesThank you all for your support and feedback to the idea here. We now have the new General Ledger Detail report that includes the option to add Journal ID as a column in the report live to you all!
Within the report itself you'll be able to rearrange columns to drag and drop this where you'd like it to sit in your report, and once you have set up how you like save as a Custom report to access this format whenever you need. 😁
-
Report Templates - Change font type and size
Ability to change font type and size in report templates.
Purpose: To make users’ can provide a report that is more readable, especially for older clients who want to see the report.
39 votesThank you for each sharing and adding your support to this idea, everyone.
We've made some steps around being able to adapt the font size of reports through the use of Report styles. Report styles are available to any Xero Partner, and lets you apply different publishing styles by allowing you to set the logo, colour of titles in reports, and font size of client reports and report templates.
If you're a small business customer, reach out to your Xero advisor to understand how this could help your business, or find one through Advisor Connect today.
We appreciate there are other ideas for improving the format of reports further with improvements such as font type, or text colouring & wrapping - We have an idea across here we'd encourage you add your support and votes to and will share any future improvements on.
-
Reporting - Cash basis reporting by default
Enable cash basis reporting by default.
Purpose: Because most clients often select cash basis report when looking at comparative reports.
37 votesHi community, thanks again for your support and interest toward the idea here.
As mentioned in my last update - our Reporting team have now released Report Preferences to all organisations, which people with Adviser role can find within the Advanced settings.
With this feature there is a selection of defaults that can be set when running newer version of reports in Xero. Currently this includes whether to show account codes, decimals and (as asked here) ability to set the accounting basis the report is run in and if this is shown on the report. 😁
-
Aged Receivables report - Include credit control notes
we would like a one line aged receivables report which shows the notes in a column next to each client, eg so we can see at a glance where credit control is up to at a glance looking at all the clients rather than having to go into each one.
If not possible can we tailor a report e.g how would we show the credit limit on the aged receivable report in another column?36 votesHey Kate,
Thanks for sharing this suggestion! I can confirm it’s already possible in Xero to see, at a glance, credit control information in the Aged Receivables report.
You’ll need to either add the ‘Credit Limit’ and ‘Available Credit’ columns to your Aged Receivables report, or use the ‘Customer credit limits’ Common Format, to surface this information.
I’ve attached a screenshot as an example, and you can read more about this in our 'Show customer credit limits' article on Xero Central.
-
Profit&Loss New-Report in multi-currency
Ability to run the profit and loss new in a currency other than the organisations base currency
36 votesHi everyone, thanks for your contributions to the idea and to those who jumped in to help test and play with the multi currency before the full release.
Today I can confirm we've released the ability to run the Profit & Loss, Balance Sheet and Budget Variance reports in other currencies an org has been using to all users. If you're using multi-currency in your org you'll find this extra option in each of these reports settings. 😁
-
Reports: Remove merge cells when exporting to excel
Please don't merge any cells in the Excel export of reports 🙂
34 votesHey community! Thanks to everyone who added their votes and comments to this idea, and took the time to respond to our survey earlier in the year.
Based on this community's feedback, we've gone ahead and implemented Option A: Unmerge all cells today.
Now when you export to an excel file, you'll find that there are no merged cells.
Heads up! As a result of this change, if your business has an especially long legal name (more than 60 characters), you may need to manually merge and wrap cells for better printability 🖨️
-
Reporting: Profit and Loss report - Show all tracking categories in separate columns as default
Ability to show all tracking categories in separate columns in the P&L report.
Purpose: To get a better income figure when comparing different areas/divisions in Xero.
32 votesHi team, thanks again for all your feedback on the design and how you use tracking in your Profit & Loss.
As mentioned in my last post - we've just released a change to add the option to 'Compare tracking categories' from the main view in report settings, so you no longer have to jump into the layout editor. It's in the process of being rolled out to everyone, so if you don't quite have it yet it'll be with you in the next day or two. 😁
Once you've got the report set up as you like, if this is a view you'd like to use on the regular save as custom, and you could make this the default if you like, too!
.jpg){kind=link}
- Don't see your idea?