13 results found
-
Balance Sheet Tracking Categories
Xero has tracking categories for Profit & Loss reporting.
Our single entity charity uses tracking categories to produce a profit and loss report by fund where the fund type is an option within a fund category.
We need the same for the balance sheet to produce a balance sheet report by fund on an ongoing basis.
For example, income and expenditure transactions on a bank account can be tracked, but not the bank account balance itself. Ditto for liability accounts etc.
This would also need a tracking option/field on manual journals.3 votesThanks for raising this and Im happy to say this functionality is already available in Xero. You can use tracking categories and options to report on your Balance Sheet by fund, in addition to using tracking for Profit and Loss reporting.
To view the Balance Sheet by fund:
- Set up your fund type as a tracking category, with each fund as a tracking option.
- Ensure the relevant transactions are assigned to the appropriate fund.
- Open the Balance Sheet report and use the tracking filter to select the required fund.
When creating a manual journal, you can also select the relevant tracking category and option on each journal line. This allows the journal entries to be included in reporting for the appropriate fund. Tracking is also available when importing manual journals using the tracking fields.
Please note that some system accounts, such as bank, accounts receivable and accounts payable accounts, may…
-
Filter Account transaction on Account TypesAccount Transactions - Filter report data by Account Types
When running the account transactions for a nominal ledger, have a quick filter option for 'Account types' as shown in the Chart of Accounts (Revenue, Fixed Assets, Direct Costs etc.)
When running the nominal reports for P&L codes I have to manually select/ deselect codes.
2 votesHi Connor, the ability to filter Account Transactions report by Account Type is already available in Xero. In the Account Transactions report, use Filter to select account types such as Revenue, Expense or Assets.
You can also use Group/Summarise to organise the results by Account Type.
As this meets the request, we’ve updated the status to Existing Functionality and closed the idea for voting. If I've misunderstood you, feel free to reach out.
-
Reporting - Contact Invoice Activity by Month/Annually
Improvement on the customer invoice activity report to enable you to filter and pick just customers so you can run a report by month and by year detailing how much you have invoiced each customer in a period.
Currently you have to pick only one contact at a time which doesn't work and not efficient2 votesThanks for sharing this idea. This is already available in Xero through the Income and Expenses by Contact report. You can run the report for all contacts at once, or filter it to selected contacts, and view the results over a chosen monthly, annual, or custom date range.
To run the report:
- In Xero, go to Reporting and select All reports.
- Open Income and Expenses by Contact.
- Select the required Date range. You can choose a preset period or enter a custom From and To date.
- Under Columns, include Contact so each contact is shown.
- Use Grouping/Summarising to group the results by Contact, if needed.
- To report on only certain customers, use Filter and select the relevant contacts. Leave the contact filter blank to include all contacts.
- Click Apply for any filters, then click Update to run the report.
- Click an amount in the report to view the underlying transactions.…
-
STP finalisation for Australian markets
For future reference, I would like to share the solution we received, as it was much simpler than the long winded process that had been suggested by Xero support
Following the change to our payroll Branch ID, it is correct that employees will see two income statements in their ATO/myGov account after STP finalisation. However, the important distinction is that the two income statements have different statuses—one is marked "Tax Ready" and the other is marked "Not Tax Ready."
Based on the advice from our tax agent, employees should use only the income statement marked "Tax Ready" for their tax…
2 votesHi Chandra
Thank you for providing this info on Xero Product Ideas!
You are completely correct: If an employers branch or ABN is changed mid-way through a tax year, it creates two separate income statements for employees. If only one of those statements is finalised, the remaining income statement will continue to show as "not tax ready."
-
Manual Journals - Ability to use Date shortcuts
+1 [etc] to increase the date field by 1 day does not work.
Have date shortcuts work everywhere in Xero.
1 voteHi TJ, checking in with our product team and testing in the browser date shortcuts should work for posting journals.
If you're having any troubles with this we'd recommend raising a case with our support team through Xero central who can get a closer look in to see what's going on. Thanks
-
interest on MTD
The Mapping on the MTD report currently maps Bank Interest to other property income. This is incorrect as this is not property income at all. This should eb re-mapped so it either does not feature on the MTD filing or appears for review on the Interest tab
1 voteThanks for raising this idea with us Mike, Im happy to say that you can already do this in Xero! You can remap account codes in MTD for IT by going to Tax → MTD for Income Tax → Income and expenses, selecting the relevant tax category, and choosing Manage report codes. Select the accounts you want to update, choose the appropriate report code, and click Map. For more information, see Set up MTD for Income Tax in Xero. But if you need an extra hand you can raise a case with our Xero Support specialists. 😊
-
Reporting - Statement or transaction activity report showing all transaction types for a date range
Accounts receivable/ payable - please add report that reflects ALL (invoices, payments, journals, credit/debit notes, etc) transactions of a range of accounts (customer/supplier) for a specific period/year.
1 voteThanks for sharing this idea. We understand the request for a detailed transaction report showing all activity for a specific contact, including invoices, payments, credit notes and journals.
This is already available using the Account Transactions report. You can filter the report by contact and include the Contact and Source columns to view the underlying transactions and their details.
As this functionality is already available, we’ve updated the status to Existing Functionality and closed the idea for voting.
-
Archive tracking category option
It would be useful to be able to archive individual tracking category options when these are 'spent'. At the moment we have to rename them, as that's the only option available.
1 voteHi Cat, tracking categories and Category options can already be archived in Xero. Go to Accounting > Accounting settings > Tracking categories and select X next to a specific Category options. If it has been used on historical transactions, the option will be moved to the Archived tab, while the historical data remains intact.
As this functionality is already available, we've updated the status to Existing Functionality and closed the idea for voting. For more information, you can refer to our knowledge article.
-
Xero Tax (UK) | Warning when reclassifying assets and liabilities that Xero automatically reverses the balances
I've had an issue when filing accounts on Xero tax that I reclassified an asset as a liability, and it would be helpful to have a warning pop up to let us know that Xero automatically reverses them. It caused significant issues not realising this.
1 voteHey Stewart, this is now possible by using the new Company Accounts option instead of classic Xero Tax. Company Accounts doesn’t automatically move negative asset or liability balances to the opposite side of the Statement of Financial Position. The balance remains in the group determined by its report-code mapping, which allows balances such as provisions to remain with debtors where appropriate.
If a balance does need to move when it becomes negative, you can configure a Switch Rule, similar to the switch option available in Xero reports:
- Open the filing in Company Accounts.
- Open the Statement of Financial Position.
- Select the relevant statement group and open the Switch Rules panel.
- Choose the source group and the destination group.
- Select the specific report code in the destination group.
- Set the rule to move negative items or the entire group, then save it.
Switch Rules apply separately to each accounting period, and…
-
VAT - Create an Out of Scope VAT code
Create an out of scope vat code as strictly speaking this is not actually any of the other codes that already exist despite being advised to use them.
11 votesThis is already available within Xero Sarah. While not specifically called 'out of scope' the No VAT tax rate is the out of scope VAT tax rate to use. When you assign the No VAT tax rate it is not included in the VAT return and is separate from the Exempt or Zero rated VAT tax rates.
We have a bit if help around this in Xero Central but if you need an extra hand you can raise a case with our Xero Support specialists. 😊
-
VAT - Ability to track late claims for Non-MTD filing orgs
Track late claims on VAT returns submitted in Xero but not filed direct to HMRC through MTD.
This is needed in order for VAT groups to be able to prepare returns in non-submitting companies which can then be consolidated.
The only alternative if the VAT group stays on Xero is to run journal reports and manually find late claims, in all non-submitting entities in a VAT group, which is a very manual process.
7 votesThanks for sharing this idea ⭐
Xero already supports late claims in Non-MTD VAT returns. Once a previous return has been finalised, transactions entered later that relate to that earlier period are automatically included in the next VAT return.
To access this:
- Open the Non MTD VAT return and review the Transactions by VAT box or Transactions by tax rate tab to check the late claims included.
- For more information, see Prepare a non-MTD VAT return.
If we’ve misunderstood the request and you’re looking for additional functionality, such as identifying or reporting late claims across multiple non-submitting companies in a VAT group, please reply with more information and an example of the workflow you need.
-
VAT Return — View invoice numbers
Could the VAT transactions report in the VAT return include the invoice number as well as or instead of the reference?
This would make the review to see if there are any missing invoice numbers much simpler. Our invoices are created in another software package by a number of people who sometimes include text as well as the invoice number and it makes sorting by numerical order time consuming. Having the invoice number as a field would make it very easy to sort in numerical order and identify missing numbers.
10 votesThis is already possible within Xero. When a Sales Invoice is included in the VAT return, under the Transactions by VAT box the Invoice number will appear under the Reference column. If the transaction is a Receive Money transaction there is no entry under the Reference column. If you need an extra hand you can raise a case with our Xero Support specialists. 😊
-
UK VAT - Ability to enter VAT scale charge
Ability to enter VAT scale charge on VAT returns.
Purpose: To easily enter and calculate VAT scale on charge in Xero.
10 votesThis is already possible within the Xero VAT return. to adjust for the fuel scale charge when you are on the standard rate VAT scheme:
- Beside Box 1, click Adjust and enter the VAT element of the scale charge.
- Beside Box 6, click Adjust and enter the VAT-exclusive/net element.
- Add a reason, such as “Fuel scale charge – Q2 2026”.
- Leave Create accounting transaction unchecked if you only want to adjust the return. Then click Update.
For example, a VAT-inclusive charge of £120 would normally be entered as £20 in Box 1 and £100 in Box 6. Check the exact treatment with the business’s accountant, particularly if they also want a journal posted to the accounts.
If you need an extra hand you can raise a case with our Xero Support specialists. 😊
- Don't see your idea?