Try Updoot Free

When spreadsheets get messy, try Updoot

← Back to BlogHow smart managers are never chasing timesheets again.Never chase timesheetsShow me

Price List Template: Free Template for Small Businesses

Price List Template: Free Template for Small Businesses
Share LinkedIn Facebook

Quick Answer

A price list shows what your business charges for each product or service: item or service name, description, unit, price and any options, packages, minimums or volume discounts, with an effective date. Keep one master price list based on your costs and target margins, use it for quotes, invoices, your website and your POS, update it on a set schedule and make sure every employee quotes from the current version.

A customer calls and gets one price from one employee and a different price from another. A quote goes out using last year's rates. The website shows a price you changed months ago. Without one current price list, pricing mistakes cost money and customer trust.

This guide includes a free price list template and explains what to include, how to set prices from costs and margins, how to handle packages and wholesale pricing and how to keep one master price list up to date.

What Is a Price List?

A price list is a document that shows the prices of your products or services. Businesses use two kinds: an internal master price list, often with costs and margins, and a customer-facing price list or menu that shows only prices and descriptions.

Internal master price listCustomer price list
AudienceOwner and staffCustomers
Includes costs and marginsYesNo
Includes internal codesYesSometimes
FormatSpreadsheetPDF, web page, menu or brochure

Free Price List Template

[Business Name] Price List
Effective date: ______  |  Prices subject to change  |  [Contact information]

