1384 results found
-
Bank Reconciliation | Suggestions - Matching by invoice number rather than amount
Reconciliation to be matched by INVOICE NUMBER rather than amount
9 votesHi community, appreciate the interest for being able to match based on the invoice number, even if the amount of the statement line and transaction in Xero differ. While this isn't something we have plans for at this stage, it'll be good to get a sense of the interest for this here.
Just to confirm for everyone coming across - The way suggested matches work currently is based on the amounts of the statement line and transaction being the same and also looking at most of the fields of a statement line and comparing with transactions entered to show a preferred match.
-
Budgets - Import Tracking budgets
Please please can you sort your system so that when we are bulk importing our annual jobs that it is possible to import the budget also - I have asked for this for many years but to date nothing has changed. I hope that now that you have finally updated the system, after several years of empty promises, perhaps this is now a possiblity. It is far too time consuming to enter the budget manually with over 1000 jobs and would speed up our invoicing if the budget field was imported instead of having to look elsewhere for the fee.…
18 votes -
Invoice Report - Including account, date paid and method of payment
I want a payment report of invoice payments made into my bank account, the report would show date of payment, method of payment and actual .
37 votesHi Donald, I've updated the title of your idea to make this simpler for others that are interested to find.
Though we don't have a report that'll show the payment method atm, you could run the Receivable or Payable Invoice Detail reports to view much of this information.
Once you've customised the report as you like, you can save as Custom to easily access that view anytime.
-
Profit and Loss - Filter tracking category by actual and budget
The new Profit and Loss report does not filter the actuals AND budget by tracking category. You have to manually add the correct tracking category budget to the report. When you have 40 plus tracking categories this becomes time consuming and silly.
The old profit and loss report did this easily. So the new report is a major step backwards
Ensure the filter for the new profit and loss report filters BOTH actuals and budget, so the report is easy to produce and has meaning. Do not expect users to add the correct column for budget - particularly those less…
51 votes -
Custom Report - Ability to decide if a formula row or column takes precedent
You can add formula columns and rows to a report, but from what I can tell, the column formula always takes precedent over the row. It would be cool if you choose if you want the row formula to calculate in the column formula column
6 votes -
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…
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 -
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 -
Reports - View bank reconciliation narration in account transaction report
Description Field with the bank narration
This happened as a couple of newer client and new to xero in the contact field wrote something incredibly different to the bank narration which makes it very difficult to review the general ledger information.
For example in the General Account the transactions descriptions are all listed as "John Smith" when if the bank narration option was available I could see it is Officeworks, KFC, etc and this would make it easier to realise these are miscoded and reallocate.
36 votes -
Reports - Export to excel with dashes instead of zeroes
It would be helpful to have the reports, once exported to Excel, already formatted, so that the Nil values are shown as a 'dash' as opposed to '0'. This is particularly useful when there is a large report or several reports with lots of data. It is more efficient when it comes to reviewing the figures, and saves having to custom format the individual reports. We have also had clients, who still prefer reports on Excel, ask for reports in this format, it is time consuming having to change, especially when it is a large reporting pack.
8 votes -
Find & Recode - Ability to change multiple accounts at once
It would be great if we could have an option to use find & recode to change to several accounts at the same time (similar to cash coding), rather than having to use the function over again each time. For example, if a client codes many transactions to general expenses, it would be useful to have a single screen where you can change the coding, with a column for "Current Account" and a second column for "New Account".
4 votes -
Reporting - Prior year comparatives to track the report periods
Ability to have the prior year comparatives track the report periods. Currently if a variance column is added to the reports the "Compare with" disappears.
2 votes -
Receivable Invoice Summary report - Filter based on Payment Date
Can we please have a function where we can filter the data based on the last payment date to show only invoices paid within the date range in the filter?
8 votes -
Reporting - Add Notes to Statement of Cash Flows
Add Notes reference for Statement of Cash Flows for totals.
When preparing financial statements it is not possible to add a Notes reference for total lines. This is extremely frustrating as we normally have a note reconciling the net operating cash flows to the net operating profit. This requires PDF correction after exporting from Xero.Please add functionality to add a Notes reference for total lines in financial statements.
2 votes -
Reports - Remove underscores between words on downloaded PDF reports
Hi team
It would be great if you could replace the underscores with spaces when downloading PDF reports from Xero - currently we have to tidy this up before sending reports to clients which takes unnecessary time.4 votes -
Aged Receivables report - Show Days overdue
It would be great if a column could be added to either the Aged Receivables Report or the Receivable Invoice Detail Report that shows the number of days the invoice is overdue by.
The number of days an invoice is overdue by can be seen on the 'Awaiting Payment' tab in the invoice section in Xero, but even on this part the information cannot be exported.
Thank you!
41 votes -
Inventory | Reports - Report that lists item sales and customer name and email address
We need to be able to create a report that lists inventory item sales and includes the customer name AND other customer contact information such as email address or phone number.
There have been occasions where I've needed to contact a large group of customers that have purchased a product from me due to a misprint in a book or an update to a title. At present, the only way I can do this is to export my inventory report and add the contacts manually. Xero Support Specialist - Daniel has confirmed this.
6 votes -
Tracking Categories - Reorder departments
In tracking categories - it would be useful to be able to have the option to reorder departments so they show in the order you want in reports
10 votes -
Bank Rule - Set Contact Only
Set a bank rule that only autofills the contact name - Often the same contact is used for sales or purchases to different accounts. Currently bank rules force you to choose an account. I'd like to set the contact automatically with the bank rule, then choose the account during reconciliation. Saves me typing the contact each time.
ALTERNATIVELY - I saw and voted for another idea that there could be a drop-down list of possible applicable rules, then I could write 2+ rules for the same contact and matching criteria, and choose the appropriate rule. This would be even faster,…2 votes -
Reporting - Non-financial items such as number of invoices
Hi, I was wondering if it is possible to include some non financial data in zero ledgers for reporting?
For Example - I would like to include a 'No. of Transactions' for a period that would not be a financial number (so no balancing required) but, this number would be available to add to reports i.e creating a cost per transaction.
We used to call these 'SKU's' and generally they would Non Financial KPI's like:- production days, FTE's, LTI's or Units produced.
Any help would be great.
Regards Iain Vernon2 votes
- Don't see your idea?