- or
1342 results found
-
Trial Balance - Ability to see current month figure along with YTD
The ability to see current month figures together with year to date on a trial balance report. This was possible on the old version of the trial balance but not on the new version.
68 votesThanks for adding input and sharing how this idea could help with your business.
Taking on board feedback, and considering some of the changes we've made across reporting recently we wanted to highlight the General Ledger Summary report that can be set up to meet your needs here. 🙂
You can set up the new General Ledger Summary report to run for a 'Month' date range, and select to include Opening and Closing balances.
With this run, Debit and Credit columns will only show the movement within the period, while the closing balance will be the YTD figure for the account (showing as positive or negative).
If you find this handy, you can save it as a Custom report rather than having to set up the layout each time you'd like to run the report.
-
NZ Payroll - Employee search filter in the Leave Transaction Report
would be great to be able to filter current employees when looking at Leave Transaction Report. We have many hundred old employees and have to scroll through all of them to get the individual employee.. also no search function to be able to find the employee easily
2 votesHeya team, thanks for sharing back on how we could improve Xero for you.
As part of our upgrading Payroll reports with the new version of the Leave Transactions report for both Australian and New Zealand versions of Xero, you can now Search by Employee. So, you'll be able to quickly jump to an employee of interest!😊
-
UK Payroll - Generate a report with employees names and NINO
UK HMRC often carry out routine checks on compliance with PAYE and National Minimum Wage. In one NMW check we have been asked to provide them with a list of the names and NINOs of all staff employed by us between two specified dates. To make it easy they dont use tax years but calendar dates
We need a standard payroll report that allows us to export a list with the employees name and NINO. The only way to create this at the moment is by a manual trawl
3 votesThanks for your interest and feedback on this idea, everyone
Currently you can generate a Pension Contribution Report which includes the employees name and NINO 🙂 When creating the report - under Columns select the fields you'd like to include in the report as well as the date range. Once created, you can export it in PDF, Excel or Google Sheets.
-
Inventory - Run Inventory List report by stock codes in Foreign Currency
Generate inventory list report in FC by stock codes as it's very important if you have businesses in various countries with different FC to know an item costs EUR *** in Europe vs USD in USA instead of all in GBP
2 votes -
Reporting - Show filters applied
When a report filter is selected, the filter should be displayed on the report that is displayed/printed. Eg if you use employee groups and you filter a payroll report by said group, the printed report should display the filter chosen
3 votes -
Income Statement / Profit & Loss Report - Ability to separate Operating from General Admin expenses
XERO: Reporting Operating Vs. G&A Expenses in Income Statement Report
In the current income statement report, there is no way to split single account between operating and G&A expenses as XERO does not allow tracking on rows. This will result in finalizing reports through excel sheets or the need to duplicate accounts in COA to enable report expenses separately by nature.1 vote -
Aged Receivables / Payables Reports - Add 'Current' column
Case CX0013378184 - Aged Receivables / Payables Reports have changed - Please re-insert "0.00" balance Current Column
We urgently request that the “0.00” balance “Current" column be put back into the Aged Receivables / Payables Reports
XERO has just changed the format of the Aged Receivables / Payables Report to NOT show the "Current" column on the Reports if there is a "0.00" balance.
This is a huge Problem to us as a company with the way in which we do our reporting as we need that column to show. I cannot see the benefit of…
12 votesThanks for the feedback and raising as an idea here, Katie. We initially made this change based on customer feedback.
Appreciate how different businesses have differing needs and we'll keep an eye on the interest of this build here, however want to be open that there are no immediate plans for adding a Current column back to these reports at this stage.
-
Reports, QOL: "Find a Report" search (from 'Home' tab) returns from all tabs
Quality of Life suggestion:
At present, typing in a report name into the "Find a Report" search-box will only give you a return if you're in the correct tab (eg. searching from the 'Home' tab will not return any 'Custom' or 'Drafts' reports).
I suggest that reports from other tabs be included, at least when searching from the 'Home' tab, with an icon/heading to distinguish the tab-origin of the report.
(I appreciate 'Published' and 'Archived' returns could run into the hundreds, so perhaps a toggle/filter would suffice to omit/include those returns as desired)
1 vote -
General Ledger Reports | Excel export - Improve applied formatting
Hello
Would it be possible to have the old v1 General Ledger report in blue Xero that was recently replaced with a new General Ledger Summary and General Ledger Detail report still available to be used.
The new versions a good and can be formatted to look close to the old report but the old report exported to Excel really well with gridlines still showing and reasonable column and row sizes so large amounts of data can be viewed at once.
Many Thanks
5 votesWe've just released the change! 😁 As per my last update - you should now find the report easier to read and work with with updates to some of the sizing of fonts, consistency in the format of cells, and overall reduced zooming of the reports when you export to Excel. Thanks again, for your support in helping us make reports better for you.
-
Account Transactions Report - even if no transactions in account
Please allow the account transactions report to show even if there are no transactions for the specified period. i.e. the report will simply show the opening and closing balance.
This is very important if you are reconciling/consolidating various accounts of which some have movement and some don't. Without the accounts balances for all accounts (inc those with no movement) it will not agree.
2 votesWe've had a lot of development across Xero's reports, and everyone will now find we've provided options of which accounts to Include when running the report - those with Only transactions, transactions or non-zero balances, or All including zero balances!
I know this has been in hot anticipation here, thanks for all your sharing in the community on this. 😊 -
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
1 vote -
Projects - Create a report that includes a breakdown of suppliers invoices
Looking for a report under a project where I can have a breakdown of all invoices with dates and gross total paid for a specific supplier - I've been told this is not available and yet all the information is in the system but no report available
1 vote -
Reporting - Export reconciliation report pack as separate spreadsheets
The report pack is a great feature to save time in downloading multiple reports at the same time. Is there the ability to export these reports to excel as separate spreadsheets rather than as multiple tabs on the same sheet? If not can this feature be added as accountants generally review these work papers separately and it saves time if we don't have to convert the multiple sheets into separate spreadsheets.
1 vote -
General Ledger Reporting - Group by Account Type
Under the GL Summary Report(new) and GL Detailed Report (new), i notice they run by account code in alphabetical order as a result of which some Balance Sheet and P/L items are mixed together.
How can i run both the above reports in a way whereby all the Balance Sheet items are on top in alphabetical order follow by all the P/L items thereafter in alphabetical order
Can anyone help
7 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 -
Invoice Reporting (Payables) - Ability to include Planned Date as a separate column
In the new reports you can run a report, by supplier, of invoices that are due and planned to be paid, which is great. There is a differentiation between due and planned in both screen detail and reporting. The schuduled/planning option enables users or managers to plan which invoices they wish to pay either by viewing on Xero or running in a report. However, the reporting option puts the two together by adding in an invoice wiht the same due date, if a planned date has not been entered. This means that invoices not scheduled/planned…
8 votes -
Multicurrency - Supplier Statement in multi currency
The attached 'Supplier Statement' report has been 'retired'. Please consider reinstating this in Xero. We buy in euro and for financial audit purposes at every year end we need to issue this report. There is now nothing like this on Xero which makes no sense as we can't report without a mass of manual work to make a report outside of Xero.
11 votes -
Journal Report - Filter by posted date
It would be really useful if the journal report could be filtered on posted date as well as transaction date, currently they can just be filtered by posting date.
That way you could quickly highlight transactions that were posted in a period, after a certain point like a VAT return submitted or trial balance exported for accounts preparation.
1 voteThanks for your idea here, Adam. Our reporting team have just release a new version of the Journal report where you'll find this is now possible!
Along with more detail, you'll find there's the ability to Filter by any column added, including Posted Date 😁
-
Income by contact report - Chart for top 10 Customers
To have the ability to show the Top 10 spending by contact chart for customers similar to chart available on the expense by contact report.
1 voteSorry for not catching your idea here sooner, Tahlia. Appreciate the idea and this was fast to follow the Expense by Contact report.
Our report team have now added a chart to rhe Income by Contact report so you can view your top 10 customers the same as you can suppliers from the Expenses by Contact report. 🙂
-
Quotes - Specific reporting for quotes (or open API)
Ability to export a report that contains Quotes data.
Purpose: To help tracking what value of a quote has been invoiced
15 votesBack with good news, everyone! From today you'll find that your Receivable Invoice Summary and Details reports have both been improved so you can now add quotes as a Source in the report, as well as two common formats to quickly see all quotes or just outstanding quotes in one view.
Get in for a try, and save the views you'd like to use regularly. We appreciate all your support and feedback for this, here.
- Don't see your idea?