DSD Reconciliation and Scan Data Rebates: Stop Leaving Money on the Table

DSD - direct store delivery - is how most of your convenience store inventory arrives. Coca-Cola, Pepsi, Frito-Lay, bread distributors, beer distributors, and snack vendors all deliver directly to your store, stock the shelves, and leave an invoice. Unlike fuel deliveries where you have ATG readings to verify volume, DSD relies on you trusting the vendor's invoice.

That trust costs convenience store owners money. DSD vendor errors - wrong quantities, wrong pricing, missing credits for returns, unapplied promotional pricing - are common and typically favor the vendor. On top of that, scan data rebate programs offered by manufacturers go unclaimed by thousands of c-store owners every year.

What Is DSD Reconciliation?

DSD reconciliation is the process of verifying every vendor delivery invoice against what was actually received, at the price actually agreed upon, with all credits properly applied. It is the convenience store equivalent of jobber reconciliation for fuel.

The DSD Reconciliation Process

1. Receiving verification: When a vendor delivers, an employee should check the delivery against the invoice - item by item, quantity by quantity - before signing. In practice, most stores sign without checking because the delivery happens during a busy shift
2. Invoice capture: Every DSD invoice should be scanned or photographed and entered into your accounting system the same day
3. Price verification: Compare invoiced prices against your vendor agreement or purchase order. Price increases should be communicated in advance; surprise increases on the invoice are common
4. Credit tracking: When you return damaged, expired, or unsold product, the vendor should issue a credit. Track every return and verify the credit appears on the next invoice or statement
5. Statement reconciliation: Monthly, reconcile the vendor's statement against your records of invoices paid and credits due

Common DSD Errors That Cost You Money

• Quantity discrepancies: Invoice says 5 cases, you received 4. If no one checks at receiving, you pay for product you never got
• Price overcharges: Invoiced at $24.99/case instead of the agreed $22.99. A $2/case overcharge on 20 cases/week is $160/month
• Missing return credits: You returned 3 cases of expired product but the credit never appeared. At $25/case, that is $75 lost
• Unapplied promotions: The vendor ran a buy-10-get-1-free promotion but billed you for all 11 cases
• Duplicate invoices: The same delivery invoiced twice, especially when a driver swaps routes or a substitute driver delivers

Individually, these errors are small - $50 here, $100 there. Across 10-15 DSD vendors delivering 3-4 times per week, they compound to $500-2,000/month in invisible margin loss.

Scan Data Rebates: Free Money Most C-Stores Miss

Scan data rebate programs pay convenience store owners a per-unit rebate on qualifying products sold, based on POS scan data. Manufacturers like Altria (Marlboro), RAI (Camel, Newport), Anheuser-Busch, and others offer these programs to incentivize distribution and shelf placement.

How Scan Data Rebates Work

1. You enroll in a scan data program through a third-party administrator (Paytronix, Skupos, or your wholesaler's program)
2. Your POS scan data is transmitted daily or weekly to the administrator
3. Qualifying purchases and sales are matched against manufacturer rebate offers
4. Rebates are paid monthly or quarterly, typically by check or ACH

What Are Scan Data Rebates Worth?

For a typical convenience store:

• Tobacco scan data: $200-800/month depending on volume and participating brands
• Beverage scan data: $50-200/month
• Snack/candy scan data: $25-100/month
• Total potential: $300-1,100/month for a single store, or $3,600-13,200/year

Many independent gas station and c-store owners are not enrolled in any scan data program, which means they are leaving this money unclaimed. The enrollment process is straightforward and the ongoing effort is minimal once set up.

Accounting for DSD and Rebates

Proper DSD accounting requires:

• Recording each vendor invoice against the correct COGS category (beverages, snacks, tobacco, etc.)
• Tracking credits as accounts receivable until applied
• Recording scan data rebates as a reduction to COGS (not as revenue) so they flow through to category-level margins correctly
• Reconciling vendor statements monthly to catch unapplied credits

FuelCFO handles DSD vendor reconciliation and scan data rebate tracking as part of our category-level merchandise margin service. Book a free books review and we will identify how much you are leaving on the table.