Skip to content

Reports & tax

Customer ideas for reporting, analytics, fixed assets and tax

Learn about the forums, how to contribute and create a good idea on Xero Central

Reports & tax

Categories

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

258 results found

  1. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  4 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  2 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  6 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. It would be great if possible to run an invoice detail report which reflects customer location.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  6 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Hi 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. 

  7. To be able to run Top Customers report showing the net figures and not just gross.

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Aaah 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. 🙂

  8. Only option is to export documents from Xero. Can the Print option, like in XPM (see attached pic) be added

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Thanks 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.

  9. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Hi 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!

  10. Tracking Categories Report - Please add the ability to print/download the tracking categories

    49 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Hi 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. 

  11. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Appreciate 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.  

  12. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    25 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  5 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  12 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  7 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  22 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Add Graphs and Pie Charts of KPI's to the Management Accounts report as some client prefer picture diagrams.

    29 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Appreciate 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 

  19. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  4 comments  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

     ·  1 comment  ·  Reporting  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?