# Product Performance by Year

## Report Information

<table border="1" id="bkmrk-name-report-type-dep" style="border-collapse: collapse; width: 100%; height: 89.4px;"><colgroup><col style="width: 19.4644%;"></col><col style="width: 80.6548%;"></col></colgroup><tbody><tr style="height: 29.8px;"><td class="align-right" style="height: 29.8px;">**Name**</td><td style="height: 29.8px;">Product Performance by Year</td></tr><tr style="height: 29.8px;"><td class="align-right" style="height: 29.8px;">**Report Type**</td><td style="height: 29.8px;">Additonal Report, exportable to CSV.</td></tr><tr style="height: 29.8px;"><td class="align-right" style="height: 29.8px;">**Deployment**</td><td style="height: 29.8px;">Request from [Support](https://kb.findesolutions.com/link/1#bkmrk-department-phone-%23-e)</td></tr><tr><td class="align-right">**Report Version**</td><td>2025.6</td></tr></tbody></table>

## Description

This report will provide you with the previous 12 months from the selected date, showing product performance on a month by month basis.

## Filters

<table border="1" id="bkmrk-name-example-descrip" style="border-collapse: collapse; width: 100%; height: 119.2px;"><colgroup><col style="width: 16.4478%;"></col><col style="width: 33.5209%;"></col><col style="width: 50.0293%;"></col></colgroup><thead><tr style="height: 29.8px;"><td style="height: 29.8px;">**Name**</td><td style="height: 29.8px;">**Example**</td><td style="height: 29.8px;">**Description**</td></tr></thead><tbody><tr style="height: 29.8px;"><td style="height: 29.8px;">Year End Date</td><td style="height: 29.8px;">2025-01-01</td><td style="height: 29.8px;">This is the date the report will work back from. If you do not set, it will default to the current date.</td></tr></tbody></table>

## Output

<table border="1" id="bkmrk-column-description" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 26.6072%;"></col><col style="width: 73.512%;"></col></colgroup><thead><tr><td>**Column**</td><td>**Description**</td></tr></thead><tbody><tr><td>Make</td><td>The manufacturer of the product.

</td></tr><tr><td>ModelNo</td><td>The model number for the product.</td></tr><tr><td>Department</td><td>The products' department.</td></tr><tr><td>CurrentRetailPrice</td><td>The *curren*t *lowest* active retail price for the product, regardless of report dates.</td></tr><tr><td>CurrentCostPrice</td><td>The *current lowest* *active* cost price for the product, regardless of report dates.</td></tr><tr><td>LastSold</td><td>The date this product was last sold.</td></tr><tr><td>Created</td><td>The date the product was created.</td></tr><tr><td>FreeStock</td><td>The amout of stock available to sell today.</td></tr><tr><td>*\[Month\]\[Year\]*</td><td>The columns for the previous 12 months from the starting report date, each showing the amount sold during that month.</td></tr><tr><td>SoldThisYear</td><td>How many you have sold in the current year, regardless of report dates.</td></tr><tr><td>TotalSold</td><td>The total amount sold of this product across all time.</td></tr><tr><td>TotalRetailInc</td><td>The total retail price, including VAT, for the products sold in the report date range.</td></tr><tr><td>TotalRetailEx</td><td>The total retail price, excluding VAT, for the products sold in the report date range.</td></tr><tr><td>TotalCostEx</td><td>The total cost price, excluding VAT, for the products sold in the report date range.</td></tr><tr><td>Margin</td><td>The raw margin value for the totals for the period.</td></tr><tr><td>Margin%</td><td>The margin as a percentage for the totals for the period.</td></tr><tr><td>Markup%</td><td>The markup as a percentage for the totals for the period.</td></tr><tr><td>ProductAge</td><td>The age in months for the product.</td></tr></tbody></table>