Get a price

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.

  1. 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."
  2. Samples are approved in writing. "Wood, leather and hand-applied finishes vary from piece to piece and from the sample."
  3. COM fabric. "Send [X] yards to our workshop by [date]. Patterned fabric may need more for matching."
  4. Changes after approval are re-quoted and can move the delivery date.
  5. Cancellation. Say what happens if the client cancels before production, and after it starts.
  6. 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.