Price List Template (Free Template)
Use this price list template to keep your cost, selling price and margin for every product in one place, so your pricing is deliberate and you can share a clean, professional price list with customers.
| Product | Code | Cost price (KES) | Selling price (KES) | Margin % | VAT? | Notes |
|---|---|---|---|---|---|---|
| Cooking oil 1L | CO-001 | 230 | 300 | 23% | Yes | . |
| Sugar 2kg | SG-002 | 160 | 180 | 11% | Yes | Low margin, high volume |
| ... | ... | ... | ... | ... | ... | ... |
Example rows shown. Download the CSV for a blank version to fill in, or open it in Excel or Google Sheets.
How to use the price list template
- 1List products and costsEnter each product, its code and what it costs you.
- 2Set selling pricesSet a selling price and let the template show the margin, so you price deliberately, not by guesswork.
- 3Check your marginsSpot thin-margin lines and decide whether to reprice or rely on volume.
- 4Share with customersShare a clean version (without cost) with customers as a professional price list.
- +Price on margin, not a flat markup, so thin lines do not slip through.
- +Review prices when supplier costs change.
- +A clean price list looks professional and speeds up quoting.
Frequently asked questions
List each product with its cost and selling price, and calculate the margin. This template does the margin for you, so you can see at a glance which products are priced well and which are too thin.
Price on margin, the share of the selling price that is profit, rather than a flat markup. Margin is what determines whether the business is profitable, and it stops thin lines slipping through unnoticed.
Whenever supplier costs change. If your cost rises and your price does not, your margin quietly shrinks, so reviewing prices against current costs protects your profit.
Yes. Share a clean version that shows products and selling prices, without your cost or margin. A professional price list speeds up quoting and looks credible.
Veira holds the cost, price and margin of every product, so your pricing is always current and you can see margin per product without rebuilding a price list by hand.
Veira records sales, stock and payments automatically, so this runs itself. From KES 2,999 a month, with a free terminal.