934 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…
2 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!
-
Reports - Option to specify which months to include when generating YTD monthly reports
Ability to run YTD reports where there is monthly columns totalling to the YTD column which automatically adds additional months as needed.
2 votesHi Bethany, thanks for sharing this suggestion for improving our reports.
We've reviewed your idea for an option to have Year-to-Date reports automatically generate columns for each month, which then total to the YTD figure. We can see how this dynamic layout would make monthly analysis much clearer and save time on report setup.
Your suggestion is now ready to gain support from other community members. Along with votes, others can now comment to share how a report that automatically adds monthly columns as the year progresses would improve their own financial analysis.
-
Sales Tax Report (US) - Recognize California's TY 6/30-7/1
Xero's Sales Tax Report doesn't recognize the great state of California's tax year: 7/1-6/30. Xero pull-downs only offer calendar-year options (1/1-12/31). So, we couldn't set up Sales Tax Report for largest state in the US. Please fix this. We can do it ad infinitum manually, but it seems that Xero could fix the problem. (Avalara could inform Xero if other US states also vary from a simple calendar Tax Year reporting.)
2 votesAppreciate you sharing your idea and why you'd find an automated date setting for California on the Sales Tax report helpful, Cheryl.
Make sure you share your idea with any colleagues that this could benefit so they can add their vote too!
We'll keep an eye on the traction this gets in the community, here. Thanks
-
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
2 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.
-
Management Reports - Allow flexible average comparison periods
Currently, when generating management reports in Xero, users have the ability to compare data across prior months and multiple periods. Some reports, like the Cash Summary, also include an “Average” option, which is a helpful feature for identifying trends.
It would be highly beneficial to extend this “Average” functionality to all relevant reports—particularly the Profit & Loss report—to provide more consistent and insightful analysis.
Additionally, the current average is calculated based on the financial year to date. This approach becomes less useful at the start of a new financial year when only limited data is available. To improve this, it…
2 votesThanks for sharing your idea with us! We've reviewed it, and now it's in the hands of the community. 😁
To get your idea supported, please share it with colleagues who could also benefit. They can add their votes and comments, which helps us understand how this change would 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.2 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
-
Account Transactions Report - Group/summarise by Related account
Reporting - Account Transactions Report - Add Related Account to the options for Grouping/Summarising
2 votes -
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…
2 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.
-
Tracking Summary report - Add currency column
For the line items in the Tracking Summary, please include a currency column! Historically this was available. Calculating commission now takes WAY longer. Seems like it should be an easy fix.
2 votes -
Cash Summary Report - Include Primary Person
Cash Summary Report to include Primary Person Please.
Can you get a cash summary report to provide in order 3 items as per below
Invoice No ... Contact ...Primary person
I cant seem to find a report for all three .
We send 170 invoices out client who pay sometimes do not include invoice number and we have to track by firm name or contact which can vary also on bank receipt information.
e.g.
I need "Primary person" to help "match" an unidentied payment. so searching for "primary person" identifies the invoice number or the right contact.2 votes -
Balance Sheet - Bank Account assignment with tracking categories
When using Tracking Categories on the balance sheet, we should be able to assign specific bank accounts to specific columns (or tracking categories). it would just be a feature where the balance "as of date" just displays in the column, regardless of all the prior transactions.
Additionally, when paying loans, if a tracking category is assigned for balance sheet tracking purposes using columns, the Bank Balance that is transferred to the note becomes a Liability on the balance sheet. This is crazy. You're essentially reducing the Note liability balance & then increasing it by the same amount as a negative…
2 votesIt does sound like you've set up the Balance sheet in a bit of a niche way to track what you're after here, Sal. Appreciate you wanting more flexibility on how you filter tracking and being able to add a secondary filter for bank account.
I want to be open that this isn't something that we have plans for. We'll continue to track interest from your idea here, but would need to see quite a bit of community support to look at making a change for this in the report.
-
Reporting - Remove Unrealised Currency Gains opening balance from Gains and Losses report
Foreign Currency Gains and Losses - remove opening balance from P&L account 498
Revaluation of the open positions is calculated from invoice/bill issued date to the report date and it is correct. Not sure where from opening balance are coming and are impacting the P&L balances.2 votes -
Reporting - Add Project features in Payable Invoice Detail report, or Filter option to show Bills or Expenses status
Can we have one more column or filter option containing Bills/ Expenses status like Paid, Awaiting payment, Awaiting approval and Draft to generate every details on project bills/ expenses record in "Project Details Report" or Project features in "Payable Invoice Detail" report.
2 votes -
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
2 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?
-
Report - Add/remove highlighting from main drafts report page
We used to have the option to add/remove highlighting in a text box directly from the main page of draft reports, however this feature was removed and now we can only Bold/Italics/Underline/Bullet point, but no highlight.
It would be great if we could add this function back in, so we didn't have to go to 'Edit Layout' to change add/remove highlighting anymore.
2 votes -
Aged Payables Report - Group by Planned Date
Allow the Aged Payables Report to be grouped by the Planned Date.
2 votesHi Alison, while there's no direct option to group by Planned date in the Aged Payables Detail report atm, if you change Group to None, once run you can click the Planned Date column header within the report to re-order by this field and it'll group all payable invoices by Planned Date.
-
CIS - Resubmission Reminder/notification
At the moment Xero allows you to change a CIS invoice etc that effects the CIS return that you have already submitted. It doesn't tell you that it would need to be resubmitted or that your action will effect your CIS report. Would it be possible for Xero to alert you that your action will effect the CIS report already submitted and advise you to resubmit it.
2 votes -
Reporting - Monthly and Annually Recurring Payments to Suppliers
Please explore the possibility of generating a report that efficiently and clearly captures Recurring Payments made to any contact or supplier with either monthly or yearly frequency?
Currently, this is not achievable without significant manual effort to extract data from various reports in Xero. While I’m aware that the "Repeating Bill Payment" feature setup can also aid with producing a report of this nature, most clients do not use this setup, and the information isn't sufficient.
Payments have been processed in Xero through various methods, including bills, direct debits, and spend money transactions. The desired report should be able to…
2 votes -
Reporting - Show Invoice Approved Date in the Current Nominal transactions Report for Turnover reconciliation
Turnover per XERO and VAT declared Net Sales should be ideally Equal ,however often may not match and therefore need reconciling-which is important to understand the difference from both the YE accounts and HMRC point of view .
There should be a report in XERO which can facilitate this reconciliation rather than use spreadsheets -which is time consuming when the information is already existing in XERO
One of difference arising is -"The Date" invoice created and approved -are different and will report in different periods of the VAT return and Xero Sales Nominal Account
Example -Invoice created and left as…
2 votes -
Reporting - Analytics tools for foreign currency exposure
I would like for Xero to provide more detailed analytics about the exposure my business has to foreign currency, with existing foreign currency bank accounts, bills and invoices, but also based on averages regarding how much I am spending and receiving in each currency projecting that out into the future perhaps over the next quarter.
2 votes
- Don't see your idea?