AnalystBuilt home Etsy shop

Sewing & Apparel

Line Sheet Template & Wholesale Order Form

A line sheet with photo frames and swatches, a price list, your terms and an order form that checks MOQ, prepacks and minimums

Line Sheet Template & Wholesale Order Form: Line sheet, price list and order form from one style list
Line sheet, price list and order form from one style list
  • Line Sheet Template & Wholesale Order Form: Line sheet, price list and order form from one style list
  • An order form that checks itself: MOQ, prepacks, colors, sizes and your minimum, flagged as you type
  • Type each style once: One price feeds every page · MSRP from your multiplier
  • Everything a buyer asks for: Sizes, prepack, MOQ, ship and cancel dates, wholesale and MSRP
  • Your photos in the frames: Insert image in cell in Google Sheets; paste into the frame in Excel
  • Swatches by color name: 16 colors fill in by themselves; any other shade shows its name
  • A price list for reorders and reps: Same prices, no photos, with the effective date and version
  • Packs become sizes: The order confirmation lists the pieces per size

from $12.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Type each style once and get everything a boutique buyer asks for: a line sheet with photo frames and color swatches, a wholesale price list, your terms on one page and an order form that checks MOQ, prepacks and your order minimum while you type.

Made for small clothing brands, designers and sewing businesses that sell wholesale to boutiques and shops.

What's inside

  • Start Here

    Quick guide, your brand and contact details, season, version and price dates, MSRP multiplier, default MOQ, opening and reorder minimums, ship and cancel dates, size run, payment terms and draft wholesale terms

  • Line Sheet

    4 styles a page, landscape, with your brand header, minimums and payment terms on every page. Each style shows a photo thumbnail, style number and name, description, fabric, up to 4 color swatches, sizes, prepack, MOQ, ship and cancel dates, wholesale price, MSRP, retail margin and a status (New, Core, Carryover, Limited, Sold out)

  • Order Form

    Retailer and ship-to block, PO number, order type, ship window, 20 lines with quantities by size or by prepack, subtotal, discount, shipping, deposit and balance, signature lines

  • Order Summary

    A one-page order confirmation with packs turned into sizes, size totals and the money

  • Price List

    Every style on the line sheet in one table, no photos, for reorders and sales reps

  • Terms

    Minimums, payment, shipping, delivery and cancel dates, cancellation, returns and damages on one printable page

  • Styles

    Your style list with colors, size range, prepack per size, MOQ, wholesale price, MSRP, dates and checks

  • Retailers

    Your boutiques with buyer, email, phone, bill-to and ship-to addresses and payment terms

Why you'll like it

  • One master price per style: the line sheet, price list and order form all read it, so they never disagree
  • MSRP fills in from your multiplier (2.0 = keystone) when you leave it blank, with the retail margin next to it
  • Order lines flag unknown styles, sold-out styles, colors and sizes you don't offer, quantities below MOQ, sizes that don't match the prepack and styles that ship after the cancel date
  • Opening and reorder minimums are checked on the merchandise total, with how much is missing
  • Prepacks such as 1-2-2-2-1: type 3 packs and the order summary lists the pieces per size
  • Swatches fill in by color name for 16 common colors
  • Prints cleanly to PDF for email (Excel prints all pages at once; in Google Sheets you print the line sheet one page at a time, each on one sheet). Every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • line-sheet-template-excel.zip — Excel version

Good to know

  • Comes with a sample brand (16 styles, 3 boutiques, one opening order) so you can see every part working; Start Here shows how to clear it.
  • The garment pictures are simple sample sketches, not product photos. Paste your own photos into the frames: Google Sheets and Excel both work.
  • Up to 40 styles on the line sheet (10 pages), 30 retailers and 20 lines per order. Sizes are editable: XS to 3XL and one size by default.
  • Any currency symbol. The terms text is a draft to start from: edit it to match your business.
  • A spreadsheet line sheet: one row per style with a photo thumbnail, swatches and prices, not a lookbook layout.
  • One order at a time on the Order Form: save each as PDF or duplicate the tab. To track many orders through production, see my Wholesale Production Order Tracker.
  • Setting wholesale prices? My Garment Costing & Batch Quote works out the cost per unit and a price at your margin.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • Using a Mac?
  • For use in one business. Please do not resell or share the files.

A business tool, not legal, tax or accounting advice.

Designed by me with the help of AI tools.

View Line Sheet Template & Wholesale Order Form on Etsy

More in Sewing & Apparel