Free Excel Template for Wine and Spirits Suppliers

The only distributor pricing template you will ever need.

Built from studying more than twenty-five real distributor price grids across the wine and spirits industry. One file that finally makes their logic visible: margins, allowances, taxes, and conversions in one place.

Instead of guessing how each distributor wants to see your numbers, you start with a model that already matches how they work.

Get the Free Template

You do not have a pricing problem. You have a clarity problem.

Pricing in this industry runs on spreadsheets. Every supplier has one. Every distributor has one. None of them look the same.

Suppliers send files that make sense to their finance teams. Distributors retype and reshape them into something their systems can accept. Somewhere in the middle, margins get fuzzy, errors creep in, and time disappears.

You do not need more cells, more tabs, or more versions of “final.” You need a shared way to see the numbers. A single grid that says,this is how distributors actually think about your pricing.

How we built the template

We collected price grids from more than twenty-five distributors: large and small, single-state and multi-state, legacy systems and modern platforms.

We looked at:

How they convert cases, bottles, liters, and gallons
How FOB, landed cost, and distributor margin are shown on one line
How depletion allowances and supplier programs are layered in
How freight, taxes, and fees are tracked without breaking the math
How sales teams see pricing and how finance teams audit it

Then we removed the noise, kept the patterns that work, and turned it into a single template any supplier can use to “speak distributor” from day one.

Why this matters

Every day, thousands of cases move based on spreadsheets like these. Most of them were built in a hurry, tweaked by three people, and never properly documented.

This template is not a theoretical model. It is a reflection of how distributors already structure pricing, brought into one clean grid.

You can keep reverse-engineering each distributor’s format one by one. Or you can start with a template designed around how the industry already behaves and use your energy on strategy instead of layout.

What is inside the template

When you download the Distributor Pricing Template, you get:

A master grid structure built from 25+ real distributor formats
Case, bottle, liter, and gallon conversion logic
FOB, landed cost, and distributor margin laid out on one line
Inputs for depletion allowances and supplier programs
Fields for freight and state taxes, including NY and PA friendly layouts
Sections for notes and internal reference so finance and sales can use the same file

No macros. No locked cells. No hidden tricks. Just a clear starting point that you can adapt to your portfolio and your distributors.

Download the Distributor Pricing Template

This template is free, but it is not anonymous.

If we are going to share something this valuable, we would like to know who we are helping. Just your name and email so we can send you the file and let you know when we release improvements.

We ask for your email for one reason: to send you tools that make pricing less messy and more predictable.