Free wholesale order form template for Excel
A ready-to-use order form that adds up line totals, VAT and the order total. Add your details once, then use it for every order.
Download the templateExcel file, 8 KB. No sign-up or email needed.
| Code | Product | Qty | Price | Total |
|---|---|---|---|---|
| SS-101 | Navy Crew Neck T-Shirt | 12 | £3.50 | £42.00 |
| Subtotal | £42.00 | |||
| VAT at 20% | £8.40 | |||
| Total | £50.40 |
What you get in the template
Everything you need to take a trade order, on one A4 page.
Your business details
Your name and contact details at the top of every order.
Customer details
Customer, account number, phone, email and delivery address.
25 order lines
Code, product, size, quantity and unit price.
Automatic totals
Line totals, subtotal, VAT and total add up as you type.
A VAT rate you can change
Set to 20%. Change it if your products are charged differently.
Terms and signature
Space for your payment and delivery terms, and a signature.
How to use it
Download it
Open the file in Excel, and choose Enable Editing if asked.
Add your details
Type over the business name, contact details and terms.
Save your copy
Delete the sample line and save it as your blank form.
Take the order
Fill it in, then print it or save it as a PDF.
What to include on a wholesale order form
A clear form saves a phone call later.
Product codes
Codes stop mix-ups between similar products.
Sizes and quantities
Say whether quantity means single items, packs or cases.
Delivery address
Ask for it every time, as trade buyers may have several sites.
Payment terms
State when payment is due and how to pay.
A website that updates itself from your stock list.
A paper or Excel order form still has to be filled in, sent over and typed up. Handwriting and old prices cause mistakes.
With CatalogueGen, your buyers browse your stock on their phone and send the order. It comes to your email, written out line by line.
No card needed. Done-for-you set-up. Our team builds your catalogue. Free set-up for a limited number of new customers each month. Worth £149. To start, send your stock list to info@cataloguegen.com.
Frequently asked questions
Is the template really free?
Yes. Download it and use it as often as you like. There is no sign-up and we do not ask for your email address.
Does it work out VAT?
Yes. It adds VAT to the subtotal using the rate in the shaded box, which is set to 20%. Change the rate if your products are charged differently.
Why are the totals blank when I first open it?
If Excel opens the file in Protected View, choose Enable Editing. The totals then work themselves out.
Can customers order online instead?
Yes. With CatalogueGen, buyers order from a catalogue on their phone and the order comes to your email.