Inventory Tracking Excel
Automatically calculates remaining stock from incoming and outgoing movements, the low-stock alert, and total stock value.
Product Price List Excel Template
The product price list Excel template automatically calculates the selling price, the shelf price including VAT and the unit profit when you enter the purchase price and your target profit margin. With barcode, product code, category and supplier fields, it works both as a shelf label source and as a price list you can send to customers; rows with a low margin turn red.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 27 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Barcode / Product Code | For matching with barcode scanners and other templates. |
| Product Name / Category / Unit | The product's description and grouping. |
| Purchase Price | The unit price you pay the supplier (excluding VAT). |
| Profit Margin % | The profit rate you are aiming for. |
| Selling Price | Automatic: Purchase × (1 + Margin/100). |
| VAT % / Selling Price incl. VAT | Enter the rate; the shelf price the customer will pay is generated automatically. |
| Unit Profit | Automatic: Selling − Purchase. The amount that stays in your pocket per product. |
| Supplier / Validity | Which company you got the price from, and the date until which the list is valid. |
How to use it
- Download the file and delete the sample rows.
- Enter your products, their purchase prices and your target profit margin.
- Enter the VAT rate so the shelf price is generated automatically.
- Review the red rows where the margin is below 10%.
- Export the list as a PDF and send it to your customer or dealer.
Who is it for?
- Wholesalers and companies with a dealer network
- Retailers (shelf labels and price increase updates)
- E-commerce sellers (margin checks)
- Buyers comparing supplier prices
Frequently asked questions
How do I update all prices when a price increase comes?
Just update the purchase price column; the selling prices and the prices including VAT are recalculated automatically by the formulas.
Are profit margin and profit rate the same thing?
In this template, the margin is the percentage added on top of the purchase price (like cost + 45%). The gross profit rate calculated on the selling price is different and comes out lower.
How do I send the price list to a customer?
You can save the file as a PDF and share it. For lists that need to stay up to date, a digital catalog is more practical: one link, and the content is always current.
Is the barcode field required?
No. If you don't use a barcode scanner, you can leave it empty or enter your own product code.
Can I give different customers different prices?
You can add columns to the right such as "Dealer Price" and "Retail Price" and set up formulas the same way. If you want to give a single customer a special price for a specific job, with quantity, discount and validity date, use the price quote form Excel template instead of this list.
Related templates
Price Quotation Form
A printable quotation document for a single customer, with a validity date and discount and VAT calculated by formula; the list of quotes issued and the acceptance rate are on separate tabs.
Warehouse Count / Inventory Excel
Compares the quantity in your system with the physical count and automatically reports shortages, surpluses and the value of the loss.
Order Tracking Excel
Tracks orders by channel, status, amount and shipping tracking number; calculates delivery time in days.
Last updated: September 27, 2026
Search terms: product price list excelprice list templateprofit margin calculation excelprice list with barcode