Price List Template: Layouts, Examples and Update Tips
Price list template guide: the fields to include, layouts for products and services, a filled-in example, and how to update prices without confusing customers.
Quick answer: A price list template is a reusable document that shows your standard prices: business details, an effective date, item or service names with codes, descriptions, units, prices, any quantity discounts, tax notes and terms. Keep the master in a spreadsheet, export a dated PDF for customers, and update it on a regular schedule.
A clear price list answers the first question most customers have and saves you from writing the same quote over and over. This guide covers what a price list template should include, layouts for products and services, a filled-in example and how to update prices without causing confusion on invoices.
What Is a Price List?
A price list (also called a rate sheet, rate card, price sheet or menu of services) is a document listing the standard prices a business charges for its products or services. It is different from:
- A quote or estimate, which prices one specific job for one customer (see quote vs estimate and our quotation format guide).
- An invoice, which requests payment for goods or services already agreed or delivered.
- An order form, which customers fill in to order from the price list (see the order form template).
What Should a Price List Template Include?
| Section | Fields |
|---|---|
| Header | Logo, business name, contact details, title ("Price List 2026"), effective date, version |
| Category headings | Group items (for example, "Cleaning Services", "Add-ons") |
| Item rows | Code or SKU, name, short description, unit (each, hour, sq ft, month), price |
| Options | Sizes, tiers or variants with their own prices |
| Discounts | Quantity breaks, package pricing, trade discount |
| Tax note | "Prices exclude sales tax" or "Prices include VAT" |
| Terms | Minimum order, delivery or travel fees, payment terms, validity ("Prices valid until further notice" or a date) |
Price List Layouts by Business Type
Product price list
Best for retailers, makers, wholesalers and distributors. Use columns for SKU, product, size or variant, unit, price, and for wholesale lists also case pack and minimum order.
Service price list
Best for trades, salons, cleaners and agencies. List services with what is included, the unit (per hour, per visit, per room) and price. Use "from" prices when the final cost depends on the job.
Tiered or package price list
Best for subscriptions and creative services. Show three columns (for example Basic, Standard, Premium) with features in rows and prices at the top.
Menu-style price list
Best for cafes, food trucks and bakeries. Short names, simple prices, minimal text.
Price List Example
Sparkle Home Cleaning: Price List 2026 (effective Nov 1, 2026, version 3). Prices exclude sales tax where applicable.
| Code | Service | Unit | Price |
|---|---|---|---|
| STD-1 | Standard clean, 1 to 2 bedroom home | Per visit | $140.00 |
| STD-3 | Standard clean, 3 to 4 bedroom home | Per visit | $190.00 |
| DEEP | Deep clean (first visit or seasonal) | Per hour, 2-person team | $90.00 |
| MOVE | Move-out clean, empty home | From | $280.00 |
| ADD-OV | Inside oven | Each | $35.00 |
| ADD-FR | Inside fridge | Each | $30.00 |
| ADD-WIN | Interior windows | Per window | $6.00 |
Recurring discount: weekly visits 15% off, every two weeks 10% off. Cancellations with less than 24 hours' notice are charged 50% of the visit price.
From price list to invoice
A customer books a 3-bedroom standard clean every two weeks, plus oven and fridge on the first visit:
| Description | Qty | Rate | Amount |
|---|---|---|---|
| STD-3 Standard clean, 3-bedroom home | 1 | $190.00 | $190.00 |
| Recurring discount 10% (every two weeks) | 1 | -$19.00 | -$19.00 |
| ADD-OV Inside oven | 1 | $35.00 | $35.00 |
| ADD-FR Inside fridge | 1 | $30.00 | $30.00 |
| Total | $236.00 | ||
Using the same codes on the price list and the invoice makes it easy for customers to check charges. You can build this invoice in the free invoice generator, and if you charge sales tax, check the amount with the sales tax calculator.
Should You Show "From" Prices or Exact Prices?
Exact prices work when the product or service is standardized: a 60-minute massage, a printed mug, a monthly bookkeeping package for up to 50 transactions. "From" prices work when the job varies, such as painting, cleaning or design, because they set expectations without locking you into a number that may not cover a larger job. If you use "from" prices, list the factors that change the price (size, condition, materials, deadline) and an example so customers can estimate. A short line such as "Final price confirmed in a written quote" protects you, and the quote then becomes the basis of the invoice. Avoid hiding all prices behind "contact us" unless your work is truly custom, because many buyers will simply move on to a competitor who publishes numbers.
How to Set the Prices on Your List
A price list is only as good as the prices on it. For each item:
- Calculate the full cost: materials, labor, overhead share.
- Add your target margin. See how to price a product and cost-plus pricing.
- Compare with competitors and the value to the customer.
- Round to clean numbers and check that discounted prices still cover cost.
Service businesses that resell materials should also decide on a standard markup; our guide to materials markup explains common approaches.
How to Update a Price List Without Confusing Customers
- Review on a schedule, for example every January and whenever a key cost jumps. The Bureau of Labor Statistics Consumer Price Index and Producer Price Index are useful reference points for general cost inflation.
- Change the version and effective date on every new list.
- Give notice to regular customers (30 days is common) before the effective date.
- Honor existing quotes and contracts at their agreed price until they expire.
- Update every place prices appear: website, PDF, order forms, saved invoice items, POS.
- Archive the old version so you can answer questions about past invoices.
Our guide on how to raise prices includes sample notice emails.
Wholesale vs Retail Price List Example
Product businesses often keep two lists from the same spreadsheet. A maker selling a handmade candle might show:
| SKU | Product | Case pack | Wholesale (per unit) | Suggested retail |
|---|---|---|---|---|
| CN-08-CS | 8 oz candle, Cedar and Sage | 12 | $13.00 | $26.00 |
| CN-08-FA | 8 oz candle, Fig and Amber | 12 | $13.00 | $26.00 |
| TN-04-AS | 4 oz travel tin, assorted | 24 | $6.50 | $13.00 |
Wholesale terms below the table: minimum opening order $250, reorders $150, first order prepaid, then Net 30 for approved accounts, shipping billed at cost. Our guide on how to start a candle business shows how those prices are calculated from cost.
How to Build a Price List in a Spreadsheet
- Create a cost sheet with columns for item code, materials, labor and overhead per unit.
- Add a price sheet that pulls the cost by code and applies your markup or margin with a formula, then rounds (for example to the nearest $0.50).
- Add discount columns for wholesale or quantity breaks calculated from the base price.
- Create a customer-facing tab that shows only code, name, unit and price, with the header, effective date and terms.
- Export that tab as a PDF named with the date, for example "Price-List-2026-11.pdf".
When costs change, update the cost sheet and every price updates with it, so you can see the effect before publishing. Saving the same item names and prices in your invoicing tool keeps quotes, estimates and invoices consistent with the published list.
Common Price List Mistakes
- No effective date, so nobody knows which list is current.
- Unclear tax treatment (does the price include tax or not?).
- Vague units, such as "per job" without saying what a job includes.
- Too many options, which slows buying decisions.
- Old PDFs still circulating after a price change.
- Invoices that use different names or codes than the price list.
A well-built price list template makes quoting faster and invoicing more consistent. When a customer orders from your list, turn it into an invoice with the invoice generator on this site: it is free, needs no sign-up and creates a downloadable PDF in your browser. You can also browse ready-made layouts on the invoice templates page.
Frequently asked questions
What is the difference between a price list and a quote?
A price list shows your standard prices for all or many products and services, and you give the same list to many customers. A quote or quotation is prepared for one customer and one job, with specific quantities, discounts, taxes and an expiry date. Many businesses send a price list first, then a quote once the customer knows what they want.
Should a price list include sales tax?
For business customers, show prices before tax and note that tax is added where applicable. For consumers, local rules and expectations differ: in the US prices are usually shown before sales tax, while in the UK, EU and Australia consumer prices are generally expected to include VAT or GST. State clearly whether prices include or exclude tax.
How often should I update my price list?
Review it at least once a year and whenever supplier costs, wages or rent change meaningfully. Many businesses update prices at the start of the year or a new season. Put an effective date and version on every list, so customers and staff know which one is current, and archive old versions for reference when an old quote is questioned.
How do I tell customers about a price increase?
Give advance notice, often 30 days for regular clients, explain the reason briefly (higher costs, expanded service), and state the effective date. Honor quotes and contracts already signed at the old price. Send the new price list with the notice so customers can plan orders. Some businesses let loyal customers place one final order at the old price.
Should I put prices on my website?
Publishing prices filters out customers who cannot afford you and reduces time spent on quotes. Many service businesses that do custom work publish starting prices or packages instead of exact prices. If your prices vary a lot by job, a from price with examples of what affects cost is a good middle ground.
What is a wholesale price list?
A wholesale price list is a version of your price list for retailers or resellers who buy in quantity to resell. It shows wholesale unit prices, usually lower than retail, along with minimum order quantities, case packs, suggested retail prices, payment terms and shipping terms. Keep it separate from your retail list and share it only with approved trade customers.
What file format is best for a price list?
Maintain the master in a spreadsheet so you can update prices with formulas and keep SKUs consistent, then export a PDF to send to customers. PDF keeps the layout fixed and is easy to print or attach to emails. For a website, publish the list as a normal web page rather than a PDF so it is easier to read on phones.
Can I offer volume discounts on a price list?
Yes. Add a quantity break table, for example 1 to 9 units at the full price, 10 to 49 at 5 percent off and 50 or more at 10 percent off. Make sure every discounted price still covers your cost and margin. Show the discount clearly so the invoice matches the price list and the customer is not surprised.
Invoice Creator Editorial Team
Guides on invoicing, cash flow and small-business finance from Invoice Creator, operated by Next Software Development Company. Content is reviewed for accuracy against the fields our own invoice generator produces.
Try the invoice generator