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

1012 results found

  1. Aged Receivables + Payables reports - Ability to add SUM formula to Total Column when exported to Excel (like old reports had)

    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)

    Appreciate your feedback on the change from older reports to new. While we don't have any direct plans for making updates to the formatting of formulas when exporting to excel we have just made some updates to excel export of reports I wanted to highlight for you here, where we've;

    • Adjusted the default zoom from 150% to 100%, and slightly change the size of title and currency fonts to make the report easier to read
    • Made small changes to the formatting of cells in rows to create more consistency across the report

    We'll stay tuned into the support for other changes coming through the site here an let you know if there's any news on this, here.

  2. In the old Xero reports as part of the management report, it was possible to run a report that showed month by month actuals for the FY to date then the budget month by the month for the rest of the financial year to give a full year forecast.

    However, in the new Xero reports, this functionality has gone. Try and write my own report but the dates don't update automatically regardless of the reporting date you select (as confirmed by a Xero specialist)

    So I can write a report that shows 4 columns - Jan - Apr actuals, then…

    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)
  3. New Account transaction report - remove the totals when generating the report for a single account.
    The new report adds a report total at the end of the selected accounts which is a total of the debit or credit transactions for 'all' accounts selected.
    When only one account is selected it still shows a total - this is in addition to the total for the transactions on the account itself so it shows total of transactions, closing balance and then total of transactions of all accounts selected. It would improve the usability of this report to have the 'overall total…

    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

    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)

    Sorry team, we'll need to take a step back from our previous update here. Though this is a feature our teams would like to pick up in the future, we're unable to focus resource on this atm. As soon as we can pick things up, I'll be back to share again.

  4. It would be useful if Bank uncoded statement line report could also show outstanding payments & receipts. 9 times out of 10 an 'orange' transaction is a client error, duplicate transaction etc. Effectively this would be a complete list of bank items to be reconciled / fixed ( Ideally with the last month, quarter, financial year filter)

    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)
  5. The previous Profit & Loss report allowed you to filter by multiple categories. There was an add t report function which allowed users to drill down into secondary categories and export ALL of the data into one report which showed 1. A P&L Summary, 2. Detailed expenditure for the chosen secondary category. The "Add to report" function allowed the user to export the entire category details as a whole.

    For our business this is critical. We are a bespoke project based company and use this filter constantly & No the project feature does not work for our business....I have tried!

    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

     ·  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)
  6. 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 Elizna, you can run the Receivable or Payable invoice detail reports for multiple contacts at a time. Is there something specific about the Contact Transactions Summary that's missing from these reports that you'd want included ? 

  7. Can payroll deductions such as IRD arrears or MOJ deductions etc be included in the Payments Report. This is vital information that is not able to be reported on at this stage and I wonder how many deductions have slipped through the cracks because clients aren't aware that a deduction has been made. In the situation where a third party is managing Xero payrolls for clients these payments need to be communicated manually via email. As you can imagine this places a large burden on the third party to ensure that this is captured each payrun.

    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  ·  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. In the Aged Payable detail reports: Show a column of paid bills and Credits listed by month by month. This is the functionality form the old aged payables report that I want added to the new reports.

    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)
  9. Reports - would love to be able to run an account transactions report that is able to be grouped by bank account as well, so we can see how each bank transaction has been coded, GST status etc from each bank account

    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)
  10. The Journal report does not show any currency information, it would be very helpful to chow to currency and the debit/ credit source amounts.

    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)
  11. On the Receivables and Payables Detail report, include a flag that shows when a planned payment date has been manually identified (as opposed to the credit terms due date). Will simplify cashflow forecasting

    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

     ·  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)
  12. 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)
  13. Ability to update and amend or assist as a user the cash flow prediction analytics function. Currently the cashflow analysis prediction function doesn't pick up a number of our regularly occurring expense invoices and sales invoices (also sometimes it has them coded as monthly rather than fortnightly etc). Result is that for us the cashflow analytics is very inaccurate and then not usable and as user we are unable to amend or update. But think it could be a good tool if we could work with it somehow to update the AI and predictions

    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)
  14. Why doesn't Xero display the currency symbol (like a $) in any of the financial reports like Balance Sheet, Income Statement, etc.? We get only the plain numbers without knowing they are in U.S. dollars (in my case) and make these basic financial reports harder than necessary to read.

    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

     ·  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. 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)
  16. Where funds span multiple financial years it would be good to be able to add a brought forward fund balance (balance sheet item) the the P&L fund report (income & expenditure for charities where tracking categories are used for the funds) so that the charity has full visibility of the fund available - last FY brought forward + net amount for this FY = total fund till available

    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

     ·  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)
  17. can you please increase the capacity for downloading general ledgers because at the moment it seems very limited. Often we have to send large files and the capacity at the moment is insufficient

    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)
  18. Report preferences need more details, eg Comparison periods (to the Date or to the period), apply to custom reports, Apply to Users rather than to Organizations.

    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

    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)

    Great to hear you find the Report preferences handy, Andrew. So the team can get a pulse of what they should expand this feature to next, it's good to have a separate idea for each new element you'd like to see developed into this. I've slightly amended the title of your idea to reflect Comparison periods, but you're welcome to start new ideas for the other elements you'd like to set blanket application of. Thanks! 

  19. Currently the Account Transactions Report calculates Debits minus Credits which means a positive Running Balance shows in brackets and a negative Running Balance shows without brackets. This is totally contradictory to the usual accepted Accounting Rules. Can this be changed so that the Running Balance is calculated as CREDITS MINUS DEBITS please ?

    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)
  20. Please can you add the ability to stop archived tracking codes appearing on P&L reports just because they had a foreign currency item at some point.
    - Archived tracking codes, with no data in current FY or reporting period appear because years and years ago it had foreign currency trans.
    - The currency L or G are not relevant to the current reporting period. The FY is closed, in some cases years and years ago - there is no need for it to keep appearing.

    Please stop this happening.

    With the new 200 tracking code reports now released this problem…

    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

     ·  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)
  • Don't see your idea?