890 results found
-
Reports - Export to excel with dashes instead of zeroes
It would be helpful to have the reports, once exported to Excel, already formatted, so that the Nil values are shown as a 'dash' as opposed to '0'. This is particularly useful when there is a large report or several reports with lots of data. It is more efficient when it comes to reviewing the figures, and saves having to custom format the individual reports. We have also had clients, who still prefer reports on Excel, ask for reports in this format, it is time consuming having to change, especially when it is a large reporting pack.
8 votes -
General Ledger Reporting - Group by Account Type
Under the GL Summary Report(new) and GL Detailed Report (new), i notice they run by account code in alphabetical order as a result of which some Balance Sheet and P/L items are mixed together.
How can i run both the above reports in a way whereby all the Balance Sheet items are on top in alphabetical order follow by all the P/L items thereafter in alphabetical order
Can anyone help
8 votes -
Inventory | Reports - Report that lists item sales and customer name and email address
We need to be able to create a report that lists inventory item sales and includes the customer name AND other customer contact information such as email address or phone number.
There have been occasions where I've needed to contact a large group of customers that have purchased a product from me due to a misprint in a book or an update to a title. At present, the only way I can do this is to export my inventory report and add the contacts manually. Xero Support Specialist - Daniel has confirmed this.
6 votesHi team, rounding back to the idea here we want to be open that this isn't a report that we have any plans for developing at this time.
That said, there is a feature in Xero today that may help you achieve what you're in need of - Smart Lists
With smart lists you can set criteria for items that customers have or haven't purchased from you within a period of time. You can either have this compare across all items or run smart lists for specific items. Search results can then be exported from Xero if you'd like to do more with them. Thanks
-
GST Audit beta - Exchange Rate for GST Purposes
We are based in Singapore. Your system does not cater very well for GST when the functional currency is not SGD.
My Xero is USD-based, hence we have to use only GST Audit Beta.
But we have to key in "Exchange Rate for GST Purposes" into our system so that when reporting to Singapore Tax authority, we have to report in SGD. There is no way to key this in, and it means keeping a seperate excel file, doubling our work. This rate is given by each supplier on their bill, and can change on daily basis. So we need…7 votes -
Contacts Ledgers - Ability to pull more than one Contact's ledger at a time
Currently, you are able to pull the Contact Transactions Summary and ledger for only one contact at a time.
If you can add the ability to pull more than one contact's transactions at a time, it would be great. It should work the same as "Account Transactions" where you choose the accounts you want to pull, just for Contacts.
6 votesHi Elizna, you can run the Receivable or Payable invoice detail reports for multiple contacts at a time. Is there something specific about the Contact Transactions Summary that's missing from these reports that you'd want included ?
-
Account Transactions report | Batch deposits - Use Payment Reference
In the account transactions report, the reference for batch deposits (of invoices) should be the payment reference.
Currently, the individual invoice numbers are presented for batch deposits when you run account transactions.
56 votes -
Manual Journals - Multiple date entries
Can we get multiple date entries for manual journals?
9 votes -
Reports - Ability to add custom KPIs to Executive Summary report
Ability to add KPIs to executive summary report e.g. Purchases/Sales percentage for the hospo industry and wages/sales % - these should be at 30% or lower so it would be great to add these into the executive summary report
15 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…
43 votes -
Aged reports - View Credit note allocations
Just looked at the new Aged Payable report > Aged Payables Detail - it doesn't show credit notes which been allocated to invoices. This is very confusing as we can't reconcile against the statement. Please review the report and add in credit notes, even if they have been allocated to the Invoices, or advise which report I need to use when reconciling the account.
10 votes -
Report Templates include a Signature
Having the option to include a digital signature in the report templates, the ability to paste an image into the text section would suffice for this. Useful for the statement of disclaimer where the firm needs to sign off every report. Currently the only way to do this is by exporting the report to a PDF manager and pasting the signature in.
55 votes -
Reporting - Work in Progress to appear on P&L
The ability to add in work in progress each month so that it shows as turnover in the P&L. This will enable us to produce a true position of the businesses profitability.
6 votes -
Reports - Add Account Code column in GST audit report
Please add the account code column?
I also wish to have the exported documents sorted by account code or account name.6 votes -
Budget Variance Report - Remove arrows
It would be nice to have the ability to add/remove the arrows from Variance Reports. Some clients don't like them and only want to see the dollar value.
18 votes -
Aged Receivables / Payables Reports - Add 'Current' column
Case CX0013378184 - Aged Receivables / Payables Reports have changed - Please re-insert "0.00" balance Current Column
We urgently request that the “0.00” balance “Current" column be put back into the Aged Receivables / Payables Reports
XERO has just changed the format of the Aged Receivables / Payables Report to NOT show the "Current" column on the Reports if there is a "0.00" balance.
This is a huge Problem to us as a company with the way in which we do our reporting as we need that column to show. I cannot see the benefit of why this was changed…
14 votesHey team, appreciate the support in this idea. We understand that you'd like to have a current column to to be able to view customers with a nil balance.
Being transparent, this isn't in our plans for the immediate future, but we'll continue to keep our eyes on the support for this idea here. Thanks
-
Report templates - Support General Purpose Financial Report (GPFR) templates
Financial Statements-General Purpose Financial Statements template published will be much appreciated so the accountants have more options
38 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.
15 votes -
Budget manager - Ability to extend periods by more than 12 months
Can we please extend the budget manager period from 12 months to more than 3 years or whatever is possible? The data in the budget manager does not go beyond 12 months and if the budget is to be changed after a year of upload it doesn't have such access.
When working for a movie/film-making company the budget runs for more than 12 months and it needs to be changed time and again. But Xero doesn't have such an option which makes it impossible to get an accurate variance.
It would be great help.21 votesAppreciate how you'd like to do this within Xero, however just to confirm it's currently possible to import budgets with more periods.
You'll just need to make sure to format the dates in your import file - more on this here.
If you'd like a practice run, try it in the demo company before importing into your own org 🙂
-
Manual journals - Export in a format that can be reimported inc. GST
Currently, I can export manual journals from a Xero organization for record saving. However, I cannot use the exported manual journals in Excel format to be imported to another organization directly. Because the exported manual journals show the GST amount in a separate line (GST account). Can you please add a new function to export manual journals for Xero importation? It means I can directly import the exported manual journals from one organization to another without editing.
7 votes -
Reporting - Show Billable Expenses in Account transactions report
When running an account transactions report, the ability to add a column to show line items that are marked as billable expenses or, a filter option to filter for billable expenses.
54 votes
- Don't see your idea?