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. A common situation we have with our clients' live Xero files is that the client wants the Legal/Trading name and Display Name as their business name, but we want it as the actual entity name. E.g. we would like to see A & B Smith Family Trust as the entity name in financial statements, but the client wants all their other internal reports/invoices as their trading name, say Adam's Mechanical Services.
    We often find ourselves changing the name to what we require, publishing financials and then changing it back to keep the client happy.
    It would be helpful to have…

    17 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)
  2. You can add formula columns and rows to a report, but from what I can tell, the column formula always takes precedent over the row. It would be cool if you choose if you want the row formula to calculate in the column formula column

    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

     ·  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)
  3. The attached post indicates that Xero has delivered the ability to hide archived files by unticking the "Show Archived" box in the account transactions report and then saving it as a custom report. I have tried this, but it doesn't work. Every time I go into my custom report which should have the Show Archived box unticked it is always ticked and the archived accounts are showing. Could you please look at this again.

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

    Hi Sally, appreciate the image back to the earlier update you're referring to here. Is it possible that the custom report you're using was saved prior to the update and needs updating with any new setting changes and then saving again to hold these for future use? 

    If you're still finding the same behaviour, I'd highly recommend raising a case with our team of specialists at Support so they can dive into why settings you've saved in a custom report aren't being applied. Thanks 

  4. Would like to see switch rules work in the notes to the financial accounts the same way they work on the balance sheet - allowing for reclassification of accounts with negative balances, for example negative current asset to current liability or negative non-current liability to move to non-current asset.

    These issues are particularly acute when an account goes from positive to negative and vice-versa between current year and prior year.

    On the basis the switch rule does not operate correctly in the notes to the financial accounts, means that in many cases the switch rule is rendered an unusable feature…

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

    Hi community, I'm Brigitte, a Senior Product Manager from our Xero reporting teamWe’re doing some research on how partners manage notes in Y/E financial reports, and we’d love to hear about your current workflow using report templates.

    How you can help:

    • This conversation will take about 30 minutes via video call
    • We'll ask you to share your screen to walk us through your current process of preparing/reviewing notes

    If you're interested, please use this link to choose a time that best suits you.

    If none of the available times work, just reply to my update with a preferred time, and we’ll do our best to accommodate!

    We greatly appreciate your constant support & valuable input for the reporting team! Thanks so much.

  5. In the old Xero reports as part of the management report, it was possible to run a report that showed month by month actuals for the FY to date then the budget month by the month for the rest of the financial year to give a full year forecast.

    However, in the new Xero reports, this functionality has gone. Try and write my own report but the dates don't update automatically regardless of the reporting date you select (as confirmed by a Xero specialist)

    So I can write a report that shows 4 columns - Jan - Apr actuals, then…

    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)
  6. Although you can save a custom Account Transactions report as the new default report, Xero still displays the original default Account Transactions columns if you drill down to account activity from Balance Sheet or Income Statement.
    This currently requires re-adjusting the column settings every time.

    78 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

    33 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 signalling your interest and sharing with us through this idea, team.

    We understand why you'd like a setting for defaults when you drill down through the Account Transactions report. This is something our reporting product team have taken a closer look at, however the solution isn't a simple change and we want to be upfront that at this stage we don't have any plans for. We will share if there are any updates here.

  7. Hello, across the board of GST xero users, are you able to make a pop up show on a companies Dashboard notifications. That tells them a GST period has ended that they can start working on their GST now, instead of getting notifications late or close to due date.

    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  ·  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)
  8. It would be great if we could adjust the justification of text in financial statements. Yes, each to his own is accepted but some like the left indent and some like the evenly justified (which just looks neater). Here's to hoping it can happen.

    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  ·  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. The Journal report does not show any currency information, it would be very helpful to chow to currency and the debit/ credit source amounts.

    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)
  10. On the Receivables and Payables Detail report, include a flag that shows when a planned payment date has been manually identified (as opposed to the credit terms due date). Will simplify cashflow forecasting

    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

     ·  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)
  11. On the notes section to the financial reports in adviser reports templated under the groups, I would like the accounts selected to be in alphabetical order. At the moment the only option is to manually drag and drop - with a large number of accounts this is extremely time consuming. An automated function would assist.

    11 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)
  12. The new Profit and Loss report does not filter the actuals AND budget by tracking category. You have to manually add the correct tracking category budget to the report. When you have 40 plus tracking categories this becomes time consuming and silly.

    The old profit and loss report did this easily. So the new report is a major step backwards

    Ensure the filter for the new profit and loss report filters BOTH actuals and budget, so the report is easy to produce and has meaning. Do not expect users to add the correct column for budget - particularly those less…

    51 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)
  13. I attended the 2023 Q2 QPU and I like that for placeholders you can add a number in the square brackets to modify the month placeholder (this was in repeating journals - is it the same in other repeating features, like Invoices/Bills?). I also wonder if you can modify the year placeholder in the same way.

    But I'd like also to be able to post repeating journals with a placeholder that uses a number-format for month (eg, 04 instead of April). Alternatively or additionally, it would be nice to be able to abbreviate the month to just the first 3…

    10 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  ·  Manual journals  ·  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 reports - Be able to make formulas from individual rows / accounts not just "columns, group totals or formula rows". I have attached an example of the work around required to get Gross Profits for hospitality split into Wet (Booze) and Dry (Food). It adds 8 lines and makes the report unwieldy. I would love to to more interesting formula. And not have to export to Excel or other programs.

    10 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)
  15. Under Custom Reports

    I send out reports to my departments each month, this morning it took 4 hours to add the tracking codes to the new P & L reports (we love the new report and so do our Department Heads).
    I was wondering if there is a way of saving each custom report for each individual dept with their tracking within a folder. We have a Junior and Senior Campus and about 45 departments at each. We already have a lot of custom reports so having a folder system would allow each Admin staff member to access what they…

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

    Thanks for the example, Shellee! That's a good few departments 😮

    There's no facility to create folders in the Reports Centre for this sort of categorisation atm. 

    We'll begin tracking support in this here. 

  16. It would be great if a column could be added to either the Aged Receivables Report or the Receivable Invoice Detail Report that shows the number of days the invoice is overdue by.

    The number of days an invoice is overdue by can be seen on the 'Awaiting Payment' tab in the invoice section in Xero, but even on this part the information cannot be exported.

    Thank you!

    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

    10 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 would be great to see a feature that was specific to VAT groups so it's an easy experience (rather than importing and exporting figures)

    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

     ·  12 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 helpful to have the reports, once exported to Excel, already formatted, so that the Nil values are shown as a 'dash' as opposed to '0'. This is particularly useful when there is a large report or several reports with lots of data. It is more efficient when it comes to reviewing the figures, and saves having to custom format the individual reports. We have also had clients, who still prefer reports on Excel, ask for reports in this format, it is time consuming having to change, especially when it is a large reporting pack.

    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)
  19. The ability to customer the Totals line of the Annual Reports so that they have the top line and Bottom Double line along with the figures having a $ sign. It doesn't right to just have the figure without the finishing touches.

    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  ·  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. Can we please have a function where we can filter the data based on the last payment date to show only invoices paid within the date range in the filter?

    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

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