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

945 results found

  1. Can we get a regular balance sheet in the Advisor (management) packs?

    For some reason it provides a summarised version, with statutory lines only (eg Fixed Assets, Trade debtors etc) but not the TB account by account.

    "More" even has an "Account codes" option, which doesn't work 😕

    Come on Xero!

    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

    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 Yaakov, appreciate it's taken me a while to get back to you here and thank you for the additional detail and I have taken a look into your interactions with our Xero Support team.

    Understand that you'd like an option to have a standard option when creating report templates to select a Balance Sheet that has all groups listing each account rather than showing totals as a default. While it's not in our immediate plans, like you've noted right now it is possible to Edit the layout of the report template to deselect the Total option for each grouping and Save the layout.

    We'll keep your idea here open to get a sense of interest from others in this, and I will share if there is any update around this for you here.

  2. 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)
  3. At the moment Xero doesn't auto calculate the depreciation rate from the effective life. This means when we run the depreciation report the rate column shows up as blank if we've entered the effective life into the asset register rather than the rate. We should be able to enter the effective life and Xero auto calculates the depreciation rate for the depreciation report.

    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

    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 your needs for Fixed Assets, here. While we appreciate it could be confusing to see a blank percentage in the rate column, we want to upfront that this isn't something we have plans of implementing in the near term.

    As you may already be across if this is something you do need to track, the best option right now would be to export the Depreciation Schedule report and make adjustments as required outside of Xero in Excel or Google sheets. I know this isn't the ideal solution and if any change is planned we'll let you know here.

  4. Many of my clients are partnerships and trade using the partners initials e.g. J & J Doe but on their reports it displays as %26 and on emails that they are sending with sales invoices, it displays as "& amp;" meaning that when I save reports or they send their invoices, this has to be changed. Having worked in a software house previously, I know that this is a programming issue and one that should have a relatively simple fix so can you please look at this.

    19 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)
  5. Where there is more than one bank account in an organization, it would be very useful to be able to filter out a particular Cat Code, separately , within each bank account. Currently one gets the entire Cat Code for the entire organization, showing all the bank accounts. Also, the column "Tax" remains blank when a bank account's reconciliations for the date selected are chosen. Please see my uploaded example of just one bank account's reconciliations, which contains every transaction, but no tax shown. The report shows "Gross" and "Net" to be equal, when in fact there are many with…

    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  ·  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. It would be helpful if you could see if an attachment was uploaded - you could consider showing an Icon outside the RHS of each line., as something Every GST checker needs to do, is make sure they have the appropriate attached Invoice so they can claim the GST. In Xero, it is laborious to have to open each line and check if their is an attachment.

    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)
  7. It would be good to have a bank feed to account transactions matching report which could show which bank feed entries have been reconciled to which account transactions without having to click into each entry. Something like the attached would be good to enable someone to spot mismatched bank entries

    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)
  8. The delivered response to my previous idea was no correct. The aged summary/detail reports only show what is outstanding.
    The report I am requesting is to show the turnover, monthly across 12 months so that we can see what we have spent with a supplier each month for that year, but also what a customer has spent with us.

    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

    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, returning to the idea here I'd also like to highlight the Income and Expense by contact report which can be run for a date range and with comparative columns. You'll also find you can drill into the figures of the report to view all transactions that make up the total for that contact.

    Alternatively, there is the Receivable and Payable Invoice Summary reports that can be filtered for the transaction types you'd like to see and grouped by Contact.

    Is there anything missing from these reports that you'd need to get the view you're after here?

  9. In most areas of xero you can enter dates in any format, however, in the 'new fixed assets' this errors unless its in the one format Xero accepts.

    Please make the date fields similar to the other fields in Xero, allowing any format e.g. 1/1/24, 1.1.24, 1-1-24, 1 1 24, etc

    5 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)
  10. We used to have the option to add/remove highlighting in a text box directly from the main page of draft reports, however this feature was removed and now we can only Bold/Italics/Underline/Bullet point, but no highlight.

    It would be great if we could add this function back in, so we didn't have to go to 'Edit Layout' to change add/remove highlighting anymore.

    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

     ·  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)
  11. Allow the Aged Payables Report to be grouped by the Planned Date.

    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

    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 Alison, while there's no direct option to group by Planned date in the Aged Payables Detail report atm, if you change Group to None, once run you can click the Planned Date column header within the report to re-order by this field and it'll group all payable invoices by Planned Date.

  12. When using any report, when drilling down into more detail is great BUT there seems no way of then returning to the original report without re-running it after you have finished reading the drilled down info? Or have I missed something.

    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)

    Would be good to get an example of a specific report you're drilling into, Lyn. You should be able to click the back button on your browser to return to the previous page / report you're on.

    Alternatively, right click and opening the drill down figure in another tab may also be useful here 🙂

  13. A flag which shows when the profit & loss figure plus brought forward retained earnings does not add up to the retained earnings on the reports. This is usually due to a mapping issue where a figure is causing a transposition error. It only seems to flag if you opt to include a statement of changes to equity. Seems like there should be a more obvious flag for this issue to ensure it is not missed.

    Also perhaps a reconciliation between the profit & loss figure in the company accounts versus the Xero business, appreciate this is likely to be…

    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. Would it be possible to have a report that shows the bank transactions and the bill/invoices that it was reconciled with? It's time consuming to check transactions one by one just to find a transaction that was incorrectly reconciled. Please see below example for your reference.

    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)
  15. Fixed Assets - Tax Pooling Depreciation. Australia has a feature to put assets into pools and calculate depreciation. This would be very useful in NZ

    5 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)
  16. Running Unrealised Gain and losses report for tracking categories

    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

     ·  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)
  17. When a client changes their GST taxable periods (e.g. 2-monthly to 6-monthly filing) they often need to file a return for a non-standard number of months to align with their balance date (e.g. 4-month GST return). It would be nice to be able to change the GST period settings in Xero to allow for the non-standard GST return to be filed directly from Xero.

    5 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  ·  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. Small Business Corporations (SBC's) can, under certain circumstances, depreciate assets in a 3-year schedule as follows:

    • 1st year: 50%
    • 2nd year: 30%
    • 3rd year: 20%

    See the attached document, under 4.2.

    Currently, this is not possible (I checked with Support).

    I expect this to work within Xero, as it is a regular tax rule in South Africa.

    Adding this schedule for South Africa would be extremely useful and important, as we now have to do the depreciation outside of Xero.

    21 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  ·  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)
  19. It would be great to have an option to run a sales report by item which includes draft invoices, delivery dockets, and purchase orders as well.

    For example, I tried to run a sales report on qty of each product sold for the financial year to date and realised this information was inaccurate as we had sold a significant qty as draft invoices (using draft invoicing in lieu of delivery docket functionality), these products were not included in the sales report.

    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)
  20. Ability to add project financials rerporting into an advisor template report

    Being able to build a management report template that includes project financials seems like a no-brainer. but you can't do it at template level. You have to start with the existing template for a managmeent report and build a report from scratch for each client.
    You can't even take an existing template and add in a project report.

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