Account transactions report - Show description of transaction line
Account Transactions Report
It doesn't make sense that you can separately select the 'Contact' column and the 'Description' column, but that the 'Contact' details show in the 'Description' column.
It feels like the 'Description' column in the Account Transactions report is wrongly pointing to the 'Contact' data!
If the 'Description' detail is not available in the Account Transactions report, this column should be withdrawn from the options available for selection.
It would be great to get this issue fixed.
Hi team, we want to acknowledge your feedback and the needs you’ve expressed for being able to view the transaction line description in the account transactions report.
While we appreciate not the news you’re hoping for here - we want to be honest with you all that there are no plans at this stage to change the behaviour of this report.
We appreciate there can be some confusion of what is shown as it does differ based on the account and the line’s origin. We have added detail within our Xero Central article, but I’ve also noted below for ease of reference.
- For accounts receivable, accounts payable, bank accounts, and tax account, it shows the contact’s name.
- For all other accounts, it shows the contact’s name and the item line description.
- As manual journals don’t have contacts, it shows narration and description.
- For wage payments, Payroll Employee displays in place of the employee's name.
We’ll be keeping a close eye on the interest this idea continues to build and votes will remain open. If anything changes with the status or if there are any updates to share, we’ll be sure to post them here so you’re among the first to hear.
-
Anne Hoff
commented
In addition to what everyone else has said, at a minimum Xero should change the column name of "Description" in the AT report where it is showing the information from "Contact" until a real solution is available.
-
Stephen Chelli
commented
This is a critical feature!
-
Kathleen Crewther
commented
It would be very valuable to have the description shown in our reports when exporting. It does seem strange that there is a description option but the contact details appear in this area.
If the description option is offered why cant this field be display on the AT report. I'm not an IT person but it seems like its an easy programing to make it happen.
Hope this happens in the near future.
All the same XERO is a great accounting program.
-
James Hursthouse
commented
I 100% support this need to show the proper Description in the Description column. I run my own advisory business and my main use case is exporting Expense Reports to my customers for reimbursement. They need to see WHO I paid an expense to, and WHAT IT WAS FOR - e.g. WHO = Hikari Sushi Restaurant / WHY / DESCRIPTION = Dinner with Mr. Important from Big Games Studio.
Right now, I export the report to Excel and manually input the DESCRIPTIONS which I have already typed into the 'Why?' field when I entered the receipt into Xero.
It is great in that I can easily filter by Tag (i.e. a specific business trip) and see which Customer the expense was assigned to, and also show the GL into which the expense has been categorized, but the fact that the exported report shows the Contact name in the Description drives me crazy and means an extra few hours of work.
Support recommended I come here and support this 'feature request' but clearly this is a bug, and I echo the sentiment of everyone on here in requesting it gets fixed asap.
-
Danni McDermott
commented
Please show the actual transaction description in the description column of the Account Transaction Report!!
There is No useful report in Xero that I can export to excel and cross reference how transactions were coded against an actual bank statement.
This issue could be easily solved if the Account Transaction Report actually showed the "Description" In the Description Column instead of the vendor/contact (which is redundant and not useful at all as that's already presented in the Contact Column).
Similar to a bank statement, I need to see : Date, Contact, Description, Amount AND the Expense Account it's hitting. It's crazy that not one report does that.
This is something Quickbooks has figured out forever ago. I can see how the expenses are being categorized without opening every individual transaction. This is a VERY time consuming problem for us with Xero.
The solution is so simple: put the actual transaction description in the description column of the Account Transaction Report. Keep everything else on the report the same, and for bonus points, just allow us to export to Excel from the Find & Recode screen. Thanks for considering this fix.
-
Leah Morris
commented
This seems like the MOST BASIC feature request ever! I've been in Xero for a whole 2 days and have spent the last hour trying to figure out why the "description" field isn't viewable for easy scanning! I agree with all of these comments please make this available to us!
-
Lee Kooiman
commented
If we could please change the description in the description Column in account transactions for all accounts to be the actual item description while in the CASH basis and not who made the payment , the ACRUALS basis has the item description as written when creating the transaction so i basically want it the same. I'm set up as cash and it makes it difficult for me and my accountant not having the description.
-
Edgar Twigg
commented
I don't want to filter by Contact, I want to filter by Description. When matching transactions, it is easy to set the Description. It is hard to set Contact.
-
Christine Wallis
commented
Hi, I would like to vote for this too. To clear things up a little, if you run a transaction report on an accrual basis then the description is included correctly. However, most of our clients want reports on a cash basis - the fact that you also cant post a budget to a cash summary report is also a problem and we have had to write our own and export into excel and this has been a real issue.
We would like to be able to run the account transaction report alongside this to enable clients to see what the transactions were on each of the codes for that month - useless when the report relates back to say payment of the invoice or the contacts name rather than the description on the invoice that has been paid.
This is really a basic report and should not need to take 2 to 3 years to develop. -
Cathy Wood
commented
Thank you Frank, well said
-
Maggie Kavanagh
commented
Thanks Frank. Hopefully the developers will understand why the functionality is required.
-
Frank Burnham
commented
Kelly, with sincere respect, I don't think you understand what we are asking. We want to run a report for expenses or assets or liabilities, or revenue, not the bank account, and see the specific description field that displays the description of the nature of the transaction. Virtually every general ledger system on the planet does this except Xero and I don't understand the blow back on this issue. We shouldn't have to justify why this is important to accountants but here it is:
Clients who record their own transactions are a disaster and the constantly miss-categorize transactions to improper accounts. If we can see the transaction language they used to explain what the transaction was, we can quickly determine whether there is an accounting error or not. There is more to accounting than the transaction date, vendor, and amount. Description satisfies the 'why' the transaction was incurred for business purposes.
For example, if a client processes a transaction with a transaction description as "dog food for Fido" and they record this to the Manufacturing Equipment account, we can very quickly determine that this an accounting error. However, Xero doesn't allow for the Manufacturing Equipment or whatever account transactions report to display the transaction description column. Instead, we have to drill down to the transaction a few click to see this.
This may seem trivial to a systems developer, but this basic reporting insight helps accountants perform a very traditional procedure called 'scanning', which is a traditional and valid auditing technique used in financial statement audits, tax preparation, and general bookkeeping services. When you see a couple hundred transaction that might be significant but you can't see the client's description, it is a colossal waste of time to click on each item, especially if you are hunting for transactions to reconcile a particular significant account balance.
Thank you for your understanding.
-
Colin Dutenhoffer
commented
This idea continues to grow but I have been told multiple times that there are not enough votes or comments to get the development team interested in fixing this problem. I have had the one other person I know that uses Xero vote. Every one else needs to encourage users to vote. I was given a work around of exporting the information into Excel but if I have to use Excel to make my information useful then what good is paying to use Xero? I am a small farm, single user, and don’t need most of the features that are included, but being able to use the description to verify my books are accurate is vital.
-
Janet Dawe
commented
It would be very useful if the actual description was included in the description column when the account transaction report is run. Repeating the contact name in the description column doesn't help at all. That information is in the Contact columns, so is just being duplicated. We insert descriptions for a reason and it's time consuming to have to go into each transaction to get the description as to what was done and why, when with a few clicks of a button, we could get it from a report. Time is precious and we are wasting a lot of it, having to look at each transaction individually, to see the description. Please can this be looked at as a matter of urgency.
-
Marie-Noelle Morin
commented
It's been three years and over 4 pages of comments requesting to remove the contact name in the description field. How is Xero waiting for ?
-
Ahmed Khalil
commented
it would be really useful if the description showed actually what the transaction was for and not just who it was for given that this information is already on the report
-
JANE EDWARDS
commented
Like others have said it would be really useful if the description showed actually what the transaction was for and not just who it was for given that this information is already on the report. Having the supplier name show twice is not helpful at all.
-
Steven Austin
commented
This is pretty poor. There is no way to export a report for a credit card account that shows the description explaining what the purchase was for.
Having two report fields showing the same data makes no sense. -
Belinda Torr
commented
When you submit a transaction via the Expense Claims function, it will duplicate the Contact Name and add that into the front of the description, so when you run an Account Transactions report, it then shows the Contact Name twice (because all transactions automatically have the Contact Name added in at the start of the description already) but then the Expense Claims feature does it again, so your transaction report line item will show as "Supplier Name - Supplier Name - Description of transaction" instead of just "Supplier Name - Description of transaction".
Can Xero remove the duplication here?
-
Terry Barnum
commented
We too would like to be able to easily see WHAT the transaction was, not just WHO it was to. We are diligent about entering that info into the "WHY" field during credit card reconciliation, but there's no way to see this info without manually drilling into each transaction. Perhaps an option to display columns as in other places. I spent over 8 hours going through ~200 credit card transactions yesterday to see what they were for and if they had been entered into WorkFlowMax2. It would be a killer feature if these apps were able to talk to each other for better cost management.