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

913 results found

  1. Transactions posted after a period end affecting prior periods

    Lock dates had not been set and as a result, there has been a few entries in to the last financial year.
    How can I locate these entries?

    I have tried a transaction report, but there are no parameters that I could enter.
    Ideally.

    Example -
    Our year end is 31st August.
    I would like a report that looks for transactions entered between dates 1/4/22 - 21/9/22 that have a transaction date up to 31.8.21 (last year end)

    In other accounting systems, you could take a unique reference number (URN) at…

    18 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 Kellie, you might find History & notes useful for getting the insight you're after here. 

    Though it's not possible to filter by the transaction date - You can set a date range like you've mentioned to view activity that has occurred post your orgs year end and ability to filter by Item types so you just view the item types you're interested in. 

    Keen to hear if this helps. 

  2. It would be great if Xero dealt with changing balance dates more efficiently. If the balance date changes it should be able to automatically calculate the opening book value, then calculate the depreciation for the new financial year end as per usual. Currently its very manual and time consuming as it reverses all journals posted since you started using Xeros fixed asset feature. Very odd and very frustrating!

    18 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 all, we wanted to round back here to share for those in the UK that we've now added the ability for you to create a short transition period (between 1 month and 12 months long) when changing the Financial Year End date.  

    To recap for anyone new coming across the idea - Aligning with the UK basis period reforms we've made a change to Financial settings so you can add start and end dates to different periods. This change impacts multiple areas of Xero.   

    • Fixed assets will draw on this information, to prevent any loss of historic information when your year end changes. Everything will automatically be calculated for you based on the period start and end dates you set in Financial Settings.  
    • The same applies in Reporting. All historic reports will be protected. And you’ll have accurate comparison periods even across varied financial years.  
    • In Xero Tax,…
  3. An Information message to advise implications of editing the "Account Type" when posting a bill for a Fixed Asset.
    "If an approved bill or spend money transaction is edited, and the account code is changed to one with a Fixed Asset account type - a draft asset won't be created". ie- it does not automatically update the transaction to include the item on the fixed asset schedule. Unless the item is manually added to the fixed asset register, it will not be included in subsequent depreciation runs.

    Ideally the system should be designed to fully complete the edit or should…

    18 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  ·  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)
  4. Ability to show future cash flow projection in Xero.

    Purpose: To effectively plan and manage the upcoming fund needs of an organisation.

    18 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)
     ·  Dana A responded

    Hello everyone, thanks for voting and commenting on this idea. Available right now is the short-term cash flow dashboard, which is a tool that visualises your future bank balance based on upcoming bills and invoices. The Analytics Plus version of this dashboard allows you to look 90 days into the future, and can make predictions for recurring cash transactions based on your spend and receive money history. 

    At this stage there are no plans to extend out the timeframe of this tool, or to account for balance sheet items but we’ll keep monitoring this idea, so please continue to add your feedback here on how this feature can improve your workflow. 

    If there’s any news to share, we’ll come back here and let you all now.

  5. Budget manager currently only allows you to include actuals for 3m, 6m and 12m. Most businesses do quarterly forecasts and hence also need 9m....why isn't this included as a default option ?? It should be...please !

    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

    1 comment  ·  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)

    We’ve seen your feedback on Budget Manager—thanks for sharing it. A 9-month actuals option could support quarterly forecasting.

    This idea has been moved to Gaining support, so the community can vote and comment. If this would help your team too, sharing how you’d use it can give the product team more context and help the idea gain traction.

    We’ll let you know when this progressed.

  6. For the report templates, would it be possible to include a tax computation as part of the Annual Financial Statements? This schedule would show the income tax calculation for the year as well as the resulting tax asset or liability at year-end.

    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

    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)

    Thanks for sharing the changes you want to see!

    We've given it a look, and now it's time for the community to rally behind it! The more support it gets, the better. Make sure you pass this along to anyone you think would benefit so they can add their vote and share their thoughts on how this would improve their use of Xero.

  7. One of the key steps in preparing client financials is to ensure accounts, especially newly added ones, are assigned to the correct report code. I had the favourited on every client in the old navigation for quick access as it's something I need almost every time. It'd like that back.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Great to get your feedback here, Chris. It'll be good for us to get a sense of interest from others in community that also found this Favouriting of Advanced Account settings useful.

    We're keeping a close eye on the interest and will share if there are any updates for you here.

  8. Hi, it would be amazing to have the ability to delete certain line items to create custom reports (eg - Profit and Loss). I currently need to export the full report into excel and manually delete the lines, but would be nice to have the option to do this in Xero custom reports

    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

    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)

    Thanks for adding your feedback and votes to this idea. We understand the requests for the ability to delete line items from custom Profit & Loss reports, and we can see how this could help streamline reporting for some workflows.

    The idea is currently in the Gaining Support stage, which means it’s open for the community to vote on and comment. These insights help our team gauge interest and guide future development priorities.

    Feel free to keep sharing your thoughts or use cases to add more context.

  9. Not a new product idea by any means, just a request to put the GST return back the way it was before the update. So far with the new update, we can no longer see the late claims on a separate tab, we cannot publish the final return in Xero and now we can not be in two different entities at once even if we are incognito mode or in a different web browser.
    When querying Xero about this problem, it was suggested that I post it as a product idea, because they are all known issues but can't do…

    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  ·  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)
  10. Remove all account codes check box upon financial statement publishing

    We need this check box added when we publish our EOFY financial statements - a similar box already exists to remove all decimal places yet we have to manually go to the trading statement, income statement, balance sheet and equity accounts and manually turn off account codes on each page.

    A simple box to remove all account codes when publishing just like the decimal place box would be fantastic

    Please fix this

    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)
  11. We would like the ability to transfer a GST refund to another tax payer. It can be done if we file online at IR and we would like Xero's GST return to file automatically with this feature. We have associated groups and have refunds that we want to offset against another tax payers GST to pay.

    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

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

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

  13. This report is great, I love it but we need to be able to customize it more. When you try and add columns it gives a message saying that you have to delete the total column first, then you need to manually add a total column which isn't the end of the world, but you can't select the the new total column in and of the formulas, like if I wanted to add the variance column (Which I would love to) but I can't.

    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

     ·  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)
  14. Currently the custom Pool creation option does not allow for the specific depreciation requirements of a software development pool - First year to be Nil, the second , third and forth years at 30% and the final fifth year of 10%. Without this function the depreciation for these assets needs to be calculated manually.

    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

     ·  2 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)
  15. Include account code as a field on all Project Reports to filter/summarise/group by.

    Currently, all 'expenses' are clumped together under one project item type.

    To manage a project properly, it is important to see the costs for individual elements such as 'labour' 'materials' 'travel expenses' sub-contractor costs' etc (or however account codes are set for the business'

    In the Construction Industry especially we always refer to other projects when pricing up for similar ones, and in Xero there is no way to see this breakdown. This was possible in Sage

    All reports should include an Account code seeing as every…

    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

    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)
  16. Where funds span multiple financial years it would be good to be able to add a brought forward fund balance (balance sheet item) the the P&L fund report (income & expenditure for charities where tracking categories are used for the funds) so that the charity has full visibility of the fund available - last FY brought forward + net amount for this FY = total fund till available

    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)
  17. When using the old reports, when you opened them up they would show the current month. Now they show 12/31/22 which is useless now that we are into March. They should either default to prior month (which is what QBO does) or current month (which is what Xero used to do).

    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

     ·  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)
  18. I need the option to auto reverse repeating journals to be available. This is neccessary for accruals.
    Auto reverse is available on regular journals but not repeating.

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

  20. I would like the field 'Branding Theme' added to invoice report as a column that can be selected.
    Any invoice report - aged debtors by detail would be great. I need to be able to analyse outstanding invoices by this field and cannot.

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