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

1082 results found

  1. Transactions posted after a period end affecting prior periods

    Lock dates had not been set and as a result, there has been a few entries in to the last financial year.
    How can I locate these entries?

    I have tried a transaction report, but there are no parameters that I could enter.
    Ideally.

    Example -
    Our year end is 31st August.
    I would like a report that looks for transactions entered between dates 1/4/22 - 21/9/22 that have a transaction date up to 31.8.21 (last year end)

    In other accounting systems, you could take a unique reference number (URN) at…

    13 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 Kellie, you might find History & notes useful for getting the insight you're after here. 

    Though it's not possible to filter by the transaction date - You can set a date range like you've mentioned to view activity that has occurred post your orgs year end and ability to filter by Item types so you just view the item types you're interested in. 

    Keen to hear if this helps. 

  2. 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)
  3. Can we have both CIS deducted by clients and CIS that we deduct from sub-contractors on the P32 report. I use the P32 to tell me what I need to pay across to HMRC but then have to do a separate calculation for CIS that I've deducted from subbies. The way Xero handles CIS deductions from sales invoices is difficult enough already!

    13 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. In the Director's Declaration, it would be great if the report could recognise if there is a single Director or multiple, and then update the wording accordingly. (eg "The Directors have determined" or "The Director has determined".)

    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. 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. 

  6. A aged report that will show the year end balance but can also update this to remove for payments that have been made/received post year end (something that can be done on Sage and is a very useful tool)

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

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. We would like to be able to generate a report that would capture all clients that are entitled to Medicare levy exemption.

    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)
  10. Hi, sometimes I need to open several assets on the asset register at once, side by side and in separate tabs. In the old style report this is really easy as each asset line has a blue clickable link.

    In the new report the only way I can see to open an individual asset is by clicking on the whole line which then navigates away from the main listing. You then have to navigate back to the listing to open the next one. This makes things slow and tedious and I lose my place.

    Can we have the blue links…

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

    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)
  14. 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)
  15. I would like to see the budget csv download with a separate column for ledger code. That way it could easily be sorted by ledger code rather than alphabetically.

    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

     ·  3 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)
  16. 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)
  17. 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)
  18. To include different accounting method for construction company.

    We are using PCM method for our accounting in which our revenue and expenses recognized are based on the project's progress. Our project work done percentage is based on the costs incurred and the revenue and cost of sales are based on the work done percentage.

    I have attached an example of calculation.

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