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

1032 results found

  1. 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)
  2. VAT - Ability to sort, filter and search what is in each tax box or tax rate when reviewing a tax return. This will help when reviewing a return before submitting.

    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

    4 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)

    Hey community, thanks for your interest and feedback on this idea 💡

    Did you know that the transaction reports on the VAT return can be exported to Excel format where these can then be sorted/searched and filtered to help review the transactions?

    We don’t have any near term plans to expand functionality to develop the ability to sort, filter and search within the tax rate box of the VAT return. If anything changes in the future, we’ll update you on this idea! 📢

  3. I would like to put fixed asset categories (plant and machinery, motor vehicles etc) as the columns, and have Cost, Depreciation, NBV - bfwds and cfwds etc in the rows underneath. See attached.

    As far as I was aware it was standard to have the fixed asset note in this format so was surprised this was not already a functionality,

    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  ·  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)
  4. 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)
  5. Added features to P&L report design to be able to add variance between YTD Actuals and YTD budget on the P&L report

    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)
  6. 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)
  7. 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)
  8. 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

  9. 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)
  10. Would be fantastic if when a fixed asset purchase is recorded and a document is included with the transaction, this document is also recorded in the draft fixed asset window. This would help as reference when moving the asset from draft to registered.

    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  ·  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)
  11. 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)
  12. 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. 

  13. The Profit and loss report: Compare tracking are amazing, but still needs the following:
    1 - To be able to edit the heading/remove the dates from the heading (as this is all reading showing on the top of the report, and can be very cluttering if every heading is starting with 1 June - 7 June 2022 ....)
    2 - in the old P&L: compare reports, the columns/tracking that was not applicable "disappeared", with the new reports, I'm seeing ALL my tracking that is available, and not only the ones applicable, please do the same for the new 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

     ·  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. Can we keep a track on changes to Tracking Categories

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Ability to dive into the total amounts on the GST Reconciliation Report.

    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

     ·  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. Using the new Contracts form, when verifying a subcontractor, you are now asked to enter the CIS Tax Rate (Gross, 20% or 30%) before you verify the subcontractor.
    You cannot save and verify with HMRC unless this field is completed. Without verification, you cannot be certain as to the tax rate.

    The error could occur where you choose a rate for the purpose of being able to 'save and verify'. If the verification failed and you required to speak to the contact, or in most cases wait for HMRC to add a subcontractor to the CIS scheme which is currently…

    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  ·  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)
  17. Could we please have the functionality of running TB reports with more than 36 months historic comparative months, thanks

    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

    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)

    HI community, thanks for your support here. While this isn't something we have plans for extending comparatives beyond 36 periods atm, it'd be good to get more detail on the ideal # of comparatives you'd be looking to run the report for, and what this would help your business do - Please do comment to share your views. 

    Other options you'll see you have with the new report, is that you can change the comparative period between Day, Month, Quarter or Year. 

  18. Enable the Payable Invoice Detail report to total the invoices for each contact. At present the report totals the GST component of each contact's invoices, which I find not at all useful. It would be possible to export the report to Excel, and calculate the totals in that format, but this would be time-consuming.

    I use the payable invoice detail report to get approvals for payment. It would be useful for the person doing the approving to see how much each contact's invoices add up to.

    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)

    Hi team, returning to the idea here I wanted to check if this is still an issue? With the Payable Invoice Details report you'll find you can 'Group by' Contact and there are options to include Balance, Gross Tax and Net columns within the report so you can get a full break down and totals for each. 

  19. Placeholders are really useful in repeating manual journal entry - could we please have them in regular manual journals?

    Oftentimes it will be necessary to repeat a series of manual entries when realising income in advance as revenue however the amounts will vary so a manual journal is required for each instance.

    Being able to have [Month] etc in the narration would make it much faster to populate each entry. [Example: "Revenue realised in [Month]"

    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

     ·  1 comment  ·  Manual journals  ·  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. We run a P&L Forecast report each month, with 12 monthly columns across the financial year.
    Start date = start of the financial year.
    Reporting on Month 1, this report shows Actuals for month 1 + Budgets for months 2 to 12, to give forecast total for year.
    Reporting on Month 2, this report shows Actuals for months 1 to 2 + Budgets for months 3 to 12, to give forecast total for year.
    Reporting on Month 11, this report should show Actuals for months 1 to 11 + Budget for month 12, to give forecast total for year.

    I…

    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

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