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

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

  3. Currently, you are able to pull the Contact Transactions Summary and ledger for only one contact at a time.

    If you can add the ability to pull more than one contact's transactions at a time, it would be great. It should work the same as "Account Transactions" where you choose the accounts you want to pull, just for Contacts.

    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, appreciate the additional feedback and it's been some time since our last engagement here.

    We don't have any plans for enabling the Contact Transactions Summary or sub reports to be run for multiple contacts at once right now.

    Appreciate the needs expressed here on getting more visibility for reviewers to be able to clearly see payments against accounts and this is something we'll keep in mind as we continue to build out our reporting in Xero.

    For now the Receivable and Payables Invoice detail reports would be the best option. If needing to zone into payments you could filter by source within this report. Thanks

  4. In the account transactions report, the reference for batch deposits (of invoices) should be the payment reference.

    Currently, the individual invoice numbers are presented for batch deposits when you run account transactions.

    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

    8 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. Financial Statements-General Purpose Financial Statements template published will be much appreciated so the accountants have more options

    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

     ·  12 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. Ability to add KPIs to executive summary report e.g. Purchases/Sales percentage for the hospo industry and wages/sales % - these should be at 30% or lower so it would be great to add these into the executive summary report

    15 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. We need the ability to see how many miles an employee has travelled within the tax year. This is so that we can follow HMRC guidelines in respect of the pence per mile that is paid to the employee. Currently the rules state that up to 10,00 miles can be reimbursed at 45p per mile and thereafter this rate is reduced to 25p per mile.

    This could also include the ability to set a default rate to avoid any errors made by the employee and to then generate an alert once the employee exceeds 10,000 miles and automatically reduce the…

    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

     ·  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)
  8. Just looked at the new Aged Payable report > Aged Payables Detail - it doesn't show credit notes which been allocated to invoices. This is very confusing as we can't reconcile against the statement. Please review the report and add in credit notes, even if they have been allocated to the Invoices, or advise which report I need to use when reconciling the account.

    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)
  9. Having the option to include a digital signature in the report templates, the ability to paste an image into the text section would suffice for this. Useful for the statement of disclaimer where the firm needs to sign off every report. Currently the only way to do this is by exporting the report to a PDF manager and pasting the signature in.

    55 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

     ·  8 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. Please add the account code column?
    I also wish to have the exported documents sorted by account code or account name.

    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  ·  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 nice to have the ability to add/remove the arrows from Variance Reports. Some clients don't like them and only want to see the dollar value.

    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

     ·  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)
  12. Case CX0013378184 - Aged Receivables / Payables Reports have changed - Please re-insert "0.00" balance Current Column

    We urgently request that the “0.00” balance “Current" column be put back into the Aged Receivables / Payables Reports

    XERO has just changed the format of the Aged Receivables / Payables Report to NOT show the "Current" column on the Reports if there is a "0.00" balance.

    This is a huge Problem to us as a company with the way in which we do our reporting as we need that column to show. I cannot see the benefit of why this was changed…

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

    Hey team, appreciate the support in this idea. We understand that you'd like to have a current column to to be able to view customers with a nil balance.

    Being transparent, this isn't in our plans for the immediate future, but we'll continue to keep our eyes on the support for this idea here. Thanks

  13. I would be good to be able to carry out data analysis of each nominal code and therefore group the account transactions by month with totals rather than by week which will ultimately tie back to the P&L. This would make it useful when carrying out data analysis from the P&L.

    15 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)
  14. Showing profit of Loss on Trial Balance (at both Client XERO Blue and advisor) Reports

    At present the trial balance report does not show profit or loss, can or will XERO recode the report in client reports(XERO Blue) and in the advisor templates. This is something I believe all accountants and bookkeepers will welcome the change, as the would improve workflow.
    Please refer to trial balance from competitors software (has printed that way for over 30 years)

    37 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)
  15. When running an account transactions report, the ability to add a column to show line items that are marked as billable expenses or, a filter option to filter for billable expenses.

    54 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)
  16. It would be useful to run a supplier invoice report that includes the Nominal ledger code the invoice as been assigned to

    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  ·  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. A button you can click to reverse the order of the columns in Reporting
    Typically the reports show the month in question closest to the account descriptions and then the prior months in columns to the right but we'd like to look at our current year starting with the earliest month in the column next to the account descriptions and the remainder of the year in columns to the right. This is particularly useful when building out projected cashflows.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    You can re-order the columns of your report with the layout editor, Robbie. 🙂

    Once you've got the report set up as you like you can Save as Custom to easily access the report with this layout. 

    If you're like to make this the default layout there is also an option for this - see our help here & here

  18. A report to run to identify suppliers and customers that have not used in the last 12 months, so we can archive some contacts.

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

    Not a capture all but maybe a step in the right direction for now that could help, Maureen - Smart Lists could help you get a view of the customers that you've not sold items to recently. 

    You could run a New Smart List to view Any customers who have Not Purchased Any items In the last year - Find out more on Smart lists here. 

  19. In reports - allow accounts to be be shown in number code order rather than in alphabetical account name order when grouped using codes in the edit layout area.

    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)

    Gotcha, thanks for rounding back, Kieran. Get where you're coming from especially if you often update or add accounts. 

    We don't have any immediate plans around this but we'll keep an eye out and let you know if there's any plans to change, here. 

  20. Can we please add a budget column to the statement of cash flows report. I find this report (once customised to reveal all account codes) very useful for showcasing cash received vs spend on taxes, assets, liabilities and business expenses. To be able to set a budget in the budget manager for cash flow will save hours preparing manual cash flow forecasts outside of xero.

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