BLOG · TEMPLATES
Furniture quotation template for custom pieces (Excel layout)
A quotation for a custom sofa, table or bed has to describe the piece as exactly as your workshop order does: size, frame, fabric or finish, every option, and the price of each. Below is a furniture quotation template laid out for Excel or Google Sheets. Copy the three blocks into a sheet, type in the formulas shown, and put your own prices in.
Block 1: the header
| Cell | What goes in | Example |
|---|---|---|
| A1 | Your company, address, phone, email | |
| A3 / B3 | Quote number | Q-2027-014 |
| A4 / B4 | Date | the day you send it |
| A5 / B5 | Valid until | =B4+30 |
| A6 / B6 | Client name, phone, email | |
| A7 / B7 | Delivery address, floor, lift or stairs | 3rd floor, no lift |
| A8 / B8 | Room or project | Living room |
Row 7 matters more for furniture than for most products. Stairs and narrow doors decide whether a sofa gets into the room.
Block 2: the lines
Headings in row 10, first line in row 11:
| Column | Heading | Example |
|---|---|---|
| A | # | 1 |
| B | Piece | Three-seat sofa |
| C | Model code | SOFA-3 |
| D | Size, W × D × H | 220 × 95 × 82 cm |
| E | Frame or wood | Oak legs, black stain |
| F | Fabric or finish | Fabric code and color, or COM |
| G | Grade | C |
| H | Options | Contrast welt, feather seat cushions |
| I | Qty | 1 |
| J | Unit price | from the price sheet |
| K | Options price | your price |
| L | Line total | =(J11+K11)*I11 |
If you price upholstery by fabric grade, add a second sheet called Prices: model codes down column A, grades across row 1, a price in each cell. Then column J fills itself:
=INDEX(Prices!$B$2:$I$200, MATCH(C11, Prices!$A$2:$A$200, 0), MATCH(G11, Prices!$B$1:$I$1, 0))
The same formula works in Excel and Google Sheets. Make the last grade column COM, for "customer's own material": the price of the piece without fabric. Type COM in the Grade column and the formula picks it up; write the yardage the client must send in the Fabric column. Upholstery makers such as LEE Industries take COM fabric sent through their dealers (LEE Industries).
Block 3: totals and payment
Labels in column K, formulas in column L, from row 31:
| Label | Formula |
|---|---|
| Subtotal | =SUM(L11:L30) |
| Discount | type the amount |
| Delivery | type the amount: curbside, room of choice, or full setup |
| Net | =L31-L32+L33 |
| Tax | =L34*$B$40 (tax rate in B40) |
| Total | =L34+L35 |
| Deposit | =L36*$B$41 (deposit share in B41) |
| Balance before delivery | =L36-L37 |
Keep the tax rate and the deposit share in their own cells, so you change them once and every quote follows.
Six terms for custom furniture
Write these in plain sentences under the totals. Change the wording to fit your shop.
- Lead time starts at approval. "Your piece goes into production when we have the deposit and your signed approval of fabric and finish. Delivery is [X] weeks after that."
- Samples are approved in writing. "Wood, leather and hand-applied finishes vary from piece to piece and from the sample."
- COM fabric. "Send [X] yards to our workshop by [date]. Patterned fabric may need more for matching."
- Changes after approval are re-quoted and can move the delivery date.
- Cancellation. Say what happens if the client cancels before production, and after it starts.
- Delivery. Say what the delivery price covers: carry in, unpack, place, take the packing away. Ask the client to measure doors, stairs and lifts against the sizes on the quote.
Four questions the quote answers before the client asks
What exactly am I getting? Every line carries size, frame, fabric and options. Two people reading it imagine the same sofa.
What will it look like? Attach a swatch photo, or better, a picture of the piece in the fabric and finish they chose. A list of codes is hard to picture.
When does it arrive? In weeks, and from which day.
Will it fit? The size on the quote, next to the client's door and stair sizes.
Where a configurator fits
A quotation template speeds up your side. A configurator lets the client do the first draft: they choose the model, size, fabric and grade, legs and options on your site, see the piece in 3D and watch the price change with each choice. You receive the order with every line of Block 2 filled in, and your team checks it instead of typing it.