Reports & tax

14 results found

1. Depreciation schedule - Identify assets that have had investment boost applied

   It would be great if there could be an investment boost report that could be printed out to help isolate what assets have had this boost applied so the new IR10 requirement can be easily reported on. Or even if that column could be added to the existing Fixed Asset report to add in.

   IR10 requirement - Businesses must now record the total value of assets they have claimed Investment Boost for in Box 60 ‘Total value of Investment Boost asset(s) being claimed’.

   79 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   14 comments  ·  Depreciation  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

2. Customer List

   Please create a customer list report with options to list the fields in the contact details. The export sucks because one cannot filter it or choose the fields to export.

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   1 comment  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi Suzette, are there any specific contact details that you would be looking to get in a report? If you can share a little more on your use case this will help when sharing back with our product teams. Thanks!

3. filter account transactions by contact

   When filtering Account Transactions report by contact, show only contacts in the report, rather than all contacts.
   Would make conducting a review a lot easier - i.e. if you are reviewing one account in particular.

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

4. Improve the uncoded statement lines report

   The uncoded statement lines report is really helpful to send to clients to show what documents we are missing, but seems to lack the functionality of the other reports.

   On high volume clients with multiple bank accounts an un-grouped option would be useful. When client provides receipts in currency paid GBP it is more helpful to have the data sorted by date rather than by bank account.

   It would be good to have the date range shortcuts (eg "this month", "last month", "last quarter") on this report - the uncoded statement lines report only has the calendar date selection option.

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

5. Budget Manager - Add Balance Sheet Items to Budget

   Budget Manager - Add Balance Sheet Items to Budget.
   - It makes no sense that one can't budget for balance sheet items.
   - The purchase of assets and repayment of loans, etc., have to be budgeted for and reflected in the budget actual vs budget reports.

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Budgets  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

6. Account Transaction Report add Item Code as a Column

   Update the Account Transaction Report to include the Item Code as a column, enabling users to track spending for each untracked inventory item.

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

7. Claude Connector improvements - Multi Entity & Transaction level data

   Two significant limitations with the Xero-Claude connector that make it difficult to use in practice:

   Single entity authentication only. Multi-entity businesses need to aggregate data across legal entities, but currently you have to stop the Claude session and reauthenticate for each entity. This rules out any scheduled or automated processes, which largely negates the value of the integration - at that point it's quicker to download a Xero extract or use another tool like XO.

   No transaction-level data. Pulling GL balances is useful, but most reconciliations and business reports require underlying transaction detail. Since Claude can't pull this, you're already logging into Xero to download transaction extracts manually - at which point there's little reason to bring Claude into the process at all. If transaction-level access were available, this integration would become genuinely powerful. Hoping that comes soon.

   Two significant limitations with the Xero-Claude connector that make it difficult to use in practice:

   Single entity authentication only. Multi-entity businesses need to aggregate data across legal entities, but currently you have to stop the Claude session and reauthenticate for each entity. This rules out any scheduled or automated processes, which largely negates the value of the integration - at that point it's quicker to download a Xero extract or use another tool like XO.

   No transaction-level data. Pulling GL balances is useful, but most reconciliations and business reports require underlying transaction detail. Since Claude can't pull this, you're already… more

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   0 comments  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

