Free Price List Template
Build the price list you hand to buyers: sections, item codes, units, prices, an MSRP column and volume tiers. Raise every price by a percentage in one go, paste rows from a spreadsheet, then print it, save it as a PDF or download a CSV. No sign-up.
What a working price list includes
Your business and the date
Name, address and contact details, and the date the prices take effect. Buyers file lists; the date tells them which one is current.
A valid-until date
"Prices valid until" stops an old list being quoted back to you a year later.
Item codes
The codes buyers put on their orders. Use the same codes as your catalog and order form so nothing ships wrong.
Units
Each, case, box, kg, roll: a price means nothing until the buyer knows what it buys.
Volume tiers and MSRP
Lower prices from set quantities, and a suggested retail price for buyers who resell, so they see their margin.
Terms
Minimum order, payment terms and freight, written once at the bottom instead of argued on every order.
How volume (tier) pricing works on the list
Type the quantities where each lower price starts. Breaks of 10 and 50 give three tiers: 1–9, 10–49 and 50+. The first tier is the price column; each further tier gets its own column. A buyer ordering 24 cases pays the 10–49 price on all 24.
Keep the steps few and the breaks round. Two or three tiers are easy to quote on a call; seven are not.
Updating every price at once
Type a percentage (4 for a 4% rise, -5 for a cut) and choose the rounding: to the cent, to the nearest price ending in .99 or .95, or to the nearest whole number. Halfway values round up. The change applies to every price and tier price on the list; the MSRP column changes only if you tick it. Undo puts the list back.
Change the effective date and the valid-until date when you send the new list, and keep the old PDF, so you can answer "what was I paying in March?"
Working out what a rise does to your margin before you send it? Use the price increase calculator.
Tips for price lists buyers use
Send a PDF, keep the CSV
Buyers get a clean PDF they cannot edit by accident; you keep the CSV to import next time.
One list per customer group
Dealer, distributor and end-user prices belong on separate lists. Duplicate the list rather than hiding columns.
Say whether tax is included
Choose "Prices exclude tax" or "Prices include tax" so the buyer does not guess.
Paste from your spreadsheet
Copy the rows from Excel or Google Sheets in the column order shown and import them in one go, up to 500 items.
For reps who live by the price list: distributor sales, wholesale sales rep, manufacturer line card, what is a food broker.
The price list is the start. The buyer's questions are the sale.
Which items they reorder, the volume they would commit to for the next break, the freight terms they pushed back on: that comes out on the call or the store visit. Record it in ParrotNotes and get the summary and action items, so your quote and your next list answer what the buyer asked. Free for 100 minutes of recording a month.
Get ParrotNotes freeRelated tools
- Order Form TemplateFill in an order form with the customer, items, quantities, prices, tax, shipping and payment, then print it or save it as a PDF.Open the tool
- Quotation GeneratorBuild a clean price quote with line items, discount, tax and terms, then print it or save it as a PDF. Nothing to sign up for.Open the tool
- Price Increase CalculatorWork out a new price from a percentage increase, its effect on margin, and how much sales volume you can lose before profit falls.Open the tool
- Margin and Markup CalculatorWork out margin, markup and selling price from cost, convert markup to margin, and see what a discount does to your margin before you quote.Open the tool