Outgrowing QuickBooks and spreadsheets: a switching plan for a flooring shop
Signs your flooring shop has outgrown QuickBooks and spreadsheets, what moves to new software, when to cut over, and a switching checklist.
By Derek Spohn · Last reviewed November 2026 · 7 min read
In this guide
- The short answer
- Signs you’ve outgrown the setup
- Decide three things before you shop
- What moves over, and what usually stays
- Pick a cutover point
- Bring the accountant in early
- Worked example: opening balances at cutover
- Getting the office and crews on board
- Running the first month
- Common mistakes
- Switching checklist
- How Turn One handles this
The short answer
You’ve outgrown QuickBooks and spreadsheets when the same job gets typed in three places and your reports can’t agree on what it made. The switch goes well when you decide who uses the new system, what moves over and your cutover date before you shop, bring your accountant in early, and go live on the first of a month.
QuickBooks is where most flooring shops keep their books, and it does that job. The strain shows up around it: the jobs, the rolls and the crews live in other files. This plan works for any software you pick, whether the books move too or stay where they are.
Signs you’ve outgrown the setup
- Rolls live on a spreadsheet. Someone updates feet left by hand after each cut, and the sheet says 40 LF when the warehouse says 12.
- Every job gets retyped. The quote goes into a spreadsheet, again onto a work order, again into an invoice. Each retype is a chance to drop a unit number or a PO.
- Your reports disagree. The job sheet says one number for the month, the P&L says another, and nobody can say which is right.
- You can’t say what a job made. Material, labor and installer pay sit in different places, so job profit is a guess until the month is long over.
For us, it was the month the books said we were profitable and the bank account kept shrinking.
Decide three things before you shop
Who uses it. List every person and what they touch: owner, office manager, bookkeeper, warehouse, dispatcher, sales, crews. This tells you how many logins you need and who has to like it.
What must move over. Write the list now (the next section helps). Any software you look at should show you how each item gets in.
Your cutover date. Pick the date the new system becomes the record. Everything after it lives only in the new one.
What moves over, and what usually stays
Bring over what you’ll act on after cutover:
- Customers and properties. Management companies, properties, units, billing contacts and payment terms such as net 30.
- Vendors. Suppliers and subcontracted installers, with whether you have a W-9 on file and whether each one gets a 1099.
- Open jobs. Anything quoted, scheduled or in progress, with any deposit already received.
- Open purchase orders. Material ordered from suppliers that hasn’t arrived or been billed.
- Open invoices. Each unpaid invoice, one by one, so payments can be applied against it.
- Open bills. Each unpaid vendor bill, so your next check run works.
- Unpaid installer pay. Work your crews finished that you haven’t paid for yet.
- Opening balances. The balance of every account on the cutover date.
- Roll inventory. Each roll with width, feet left, dye lot, location and cost.
- Price lists. Your current sell prices and property contract pricing.
What usually stays behind: closed jobs, paid invoices, old journal entries and past years. Keep the old system or a full export where you can read it. Ask your accountant how long to keep those records, since rules vary by state.
Pick a cutover point
Go live on the first day of a month. You can’t close the prior month that day, because the bank statement and the last vendor bills arrive later. So you start with draft opening balances from the books as they stand, then finalize them when your accountant closes the prior month, usually 2 to 3 weeks later.
Pick a slow month if you can. For many multifamily shops the summer move-out season is the busy stretch, and training on top of it is hard.
January 1 gives you a clean year, but it’s also when your accountant is busiest with year-end forms. Ask which they prefer.
If you cut over mid-year, the year’s P&L splits across two systems: January to cutover in the old one, the rest in the new. Ask your accountant whether to bring the year-to-date totals in as summary entries so the new system shows the whole year. Payments to subcontracted installers split the same way, so ask how they want year-end forms handled too.
Bring the accountant in early
An accountant brought in late can force you to redo the setup, so talk to them before you sign. Ask them:
- Which month will be the last one in the old books, and how long that close usually takes.
- Whether they’ll want access to the new system, an export, or both.
- How they want the chart of accounts set up, so their reports still make sense to them.
- Which system files any sales tax or payroll returns for the cutover month.
Send them the draft opening balances at go-live and the final ones after they close the prior month. Then have them review your first month-end close in the new system.
Our accountant once begged us not to use a flooring program’s built-in accounting. He said it was stiff, clunky and tedious, and it didn’t flow the way mainstream accounting does. Have your accountant look at any system’s books before you commit.
Worked example: opening balances at cutover
This is an example with made-up numbers. Say you go live November 1. That day you enter draft balances from the October 31 books as they stand. About three weeks later your accountant closes October, and you update the draft to the final numbers. The final October 31 balance sheet shows:
- Operating checking: $48,200
- Owed by customers (open invoices): $63,500
- Roll and stock inventory, at cost: $22,400
- Trucks and equipment, at cost: $67,500
- Depreciation taken on trucks and equipment so far: $26,500
- Owed to vendors (open bills): $19,750
- Company credit card: $3,100
- Customer deposits held for jobs not yet done: $6,800
- Truck loan: $27,000
Accountants usually want equipment as two lines, the cost and the depreciation taken so far, so the new books keep that history. Your own list will also include sales tax owed, payroll owed and unpaid installer pay if you have any on that date. They’re left out here to keep the math short.
What you own: $48,200 + $63,500 + $22,400 + $67,500 minus $26,500 = $175,100.
What you owe: $19,750 + $3,100 + $6,800 + $27,000 = $56,650.
What’s left for the owners (equity): $175,100 minus $56,650 = $118,450.
Check it: what you owe plus equity, $56,650 + $118,450, equals $175,100, the same as what you own. Those balances, with the equity, are your opening entry.
Then tie out the lists behind the totals. “Tie out” means the detail adds up to the balance, to the cent:
- Your 14 open invoices must add up to $63,500.
- Your open bills must add up to $19,750.
- The deposits on your open jobs must add up to $6,800.
- Your roll list at cost must add up to $22,400.
Say the roll count comes in at $21,650, which is $750 short of the books. Don’t bury the gap in the new system. Have your accountant decide how to record it as part of the October close, in the old books, and carry over the corrected balance.
Getting the office and crews on board
Pick one person in the office to own the switch. They learn it first and answer the small questions so the owner doesn’t have to.
Train the office on a real job from your own list, from quote to invoice.
For crews, change as little as you can at first. Show them where their jobs are on their phone, how to mark one done and where to put photos. Start with one crew lead, then the rest.
We kept switching our own internal tools, looking for one that fit, and none of them spoke our language. We never got stable inside the office, so we never even tried to bring outside installers on. Get the office settled first, and the crews come easier.
Running the first month
- From the cutover date, new work goes into the new system only.
- When the prior month closes, replace the draft opening balances with the final ones and tie them out again.
- Keep a running list of anything missing or wrong, and fix it weekly.
- Each week, check open invoices against what you expect to collect.
- At month-end, reconcile the bank, check the roll count, and have your accountant review the close before you call it done.
Common mistakes
- Picking a cutover date in the middle of a month or the busy season.
- Waiting to go live until the prior month is closed, which pushes the date back every month.
- Importing years of history and then spending the first month cleaning it.
- Carrying over balances that don’t tie to the lists behind them.
- Calling the accountant after the contract is signed.
- Leaving the crews out until go-live day.
Switching checklist
- List who will use it and what each person touches.
- Write down what must move over.
- Talk to your accountant and pick the cutover date together.
- Export customers, properties, vendors, price lists, open jobs, open purchase orders, open invoices and open bills.
- Count the rolls: width, feet left, dye lot, location and cost.
- Train the office on a real job, then the crew leads.
- Go live on the first day of a month with draft opening balances. New work goes in the new system only.
- When your accountant closes the prior month, enter the final balances and tie each total to its list.
- Keep the old system readable for reference.
- Close the first month with your accountant.
How Turn One handles this
Turn One gives you two ways to start. Set it up yourself and bring your lists over with the import workbook, or send us the exports from your old software and we import them. Either way, you check every list before go-live. Your books start clean on a date you pick, and nothing changes for your crews until you say so. Both are laid out on the Pricing page. More on the Books page.
Derek Spohn built a multifamily flooring company from scratch to more than 20 crews. He started Turn One. Questions or a correction? Email contact@getturnone.com.
More guides
- How to invoice a property management company (and get paid sooner)What property management AP needs on every flooring invoice, where to send it, and how to follow up without souring the account.8 min read
- Margin vs. markup for flooring contractorsThe difference between margin and markup on a flooring job, how to convert one to the other, and why mixing them up costs you money.2 min read
- How to quote an apartment unit turn (and keep the margin)What goes in a flooring turn quote, how to price it from cost and margin, and the approval and follow-up steps that keep the money.7 min read
- Square yards, square feet and linear feet: how flooring is measured and soldHow carpet, LVP and base are sold by square yard, square foot and linear foot, how to convert, and how roll width and cartons set what you order.7 min read