The 7 Spreadsheets Every Flooring Store Is Secretly Running

Most flooring stores run on seven unofficial spreadsheets: a hold sheet for sold-but-not-delivered goods, an install calendar, a balances-due tab, a sample checkout log, a special-order tracker, a remnant and roll inventory, and a designer or trade account list. Each one exists because the store's point-of-sale or accounting software couldn't do the job, and each one is usually maintained by a single person. The spreadsheets are not the problem. The problem is that each one is a separate copy of the truth, and the copies drift.

I have personally run every Service Buddy onboarding since we started working with flooring retailers. The first hour of every one looks the same: the owner or office manager shares their screen, opens a folder, and starts walking me through the files that actually run the store. The names change. The seven jobs those files do almost never do.

This post is about those seven spreadsheets: what each one is really tracking, why it exists, how it breaks, and what to do about it without blowing up a business that works.

Why every flooring store ends up with spreadsheets

Nobody sets out to run a carpet and rug business on Excel. It happens one gap at a time.

The POS system can ring a sale but can't tell you which rolls are on hold for which customer. QuickBooks can show an open invoice but not whether the install is scheduled. So someone opens a workbook, adds a few columns, and solves the problem in ten minutes. It works. It keeps working, right up until the person who built it takes a week off.

That is the pattern I see over and over. A spreadsheet is a workaround for a question the software can't answer, and in flooring retail there are a lot of those questions, because the sale is not a transaction. It's a sequence: quote, measure, approval, deposit, order, receipt, install, balance, and often a reorder from the same customer or their designer months later. Generic retail software was built for the first step. Flooring stores built spreadsheets for the other eight.

I wrote earlier about why a carpet and rug store breaks when one employee is out. Spreadsheets are the mechanism. The "hero employee" everyone depends on is almost always the person who owns the most spreadsheets.

The seven spreadsheets

If you own or manage a flooring showroom, you will recognize at least four of these. Many stores run all seven.

1. The hold sheet

What it tracks: material that has been sold, reserved, or put on hold for a customer but hasn't left the building. A roll of wool carpet with a deposit against it. A rug out on approval with a designer. A remnant a customer said they'd come back for on Saturday.

Why it exists: inventory systems know what you own. They rarely know what you've promised. The hold sheet is where promises live.

How it breaks: a salesperson sells a roll that's already on hold because they checked the showroom floor, not the sheet. Or a rug sits on hold for three weeks because the hold was never released after the customer passed. Both cost you money, and both happen silently.

The question it can't answer: "Of everything on hold right now, how much is backed by a deposit and how much is a verbal maybe?"

2. The install calendar

What it tracks: which crew is at which address on which day. In most stores this is a hybrid: a whiteboard in the back, a shared Google Calendar, and a spreadsheet that reconciles the two.

Why it exists: the calendar needs to know things that live in three other systems. Has the material arrived? Is the deposit paid? Did the measure change the yardage? None of that is on a calendar invite.

How it breaks: an install gets scheduled before the goods land. The crew shows up, the customer took the day off work, and the carpet is still on a truck. Everyone has lived this one.

The question it can't answer: "Which installs next week are not actually ready to install?"

3. The balances-due tab

What it tracks: who owes what. Deposits collected, balances outstanding, who was promised a final invoice after the install punch list is done.

Why it exists: QuickBooks can show open invoices, but most flooring stores don't invoice the balance until the install is complete, so the accounting system has no idea how much money is sitting in approved-but-not-yet-invoiced jobs. The balances tab is the bridge between the sale and the books.

How it breaks: reconciliation. Every payment has to be entered twice, once in the sheet and once in QuickBooks, and the two never quite agree. Month-end becomes a hunt for the difference.

The question it can't answer: "How much cash is owed to us on jobs that are already installed?" You can get there, but it takes an afternoon.

4. The sample checkout log

What it tracks: carpet samples, rug pads, and sometimes entire rugs that left the store with a customer or designer. Who has it, when it went out, when it's due back.

Why it exists: samples are inventory that doesn't look like inventory. They are expensive, they are the thing that closes the sale, and no POS treats them as a trackable asset.

How it breaks: the log is only as good as the moment someone remembers to write in it. A busy Saturday means six samples go out and two get logged. By Wednesday nobody knows where the other four are, and one of them was the last architect folder of a discontinued line.

