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

899 results found

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

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

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

  3. Bank reconciliation - A report that will show each bank transaction and then which invoice it has been reconciled against, as a way of having a quick way to check something has been reconciled incorrectly. Currently, the only way is to view each transaction through the account transaction report.

    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

    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)

    Good to hear you're aware of how you can run the Account Transactions report to view this information, Catherine - Is there a reason or something missing from this report that would help you when reviewing transactions? 

  4. Manual Journal - Copy details from line above- this is a tool in Sage so please could you consider it? :) it's a nifty action & allows a one click solution to repeat account & tracking categories and is especially useful for large entries such as payroll journals.

    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

    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, we appreciate the feedback here. Right now, we're in the process of rolling out a new manual journals experience to users, and I'm pleased to share that this also includes the ability to copy a row, which will add a duplicate row beneath the one being copied. Along with this you'll have the ability to Paste lines detail that's been copied elsewhere 🙂

    Currently, this experience has been rolled out across AU, NZ and US and will be coming to all other regions soon. I'll round back to confirm once it's out to all.

  5. The Journal report does not show any currency information, it would be very helpful to chow to currency and the debit/ credit source amounts.

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

    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

     ·  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)
  7. VAT201 Report (ZA) - A SARS requirement is to have sequential invoice numbers. The invoice numbers are not displayed on the VAT201 report, only the customer reference number, if there is no reference number, then the customer invoice number is displayed. Can we please have a column for the customer invoice number or only have the customer invoice number listed.

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

    53 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

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

    Thanks so much for sharing this idea, and to everyone who’s added their support and feedback here.

    We’re moving this idea to Accepted as we can see the value in improving the experience for Group VAT workflows, particularly where customers are currently relying on manual import and export steps.

    While this isn’t something we have scheduled right now, it is something we expect to consider as part of future planning. This would require a significant amount of work to build well, which means we’re not able to share a timeframe or delivery details at this stage. We’ll keep this idea updated as things progress.

    Thanks again for helping us highlight the need here 🙂

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

    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

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

    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

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

    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)
  12. Enable the selection of the averaging method of depreciation (full months and actual days) for Australian edition.

    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  ·  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)
  13. 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…

    44 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

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

  14. 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…

    53 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)
  15. 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)
  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!

    44 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. 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)
  18. Under the GL Summary Report(new) and GL Detailed Report (new), i notice they run by account code in alphabetical order as a result of which some Balance Sheet and P/L items are mixed together.

    How can i run both the above reports in a way whereby all the Balance Sheet items are on top in alphabetical order follow by all the P/L items thereafter in alphabetical order

    Can anyone help

    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)

    Hi team, coming back to the idea here, although it's not possible to group by in the General Ledger Summary report, you'll find you include Account Type as a column, and re-order by clicking on the column header which may help some of the needs here.

  19. We need to be able to create a report that lists inventory item sales and includes the customer name AND other customer contact information such as email address or phone number.

    There have been occasions where I've needed to contact a large group of customers that have purchased a product from me due to a misprint in a book or an update to a title. At present, the only way I can do this is to export my inventory report and add the contacts manually. Xero Support Specialist - Daniel has confirmed this.

    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

    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)

    Hi team, rounding back to the idea here we want to be open that this isn't a report that we have any plans for developing at this time.

    That said, there is a feature in Xero today that may help you achieve what you're in need of - Smart Lists

    With smart lists you can set criteria for items that customers have or haven't purchased from you within a period of time. You can either have this compare across all items or run smart lists for specific items. Search results can then be exported from Xero if you'd like to do more with them. Thanks

  20. Can we please extend the budget manager period from 12 months to more than 3 years or whatever is possible? The data in the budget manager does not go beyond 12 months and if the budget is to be changed after a year of upload it doesn't have such access.
    When working for a movie/film-making company the budget runs for more than 12 months and it needs to be changed time and again. But Xero doesn't have such an option which makes it impossible to get an accurate variance.
    It would be great help.

    25 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  ·  Budgets  ·  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?