- or
1358 results found
-
Reporting - Add Related Account filter to Account Transactions report
For some reason the related account is not available to filter on the Account Transactions Report. Can this please be added?
7 votes -
US Sales tax - 1099s: W9 submissions should create an actual document
So we send a W9 request and a vendor completes it, great. But this doesn't create a digital W9 form, it just modifies the information in the vendor's 1099 contact page. So if an auditor requests a copy of a vendor's W9, we have nothing to give them. And it's possible to override the changes made by the W9 submission, so there's no way to verify - say a year later - that the information on their contact page aligns with the W9 information they submitted. The lack of static documentation makes this feature almost useless for us as most…
7 votesHi there
While we don’t create an exact replica of the form we’ve worked closely with our compliance team to make sure that if you are audited we can supply the information needed. We also cater for the event of W-9 information being overridden and needing W-9’s from previous years.
In terms of getting the information for an audit - while we don’t offer a self service option at the moment - if you need it you can submit a request to our support team and we’ll provide what you need for an audit 😊
-
Bank reconciliation report to show contact reconciled to
Bank reconciliation - A report that will show each bank transaction and then which invoice it has been reconciled against, as a way of having a quick way to check something has been reconciled incorrectly. Currently, the only way is to view each transaction through the account transaction report.
7 votesGood to hear you're aware of how you can run the Account Transactions report to view this information, Catherine - Is there a reason or something missing from this report that would help you when reviewing transactions?
-
Inventory - Show items without movement in Inventory Item Details report
The Inventory Item Details report does not show inventory items where there was no movement during the month. Therefore the report does not tie out to the balance per the TB for inventory. Can this be fixed?
8 votesHey Louis - thanks for sharing your suggestion!
Understand that it's not quite what you're after, but it's worth a mention: The 'Inventory Item Summary' report will show all inventory items in your organisation, including those without any movement in the selected period.
I've attached a screenshot as an example, so you can check if it suits your reporting needs - we'll leave this idea up in the meantime 😊
-
Outstanding Credit Notes, Overpayments Prepayments Report
Report to show all open (unallocated) Credit Notes, Overpayments and Prepayments in orginal currency.
5 votesHi everyone, this is actually already possible through the use of the Payable and Receivable Invoice Summary and detail reports.
You can adjust the filters of the report to only select Overpayment, Prepayment and Credit note Source items, as well as set the Status so you only view Draft and Approved items.
Once set up Save as custom, so you can easily access this view anytime. 🙂
-
Reporting: Sales Report - Track sales by sales person
Report that shows the total sales made by each sales person in an organisation
Purpose: Ease of being able to compare Sales reps stats across the organisation and/or overtime
10 votesHi community, as you've found Xero doesn't currently have a function that automatically tracks or calculates sales by sales person.
In the meantime, you could use tracking when you record your sales, which will allow you to report based on sales made by each sales person.
A suggested process is:
- Create a tracking category called something like 'Sales Rep', and create category options within the category for each of your sales staff.
- When a sales invoice or quote is created, you can include the staff member's name in the staff member (Tracking) field on the invoice/quote.
- You can then use the Tracking reports to see the sales that relate to each 'Sales Rep' and calculate commission manually outside of Xero.
If commission sales are a regular part of your business, you may wish to consider using one of our integrated App products. These integrate with your Xero organisation and…
-
Reports - Add Product Code field to Transactions Report
Please add the Product Code as a reportable field to the Transactions Report (and any report that looks at 'Descriptions'). Any transaction description that is genrated from a 'Prodcut' needs to include the Product code to give an essentail higher layer of analysis - i really dont know how anyone can drill down into their Sales data without it? It must be a tick box to add as it will be in the same table that the description comes from. Please just add it or offer a custom report building service.
5 votes -
Bank Account Changes Report Showing Contact's Name - Downloadable as a PDF
Would like a report showing a list of bank account number changes. This would show original bank account number, new bank account number, contact's name, date the bank account number was amended and who amended the bank account number and to be able to print this as a pdf. This would be of great benefit because of fraud and also our Auditor has asked if we can produce a list of bank account number changes for a selected period.
178 votesHi everyone, while we don't have a direct report for this, some changes we've made to History & Notes in Xero will help in achieving what you're in need of here.
You can run the History & Notes, filtering by Type = Contact and typing 'Bank account number' in the Search to just view results for this action.
If needed you'll be able to export your results to PDF or Excel.
Though the contact name doesn't show on screen, you can right click on the Contact in the report to open the contact's record in a new browser tab, that allows you to inspect details without navigating away from your History & Notes results.
-
Journal Report - Option to include the description or reference.
Journal Report - Layout
Ability to edit the layout of the report to include the description or reference.
6 votesHi team, not long since my last update we have now gone live with our new Journal report in Xero. 😁
Thanks again for your engagement in community, here.
As noted earlier, with the new version of this report along with more detail and abilities to sort and filter you'll find 'Description is now a column that can be included and filtered by in this report!
-
Aged Payables Detail report -
Aged Payables Detail Report - when a planned date isn't entered then the due date appears in the report by default.
Please remove this default and if a planned date is not allocated then leave blank or put Add date.3 votes -
Account Transaction report - Add Quantities & Unit Price to Column Drop Down
It would be incredibly helpful if 'Quantities' & ' Unit Price' were included as column options in the Account Transactions report.
This way one can quickly review the quantity & price of each entry without having to drill down into each individual entry. It would also provide a total quantity and average unit price for the given period.
The example that I am referring to is on a farm business where we would like to review the tonnes of crop sold and the price.155 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)
5 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.
-
Invoice Reminders Report - Date and email sent to
Provide a report on who the automated invoice reminders have been sent out to, to know when the final reminder has gone out and payments not made can then be chased manually.
10 votes -
New Bank Reconciliation report - Include note for foreign currency exchange
Exchange rate on bank reconciliation report
For foreign currency bank accounts, the old bank reconciliation report used to include a note stating that the exchange rate per xe.com that was used to translate the bank balance to the home currency at the report date. This was very useful information to include, as it confirmed the rate and the source of where that rate was obtained. This is not included on the new format bank reconciliation report pack. Please could this note be brought back on the new format reports?7 votesHi community, apologies we've not returned to this sooner. Pleased to share that foreign currency disclosures are now available in the Bank Reconciliation Summary report.
-
Reports - Add Contacts report to show contact details and contact activity
Contacts report that shows contact details (name address etc) and Activity in last Financial Year.
This would assist in cleanups of multiple contacts / old contacts etc.9 votes -
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.23 votes -
NZ Payroll: Leave report to show leave balance and total owing
NZ Payroll - I would like a report that shows annual leave taken, any adjustments made to the leave balance and a final total of leave owing. I do not think there is anywhere that shows if an change has been made to someone's leave balance
23 votes -
Management report pack - locking in start dates
We run a P&L Forecast report each month, with 12 monthly columns across the financial year.
Start date = start of the financial year.
Reporting on Month 1, this report shows Actuals for month 1 + Budgets for months 2 to 12, to give forecast total for year.
Reporting on Month 2, this report shows Actuals for months 1 to 2 + Budgets for months 3 to 12, to give forecast total for year.
Reporting on Month 11, this report should show Actuals for months 1 to 11 + Budget for month 12, to give forecast total…5 votes -
UK Payroll - Unpaid leave report
So simple but not available. To record an absence i.e. sickness (unpaid) IN DAYS and to have a simple report showing dates and number of days sick.
The payroll reporting is so seriously lacking in all areas
5 votes -
Management Report - Ability to save individual reports as custom
Management Report: Be able to save individual reports in the management report as custom reports. Currently only the pack can be saved as a custom report. If I have edited the profit and loss I cannot save this specific report to be used in other management packs.
3 votes
- Don't see your idea?