8. US Sales Tax - Use Tax application and returns

   U.S. State Returns - USE TAX PROCESSING NOTES
   6/10/26
   Note: the following notes are based on treatment of Use Tax in California and South Dakota. I believe that the procedures listed would apply to most states that impose a Use Tax.
   What is Use Tax?
   Use Tax is the term used to describe the “Sales Tax Equivalent” that applies when an organization purchases a taxable item/items from a vendor and the invoice for the purchase does not contain a charge for the appropriate sales tax. The amount of the Use Tax is typically the same amount as the Sales Tax that would have applied on the purchase if the vendor had included such tax on the invoice and is nearly always based on the total tax that would apply at the delivery point of the product. This total tax may be comprised of the following components of tax, depending on the state tax laws at the point of purchase.
   • State sales tax.
   • County sales tax.
   • Municipal tax.
   • District tax.
   • Other applicable taxes imposed by state tax law.
   Contact should be made to the appropriate state revenue or tax agency responsible for sales tax law to determine the appropriate taxes to be applied.
   Why is sales tax not charged on some purchase invoices?
   There are a variety of reasons that sales tax may not be charged on purchase invoices.
   • The most common is that the vendor from whom the purchase is made is in a different state than the purchaser and the vendor does not charge the purchasing state sales tax for some reason. This is quite common with internet purchases, as current law excludes such sales when the annual sales volume is under a specific amount. The most common amount is $100,000 annually, but this should be verified with the state agency in the state where the purchaser is located.
   • Another reason is that when the vendor purchases both taxable and non-taxable items from the vendor and has provided the vendor with a “resale” certificate. Unless the purchaser specifically tells the vendor that the purchase IS taxable, it is most likely that the sales tax will not be charged because of the tax-exempt coding in the vendor’s software system.
   • Sometimes in-state vendors assume that non-profit organizations are “tax exempt” from sales tax when that is not the case. In fact, many such software documentations, including QuickBooks (Online and Desktop) and Xero and others incorrectly make a blank statement that non-profits are exempt from sales tax, which is NOT correct. While 501(c)(3) and (c)(6) organizations are exempt from income tax, they are most generally NOT exempt from sales tax. When this happens, it is necessary to accrue Use Tax on the invoiced amount, AND the in-state vendor should be contacted and advised to charge tax on future invoices.
   • Some small local vendors may erroneously believe they are exempt from charging sales tax, or they simply refuse to do so. While you must accrue and pay Use Tax on such purchases, you may want to consider using alternate vendors in the future unless the vendor is the only source of the items purchased. Frequently, these small vendors are the same ones that assume non-profits are exempt from all tax, not just income tax.
    
   Process for accruing and payment of Use Tax:
   The following steps are needed to accrue and pay Use Tax.
   1. Use Tax is typically paid at the same time and in the same form as the state sales tax return. The information typically required on the return is as follows:
   a. The total amount of invoice purchase for taxable items delivered to the purchase location, and
   b. The total amount of sales tax that should have applied for the taxable purchase.
   2. This would require a General Ledger liability account in the Chart of Accounts. This would typically be in the same numerical sequence and located in the same section as the Sales Tax Liability.
   3. Use Tax would be composed of the same sales tax components as the Sales Tax that would apply in the location of the purchaser. This may include the state sales tax, a county tax if applicable, a municipal tax if applicable, and all district taxes if applicable.
   a. Ideally the software system should allow for the purchase total and the applicable sales tax component amounts for each of the components. These components may all post to the Sales Tax Liability GL account even though they are first listed under a Use Tax total in the first portion of the Sales Tax return.
   b. If the software does not allow for the component portions of the tax, it would be calculated as the return is prepared.
   4. If the software system used by the company does not allow for the component portions to be identified separately and does not provide for a way to capture Use Tax purchases, it will require manual effort to capture the appropriate purchase and component value totals.
   Note: This should be a consideration when reviewing software systems for use in the organization. Many software systems state that they manage Sales Tax Reporting but do not include any software to address Use Tax Purchases. If their software systems also claim to “automatically” file the organization sales tax returns, this would result in incorrect sales tax filings. Organizations using such systems should NOT allow automatic filing of sales tax returns but instead realize that they must manually complete such returns to appropriately include Use Tax purchase data.
   5. When making a payment of sales and use tax for the sales tax return, you will need to …
   a. If you created and posted to a Use Tax Liability account to track Use Tax totals separately, you will need to do one of the following when paying the sales tax return:
   i. When making the payment, you will need to post the appropriate amounts to both the Sales Tax Liability and the Use Tax Liability accounts, OR
   ii. You will need to make a transfer of the Use Tax Liability portion of the payment from the Use Tax Liability into the Sales Tax Liability and then record the entire payment as offset to the Sales Tax Liability account.
   iii. Either is correct, the choice would be what level of tracking your organization wishes to do for Use Tax.
   6. Use Tax is normally not a frequent or large dollar item but is required to be reported on by states that impose a Sales Tax, so it is something that needs to be addressed. During sales tax audits, they will always search for invoices that do not contain sales tax and dig deeper into finding out whether Use Tax was accrued and paid. Penalties and Interest will apply if Use Tax is ignored.
    
   Process to enter the invoice to capture Use Tax Payable:
   When an invoice is received for a taxable purchase (typically an expense or fixed asset item(s)) but does not include a charge for the sales tax on the purchase, use the following workaround. This assumes that you have created a liability account for Use Tax Payable.
   For the example presented, assume that the item purchased is $100, and the aggregate sales tax is 7%. Further assume that the taxable invoiced amount for the period is $5000.
   1. Enter the invoice as follows:
   a. The credit to Accounts Payable is $100.00, the amount of the invoice.
   b. The debit to the expense or fixed asset account is $107.00
   c. An credit of $7 is made to the Use Tax Payable GL account.
   d. Credits = $100 + $7=$107.00 Debits = $107.00
   2. When the sales tax return is due to be filed & paid to the state, we would include $100 as the “Purchases subject to Use Tax”, which is normally then added to the total taxable invoice amount. Example: $5000 + 100 = $5100.
   3. Tax would calculate at $5100 x .07 = $357.00
   4. Thus, the $7 accrued for Use Tax is included in the total owed to the state.
   5. In this example, a manual journal entry would be made to transfer the $7 from the Use Tax Payable account into the Sales Tax Payable account to allow the full liability to the state to be paid from the Sales Tax Payable account.

   U.S. State Returns - USE TAX PROCESSING NOTES
   6/10/26
   Note: the following notes are based on treatment of Use Tax in California and South Dakota. I believe that the procedures listed would apply to most states that impose a Use Tax.
   What is Use Tax?
   Use Tax is the term used to describe the “Sales Tax Equivalent” that applies when an organization purchases a taxable item/items from a vendor and the invoice for the purchase does not contain a charge for the appropriate sales tax. The amount of the Use Tax is typically the same amount as the Sales Tax… more

   1 vote

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   1 comment  ·  Tax filing  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

   Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

