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

568 results found

  1. Currently if you export your fixed asset register, the dates are exported in mm/dd/yyyy format. If you use the dd/mm/yyyy format, then the figures are wrong in excel. e.g. 06 April is read as 04 June (and the figure eg 44088 is the wrong one). Other dates come as text e.g. 2/28/2022 and are not read at all. It should be possible to export them as number eg. 44080, which can be formatted as required.

    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  ·  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)
  2. The variance columns in the current P&L reports don't make sense - increased costs show as positive variances, despite the red arrow. The formula is fine for revenue and profit, but needs to be the other way round for costs. Is it possible to have this, or to add a column with different formulae for different sections?

    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

    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)

    Hi team, to confirm how the Budget Variance report works currently it'll show;

    • Green arrows for favourable amounts
    • Red arrows for unfavourable amounts
    • Increases in the amount from budget will have an upward arrow
    • Decreases in amounts from budget will have a downward arrow

    We appreciate your feedback here however being open, there are no plans to change the way this logic is applied in the report, or to extend the arrow colouring across the figures/amounts in the report. 

  3. I think it would be useful, in the GST Audit Report, to show the Payee, rather than the reference. The reference is often not very informative.

    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)
  4. Issue - When accessing the Recent Bill Report from the contact screen the automatic date range is the most current month. If you require anything longer this requires multiple steps to rectify.

    Purpose - To show relevant recent bills depending on the contact/entity, not just the bills in the current month.

    Solution - Have an option to set a custom date range that automatically loads when clicking this report. This custom date range could vary from entity to entity.

    1 vote

    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)
  5. 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)
  6. Projects - Would be terrific if we could produce a report based on employee projects, for example to be able to see what staff currently have on, the $$ they have quoted for a period of time etc.

    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)
  7. It would be really helpful if you can add more filters in the Project Summary reports, e.g.. a date range for "Closed Date" so we can report on Projects completed in a specific month. At the moment the date range is based on time entries only.

    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

     ·  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)
  8. Reporting - to run a report that can show payment information (eg. paid date) and reference/item information.

    A report under cash basis does not show the reference that I put on the invoice reference or the item information chosen in the invoice, it is really hard to search receivable payment based on the information I need (PFA).
    A xero support specialist explained that because there is no reference on the payment, I can only search by Contact name or invoice number. But, when we do reconciliations to match the bank received with the invoice, there is nowhere to add an…

    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

     ·  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)
  9. Looking out our month-on-month Income Statement is cumbersome. Adding "YTD" in the "compare with" field would be an upgrade to fairly standard accounting.
    thanks.

    1 vote

    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. Can we combine two xero report ?
    Payable invoice detail report & Detailed time report.

    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)
  11. Is there the ability to make the cashflow report into an accrual report also so we have one report that can show p&l and capital expenditure with an area for adjusted accounts payable/receivable still outstanding and then projecting the bank balance.

    Currently we use a 12-month P&L and then have to do a separate balance sheet and it doesn't quite hit the mark.

    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

    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. So annoying that my published reports remove decimals points every time. PLEASE MAKE THIS CHANGE. Published reports should be saved as is!!! Do not modify my published report XERO! We produce hundreds of these reports every month and have to keep adding the decimal back. This is driving our firm insane!!!

    30 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)
  13. Sales Tax Audit report is produced only on the organization's base currency.

    To be able to produce the Sales Tax Audit report in other currencies as well.

    Reason: to be able to extract the report for organisations registered in countries of which currency is other than the Company's base (if also required for the authorities.)

    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  ·  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. I need to be able to run the "Income and Expenses by Contact" by Due Date rather than by Invoice Date, i.e. I would like to be able to select a date range and then there could be a drop down selection indicating whether these dates are Invoice Dates or Due Dates.

    We are a SaaS company with monthly subscription invoices, and what I am trying to achieve by running the report by Due Date is to report by the usage month which the invoice relates to.

    E.g. an invoice for August's usage would be auto generated on 25 July,…

    1 vote

    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. The new reports are, as default, jumping to the top of the page on refresh. This is impractical and time consuming having to scroll down back to where you were. Can this be looked at and stopped

    1 vote

    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. It would be really helpful to be able to able to pull off a debtor report showing the NET figures, not gross. As i am continually being requested by IF to reproduce debtors report as net as they don't fund the VAT !

    1 vote

    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)
  17. 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)
  18. Enable 1099 report to Canadian businesses

    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. New reports - enable data capture in links

    Currently - if you select a specific date range or filter and then link to this report, that data is lost and upon clicking the link you get the default report and have to reselect the data.

    It would be useful and time saving to enable the link to capture that data - the same as the old versions of the reports

    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)
  20. Add Puerto Rico to the sales tax lookup under States where your business is registered to collect sales tax

    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

    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 raising this as an idea on the site, Rhyse. We don't currently have plans for extending auto sales tax to other regions atm but we're keen to stay close to the interest of this here. I'll let you know if there's anything changes for this, here. 

  • Don't see your idea?