258 results found
-
Custom Report - Ability to Hide/Unhide Columns
Currently we create a budget for each tracking category (department).
I have created a custom report which includes the budget for each category. I then use the formula function to sum the budgets together.
I only want to see the formula column in the report outputted. (I realise that columns can be hidden when data is exported to Excel)
I understand that there is not a way to show a formula column without all the individual budget columns.
Enhancement suggestion: include a radio button for each column to hide/reveal that column in the report
20 votes -
General ledger details - Add Posted date and Posted by columns
I was requesting for "Account Type" and "Source" as options that can be added to "Journal" report.
Staff replied these options are available in "General Ledger Details" report and "Journal ID" is also available in "General Ledger Details" report now.
However, the "General Ledger Details" report does not have accounting entries posting date and who was it posted by.
Please add (1) "Account Type" and "Source" to "Journal" report, or (2) "Posted Date" and "Posted By" to "General Ledger Details" report.8 votes -
Business Snapshot - Ability to show monthly and quarterly comparatives
In the Business Snapshot all of the comparatives are to previous year. In a startup this isn't meaningful as prior year balances are nil, but month-to-month or quarter-to-quarter comparatives would be super useful. In established businesses also, monthly and quarterly comparatives can be very useful.
20 votes -
Receivable Invoice Details Report - Add Contact Location
It would be great if possible to run an invoice detail report which reflects customer location.
8 votes -
Account Transactions report - Add Transaction number
I exported the Detailed Account Transaction Report. Additional column I need is the transaction number so I could group or filter the specific transaction/s that I want to conduct further analysis.
Thank you.
8 votesJust to check, when you say Transaction number would this be the journal ID or the transactions reference number, Archie?
-
Assurance Dashboard - Add Reporting Functionality
The assurance dashboard has been around for a while and it's great to have a number of checks accessible in the same place. However, there doesn't appear to have been much development in this area i.e. we are still not able to export out reports from the Assurance Dashboard.
A client reached out today looking for an easy to run report showing bank account number changes. This is an important item to check on for businesses, particularly entities that have bank accounts loaded into Xero by multiple people, use batch payments etc. Accessing this information through the assurance dashboard is…
16 votesHi everyone, appreciate the feedback on my last question. I've slightly amended the title of this idea. As a bit of an update from when I last posted we have actually made an update in History & Notes as I know some of you were interested in - You can now Export to PDF or Excel from this screen and you'll find there are filter options to help you zone into the items you're most interested in looking at.
-
Top Customers Report - Ability to show chart in Net figures
To be able to run Top Customers report showing the net figures and not just gross.
18 votesAaah thanks for the clarification, Vicky and Alex. You could use the Management report to add the Top Customers report. Appreciate that the chart itself displays for Gross figures right now. We'll continue gathering interest for this here.
In regards to the sort order of the report - By default contacts will be sorted by the Gross column, however you can add a Net column and re-sort by clicking on any column header. 🙂
-
Reporting - Option for selective printing (similar to XPM)
Only option is to export documents from Xero. Can the Print option, like in XPM (see attached pic) be added
7 votesThanks for your engagement in this idea, everyone. Apolgies it's taken so long to update you here, and appreciate the confirmation of where you'd like to see this.
We want to be honest that we don't have any planned work for developing print options at the organisation level atm. If there's any changes to share we'll let you know.
-
CIS - Breakdown on CIS Suffered Report
It would be a massive help if you could click on the figures on the CIS suffered report to see which customer invoices make up the report figures. Clients often ask me which invoices are included and I have to manually work out where the figures come from
30 votesHi all, wanted to share a workaround here for those who aren't already aware.
You can run the Account Transactions report on a cash basis and if you filter it by the CIS Labour Income or CIS Asset account, you can see the invoices which have been included in the CIS Suffered report.
We don’t have any plans in the near term to expand functionality on the CIS Suffered report. If anything changes in this space, we’ll update you on this idea!
-
Tracking Categories Report - Ability to print/download tracking categories
Tracking Categories Report - Please add the ability to print/download the tracking categories
49 votesHi team, to export a list of all Tracking categories in your org, you may find the Tracking Summary report of use to you here. Alternatively, you could run the Account Transactions report and Summarise by the Tracking category.
The one caveat here for both reports is that they'll only show a list of the tracking options that have been used within the date range the report is run.
-
Xero Project reports - Click into transaction from report
Xero Project feature idea
- drill down transaction from Xero Project reporting
- Report template Xero Project layout can not be saved to custom report template
- assign project to Payroll
- Inactive jobs, still showing in the list although its in the different section, in my opinion the inactive project should not show up at all, should make the same like employee list where there is a dongle to show inactive Projects.
16 votesAppreciate you have a few ideas for Projects here. We try to keep 1 idea per thread so others understand what they are voting for and we can clearly share the information back with our Product teams.
I've changed the title of your idea here to reflect your first idea and welcome you to create new ones for the other ideas that you've suggested.
-
Account Transactions Report - Show date transaction was raised
For the account transactions report please can you add more column options to include the contact/supplier name and entered date. This is helpful in analysing the transaction data further.
57 votes -
Reporting - Customer Profit & Loss and Budget Variance
Please provide a report by Customer for Profit and Loss and allow us to upload a budget for each customer so we can include the forecast in XERO. QBO has much better and flexible reporting than XERO. Please see attached QBO Report of P&L by Customer. Please mimic this report in XERO.
7 votes -
Reporting - Change ordering of Account Type on Trial Balance when grouped
Can you please add a profit and loss formula / row in the trial balance report or create a new trial balance report that includes the profit or loss for each selected period.
27 votes -
Reporting - Switch layout between left-right and right-left
When you download a P&L / BS report (whether old or new templates), and include comparative periods, there should be an option to choose left to right, or right to left. If i have downloading for Jul-22, with 12 months of comparatives, i want the oldest month to be on the left, and Jul-22 to be all the way to the right. That is typically how all excel financial models are built, and the basis of these models is historical financials.
28 votes -
Aged Payable/Receivable Report - Option to include CIS Deduction Value
Add CIS Deduction value to the Aged Receivables and Aged Payables reports. In the same way Outstanding VAT value is an option to include in the reports, also include CIS Deduction.
69 votes -
Simpler BAS - GST Reconciliation Report
GST Reconciliation report to work using the Simpler BAS option. It doesn't seem to pull anything that's already been filed/finalised through using this report
43 votes -
Reporting - Add Graphs and Pie Charts in Management Accounts for KPI
Add Graphs and Pie Charts of KPI's to the Management Accounts report as some client prefer picture diagrams.
29 votesAppreciate your feedback around how more visuals in reporting would aid when presenting business information to stakeholders.
Though not direct within the Management report - Xero Analytics provides visual tools to assess and get insight into your business with Short term cash flows and Business Snapshot.
Alongside this, our reporting team have also started release of a graph in the 'Expenses by Contact report' - It's available if you're running a US organisation atm, and will be with other regions soon
-
Projects - Add 'actual hours' and 'estimated hours' to Summary Report
Project Summary Report always had actual hours and estimated hours on and since it has been updated this option is no longer available and that is 2 of the most important columns for us. Also the wording of the headings have changed and no longer match the Project Details report which is ridiculous. This report needs to be converted back to how they used to be.
12 votes -
Reporting | Copy custom report - Editing Shortcut
When selecting a published report to copy for the next period, it would be ideal if there was a copy and edit option in the shortcut options. This would allow users to create a copy of the report from the main menu instead of being required to open the report and then selecting the option.
9 votes
- Don't see your idea?