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

528 results found

  1. Been trailing the new reports format and when setting up a custom group account layout for a Profit and Loss report we can't use this layout across Common Formats of Profit and Loss. This feature was available in the old reports that once a custom layout was created it worked on all formats. Been advised that would need to create a separate custom report for every Common Format

    73 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)
  2. A report to show transactions that have been posted including the account code and the projects that the transactions have been assigned to with data parameters.

    We reconcile the sales, direct costs and gross profit amounts from the project summary report to the same amounts in the profit and loss report but currently there is no way to identify differences when they arise. The above report will really be helpful!

    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)
  3. Report preferences need more details, eg Comparison periods (to the Date or to the period), apply to custom reports, Apply to Users rather than to Organizations.

    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)

    Great to hear you find the Report preferences handy, Andrew. So the team can get a pulse of what they should expand this feature to next, it's good to have a separate idea for each new element you'd like to see developed into this. I've slightly amended the title of your idea to reflect Comparison periods, but you're welcome to start new ideas for the other elements you'd like to set blanket application of. Thanks! 

  4. Every month I publish, export and share reports with certain individuals. I would like to do this within Xero. I set up users who can have "View published reports" access. When I publish a report I can then select that report and choose which of these users I wish to share it with. The user is notified, can login to Xero and is then presented with a list of published reports that have been shared with them. It keeps all the functionality native to Xero.

    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

     ·  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)
  5. Would like to see Current Account codes rollover each year to an Opening Current Account Balance (same with GST codes, Tax codes, HP's, Bank loans) - like P&L items do to Retained Earnings code. And show the Opening Balance on the Trial Balance.
    Currently Xero Trial Balance shows Current Account codes (& all of the above codes) with accumulated Opening Balance & current year movement.
    However the report formatting in the advisor standard reports appears to be driven off movements in the current year (so we can't journal the closing balances from last year to an opening balance code -…

    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

     ·  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)
  6. Can payroll deductions such as IRD arrears or MOJ deductions etc be included in the Payments Report. This is vital information that is not able to be reported on at this stage and I wonder how many deductions have slipped through the cracks because clients aren't aware that a deduction has been made. In the situation where a third party is managing Xero payrolls for clients these payments need to be communicated manually via email. As you can imagine this places a large burden on the third party to ensure that this is captured each payrun.

    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)

    Hi there, we appreciate you raised this a little while ago. This isn't something we have plans for in the near term.

    Not getting a lot of support from other members we’ll soon remove this from Product ideas. If it’s still highly valuable to you, welcome to start it again and see if it gets renewed interest.

  7. Report that brings together all Subcontractors for end of year TPR

    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)
  8. There are a number of Report Templates available in the Client Reports which once adapted would be good to copy either from one client to another or better still from a Client to the Practice Reports, making them available for all clients and they could then be included in Monthly Management Reports.

    Currently you can only copy reports within a client or within the Practice Reports and the facility is not available to copy across from one to another

    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

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

    Back with an update for, everyone 😊We have now enabled the ability to add client-specific custom reports to Adviser packs!

    As mentioned in my last update we don't have direct plans for enabling the ability to copy reports from client to client or client to practice report templates.

    While this update doesn't completely accomplish what's been directly asked in this idea, we know this is a key feature that'll be highly beneficial to some in this idea in creating more comprehensive reports. Thanks for sharing with us all, here.

  9. Being able to group the account transaction report by contact is brilliant but unfortunately the report has default columns for Debit, Credit, Gross and VAT and not running balance or net.

    If the client is VAT registered the total showed by contact is VAT inclusive so please can the report also have the Net column turned on by default.

    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  ·  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. Hi team
    It would be great if you could replace the underscores with spaces when downloading PDF reports from Xero - currently we have to tidy this up before sending reports to clients which takes unnecessary time.

    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

     ·  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. Reporting - Account Transactions - Group by Contact Group - Aged Receivable Transactions

    When I run the Account Transactions new report with Grouping as Contact Group, the option to add opening and closing balances is blocked. Is it possible to enable this so that we can use the report in lieu of a monthly activity statement for the Group.

    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

     ·  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)
  12. Hiding archived accounts from chart of accounts list when customising report layouts, perhaps with a tick box to show or hide the archived accounts. It makes the job of customising layouts so tedious when the old messy chart of accounts come up every time and you can’t hide the archived accounts!

    71 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

     ·  48 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. Hi,
    Something that would be very helpful as an accountant, is the ability to run a report for a given date which shows all the transactions where the VAT was claimed/paid on a later return. I know that the VAT reconciliation report doesn't work with MTD.
    Happy to discuss to help with this.

    119 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

    38 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 everyone, we appreciate why you’d like a report that provides visibility of VAT late claims to streamline your reconciliation processes, especially around year-end and for monthly VAT returns.

    Currently, it's possible to use the Account Transactions report to manually reconcile against filed VAT returns, although we get the desire for a more automated solution.

    This isn’t on the team’s roadmap at present, however this is something we'll continue to consider how we accommodate these needs in future planning for tax reports in Xero. I'll be sure to let you know if there is any movement to share, here.

  14. Ability to change the file name when exporting reports

    When exporting reports, it defaults to Company name_Report Name.pdf. We have a format of naming files in our business which does not match the default format. It would be simpler to be able to change the default file exporting system so that it more closely fits our standards, saving time. This could be added into the company settings. Options include: Report should say: Text [placeholder] Text [placeholder], and "include or exclude underscore".
    Options for placeholders include date printed, company name, report name, etc.

    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

    41 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. Will there be something developed (in the works) on sharing the mapping report with clients, so they know which codes are lumped together in the P&L and Balance Sheet? This seems to be a common inefficiency where they ask the question and we have to break down each code and manually provide the info, as they don't have access to our reporting templates / edit layout function. Suggest a mapping report breaking key accounts codes down in the P&L and Balance Sheet of the financial statements i.e. a report that would be included with your financial statements to show the…

    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

    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)
  16. We need a report that is cash basis and can have number of items sold during a time period. This report also needs revenue totals and allow a tracking category. Essentially this is to produce a report to determine Royalties that are due on some products that are sold.

    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)
  17. For the new format of the Profit and loss report, only show the tracking categories that actually have a balance. Therefore do not show with nil balance.
    Currently have to adjust the report to remove the relevant columns which is time & $.

    The old version did this automatically!

    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

    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 your feedback on this idea, community. We appreciate you sharing how important consistent Profit & Loss formatting is for your workflows.

    As noted by some, currently you can export the report to Excel in order to make adjustments outside Xero as needed.

    To confirm, currently, if a tracking option doesn't have transactions in the period, there won't be a column for that option and there isn’t a way to show it on the report.

    Being open, we don’t have any plans for changing the current behaviour and capabilities of tracking columns within the Profit & Loss report. We value your feedback and will keep this in mind as we evaluate future reporting enhancements.

    That said, there are a few comments within the thread that reference the ability to show accounts that have a nil balance - Earlier this year we released an option within multiple reports to enable…

  18. It would be very useful if the cashflow report could intelligently add VAT payments to Cashflow automatically.

    For example when a VAT return if filed, automatically add the payment amount and date to the report, learning as it does with repeating outgoings what the date might be - if you're paying by DD this is pretty predictable.

    As invoices are generated (payable and receivable) the report already picks up the amount of VAT payable to HMRC and it would not be a stretch to calculate what is due back on purchases, or to use the known VAT reporting date to…

    29 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  ·  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. Would it be possible to up date the CIS feature to have the reports that are filed through Xero to HMRC be automatically saved into the filed with HMRC section so that you can see the original return that was submitted if you have had to update it. Returns are not saved on HMRC if they are submitted through Xero.

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

    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

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

  • Don't see your idea?