530 results found
-
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 -
Reporting - Projects billing vs quotes
Ability to link quote and invoice (not billing from the actual quote)
We currently keeping time in Avaza and pulling time through on our invoices in Avaza into Xero. The actual time(our cost) is then shown in the Xero invoice which is changed to the invoice amount. I am trying to get to the ultimate spreadsheet - Quote (budget column) vs Actual cost (time) vs Invoiced amounts (this all has to be shown as the separate line items quoted)In summary:
A report that replicates an excel sheet that we have set up manually at the moment:Column 1
Client…
1 vote -
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. 🙂
-
Reports - New Aged Payables Report V's Previous Report filtering options by due date
Previously in the old format Aged Payable Summary and Detail reports you could run the report at the end of the month and change the Ageing by option to be by Due date and the report would then exclude any invoices with a due date later than the month end it was being run by. However when doing the same in the new format report this does not work and the Current column shows invoices for the month as being due even if they have a due date of later than the month end date being selected i.e. the report…
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.
-
Reports - Merge columns
The ability to merge columns in xero - specifically the General Ledger Summary report to merge the Account name and number.
2 votes -
Reporting - Restrict user access to the Edit Layout button in financial statements
We have spent a significant amount of time creating our financial statement templates using the report codes to ensure consistency and quality. Using Edit Layout can cause significant issues, including notes not matching the numbers in the balance sheet. As a result, we require the ability to remove access to the Edit Layout function for selected users.
This is a significant quality and risk issue.1 vote -
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…
15 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.
-
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")
9 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, 🙂
-
User roles - Reports access with no payroll (including accounts)
We want to give access to reporting to one of our managers however we don't want them to be able to view all payroll information. Therefore I am looking for a function that can give access to all of Xero except anything to do with payroll so all nominal codes to do with wages would need to be invisible etc. Journals would another thing that needs to be hidden.
11 votesThis is really useful to know, thanks Josh - Though we don't have immediate plans for change around this, we really appreciate you sharing the detail of how you'd see this permissions working best for you. We'll keep an eye across this one here, and let you know if there are any updates.
-
Reporting - Save default settings for Aged Receivables Detail
One of the most irritating features when using the Aged Receivables Detail report for Credit Control purposes (downloading to Excel and pasting into an email) is that when selecting the Date Range under Aging periods and the Invoice Date under Aging By, it continuously defaults back to the first option.
Kindly allow the setting of a default to prevent the system from continuously defaulting back to the system setting.
1 vote -
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.
16 votes -
Reports - Coloured text for variances on new reports
Prior to the new reports we were able to select different colours for budget variances on our Xero reports. Green for on budget or better than budget and red for below budget.
This was immensely useful when going through reports in monthly management meetings as it meant over or under performance in any line was easily recognisable.
Please can you bring this simple feature back!
3 votes -
Receivable Invoice Details Report - Add Contact Location
It would be great if possible to run an invoice detail report which reflects customer location.
7 votes -
New Journal Report - View file attachments from source transaction
Currently there is no definitive link between posted documents and the Journal Report. Having the Document reference will simplify examination of the audit trail.
6 votes -
Reports - Do not show unfiled amounts for previous financial years
The change if made in prior quarter should be made either available in amended Activity statement report or should carry forward till that particular financial year. Unfiled amount shouldn't be carried forward for infinite period of time.
2 votes
- Don't see your idea?