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

  2. In the Director's Declaration, it would be great if the report could recognise if there is a single Director or multiple, and then update the wording accordingly. (eg "The Directors have determined" or "The Director has determined".)

    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)
  3. 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)
  4. The ability to do budgets by GL account number. It's very perplexing this is not available today!

    95 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  ·  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)

    Hi everyone, we’ve been tracking this conversation and appreciate the insights you’ve shared around budgeting. We get how being able to sort budgets by General Ledger account number could streamline your workflow and help reflect the structure of your reports.

    Currently, as you may know you can export budgets to a spreadsheet, and sort them outside Xero. But, we understand you'd prefer a solution directly in Xero.

    We want to be transparent; this isn't currently in our roadmap. As we continue to monitor this space, we’ll update you here if anything changes.

  5. The ability to have accounts display in GL account number order on reports. It boggles the mind that this is not an option already!

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

    Hi everyone, thanks for the engagement and support on this idea. We recognise that having the option to display accounts in GL account number order when editing a reports layout would reduce the need to manually adjust the order of accounts.

    We've reviewed your feedback, including the specific issues with grouping, and are moving this idea to Accepted. This reflects that the idea has not been included in our current roadmap but that this is an idea that we will continue to monitor.

  6. With the currect feature History and note report we are able to see which invoice for example has been edited - change name of invoice - reconciled etc. However we would like to have a more detailed view, for example if an invoice is booked in USD and someone will change the currency in EUR we are not able to see this change , we can see only that the invoice is edited by X person but we are not able to see the change. How can we have this feature?

    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

    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 wanted to provide an update of a recent change we have made where you'll now see the email address of the primary email entered in the To field is recorded in history each time an invoice is sent. You can read more about this change in my update here.

    As mentioned on that thread there are a couple of unique scenarios we are tidying up and I'll return to confirm once that is complete.

  7. Would it be possible to add Project Codes as a selectable column in the Account Transactions report? We would find this most useful as it would save time.

    115 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

     ·  55 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. 169 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 community, we appreciate your insights on this idea. We recognise that having depreciation excluded from the Cash basis P&L can limit how useful the report is for understanding overall business performance.

    The distinction you’ve highlighted between a cash basis Profit and Loss report and a Statement of Cash Flows is a helpful one and gives us a better sense of why this feature matters for your reporting and compliance needs.

    For now, creating manual journals is the only available option to include depreciation in cash basis reports. While not ideal, it’s a feasible approach if you need to reflect these adjustments.

    We want to be upfront here that this isn't something we have roadmapped right now, and not likely to be planned soon.

    This may be something we revisit in the future and will make sure to share any updates if the situation changes.

  9. Report listing all customers including contact details, credit terms and credit limits

    132 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

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

    Thank you for the engagement on this idea. We’ve listened closely, and know that being able to export full customer credit information including credit limits and associated credit terms would be a highly beneficial feature for you all that've voted.

    As mentioned in our previous update the Aged Receivables Summary report does provide some of the information requested, however we understand that this may not fully meet all your needs.

    Our Product team has reviewed this idea and we're updating the status to ‘Accepted’. This is an idea we’d like to develop, but isn’t currently on the roadmap. Please continue to add your comments and votes and if anything changes, we’ll make sure to post an update here.

  10. Include the option to enter the Registered User's UTR number in CIS verifications as well as the Organisations UTR number which will allow partnerships to be verified - HMRC need both to verify a partnership.

    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

     ·  17 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)
  11. VAT reporting in the EU includes ICP reporting for sales to other EU countries (aka pre-Brexit EC Sales reporting). Part of the reporting requirement is to supply the customers VAT number on the ICP return. The customers VAT number is supplied at the time of invoicing and is included on the invoice and in the customer contact details so is an existing field in Xero. To meet the ICP reporting requirements, every invoice is opened manually to find the customers VAT number which is entered against each customer on an export of the Sales Tax Audit Report spreadsheet off Xero,…

    23 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)
  12. A note of outstanding, unreconciled statement lines before completing a VAT return.

    Currently you click review and can see the VAT return; however, it would be useful to have a box that would flag if there any unreconciled transactions within the VAT period.

    This would help to ensure no transactions are missed when completing a VAT return.

    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

    1 comment  ·  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 to you all for sharing and supporting this idea. We understand how helpful it'd be to identify unreconciled statement lines within the VAT period before completing a return, reducing the risk of missed transactions.

    This is being considered as part of a wider piece of work to help identify and resolve outstanding items at the right point in the tax-filing process. While it's not in development as yet, we'll keep you updated as work gets picked up.


  13. In the new reports you can run a report, by supplier, of invoices that are due and planned to be paid, which is great. There is a differentiation between due and planned in both screen detail and reporting. The schuduled/planning option enables users or managers to plan which invoices they wish to pay either by viewing on Xero or running in a report. However, the reporting option puts the two together by adding in an invoice wiht the same due date, if a planned date has not been entered. This means that invoices not scheduled/planned to be paid are included…

    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

     ·  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)
  14. It would be helpful to have the ability to add overdue invoices into the Short-Term Cash Flow Projection report without having to change any details in accounts receivables.

    7 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)
  15. It's unfathomable to me that it is not possible to do something as simple as output sales by state or by province or by country or by city. These are discreet fields in Xero and we ought to be able to filter a sales or P&L report to just include sales for some regions or to summarize by state or country. Right now all I can do is export all transactions and run everything through excel, which is not the way this should work. Thanks.

    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

    18 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, while not a fully fledged report you may find Smart Lists within a contact useful at present. 

    From Contacts you can set up and get a list of customers that meet certain rules that you've set up - such as 'Location' is and setting this to one or more locations your customers are based. 

  16. It would be extremely useful to be able to either
    1. export the main data from all purchase orders / or
    2. be able to make up a custom report

    Ie: Supplier, date / reference / ETA / Salesperson / dollar / Revenue identity etc.
    Used For: Sales team, Customer order ETA's etc

    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

    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)
  17. 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)
  18. I've accidentally created a Small Business Depreciation Pool in the Fixed Asset section of a client.

    As far as I can tell there is no way to permanently remove or delete this, and it just hangs around forever?

    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

     ·  4 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)
  19. 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)
  20. Please please can you sort your system so that when we are bulk importing our annual jobs that it is possible to import the budget also - I have asked for this for many years but to date nothing has changed. I hope that now that you have finally updated the system, after several years of empty promises, perhaps this is now a possiblity. It is far too time consuming to enter the budget manually with over 1000 jobs and would speed up our invoicing if the budget field was imported instead of having to look elsewhere for the fee.…

    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

     ·  19 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?