Account transactions report - Include item code as a column
Add item code as a column option in the account transactions report
Hi everyone, thanks for sharing and supporting this idea 🙂.
We understand you’d like to have Item Code available as a column in the Account Transactions report so it’s easier to review and track transactions against items, including untracked inventory items.
We’re moving this idea to Gaining support while we continue to learn more about the different ways this would help customers in their day-to-day workflows.
If this would be useful for you, please keep voting and add a comment with more detail about your use case. In particular, it’s helpful to understand what you’re trying to report on today and where the current report falls short.
We’ll keep an eye on the feedback here and share an update if anything changes.
-
Emma Davies
commented
Please add this as an option as there are several scenarios where this would be useful, such as for comparing Xero reports in different GLs to reports provided by Shopify or other third-party providers where the Item Code is the unique feature to identifying transactions.
-
Daryl Carver
commented
Sage does it - has had it forever. That is a class leading accounting product...i simply don't understand why it isn't there? It would add so much revelance and detail to reporting, anlaysis...
-
Viona Gunawan
commented
Very critical for my work. We use Item Code for comparison specific costs with budget. This will make monthly reporting so much easier.
-
Leticia Brown
commented
Update the Account Transaction Report to include the Item Code as a column, enabling users to track spending for each untracked inventory item.
-
Amy Redman
commented
We are just migrating to Xero and this lack of function is really surprising and already very frustrating! the main reason we moved to Xero was for greater reporting flexibility and less reliance on spreadsheet manipulation. Not being able to see the product code in the account transactions means we will still have to be merging reports externally to get the full picture.
Are there any plans to make this happen?
-
Amelia Kennedy
commented
PLEASE can you add the Item Code to the Account Transactions report. Unable to track Bills and Spend Money items in one place without doing some sort of cross matching. PLEASE!
-
Viona Gunawan
commented
Yes, this should be easy for Xero to implement. We need it for reporting in my workplace, and I believe many others would find it useful too
-
Julie Cooper
commented
without this item code being included everything is manual and who has that time!
-
Nadine Hyslop
commented
Yes! I've just been directed to the 'receivable invoice detail' report, however for a year of transactions I can see that being a big job to sift through everything.
Basically we are not a retail business but use untracked item codes for pricing reasons on our services for easy adjustment (and some line items have set line info which saves time). We cant use the tracking categories as that is used to track which truck was used.
We are only human - so we need to be able to run a report to see a certain range of our sales accounts have been mistakenly left out being assigned to these items as it will affect the overall pricing at EOY. -
Daryl Carver
commented
Essential - i really dont understand how anyone can easily analsye their transactions to be honest? Surely in a relational database this must be a '5 second' fix?
-
Jennifer Tryggvason
commented
Yes! As it stands I can't see item by tracking category, but if the item code were on the transaction list, I could filter the transactions report by tracking category, then export and sort by item.
It's a major shortcoming that I can't find any way to sort the item report by tracking category. -
Barbara Fusco
commented
Yes, please add a column to the Account Transactions report to see the related product/service code - this is crucial for reporting on direct costs and revenue. And it is important to include both purchase invoices and spend money items, as the Payable Invoice Detail report does not include Spend Money items. So it is essential to be able to see it all in one single report instead of having to run several reports each time - really time consuming!
-
Shimas Jiffry
commented
Sales transaction report - we are unable to find a separate column for item code, it will be helpful if its available as we can extract the sales report with item code to do Vlookup workings to find out if the goods are invoiced / sold as per the instructed prices. at the moment it reflects only the description and it will be helpful if the item code can be added.