375 results found
-
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 -
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.
9 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 -
Reports | VAT201 - Add Google Sheet format for download
Please INCLUDE GOOGLE SHEETS for ALL downloadable reports in Xero. Some reports are downloadable only in Excel. SUPER FRUSTRATING!!!!!!
1 voteHi Johann, so I can get your request in front of the right team, I just need to check which reports you're specifically referring to. Would one of them be the VAT 201?
-
Tracking Categories Report - Ability to print/download tracking categories
Tracking Categories Report - Please add the ability to print/download the tracking categories
46 votesHi team, to export a list of all Tracking categories in your org, you may find the Tracking Summary report of use to you here. Alternatively, you could run the Account Transactions report and Summarise by the Tracking category.
The one caveat here for both reports is that they'll only show a list of the tracking options that have been used within the date range the report is run.
-
Xero Project reports - Click into transaction from report
Xero Project feature idea
- drill down transaction from Xero Project reporting
- Report template Xero Project layout can not be saved to custom report template
- assign project to Payroll
- Inactive jobs, still showing in the list although its in the different section, in my opinion the inactive project should not show up at all, should make the same like employee list where there is a dongle to show inactive Projects.
16 votesAppreciate you have a few ideas for Projects here. We try to keep 1 idea per thread so others understand what they are voting for and we can clearly share the information back with our Product teams.
I've changed the title of your idea here to reflect your first idea and welcome you to create new ones for the other ideas that you've suggested.
-
Reports - Sort archived published reports by end date
Please provide better organization tools to published reports archive such as being able to sort published reports by report end date (cut-off date)!
Sometimes we have to go back and reperform a client's bank reconciliation because they don't always know what they are doing, or new transactions cleared in the subsequent period affect previously published report. It doesn't take long to see the published reports archive get disorganized and hard to find a published report.
1 vote -
Reports - Restrict access to custom reports created in the incorrect tab
If you create a report in the custom tab rather than the adviser tab in error, it would be good to be able to either lock it so it has as restricted access to that custom report almost as though it's password protected (ie only the creator can see for example) or have the facility for it to be moved to the adviser tab to allow it to have restricted access to advisers only.
3 votes -
Reports - Voided and Deleted Invoices deselected by default
I deleted and voided invoices for a reason. I don't want to see them again, yet they show up by default on a number of reports. This is in addition to making the invoice number unusable when invoices are voided. None of this makes sense to me and I shouldn't need to make a custom version of every report that seems to included voided/deleted data by default.
5 votes -
Reporting - Include Branding Theme on invoice reports
I would like the field 'Branding Theme' added to invoice report as a column that can be selected.
Any invoice report - aged debtors by detail would be great. I need to be able to analyse outstanding invoices by this field and cannot.12 votes -
Reporting - Add an Account column to the Contact Transaction detail report
It would be GREAT (ok essential) to have the "Related account" column available here.
A list of transactions by contact at it is, with date,VAT and total amount is ok but a CRUCIAL column is missing.
"Related account" column is crucial/ essenital/ a mist because we often need to check consistency of posting to the correct account, which we cannot do right now.
3 votes -
Reports - WIP report with one value per group
Simple WIP report - 1 value per group (not broken down by job or individual client). Just a quick snap shot.
Easy!
2 votes -
Reporting - Link Account Transaction Report to Total Lines on Balance Sheet and P&L
Add the ability to open an account transaction report by clicking on the number in a total line of the balance sheet or P&L. The linked account transaction report would contain the account transactions for all accounts that were being totaled.
1 vote -
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 -
Reporting - Running scenario analysis with draft transactions
Dave Andrews asked a question.
Edited Tuesday, 15 August 2023 12:36 PMCan one create a report based on DRAFT information eg Draft invoice not approved
Can one create a report based on DRAFT information eg Draft invoice or draft bill (not approved and therefore not posted into the books of account).For example I would like to see what impact certain entries would have on a balance sheet or income statement but dont want to approve them only to see the impact and then subsequently void or reverse them if I am, say unhappy with the outcome ? I…
2 votes
- Don't see your idea?