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

1096 results found

  1. Appologies in advance for my frustration.

    Are Xero considering providing a Gender Equity report in the future?
    I raised a case for our HR Dept last year and the answer from Xero was no.

    If any community member has any short cuts on gathering this info, please respond to this post.

    I am wasting so many hours trying to gather the required data from your available reports.

    In April I exported Employee contact details to export & sort.
    This morning I have been exporting Renumeration data and then sorting deleting non date range required emplyees. Due to no date range…

    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

    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)

    Thank you for suggesting a gender equity report for payroll. We recognise that many of you currently spend significant time manually merging multiple exports to get these insights.

    Whether we build a dedicated equity report or enhance existing reports with gender columns and advanced filtering, our goal is to streamline your workflow.

    To help this request move forward, please encourage your colleagues to vote for it. We also welcome your comments on how this update would specifically improve your Xero experience.

  2. Just looked at the new Aged Payable report > Aged Payables Detail - it doesn't show credit notes which been allocated to invoices. This is very confusing as we can't reconcile against the statement. Please review the report and add in credit notes, even if they have been allocated to the Invoices, or advise which report I need to use when reconciling the account.

    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

     ·  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. I need to search Invoice descriptions to find Invoices that have certain quote references.

    I've found a workaround for this using an Account Transaction report and filtering on description. However I can't find a way to use an OR operator.

    For example I can create a report that finds all quote references with "A0", and I can modify that to display a report that finds all quotes with a reference that contains "L0".

    However, I can't find a way to create a single report that contains all quote references with "A0" OR "L0" (or "A0" OR "A1" OR "A2")

    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

    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)

    Thanks for the detail in your idea here, Paul. I had a bit of a test of this myself and have checked in with our reporting team. 

    It doesn't quite appear in the modal once the report's run - this is something that we'll look to improve. 

    However, it's possible to enter multiple terms which will each be searched and return results for (like OR as an operator) - All you need to do is enter a comma(,) and space between each condition. 

    For example A0, L0 or A0, A1, A2, 🙂

  4. For accountants and bookeepers who charge fees based on number of transaction lines being recorded it will be great if a simple report can indicate the number / count of transactions recorded by each Source in a given period.

    This will also be helpful for new accountants and book keeper who are sourcing for clients who are using Xero to share that details so a smart quotation can be provided

    Manesh

    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

    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 Manesh, have you tried the new Account transactions report? When you run this report you'll be able to see how many items are in the report, noted in the menu bar at the bottom of the screen. 

  5. Develop report that lists customers with date,type and amount of last statement sent.

    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

     ·  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. Custom Reports
    The formula feature only appears to work for columns that are located to the left of the formula column.
    Each column has a name, surely the name is the important element and not the position of the column on the report.
    Can the formula feature be amended so that columns from anywhere in the report can be included

    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

     ·  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)
  7. We reconcile monthly sales with an internal ordering/salesprocessing system. This is good for checking to see if invoices have been missed and also to make sure that the net sales are the same in Xero too (another fail safe check). There needs to be a sales report that is easy to run off on a monthly basis showing net figures. Currently I have to run a couple of reports off - identify prepayments and delete them in the excel version, then add another column to work out net value. The latter is not always easy as some of our goods…

    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)
  8. Sales Tax Audit report is produced only on the organization's base currency.

    To be able to produce the Sales Tax Audit report in other currencies as well.

    Reason: to be able to extract the report for organisations registered in countries of which currency is other than the Company's base (if also required for the authorities.)

    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

     ·  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)
  9. New reports - enable data capture in links

    Currently - if you select a specific date range or filter and then link to this report, that data is lost and upon clicking the link you get the default report and have to reselect the data.

    It would be useful and time saving to enable the link to capture that data - the same as the old versions of the reports

    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

     ·  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)
  10. The new Account Summary Report needs the Account Code in the drop down list. Currently it only has the names of the accounts. There is no option to show or hide the Account Code. Sometimes I work with the account codes and not names. I need the ability to type the code in as well.

    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

     ·  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)
  11. It would be useful if we were able to select published reports in bulk to archive them, rather than having to do them one at a time.

    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

    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)
  12. Could the VAT transactions report in the VAT return include the invoice number as well as or instead of the reference?

    This would make the review to see if there are any missing invoice numbers much simpler. Our invoices are created in another software package by a number of people who sometimes include text as well as the invoice number and it makes sorting by numerical order time consuming. Having the invoice number as a field would make it very easy to sort in numerical order and identify missing numbers.

    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  ·  Tax filing  ·  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. The new custom report pack looks great but it would be good to be able to export the VAT return within the same pack. Can the VAT reports be added to this functionality? I think it would be helpful for many people.

    I regularly look at a profit and loss, balance sheet, aged receivables detail, aged payables detail and the VAT return reports monthly for all clients and it would be great to export these together, and would save a lot of time.

    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

     ·  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)
  14. Supplier and customer ledger - to be able to pull a supplier/ customer ledger, instead of pulling reports per contact. This would be ideal if it can be pulled for a certain period, to see all suppliers'/ customers' opening balances, movements and closing balances per supplier/ customer, all on one document.

    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

     ·  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)
  15. The ability to import report templates for financial reports

    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

     ·  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)
  16. The Profit and loss report: Compare tracking are amazing, but still needs the following:
    1 - To be able to edit the heading/remove the dates from the heading (as this is all reading showing on the top of the report, and can be very cluttering if every heading is starting with 1 June - 7 June 2022 ....)
    2 - in the old P&L: compare reports, the columns/tracking that was not applicable "disappeared", with the new reports, I'm seeing ALL my tracking that is available, and not only the ones applicable, please do the same for the new reports

    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

     ·  0 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. It is crucial to be able to print or email statements to multiple or all contacts with received money transactions at once showing each received money transaction for the contact in a time period on individual/separate pages by contact. This is really needed functionality because any nonprofit entity needs to send giving/donation statements at year end. I have tried multiple reports and statements. I can create an Account Transactions report showing all the clients and the received money entries, but it doesn't allow me to separate contact on their own page. The functionality under Business and sending statements would be…

    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

    0 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 Justin, thanks for sharing your idea again, I understand the challenge of creating a statement for a contact who only have receive money transactions. We've reviewed your idea agree its something others have asked for, so now it's up to the community to get behind and support it. Make sure you share your idea with any colleagues that this could benefit so they can add their vote too!

    Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero.

  18. This is a known issue that needs to be voted on to be prioritized.

    The Auto Sales Tax feature in Xero (from Avalara) disallows the ability to use Find and Recode. This is a huge limitation that will have massive repercussions as time goes on. Please fix this promptly.

    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

    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 idea here, Mariel.

    Appreciate hearing why you'd like to be able to change the account for invoices that have auto sales tax.

    We've reviewed your idea and now it can gain support from other community members.

    I've created a new idea to track support in being able to find & recode here so we can get interest in this specifically.

    If there is any plans made for either of these we'll update you through the respective idea. For now it can gain support from others in community 🙂

  19. On the Profit and Loss report there is no ability to show percentages, if tracking categories are used as a filter. We want to see COGS as a percentage of trading income, and Net Profit as a percentage of trading income.

    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

    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)

    Hi Karen, thanks for submitting this idea. Showing percentages in the Profit & Loss report when using Tracking Categories would make it easier to see how different projects, departments, or locations are performing at a glance.

    This feature would give you clearer insights and save time by reducing the need to export data and crunch numbers in spreadsheets.

    This idea is now in the Gaining Support stage. If this would help your reporting, please add your vote or share your thoughts, it really helps the product team understand the impact.

    We’ll keep this thread updated with any news.

  20. Hi Xero Support,

    We've been generating individual e-invoice from Xero/Invoici for months, however, we could not find any report on e-invoice generated through Xero/Invoici.

    This report could help us in ensuring accuracy of the data exported to MyInvois portal. We would require a specific report on the generated individual e-invoices to make sure that they tally with the sales invoices report from Xero.

    Thanks!

    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

    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)

    Thanks for sharing this valuable feedback about your experience with e-invoicing.

    We've reviewed your idea for a dedicated report on generated e-invoices. We understand how this would be crucial for ensuring the accuracy of data you export to the MyInvois portal and for tallying with your Xero sales reports.

    Your suggestion is now open to gain support from the wider community. Along with votes, others can now comment to share how an e-invoicing report could improve their own reconciliation and data validation processes. 🙂

  • Don't see your idea?