- Gross sales
- Claybourne-branded product sales from QuickBooks, before discounts, credit memos and slotting fees.
- Discounts
- Discount lines on invoices. Shown as a negative number.
- Credit memos
- Credit memos issued to the customer. Shown as a negative number.
- Slotting fees
- Slotting fees paid to the customer. Shown as a negative number.
- Net sales
- Gross sales plus the three negative lines.
- All discounts
- Discounts, credit memos and slotting fees added together, as a positive number.
- Discount rate
- All discounts divided by gross sales, from the summed dollars. Left blank above 150%.
- Discount rate by customer
- Credits and discounts divided by gross sales for one customer in one month. The first column is the month in progress. Only customers with sales in the 13 months show.
- (Blank)
- In a filter list: rows whose rep, state or banner is not in that list. Power BI shows the same item.
This page is a copy of the Power BI Credits & Discounts page. The numbers come from the same Snowflake views, with the same rules. The two upper tables use different sources, so their rates can differ for the same month.