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

522 results found

  1. Hide or Archive System Accounts when not needed. We are a Cash Accounting based business so have no A/R, A/P, or other accounts related to Accrual Accounting. I
    It would be most useful to tidy up our chart of accounts to be able to hide the system accounts related to Accrual Accounting so that they don't clog up our reports etc.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Description Field with the bank narration

    This happened as a couple of newer client and new to xero in the contact field wrote something incredibly different to the bank narration which makes it very difficult to review the general ledger information.

    For example in the General Account the transactions descriptions are all listed as "John Smith" when if the bank narration option was available I could see it is Officeworks, KFC, etc and this would make it easier to realise these are miscoded and reallocate.

    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

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

    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

     ·  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)
  4. The new Profit and Loss report does not filter the actuals AND budget by tracking category. You have to manually add the correct tracking category budget to the report. When you have 40 plus tracking categories this becomes time consuming and silly.

    The old profit and loss report did this easily. So the new report is a major step backwards

    Ensure the filter for the new profit and loss report filters BOTH actuals and budget, so the report is easy to produce and has meaning. Do not expect users to add the correct column for budget - particularly those less…

    51 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

     ·  13 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. You can add formula columns and rows to a report, but from what I can tell, the column formula always takes precedent over the row. It would be cool if you choose if you want the row formula to calculate in the column formula column

    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

     ·  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)
  6. In reports - Be able to make formulas from individual rows / accounts not just "columns, group totals or formula rows". I have attached an example of the work around required to get Gross Profits for hospitality split into Wet (Booze) and Dry (Food). It adds 8 lines and makes the report unwieldy. I would love to to more interesting formula. And not have to export to Excel or other programs.

    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)
  7. Appologies in advance for my frustration.

    Are Xero considering providing a Gender Equity report in the future?
    I raised a case for our HR Dept last year and the answer from Xero was no.

    If any community member has any short cuts on gathering this info, please respond to this post.

    I am wasting so many hours trying to gather the required data from your available reports.

    In April I exported Employee contact details to export & sort.
    This morning I have been exporting Renumeration data and then sorting deleting non date range required emplyees. Due to no date range…

    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

     ·  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. It would be helpful to have the reports, once exported to Excel, already formatted, so that the Nil values are shown as a 'dash' as opposed to '0'. This is particularly useful when there is a large report or several reports with lots of data. It is more efficient when it comes to reviewing the figures, and saves having to custom format the individual reports. We have also had clients, who still prefer reports on Excel, ask for reports in this format, it is time consuming having to change, especially when it is a large reporting pack.

    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

     ·  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. Ability to have the prior year comparatives track the report periods. Currently if a variance column is added to the reports the "Compare with" disappears.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. The ability to customer the Totals line of the Annual Reports so that they have the top line and Bottom Double line along with the figures having a $ sign. It doesn't right to just have the figure without the finishing touches.

    3 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. Can we please have a function where we can filter the data based on the last payment date to show only invoices paid within the date range in the filter?

    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)
  12. Add Notes reference for Statement of Cash Flows for totals.
    When preparing financial statements it is not possible to add a Notes reference for total lines. This is extremely frustrating as we normally have a note reconciling the net operating cash flows to the net operating profit. This requires PDF correction after exporting from Xero.

    Please add functionality to add a Notes reference for total lines in financial statements.

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

    4 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)
  14. It would be great if a column could be added to either the Aged Receivables Report or the Receivable Invoice Detail Report that shows the number of days the invoice is overdue by.

    The number of days an invoice is overdue by can be seen on the 'Awaiting Payment' tab in the invoice section in Xero, but even on this part the information cannot be exported.

    Thank you!

    41 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)
  15. 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)
  16. Under Custom Reports

    I send out reports to my departments each month, this morning it took 4 hours to add the tracking codes to the new P & L reports (we love the new report and so do our Department Heads).
    I was wondering if there is a way of saving each custom report for each individual dept with their tracking within a folder. We have a Junior and Senior Campus and about 45 departments at each. We already have a lot of custom reports so having a folder system would allow each Admin staff member to access what they…

    40 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

    21 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 the example, Shellee! That's a good few departments 😮

    There's no facility to create folders in the Reports Centre for this sort of categorisation atm. 

    We'll begin tracking support in this here. 

  17. Please put a menu item under the Accounting Menu for Journal Entry. I don't like having to run a report just to go to manual journals or to add a new journal. Just put "New Journal" under the advanced sub menu under accounting. If you are concerned about the average bookkeeper making journal entries, allow the ability for the admin to dictate which menu items are shown for different users.

    3 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)
  18. Hi, I was wondering if it is possible to include some non financial data in zero ledgers for reporting?
    For Example - I would like to include a 'No. of Transactions' for a period that would not be a financial number (so no balancing required) but, this number would be available to add to reports i.e creating a cost per transaction.
    We used to call these 'SKU's' and generally they would Non Financial KPI's like:- production days, FTE's, LTI's or Units produced.
    Any help would be great.
    Regards Iain Vernon

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. On the notes section to the financial reports in adviser reports templated under the groups, I would like the accounts selected to be in alphabetical order. At the moment the only option is to manually drag and drop - with a large number of accounts this is extremely time consuming. An automated function would assist.

    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)
  20. Recommendation is to add graphs as a report on Xero. Clients can see their turnover an example over a few months which can be sent to them direct from Xero !

    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)

    Is there a specific report or reports you'd like to do this with, Suveera. 

    Xero analytics is one way of getting more of a visual view of an organisations performance, or alternatively you'll find there are a couple of reports like the Income and Expense by Contact reports that enable you to show a chart of your top 10 customers or suppliers. 

  • Don't see your idea?