Settings and activity
4 results found
-
22 votes
An error occurred while saving the comment -
211 votes
Thanks for all the valuable feedback you’ve shared through this idea. We get how adding Quantity and Unit Price columns to the Account Transactions report would help you with transaction reconciliation, and provide clearer insights, without the need of opening individual transactions.
Being upfront this isn’t in our team’s roadmap, however the idea will remain open for voting. Your input continues to shape our understanding of what’s most important, and we’ll keep sharing your feedback with the product team as they assess and plan for the future.
An error occurred while saving the comment 
Sam Jones
commented
Hi all, I've been waiting for fixes for this for a longtime, and like many of you I genuinely couldn't believe this still hadn't been sorted after all these years. So we went and built it ourselves.
It's called QSync. It connects to your Xero account and generates a GL report with a quantity column, exactly what everyone here has been asking for. It pulls your invoices, bills, bank transactions and manual journals with full line item detail including quantities, unit price, net, VAT and gross. Filters by date, account, contact, type and tracking categories. CSV export included.
It's live at qsyncreports.com and completely free to have a go, connects via your Xero login in about 60 seconds. No credit card, nothing to install.
It's still early days, very much a beta, so it's rough around the edges in places and I'm actively working on it. That said, the core report is working well and I'd love to get some real-world feedback from people who've actually needed this. Any comments, suggestions or bug reports would be really well received at this stage.
Feel free to drop me a line directly at sam@clearyields.com if you'd prefer to get in touch that way.An error occurred while saving the comment Sam Jones
commented
This would be a highly valuable addition to the Account Transactions report and is critical for operational and commercial analysis.
Including ‘Quantity’ and ‘Unit Price’ as selectable columns would allow users to review both volume and pricing at a glance, without needing to drill into individual transactions.
From a practical perspective, this is particularly important in sectors such as agriculture, where performance is assessed on both tonnes sold and price achieved. The ability to see total quantities and average unit price over a period would significantly improve reporting efficiency and decision-making.
At present, extracting this information requires manual workarounds, which is time-consuming and increases the risk of error.
Sam Jones
supported this idea
·
-
132 votes
An error occurred while saving the comment Sam Jones
commented
Hi all, I've been waiting for fixes for this for a longtime, and like many of you I genuinely couldn't believe this still hadn't been sorted after all these years. So we went and built it ourselves.
It's called QSync. It connects to your Xero account and generates a GL report with a quantity column, exactly what everyone here has been asking for. It pulls your invoices, bills, bank transactions and manual journals with full line item detail including quantities, unit price, net, VAT and gross. Filters by date, account, contact, type and tracking categories. CSV export included.
It's live at qsyncreports.com and completely free to have a go, connects via your Xero login in about 60 seconds. No credit card, nothing to install.
It's still early days, very much a beta, so it's rough around the edges in places and I'm actively working on it. That said, the core report is working well and I'd love to get some real-world feedback from people who've actually needed this. Any comments, suggestions or bug reports would be really well received at this stage.
Feel free to drop me a line directly at sam@clearyields.com if you'd prefer to get in touch that way.Sam Jones
supported this idea
·
-
257 votes
Hi everyone, thanks for your engagement and support for adding a quantity column to reports in Xero. We understand there are differing reasons around wanting to add quantity to a report, like being able to track fuel for tax credits, livestock numbers, or hours worked for carbon reporting.
There's a specific idea for Livestock reporting that we'd recommend anyone interested in this joins.
To highlight, quantity can be added within the following reports within Xero right now;
- Inventory Item Details - will allow you to view quantity on hand of tracked inventory items
- Inventory Item summary - lets you view quantities purchased and sold for all items, as well as opening closing and adjusted quantities for tracked items
- Sales by Item report - will show you quantities sold for inventory items
- Payable Invoice Details report - will give you quantities purchased for all line items
- Receivable Invoice Details report -…
Sam Jones
supported this idea
·
Hi all, I've been waiting for fixes for this for a longtime, and like many of you I genuinely couldn't believe this still hadn't been sorted after all these years. So we went and built it ourselves.
It's called QSync. It connects to your Xero account and generates a GL report with a quantity column, exactly what everyone here has been asking for. It pulls your invoices, bills, bank transactions and manual journals with full line item detail including quantities, unit price, net, VAT and gross. Filters by date, account, contact, type and tracking categories. CSV export included.
It's live at qsyncreports.com and completely free to have a go, connects via your Xero login in about 60 seconds. No credit card, nothing to install.
It's still early days, very much a beta, so it's rough around the edges in places and I'm actively working on it. That said, the core report is working well and I'd love to get some real-world feedback from people who've actually needed this. Any comments, suggestions or bug reports would be really well received at this stage.
Feel free to drop me a line directly at sam@clearyields.com if you'd prefer to get in touch that way.