Inventory report with GP margins
Inventory activity summary with columns for
Purchases
Adjustments
Sales
On Hand
Unit Cost
Sales (currency value)
COS (currency value)
GP
GP%
Unit sales price
2
votes
Elna Taljaard
shared this idea
Hey Elna, there is existing functionality in Xero that lets you see gross profit and margin for your inventory items using the Inventory Item Details report. To turn this on in the report, follow these steps:
- Go to Accounting > Reports > All reports.
- Open the Inventory Item Details report.
- Choose the date range you want, then click Update to run the report.
- Click Columns, then select:
- Margin – shows the difference between the cost price and sale price as a percentage (your GP%).
- Profit per item – shows the difference between the cost price and sale price in dollars (your GP per unit).
- Click Update again to refresh the report with those columns showing.
You can also use the Group/Summarise options to group by item if you want to see totals by product, and use Filters to narrow it down to particular items or date ranges.
😊
