The Retail Analytics Vendor Credit Report swiftly identifies and exports items eligible for back-end credits. It also includes a quick calculation method for the amount owed based on the sponsored cost of goods sold percentage split. Covering everything from applied discounts to individual SKUs, this report provides a comprehensive overview for easier tracking, management, and financial reconciliation.
The report includes top controls that allow you to quickly isolate and export specific discounts or items applicable to your agreed-upon credit. For this report, you can specify:
Stores:
Dates:
Discount Name:
Discount Reason:
Distributor:
Product Brand:
Product Type:
Product Subtype:
Product Name:
This report also allows you to select which type of cost you want estimated credit to be calculated.
Base Cost: The value assigned to each item during the intake of an invoice. (Example Below)
True Cost: This is the base cost minus any applicable invoice discounts. When a discount is applied to an invoice, the discount amount is evenly distributed across all line items on the invoice. (Example Below)
I
After utilizing the controls and cost selector to specify the data for the report, you can use the Cost of Goods Sold Reimbursement % slider to calculate your estimated credits.
How Estimated Credit is calculated:
Cost of Goods Sold Reimbursement Percentage x Cost = Estimated Credit