Year-end furniture inventory count

December 31, late afternoon. Sofas await customers, a container is somewhere on the Pacific, and bolts of a customer's own fabric lean against the back wall. The floor samples have been here long enough to know where the spare keys live. Which pieces belong on the inventory valuation, and which merely happen to be in the building?

A year-end inventory count in a special-order store needs separate answers for physical quantity, ownership, and accounting value. Count and identify the goods first. Then reconcile the records that establish which goods belong in the store's inventory at the cut-off. Payment status alone cannot answer that question.

General information, not tax advice.

Give every category a place on the count sheet

Separate the special-order categories before the counting team starts. A single column headed “sofas” cannot distinguish available merchandise from a customer's reserved piece, a damaged return, or something held for another business. The count sheet should preserve those distinctions even when the pieces look identical under their dust covers.

Use an item or configuration identifier, physical location, counted quantity, condition, customer or PO reference, and an ownership-review field. Keep the count and the financial valuation in separate columns. The person holding the scanner should not have to settle a shipping contract while standing between upholstered headboards.

Category	What the team records	What accounting needs
Available warehouse stock	Exact variant, quantity, and location	Cost record and ownership
Floor samples for sale	Configuration, condition, and age	Cost plus evidence for any valuation adjustment
Goods held for customer orders	Physical units and linked orders	Delivery, title, and revenue treatment
Goods in transit	Shipment and PO references	Contract terms and evidence of shipment or arrival
Customer-owned material	Description, owner, quantity, and location	Separate review of whether it belongs in the valuation
Consignment	Owner and agreement	Whether goods are consigned in or out

Keep customer-held stock visible on the physical count even when it is unavailable for another sale. “Reserved” describes availability. It does not, by itself, determine ownership or accounting treatment.

Decide what paid-but-undelivered means for your store

A paid invoice does not by itself tell the counting team to remove a sofa from inventory. The contract, transfer of title, and the store's accounting policy matter. Have your CPA settle the treatment of fully paid goods, customer-owned material, consignment, goods in transit, and sample write-downs before the count begins.

Keep customer payments and inventory movements in separate columns. A paid customer order can still be physically awaiting delivery, while a piece received for inspection can remain subject to an unresolved ownership question. Give accounting the payment, agreement, receipt, and handover evidence together so it can apply the store's policy consistently.

Give the team a written classification rule and a review queue for exceptions. If a customer has postponed delivery, keep the order reference and the hold reason with the physical unit. If the customer owns fabric stored in your workroom, list and identify it separately for accounting review instead of silently treating it as purchased fabric stock.

Establish the cut-off before moving another carton

The cut-off is the point to which the count will be reconciled. Record its date and time, then identify receipts, deliveries, and transfers on either side. If operations continue during counting, use a movement log so a piece cannot disappear from one location and reappear in another without an explanation.

Receipt dates should reflect when goods were actually received. A January data-entry session does not make a December receipt a January arrival. Conversely, an invoice dated in December does not prove the shipment reached the warehouse before year-end. Keep dock evidence beside the receipt record.

For the financial close, compile the freight, duty, and other acquisition costs associated with the included goods, including bills that have not arrived. Accounting can determine the accruals. Use the landed-cost guide to make the supporting charge schedule traceable to the goods, rather than guessing from a freight account total.

Review the container on the water separately

Goods in transit need a document review, not an imaginary warehouse count. IRS Publication 538 includes purchased merchandise when title has passed to the business, even if it remains in transit, and excludes future purchases where title has not passed. Record the shipment separately so it is not missed or counted twice when it arrives.

The model UCC's section 2-401 distinguishes shipment and destination contracts and recognizes explicit agreements about title. State enactments and the actual contract govern the transaction; an international shipment may require a different legal analysis. A shipping abbreviation alone is not a complete inventory policy.

Put the vendor agreement, invoice, shipping evidence, and destination in the year-end packet. The question is which goods the store owns at cut-off, not which vessel is nearest the coast. Keep the accounting decision alongside that evidence so receiving does not add the shipment to inventory a second time after arrival.

Count location by location, then investigate differences

Run the physical count in Shopify. Its inventory-management guidance directs full-location stocktakes and cycle counts to Admin stock counts, with POS counting at POS Pro locations; Quick count supports smaller spot checks. Choose the supported workflow for the scope of your count and the location's subscription.

Recount differences before adjusting quantities. Look for an unrecorded transfer, an item received against the wrong variant, a completed delivery still sitting in the records, or a piece counted once under a dust cover and again under its carton label. A repeated model name is not enough to identify a custom configuration.

Quantity adjustments belong in Shopify's counting workflow. If the investigation reveals an actual receiving error, correct that receipt in OrderPilot with a reason. Do not invent a receipt correction merely to make a stock count agree; the original PO may have been received correctly and the difference may have arisen later.

Value samples from evidence, not their birthday

Keep the physical sample count even when a floor piece has lost selling appeal. Age, condition, current selling evidence, and the accounting method inform the valuation review. A year-old sample does not automatically have a zero value, and reducing its sale ticket does not automatically rewrite its historical cost.

Publication 538 describes cost and other inventory valuation methods, acquisition charges, special treatment for shopworn goods, and an exception for qualifying small businesses. The right method and any change to it belong in the store's accounting policy. Keep photographs, the original cost, and selling-price evidence with proposed adjustments.

For merchandising decisions, use the aged-inventory and floor-sample guide. For year-end, preserve the difference between what you hope to sell the sample for and the value accounting has accepted in the inventory records.

Use OrderPilot to explain the special-order quantities

OrderPilot supplies the purchasing and customer-order evidence behind the count. Review open and partially received POs to distinguish outstanding commitments from actual receipts. Dated receipts support cut-off; held units identify the customer commitment and location; receipt costs provide the acquisition history. With QuickBooks Online connected, a bill per receipt helps accounting match received goods to the purchasing record. Review exceptions and corrections with the person closing the books. The QuickBooks setup guide explains the purchasing scope and mapping that make these records useful together.

Say the count finds six identical chairs in an illustrative warehouse bay. Four belong to undelivered orders and two are available. Record six physical chairs, identify the four held units, and give accounting their order and delivery evidence. Do not replace the physical count with the available quantity or value all six at the current retail ticket.

Keep this checklist with the count packet

[ ] Name the count owner, cut-off, and locations covered.
[ ] Assign every aisle, showroom, storage area, and returns area to a counter.
[ ] Identify exact variants or configurations rather than model names alone.
[ ] Separate available stock, held orders, samples, returns, and outside-owned goods.
[ ] Record condition and age evidence for floor samples.
[ ] List in-transit shipments with their ownership evidence.
[ ] Match receipts and deliveries to the cut-off; log movements during counting.
[ ] Recount differences and record the investigation result.
[ ] Post approved stock-count adjustments in Shopify.
[ ] Correct genuine receipt errors in OrderPilot with a reason.
[ ] Compile receipt costs and unbilled acquisition charges for accounting.
[ ] Retain the count, approvals, valuation decisions, and reconciliation together.

This text is ready to print as the working checklist; the records behind each tick remain part of the count packet. After the close, use inventory turns for a special-order store to turn the cleaner numbers into a buying decision.

Sources

Publication 538: Accounting periods and methods — Internal Revenue Service, January 2022 edition.
UCC § 2-401: Passing of title — Uniform Commercial Code, Cornell Legal Information Institute.
Migrating to Shopify inventory management — Shopify Help Center.

Year-end inventory count in a special-order store