Should You Track Inventory in QuickBooks or Expense It?

Inventory accounting is one of those areas where a small decision made at setup time creates years of either clarity or confusion. Owners who sell physical products often ask whether they need to track inventory formally in QuickBooks or whether they can just expense everything they buy. The honest answer is: it depends, and the wrong choice is expensive in either direction.

What Owners Get Wrong

The most common mistake is treating inventory tracking as an optional best practice rather than a decision with real financial implications. Expensing all purchases when you actually hold significant inventory understates your assets, overstates your costs in high-purchase periods, and understates them in low-purchase periods. Your profit picture becomes misleading, and any financial report you produce for a bank, investor, or potential buyer will not hold up to scrutiny.

The opposite mistake is tracking inventory formally in QuickBooks when the business is a pure service business or buys and immediately uses supplies. That creates unnecessary complexity, requires physical counts, and produces financial statements that look more cluttered without any meaningful gain in accuracy.

The decision should be driven by two questions: Do you hold goods for resale? And is the dollar value of what you hold material to your financial picture?

The CFO Perspective: Inventory vs. Expense, Defined

When to Track Inventory in QuickBooks

Track inventory formally when you buy goods that sit on a shelf before they are sold. Retailers, product-based e-commerce businesses, wholesalers, and manufacturers all fall into this category. If you walk into your storage room and there are $15,000 worth of goods sitting there at any given time, that $15,000 is an asset, not an expense. It does not become an expense until you sell it. If you expense it when purchased, your books will show a loss in the month you stock up and inflated profit in the months you sell through, even though the underlying business performance is unchanged.

QuickBooks inventory tracking creates a Cost of Goods Sold account that only recognizes the cost of items when they are invoiced to a customer. This gives you accurate gross margin reporting and a balance sheet that reflects what you actually own.

The practical threshold: if your inventory balance on hand at any month-end exceeds roughly one or two months of revenue, formal tracking is worth it. Below that, expensing with periodic adjustments may be acceptable depending on the materiality of the difference. Ask your accountant what threshold makes sense for your specific filing.

When to Expense Purchases

Expensing is appropriate when you buy materials or supplies that are used quickly and do not sit in stock in any meaningful way. A plumber buying fittings and pipe for a job, a caterer buying food for an event, or a cleaning company buying supplies that are fully consumed each month, these are not inventory situations. The purchases are matched to the revenue they support in the normal course of business without needing formal inventory accounting.

Service businesses that buy incidental physical components as part of delivering a service typically belong here. The key question is: does the item exist as a distinct sellable unit? If you buy a box of parts and immediately use them on a job, that is a supply or job cost, not inventory. If you buy a box of parts and put them on a shelf to sell individually to future clients, that is inventory.

An Illustrative Scenario

Consider a business that sells and installs custom signage. They purchase sign blanks in bulk for approximately $8,000 at a time, hold them for four to eight weeks while jobs are scheduled, then use them as jobs complete. If they expense the $8,000 at purchase, their books will show a large cost spike in the purchase month and reduced costs in the weeks that follow, making their monthly margin swing wildly even though actual production is steady. Tracking these as inventory, recognizing the cost only when a sign ships with an invoice, produces a clean and accurate monthly gross margin that reflects real business performance.

What to Do About It

1. Identify what you physically hold between purchase and sale. Walk through your process. If goods sit in your possession for more than a week before going to a customer, you are likely holding inventory in the accounting sense.
2. Estimate the value on hand at a typical month-end. Add up what you would have in stock if someone walked in at the end of any given month. If that number is material to your financial picture, formal inventory tracking is worth the setup effort.
3. Set up inventory items correctly in QuickBooks. Use the Inventory Part item type rather than Non-Inventory Part or Service. This creates the asset account and the Cost of Goods Sold linkage automatically. Entering items incorrectly at setup is the most common source of inventory accounting errors in QuickBooks.
4. Do a physical count at least twice a year. QuickBooks tracks units sold based on invoices, but it does not know about items that were damaged, lost, or used for samples. A physical count and an adjustment entry keeps your QuickBooks balance accurate.
5. Ask your accountant about year-end treatment. For tax purposes, CRA requires inventory to be valued at cost or fair market value, whichever is lower, at your fiscal year-end. Your accountant will handle this adjustment, but you need accurate records in QuickBooks to make it straightforward. This is educational guidance on how it works, not specific tax advice, so confirm the treatment for your situation with your accountant.

Getting this right at setup saves significant clean-up work later, especially if you ever apply for financing or sell the business. If you want to assess whether your current bookkeeping setup reflects your actual business correctly, book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.