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

1091 results found

  1. So we send a W9 request and a vendor completes it, great. But this doesn't create a digital W9 form, it just modifies the information in the vendor's 1099 contact page. So if an auditor requests a copy of a vendor's W9, we have nothing to give them. And it's possible to override the changes made by the W9 submission, so there's no way to verify - say a year later - that the information on their contact page aligns with the W9 information they submitted. The lack of static documentation makes this feature almost useless for us as most…

    13 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)

    Hi there

    While we don’t create an exact replica of the form we’ve worked closely with our compliance team to make sure that if you are audited we can supply the information needed. We also cater for the event of W-9 information being overridden and needing W-9’s from previous years.

    In terms of getting the information for an audit - while we don’t offer a self service option at the moment - if you need it you can submit a request to our support team and we’ll provide what you need for an audit 😊

  2. Would be useful to be able to narrow column width, especially when decimals are removed and more months are required on 1 page. Similar to Excel, where we can change width and height of rows or columns.

    101 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

    52 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 all your support on this idea and for sharing how the option to adjust the column width on your reports would be beneficial. We understand that in some reports the inability to adjust the column size could result in extra white space or longer entries not being fully displayed.

    This idea has been reviewed by the Product team and has been moved to the ‘Accepted’ status. This reflects that this idea is not currently on our roadmap but it is a suggestion we will continue to monitor when looking at how we develop our reports.

  3. VAT Only Transactions - Xero to remove needless restriction to have VAT amount less than line total. This will allow posting zero net with VAT amount to 20%EXP VAT code with a total equal to the VAT total without having to reply on VAT on imports tax code.

    3 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)

    Hi community, we don't have any plans to remove change the behaviour here. However, to confirm you can enter a 100% VAT invoice and we have an article that details how to do this. Essentially, you'll enter the invoice using two transaction lines, which when followed will:

    • Show a 100% VAT total on the invoice
    • Have 0.00 effect on the account code balance.

    Please note that both lines will show on the invoice PDF.

  4. Our company are making use of the "personal money" and "company money" options to submit their expense claims. There is a report to track cost paid with personal money but no report to track cost paid with the company money. This report will be critical for commission calculations.

    6 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)

    Hi Hiten, company money transactions are recorded in the organisation as Spend money. You could run the Account Transactions report for your bank accounts, and add a filter for, or group the report by source to only see spend money transactions.

    In terms of commissions, we don't have a specific feature for tracking this however you could use Tracking in Xero to set up a Tracking category and each of the employees as a tracking option on that category. This way when they are entering company money transactions you could track it back to the employee by filtering by that tracking option.

  5. It would be useful if Xero could show when a subcontractor is verified with HMRC, due to the two year verification rule.

    If the date of verification could be shown on a report that would be great, then it would be easy to identify if a re-verification is required.

    1 vote

    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  ·  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)
  6. Xero HQ report templates overwrite the order of accounts to alphabetical when accessed at a client. The report templates are in the correct part of the financial statement for the client, but then it defaults to alphabetical order. This requires you to change the order for each client, even though it was done at the HQ level.

    4 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)
  7. Could we please add the 'Due Date' option to the Aged Receivables Summary Report. I love the simplicity of this report versus the Detailed report but unlike the detailed report, there is no option to add the due date.

    1 vote

    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 the feedback, Jodi. When you say you'd like to add the Due date I'm guessing this would be as a column to the report? One thing that would make this tricky is where you have multiple due dates for a customer with multiple invoices in the period the reports being run - what date would you expect to show here?

  8. Purchase Order Reporting
    The current work around of using the Outstanding Purchase Orders Summary report lacks a lot of the vital info that's needed to manage Purchase Orders and create accruals at month end. A report that shows all the - coding, tracking codes, dates, who created and who approved, Description, etc and ability to run reports on only those that are not Billed and both with and without detailed lines would be more helpful.

    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

    9 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, thanks for your feedback here. We appreciate there are more details some in the idea here would like to see around reporting of Purchase orders in Xero.

    We wanted to highlight for those in the conversation that it may help - There are Purchase order common formats in the Payable Invoice Detail report that you could use.

    For example, in the All purchase orders detail report, you can add a column to show the account, tracking and any other line item info you need.

    We want to be open that we don't have any plans right now for additional Purchase order reporting, however we'll continue to keep an eye on the idea here and share if there is any news.

  9. The Supplier Bill Activity report is great for showing transactions for a Supplier if you operate only with one currency.
    However, for accounts with Multicurrency, it should also include optional columns for the Source Currency amounts and when showing just one currency, the balances in that currency in the list of columns.

    37 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

    19 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. Our law firm has a critical need for an understandable method for handling trust transactions.

    3 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  ·  Fixed Assets  ·  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. Thanks for adding the new "compare tracking categories" in the new Profit & Loss Report.

    However, even with this additional development the new version of Profit & Loss Report requires you to manually add each tracking category one by one. Having the feature of "select all" reinstated as the old version did would be really helpful.

    Having limited tracking categories to 200 isn’t helpful, previously Xero was able to search across an unlimited number of tracking categories, but only report on the active ones.

    I’m sure there are many users that have more than 200 tracking categories (not always active…

    48 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)
  12. Xero offers users the ability to select between cash-based accounting and accrual-based accounting for financial reports. However, a major problem is that the inventory sales reports are based only on accrual-based accounting. This means the financial reports and inventory sales reports are never consistent. Please add the ability to run cash-based accounting reports for inventory sales (sales by item, etc.).

    4 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)
  13. Please create all excel exports from Xero in the currrent .xlsx format. Most still produce an old xls.file format (for instance Sales Tax Report) and need to be resaved to bring up to date.

    3 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)
  14. In the upcoming new Fixed Assets layout/section, if you sort a heading (Asset name, asset number etc.) it only remains for that particular session, if you close out, it'll default back to sorting via the Purchase Date when you re-open.

    Proposing this remembers what the user selected.

    Also if you select "Items per page" it only displays that amount of items for that session, then defaults back to 10 after re-opening.

    Please make it remember the user's chosen setting.

    3 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  ·  Fixed Assets  ·  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. Get rid of (or just hide) "Tracking Transfers" when printing PDFs of manual journals. Seeing descriptions are more important than the background tracking.

    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

     ·  17 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. Be able to view a report of expense claim details of expenses that have already been paid

    13 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)
  17. If the VAT201 report endpoint is added to the Xero API, it could save businesses doing the reconciliation for their clients and their tax returns. The report could then be saved directly to an excel document based on specific dates and this could lead to hours of time being saved for the people doing the recon.

    1 vote

    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  ·  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)
  18. It would be very useful if the declined reason could be included in a report/export to enable further investigation as to why quotes where declined.
    This would highlight any patterns, e.g. price to high, delivery to long etc.

    3 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)
  19. Account transaction report that can analyse multiple accounts in one report by grouping everything by account and then summarising each account by contact at the same time.

    2 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)

    Not exactly what you're after here, however in lieu of not having the ability to summarise within a group you could use the column header to order by Contact within a grouping.

    Being open, we don't have any plans for developing this capability in the near term.

  20. On the VAT201 report a option to capture the Diesel refund per month to pull through to the E-Filing VAT201.

    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

     ·  9 comments  ·  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)
  • Don't see your idea?