Product Margin Report is an excel macro-enabled workbook that compiles Sales and Cost of Goods Sold ledger reports into one. The final result is the profit and margin made on each item that was sold in particular period. If your financial system does not provide detailed profit and margin reporting, Product Margin Report will save you a lot of time!

The tool is found to be particularly useful for companies carrying physical inventory (manufacturers, distributors, etc). It clearly shows how much profit the company made on each sale, what are high profit and low profit items and how well our sales reps performed. Many companies depend commission on gross profits so it may be widely used in commission calculation for your employees. Additionally, once data is combined, you can easily produce aggregated reports such as margin per customer, margin per invoice, margin per item or margin per sales rep!

Product Margin Report was created to fill in gap in financial reporting. Not every financial system provides accurate and detailed margin reports. Many of them separate sales and purchasing in reporting. Combining these two is not difficult task but it is highly time-consuming and tedious. The goal of Product Margin Report is to save time preparing this important report without sacrificing accuracy and quality!