Home and property

Tile quantity, wastage and leftover boxes: keeping the order sheet

A tile order sheet that records area, boxes ordered, used and returned, plus batch numbers kept for later repairs, so you never pay twice.

Editorial illustration for Tile quantity, wastage and leftover boxes: keeping the order sheet

Keep a one-page tile order sheet: area to cover, tile size, boxes ordered, boxes used, boxes left over or returned, and the batch number printed on each box. It stops you paying for the same tile twice and lets you match a broken tile years later.

How do you work out how many boxes to order?

Start with the floor or wall area in square feet, add an allowance for cutting and breakage, and divide by the area in one box. Ask the dealer what allowance suits your layout, since diagonal patterns and rooms with many corners waste more than plain straight laying. Use the figure the dealer and the tiler agree on; the ten percent below is only a placeholder.

Worked example with invented numbers. Floor area to cover: 450 square feet. Allowance: 10 percent, so 450 × 1.10 = 495 square feet. Each tile is 2 feet by 2 feet, which is 4 square feet, and a box holds 4 tiles, which is 16 square feet. Boxes needed: 495 ÷ 16 = 30.9, so order 31 boxes.

What goes on the order sheet?

FieldExampleWhy it matters
Area to cover450 sq ft, two bedrooms and passageBasis for the quantity
Tile size and finish2 x 2 ft, matt vitrifiedNeeded to match later
Shade or design codeAs printed on the boxSame name can come in different shades
Batch or lot numberWritten from each box labelTiles from different batches can differ in colour
Boxes ordered31Compare with delivery challan and bill
Boxes used and returned29 used, 2 leftShows what you paid for versus what went down

Why does the batch number matter?

Tiles from separate production lots can differ slightly in shade or size even when the name and code are the same. If you need to replace a cracked tile in two years, the leftover box from the original batch is your best match. Photograph the label on every box on delivery, and write the batch numbers into the sheet. Mixing batches in one room is a reason to ask the dealer before laying.

What should you do with leftover boxes?

  1. Count boxes at delivery and again after the tiler finishes.
  2. Ask the dealer in advance whether unopened boxes can be returned, for how long, and at what deduction. Get the answer on the bill or in writing.
  3. Keep at least one unopened box per area for future repairs, labelled with room and batch.
  4. Return the rest within the dealer's stated window, with the bill, and note the credit or refund as a separate row.

What about the tiler's labour and other materials?

Keep them on the same sheet in a second table: adhesive, spacers, grout, skirting, and the tiler's charge. Tiler's labour is often quoted per square foot; record the rate and the measured area, and multiply them yourself. For 450 square feet at an invented ₹60 per square foot, labour is 450 × 60 = ₹27,000. Confirm whether the rate covers the cutting and the waste, since some tilers measure only the finished area.

Where does a tracker help?

SpendixAI can hold the dealer's payments, the refund for returned boxes and the tiler's instalments under a custom category for the flat, with the delivery challan and bill kept on each transaction. If you ordered and paid in cash, add those entries by hand so the record is complete.

After the work is done

  • Final box count matches the sheet.
  • Batch numbers and one sealed box stored in a dry place.
  • Dealer's return or credit note filed with the bill.
  • A photo of the finished floor with the date, for your records.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports