The general goal of the RevLoss Summary is to better visualize revenue loss at Walmart, so that you can understand where you're losing dollars, why, how you're trending over time, and how effective your dispute efforts are.
FAQ
What determines the month that dollars are shown by?
The RevLoss Summary groups dollars based on the time period that the supplier billed Walmart, including any related deductions, OTIF and SQEP fines, and dispute approvals to those invoices.*
This helps you see, out of the dollars I billed Walmart this month, how much did I ultimately get paid, after applying all deductions, fines, and dispute approvals related to that month's invoices.
*Return deductions and other AP deductions that are unrelated to a specific supplier invoice are grouped based on the claim date of the deduction on the RevLoss Summary.
How is Revenue determined?
Gross Revenue is based on the total invoiced amount of all invoices that have appeared on a Walmart check. This includes invoices that were completely deducted, partially paid, or completely paid. Revenue dollars are grouped into a month based on the invoice date.
Net Total is the gross revenue minus any AP deductions and Compliance (OTIF and SQEP) fines that have not been won back via dispute.
Example
Johns's Hot Sauce billed Walmart $5M in March.
Gross Revenue
Gross Revenue for March = $5M
Net AP Deductions
$500K was deducted via AP deductions on the $5M of March invoices.
$400K of that was ultimately paid back from disputes.
Net AP Deductions for March = 500K - 400K = $100K
Net Compliance Fines
A $60K OTIF fine was issued for March orders.
A $20K SQEP fine was issued for March orders.
$10K was paid back from OTIF disputes.
Net Compliance Fine for March = 60K + 20K - 10K = $70K
Net Total
Net Total for March = 5M - 100K - 70K = $4.83M
A key point is that no matter when Walmart took the deduction, or when the dispute was submitted or approved, the dollars get related back to the month of the related invoice date.
What Revenue Loss ("RevLoss") is included?
AP deductions taken by Walmart against your invoices, and Compliance fines issued by Walmart are included as "RevLoss" on the RevLoss Summary.
NOTE: There are other chargebacks taken by Walmart including Collect Pickup Program charges, post audits, and other types that are not included today in the RevLoss Summary. Let us know if you'd like to see other charge types included!