Flooring store guides
Year-End Inventory Count for Flooring Stores: Stock in Boxes
By the FloorBase team · Published November 3, 2026
December is when flooring stores find out what they actually own. The physical inventory count is not busywork. It is the bridge between what the shelf shows, what the software thinks you have, and what your accountant needs for year-end. For independent Canadian retailers, doing the count in boxes — the unit you buy, sell leftovers in, and return — keeps the numbers honest.
This guide walks through a practical year-end count for a single showroom or owner-operated store. It is not written for banner groups with warehouse scanners and corporate cycle-count programs. It pairs with a January software cutover if you are switching systems, and with a Canadian close-out if you are wrapping GST/HST, unpaid invoices and commissions.
Why flooring inventory is counted in boxes
Flooring is quoted in square feet and purchased in boxes (or cartons, or rolls — but most hard-surface lines land as boxes). If your count sheet is in square feet only, two problems show up every year:
- Partial boxes get invented. A salesperson “knows” there is half a carton of that oak left. The next quote assumes coverage that is not on the shelf.
- Purchase orders drift. You order another skid because the spreadsheet is fuzzy, then discover three full boxes behind the rack after the truck arrives.
FloorBase calculates box quantities from square feet on quotes and invoices. For example, 300 sq ft at 20.5 sq ft per box becomes 15 boxes. Your year-end count should use the same unit: what is on the shelf in full boxes, plus a clear note for opened cartons you still sell from.
Prepare the count before you touch a pallet
1. Freeze movement for a short window
Pick an evening or Sunday morning. Pause will-call pickups and new special-order receipts for that window so the count does not chase a moving target. Tell the install crew which jobs can still pull stock and which must wait.
2. Print (or export) a product list with box coverage
Every SKU needs:
- Product name and brand
- Square feet per box
- Expected on-hand boxes (from your current system or spreadsheet)
- A blank for counted boxes
- A blank for variance
If you are mid-migration to FloorBase, clean the product list first so coverage is right. Wrong coverage makes every quote and every count wrong.
3. Separate “store stock” from “sold, not yet delivered”
Boxes tagged for a sold job are not free inventory. Mark them by invoice or customer before you count the open shelf. Otherwise you will “find” stock that already belongs to a job and sell it twice.
4. Decide the rule for opened boxes
Common store rules:
- Count only sealed boxes as inventory; treat opened boxes as samples or write-offs.
- Or count opened boxes at remaining estimated coverage, with one person responsible for the estimate.
Pick one rule and write it on the top of the count sheet. Consistency matters more than perfection.
How to run the physical count
Work brand by brand, rack by rack. Two people beat one: one counts, one records. Do not jump around the warehouse answering the phone between aisles.
- Count sealed boxes on the shelf and in overflow.
- Record opened boxes under your chosen rule.
- Note damaged or unsellable stock separately so it does not inflate available inventory.
- Tag job-reserved stock and exclude it from available on-hand.
- Initial each aisle when finished so you know what was skipped if you get interrupted.
When the floor count is done, compare counted boxes to system boxes. Large variances usually mean mis-tagged job stock, receipts that never got entered, or a product with the wrong sq ft-per-box value — not a haunted warehouse.
Tie the count to purchase orders and returns
A year-end count is wasted if buying and returns ignore it the next morning.
Purchase orders from sold invoices
In FloorBase you can create a purchase order from an invoice and email it to each brand or supplier. Box pricing uses sq ft per box × cost per sq ft. That keeps January buying tied to sold work instead of “we always order a little extra in case.” After the count, raise POs only against jobs you intend to fulfill, and use the new on-hand numbers so you do not reorder what you just found.
POs are created and emailed by your team. FloorBase does not automate mill ordering or send purchase orders without you.
Returns after the invoice is complete
Returns in FloorBase work when the related invoice is marked complete. If a customer brings product back in early January from a December job, finish and complete that invoice trail first. Then process the return so stock and money stay aligned. Do not drop returned boxes back on the shelf without a document — that is how next December's variance is born.
Opening balances for January
Once counted boxes are agreed:
- Update on-hand quantities in your system of record.
- Export a CSV for your bookkeeper if they track inventory value in QuickBooks. FloorBase supports QuickBooks CSV import and export for customers, products, invoices and expenses — not a live sync.
- If you are switching software before January 1, this count is your opening stock in the new system. See the companion guide on switching flooring store software before January 1, and compare options on FloorBase vs QFloors and FloorBase vs Floorzap.
Canadian stores closing the books should also skim the year-end close-out checklist: sales tax report, unpaid invoices and commissions paid on collected invoices.
Where FloorBase helps (and what it does not claim)
FloorBase is built for independent Canadian flooring stores. For inventory season it helps you:
- Quote and invoice with box quantities from square feet
- Raise supplier purchase orders from invoices and email them by brand
- Process returns on completed invoices
- Keep store operations next to tax, unpaid filters and commissions in one browser app
It does not claim barcode scanning, cycle-count workflows, Measure Square or measurement import, room-dimension or waste-percent calculators, automated mill ordering, POS, or live QuickBooks inventory sync. If you need those, evaluate them separately. If you need a store system that speaks boxes, invoices and Canadian tax, start at features and pricing, or request a demo. More Canada context lives on flooring store software for Canadian retailers.
Frequently asked questions
How should a flooring store count year-end inventory?
Count in boxes, brand by brand, during a short freeze on stock movement. Separate job-reserved product from available shelf stock, write down a rule for opened boxes, then compare counted boxes to system quantities and fix coverage or receiving errors that explain the variance.
Should flooring inventory be tracked in square feet or boxes?
Both matter, but the shelf count should be in boxes because that is how product arrives and how leftovers are stored. Software should convert quote square footage into box quantities using each product's coverage so sales and stock stay in the same unit.
How do purchase orders relate to the year-end count?
After you finish the count, create purchase orders from sold invoices rather than from guesswork. In FloorBase, POs are created from an invoice and emailed to each supplier, with box pricing from sq ft per box × cost per sq ft. That stops January reorders of product you already found on the rack.
Can FloorBase scan barcodes during a physical inventory?
No barcode or cycle-count feature is claimed here. Use a structured count sheet (or export), update on-hand boxes when the count is agreed, and keep day-to-day quoting tied to box coverage in the system.
What do we do with returns during year-end?
Complete the original invoice first, then process the return so inventory and payment stay consistent. In FloorBase, returns work when the invoice is marked complete. Do not return boxes to available stock without a document.
Does FloorBase sync inventory live with QuickBooks?
No. Use QuickBooks CSV import and export for the lists and transactions your bookkeeper needs. FloorBase runs store operations; QuickBooks remains the ledger.