899 results found
-
Reporting: Excel Export - Adjust default row height on exported reports
When exporting reports to Excel they are coming in with very narrow row heights. By Default Excel will create a row height 4 points larger than the font. Eg: default font is 11 points and row height is 15 points. If I increase the point size, the row height increases.
My exported reports have the general data at 9 points but the row height is at 11 points - and I'm constantly having to modify my spreadsheets.
It appears that Xero believes that a 2 point difference between font size and row height gives enough white space to make the…
3 votesHi Karen, we wanted to share a quick update regarding the idea to adjust the default row height on exported Excel reports.
This idea is now classified as Gaining Support, and we’re continuing to monitor it as part of our ongoing efforts to improve reporting features.
To the community, if this improvement would benefit your workflow, please feel free to vote and share your thoughts.
Thank you for contributing your ideas!
-
VAT - Summary Report by box number
VAT summery report by catagory/box like the one in Sage which is a big help when you have resticted VAT on leasing, roundings, Import vat, VAT on legaland insurance claims etc so you can calculate what the full VAT is and agree the difference quickly without having to go through every single transaction
3 votesThanks for sharing your idea of a VAT summary report and including an example of how this could look. We appreciate you sharing how this could help with VAT reconciliation when handling different VAT treatments.
We've reviewed your idea and now it's up to the community to get behind and support it. Make sure you share your idea with any colleagues that this could benefit so they can add their vote too!
Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Account transactions report - Option to Group by year
In the Account Transactions report, the Grouping / Summarising box should allow you to group/summarise by Financial Year.
For example so you can look at multiple years in a row, but you still get subheadings/ breaks for each financial year. This would be really helpful when looking at recurring expenses like finance / insurance payments.
Thanks
3 votesThanks for your engagement and sharing your idea here, Phil.
We've reviewed your idea and will now watch as it gains support from other community members.
Along with votes, others can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Fixed Assets - Add tax depreciation for UK
Fixed Assets - Add tax depreciation for UK
At the moment, only the Australian version of Xero offers a tax depreciation function. We need this feature in the UK version too if Xero Tax is to be considered as a serious Tax software.3 votesWe appreciate your feedback on how we could help you get more out of using Fixed Assets in the UK version of Xero.
Though we don't have any immediate plans for this we'll keep watching the support for this grow here, and update of there are any changes planned. Thanks
-
Fixed Assets - Add location
Fixed assets - please add a field for location
3 votesHi Maresa, when you say you'd like to add Location would this be based on a Tracking category you've set up in the organisation? If so, you could add this when you create the original transaction(bill) the asset is raised from.
-
Reporting | Add multiple FY'S as common date selections
Report dates
On financial reports. Instead of last financial year of this financial year wouldn’t it be better to have the years as the selection ie 2024/25 2023/24 2022/23. it will be much quicker to select the year especially is going back further than the current year.3 votesThanks for sharing here, Kerri. Understand why you'd find this helpful and we'll start to get a sense from others that'd like to see this here, too.
I know it's a little different to what you're directly asking here, but perhaps comparison columns and saving as custom could help where you can run the report for multiple date ranges at once and view the comparison across each?
-
Reporting - Print pdf shortcut
To be able to have a short cut to be able to print pdf straight from report screen without having to click multiple times to get there
3 votesThanks for your feedback, Sadie. We don't have any direct plans for a PDF / Print shortcut atm but we'll feel out the interest from your idea here and let you know if there's any progress.
-
Reports - Add planned payment date direct from reports
It would be really helpful if there was the option to add a planned payment date for all invoices listed on a particular aged creditors report. Having customised reports so that only invoices on particular job sites are listed, it then seems very inefficient to have to access 'bills to be paid' and manually, individually search each of the invoices listed on the report to schedule a payment date for them. Could this not be a function, whereby you can schedule them all for payment directly from the aged creditors report?
3 votes -
UK VAT - View multiple unsubmitted VAT returns
We should be able to prepare and view future VAT returns where there are multiple unsubmitted returns. Ie. able to prepare multiple VAT returns for client approval at once. Currently, they have to be prepared and submitted before the next quarter's return is visible.
3 votesHi, grateful for your engagement here community.
Just a quick update that this idea is open for voting and comments from the wider community - please share your thoughts on how this would help you. We'll keep an eye on the support for this idea here.
In the mean time, you may wish to use the “Looking to see VAT transactions for your own date range” option to run off reports for each return period, and then calculate the VAT from this report.
-
MTD VAT - Show MTD VAT reports after downgrade to Ledger plan
Historical MTD VAT reports can't be seen after subscription downgrade!
We have just realised that we have lost access to a client's MTD VAT reports after their Xero subscription was downgraded to ledger after de-registering for VAT and becoming dormant. We can see all their pre 2019 VAT reports under "Filed with HMRC" or "Published" but there is nowhere to view the subsequent MTD returns and the detail behind them. Not great when you are preparing a final set of accounts prior to dormancy.
These reports may well be needed in future in the case of a VAT inspection or…
3 votesWe’re moving this idea to Gaining Support so we can better understand how many customers and accounting practices would benefit. If this would help you, please vote for the idea and add a comment describing your use case—especially whether you need the filed return summary, transaction detail, or exportable reports.
⭐ The more support and examples we receive, the better we can assess this with our product teams.
-
Reports - Change the position of group totals in custom layouts
At present we are able to edit the layout of reports by rearranging, creating formulas, and grouping accounts. It would be INCREDIBLE to be able to customize the following.
1) Group font (size and boldness only)- right now it defaults to a much larger BOLD font than the underlying accounts. It would be nice to choose these sizes and weights
2) Customize the Group Total's Location - at present it shows only as an additional labeled row with the corresponding total. It would be a neater presentation to just have the group total show right in line with its main…
3 votesHi Michael we're grateful for your engagement here, however we ask that each post is contained to a single idea for a feature.
We've identified that there are existing Xero Product Ideas relating to customising fonts and styles in reporting, and collapsing and expanding account groups. We've gone ahead and added your vote to these ideas, so that we can gather support and gauge interest for these ideas separately.
We've also adjusted the title of this idea to reflect your suggestion to change the position of group totals in custom layouts. This idea can now gather support through votes and comments from others in the community.
-
Business Activity Statement | GST Audit report - Add transactions source field
I would like the GST AUDIT REPORT to be permanently updated, so that the transaction SOURCE FIELD would be included in the report. Otherwise the report should be customisable to include this and many other fields / options, so any of us professionals and internal accountants can extract what we need to review client / business BAS data easier, and lodge the BAS's quicker. There are MANY ideas for the GST AUDIT report to be customisable and several are also relevant to me and my needs, but I couldn't find a request for this one and it is such an…
3 votes -
Custom Reports - Include Balance sheet accounts to report movements
Hey - when making a custom report it would be really useful to be able to show the movement in balance sheet codes. For example, when preparing our month end summary we can't bring in the capitalised wages cost automatically because it brings in the cumulative balance, rather than the balance for the period. To be honest it's crazy to me that this doesn't exist, but would be great if it could!
3 votesThanks for submitting your idea on Xero Product Idea's, Ryan. We appreciate you taking your time to share changes that would be most meaningful to you.
Being open, we don't have any current plans for changing the Custom report behaviour but we'll continue to track the interest through your idea here and will update if there is any changes to share.
-
Fixed Assets: Auto Calculate the Depreciation Rate from the Effective Life
At the moment Xero doesn't auto calculate the depreciation rate from the effective life. This means when we run the depreciation report the rate column shows up as blank if we've entered the effective life into the asset register rather than the rate. We should be able to enter the effective life and Xero auto calculates the depreciation rate for the depreciation report.
3 votesThanks for sharing your needs for Fixed Assets, here. While we appreciate it could be confusing to see a blank percentage in the rate column, we want to upfront that this isn't something we have plans of implementing in the near term.
As you may already be across if this is something you do need to track, the best option right now would be to export the Depreciation Schedule report and make adjustments as required outside of Xero in Excel or Google sheets. I know this isn't the ideal solution and if any change is planned we'll let you know here.
-
Bank feed to account transactions match report
It would be good to have a bank feed to account transactions matching report which could show which bank feed entries have been reconciled to which account transactions without having to click into each entry. Something like the attached would be good to enable someone to spot mismatched bank entries
3 votesHi David, it's possible to run the Account Transactions report showing a 'Related account' column to see where transactions have been reconciled to. Would this suit what you're asking here?
-
Reporting - Flag when actual Retained Earnings doesn't match to the report value
A flag which shows when the profit & loss figure plus brought forward retained earnings does not add up to the retained earnings on the reports. This is usually due to a mapping issue where a figure is causing a transposition error. It only seems to flag if you opt to include a statement of changes to equity. Seems like there should be a more obvious flag for this issue to ensure it is not missed.
Also perhaps a reconciliation between the profit & loss figure in the company accounts versus the Xero business, appreciate this is likely to be…3 votes -
Reporting - Include Draft invoices and Purchase Orders in the Sales by Item report
It would be great to have an option to run a sales report by item which includes draft invoices, delivery dockets, and purchase orders as well.
For example, I tried to run a sales report on qty of each product sold for the financial year to date and realised this information was inaccurate as we had sold a significant qty as draft invoices (using draft invoicing in lieu of delivery docket functionality), these products were not included in the sales report.
3 votes -
Report templates - Add Project reports
Ability to add project financials rerporting into an advisor template report
Being able to build a management report template that includes project financials seems like a no-brainer. but you can't do it at template level. You have to start with the existing template for a managmeent report and build a report from scratch for each client.
You can't even take an existing template and add in a project report.3 votes -
NZ GST Return- Ability to only show a single line per invoice on the Transactions report
When running the GST Transactions Report, each and every line from each invoice is reported separately, creating a ridiculously large report.
Perhaps there could be one single line per invoice, reporting the total GST for that invoice? Like it used to be?Thanks
3 votes -
Account transactions - Common date for 'last week'
An option to set the date range to "last week" from the date range pull down options in account transactions reports.
Being able to create custom account transactions reports set to "last week" would be invaluable for our weekly reporting, avoiding fiddly changes to the date range each week when pulling a number of reports, and preventing any dating errors.
It would be a great advantage.
Should be an easy to add that option to Xero, I would have thought.
And it is a common option (e.g. GoCardless has it.)
3 votes
- Don't see your idea?