895 results found
-
Account Transactions | Foreign Currency - View running balance
I deal with a foreign supplier in US$. I would like to see a running balance of my transactions in the Account Transactions report in the foreign Currency
12 votes -
Reporting - Ability to sort notes alphabetically
On the notes section to the financial reports in adviser reports templated under the groups, I would like the accounts selected to be in alphabetical order. At the moment the only option is to manually drag and drop - with a large number of accounts this is extremely time consuming. An automated function would assist.
12 votes -
Account Transactions report - Filter Description by multiple terms
I need to search Invoice descriptions to find Invoices that have certain quote references.
I've found a workaround for this using an Account Transaction report and filtering on description. However I can't find a way to use an OR operator.
For example I can create a report that finds all quote references with "A0", and I can modify that to display a report that finds all quotes with a reference that contains "L0".
However, I can't find a way to create a single report that contains all quote references with "A0" OR "L0" (or "A0" OR "A1" OR "A2")
12 votesThanks for the detail in your idea here, Paul. I had a bit of a test of this myself and have checked in with our reporting team.
It doesn't quite appear in the modal once the report's run - this is something that we'll look to improve.
However, it's possible to enter multiple terms which will each be searched and return results for (like OR as an operator) - All you need to do is enter a comma(,) and space between each condition.
For example A0, L0 or A0, A1, A2, 🙂
-
Projects - Add 'actual hours' and 'estimated hours' to Summary Report
Project Summary Report always had actual hours and estimated hours on and since it has been updated this option is no longer available and that is 2 of the most important columns for us. Also the wording of the headings have changed and no longer match the Project Details report which is ridiculous. This report needs to be converted back to how they used to be.
12 votes -
CIS - File for overpayments allocated to a CIS invoice
Yes that's right. Let's say you pay a subby £150 in advance and allocate that as an overpayment on their account from the bank feed. You then get an invoice from them a couple of weeks later for £500 and deduct CIS of £100 leaving £400 outstanding. You allocate the overpayment from the account of £150 and pay your subby the balance of £250. The system will only declare CIS on the £250 element of what you have paid. You have to know an overpayment has been allocated, reverse it and allocate the payment directly to the invoice for it…
12 votes -
Reporting - By Contact Group
Cost analysis by group type, e.g. we have a group for DD suppliers. It would be useful to analyse how much we spend by group over a set period. We are looking at setting up other groups soon so this would be very helpful.
12 votesThanks for your idea here, Kerry. Can I ask if there's a speciufic report you'd like to be able to run by Contact group?
-
Manual Journals: Allow placeholders in standard manual journals
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]"
12 votes -
AU Tax: Pay the ATO directly from the Activity Statement page
The ability to pay the ATO automatically from Xero would be a really handy feature. Similar to the automatic super payment, this would be a huge time saver.
12 votes -
Manual Journals - Ability to change column order
The new menu format does not make logical sense. You now have to scroll to see any details and in long journal postings scroll down the page due to unnecessary spacing and you cant resize the columns? In addition, why are the totals for the debit and credit columns not underneath the columns?
Logically, it would make sense to have the description first, followed by account, debit, credit to enable easy review. The new layout appears to be more confusing than anything else. If we can re arrange the rows, can we also re arrange the columns?
The previous format…
11 votesHi team, just adding an update here as it's best if each idea is separated so we can get a clear gauge of interest in a change - I've created a new idea from this one about the debit & credit request, and have slightly adjust the title here to reflect the desire to change the column ordering.
We'll update if there is any change planned for either of these ideas respectively. Thanks
-
Reporting - Ability to change the presentation or base currency at a report level
Ability to run detailed transaction and other reports translated to another currency.
When you are running a multinational business, the ability to convert all data back to 1 currency for reporting is invaluable. Though the entity may trade in one currency, being able to report in another is also important.
Also, looking at the detailed transactions for analytics is important but difficult when it's in a foreign currency. Having a multicurrency TB for export/import and reconciliations would also be handy.
11 votesHi team, we appreciate all the engagement so far. We understand that when you’re working with multiple currencies, being able to view and present reports in a different currency can make it easier to communicate results.
At the moment, report currency is tied to your organisation’s base currency, which means you can’t switch the presentation currency directly within a report.
For now, these reports and spreadsheet exports can help bridge the gap when you need converted views for reporting. We’re continuing to track interest here and share it with the team.
We’ve moved this to Gaining Support so others can add their use cases and help us better understand how this feature could add values.
-
Navigation - Practice Setting to set default for Favourite reports
Can the list of favourite reports be set to default to always include the Trial balance (at least with Advisor rights). As an accountant I always run a Trial balance report and have to manually set this as a favourite on every client I log into. I also regularly use the accountant transaction report and Aged payables and receivables which are already default favourites.
11 votesThanks for sharing on the new navigation with us here, Shirley. We'd like to get a sense of the interest in this from the community here and will keep a close eye on the traction.
If there are any updates we'll share with you here.
-
Reporting - Percentages with decimals when expenses shown without
Xero allows us to choose whether or not we show decimals in an Income Statement. We believe showing 2-decimal places on revenue and expenses to be unnecessary, but feel it is VERY important to show 2-decimals on the % of revenue. It is better to show .04% than .00% and .05% than 1%. We would like to see Xero separate the option of decimals between numbers verses percentages so our clients can have a clear grasp on their performance.
11 votes -
Reports - Option to export as CSV
Currently all reports can be Exported to PDF, Excel or Googlesheet. Please add an option to export to CSV. This file would not have report headings, just column headings.
When exported data is to be imported into another system it is time wasting to have to remove the heading lines and convert the file to csv.
Seeing that Xero requires all it's import files to be in csv, it's odd that this is not an option for the reporting side of things.11 votes -
Aged Receivables - Include credit limit
We would like to see the credit limits included in the Aged Receivables Details, as well as in the Summary. This way, when we are working with detailed reports, it will be easy to see if a customer has exceeded their limit without having to run a separate report.
The amount could be placed as an extra column on the total amount of each client in the report.11 votes -
Reporting - Output PLS Report in TrustEasy Format
PLS Report (EFT Reconciliation Report): Currently it merges first two fields of client name and surname and if that could be fixed with ability to export in .csv / excel please. It would be great if it PLS report could be exported in TrustEasy format to manage fee from refund (attached).
11 votes -
Income and expenses by contact - Filter using tracking category
We run multiple branches out of one Xero ledger. We find the income and expenses by contact report very handy to track sales data, however it would be much more useful if we were able to filter by tracking catagory (for our instance we track branch locaiton).
11 votes -
Trial Balance - Monthly movement report
Would be great to be able to run a report showing the monthly net movement on the trial balance for a year (ie. 12 columns)
11 votesAaah yes I get what you mean, thanks for coming back to clarify for me, Kevin. We'll leave the idea here to gather interest.
While this isn't something we have plans for atm, I'll update if there is any change around this to share.
-
Xero Tax - Reporting name vs Account name
Currently Xero pulls data from the connected ledger into Xero tax – it’s great! But its pulls the account name, when we’re often only changing the reporting name so as not to mess with a clients system.
Would be beneficial if Xero tax pulled the reporting name rather than the account name through for linked accounts. Would make things more consistent between financials & tax return.11 votes -
UK Reports - Add Net column to account transactions report
Being able to group the account transaction report by contact is brilliant but unfortunately the report has default columns for Debit, Credit, Gross and VAT and not running balance or net.
If the client is VAT registered the total showed by contact is VAT inclusive so please can the report also have the Net column turned on by default.
11 votes -
Reporting - COInvest report that captures all info required.
Report that brings together all Subcontractors for end of year TPR
11 votes
- Don't see your idea?