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

706 results found

  1. The new custom report pack looks great but it would be good to be able to export the VAT return within the same pack. Can the VAT reports be added to this functionality? I think it would be helpful for many people.

    I regularly look at a profit and loss, balance sheet, aged receivables detail, aged payables detail and the VAT return reports monthly for all clients and it would be great to export these together, and would save a lot of time.

    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)
  2. At the moment on the old P&L and Balance Sheet reports if you change the company on another tab and have the P&L and B/S open in another tab if you press F5 on your keyboard it will update to the new company you have changed to. This feature is not available on the new P&L & B/S which will be the only source from July. I really need this F5 function on the new reports as I have 20 ledgers to run and if I have to keep re-running the P&L & B/S at month end it will significantly…

    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)
  3. Now that we can add equations, I'd like to see Xero add non-financial data for use in calculations. Specifically, I'd like to add a number that changes each month (number of clients). This will allow me to calculate the revenue per client. I would also like to add the number of clients lost and clients gained so I can calculate the churn rate and customer lifetime value (important to use in making decisions on marketing spend).

    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  ·  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. one of the ATO requirement is to submit the Expense from other companies with ABN into it. if you can implement by adding ABN to the report, it will be really helpful for us.
    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

     ·  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. Produce a Tpar printable Tpar report per subcontractor so we have something to give them when they request details of the amount reported to the ATO

    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

     ·  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. Profit & Loss report: Show account names on 1 line.

    The new report has account names over 2 lines, so makes the report extra long, and not very easy to view on the screen. Analysis becomes less efficient.
    Prefer the old version report "look". We were able to see the business at a glance on fewer pages!

    Also, the extraction to excel now has merged cells. Have to unmerge and manipulate before using the report. Again less efficient.

    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)
  7. The ability to import report templates for financial 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

     ·  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 Xero HQ when we create a New Template for Reports and add reports according to our preference, We are unable to add reports like Top Suppliers and Top customers report in Xero HQ but those reports are available in individual client's organizations.

    It would be great if we can add these reports in Xero HQ so it would be easy to generate month end reports from Xero HQ for all the clients.

    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)
  9. Recent changes to the report layouts when comparing categories means that categories without data no-longer show. It would be great for the user to have the ability to choose whether to include/exclude.
    This is particularly relevant when reporting is exported to Excel for customised reports that cannot be developed within Xero. The exported data out of Xero needs to have same column headings so that lookups in Excel continue to work.
    The recent change has meant that reports we have already developed within Excel that rely on Xero data no-longer work. And is time consuming to add back in columns…

    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)

    Appreciate the feedback, Julie. This has generally been to help keep the report clean.

    There aren't any direct plans for adding non used categories back into view but it'd be good to be able to share if there are any specific reports you're commonly using that you'd find this view useful in.

  10. "Compare Tracking Category" in the Old Format P&L Report includes columns for all Tracking Category Values USED in the date range; irrespective of whether the value is ACTIVE or ARCHIVED.

    "Compare Tracking Category" in the New Format P&L Report is different: it includes columns for ACTIVE Tracking Category Values. This represents an incomplete view because ARCHIVED Tracking Category Values USED in the date range are not included.

    Please can you enable reporting of USED Tracking Category Values in the New Format P&L Report before you remove Old Format Reports in July 2023.

    Custom reports don't provide a viable solution due…

    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

    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. I have successfully managed to create a custom report.

    I now want to add on rows which give me the opening and closing balance each month to get a 12 month cashflow. Is there a way I can do this from the statement of cash flows (using the cash and cash equivalents at beginning and end of period)

    When I try to add rows to my custom report it doesn't seem to offer to add, but only to group item is this something that could be considered.

    I work for several charities and this report showing money in bank at…

    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)
  12. The existing 'Statement of Cash Flows' could be enhanced to be the bridge between the P&L and the balance sheet.
    1. Term debt and cash are netted to give the movement in cash equivalents. If the statement differentiated between 'term' funding (in our case, reduction of term debt) and the 'cash at bank' balance it would better describe cash flows.

    1. Make repayment of loans a 'financing' activity. Currently it is wrapped in 'cash equivalent'.

    2. The flows in Operating Activities would be more meaningful if it highlighted where to see changes. For example, working capital changes in the period under review…

    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

     ·  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. I am having some difficulty with "Blank Reports". I designed a small divisional report which included only a small percentage of my P&L accounts. I tried to select a date range which is offered but doesn't work - the only date range that works is the current financial year. If you want to look at last month, last quarter etc - no luck.

    When I brought this to the attention of Xero, their response was that feature isn't available - then why is it a report option. Their suggestion was to modify the P&L format which has date options that…

    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)
  14. It would be so helpful to have a YTD column in the account transactions report. I run this report monthly for certain sales accounts to give to our marketing department and need the monthly amount and also the year to date amount however this report only allows me to show the period selected. This means I have to run 2 reports, one showing the monthly account transaction total and then one showing the year to date account transaction totals which I then combine in excel. Would also be good if there was a comparison to budget column.

    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)
  15. I would like to send departmental P&L/spend reports to my managers. For eg, send all marketing spend to that team showing the act v bud figures AND all the transactions making up the actual fig
    I reckon it would be best to add the Act and Bud figs at the top of the account transactions report for a particular chart of accounts

    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

     ·  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 great if Analytics Plus had the option to exclude individual bills.

    For example, our business pays our BAS and PAYG from a sub account.
    We are unable to exclude this from the projection.

    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)
  17. Report Design - Option to add the Field of who created the quotation

    This will allow better use in data review/manipulation

    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)
  18. For large farms/orchards or multiple businesses in the group, needing a P & L each for each Farm and Orchard. Then a combined statement P & L bringing all the totals together with the group overhead expenses. Currently have to do separate custom reports in Xero then paste in, would be good to have it all formated in one spot not doing multiple reports and copying and pasting. Currently using another accounting software provider to do the financials and only using Xero to collect the date, would be good to have it all in one spot

    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)

    Hi Tracey, appreciate it's been sometime since you initially raised your idea here. Not getting any community support this will soon be removed from the forums. However, taking a read through it may be worth looking into Tracking to see if this feature could be useful to track expenses for each orchard/farm. The P&L could then be set up to provide columns of the expenses and revenue for each orchard comparably. Thanks

  19. 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)
  20. With the old reports you were able to run the report and then click into one of the GL codes to look at the data. There was then a link "back to P&L / Balance sheet report" which took you back. This is missing in the new report which is very time consuming as it seems you have to start again with running and customising your report.

    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)
     ·  Dana A responded

    Thank you for rounding back to confirm, Emily. I’ve changed the title of your idea, and we’ll keep an eye on the interest from the community here. 

    For now, you can try to use the right click to open a new tab on your browser when opening the transaction or code. We’ll come back here if there’s any news. 

  • Don't see your idea?