164 results found
-
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.
-
Reporting some expenses only
I'd like to create some customised reports for particular costs and wondered if there's any option to just report on some costs of the business without having to lump all the other ones somewhere
1 voteYou should find the Blank report can be used to create what you're after here, Mary-Ann.
-
New Reporting - Automatically include cents
On the new reports the cents are always off and when you are reconciling the bank to me as a bookkeeper you want to cents to be included and not having to tick an extra button to say please include. I have noticed the reports have been geared towards accountants and not bookkeepers as all my reports have cents on them however the bank reconciliation report it's just doesn't make sense to me. Or if you could set in your set ups to always include cents and then this stays that way in the entire Xero file that would be…
1 voteHi Anja 👋 we just released Report preferences to everyone from today!
If you have the Adviser or Standard role you can access this from Advanced settings - see more on this here 🙂
-
Journal report - Include account Type and Source
Showing Account Type and Source
1 voteHi Joanne, you can include both Account Type and Source as columns by running the General Ledger Details report which also allows you to view Journal ID 😁
-
Journal report - Export with Narration / description
Could we please have an update on Manual Journals, so if you extract the Journal report it would so the narration/ description we add the each line of the journal report.
Also if we can print PDF a specific journal so it flows well with the above information1 voteHi Navisha, our team have been making lots of development with Xero's new reports.
Yesterday we released the new Journal report where you'll find you can add both Narration & Description as separate columns in this report.
Once set up, you can export the report to PDF, Excel or Google Sheets 😁
-
Journal Report - Filter by posted date
It would be really useful if the journal report could be filtered on posted date as well as transaction date, currently they can just be filtered by posting date.
That way you could quickly highlight transactions that were posted in a period, after a certain point like a VAT return submitted or trial balance exported for accounts preparation.
1 voteThanks for your idea here, Adam. Our reporting team have just release a new version of the Journal report where you'll find this is now possible!
Along with more detail, you'll find there's the ability to Filter by any column added, including Posted Date 😁
-
Reporting - Display currency report is run
Hi,
When we export the management accounts of the companies, the currency is never mentioned which is not convenient.
It would be great to add the currency on these documents as we have a lot of currencies.
Thank you.3 votesHi all, coming back in to confirm that as of today you'll find you can now run the Profit & Loss, Balance Sheet and Budget Variance reports in currencies the org has been using, and you'll be able to select and see the currency the report is run in at the top in the report settings. 😁
If there are other specific reports you'd like to see this developed in please do start a new idea in the site here and we can get a feel for the interest in each of these, too. Thanks!
- Don't see your idea?