Skip to content
Controlbook
All posts
Academy· 6 min read

FF&E schedule template: what to include and why it matters

What a proper FF&E schedule template should contain, the formats that actually work in practice, and what the spreadsheet approach gets right — and wrong.

Max Beech
Design studio workspace with specification documents and FF&E schedule templates being reviewed

Search for "FF&E schedule template" and you'll find dozens of options. Most are basic spreadsheets with five or six columns: item name, supplier, quantity, cost. They're fine for a simple residential project where the designer knows every supplier personally. For a commercial hospitality fit-out, they fall apart quickly.

The gap between a template that covers the basics and one that actually works through a full project lifecycle is wider than most people realise until they're halfway through procurement and something goes wrong.

What a working FF&E schedule template needs

A useful FF&E schedule template is organised around two distinct purposes: specification and procurement tracking. These are related but not the same.

The specification section answers: what exactly is each item? It needs:

  • Item name and category (seating, casegoods, lighting, soft furnishings, accessories, artwork)
  • Room type and location (which room type, which zone within the room)
  • Manufacturer and brand name
  • Model name and product reference code
  • Finish, fabric, or material specification — with specific codes, not general descriptions
  • Dimensions (width × depth × height)
  • Lead time (weeks)
  • Fire rating classification (for upholstered items, textiles, and soft furnishings)
  • Certificate reference or document link
  • Substitution history (any changes from original specification)

The procurement tracking section answers: where is each item in the order process? It needs:

  • Supplier name and account contact
  • Order reference
  • Unit cost (ex-VAT)
  • Total cost (quantity × unit)
  • Order date
  • Expected delivery date
  • Actual delivery date
  • Delivery condition (arrived intact, damaged, short-shipped)
  • Installation confirmation

In a well-built template, these live in separate tabs of the same workbook, linked by item reference codes. Merging everything into a single wide spreadsheet works for small projects but becomes unmanageable at scale.

The room type approach

The most robust FF&E schedule templates are built around room types, not individual rooms.

If a hotel has 180 standard rooms and each has an identical configuration, specifying each room individually is unnecessary work. Specify the standard room type once — define every item, its specification, quantity per room, and sourcing — then apply quantity multipliers to generate total order quantities.

A template built this way has a room type definition sheet (what items belong to each type), a quantities calculation sheet (number of rooms per type × items per room = total order quantities), and a procurement sheet (order status by supplier).

This structure also makes substitutions cleaner. When a specified item is changed — because it's discontinued, fails a compliance check, or is swapped at the client's request — you update it in one place (the room type definition) rather than across 180 individual rows.

Column structure that works

Here is a minimum viable column set for the specification layer of an FF&E schedule template:

ColumnExample
Item IDBDR-001
CategoryCasegoods
Item nameBedside table
Room typeStandard
ZoneSleeping area
Manufacturer[Manufacturer name]
Product nameNoctis Low Bedside
Reference codeNLB-400-WLN
Finish / fabricWalnut veneer, matt lacquer
W × D × H (mm)500 × 400 × 480
Fire ratingCrib 5
Certificate refCERT-2024-0341
Lead time (weeks)14
Unit cost (£)680
Qty per room type2
Total qty360
Total cost (£)244,800

That's a wide spreadsheet, which is exactly why most templates under-include — the creator is trying to keep it manageable on a standard laptop screen. The cost of under-inclusion shows up later: procurement teams have to go back to the designer for missing information; operators can't identify items at the point of replacement.

What most templates get wrong

No change log. Specifications change throughout a project. A template without a change log — a record of what was originally specified, what it was changed to, when, and why — produces a document at handover that may not reflect what was actually installed. This is one of the most common reasons operators struggle to manage FF&E in the years after a hotel opens.

No compliance tracking. Fire certification is legally required for upholstered furniture and textiles used in commercial hospitality environments in the UK. A template that records the item but not its fire rating status — or that records only the fabric certificate without checking the composite — leaves the operator in a legally precarious position and doesn't capture the full cost of a compliant specification.

No supplier hierarchy. The original specified supplier and an approved alternative supplier are different things. A template that records only one supplier gives the procurement team no options when the first supplier's stock is exhausted or their lead time slips. Recording both — with the alternative clearly flagged as a second-choice substitution — gives the project more resilience.

Cost columns that don't track changes. Unit costs change between specification and order, especially on longer projects. A template that records only the original budgeted cost doesn't capture the final actual cost. The variance between budget and actual is useful operational data; a template that doesn't preserve both loses it.

When a template reaches its limits

For most projects up to around 150 items, a well-structured spreadsheet template is adequate. Above that threshold — or on projects where multiple stakeholders need simultaneous access, where version control is critical, or where the hotel operator needs a live operational record at handover — dedicated specification software starts to make sense.

The transition point is usually triggered by one of three events: a costly error caused by working from an out-of-date version; a handover where the operator receives documentation they can't use; or a project where the procurement company and design firm are using incompatible formats and spend weeks reconciling them.

Controlbook provides a structured specification record that works from design through procurement and into ongoing operations — covering the full FF&E lifecycle rather than just the initial project phase. If you'd like to see how it compares to the spreadsheet approach on a real project, book a demo.

Frequently asked questions

Is there a standard FF&E schedule template I can download?

There is no single industry-standard format, though most procurement companies and design firms have their preferred templates. What matters more than the specific format is whether it captures the fields described above — particularly compliance status, change history, and supplier detail. A well-structured Excel template that covers those fields is more useful than a proprietary format that doesn't.

How do I format an FF&E schedule for procurement?

The procurement team needs item references, supplier contacts, model numbers, quantities, and lead times. Organising by supplier — rather than by room type — makes it easier for them to batch orders and manage lead times. Consider a supplier summary tab that consolidates all items by supplier, with contact details and total order value, alongside the room type–organised specification tabs.

What's the difference between an FF&E schedule and an FF&E matrix?

An FF&E matrix typically refers to a room-type–versus–item–category grid that gives a quick overview of what's specified where. It's a summary tool. The full schedule is the detailed document behind it, containing specification and cost data for every individual item.

Should the FF&E schedule include artwork and accessories?

Yes, if those items are being procured as part of the project. Artwork and accessories often get treated as afterthoughts in FF&E scheduling and then become logistical problems during installation — they arrive without proper records, get placed incorrectly, or don't have fire rating documentation. Including them in the schedule from the start is cleaner.

See it running on your own property's data.

Give us 30 minutes. We'll report a real fault, identify the item, check availability and draft the supplier email, live, on a sample of your own data.