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

139 results found

  1. Changing subtitles on reports when changing the year end.
    When shortening the year end, eg with Basis Reform periods, the year end is showing incorrectly as 'year end and the original year end date' rather than period end and the new year end date. It would be great to have the flexibility to amend subtitle dates within reports so that the accounts can be produced straight 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  ·  Reporting  ·  Admin →

    Hi team, sorry we haven't caught the idea here sooner. Listening to feedback we know the sub heading was a bit of a confusion point for organisation's with a longer or shorter FY.

    We've recently made a change so the subheading will now read 'For the 'x' months ended' so the report will be more accurately reflected.

    Thanks for your sharing on this with us here.

  2. The 'old' balance sheet showed the fx rates as a note at the bottom - can we have the option to add this to the new balance sheet layout.

    99 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

    16 comments  ·  Reporting  ·  Admin →

    Hi everyone, we've just released disclosures for foreign currency in Balance Sheet, Profit & Loss, Trial balance, Movements in equity, Budget Variance and the Blank reports.🙂
    When you run one of these reports in base currency you'll see indicators next to amounts that have been translated that show the exchange rate that was used.
    Where applicable and you run one of these reports in a foreign currency there will be an indicator next to the currency sub heading that links to a note which display the exchange rates at which the base currency has been translated to foreign currency as at the report date, and any comparative dates.
    We'll be extending this feature across more reports and I'll return to share as these come available. Thanks!

  3. Would it be possible to amend Xero settings, so that if you run a balance sheet to the end of February, the comparatives are also run to the end of previous month?

    In February, my current month balance sheet is run to 28 February (Xero's choice) and Xero decides that means I also want to see the comparatives run to 28 January as a default setting.

    As many month-end journals are posted to, say, 31 January, the balance doesn't include them.

    This is very misleading: in any other month, the comparatives are run to the end of the month.

    It's…

    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 →

    Sorry Karen, not quite sure what's going on with your report there but I'd recommend coming into our specialists at Xero Support to have a closer look at your report settings.

    Running for the full period of the month is the default so it should pick up all days for the month comparatives you're running the report for.

    I've attached a test from the demo org - Setting the Date to 28 Feb, with compare for 2 months the report shows me the full months with columns for 31 Jan and 31 Dec.

  4. Where on xero in the report is a customer & supplier name & address report giving account number / address details please.

    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 →
  5. Provide a FULL list of ALL reports!

    There are SOOOO many reports out there that I am not aware of, as they are all hidden! Unless you know the exact name of the report they are useless to search. I have just spent a wasted few days between facebook and support trying to pull a report similar to Supplier Statement. I did a search and of course there is nothing called that. I eventually contacted support to find out how I could get a Supplier Statement and was told to use a "Supplier Bill Activity". I would never have guessed…

    39 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 →

    Totally get the keywords our customers look for or search and the names of Xero's reports may not always match. We've making use of generative AI and have released this to search within the Xero help menu - Where possible Xero will auto generate a response based on your search, and otherwise you'll see the most relevant content from Xero Central.

    Taking the example in the idea here, when searching 'supplier statement' the first relevant result helps a user understand what reports will help them get an understanding of supplier activity in Xero.

    In terms of listing reports in the reports centre - Some of Xero's reports such as the Supplier Bill Activity are a drill down report. While it won't be listed on the reports centre as a default, you can click the 3 dot menu next to the Contact Transactions - Summary report to view sub reports. If…

  6. Make W-9 request available from the contact page. Perhaps where financial details are manually entered. Why have to go over to the 1099 report?

    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

    1 comment  ·  Tax filing  ·  Admin →

    Hi everyone, we've released a new 'Tax Details' section for US customers in Contacts that allows you to request W-9s from a contact you've set up in Xero. From this section you'll also be able to see a contacts W-9 status and manually update this if needed.

    We've also added additional fields for 'Name on the income tax return' (previously 'Legal name') and 'Business or disregarded entity name' in Contacts to match the 1099 W-9 Management space.

    Thanks for sharing and staying updated with us here through product ideas.😊

  7. Currently, when preparing financial statements or other reports in Xero, you have to export the report to PDF to work out if you will need to insert page breaks to keep all related content on one page, or to ensure that a heading doesn't end up on one page and the information on the next. This can sometimes mean exporting a report multiple times if there are multiple page breaks required.

    It would be helpful if in the drafting stage, Xero reports showed some sort of indicator (i.e. a dotted line), so that you could identify where a page would…

    69 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 →

    Hi everyone! Today we released the new preview panel to all users 🥳

    Any report that you can edit the layout of now has a PDF preview on the right of the screen. You'll be able to instantly see how any changes you're making to your reports will be reflected (including page breaks).

    We thoroughly appreciate the input and feedback we've received from customers which has helped refine this end result. Thank you

  8. It would be great to have the ability to run a report to show any bank transactions reconciled on a given date i.e any bank transactions that were reconciled on 7 August 2024, rather than clicking into individual transactions to see the audit trail

    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 →

    Hi Beth, appreciate it's been a little while since you first raised your idea here. This is actually already possible with the History & notes report.

    If you set the date as you need, then in the Search bar type 'Reconciled'. This will quickly group and show you a list of the transactions that have been reconciled for that period, along with a few details of the reconciliation.

  9. Transaction/summary report for suppliers but showing history in aged format, to be able to report on what we;ve spent with a supplier for the last 12 months - Each month!

    Xero really need to look at producing a report generator like sage had, so we can create any report we need.

    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 →
  10. Option to attach files to individual fixed assets

    Purpose: Ease of reference, being able to attach files and documentation that related to an asset

    681 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

    Hi community, we've now released the ability to attach a file to a Fixed Asset to all organisations using the new FA's experience. As mentioned in my last update, the 'Attach files' option is found at the top right when editing an individual asset. You can either select to Upload files from your device or files library, or simply drag & drop files to the upload modal.😊

    We appreciate there are some Australian businesses using pools that are still on the older Fixed Assets experience and won't have access to the Attach files' feature atm. While we complete work to help move you all to the new experience I've created a new idea. Add your vote to stay updated.

    If you'd like to stop using pools this is possible, however it requires you to turn off tax reporting - This does have impact on other aspects of your fixed…

  11. General Ledger Exception Report

    Getting new updates and new reports is fine but can you please keep this GL Exception report (old version) or else make arrangements to create the same report in the updated versions of General Ledger Reports.

    This report is very useful and crucial for setting up work papers.

    50 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

    18 comments  ·  Reporting  ·  Admin →

    Hey community, thanks for your interest in this idea, and for sharing your feedback on the new reporting experience.

    We’ll be rolling out a new version of the General Ledger exceptions report, and you should see start to see it pop up in your reporting centre from today 🎉 

    Unlike the older exceptions report, this is a dedicated report. So you'll no longer need to navigate to the GL Summary to find it - saving you a couple of clicks!

  12. Add a quick option to create a manual journal entry to adjust the sales tax amount paid when reporting and filing sales taxes.

    My state (and others, I assume) forces me to round up to the nearest dollar the amount of sales tax I owe when I file, which results in the filed number being different than what's in my "sales tax" account in Xero. I then have to add a manual journal entry to adjust that amount - usually debiting from one of my product categories.

    It would be nice to have the option to do this automatically when…

    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  ·  Tax filing  ·  Admin →

    Hi team, returning to confirm that we've now released an improvement so you can handle variances in the Sales tax amount payment and make sure this matches what is owed to the state. You'll find you can now record an adjustment when marking a State sales tax report complete. See more on this in Xero Central.

  13. In the old reports there was a bank report, (Detailed Account Transaction Report) that you could pull up the bank account and it would show the bank entries and where they had been coded. This is not longer available. Alternatively, could the code be added to the Bank reconciliation page where it shows the entries.

    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 →
  14. Current volume limit is too low. I can't even run the account transaction report including all the account codes for the whole financial year. It's not ideal to run a few report and add together. Strongly recommend Xero increasing the volume limit for the report.

    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 →
  15. It would be great if there was a way to create a new invoice from the Billable Expenses report.

    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 →
  16. The account transactions report when exported no longer has bold headings and is difficult to read - please change back ASAP!

    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 →
  17. When editing a report in the financial statements, it would be great if there was an option to preview just that page and not the whole document. Ie if editing balance sheet , have the option to open a pdf of just that page ( but keep the whole doc on a sept PDF- so two options)
    Would just be so much faster to preview the actual page I'm working on, and not having to wait for the whole document to open, than scroll/find the bal sheet

    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 →

    Thanks for all your contributions and feeding back to the team on your needs in this space. I'm pleased to share that we have now released our new preview panel to all users.

    When you open the layout editor of a report you'll see PDF preview of your report on the right hand side, so you can see how changes you're making to your report impact it 'on the fly'. 🥳

  18. Ability to close and lock a period for accounting and reporting purposes to ensure that, once figures are reported and published, those figures do not change. Any necessary changes (VAT rates, corrections etc) to source documents could be made but the impact should fall in the current, open period.

    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

    6 comments  ·  Reporting  ·  Admin →

    Hi team, returning to the idea here there are a few separate asks being raised. As mentioned in my last update on the idea here - currently for reporting purposes you can Publish report to keep a record of accounts at an as at date in the system. Alternatively to stop transactions being raised in past periods there are the existing lock date options.

    We have separate ideas for the recording a posting versus invoice date and another for setting separate tax and accounting period lock dates that I'd recommend adding your votes for if this is more what you're after.

  19. Ability to show date and time stamps, to see when the report was run.

    Purpose: This will help users to do their Audit Trail.

    241 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

    51 comments  ·  Reporting  ·  Admin →

    Hey community, thanks for your continued interest in this idea. Earlier this year we delivered some updates to reports, so that they’ll now show page numbers and date stamps when exported to PDF.

    This is an idea that was seeded by the community team when we launched Product Ideas back in 2022.

    The Product team has done some great work to address the original request but reading the commentary here, the scope of the idea has grown a bit since then!

    We’re confident that this release solves the original request so I’ll be marking this as delivered.

    There are additional improvements that have picked up some momentum in the comments: to make the date stamp toggle-able, and to extend the field to include time as well. To be open we don't have plans to progress these specific asks.

  20. Add the following to reports:
    Supplier Activity Statement to compare with the statement received from your suppliers.
    Alternatively - enable a Customer and Supplier DETAILED LEDGER as per usual accounting practice. This should be standard within Xero.

    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

    4 comments  ·  Reporting  ·  Admin →

    Hi all, with no response from my last update we are going to shift this to delivered with the ability to run the Aged Payable or Receivable Detail reports where you can set the Ageing periods to be Day, Week or Month based on your choosing. If needed you can also filter these reports by Contact.


    For ageing periods on a customer's statement -  we have an idea for this that we've shared on and to be upfront we don't have any plans in the foreseeable future.

    Supplier statements have been discussed on a different idea. However, we want to be upfront this isn't planned.

← Previous 1 3 4 5 6 7
  • Don't see your idea?