945 results found
-
Reporting - Option to extract transaction details without subtotals and formatting to support pivot analysis
Most often when I extract XERO finance reports I have to strip out all of the headings and totals in order to get to the raw transaction data for further pivot analysis and data refinement. Having a raw data dump (i.e., excel or csv format) as an option to the formatted files would save considerable time for users doing pivot analysis, multi period or year comparisons, adding calculations and additional columns, preparing charts, and just trying to summarize the data in a different way.
10 votes -
Report Templates - Make Report Fields available to use in group headings
It is not currently possible to use Report Fields in a group heading in reports.
We spend time setting up shareholder and director names in Report Fields but they can only be used in text blocks, not group headings in reports. If we could use Report Fields in group headings we could make report templates, such as the schedule of shareholder current accounts, more dynamic and automatic. See the screenshot attached for an example.
10 votes -
Reports - Add Business Snapshot report to management reports
It would be great to be able to add the Business Snapshot Report to the Management reports
10 votes -
Reporting - Bank Reconciliation report with line details
Report to display how one (of several) bank accounts was reconciled by another user. Items to include Who (Contact) What (Account Selected and Description) Division and Tax Rate.
This is to ensure the items were reconciled correctly, particularly overseas payments where NO GST must be selected. To check work of admin.
10 votes -
Reporting - Automatically update footer page range based on report page numbers
Can we get the report pack to automatically update both the footer and compilation report, based on the page range for the statement of accounting policies and notes to the financial statements. We're currently doing this manually and it leaves room for error.
10 votes -
Reports | VAT201 report - View total per transaction
I am looking for a way to view a value for the supplier or customer transaction as a total value not as individual lines in the vat201 report. For example. I have 3 line transactions in 1 customer invoice, so it shows these three separately. I dont want to view it like that, I want to view it as a complete value, so we can double check the whole invoice as opposed to going to the invoice and looking line through line, which is extremely time consuming
10 votes -
UK Reports - Add Net column to account transactions report
Being able to group the account transaction report by contact is brilliant but unfortunately the report has default columns for Debit, Credit, Gross and VAT and not running balance or net.
If the client is VAT registered the total showed by contact is VAT inclusive so please can the report also have the Net column turned on by default.
10 votes -
Reports - Add BAS reporting
Being able to click on the summary page to show what is entered in that field would be good or a drop down box on the BAS summary page. Having to scroll through sales to get to the expenses is time consuming.
10 votes -
Repeating journals - Date placeholder that uses a number-format for month
I attended the 2023 Q2 QPU and I like that for placeholders you can add a number in the square brackets to modify the month placeholder (this was in repeating journals - is it the same in other repeating features, like Invoices/Bills?). I also wonder if you can modify the year placeholder in the same way.
But I'd like also to be able to post repeating journals with a placeholder that uses a number-format for month (eg, 04 instead of April). Alternatively or additionally, it would be nice to be able to abbreviate the month to just the first 3…
10 votes -
Bank reconciliation report to show contact reconciled to
Bank reconciliation - A report that will show each bank transaction and then which invoice it has been reconciled against, as a way of having a quick way to check something has been reconciled incorrectly. Currently, the only way is to view each transaction through the account transaction report.
10 votesGood to hear you're aware of how you can run the Account Transactions report to view this information, Catherine - Is there a reason or something missing from this report that would help you when reviewing transactions?
-
Reports - Make formulas for individual rows
In reports - Be able to make formulas from individual rows / accounts not just "columns, group totals or formula rows". I have attached an example of the work around required to get Gross Profits for hospitality split into Wet (Booze) and Dry (Food). It adds 8 lines and makes the report unwieldy. I would love to to more interesting formula. And not have to export to Excel or other programs.
10 votes -
Aged reports - View Credit note allocations
Just looked at the new Aged Payable report > Aged Payables Detail - it doesn't show credit notes which been allocated to invoices. This is very confusing as we can't reconcile against the statement. Please review the report and add in credit notes, even if they have been allocated to the Invoices, or advise which report I need to use when reconciling the account.
10 votes -
Account Transactions Report - Hide Archived Accounts
The attached post indicates that Xero has delivered the ability to hide archived files by unticking the "Show Archived" box in the account transactions report and then saving it as a custom report. I have tried this, but it doesn't work. Every time I go into my custom report which should have the Show Archived box unticked it is always ticked and the archived accounts are showing. Could you please look at this again.
10 votesHi Sally, appreciate the image back to the earlier update you're referring to here. Is it possible that the custom report you're using was saved prior to the update and needs updating with any new setting changes and then saving again to hold these for future use?
If you're still finding the same behaviour, I'd highly recommend raising a case with our team of specialists at Support so they can dive into why settings you've saved in a custom report aren't being applied. Thanks
-
VAT - Show Unreconciled Statement Lines for a VAT period when completing a VAT return
A note of outstanding, unreconciled statement lines before completing a VAT return.
Currently you click review and can see the VAT return; however, it would be useful to have a box that would flag if there any unreconciled transactions within the VAT period.
This would help to ensure no transactions are missed when completing a VAT return.
10 votes -
Custom Report - Ability to create formula with any column
Custom Reports
The formula feature only appears to work for columns that are located to the left of the formula column.
Each column has a name, surely the name is the important element and not the position of the column on the report.
Can the formula feature be amended so that columns from anywhere in the report can be included10 votes -
Xero Accounting app - File CIS returns from app
To be able to use CIS on the mobile app and on an IPAD.
When you are not able to use a laptop and you need to work with CIS.10 votes -
Reporting - Include report filters in report links/URLs
New reports - enable data capture in links
Currently - if you select a specific date range or filter and then link to this report, that data is lost and upon clicking the link you get the default report and have to reselect the data.
It would be useful and time saving to enable the link to capture that data - the same as the old versions of the reports
10 votes -
Reports - Add non-financial data into Xero for use in calculations
Now that we can add equations, I'd like to see Xero add non-financial data for use in calculations. Specifically, I'd like to add a number that changes each month (number of clients). This will allow me to calculate the revenue per client. I would also like to add the number of clients lost and clients gained so I can calculate the churn rate and customer lifetime value (important to use in making decisions on marketing spend).
10 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 -
GST - Enable AIM tax method
Enable AIM tax method for NZ
This is needed for small businesses in NZ to do their own AIM lodgement automatically via Xero without using an accountant. In the GST return, there are three options currently; Standard, Estimate, and Ratio but not AIM. The whole purpose of AIM is to smooth cashflow and make it simpler for small businesses to file one return for both GST and Income Tax at the same time, but it appears this option is not available to us! Please vote for this to be included ASAP as an option.10 votes
- Don't see your idea?