568 results found
-
Reporting - Saved customised report layout across common formats
Been trailing the new reports format and when setting up a custom group account layout for a Profit and Loss report we can't use this layout across Common Formats of Profit and Loss. This feature was available in the old reports that once a custom layout was created it worked on all formats. Been advised that would need to create a separate custom report for every Common Format
33 votes -
Trial Balance report: More than 36 months historical comparison
Could we please have the functionality of running TB reports with more than 36 months historic comparative months, thanks
4 votesHI community, thanks for your support here. While this isn't something we have plans for extending comparatives beyond 36 periods atm, it'd be good to get more detail on the ideal # of comparatives you'd be looking to run the report for, and what this would help your business do - Please do comment to share your views.
Other options you'll see you have with the new report, is that you can change the comparative period between Day, Month, Quarter or Year.
-
Report Templates - Allow "Current date" to be inserted in reports at the client level.
There is no options to insert automatic date formatting into the reports at the client level. When the "current date" insert field doesn't work you have to manually enter the date all the time. It would be easier to be able to insert "current date" field.
16 votesHeya team! We know it's been a while since this idea was initially started but we really appreciate your feedback on how dynamic dates for report templates would be useful.
Our reporting product team are currently doing some discovery that could possibly solve for the needs here and we'd love to get your input to help validate their research.
If you'd be keen to be involved please book a time with our team through the 👉 link here.
We really appreciate your engagement, and I'll be sure to share outcomes in our next update.
-
Reporting: New P&L Report - Include archived Tracking Category used in date range
"Compare Tracking Category" in the Old Format P&L Report includes columns for all Tracking Category Values USED in the date range; irrespective of whether the value is ACTIVE or ARCHIVED.
"Compare Tracking Category" in the New Format P&L Report is different: it includes columns for ACTIVE Tracking Category Values. This represents an incomplete view because ARCHIVED Tracking Category Values USED in the date range are not included.
Please can you enable reporting of USED Tracking Category Values in the New Format P&L Report before you remove Old Format Reports in July 2023.
Custom reports don't provide a viable solution due…
7 votes -
New Account Summary Report - Search by Account Code
The new Account Summary Report needs the Account Code in the drop down list. Currently it only has the names of the accounts. There is no option to show or hide the Account Code. Sometimes I work with the account codes and not names. I need the ability to type the code in as well.
8 votes -
Reporting - Option to default include GST in Debtors & Creditors reports
Can you add a option in the standard reports to include GST in debtor & creditors without having to create a custom report
2 votesThanks for sharing, Paul.
Appreciate it's a few steps to set up and add the columns, however once formatted as you like, if you save as Custom you can then set this as the default so it's a onetime effort.
Understand this may be more cumbersome if working with many organisations. Being open this isn't something we have plans for currently. We'll watch the interest in this, here.
-
Reporting - Filter Inventory reports by Tracking
Please add ability to filter inventory reports by tracking codes, so you can see quality purchased and sold by tracking code.
35 votesHi team, while not available in the Inventory reports directly you could run the Receivable or Payable Invoice Detail reports where you'll find your can group and filter by Item and Tracking which should help you get a picture of quantities purchased and sold by category 🙂
-
Profit & Loss report - Filter by project
Project reports are very difficult to follow and understand. The ability to click a transaction and open the source is not possible unlike all standard Xero reports. A Profit and Loss by project is crucial. Project transactions need to be combined into the audit trail so that standard reports can be ran to include project information.
90 votesReally appreciate those who’ve taken the time to share how this’d help in your day-to-day. We know being able to filter a Profit & Loss report by project would make it easier to understand how your jobs are performing.
Right now, the best workaround is to export your data and make adjustments for this in Excel, but we get that it adds extra steps.
There’s also the Profitability dashboard feature in Xero Projects, which gives a quick view of how each job is tracking, and may be helpful.
We’ll keep an active eye on the interest this idea continues to build through votes, but do want to be transparent that this is not in our roadmap for the foreseeable future. Thanks again for your input through Xero product ideas.
-
Profit & Loss Reports - Change variance column for costs
The variance columns in the current P&L reports don't make sense - increased costs show as positive variances, despite the red arrow. The formula is fine for revenue and profit, but needs to be the other way round for costs. Is it possible to have this, or to add a column with different formulae for different sections?
10 votesHi team, to confirm how the Budget Variance report works currently it'll show;
- Green arrows for favourable amounts
- Red arrows for unfavourable amounts
- Increases in the amount from budget will have an upward arrow
- Decreases in amounts from budget will have a downward arrow
We appreciate your feedback here however being open, there are no plans to change the way this logic is applied in the report, or to extend the arrow colouring across the figures/amounts in the report.
-
Reporting - Ability to Bulk Archive Published Reports
It would be useful if we were able to select published reports in bulk to archive them, rather than having to do them one at a time.
8 votes -
Reporting - Create folders to manage reports (Custom, Published and Archived)
Under Custom Reports
I send out reports to my departments each month, this morning it took 4 hours to add the tracking codes to the new P & L reports (we love the new report and so do our Department Heads).
I was wondering if there is a way of saving each custom report for each individual dept with their tracking within a folder. We have a Junior and Senior Campus and about 45 departments at each. We already have a lot of custom reports so having a folder system would allow each Admin staff member to access what they…40 votesThanks for the example, Shellee! That's a good few departments 😮
There's no facility to create folders in the Reports Centre for this sort of categorisation atm.
We'll begin tracking support in this here.
-
Reporting - Switch layout between left-right and right-left
When you download a P&L / BS report (whether old or new templates), and include comparative periods, there should be an option to choose left to right, or right to left. If i have downloading for Jul-22, with 12 months of comparatives, i want the oldest month to be on the left, and Jul-22 to be all the way to the right. That is typically how all excel financial models are built, and the basis of these models is historical financials.
19 votes -
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.
53 votes -
Fixed Assets - Negative fixed asset
Fixed Assets - ability to have a negative fixed asset for when an asset has devalued and the revaluation is therefore negative.
19 votes -
Report Templates | Copy - Client to practice, or client to client
There are a number of Report Templates available in the Client Reports which once adapted would be good to copy either from one client to another or better still from a Client to the Practice Reports, making them available for all clients and they could then be included in Monthly Management Reports.
Currently you can only copy reports within a client or within the Practice Reports and the facility is not available to copy across from one to another
66 votesBack with an update for, everyone 😊We have now enabled the ability to add client-specific custom reports to Adviser packs!
As mentioned in my last update we don't have direct plans for enabling the ability to copy reports from client to client or client to practice report templates.
While this update doesn't completely accomplish what's been directly asked in this idea, we know this is a key feature that'll be highly beneficial to some in this idea in creating more comprehensive reports. Thanks for sharing with us all, here.
-
Report Pack - Add Uncoded statement lines report
To add 'uncoded statement lines' to the new report packs in Xero.
10 votes -
Management reports - Ability to include VAT return reports
The new custom report pack looks great but it would be good to be able to export the VAT return within the same pack. Can the VAT reports be added to this functionality? I think it would be helpful for many people.
I regularly look at a profit and loss, balance sheet, aged receivables detail, aged payables detail and the VAT return reports monthly for all clients and it would be great to export these together, and would save a lot of time.
9 votes -
CIS - Breakdown on CIS Suffered Report
It would be a massive help if you could click on the figures on the CIS suffered report to see which customer invoices make up the report figures. Clients often ask me which invoices are included and I have to manually work out where the figures come from
23 votesHi all, wanted to share a workaround here for those who aren't already aware.
You can run the Account Transactions report on a cash basis and if you filter it by the CIS Labour Income or CIS Asset account, you can see the invoices which have been included in the CIS Suffered report.
We don’t have any plans in the near term to expand functionality on the CIS Suffered report. If anything changes in this space, we’ll update you on this idea!
-
Fixed Assets - Change behaviour to recognise new asset when account type updated on existing transaction
An Information message to advise implications of editing the "Account Type" when posting a bill for a Fixed Asset.
"If an approved bill or spend money transaction is edited, and the account code is changed to one with a Fixed Asset account type - a draft asset won't be created". ie- it does not automatically update the transaction to include the item on the fixed asset schedule. Unless the item is manually added to the fixed asset register, it will not be included in subsequent depreciation runs.Ideally the system should be designed to fully complete the edit or should…
13 votes -
Bank Reconciliation Report - Show 'Discuss' tab notes
Include notes that have been left on transactions in the 'Discuss' tab on the Bank Reconciliation Summary Report.
35 votesThanks for the ongoing support in this idea, team. I want to be upfront that we don't currently have any plans for adding Discuss to reports however we'd like to keep tracking the support of this with community here, and will share if there are any changes to update you of.
- Don't see your idea?