522 results found
-
Reports - Add custom reporting template
One custom template layout that could be transferred over all reports. We have multiple nominal codes for income and expenditure which means a lot of work to set up a new custom report. I currently have to export into excel which can cause errors.
39 votes -
Aged receivables summary - Add due date
Could we please add the 'Due Date' option to the Aged Receivables Summary Report. I love the simplicity of this report versus the Detailed report but unlike the detailed report, there is no option to add the due date.
1 voteThanks for the feedback, Jodi. When you say you'd like to add the Due date I'm guessing this would be as a column to the report? One thing that would make this tricky is where you have multiple due dates for a customer with multiple invoices in the period the reports being run - what date would you expect to show here?
-
Supplier Bill Activity report - Run in Foreign Currency with totals
The Supplier Bill Activity report is great for showing transactions for a Supplier if you operate only with one currency.
However, for accounts with Multicurrency, it should also include optional columns for the Source Currency amounts and when showing just one currency, the balances in that currency in the list of columns.36 votes -
Profit & Loss Report - Compare > 200 tracking categories, and bulk select
Thanks for adding the new "compare tracking categories" in the new Profit & Loss Report.
However, even with this additional development the new version of Profit & Loss Report requires you to manually add each tracking category one by one. Having the feature of "select all" reinstated as the old version did would be really helpful.
Having limited tracking categories to 200 isn’t helpful, previously Xero was able to search across an unlimited number of tracking categories, but only report on the active ones.
I’m sure there are many users that have more than 200 tracking categories (not always active…
48 votes -
Reporting - A more detailed Purchase Order report
Purchase Order Reporting
The current work around of using the Outstanding Purchase Orders Summary report lacks a lot of the vital info that's needed to manage Purchase Orders and create accruals at month end. A report that shows all the - coding, tracking codes, dates, who created and who approved, Description, etc and ability to run reports on only those that are not Billed and both with and without detailed lines would be more helpful.27 votesHi everyone, thanks for your feedback here. We appreciate there are more details some in the idea here would like to see around reporting of Purchase orders in Xero.
We wanted to highlight for those in the conversation that it may help - There are Purchase order common formats in the Payable Invoice Detail report that you could use.
For example, in the All purchase orders detail report, you can add a column to show the account, tracking and any other line item info you need.
We want to be open that we don't have any plans right now for additional Purchase order reporting, however we'll continue to keep an eye on the idea here and share if there is any news.
-
Expense claim report for company money
Our company are making use of the "personal money" and "company money" options to submit their expense claims. There is a report to track cost paid with personal money but no report to track cost paid with the company money. This report will be critical for commission calculations.
5 votesHi Hiten, company money transactions are recorded in the organisation as Spend money. You could run the Account Transactions report for your bank accounts, and add a filter for, or group the report by source to only see spend money transactions.
In terms of commissions, we don't have a specific feature for tracking this however you could use Tracking in Xero to set up a Tracking category and each of the employees as a tracking option on that category. This way when they are entering company money transactions you could track it back to the employee by filtering by that tracking option.
-
Reporting - Cash Based Accounting Inventory Sales Reports
Xero offers users the ability to select between cash-based accounting and accrual-based accounting for financial reports. However, a major problem is that the inventory sales reports are based only on accrual-based accounting. This means the financial reports and inventory sales reports are never consistent. Please add the ability to run cash-based accounting reports for inventory sales (sales by item, etc.).
4 votes -
Reports - Option to hide "Tracking Transfers" from journals report
Get rid of (or just hide) "Tracking Transfers" when printing PDFs of manual journals. Seeing descriptions are more important than the background tracking.
30 votes -
Account Transactions report - Option to Group by and then summarise within a group
Account transaction report that can analyse multiple accounts in one report by grouping everything by account and then summarising each account by contact at the same time.
2 votesNot exactly what you're after here, however in lieu of not having the ability to summarise within a group you could use the column header to order by Contact within a grouping.
Being open, we don't have any plans for developing this capability in the near term.
-
Reporting - Better filtering in Reconciliation Reports
Where there is more than one bank account in an organization, it would be very useful to be able to filter out a particular Cat Code, separately , within each bank account. Currently one gets the entire Cat Code for the entire organization, showing all the bank accounts. Also, the column "Tax" remains blank when a bank account's reconciliations for the date selected are chosen. Please see my uploaded example of just one bank account's reconciliations, which contains every transaction, but no tax shown. The report shows "Gross" and "Net" to be equal, when in fact there are many with…
1 vote -
Report Templates - Default client advisor reports to alphabetical order in Xero HQ
Xero HQ report templates overwrite the order of accounts to alphabetical when accessed at a client. The report templates are in the correct part of the financial statement for the client, but then it defaults to alphabetical order. This requires you to change the order for each client, even though it was done at the HQ level.
3 votes -
Reports - More detailed bank transaction report.
Add a more detailed bank transaction report.
It would be nice to generate a bank report that allows you to see the accounts booked in details. For example, if one transaction has multiple accounts, I can see what accounts where used and what amount. this would make it a lot easier to look over and control if you made some mistakes or did not included bank fees in the transaction.4 votesHi Ester, have you tried he Account transactions report? There's a 'related account' column that may suit your needs and will show the GL account that the transactions is coded to.
-
Reporting - Option to extract transaction details without subtotals and formatting to support pivot analysis
Most often when I extract XERO finance reports I have to strip out all of the headings and totals in order to get to the raw transaction data for further pivot analysis and data refinement. Having a raw data dump (i.e., excel or csv format) as an option to the formatted files would save considerable time for users doing pivot analysis, multi period or year comparisons, adding calculations and additional columns, preparing charts, and just trying to summarize the data in a different way.
10 votes -
Reporting - Report on Paid expense claims
Be able to view a report of expense claim details of expenses that have already been paid
12 votes -
Analytics Plus | Short term cashflow - Filter predictions by bank account
Analytics Plus - Predictions do not filter based on bank account selection
When you have multiple bank accounts but only need one selected for cash flow purposes, the monthly predictions that xero has created do not filter out based on the bank account they were predicted from.
In my example I now have petty cash predictions and interest income from a savings account showing when only the main current account is selected, this messes with the predicted end balance making the cash totally useless
5 votes -
Reporting - Monthly and Annually Recurring Payments to Suppliers
Please explore the possibility of generating a report that efficiently and clearly captures Recurring Payments made to any contact or supplier with either monthly or yearly frequency?
Currently, this is not achievable without significant manual effort to extract data from various reports in Xero. While I’m aware that the "Repeating Bill Payment" feature setup can also aid with producing a report of this nature, most clients do not use this setup, and the information isn't sufficient.
Payments have been processed in Xero through various methods, including bills, direct debits, and spend money transactions. The desired report should be able to…
2 votes -
Reports - Option for 'Start of Fiscal Year to End of Last month' date range
Reports - Date Option - Start of Fiscal Year to End of Last month
13 votes -
Reporting - Distinguish between 0.00 and nil balance accounts
On balance sheets or profit and loss reports. It would be amazing if there was a distinction between accounts that have nothing in them (e.g. -) and accounts that have a nil balance (e.g. 0). They currently have the same icon (-). Having different icons would make it easier to distinguish without having to click into the account.
3 votes -
Account transactions - Common date for 'last week'
An option to set the date range to "last week" from the date range pull down options in account transactions reports.
Being able to create custom account transactions reports set to "last week" would be invaluable for our weekly reporting, avoiding fiddly changes to the date range each week when pulling a number of reports, and preventing any dating errors.
It would be a great advantage.
Should be an easy to add that option to Xero, I would have thought.
And it is a common option (e.g. GoCardless has it.)
2 votes -
Reporting - Show Invoice Approved Date in the Current Nominal transactions Report for Turnover reconciliation
Turnover per XERO and VAT declared Net Sales should be ideally Equal ,however often may not match and therefore need reconciling-which is important to understand the difference from both the YE accounts and HMRC point of view .
There should be a report in XERO which can facilitate this reconciliation rather than use spreadsheets -which is time consuming when the information is already existing in XERO
One of difference arising is -"The Date" invoice created and approved -are different and will report in different periods of the VAT return and Xero Sales Nominal Account
Example -Invoice created and left as…
2 votes
- Don't see your idea?