56 results found
-
Reporting - Customisable Graphs
Recommendation is to add graphs as a report on Xero. Clients can see their turnover an example over a few months which can be sent to them direct from Xero !
15 votesHi everyone, thanks for your support and sharing on this idea. As some may have come across Xero now has Analytics.
Analytics enables all Business edition orgs (excluding Simple plan) to explore and customise visualisations and dashboards of the organisations key financial data, which can then be shared via link or export with colleagues or clients.
You can access these features via the navigation in your Xero homepage through the 'Reporting' tab.
-
Reporting - Aged Receivables Reports - run as at one date, and view the amount still outstanding at another date
Within the debtors and creditors reports (either detailed or summary) the ability to show balances as of todays date when working on client's system up to 9 months later, would be handy to see which debtors and creditors are still outstanding.
I.e. client has £100k debtors as at their year end 31/3/22, but when we run report on say 31/7/22, how many of that £100k is still outstanding? To have a toggle to the balance at the report date (31/3/22) or the current date would help,35 votesHi everyone, thanks for showing your interest here. With the newer Aged Detail reports, you can achieve this by;
- Setting the date of the report to the date you want to include payments up to
- Click Filter
- Set an Invoice Date filter as 'any' - 'invoices raised up to date'
If this is something you'll commonly run you may want to save the report as custom so you can easily open the report anytime. You'll just want to remember to adjust the filter for the Invoice Date. 🙂
-
Account Transactions Report | Paid or Unpaid Bills / Invoices
I wish to see if invoices are paid on unpaid when pulling account transaction reports.
Accounting - Account Transaction Report - Columns - (add if we can see if bill/invoice paid or unpaid)
There is no way currently when pulling this report to see if the bills are paid or not.
7 votesApologies for not seeing your response here sooner, Jayden. Thanks for sharing that image. I do hope you've got your answer already but to confirm for anyone viewing here - That screenshot appears to be the Account Transactions report.
To view paid or unpaid invoices or bills you'll want to run the Receivable or Payable Invoice Detail reports. This is a slightly different report to what you're looking at and can be found in the Payables and Receivables section of the reports centre.
-
Reporting - Add a column for contacts' phone numbers
I would like to be able to run a report that simply has overdue invoices, name, phone number, email. Ideally sorted by sales. Similar to the list I get when I am doing Statements but with a phone number in it.
4 votesHi team, apologies we've not updated the idea here sooner. With the Aged Receivables Summary report you can add a column for phone number, and you'll also find a common format from the left panel called 'customer credit limits' which show a list of limits and available credit by customer.
-
Reporting - Option to run reports in different currencies
i would like to have the option to run a report with USD , at the moment i have the option to British pounds
thanks
Astrid2 votesHi Astrid, sorry we haven't got back on your idea here sooner. You'll find since you first raised this here we've released the ability run reports in different currencies your organisation uses.
-
Reporting - Detailed Tracking Summary with Notes
Please bring back pre-July 2023 changes tracking summary (detailed) with Notes 3 Codes, I rely heavily on it.
2 votesHi team, as an update here we have now released a new Tracking Summary report.
You're able to include the new report in Management reports, and can drill down through the amounts shown in your reports.
If you use multi currency you'll see an icon in rows where transactions have been recorded in foreign currency and can click this to view the Exchange rate details.
-
Reports - Delete custom reports
We need the ability to delete a custom report. Many times a custom report is necessary for a period of time then no longer needed. I see no way to delete it. That would be VERY helpful.
2 votesHi Suzette and Tristan, this is already possible 🙂. A user with the Advisor role in an organisation can select to delete a Custom, Drafts, Published or Archived report from the relevant tab in the Report Centre.
-
Report Templates - Allow "Current date" to be inserted in reports at the client level.
There is no options to insert automatic date formatting into the reports at the client level. When the "current date" insert field doesn't work you have to manually enter the date all the time. It would be easier to be able to insert "current date" field.
18 votesHi team, happy to return to confirm that this has now been completely rolled out.
Report field that have been added and run at the client level are no longer editable, so it'll stay connected and continue to automatically update.
We really appreciate your support and sharing with us about this need in the idea here. Thanks! 😁
-
Account Transactions Report - Show VAT for Bank Accounts
To enable VAT to be shown on Account Transaction Reports for BANK ACCOUNTS
.
When reconciling the VAT to the VAT Reports, it is necessary to pick up the VAT from each type of transaction. We can pick up some of the outputs from the Sales Day Book (Receivables Invoice Detail) and some of the Inputs from the Purchase Day Book (Payable Invoice Detail) but what of the VAT which is dealt with straight from the Bank Account with no related Invoice / Bill.VAT Inspectors require a clear audit trail and although the VAT Reporting itself shows each transaction,…
7 votesHi team, we wanted to return and provide a further update to the idea here understanding it's still getting some attention. As mentioned in my last post we introduced a common format('Account Transactions with tax rates') within the General Ledger Details report that provides a more direct overview of the tax entered for all transactions in your organisation. It includes all transactions that have a tax implication to the ledger regardless of where they came from.
To provide a bit more on how tax treatment is shown and how Xero works - Xero automatically splits transactions to record the tax element of a transaction based on the tax rate selected on lines of your transactions, this saves you time having to record the apportionment in separate lines.
Bank transactions that are shown in reports are the amounts that have been received in your actual bank account and there fore they…
-
Report - Show Opening & Closing Balance, Total Debit & Credit for All Accounts in Columns
To have a report that can check the information of opening balance, total debit, total credit, and closing balance during the date range for the all the accounts in columns.
1 voteThe Account transactions report in Xero can give you the information you're asking here, Jiin Chiang.
If you don't want to see all the account detail you could 'Summarise by Account'
-
Report Settings - Option to set defaults for cover page & content page
for blue xero, we have to continually tick COVER PAGE, CONTENT PAGE, and other functions. Please allow us to set a permanent setting so we can generate the reports more quickly
4 votesHi team, while not completely obvious this is already possible from Xero HQ.
In Xero HQ, when opening a report template there is an Options button which contains Publishing defaults where you can choose to automatically include or exclude Contents page and Cover page.
-
Profit & Loss - Show Invoice Numbers
Currently there is no functionality in Xero to populate the invoice number in the Profit and Loss report while the reference field is filled out. Would like to have the invoice number to be shown as well for easy reference and checking.
3 votesHi team, as noted in my last update you can click on the figure in the Profit & Loss which drills down to the Account Transactions report.
You'll find that you can adjust the report settings to add 'Invoice Number' as a column so you can see both pieces of information on the report.
-
Report templates - Annual accounts templates up to do date and in line with legislation
The Trust - Annual Accounts Xero SPFR template for trusts > Notes to the Financial Statements > 1. Reporting Entity states "Legal or Trading Name is a trust established by a trust deed dated [insert field: trust deed date], and subject to the Trustees Act 1956." this is incorrect as the Trusts Act 2019 passed on 30 July 2019 has replaced the Trustee Act 1956. Xero have advised "While the team is aware the templates may need updating given current focus being on the expiration of old reports they do not have the capacity to give it a priority at…
2 votesHi team, templates have now been updated to refer to the new legislation. Thanks for your contribution and sharing in product ideas, here.
-
Purchase Orders: Generate a report on PO by item code
I would like to request that a report be designed where you can determine which purchase orders contain the "quantity on order" on a specific code. At the moment the only report you can pull is one where it shows which bills and invoices contain that code.
We work with thousands of products, and we need to find a way to determine which purchase orders have certain codes. There should be an option to pull a report based on the item code, showing what is on order (including the PO number) as well as the bills and invoices.
This will…
2 votesHi community, since this idea was raised we have developed Xero reports - You'll now find a common format option to the left side panel within the Payable Invoice Detail report to view All purchase order details'
The report includes the Item Code column by default, and you can also set Grouping/Summarising to Group by Item Code to group items together.
Additionally you could Filter the report, for example by Status, to only view Current orders.
-
Reporting - Net Sales
To have a report for NET Sales for a month. Currently there is a report that only shows what's payable with VAT (not all sales are vatable) so, when trying to reconcile with the in-house ordering program it becomes a whole big xcel spreadsheet exercise...... takes to much time. the report also includes Prepayments which are not goods sold, but money transactions in advance
1 voteHi team, returning to the idea here we will mark this delivered. As noted in my last update, with the Receivable Invoice Details report you can add Net and Gross columns to the report, as well as filter by Status if needed to zone into a group of invoices.
Once the reports set up you can save as custom to access the report with this setup anytime.
-
Reporting - Option to add account numbers & zero balances to financial statements
Ability to have to have a check box for "Include Account Numbers" and "Include or Omit Zero balances".
Purpose: Because it demonstrates completeness to show that the balance actually is zero
212 votesHi everyone, as of today the ability to show nil(zero) balance accounts in reports is live to all users!
To confirm, there are 2 ways to turn this on. Either through a blanket selection in the Report preferences, or via a toggle on and off option within the 'More' menu of the following reports;
- Balance Sheet
- Profit & Loss (Income Statement)
- Statement of Cash Flows - Direct Method
- Trial Balance
- Cash Summary
- Movements in Equity
- Blank report
- And, Report templates
As we close out this idea, we want to say a big thank you to everyone that's shared their interest in this with us overtime.
- Don't see your idea?