- or
1362 results found
-
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 -
Budget Reports - Ability hide selected accounts
The ability to remove the nominal accounts from a budget or show only selection of nominal accounts on a budget report. This would be useful so we can send budget owners a reports which shows only the budget lines that they are interested in and keeps actuals and forecasts in other nominal codes confidential.
11 votes -
Bank Statement report to show who the contact is that the transaction has been reconciled to
In the Bank Statement report it would be extremely helpful to have an additional column/option to view the Customer or Suppliers contact name that the transaction has been reconciled to.
We have a lot of invoices for the same amount and depending on who is reconciling, they can be matched to the incorrect customer.
A report showing the contact would help pick up anomalies, rather then after sending statements wait for a disgruntled customer to notify us that a payment has been made when we have reconciled it to another customer.3 votesPerhaps the Account Transactions report would be of help to you here, Tracy? You can adjust the report to add related account and Contact columns so you could see which account a payment came from as well as the contact it was assigned too.
-
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 - 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 -
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 -
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.
-
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.
-
AU Payroll | Employee - Job Title field
We should be able to customise our employee details report to include their job title as well, will this be look at and develop please
37 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 -
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. 😊 -
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 😁
-
Reports - Ability to add Sales Inventory Items to P&L Report
We would love the ability to include/add Sales Items to the P&L Report under Cost of Goods Sold - in order to track specific items(products/services).
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 -
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.
-
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.
-
New Bank Reconciliation Summary Report - Align header and balance
In the old version of Bank Reconciliation Summary report, the headers "Balance in Xero" and "Statement Balance" sitting with its balance amount in the same row.
After updated to the new version, the report, https://reporting.xero.com/!bX2sj/v1/Run/1066 for example, the balance falls different row of its title. It doesn't make sense and this would make it complex because you are not able to use scripts or Vlookup to manage those report (if they are not align in the same row).
Could you please consider
1. moving the balance amount to the same row of its header, or
2.…1 vote -
New Account Transaction report - Show closing balance on first page
Please restore the display of the closing balance on the first page of this report.
The report is used each month to check control accounts which may go to many pages.
The closing balance used to show on the first page which was extremely helpful not you have to scroll to the bottom (and you have removed the option for less transactions to show) and then we have to scroll through to the last page in order to see the balance.
Please bring back the functionality of the old report before you stop access to it-
Screenshot 2023-06-02 16.49.23.png 457 KB -
Screenshot 2023-06-02 16.50.26.png 427 KB -
Screenshot 2023-06-02 16.49.45.png 412 KB -
Screenshot 2023-06-02 16.49.23.png 457 KB -
Screenshot 2023-06-02 16.49.45.png 412 KB -
Screenshot 2023-06-02 16.50.26.png 427 KB -
Screenshot 2023-06-02 16.49.23.png 457 KB -
Screenshot 2023-06-02 16.50.26.png 427 KB -
Screenshot 2023-06-02 16.49.45.png 412 KB
1 vote -
-
Transactions report - all info in one line per transaction (not a second PST line)
Report for "Account Transactions" should only produce one line per transaction.
Currently, the report splits off a separate line for the PST component of each transaction, adding "- PST" in the description and to the contact name, and pulls the PST amount out of "Gross".
I need an account transaction report that includes GST, PST and the unit price in "gross" on a single line per transaction. These gross values will match the bank statement, and have the description/reference/contact and the account(s) the transaction was coded to.
The easiest approach is to have additional columns to select from, and (critically)…
2 votes
- Don't see your idea?