The question it can't answer: "Which samples have been out more than two weeks, and did those customers buy?" That second half matters. Samples out with no sale is a follow-up list hiding in plain sight.

5. The special-order tracker

What it tracks: every purchase order placed with a mill or vendor. Date ordered, expected ship date, dye lot, received or not, and which customer job it belongs to.

Why it exists: lead times. Special-order carpet can take weeks, and the customer was promised a date on the day they signed. Someone has to watch the gap between the promise and the mill.

How it breaks: the yardage changes after the measure and the PO doesn't. Or the mill ships two dye lots and nobody catches it until the installer unrolls the second one. Or the ETA slips and the install calendar (spreadsheet number two) never hears about it.

The question it can't answer: "Which open orders are going to miss the install date we already gave the customer?"

6. The remnant and roll inventory

What it tracks: what's actually in the back. Rolls by width and remaining length, remnants by size, rugs by SKU and location.

Why it exists: the official inventory count is wrong and everyone knows it. Cuts don't get recorded. A remnant gets sold off the floor for cash. A roll gets moved to the second warehouse and the system still shows it here. So someone keeps a "real" list.

How it breaks: two lists is worse than one. The system says 40 yards, the sheet says 32, the roll has 28. You find out when the installer runs short on a Friday afternoon.

The question it can't answer: "What can I sell today, right now, and what is it worth at cost?" If you can't answer that in under a minute, you don't have inventory. You have a guess.

7. The designer and trade account list

What it tracks: interior designers, decorators, builders, and property managers who buy from you repeatedly. Pricing tiers, commission or referral arrangements, what they ordered last, who their clients were.

Why it exists: trade customers don't fit a retail POS. They buy on account, they reorder the same goods across multiple clients, and the relationship matters more than any single ticket. The spreadsheet is the CRM the store never bought.

How it breaks: the relationship lives with one salesperson, and so does the sheet. When that salesperson leaves, the designer gets a cold call from the new hire asking what they usually order. That is how you lose a trade account you spent five years building.

The question it can't answer: "Which designers bought from us last year and haven't ordered in the past six months?" That list is some of the cheapest revenue in the building, and almost nobody can produce it.

What these spreadsheets actually cost

The usual argument against spreadsheets is error rates, and the research there is not kind. Raymond Panko at the University of Hawaii has spent decades compiling field audits of real operational spreadsheets. Across the nine audit studies where methodology was known, covering 163 spreadsheets, auditors found errors in 84% of them. In the five most rigorous audits, 91% of spreadsheets contained what the auditors classified as important errors. The European Spreadsheet Risks Interest Group keeps a running catalogue of real-world spreadsheet failures that have cost companies and governments real money.

Those numbers come from corporate finance and engineering, not flooring stores. But I don't think formula errors are the biggest cost in a showroom anyway. The bigger costs are structural:

Each spreadsheet is a copy. The hold sheet, the inventory list, and the special-order tracker all describe the same roll of carpet, from three angles, in three files, maintained by three people. Every time one changes, the other two are wrong until someone notices.

Each spreadsheet has an owner. Not an owner in the sense of accountability. An owner in the sense that it lives on their laptop, uses their color coding, and only they know that yellow means "deposit taken, PO not placed." When they're out, the store is running on memory.

The gaps between spreadsheets are where the money goes. The install scheduled before the material arrived. The sample that went out and never came back. The designer who stopped reordering and nobody noticed. None of those are errors inside a spreadsheet. They are failures of connection between spreadsheets, and no amount of careful data entry fixes that. I walked through the dollar side of this in The Real Cost of Running a Flooring Store Without Modern Software, so I won't repeat the math here.

How to find your seven in 15 minutes

You don't need a consultant for this. Sit down with whoever runs your office and ask three questions:

"What files do you open every morning?" Not what the software does. What they actually open. Write the names down. That's your list.

"Who else can update this?" If the answer is "just me" for more than two of them, you have a single point of failure, and it has a vacation coming up.

"Where does this information also live?" If the hold sheet duplicates something in the POS, or the balances tab duplicates QuickBooks, you have found a copy. Copies are where the reconciliation hours go.

Most owners who do this exercise are surprised twice: first by how many files there are, and second by how much of the business depends on files they've never opened.

