376 results found
-
Account Transactions Report - Running Balance calculation
Currently the Account Transactions Report calculates Debits minus Credits which means a positive Running Balance shows in brackets and a negative Running Balance shows without brackets. This is totally contradictory to the usual accepted Accounting Rules. Can this be changed so that the Running Balance is calculated as CREDITS MINUS DEBITS please ?
5 votes -
Custom Report - Ability to Hide/Unhide Columns
Currently we create a budget for each tracking category (department).
I have created a custom report which includes the budget for each category. I then use the formula function to sum the budgets together.
I only want to see the formula column in the report outputted. (I realise that columns can be hidden when data is exported to Excel)
I understand that there is not a way to show a formula column without all the individual budget columns.
Enhancement suggestion: include a radio button for each column to hide/reveal that column in the report
20 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")
11 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, 🙂
-
Job WIP Balances Report - Criteria Search
I would like to be able to have a selection of criteria for the standard Job WIP Balances Report that allows me to produce that report by certain fields in the report ie Name, State. Also by adding the following criteria would also save me a lot of time exporting and trying to sort by:
1. Client Group; or
2. Manager.4 votes -
Mileage/Tracking Report - Ability to see employee mileage within the tax year
We need the ability to see how many miles an employee has travelled within the tax year. This is so that we can follow HMRC guidelines in respect of the pence per mile that is paid to the employee. Currently the rules state that up to 10,00 miles can be reimbursed at 45p per mile and thereafter this rate is reduced to 25p per mile.
This could also include the ability to set a default rate to avoid any errors made by the employee and to then generate an alert once the employee exceeds 10,000 miles and automatically reduce the…
33 votes -
Reporting - Accept 2 decimal places in Budget Manager
Modify the Budget Manager so that it accepts 2 decimal places and does not round to the nearest full dollar.
Rounding all figures means that the Net Profit amount is incorrect which means the budgets are incorrect.
48 votesThanks for your interest and input on this idea, everyone. Being upfront this isn't something we have planned at this time but we'll continue to monitor the votes and feedback coming through and will be sure to let you know if there's any change to this, here.
-
Business Snapshot - Ability to show monthly and quarterly comparatives
In the Business Snapshot all of the comparatives are to previous year. In a startup this isn't meaningful as prior year balances are nil, but month-to-month or quarter-to-quarter comparatives would be super useful. In established businesses also, monthly and quarterly comparatives can be very useful.
20 votes -
Inventory report - with comparative figures.
An inventory report - similar to the inventory item summary, but that allows the user to compare figures to prior periods. This will allow retailers and even manufacturers, to easily track seasonal trends in sales.
17 votes -
Reports - Group account transactions by month
I would be good to be able to carry out data analysis of each nominal code and therefore group the account transactions by month with totals rather than by week which will ultimately tie back to the P&L. This would make it useful when carrying out data analysis from the P&L.
12 votes -
Receivable Invoice Summary - Date range 'Any' option
Previously, in old "Customer Invoice Report" there was a feature under "Dates" where we could select "ANY" which allowed Invoices created outside of your selected date range to be included in your report.
This seems to be no longer available in the new "Receivable Invoice Report" and any invoices created outside of your selected date range (but paid within that date range) won't show up on the report.
You can expand your date range but this has potential to re-list paid invoices from previous reports.
Can "ANY' be added as an option to Dates as it was in previous version?5 votes -
Invoice Reporting (Payables) - Ability to include Planned Date as a separate column
In the new reports you can run a report, by supplier, of invoices that are due and planned to be paid, which is great. There is a differentiation between due and planned in both screen detail and reporting. The schuduled/planning option enables users or managers to plan which invoices they wish to pay either by viewing on Xero or running in a report. However, the reporting option puts the two together by adding in an invoice wiht the same due date, if a planned date has not been entered. This means that invoices not scheduled/planned to be paid are included…
12 votes -
Reporting - Expenses by contact report option to filter i.e supplier addresses/location/postal code
Broken down to location/ postal code with the total cost for a contact/supplier in any period is needed.
I am aware 'the expenses by contact' gives you the total spend in a year but this doesn't filter down to location/ addresses or post code. At year end a key part of our process is reporting local suppliers for our social impact and purpose, we have to complete a time consuming exercise entering addresses/location manually line by line for key suppliers in excel. This information is reported to our Board of Directors, to our Group Board and as part of our…3 votes -
Short term cashflow - Option to include payroll
Very simply, short term cashflow does not include a range of items the biggest and most important of which is payroll. I think if you are selling this feature you should be very wary of the need for a disclaimer if the feature fails to be accurate, and decisions could be made on false information if for example the biggest expense item being wages is not included.
Granted it should be something people take great care when making financial decisions and should note the issue, many don't have great financial literacy which is part of why xero was created in…
17 votesThanks for your feedback here, everyone. To confirm, if you're using Xero Analytics Plus the dashboard can predict payroll expenses if they’re reconciled as spend money transactions or bills, and are regular in amount and frequency. To manually include payroll expenses, add them as upcoming money out transactions.
We don't have any planned changes for how these type of transactions are represented in Short term cashflows in the near term. If there are any updates made we'll share this with you here.
-
Multicurrency - Stop showing archived Tracking data in reports
Please can you add the ability to stop archived tracking codes appearing on P&L reports just because they had a foreign currency item at some point.
- Archived tracking codes, with no data in current FY or reporting period appear because years and years ago it had foreign currency trans.
- The currency L or G are not relevant to the current reporting period. The FY is closed, in some cases years and years ago - there is no need for it to keep appearing.Please stop this happening.
With the new 200 tracking code reports now released this problem…
5 votes -
General ledger details - Add Posted date and Posted by columns
I was requesting for "Account Type" and "Source" as options that can be added to "Journal" report.
Staff replied these options are available in "General Ledger Details" report and "Journal ID" is also available in "General Ledger Details" report now.
However, the "General Ledger Details" report does not have accounting entries posting date and who was it posted by.
Please add (1) "Account Type" and "Source" to "Journal" report, or (2) "Posted Date" and "Posted By" to "General Ledger Details" report.7 votes -
Top Customers Report - Ability to show chart in Net figures
To be able to run Top Customers report showing the net figures and not just gross.
18 votesAaah thanks for the clarification, Vicky and Alex. You could use the Management report to add the Top Customers report. Appreciate that the chart itself displays for Gross figures right now. We'll continue gathering interest for this here.
In regards to the sort order of the report - By default contacts will be sorted by the Gross column, however you can add a Net column and re-sort by clicking on any column header. 🙂
-
Short-Term Cash Flow - Split payments on Bills
Hi
Client is wondering whether there is a way to split bills in the cash flow prediction to show half the bill being paid on this day and the remainder on another day. Currently you can tell it that we estimate to pay the bill in full on this day but can't see an option to split the bill.
Look forward to hearing from you.
Thanks
4 votes -
Account Transactions report - Add Transaction number
I exported the Detailed Account Transaction Report. Additional column I need is the transaction number so I could group or filter the specific transaction/s that I want to conduct further analysis.
Thank you.
7 votesJust to check, when you say Transaction number would this be the journal ID or the transactions reference number, Archie?
-
Reporting - Option for selective printing (similar to XPM)
Only option is to export documents from Xero. Can the Print option, like in XPM (see attached pic) be added
7 votesThanks for your engagement in this idea, everyone. Apolgies it's taken so long to update you here, and appreciate the confirmation of where you'd like to see this.
We want to be honest that we don't have any planned work for developing print options at the organisation level atm. If there's any changes to share we'll let you know.
-
Assurance Dashboard - Add Reporting Functionality
The assurance dashboard has been around for a while and it's great to have a number of checks accessible in the same place. However, there doesn't appear to have been much development in this area i.e. we are still not able to export out reports from the Assurance Dashboard.
A client reached out today looking for an easy to run report showing bank account number changes. This is an important item to check on for businesses, particularly entities that have bank accounts loaded into Xero by multiple people, use batch payments etc. Accessing this information through the assurance dashboard is…
16 votesHi everyone, appreciate the feedback on my last question. I've slightly amended the title of this idea. As a bit of an update from when I last posted we have actually made an update in History & Notes as I know some of you were interested in - You can now Export to PDF or Excel from this screen and you'll find there are filter options to help you zone into the items you're most interested in looking at.
- Don't see your idea?