What's the difference between a maker who's landed one wholesale order and a maker with twenty boutique accounts?
Almost nothing — except a piece of paper.
The piece of paper is called a line sheet, and most handmade sellers have either never made one or have a Word doc from 2022 in a folder somewhere with three SKUs that no longer exist. That paper is the difference between sounding like a hobby and sounding like a brand. It's also where most makers make their first wholesale pricing mistake — typing in a number that feels reasonable, sending the PDF off, and only later realizing the math underneath was off by a margin point that costs $4 a unit forever.
So here's the fix in one download: a working Excel line sheet, with the pricing math wired in behind it, and a sanity check that flags any SKU priced too low for wholesale before you ever send it. The rest of this post is a teardown of every cell, every formula, and the strategy behind each field — so when you replace the sample SKUs with your own, you'll know exactly what each one is doing and why.
Grab the template: Wholesale Line Sheet Template (Excel) — three tabs, formulas already wired, sample SKUs you can replace in five minutes.
If you haven't decided whether wholesale is even the right move for your business yet, the wholesale pricing for handmade products post covers minimums, margin floors, and when to say no. This post is what you grab once that question is answered yes.
What a line sheet actually is (and what it is not)
A line sheet is the document a buyer at a boutique, a museum store, or a regional gift shop reads to decide whether to carry your products. It is not a brochure. It is not your about page. It is a price list with terms — half the page is the prices, the other half is the rules of doing business with you.
Buyers see hundreds of these. The ones that get filed for follow-up have three traits in common:
- They look like a price list, not a story. Buyer's eyes go to the SKU table first. Tagline, story, and origin myth go on your website.
- The terms are at the top. Minimum opening order, lead time, payment terms — buyers screen on these before reading SKUs.
- Every price is dated. "Effective April 2026 — prices subject to revision quarterly" tells the buyer two things: that you take this seriously, and that you reserve the right to update prices when your costs move.
The template handles all three by default. You only need to fill in your numbers.
The three tabs (and what each one is for)
Open the template and you'll see three tabs at the bottom:
- Read Me — A walkthrough of how the workbook is laid out, the math behind the formulas, and a glossary of every term a buyer will see. Read once and never again.
- Line Sheet — The document you send to buyers. This is the one you'll print to PDF.
- Pricing Math — The per-SKU cost build-up that drives every price on the Line Sheet tab. This is where you do real work.
The relationship between Line Sheet and Pricing Math is the magic of the workbook. Every wholesale price, every MSRP, every case-pack number on the Line Sheet is a formula that pulls from Pricing Math. Change a multiplier on the math tab and the line sheet updates itself. Type a price directly onto the Line Sheet and you've broken the chain — don't.
The Pricing Math tab — every column, in plain English
This is where the actual pricing happens. The columns are color-coded: yellow cells are inputs (you change these), gray cells are formulas (you don't), and the rightmost column flags any SKU below a healthy wholesale margin in red.
Here's what each column does:
| Column | What it is | Where the number comes from |
|---|---|---|
| SKU | Your product code | You — keep it short, no spaces |
| Product name | What it is | You |
| Variant / size | The specific version (8 oz, lavender, etc.) | You |
| Materials cost | Raw materials per unit | Your recipe / recipe costing 101 |
| Labor (hrs) | Honest production time per unit | You — be honest, including cleanup |
| Labor rate | What you pay yourself per hour | You — start at $22/hr if unsure |
| Labor cost | Hours × rate | Formula |
| Packaging cost | Box, label, tissue, the bag, all of it | Your packaging line items |
| Overhead (%) | Studio, utilities, software as a % of direct cost | You — 10–15% is typical |
| Overhead $ | Overhead applied to this unit | Formula |
| True unit cost | Materials + labor + packaging + overhead | Formula |
| Wholesale × | Multiplier on cost (default 2.0×) | You |
| Wholesale price | True cost × wholesale multiplier | Formula |
| Retail × | Multiplier on wholesale (default 2.0×) | You |
| MSRP | Wholesale × retail multiplier | Formula |
| Case pack | How many units in a shipping unit | You |
| MOQ (units) | Minimum order quantity per SKU | You |
| WS margin % | (WS price − cost) ÷ WS price | Formula |
| Sanity check | "Below 50%" / "OK" / "High" | Formula — color-coded |
The two multipliers — wholesale and retail — are the levers that make this whole thing flexible. The defaults (2.0× and 2.0×) give you the gift industry's standard math: a 50% wholesale margin and keystone retail markup. Change the wholesale multiplier to 1.7× for food products and the formulas update everything downstream. Change the retail multiplier to 2.5× for a category that supports it and your MSRP moves to match.
The math in one line: Wholesale price = True unit cost × wholesale multiplier. MSRP = Wholesale price × retail multiplier. Everything else is decoration.
Why the 50% wholesale margin matters (and the sanity check that protects it)
The rightmost column of the math tab — the sanity check — is the single most important cell in the workbook. It flags any SKU where your wholesale margin drops below 50%, because that's the floor most retail buyers will work with.
Here's why it's a floor:
- A boutique that pays $10 wholesale needs to sell at $20 retail to keystone — a doubled markup, the math their whole business runs on.
- If they can't keystone, they don't take the line. Not because they're greedy, but because at 40% margin they can't pay rent on their store.
- That means your wholesale price has to leave at least 50% margin on top for the retailer's math to work. Below 50% retailer margin, the conversation ends.
So when the sanity check flags an SKU as "Below 50% — too low for wholesale," it's telling you one of two things has gone wrong:
- Your true unit cost is too high relative to your wholesale price (the multiplier is too low).
- Your retail price was set too low to begin with, which means wholesale at half of it leaves you with nothing.
Either way, the SKU isn't ready for a line sheet. Fix the cost or fix the price before the buyer sees it.
This is the check almost nobody runs by hand. The template runs it for you on every row.
The Line Sheet tab — what buyers actually see
Switch to the Line Sheet tab and you'll see the document a buyer will. Top to bottom, it's structured the way the gift industry expects:
The header block: Brand name (large), tagline (small, italic), and the magic words — "WHOLESALE LINE SHEET — Effective [date]." That date is non-negotiable. It's how you justify quarterly price revisions when your fragrance oil supplier raises rates.
The terms block: Seven rows that buyers screen on before they even read your SKUs.
| Term | What it does | A reasonable starting point |
|---|---|---|
| Contact | How to reach you | Real email, real phone, real website |
| Min. opening order | The dollar floor for a brand-new account | $200–$500 |
| Reorder min. | The floor for follow-up orders | $100–$200 |
| Lead time | Order to ship | 2–3 weeks |
| Payment terms | When and how you get paid | Prepay for first three orders, then Net 30 by application |
| Shipping | Who pays freight, how it ships | "FOB origin, ground prepaid and added" is the standard |
| Damages / returns | The window for problem-reporting | 7 days, photos required |
These aren't optional. A line sheet without an opening minimum is a line sheet that gets you a $40 wholesale order from a hobbyist friend of a friend that costs you $50 to fulfill.
The product table: SKU, product name, variant, case pack, MOQ, wholesale price, MSRP, available date, notes. That's it. Buyers do not need ingredient lists, your favorite scent stories, or a photo of you in your studio. Save those for the website.
The product table on the Line Sheet pulls from the Pricing Math tab via formulas. You don't type the prices on this tab. If you find yourself wanting to override one — say, a special closeout price — go back to Pricing Math and change the multiplier on that SKU. The Line Sheet will update.
What goes on the line sheet — and what stays off
This is the part most makers get wrong on their first attempt. Buyers do not need (and do not want) to see:
- Your cost of goods. They calculate their margin based on the wholesale-vs-MSRP gap, not yours.
- Your margin percentage. Same reason. Showing your margin is a negotiation against yourself.
- Process photos. A line sheet is a price list. The story sells the brand on Instagram; the price sells the order on the line sheet.
- More than two pages. A line sheet is a snapshot, not a catalog. If you have a hundred SKUs, send them a curated 20-SKU "current season" line sheet and a separate full catalog on request.
What buyers DO want, beyond what's in the template:
- A clean PDF. Print to PDF (File → Save As → PDF) with the Line Sheet tab set to landscape and "fit to one page wide." Don't send the Excel file unless they ask.
- Photos available on request. A line of small thumbnails next to each SKU is a "nice-to-have" for a v2 of your line sheet — but a buyer worth working with will ask for the photos separately and you can email a Dropbox link.
- A wholesale agreement. The line sheet sets the terms; the agreement is the legal document that codifies them. Different document, different post.
When to break the rules
The wholesale and retail multipliers are starting points, not laws. Here's where the defaults go wrong:
- Food products (jams, hot sauce, baked goods) tend to live at a 1.7–1.8× wholesale multiplier instead of 2.0× because retailers expect lower wholesale prices on consumables. Change the cell on each food SKU and let the formulas update. Make sure your true unit cost still leaves you margin at the lower multiplier — if it doesn't, food wholesale isn't viable for that product yet.
- Jewelry and high-perceived-value categories can hold 2.2–2.5× wholesale multipliers comfortably because the retail prices stretch.
- Kits and bundles sometimes price below the simple multiplier of their components — that's fine if the bundle creates retail value the components don't. The sanity check will still flag it if margin drops below 50%; that's the line.
- Custom labels or private label are not in the template by design. Those are quoted per-deal, not listed.
Whenever you change a multiplier, watch the sanity check column. If it stays green, you're fine. If it flips to red, you've priced below where wholesale works — and you have a real decision to make about whether wholesale is the right channel for that product at all.
How to send the thing
Once your numbers are filled in:
- Open the Line Sheet tab.
- Update the brand block (top-left), the contact line, and the terms rows. Replace the placeholder text — every
[your X]is something to change. - File → Save As → PDF. Set Sheet to Line Sheet, Orientation to Landscape, Scaling to "Fit to one page wide." Save with a filename like
[BrandName]-Line-Sheet-2026-Q2.pdf. - Email it. Two-line message: "Hi [Buyer], thanks for the interest. Attaching our current line sheet — minimums and terms on the cover. Happy to send product photos or answer specific category questions. Best, [you]."
- Save the PDF, with the date in the filename, in a folder. Quarterly, you'll regenerate it from the same Excel file with updated prices and a new effective date.
That's it. You have a line sheet. You're ready for a wholesale conversation.
When the spreadsheet stops being enough
The template will get you through your first ten wholesale accounts. After that, two things start happening that an Excel file doesn't handle gracefully:
- Your true unit costs change every time an ingredient supplier raises their rate, and the line sheet you sent last quarter no longer reflects what the candle actually costs you to make. You can keep the wholesale price the same — but your margin quietly compresses, and you don't see it until you do the math by hand at year-end.
- You start needing to apply different prices to different accounts (a long-time partner, a closeout SKU, a higher-volume buyer with a custom multiplier). Excel can do this, but it gets brittle fast.
This is roughly the moment Ardent Seller earns its keep. Pricing tiers — retail, wholesale, custom — live next to each product, tied to the recipe. When an ingredient cost moves, your wholesale floor moves with it, and the next line sheet you regenerate is built from current numbers instead of a memory of what costs were when you typed them in. Customer accounts hold their terms (Net 30, prepay) and their order history. The line sheet stays a snapshot you ship; the system underneath stays current. (The Ardent Seller features page walks through how the pricing tiers and recipe costing work in practice.)
For the first ten accounts, though, the spreadsheet is enough. Download the template, fill in your numbers, send the PDF, and keep the engine simple until the volume justifies an upgrade.
Now go land your first boutique.
Related reading
- Wholesale Pricing for Handmade Products — The strategic post behind the template: when wholesale is right, how to set minimums, when to refuse Net 30.
- Margin vs Markup — The pricing math mistake that quietly turns a 50% wholesale "margin" into a 33% one. Read this before sending the line sheet.
- Recipe Costing 101 — How to build the per-unit cost number that the Pricing Math tab needs as its input.
Free resources
A few free downloads from the Ardent Workshop library that pair well with this post:
- Wholesale Line Sheet Template (Excel, with Pricing Math) — The template this post is a teardown of. Three tabs, formulas wired in, ready to fill.
- Spreadsheet vs Inventory Software: The Decision Guide — Once you're past ten wholesale accounts, this is the question to answer next.
- Craft Seller Startup Checklist — The 36 things to set up before — and after — your first sale, including the pricing fundamentals the line sheet rests on.
This article is provided for educational purposes only and does not constitute financial, tax, or business advice. Cost structures, multipliers, and margin figures are illustrative starting points and will vary by your category, costs, and customers. Consult a qualified accountant or small-business advisor before making pricing or wholesale decisions based on this content.