What to do about it

You have three options, and the right one depends on how much pain each spreadsheet is causing.

Consolidate. If two spreadsheets describe the same thing, merge them into one shared file with one owner and one set of rules. This is free and it helps. It does not fix the fact that the file is still disconnected from your quotes and your books.

Connect. Some stores wire their spreadsheets to QuickBooks or their calendar with exports and imports. This reduces double entry but adds fragility. When the export format changes or the person who built the macro leaves, you're back to manual.

Replace. Move the workflow into a system where the hold, the order, the install, the payment, and the customer are the same record, not seven descriptions of it. This is the only option that eliminates the copies rather than managing them.

If you go the replacement route, two pieces of advice from watching stores do it:

Don't try to kill all seven spreadsheets on day one. Rank them by pain. For most carpet and rug stores, the hold sheet and the balances tab are the two causing real money problems, so start there. The sample log and designer list can follow once the team trusts the new system.

And insist that the system start from your spreadsheets, not from a blank database. Your remnant list, your designer accounts, and your open special orders are the business. Any software vendor who tells you to "just start fresh" has not run a flooring store.

How Service Buddy handles the seven

We built Service Buddy specifically around this sequence, so the seven spreadsheets map directly onto parts of the platform:

The hold sheet and the remnant list become real-time inventory organized by product, size, color, and SKU, with QR-code labels on every roll, rug, and remnant. When a quote turns into a job, the material updates automatically, so the showroom floor and the system are describing the same roll.

The install calendar becomes one shared calendar where every approved sale appears, installers are notified automatically, and job status, materials, and customer details stay on the same record as the appointment.

The balances tab becomes connected billing and payments, where deposits, payment links, and balances tie directly to the job and post to QuickBooks Online without re-entry.

The special-order tracker becomes purchase orders created directly from the quote or job, with vendor, item, cost, and quantity pulled in and status tracked from placed to received.

The designer list and the sample log live in the customer record, where every quote, job, payment, text, and email is attached to the person, not to a salesperson's laptop.

On the migration question: we work from your existing records. The customer list, product catalog, pricing tiers, vendors, and open quotes and jobs come over with you, and we sit in on the implementation ourselves. The spreadsheets you've built are the specification. We just stop making you maintain seven of them.

Frequently asked questions

Is it bad to run a flooring store on spreadsheets?

Not inherently. Spreadsheets are a reasonable way to solve a problem your software can't. The risk is structural: multiple spreadsheets describing the same inventory, jobs, and customers drift out of sync, and each one tends to depend on a single person. The cost shows up as double-booked material, installs scheduled before goods arrive, uncollected balances, and lost designer accounts, not as formula errors.

What spreadsheets do most flooring and carpet stores use?

The common set is a hold sheet for sold or reserved material, an install calendar, a balances-due list, a sample checkout log, a special-order or purchase-order tracker, a remnant and roll inventory, and a designer or trade account list. Most stores run at least four of these, often alongside a POS system and QuickBooks.

How do I know which spreadsheet to replace first?

Rank them by financial pain. For most carpet and rug retailers, the hold sheet (material promised but not delivered) and the balances-due tab (cash owed but not invoiced) cause the most direct losses. Start there, then move the sample log, special orders, and designer accounts once the team trusts the new system.

Can QuickBooks replace these spreadsheets?

Only partially. QuickBooks handles invoices and payments well, but it does not know which rolls are on hold, which installs are ready, which samples are out, or what a designer ordered last. Stores that run on QuickBooks alone almost always keep spreadsheets for those jobs. A flooring-specific system that syncs to QuickBooks Online covers the operational side while QuickBooks stays the accounting record.

Will I lose my spreadsheet data if I move to flooring software?

You shouldn't. A good implementation starts from your existing files: customers, products and pricing, vendors, open orders, and inventory. Treat your spreadsheets as the specification for what the system needs to track, and be wary of any vendor who suggests starting from a blank database.

Find out what your spreadsheets are hiding

If you did the 15-minute exercise and came up with five or more files, it is worth 30 minutes to see what the same workflow looks like when the hold, the order, the install, and the payment are one record. Book a live demo and bring your spreadsheets. I'd rather look at your real hold sheet than show you a canned one.