1081 results found
-
Sales Tax (CA) - Support 'Quick method' GST/HST tax calculation
Support Quick Method of GST/HST tax calculation for Canadian small business. Small business corporations in Canada have an option of so called Quick Method of GST/HST tax calculation that is based on a marginal percentage from the sales revenue amount instead of full balance of taxes collced and paid. Many small businesses choose to use QM because it frequently and significantly (upt to 30%) reduces GST/HST taxes payable. Current GST/HST tax report does not support the QM and the manual workaround method through tax adjustment is not 100% corret in terms of the line numbers in the report. Enabling QM…
14 votes -
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 -
BAS - Include Sales Invoice number
It would be great if the Activity Statement Transaction reports included the Sales Invoice number in addition to the Reference field. The old full BAS report used to show the Sales Invoice number as the Reference field on the report.
We use simPRO for Invoicing and when the data is imported the Job No/Order Number is imported into the Reference field in Xero but we sometimes issue multiple invoices per job so the Invoice number is much more relevant as a reference.2 votes -
VAT reconciliation report - Highlight that report only works with older version of non-MTS VAT Return
The VAT reconciliation report is still listed in the menu of reports, however there should be a comment somewhere in the report that says that it doesn't integrate with VAT returns filed under MTD.
This will avoid staff who are unaware of this, trying to make sense of it.
Maybe just completely remove it.1 voteThanks for the feedback, Andrew. This is something that's noted within the help for this report but appreciate wanting to see this more predominantly in the product.
No changes at present but we'll let you know if there are any made, here.
-
Xero New Reports from 31/7/23 - fixes to the Trial Balance report compared to the Old Reports
The mandatory update to using the new Reports in Xero from 31st July 2023 means the old version of reports will cease. This includes the much used Trial Balance report as accountants like myself tend to start from there when reviewing quarterly and annual work.
I notice the following list of issues with the New Report for Trial Balance:
1 - You can bookmark the old TB report and use this bookmark across clients. Also bookmark can be changed to show a particular date too i.e. 31st March. Bookmarking the new report always takes you to same client you initially…
4 votes -
Expenses Report - Ability to view unapproved expense claims
Xero Expenses - Currently there is no report to get information on expense claims needs approving. (by staff member, period etc) It would be useful to have a report which can be filtered rather then logging in to screen and view all. Thanks!
22 votes -
Reports - Voided and Deleted Invoices deselected by default
I deleted and voided invoices for a reason. I don't want to see them again, yet they show up by default on a number of reports. This is in addition to making the invoice number unusable when invoices are voided. None of this makes sense to me and I shouldn't need to make a custom version of every report that seems to included voided/deleted data by default.
5 votes -
Budget - Enter budget as a yearly option
Quickbooks allows this: and 501c6 and 501c3 find this EXTREMELY useful. We don't budget by the month per se; we budget yearly.
49 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 -
VAT Reconciliation Report - Auto-populate and drill down into figures
An updated, functional VAT reconciliation report.
The existing VAT reconciliation report isn't particularly useful. It has to be populated manually and the figures that do populate automatically can't be drilled down into. Not helpful.
VAT reconciliation aren't really a problem for us as we can use the Detailed Account Transactions report to identify the transactions posted directly to the VAT account i.e. transactions that have a category of VAT, whether it be a VAT payment, VAT on imports or just simply a miscoding by the client. Essentially it highlights those transactions that will affect the VAT ledger balance but won't…
23 votes -
Uncoded Statement Lines report - Default 'To' today's date
Currently when accessing the Uncoded Statement Lines report, the last date of the prior month will appear in the To field. This is currently set as the default in Xero.
Be more helpful if the current date was entered as it is the current entries that are being queried. If everything is up to date there should few if any aged items left in the reconciliation report.
3 votesThanks for the feedback, Richard. Can see where you're coming from and we'll get a sense of the overall interest from users on the thread here but want to be open that we don't have immediate plans for changing this.
To enable a little more swiftness when changing the date of this report you may find typing the letter 't' before clicking or tabbing through to the next field helpful - we have a few more date entry shortcuts you may like to explore, too.
-
Reports - Show payee in GST Audit report
I think it would be useful, in the GST Audit Report, to show the Payee, rather than the reference. The reference is often not very informative.
3 votes -
Report - Net Functional Column should add up on Account transaction report
The Net functional (for us GBP) column in the Account Transaction Report does not function correctly if we are considering the full GL.
Whether it shows a Debit or Credit as plus or minus depends on the type of account.
For example, an accrual Jnl posts Debit Expense/Credit Liabilities but both show as Positive in the Net column.We run the full GL to conduct our analysis and we re-calculate this column every time.
Then we can confirm that the list balances as the total of the double-entries should be nil.Is the current presentation of any use to anyone?…
4 votes -
History & Notes | Include item for invoice Sent (Via email or E-Invoice)
The History and Notes in Advanced Settings does not include the action of Emailing (or Sending) an Invoice (or any other document), yet this action appears on the individual Invoice History.
14 votes -
Invoice Reminders Report - Date and email sent to
Provide a report on who the automated invoice reminders have been sent out to, to know when the final reminder has gone out and payments not made can then be chased manually.
17 votes -
Fixed Assets - Allow Custom values in depreciation schedule e.g. 50%, 30%, 20%
Please update depreciation schedule to allow for custom percentages per year, for small business in SA it is allowed to depreciate 50% / 30% / 20% over three years but there is no viable way to implement currently.
18 votesHI team, we're grateful for your involvement and sharing through product ideas. To let you know, currently we don't have any plans for developing the ability to add custom percentages in the depreciation schedule.
We'll continue to track the interest from community through this idea and if there are any changes surrounding this we'll share an update with you all.
-
Reporting - Ability to sort notes alphabetically
On the notes section to the financial reports in adviser reports templated under the groups, I would like the accounts selected to be in alphabetical order. At the moment the only option is to manually drag and drop - with a large number of accounts this is extremely time consuming. An automated function would assist.
10 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 -
Xero Accounting app - Ability to include comparatives in the P&L
Add previous month to the other options to view P&L of this month, this quarter, & this year on mobile app
2 votes -
Reports - Add column for 'Last year to date'
It would be great for Reports and Custom Reports to have the ability to include a "Last year to Date" Colum. This would improve the ability to compare how the client is progressing Year on Year.
4 votes
- Don't see your idea?