This report gives you a detailed look at inventory item performance across sales, costs, and profitability for a selected time period (e.g., "This Year"). It's designed to support cost tracking, profitability analysis, and inventory control for veterinary or retail operations.
🧾 Purpose of This Report
This table allows you to:
Track unit costs and cost changes
Monitor sales activity and revenue
Analyze profit per inventory item
Compare item markups and sales price history
📌 Understanding the Report Columns
📦 Inventory Item Details
Inventory Item Name: The name or SKU of the product.
Expandable Rows: Click the arrow (▸) to see breakdowns by linked products
💲 Cost Tracking
Current Cost per Unit: The latest known cost to acquire or produce one unit of the item.
Avg Cost per Unit: The average cost over time, accounting for past purchases or changes.
Last Cost Change: The last recorded date on which the unit cost was updated.
Received PO Cost: Shows the cost for a recent purchase order, where available.
📦 Inventory & Sales Activity
Qty Ordered: Total units ordered during the reporting period.
Units Sold: Number of units sold to clients/customers.
Units Returned: Number of units returned by customers.
Last Sold: The most recent sale date of the item.
📈 Financial Performance
Cost of Goods Sold (COGS): Total cost attributed to the items sold.
Total Item Sales: The revenue generated from selling the item.
Inventory Item Profit: Net profit = Total Item Sales - COGS.
Negative values indicate a loss.
Zero profit may indicate free items, tracking gaps, or cost mismatches.
🔍 Linked Product Markup & Pricing Breakdown (when expanded)
Category: The product category assigned to the linked product item.
Current Markup: The current percentage increase from cost to sales price - shown both as a percentage and dollar value
Current/Avg Markup: The average percentage increase from cost to sales price - shown both as a percentage and dollar value
Last Markup Change: The last date the markup amount or percentage changed.
Current Sales Price: Price at which the linked item is currently being sold.
Last Sold: The last date which the linked item was retailed.
Total Product Sales: Total sales from the linked item within the report time period.
📥 Export Options
Use the top-right controls to:
Download a full report
Export to CSV for spreadsheet manipulation
Clear or update the selected time range for the report
🛠️ Example Use Cases
🧾 Profitability Reviews: Identify underperforming or over-marked products.
📦 Restock Planning: Check if costs have increased before reordering.
🧮 Financial Reporting: Export data for P&L statements or tax reporting.
⚠️ Spot Inconsistencies: Find items with $0 cost or revenue and fix underlying data.
❗ Common Observations
Issue | Explanation |
$0 Cost or Sales | Might indicate a missing entry, donation, or a system input error |
Negative Profit | Sales revenue doesn’t cover cost; review markup or pricing |
No Units Sold | Consider investigating low-performing SKUs or promotional needs |
Old Last Sold Date | Item may be obsolete or rarely used |