Item / serviceDescriptionUnitPriceNotes
Standard service callDiagnosis and first 30 minutesPer visit$
Additional laborPer technicianPer hour$
Product A[Size/color/options]Each$Volume discount over 10
Package: Basic[What's included]Per month$
Add-on[Description]Each$

Internal Master Price List

SKU / codeItemUnit costPriceMargin %Last updatedNotes

Keep the internal version private. Share the customer version on your website, in quotes and at the counter.

What to Include

ElementWhy it matters
Item or service nameClear, consistent names
DescriptionWhat's included, size or scope
UnitEach, hour, square foot, month, visit
PriceThe current price
Options and add-onsUpsells and customization
Minimums and volume pricingClear rules for larger orders
Effective dateShows which version is current
TermsTaxes, deposits, travel fees, expiration

Setting Prices From Costs and Margins

Start with your costs, then add the margin you need.

  1. Calculate the direct cost of each product or service: materials, labor and any direct fees.
  2. Add a share of overhead.
  3. Decide your target profit margin.
  4. Calculate the price.
  5. Compare with competitors and the value to customers.

Price from margin: Price = Cost ÷ (1 − target margin)
Example: A product costs $30 and your target margin is 40%. Price = $30 ÷ 0.60 = $50.

Don't confuse markup and margin. A 40% markup on $30 is $42, which is only a 28.6% margin. See markup vs. margin.

CostTarget marginPrice
$1050%$20.00
$3040%$50.00
$10035%$153.85
$25030%$357.14

Service Price Lists

Service businesses often combine several pricing methods:

MethodExampleBest for
Hourly rate$95 per hourVariable work
Flat rate$189 water heater flushRepeatable tasks
Per unit$0.35 per square footCleaning, painting, flooring
PackagesBasic, Standard, PremiumRecurring services
Minimum chargeTwo-hour minimumSmall jobs

For services, include what's included and what isn't, such as materials, travel or disposal.

Product Price Lists

Wholesale vs. Retail Price Lists

RetailWholesale
CustomersEnd consumersBusinesses that resell
PricingFull priceDiscounted
MinimumsUsually noneMinimum order quantities
TermsPay at purchaseOften Net 15 or Net 30
TaxSales tax usually appliesResale certificates may apply

Keep wholesale and retail lists separate, and only share wholesale prices with approved wholesale customers. Ask your accountant or state tax agency about sales tax and resale certificates.

Packages and Add-Ons

Packages make buying easier and can raise average sale size. A common approach is three tiers, with the middle one designed as the best value.

PackageIncludesPrice
BasicCore service$
StandardCore service + popular add-ons$
PremiumEverything + priority service$

List add-ons separately so customers can build what they need.

One Master Price List

Every price your business uses should come from one master list. That list feeds:

In a spreadsheet, lookup formulas can pull prices from the master list into quotes and invoices automatically. See how to use VLOOKUP in Google Sheets.

Updating Prices

  1. Review costs on a set schedule, such as quarterly.
  2. Update the master list and change the effective date.
  3. Update every system that uses prices.
  4. Notify customers when prices change. See the price increase letter.
  5. Remove old price lists from circulation.

Sharing the Price List With Staff

Example: A Landscaping Company

A landscaping company's crew leads quoted prices from memory, and two customers on the same street paid very different amounts for the same service. The owner created a master price list with per-visit and per-square-foot prices, three seasonal packages and clear add-ons, and connected it to the quote template. Pricing became consistent, and the average job size went up as customers chose packages.

Common Price List Mistakes

Price List Checklist

StepDone?
List every product and service with units
Calculate costs and set prices from target margins
Add packages, add-ons and minimums
Create internal and customer versions
Add an effective date
Connect the master list to quotes, invoices and POS
Review prices on a set schedule

Price List Examples by Business

Cleaning Service

ServiceUnitPrice
Standard clean (up to 1,500 sq ft)Per visit$
Deep cleanPer visit$
Inside fridgeAdd-on$
Inside ovenAdd-on$
Weekly plan discountPer visit−$

Bakery

ItemUnitPrice
CupcakesDozen$
Custom cake, 8-inchEach$
CookiesDozen$
Custom messageAdd-on$

Handyman or Trades

ServiceUnitPrice
Service callPer visit$
LaborPer hour$
Fixture installationEach$
MaterialsAt cost plus markup—

Use these as a starting point and set your own prices from your costs and margins.

Spreadsheet Setup for a Master Price List

Discount Rules

Discounts can quietly erase margins. Write down when discounts are allowed and who can approve them.

DiscountRuleApproved by
Volume10+ units: 5%Automatic
Repeat customerPer programManager
One-time adjustmentUp to 10%Owner

Showing Prices on Your Website

Publishing prices, or at least starting prices, helps customers decide faster and reduces calls from people who aren't a fit. If your work varies too much to list exact prices, show ranges or "starting at" prices and explain what affects the final price.

Price List Formatting Tips

Reviewing Margins on Your Price List

Once a quarter, compare each item's price to its current cost. Supplier increases, wage increases and higher overhead can shrink margins without any change to your prices. Flag items below your target margin and decide whether to raise the price, reduce cost or drop the item.

Getting Started This Week

  1. List every product and service.
  2. Add current costs.
  3. Set prices from target margins.
  4. Create a customer-facing version.
  5. Replace old lists everywhere they're used.

Sample Completed Master Price List

CodeItemCostPriceMarginUpdated
SVC-01Service call$38$9560%Jan
SVC-02Additional hour$42$11062%Jan
PRD-10Filter, standard$6$1867%Mar
PKG-BBasic maintenance plan (monthly)$12$2959%Jan

This sample uses made-up numbers. A quick scan shows margins by item and when each price was last reviewed.

Pricing for Rush Jobs and After Hours

Rush, weekend, holiday and after-hours work usually costs more to deliver because of overtime and disruption. Many businesses list a rush or after-hours rate or fee on their price list so customers know in advance. Make sure the extra charge covers any overtime you pay. See overtime and holiday pay in the same week.

Price Lists for Quotes and Bids

Even for custom work, a price list of standard rates and unit prices makes quoting faster and more consistent. Estimators build quotes from the list, then add job-specific items. When prices change, every future quote updates automatically if the quote template pulls from the master list. See the contractor quote template.

Common Questions About Price Lists

Price List Quick Tips

Updating Prices Without Confusing Customers

A clean switch on one date avoids customers seeing different prices in different places.

Using Price Lists With Sales Reports

Compare your price list with what actually sells. Items that rarely sell may be priced too high or not needed. Best sellers with low margins may be worth a small price increase. Review sales by item each quarter alongside your margins to decide what to change. See software for tracking sales.

Price List for Employees vs. Customers

Some businesses offer employee discounts. If you do, list them in a separate internal sheet with clear rules, such as which items qualify and any limits, and keep them off the customer list. Discounts given to employees may have payroll tax implications; ask your accountant.

A Price List Is a Living Document

Your costs, customers and competitors change, and your price list should keep up. With one master list, a regular review schedule and clear rules for discounts, pricing stops being a source of mistakes and becomes a tool for protecting your margins.

Price Lists for Seasonal Businesses

Seasonal businesses, like landscaping, pool service, snow removal and holiday retail, often use seasonal price lists. Set prices before the season starts, publish them early and use packages or prepaid plans to lock in customers. Review results at the end of the season to set next year's prices.

Price List Records

Keep every past version of your price list with its effective date. Old lists help when a customer disputes a past charge, when you're reviewing how prices changed over time and when you're planning the next increase.

Pricing and Your Brand

Prices tell customers something about your business. Very low prices can suggest lower quality, and confusing price lists can feel untrustworthy. A clear, consistent and well-designed price list helps customers understand your value and makes them more comfortable buying.

Making Your Price List Easy to Read

Use clear headings, consistent units and plenty of white space. Put the most popular items or packages first, and keep fine print to a minimum. Test the list by asking someone outside the business whether they can quickly find a price and understand what's included.

Printing and Sharing Your Price List

Whatever format you use, make sure the effective date is visible so everyone knows which version is current.

Price List for New Services

When you add a new service, estimate its costs carefully, price it from your target margin and mark it as new on the list. Review its actual costs after the first few jobs and adjust the price if needed.

Who Owns the Price List?

Assign one person, usually the owner or office manager, to maintain the master price list. They update costs, approve price changes, publish new versions and make sure old copies are removed. Clear ownership keeps the list accurate and prevents staff from creating their own versions.

That person should also review the list with you every quarter, compare prices to current costs and flag anything that needs to change before it affects your margins.

Small, regular updates are easier for customers to accept than rare, large ones.

Keep the list simple and current.

Keep Pricing Consistent With Updoot

Updoot's invoice generator uses consistent pricing on every invoice, and SOP management keeps your pricing rules and discount approvals where your team can find them. Check your margins with the gross margin calculator.

Related Reading

Markup vs Margin →

Price Increase Letter →

Gross Margin Calculator →

Frequently Asked Questions

What is a price list? ▶
A list of what your business charges for each product or service.
What should a price list include? ▶
Name, description, unit, price, options, minimums and an effective date.
How do I set prices from margin? ▶
Price = cost ÷ (1 − target margin).
What is the difference between markup and margin? ▶
Markup is a percentage of cost; margin is a percentage of price.
Should I have separate wholesale and retail price lists? ▶
Yes, and share wholesale prices only with approved wholesale customers.
How often should I update my price list? ▶
Review costs and prices on a set schedule, such as quarterly.
Should my price list include costs? ▶
Only the internal version. Customer price lists show prices only.
How do I keep staff using the right prices? ▶
Keep one master list in a shared place and remove old copies.
Should I put prices on my website? ▶
Showing prices or starting prices helps customers decide faster.
How do I calculate margin in a spreadsheet? ▶
Use =(Price-Cost)/Price.

Ready to try Updoot free?

Keep pricing consistent on every quote and invoice. Free to start.

Start Free Today