169 results found
-
Report - Show Opening & Closing Balance, Total Debit & Credit for All Accounts in Columns
To have a report that can check the information of opening balance, total debit, total credit, and closing balance during the date range for the all the accounts in columns.
1 voteThe Account transactions report in Xero can give you the information you're asking here, Jiin Chiang.
If you don't want to see all the account detail you could 'Summarise by Account'
-
Aged Payable/Receivable report - Foreign currency data as a footer in new report format
It would be good if we could add the foreign exchange rates to the bottom of the Aged Payables and Aged Receivables report in the new report format like it is present in the old format.
18 votesHey community 👋 thanks for supporting this idea, I'm popping in to switch it across to delivered!
We’ve added a new currency icon which displays next to figures on the Aged Receivable and Aged Payable reports, to indicate that they include revalued foreign currency amounts. Clicking the icon displays a popover with the exchange rate information. It also includes a hyperlink to the full exchange rate note at the foot of the report 🎉
The exchange rate note will display by default, but we’ve heard from some customers that they want the ability to hide the disclosure. We’ve added this option under the More button. Hiding the disclosure this way will also remove it from all exported versions of the report. The disclosure can be re-added to the report later if desired.
-
Reporting - Duplicate Supplier Bills
Xero will alert if there you are posting a duplicate manual bill but not if the bills are imported. Being able to run a report to show any duplicated supplier invoices that have slipped through the net would be amazing.
2 votesThanks for confirming, Kayleigh 🙂 In this case you should find the Payable Invoice Summary report which you could either Group or Filter for Reference 'contains'. This way you should be able to scroll through your invoice within the date range and quickly pick up where there is more than one bill entered wit the same reference.
I've attached an image from our demo co. for reference on filtering
-
Account Transactions report - Filter by Account type
When producing an Account Transactions report, it would be helpful if we were able to filter by type (e.g. only P&L items, or only Balance Sheet items, or codes within a certain/custom range). At present, we have to select or deselect on sometimes a rather long list of accounts.
9 votesThis is possible with filters in the newer version of the Account transactions report!
You'll see Account Type as an option from Filters through which you can select which ones you'd like to make visible in your report.
You can even go a step further and group by Account Type if that's a better view for you, too.😁
-
GL report - Include tracking categories
General ledger reports include tracking categories
5 votesHi team, as previously noted although not in the General Ledger specifically it is possible to get this information running the Account Transactions report in Xero, this can then be exported if you'd like to make use outside of Xero.
We'll mark this idea delivered with the option above, if there's particular reason you need this detail in the General Ledger welcome to add this idea back in the forums and please detail your needs to be considered.
-
Report Settings - Option to set defaults for cover page & content page
for blue xero, we have to continually tick COVER PAGE, CONTENT PAGE, and other functions. Please allow us to set a permanent setting so we can generate the reports more quickly
4 votesHi team, while not completely obvious this is already possible from Xero HQ.
In Xero HQ, when opening a report template there is an Options button which contains Publishing defaults where you can choose to automatically include or exclude Contents page and Cover page.
-
Reports - Ability to sort new general ledger detail report by account code
in previous general ledger summary report you were bale to sort the general ledger by account code so the profit and loss and balance sheet items were grouped together in the excel report. Please can you implement this feature to the new general ledger detail report
1 voteHey Matthew, thanks for sharing this idea - this is actually already possible in the General Ledger detail report!
From the 'Grouping/Summarising' drop down menu, you can select 'Group by Account Code and Name' to organise the transactions by Account Code.
I've also included a screenshot of where to find this option 😊
-
Short Term Cashflow - Include repeat transactions
Short Term Cashflow Tool Improvements:
- Able to add recurring money in money out entries
- Able to print Graph and money in/out list to PDF
- Able to review past transactions (old dates)12 votesHey community - the team have been working on the ability to include repeating transactions in Short-term cash flow, and I'm happy to announce that it's being released today 🎉
Since this idea was updated to reflect the first point in the description, I'm switching it over to delivered.
As mentioned in our last update, if you're interested in print/export functionality for Xero Analytics Plus you can add your vote to the idea here
I can’t see any other ideas about the ability to review past transactions but can confirm that's not currently planned. If it’s still important to you feel free to start a new idea for it.
-
Profit & Loss - Show Invoice Numbers
Currently there is no functionality in Xero to populate the invoice number in the Profit and Loss report while the reference field is filled out. Would like to have the invoice number to be shown as well for easy reference and checking.
3 votesHi team, as noted in my last update you can click on the figure in the Profit & Loss which drills down to the Account Transactions report.
You'll find that you can adjust the report settings to add 'Invoice Number' as a column so you can see both pieces of information on the report.
-
Default dates in reports
With the old reports we were able to set the report dates and then save the link. For example for the 2022 year I have the Profit & Loss, Balance Sheet, Trial Balance, Journal report, Accounts receivable etc with the default date 01/07/2021-30/06/2022. I have saved these links into a folder on my browser and then whenever I open up the report to whichever client file I am in in automatically defaults to this date. Is there any way the new reports can default to an annual date so that we don't have to keep refreshing the date every time…
2 votesHi Ineke, this is possible in the newer versions of reports. Once you have the report set up as you like you can save as Custom.
There are both common date formats such as Last Month, This year etc, or you can set a custom date range.
Once you've saved the custom report, you can also make this more readily available by favoriting it. 🙂
-
Aged payable reports - Set default for updated settings
Xero aged payables- the old reports were much clearer and useful.
We would like to be able to set the report so we can have the dates along the top and invoice date rather than having to go in every time and have to manually change it. It has become quite laborious.1 voteHi BNNL, once you've set up the report with the settings as you like you can save as custom to access with this same layout anytime. You can go a step further to make this the default if it's the layout you'd like everyone in the org to use too.
-
Outstanding Credit Notes, Overpayments Prepayments Report
Report to show all open (unallocated) Credit Notes, Overpayments and Prepayments in orginal currency.
5 votesHi everyone, this is actually already possible through the use of the Payable and Receivable Invoice Summary and detail reports.
You can adjust the filters of the report to only select Overpayment, Prepayment and Credit note Source items, as well as set the Status so you only view Draft and Approved items.
Once set up Save as custom, so you can easily access this view anytime. 🙂
-
Reporting - Compare Tracking Category
When using the new version of the P & L and selecting the Compare Tracking category option, would it be possible to build in a function where the report only shows items with any activity in the selected period, rather than showing everything?
8 votesThanks for your interest in this idea, everyone.
We've made a recent change to the way you can view Tracking in the newer Profit & Loss! We appreciate the efficiency users found in being able to compare tracking across categories with the older reports and have uplifted this in the newer version.
You'll now see the option to ‘Compare by tracking categories’ on the screen when you open the new Profit & Loss.
When selecting tracking categories, if there has not been any activity within your selected report dates you will not see a column for this shown in the results when the report is run - This is part of the releases mentioned last month in “A sneak peek into what’s next for reports in Xero”
-
Payable invoice detail report - Filter to show "No VAT" transactions
Payable Invoice Detail reports - Ability to Filter VAT Rate Name and VAT Rate (as one can in Receivables)
In the Receivable Invoice Detail Report, the filters include both the "VAT Rate Name" and "VAT Rate". These are not currently available in the Payable Invoice Detail Report, but would greatly assist anyone trying to reconcile the figures in this report with those shown on the VAT Return. As such it is essential to ensure that the figures submitted in Box 7 of the VAT Return are accurate.
2 votesHi team, the Payable Invoice Detail report has filter options for both VAT Rate and VAT Rate Name. Including an option under VAT Rate Name for 'No VAT'
-
Customer Invoice Report does not have any equivalent in New Reports.
Customer Invoice Report is being retired but there is no equivalent new Report to provide a list of Invoices issued. This report is essential for monitoring invoices issued and payments received where the Xero subscription is for a non GST cash book.
1 voteHey Jill, the Receivable Invoice Detail and Summary reports have been set up with new common formats and filters that should replicate most of the functionality in the old reports.
For example, to view all your paid Invoices within a specific date range, you can run the Receivable Invoice Detail report with a filter for "Last payment date".
If that's not quite what you're after, have a chat with our support team 😊
-
Report templates - Annual accounts templates up to do date and in line with legislation
The Trust - Annual Accounts Xero SPFR template for trusts > Notes to the Financial Statements > 1. Reporting Entity states "Legal or Trading Name is a trust established by a trust deed dated [insert field: trust deed date], and subject to the Trustees Act 1956." this is incorrect as the Trusts Act 2019 passed on 30 July 2019 has replaced the Trustee Act 1956. Xero have advised "While the team is aware the templates may need updating given current focus being on the expiration of old reports they do not have the capacity to give it a priority at…
2 votesHi team, templates have now been updated to refer to the new legislation. Thanks for your contribution and sharing in product ideas, here.
-
Profit and loss + Statement of cash flows combo report
Business owners need to see the P&L and the Cash in one place. Please combine the P&L and the Statement of Cash Flows into one report so they can be viewed together.
This is how it is in professional 3 statement financial models: P&L with Cash flows directly below.
Providing a combo report would save many hours in combining them manually!
2 votesHi Patrick, you could do this with Management reports in Xero. You can add both the Profit & Loss and Statement of cashflows reports when creating a new pack🙂
-
Reporting - Ability to have the chosen font size on PDF exports for draft reports
The font size for Xero reports has increased - great - much easier for clients to read their annual accounts. However, when Exporting to PDF from the Draft reports, it previews it in the default size, which is often the wrong size. In order to preview the reports as they will print, you have to publish the report, note where you need to move/add page breaks, then delete the published report and go back into the draft report to make those layout changes. This adds an extra 5 minutes or so on to every job which is not necessary.
Solution…20 votesThanks for the support and interest in this change, everyone. While it may not be obvious, for Xero Partners or staff connected to a Practice there's an option to adjust and change the font size of your reports by selecting 'Styled PDF' when exporting new reports from Xero - Detail here will help in setting & managing your Report Styles.
If not already you use Advisor Connect to find a Xero Partner that can meet your business needs.
-
Aged Receivables/Payables Detail Report - Running total
We need a running total added within each supplier to these reports as it is very frustrating when trying to balance to supplier statements or allocate a payment.
8 votesHi team, this is possible - Make sure you've added Total as a column to the Aged Payable/Receivable detail report and then Grouping by Contact.
If this is your preferred view for the report, you can save as Custom to select and run in this format whenever you need.
-
New Journal Report - Manual journal search
The old journal report allowed one to search for Manual Journals, the new report does not; it would be invaluable to drill down into the new journal report to search manual journals only :-)
1 voteHi Vanessa, great to hear you're using the new report! 🙂 If you click on the More option in the report you'll see this is an option that can be selected - see my image below.
- Don't see your idea?