This report allows you to quickly find all transactions for a specific Brand promotion, calculate the credit due for each, and export it to the send to the Brand for credit.
Insights > Dashboard > Accounting > Vendor Promotion Credit Report
Select the following options to filter report data:
- Date
- Shop(s)
- Brands
- Promotion Name
- Vendor Coverage - Agreement between the vendor & shop
-
The resulting report will calculate your Promo Credit due based on the following:
Vendor Coverage x Discount % x COGS -
Export this to CSV or Excel via more options in the upper right to send to your vendor
There is a line for each unique product/batch combination for a promo.
- If 5 qty of a single batch it will show 5 on one line.
- If 3 of one batch and 2 of another, then it will show the two lines for qty 3 and 2.
That is so it can account for the unique COGS of each batch. - Gross Sales is Units x Product Price
- Discounts are the dollar amount discounted off the Gross Sales based on the specific promo
- Customer Discount is the % of Discounts divided by Gross Sales.
- Unit Cost is the batch cost per unit
- Net Sales is Gross Sales - Discounts
- COGS is Unit Cost x Units Sold
- Vendor Coverage % is the percentage of the promo the vendor will cover
- Vendor Absorbs is Vendor Coverage % x Customer Discount
- Promo credit is the final calculation
Typically, a vendor will say they will cover a percentage of the promotion, say 50% of the promo.
This means that they will credit the customer back for 50% of the customer discount against the retailer's COGS.
A couple of examples:
1. Stiiizy says they will support 100% coverage of a BOGO sale on Stiiizy.
The retailer buys the units for $6 wholesale, they retail them for $20.
On sale, the BOGO means they are effectively selling two units for $20 ($10 each).
This is an effective 50% discount.
The retailer will be credited 100% of 50% of their COGS.
So for two units at $6 each wholesale, that is a total COGS of $12.
Stiiizy will provide a credit 100% x 50% x $12 = $6
2. Kiva says they will support 50% coverage of a 20% off sale on their products.
The retailer buys KIVA units for the units for $10 wholesale, they retail them for $16.
They sell 8 units with a 20% discount, with total net sales of
$102.40 (8 units x $12.80 [20% off $16])
The retailer will be credited 50% of 20% of their COGS.
So for 8 units at $10 each wholesale, that is a total COGS of $80.
Kiva will provider a credit 50% * 20% x $80 = $8
Vendor Coverage x Discount % x COGS.