9. "Last week" common selection date range

   When selecting a date range in reports, please can a "last week" / "this week" common date selection be added?

   •  

   2 votes

   vote vote vote vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   vote

   We’ll send you updates on this idea

   1 comment  ·  Reporting  ·  delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

   Hi Arthur, is there a particular report you'd find this selection most useful for? It's unlikely we'd add this as a common date range across all reports at once - it'd be good to better understand the reports this would be most helpful for you on. Thanks

10. calculate vat liability in cash flow manager

    It would be good if Xero could use vat charged on invoices and spent on bills to calculate what the predicted VAT is for that quarter and add it into cash flow manager - rather than this needing to be added manually

    1 vote

    vote vote vote vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    vote

    We’ll send you updates on this idea

    0 comments  ·  delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating
    Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

    Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

11. Total Rows should always total the lines above it, even if the lines above it are calculatued using a formula

    If I have a report and a column is a formula.

    When I export that report to excel, the column has the underlying formula in each cell.

    The column even has that formula in a cell that is in a total row. This is okay if the formula is a percentage, but never if the formula is an amount.

    A total row with an amount should always be the total of the cells above it. Never any other formula.

    Other column types (such as date), do not suffer this issue, they will correctly insert a formula that sums the cells above it, for a total.

    Please fix the excel export so that it will correctly total the amount cells above it in the total row, even if the column is a formula column.

    If I have a report and a column is a formula.

    When I export that report to excel, the column has the underlying formula in each cell.

    The column even has that formula in a cell that is in a total row. This is okay if the formula is a percentage, but never if the formula is an amount.

    A total row with an amount should always be the total of the cells above it. Never any other formula.

    Other column types (such as date), do not suffer this issue, they will correctly insert a formula that sums the cells… more

    1 vote

    vote vote vote vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    vote

    We’ll send you updates on this idea

    0 comments  ·  Reporting  ·  delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating
    Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

    Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

12. MTD for ITSA quarterly Report adjustment

    Currently the MTD reports display the transactions year to date (which is actually what's being filed) but as the year progresses, the volume of transactions will grow and the same transactions will be reviewed repeatedly. It would be better if the MTD quarterly reports show the transactions of that quarter plus any new or adjusted transactions from previous quarters. This could be done by tagging each transaction with either submitted/not submitted on a previous return.

    1 vote

    vote vote vote vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    vote

    We’ll send you updates on this idea

    0 comments  ·  Tax filing  ·  delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating
    Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

    Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

13. Personal Tax (UK) | Repayments to be shown separately

    Tax repayments on UK Tax Returns are automatically offset against the January payment on account, even when it's requested to be sent by cheque or bank transfer. There should be the option for this to be shown separately on the calculation as it will confuse clients when they want to know what is due for payment in January.

    1 vote

    vote vote vote vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    vote

    We’ll send you updates on this idea

    0 comments  ·  Tax filing  ·  delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating
    Idea review  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.

    Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂

14. Reporting: Include read only access to all reports on Ledger subscriptions

    Please provide read only access to Payroll reports, Employee data and GST Returns when a subscription is downgraded.

    1 vote

    vote vote vote vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    vote

    We’ll send you updates on this idea

    0 comments  ·  Reporting  ·  delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating
    Idea review  ·  AdminDavina Roper (Admin, Xero) responded

    Hi Vicki, thanks for taking the time to bring this idea to us. We will need more detail on the idea, such as is the read only permission for the client or staff and any other specific details you can give us so we can review the idea for you 🙂