Account Transaction report - Add Quantities & Unit Price to Column Drop Down
It would be incredibly helpful if 'Quantities' & ' Unit Price' were included as column options in the Account Transactions report.
This way one can quickly review the quantity & price of each entry without having to drill down into each individual entry. It would also provide a total quantity and average unit price for the given period.
The example that I am referring to is on a farm business where we would like to review the tonnes of crop sold and the price.

-
Dennis Graham commented
all the data is there can't be that hard. It's unbelievable that quantities cannot be reported on transaction reports.
-
Julie Copland commented
151 votes, and I’m sure there are hundreds if not thousands of others that would find this a huge time saver, please consider this Xero
-
Olivia Rawson commented
How is this not an option?! There's a quantity box in every invoice and bill yet no option to show quantities in a simple transaction report? Please add this feature, so simple yet so helpful...
-
Liz McMahon commented
Very important need for ATO fuel tax credit calculations
-
Tracy Minchin commented
This is a basic feature that all other accounting software programs make avaliable, except Xero! This is needed ASAP, especially to extract litres of fuel purchased for ATO Fuel Tax Credits calculations.
Why have a data entry field called QTY when you cannot generate a single report out of Xero to extract that data??KELLY MUNROW please give us Xero's response
-
Rhys Williams commented
This seems like very basic information to not be able to add to the report - quite shocked that this is not available when it is added to each transaction
-
Sue Gulliford commented
This is essential information for farm businesses - I don't understand why it can't be available.
-
Denise Scott commented
This used to be available within this report as I had a custom report built for this but someone, somewhere within Xero has removed the option to add quantities & unit price to the Account Transaction report. What is the point of giving the ability to post bills/invoices using quantity & unit price if you can't then report on how much of a particular item you have purchased. We are trying to extract information for a UK Government funded Carbon Audit for farming clients and now have to resort to drilling into each transaction to find out the quantities purchased of fertiliser and fuel. This should be a standard means of reporting for non-service industry clients who don't function in the same way as e.g. plumbers merchants and the like.
-
Mariette Van Wyk commented
Critical - Saving time and manual editing
-
Hannah Gillespie commented
FYI for all commenters - Quantity information can be added on the receivable (or payable) invoice detail report, doesn't allow for journal transactions etc, but goes some way to be able to get information out of xero that has been put in!
-
Court McCauley commented
The lack of a report showing quantities costs me hours regularly. This feature has been available in other software for decades, and has been requested from Xero since at least 2013. Being able to include a quantity column in a general ledger or account transaction report would save a tonne of time and work.
-
Hailey Crossan commented
This addition will be super helpful for myself and my company, we manually add it in a report pulled from Xero.
-
Lara van Eeden commented
Critical - will really make reporting better.
-
Anton Verster commented
This will assist a lot in refining searches and make reporting to the client a lot easier and quicker
-
Suzelle Pienaar commented
This will easy comparing periods and spot tendencies easily.
-
Jean-Andre Du Toit commented
Please can we get this available. Was actually shocked that it was not yet available as I thought it to be a basic inclusion.
-
Nicole Mason commented
This would be really useful - surprised it is still not available.
-
Matthew & Eimear Perks O'Connor commented
Would be very useful and would save me a lot of time
-
Peejay Moody commented
It is beyond comprehension that the quantity field cannot be selected in a Transaction Report. This is not even an 'idea', it's just basic functionality that is woefully lacking.
-
Tim Gleeson commented
I am surprised this is not a baseline reporting requirement. Quantity of an invoiced item helps determine trends in sales over time