522 results found
-
Reporting: New P&L Report - Include archived Tracking Category used in date range
"Compare Tracking Category" in the Old Format P&L Report includes columns for all Tracking Category Values USED in the date range; irrespective of whether the value is ACTIVE or ARCHIVED.
"Compare Tracking Category" in the New Format P&L Report is different: it includes columns for ACTIVE Tracking Category Values. This represents an incomplete view because ARCHIVED Tracking Category Values USED in the date range are not included.
Please can you enable reporting of USED Tracking Category Values in the New Format P&L Report before you remove Old Format Reports in July 2023.
Custom reports don't provide a viable solution due…
7 votes -
Custom Reports - Add cashflow chart to custom report
I have successfully managed to create a custom report.
I now want to add on rows which give me the opening and closing balance each month to get a 12 month cashflow. Is there a way I can do this from the statement of cash flows (using the cash and cash equivalents at beginning and end of period)
When I try to add rows to my custom report it doesn't seem to offer to add, but only to group item is this something that could be considered.
I work for several charities and this report showing money in bank at…
1 vote -
Reporting - Reconciliating Profit & Loss and Statement of Cash Flows
The existing 'Statement of Cash Flows' could be enhanced to be the bridge between the P&L and the balance sheet.
1. Term debt and cash are netted to give the movement in cash equivalents. If the statement differentiated between 'term' funding (in our case, reduction of term debt) and the 'cash at bank' balance it would better describe cash flows.Make repayment of loans a 'financing' activity. Currently it is wrapped in 'cash equivalent'.
The flows in Operating Activities would be more meaningful if it highlighted where to see changes. For example, working capital changes in the period under review…
5 votes -
Blank Reports - Apply common date formats
I am having some difficulty with "Blank Reports". I designed a small divisional report which included only a small percentage of my P&L accounts. I tried to select a date range which is offered but doesn't work - the only date range that works is the current financial year. If you want to look at last month, last quarter etc - no luck.
When I brought this to the attention of Xero, their response was that feature isn't available - then why is it a report option. Their suggestion was to modify the P&L format which has date options that…
1 vote -
Account transaction report - Add YTD balance column
It would be so helpful to have a YTD column in the account transactions report. I run this report monthly for certain sales accounts to give to our marketing department and need the monthly amount and also the year to date amount however this report only allows me to show the period selected. This means I have to run 2 reports, one showing the monthly account transaction total and then one showing the year to date account transaction totals which I then combine in excel. Would also be good if there was a comparison to budget column.
5 votes -
Be able to see all transactions within a P&L report
I would like to send departmental P&L/spend reports to my managers. For eg, send all marketing spend to that team showing the act v bud figures AND all the transactions making up the actual fig
I reckon it would be best to add the Act and Bud figs at the top of the account transactions report for a particular chart of accounts10 votes -
Reporting - Exclude selected bills from Analytics Plus dashboards
It would be great if Analytics Plus had the option to exclude individual bills.
For example, our business pays our BAS and PAYG from a sub account.
We are unable to exclude this from the projection.2 votes -
Reporting - Field to show which user created a Quote
Report Design - Option to add the Field of who created the quotation
This will allow better use in data review/manipulation
5 votes -
Inventory Item Summary report - Select all in a filter
In the Inventory Item Summary report I can customise the report by adding a filter & then searching for a stock item eg a spigot - but there are 100 different types of spigots, & each of them need to be selected individually!!! can we please have a "select all" button???
4 votes -
Reporting: New P&L and Balance sheet - Add a link to go back to the report
With the old reports you were able to run the report and then click into one of the GL codes to look at the data. There was then a link "back to P&L / Balance sheet report" which took you back. This is missing in the new report which is very time consuming as it seems you have to start again with running and customising your report.
6 votesThank you for rounding back to confirm, Emily. I’ve changed the title of your idea, and we’ll keep an eye on the interest from the community here.
For now, you can try to use the right click to open a new tab on your browser when opening the transaction or code. We’ll come back here if there’s any news.
-
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 -
Profit & Loss - Ability to add variance columns for YTD Actuals & budget
Added features to P&L report design to be able to add variance between YTD Actuals and YTD budget on the P&L report
7 votes -
Profit and Loss (new): Edit/remove the heading dates
The Profit and loss report: Compare tracking are amazing, but still needs the following:
1 - To be able to edit the heading/remove the dates from the heading (as this is all reading showing on the top of the report, and can be very cluttering if every heading is starting with 1 June - 7 June 2022 ....)
2 - in the old P&L: compare reports, the columns/tracking that was not applicable "disappeared", with the new reports, I'm seeing ALL my tracking that is available, and not only the ones applicable, please do the same for the new reports9 votes -
Detailed GST Reconciliation Report
Ability to dive into the total amounts on the GST Reconciliation Report.
14 votes -
Trial Balance report: More than 36 months historical comparison
Could we please have the functionality of running TB reports with more than 36 months historic comparative months, thanks
4 votesHI community, thanks for your support here. While this isn't something we have plans for extending comparatives beyond 36 periods atm, it'd be good to get more detail on the ideal # of comparatives you'd be looking to run the report for, and what this would help your business do - Please do comment to share your views.
Other options you'll see you have with the new report, is that you can change the comparative period between Day, Month, Quarter or Year.
-
Management report pack - locking in start dates
We run a P&L Forecast report each month, with 12 monthly columns across the financial year.
Start date = start of the financial year.
Reporting on Month 1, this report shows Actuals for month 1 + Budgets for months 2 to 12, to give forecast total for year.
Reporting on Month 2, this report shows Actuals for months 1 to 2 + Budgets for months 3 to 12, to give forecast total for year.
Reporting on Month 11, this report should show Actuals for months 1 to 11 + Budget for month 12, to give forecast total for year.I…
6 votes -
VAT Reconciliation report - Ability to drill down in the unfiled VAT section
Not sure this is really part of Xero HQ - but it would be really useful to be able to drill down into the unfiled VAT section on the VAT reconciliation report.
12 votes -
Xero Reporting for Philippines ( BIR compliance)
People here in PH are starting to use Xero and I think many more will use it too if you create reports that are required by our Tax Authority such as:
Sales Journal
Purchase Journal
Cash Receipts Journal
Cash Disbursements JournalMost of our clients are asking for this. I really hope you will be able to implement this.
8 votesHi everyone, just wanting to highlight that as Caroline has suggested, it is likely the Account Transactions reports in Xero could be used to create the reports required. However, this depends on what information you require each report to contain.
If anyone is able to reply with more specific details on whether any information is unable to be obtained via the account transaction report this will help our product team better understand what's needed.
-
Reporting - 'Select all' option on the Account Transactions Report when Search is used
It would be great if when you use the search field to search for a name/description, if there was an option to 'select all' of the searched items. I often search for a description and then have 10-15 account codes I want to view, but i have to tick them all individually. A select all button would be amazing!
There is already a select all / deselect all option but only when there is no description searched.11 votes -
Reporting - Password Protect option for PDF downloads
SureIy this would be a no brainer??
I'd like an option to download PDFs with a password automatically added.
The password could be added in the company setting pages with the option to download "Protected PDF" when you print a report.
This feature seems so simple to create and i'm not sure why it hasn't been thought of.
This would also save us having to do this manually with every report sent to a client.
Please set this up at it would be a great option for bookkeepers and accountants.
8 votes
- Don't see your idea?