Free Download · Back Office · PDF + Excel worksheet

Free Download: Vendor Reconciliation Worksheet

Your top 5 vendors (McLane, Core-Mark, Reyes, your fuel jobber, your dairy) bill you wrong 2-4% of the time. That's $1,500-$4,000/store/year in overcharges most operators never recover. This worksheet catches it in 15 minutes per delivery.

What's Inside

  • The Vendor Reconciliation Worksheet (Excel): drop in your BOL, your invoice, and your actual count — get the variance, the $ impact, and a credit memo request auto-generated
  • The Top Vendor Cheat Sheet: the specific error patterns of McLane, Core-Mark, Reyes, Eby-Brown, and major fuel jobbers (because every vendor errs in predictable ways)
  • The dispute escalation script: exact email language and phone tree contacts for filing a credit at each major vendor
  • The 'silent shortages' guide: the 12 most common ways vendors quietly overcharge you — short-shipping, promo not applied, wrong case pack, freight markup
  • The Quarterly Reconciliation Review: how to look across 90 days of deliveries and spot the patterns that one delivery won't show

Who This Is For

  • Operators getting weekly deliveries from McLane, Core-Mark, Reyes, Eby-Brown, S. Abraham, or any major c-store distributor
  • Gas stations dealing with branded jobber pricing (BP, Shell, Chevron, Sunoco)
  • Multi-unit owners who can't personally check every delivery anymore
  • Operators whose monthly variance is creeping up but they can't pinpoint where

Why It Matters

The c-store wholesale model is built on volume and trust — and that trust gets exploited. Industry studies put vendor billing errors at 2-4% of invoice value across food, candy, beverage, and tobacco. On a store doing $80K/month in cost-of-goods, that's $1,600-$3,200/month you're overpaying.

This worksheet doesn't fix vendor errors — it documents them. And documentation is the only thing that gets you credits. Operators who run this consistently typically recover 60-80% of overcharges within 30 days.

Disclaimer
DohAssist is an independent service provider. This worksheet is provided for educational purposes only. References to specific vendors (McLane, Core-Mark, Reyes, Eby-Brown, S. Abraham, BP, Shell, Chevron, Sunoco) are made solely to describe the industries we serve. We are not affiliated with, endorsed by, or sponsored by any of these companies. All trademarks remain property of their respective owners.

Get Your Free Download

Tell us a little about your operation. Your download starts immediately and we'll also email you a copy.

By downloading, you agree to receive occasional operational insights from DohAssist. We may follow up by phone or text. Unsubscribe anytime.

Want every delivery reconciled automatically against your BOL?

DohAssist pulls vendor invoices, matches them against POS receipts and delivery logs, and surfaces credit-worthy variances every Monday morning. See it on a 20-minute call.

📞 Call Book Strategy Call →