This is a free delivery note template for goods you leave in a store on consignment. It comes as an Excel file (.xlsx) that calculates subtotals and totals for you, and as a PDF you can print and fill in by hand. Download it directly, with no sign-up.
What a consignment delivery note is, and why it matters
A delivery note travels with the goods when they move from a supplier to a business. It states what was handed over, how many units, at what price, and who received it.
In consignment selling it matters more than in a regular sale. The store does not pay when it receives the products. It pays when they sell. That makes the delivery note the only proof of what is sitting on the store’s shelves. Weeks later, when you settle accounts, every figure is checked against it. If it is missing or vague, each gap turns into an argument.
What the template includes
Header: note number, date, supplier details (name, phone, email) and store details (name, address, contact person).
A 15-row table with these columns:
| Column | What to write |
|---|---|
| # | Line number |
| Code | Your product code or SKU |
| Product | Name and size or variant |
| Quantity | Units delivered |
| Retail price | Shelf price of one unit |
| Subtotal | Quantity x retail price, calculated automatically |
Totals: total units and total value at retail price, both automatic.
Other fields: the agreed store commission (%), for reference only, and a notes area.
Signatures: a “delivered by” block and a “received by” block, each with name, signature and date. A line at the bottom states that the goods remain the supplier’s property until sold, as agreed between the parties.
How to fill it in, step by step
- Give the note a number. A simple sequence (001, 002, 003) avoids duplicates.
- Enter the delivery date, then the supplier and store details.
- Add one row per product: code, name, quantity and retail price. The subtotal fills itself.
- Check the unit and value totals against what you actually have in the box.
- Write down the agreed commission and any useful detail in the notes, such as “display by the register”.
- Count the goods together with the store contact before signing.
- Both sides sign. Print two copies, one for each party. If you use the Excel version, save the file too.
A worked example (illustrative numbers)
Made-up figures to show how it looks:
| # | Code | Product | Quantity | Retail price | Subtotal |
|---|---|---|---|---|---|
| 1 | CAN-01 | Soy candle 200 g | 12 | 10 | 120 |
| 2 | SOA-04 | Handmade soap | 20 | 4 | 80 |
| 3 | HON-02 | Honey jar 250 ml | 6 | 8 | 48 |
Total units: 38. Total value at retail price: 248. If the agreed commission were 30%, that figure is only noted for reference. The real settlement happens when the store reports what it sold.
Common mistakes
- Signing without counting. A signed note with quantities nobody checked protects neither side.
- Prices that change later. If the retail price moves, issue a new note or write the change down with a date.
- Vague descriptions. “Assorted items” is useless. Use codes and clear names.
- Keeping a single copy. If the store holds the only copy, you have nothing to check against.
- Leaving out the commission. Even as a reference, writing it down avoids confusion about what gets deducted.
Once the note is done, the next job is tracking what sells. The consignment tracking spreadsheet is the companion to this template. You can also read how to sell products on consignment to stores.
When a spreadsheet stops being enough
For one or two stores, this note and a tidy folder are fine. The trouble starts as you grow. With five or ten stores, each with deliveries, returns and restocks, there are many files to maintain and cross-check by hand. One lost note, one missing count or an old version of the Excel is enough to throw the numbers off. That is the point to consider something more organized.
Frequently asked questions
What should a delivery note include?
A number and date, the details of who delivers and who receives, the product lines (code, description, quantity, price) and signatures. For consignment goods, add a line saying the products stay the supplier’s property until they are sold.
Is a delivery note the same as an invoice?
No. A delivery note records that goods were handed over. It does not replace an invoice. Invoicing rules depend on each country, so check with an accountant how to document your sales.
Can I use this in Word?
The file is Excel (.xlsx), and there is also a printable PDF. If you prefer Word, you can copy the table across, but you would lose the automatic calculations.
How many products fit on one note?
The template has 15 rows. If you deliver more, fill in a second note with its own number and mention it on both.
Keeping track with less paperwork
If you already work with several stores, COMPA lets you register each delivery, has stores report their counts through a simple link without creating an account, and reconciles what was delivered, sold and returned. It also produces account statements and records payments and replenishment.