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

990 results found

  1. Currently we create a budget for each tracking category (department).

    I have created a custom report which includes the budget for each category. I then use the formula function to sum the budgets together.

    I only want to see the formula column in the report outputted. (I realise that columns can be hidden when data is exported to Excel)

    I understand that there is not a way to show a formula column without all the individual budget columns.

    Enhancement suggestion: include a radio button for each column to hide/reveal that column in the report

    20 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)
  2. Custom Reports
    The formula feature only appears to work for columns that are located to the left of the formula column.
    Each column has a name, surely the name is the important element and not the position of the column on the report.
    Can the formula feature be amended so that columns from anywhere in the report can be included

    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

     ·  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)
  3. Filter history and notes by Action and display sales invoice number. Enable the report to export the to Google Sheets/Excel.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Additional report: Supplier report to include e-mail addresses, supplier address, bank details, terms,

    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)

    Hi everyone, not seeing a lot of interest in this idea overtime and with no plans in the roadmap we will update this idea to Not in pipeline.

    While we appreciate why users would like a report containing all these details, this isn't something we have plans to develop.

    As previously suggested it's possible to export your list of suppliers from contacts that includes email and bank details.

    In relation to spend within a period, you could run the Payable Invoice Details report which can be grouped by Contact and run for a period to view the items purchased and the accounts these were coded to.

    It may also be worth noting that Email can be included as a column when running the Aged Payables Detail or Summary reports.

  5. Very simply, short term cashflow does not include a range of items the biggest and most important of which is payroll. I think if you are selling this feature you should be very wary of the need for a disclaimer if the feature fails to be accurate, and decisions could be made on false information if for example the biggest expense item being wages is not included.

    Granted it should be something people take great care when making financial decisions and should note the issue, many don't have great financial literacy which is part of why xero was created in…

    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)

    Thanks for your feedback here, everyone. To confirm, if you're using Xero Analytics Plus the dashboard can predict payroll expenses if they’re reconciled as spend money transactions or bills, and are regular in amount and frequency. To manually include payroll expenses, add them as upcoming money out transactions.

    We don't have any planned changes for how these type of transactions are represented in Short term cashflows in the near term. If there are any updates made we'll share this with you here.

  6. On Drafts there would be say 10 lines which is actually all for the same asset.

    Say I am building a product store. Using 10 different suppliers. Store, Erection, Floor, Building inside etc. I want to map all those together and register as 1 asset when done. This way the auditors see the whole store as one asset. Not 10 lines that I must show them. For instance "Thats the floor in that storage building"

    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

     ·  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)
  7. Project Summary Report always had actual hours and estimated hours on and since it has been updated this option is no longer available and that is 2 of the most important columns for us. Also the wording of the headings have changed and no longer match the Project Details report which is ridiculous. This report needs to be converted back to how they used to be.

    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

     ·  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)
  8. Adding Client's (Supplier) tax registration number column to Account Transactions report and Income/Expense by Contact report. Helpful with filing INTRASTAT, VIES & 46G.

    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)
  9. Ability to setup a 13 week budget (blocks of 4 weeks). We currently cannot utilise the budget function because there is only the ability to budget monthly.

    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  ·  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)
  10. Hi there, would be awesome to be able to have a column in the detailed general ledger which has the quantities from what you entered in the quantity column when you reconcile the transactions. This is especially important when figured is used with Xero. As it takes a lot of time to go into each transaction and see what the stock quantities are to get the group total.

    57 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 everyone, we hear your feedback about how viewing quantity within the General Ledger report could help when reviewing transactions. While not specifically within the General Ledger there are a few different reports that can currently be run and may help with this review;

    • Inventory Item Details – view quantity on hand of tracked inventory items
    • Inventory Item Summary – see quantities purchased and sold for all items, including opening, closing, and adjusted quantities for tracked items
    • Sales by Item report – shows quantities sold for inventory items
    • Payable Invoice Details report – shows quantities purchased for all line items
    • Receivable Invoice Details report – shows quantities sold for all line items

    We’ve reviewed this idea but want to be upfront that there aren’t plans in the near term to add quantity as a column to the General Ledger Detailed report.

    We’ll keep an eye on the interest this idea…

  11. In the Inventory Item Summary report I can customise the report by adding a filter & then searching for a stock item eg a spigot - but there are 100 different types of spigots, & each of them need to be selected individually!!! can we please have a "select all" button???

    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)
  12. I would like to have an option for repeating journals to be done daily. Currently you can only choose monthly or weekly.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. I have voted for the idea "Switch Rules - Notes to Financial Accounts" but would like to also propose an idea that may be of benefit if that one is too complex to implement.

    Enable a rule that allows an account to be shown/hidden depending on the balance.

    For example - if Accounts Receivable is a credit balance then it will display, if it has a negative balance it is hidden.
    That means that the Accounts Receivable account could be added to two schedules in the report, but will only show in one, which should align with switch rules in…

    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)

    Appreciate you thinking of other ways to solve something, Jessica. With a lot of the reporting teams concentration on elements to redevelop the most vying features from older reports in the new before their removal later this year I want to be open that we don't have this in pour plans at this stage. 

    We'll start to get a sense of the interest for this here, and let you know if there are any changes. 

  14. To be able to view at a glance the 'period taken from a customer to pay invoices' from the Due Date to when the funds have reached the supplier's bank account. This is instead of exporting the Xero report in an excel sheet and then adding a formula to calculate the difference between the two dates. Surely with all the information already stored in the Xero account, this option shouldn't be too difficult to add. Thank you.

    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)
  15. We need the ability to sort the data in the VAT Report table.

    This will make it much easier to review all the transactions to check that everything has been properly allocated.

    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  ·  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)
  16. It would be very useful to be able to change the names of the General Ledger Account Types. Also Fixed Assets should be changed to Capital Assets because Capital Assets is really the applicable term because not all Fixed Assets fixed. Machinery, equipment, rolling stocks......

    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

     ·  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)
  17. To be able to run Top Customers report showing the net figures and not just gross.

    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

    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)

    Aaah thanks for the clarification, Vicky and Alex. You could use the Management report to add the Top Customers report. Appreciate that the chart itself displays for Gross figures right now. We'll continue gathering interest for this here. 

    In regards to the sort order of the report - By default contacts will be sorted by the Gross column, however you can add a Net column and re-sort by clicking on any column header. 🙂

  18. When reviewing a VAT return on the transactions by tax rate tab - there is no way to view the detail if the payment was through an invoice or bill even though you are able to see the detail if it is entered as a spend money or receive money transaction.

    Being able to create bills and add attachments is extremely convenient, however, it is not when you are unable to see the detail you have provided when reviewing the VAT return.

    Please look into this! Thank you.

    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  ·  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)
  19. Can we please extend the budget manager period from 12 months to more than 3 years or whatever is possible? The data in the budget manager does not go beyond 12 months and if the budget is to be changed after a year of upload it doesn't have such access.
    When working for a movie/film-making company the budget runs for more than 12 months and it needs to be changed time and again. But Xero doesn't have such an option which makes it impossible to get an accurate variance.
    It would be great help.

    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

    8 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)
  20. In the Business Snapshot all of the comparatives are to previous year. In a startup this isn't meaningful as prior year balances are nil, but month-to-month or quarter-to-quarter comparatives would be super useful. In established businesses also, monthly and quarterly comparatives can be very useful.

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