95 results found
-
Reporting - Trial balance split by category
"Please provide or enable a template that allows the generation of a Trial Balance report with account groupings categorized under the same headings like Profit and Loss statement and Balance sheet."
6 votesThanks for sharing your idea, and letting us know the changes that matter most for you.
We've reviewed your idea to show the Trial Balance by category and now it's up to the community to get behind and support it.
In the meantime, did you know that you can group the Trial Balance by 'Account Class' or 'Account Type'? Whilst not the exact functionality requested, these options allow you to split the accounts up within the report.
Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Reporting - Include Invoice numbers for payable and receivable payments
Include Invoice numbers for payable payments and receivable payments in reports.
The information is available for payable invoices and receivable invoices but is missing for the payable payments and receivable payments. Reference information is carried through but not invoice number information.
4 votesHi!
Thanks for sharing your idea about the change you'd like to see or this element of reports.
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 votes and comments too!
-
Reports - Trial Balance with OPENING / CLOSING balance and and Movement from GL Summary Report
Team Xero
currently TB report shows ending balances for current year in db/cr two columns AND in single column Clubbed up remaining balances +/- in when COMPANRED to previous periods.I propose/request IT to make TB more classic by
- showing ALL remaining balances in two columns DB/CR when comparing previous years
- OPENING and CLOSING balances columns to be available (year selected from starting of fiscal year Jan20xx)
- TB report to ALLOW us to SELECT RANGE of dates (Range based TB)
- MOVEMENT (total Debits Total Credits) for the selected DATE and/OR RANGE should be available. CURRENTLY this is available in GL…
16 votesHi Yaseen, thank you for this incredibly detailed and well-thought-out suggestion for the Trial Balance report.
We can see how much manual work you're doing, combining exports from the GL Summary Report, just to create a "classic" comparative Trial Balance for your auditors. That's exactly the kind of difficult workflow we want to help improve.
Your proposal to enhance the report with separate debit/credit columns for comparatives, clear opening/closing balances, and a movement column for a selected date range is very clear.
We're grateful for your engagement and for letting us know the changes that matter to you. We've reviewed your idea and now it can gain support from other community members. Along with votes, others can now comment to share additional detail about how these reporting improvements would help them during audits and financial analysis.
-
Reporting - Switch between detail/summary Aged Payables/Receivables report
Instead of having 2 separate reports for Aged Payables and Receivables, there should just be one report for each, and a drop down/toggle to switch between the detailed report and the summary report. Not the biggest deal, but would make things a lot more fluid and easier. Could be replicated across other reports too to simplify the process, and make the "reports" section much tidier and easier to navigate.
3 votesThanks for sharing your idea for a dropdown to switch between the detailed and summary versions of the Aged reports.
We've reviewed your idea and now it's up to the community to get behind and support it. Along with votes, other members can now comment to share additional detail about how your idea could improve their experience with Xero.
In the meantime, did you know that you will find the detail/summary version of the report listed in the Related reports section of the left hand panel when running a report?
-
Giving Statements for Year End
It is crucial to be able to print or email statements to multiple or all contacts with received money transactions at once showing each received money transaction for the contact in a time period on individual/separate pages by contact. This is really needed functionality because any nonprofit entity needs to send giving/donation statements at year end. I have tried multiple reports and statements. I can create an Account Transactions report showing all the clients and the received money entries, but it doesn't allow me to separate contact on their own page. The functionality under Business and sending statements would be…
8 votesHi Justin, thanks for sharing your idea again, I understand the challenge of creating a statement for a contact who only have receive money transactions. We've reviewed your idea agree its something others have asked for, so 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.
-
Reports - Date Range to include Calendar Year to date
Entities often need to view business reports in calendar year, as opposed to Financial year.
Increasingly, revenue, expense and profit performance and targets at management and operational level are considered by calendar year.2 votesHi Ian thanks for sharing your idea here, and letting us know the changes that matter most for you.
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! In the meantime, we recommend typing the date in the box to avoid extra clicks. You may type 1/1/25 or Jan 2025. If you require further help with this, we recommend raising a case with our support team.
-
Profit & Loss - Use Average currency value when reporting in an alternative currency
When presenting the Profit & Loss in a different currency from the file currency the exchange rate is as the last date of the Profit & Loss Statement (P&L). While this is appropriate for the Balance Sheet it is not so for the P&L. I would like to be able to extract a P&L report knowing the figures are based on an average exchange rate for the period as opposed to a single date rate.
5 votesAppreciate you sharing your idea here, Michelle.
In the way Xero works at present the exchange rate is based on the end date of a report or the set exchange rate that was used.
It's now up to the community to get behind and support your idea here. Make sure you share this with any colleagues that this could benefit so they can add their vote too!
-
Reports - Option for All time / All dates to view all transactions
We need to be able to select "All Dates" on a report. ex. I want to see a report for a certain account from the start of my business to the current date. now I need to select beginning date and then todays date and the update.
13 votesThanks for sharing this great idea for improving efficiency in reports.
For anyone looking to achieve this now, you can view transactions across all time by selecting a custom date range in your reports. By setting the start date to your organisation's first transaction date and the end date to today, you can get a full historical view of your data.
We see the value in your suggestion to add a preset 'All Time' or 'All Dates' option, which would make this process a faster, one-click action.
To align with our new statuses for Xero Product ideas, we've updated the status of this idea here. We encourage everyone who would find this feature useful to keep voting and sharing comments. Learning more about the specific reports you'd use this for and how it would help your business helps our product team understand the potential impact.
-
Transition period for non UK organisations - managed financial year end
Can the transition period for change in financial year date be added to companies that are non UK organisations as well. we have a group of companies that all extended their financial year but i have only been able to use the transition period in UK organisations. Why is this not an option in non UK organisations?
3 votesHi Claire, thanks for raising this. We appreciate you sharing the want of having the transition period feature across all the regions while it is only currently available for UK organisations. Your idea is now in Gaining support status, meaning our community team have reviewed it and it's open for community support through votes and comments. We encourage others who would benefit from this to add their votes and share their use cases to help us understand the broader need.
-
Short-term cash flow - Automatically include loan payments or bank transfers
It would be helpful if loan payments and bank account transfers were added automatically.
Adding these manually is time-consuming.
3 votesThanks for sharing your idea, and letting us know the changes that matter most for you. We've moved this idea to Gaining support so other users who want this feature can also add their vote to it. We'll keep an eye on this for more traction.
-
Payroll AU - Add running totals to Transaction Listing Details Report
Can a total be added under the amount on this report.
If a total was available, I wouldn't need to export to excel simply to add a total before sharing the report.Ideally, the total would also apply to groups on the report, ie, total by employee and total for all employees.
1 voteThanks for letting us know you'd like the Transaction Listing Details Report to have a total per Employee and or Group when you filter the report by Group.
As you've found, the report will only show itemised values. One work around would be to export the report to Excel or Google sheets and add a summary total manually. We'd also suggest taking a look at the Transaction Listing Summary Report.
We've reviewed your idea and it's now open to the community to get behind and support your idea. 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.
-
Profit & Loss - Ability to show percentages with Tracking Categories
On the Profit and Loss report there is no ability to show percentages, if tracking categories are used as a filter. We want to see COGS as a percentage of trading income, and Net Profit as a percentage of trading income.
8 votesHi Karen, thanks for submitting this idea. Showing percentages in the Profit & Loss report when using Tracking Categories would make it easier to see how different projects, departments, or locations are performing at a glance.
This feature would give you clearer insights and save time by reducing the need to export data and crunch numbers in spreadsheets.
This idea is now in the Gaining Support stage. If this would help your reporting, please add your vote or share your thoughts, it really helps the product team understand the impact.
We’ll keep this thread updated with any news.
-
Reports - Add Tracking Category Column/Breakdown to Trial Balance
Trial balance with a column for Tracking Category. Currently I need to download each TB individually if I want it by tracking category, which is very time consuming and inefficient.
2 votesThanks for sharing your idea, and letting us know the changes that matter most for you.
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.
-
Reporting - Make the Edit Report layout more seamless
Is there a plan in place to update the Edit Report layout to be more user friendly!
In particular, it is clunky inserting tables and being able to edit like a simple word doc (bold, italic, line spacing etc.)
Also being able to print off the reports in the 'edit' mode so you can see the expanded breakdown of the accordian would be very helpful to ensure that Notes match Statements of Financial Performance and Position (especially useful for our juniors who often can't work out where their subcodes are if there have been reporting changes)2 votesThanks for sharing your idea, and letting us know the changes that matter most for you.
We've reviewed your idea and split it to ensure the community can get behind and support both. You can view the other idea here. Along with votes, others can now comment to share additional detail about how your idea could improve their experience with Xero.
-
Reporting - Manual Journal Report
Report that extracts manual journal entries (only) with user details - for audit purpose.
2 votesThanks for sharing this idea. We've reviewed this and now other users can add their votes and comments to support it.
For now, there's a way you can get a report on the manual journals, but without listing the user details.
To do this:
1) Run the Account Transactions Report for the relevant date range.
2) Click the Accounts dropdown and click Select All.
3) Use the Filter option to select Source = Manual Journal.
4) Click Update to generate the report.
Although this report won't list the users, you can click into journals to view their details, the History & Notes will show who entered it.
-
Reports - Add reports for eInvoices
Hi Xero Support,
We've been generating individual e-invoice from Xero/Invoici for months, however, we could not find any report on e-invoice generated through Xero/Invoici.
This report could help us in ensuring accuracy of the data exported to MyInvois portal. We would require a specific report on the generated individual e-invoices to make sure that they tally with the sales invoices report from Xero.
Thanks!
8 votesThanks for sharing this valuable feedback about your experience with e-invoicing.
We've reviewed your idea for a dedicated report on generated e-invoices. We understand how this would be crucial for ensuring the accuracy of data you export to the MyInvois portal and for tallying with your Xero sales reports.
Your suggestion is now open to gain support from the wider community. Along with votes, others can now comment to share how an e-invoicing report could improve their own reconciliation and data validation processes. 🙂
-
UK Payroll - Matrix format for pay run reports
Provide reports (for both draft pay runs and posted pay runs) in a matrix format like other Xero reports, rather than listed under each employee. The current format makes it impossible to carry out checks or to create further reports for management.
Given the latest update that improving payroll reports is not a priority for Xero, we are very close to leaving Xero and moving to another payroll provider for the next financial year, as all other softwares we have used during our careers have provided far more useful reporting than what Xero offers.
Xero's financial accounting reports are great…
2 votesThanks for sharing your idea, and letting us know the changes that matter most for you.
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.
-
Income by Contact report - Extend chart
Would be great to run this report but be able to show Top 20 or 30 clients rather than just Top 10.
1 voteHi Brenda, just to confirm is it within the graph that you're wanting to increase the # of top customers?
Currently, if you run the Income by Contact report with Chart & table the chart will only show the top 10 but the table will give you an ordered list for all contacts that you received income from in the period.
-
Profit & Loss - Change heading default to 'Net Profit / (Loss)'
I WOULD LIKE TO RECOMMEND A PRODUCT UPDATE ON THE PROFIT & LOSS REPORT.
THE REPORTS 'Net Profit' ON ALL REPORTS, EVEN IF SOME PERIODS HAVE A LOSS. CAN IT INCLUDE 'Net Profit/(Loss)' AS PEOPLE, ESPECIALLY THOSE NOT IN THE ACCOUNTING FIELD TO KNOW THAT BRACKETS MEANS A LOSS, MAY INTERPRET (LOSS) AS A PROFIT
2 votesHi Ntando, it'll be good to gauge interest from others in the community that'd like this terminology to be used as a default on the Profit & Loss report.
Want to be open this isn't anything we have any plans for atm with the customisation that's available.
As you may already be across, currently you can edit the heading of the row through the Edit layout, and then Save as Custom where you have the option to make the report the default for the organisation.
-
Bank Reconciliation - Show Separate Debit and Credit columns
Bank Reconciliation - With Separate Debit and Credit columns with their totals
Currently both DR and CR amounts show in one column. Would love to see them in their own columns when reporting.Also, a larger description/reference area would be great.
1 voteHi Sousana, thanks for sharing your idea, and letting us know the changes that matter most for you.
We've reviewed your idea and now it's up to the community to get behind and support it. You may share it with your friends and colleagues who may also find this to be a useful addition to Xero. They will be able to add their votes and comments on it too.
- Don't see your idea?