How do I set up inventory accounting in QuickBooks for a wholesale distribution business?
QuickBooks Online has built-in inventory tracking that works on a FIFO (first in, first out) basis. To enable it, go to Settings, then Sales, and turn on inventory tracking. From there you can create inventory products with purchase costs, selling prices, and quantities on hand. For a small wholesale operation with a handful of SKUs, this might be enough to get started.
The setup itself is straightforward. Create each product as an inventory item, assign it to an income account and a COGS account, and enter your starting quantities and costs. Group products into categories that match your product lines so your reports show meaningful breakdowns rather than one long list. If you sell the same item to different customer segments at different prices, use price rules to manage that instead of creating duplicate products.
Where things get complicated for wholesale distribution is landed cost. The true cost of a product isn’t just what you paid the supplier. It includes freight, customs duties, insurance, and sometimes warehousing fees before the product is available for sale. QBO doesn’t calculate landed cost natively. You either need to manually adjust your average cost per unit after each shipment arrives (which is error-prone with hundreds of SKUs) or use a workaround like posting those extra costs to COGS directly, which muddies your per-unit profitability.
For wholesalers dealing with hundreds of SKUs, multiple suppliers, and regular imports, a third-party inventory management system is usually the right move. Tools like Cin7 (formerly DEAR Inventory) or Fishbowl sync with QuickBooks Online and handle what QBO cannot. They calculate landed cost automatically by rolling freight and duties into unit cost. They track inventory across multiple warehouses. They manage reorder points so you get alerts before you run out of a fast-moving product. And they give you inventory turnover reporting that helps you identify slow movers tying up your cash.
The integration between these tools and QBO keeps your financial books accurate without requiring double entry. Sales orders, purchase orders, and inventory adjustments flow into QuickBooks so your balance sheet and income statement reflect reality. Your inventory accounting stays clean in QBO while the dedicated inventory system handles the operational complexity.
A few things to get right from the beginning. Set up your chart of accounts to separate COGS by product line or category. This lets you see gross margin by product group instead of just one blended number for the whole business. Track shrinkage and damaged goods with adjustment accounts so you know where inventory losses are happening. And do physical inventory counts on a regular cycle, even if the system says you have 200 units on the shelf. Systems drift, and wholesale businesses with high volume drift faster.
If your books are already running in QBO but inventory has been handled loosely or not at all, getting the starting balances right is the most important first step. Entering incorrect opening quantities and costs means every report going forward is wrong. It’s worth taking the time to do a full physical count and reconcile it against your purchase records before you flip on inventory tracking.
Wholesale distribution accounting has layers that generic bookkeeping doesn’t cover. If you’re growing past what basic QBO inventory can handle, working with bookkeepers in Buena Park who understand wholesale operations can save you from building a system you’ll just have to rebuild six months later. Getting the structure right at the start is significantly cheaper than fixing it after thousands of transactions have already flowed through.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
What bookkeeping records do I need for a 1031 exchange on rental property?
You need records tracking the adjusted basis of the property you're selling, all sale and exchange costs, qualified intermediary funds, and the full purchase details of the replacement property. The replacement property carries over the old basis, so accurate depreciation history is critical.
Read answerWhat is the best way to track intercompany transactions between healthcare entities in QuickBooks?
Set up Due To and Due From accounts in each entity's QuickBooks file to log every payment made on behalf of another entity. QuickBooks Online lacks built-in intercompany elimination, so you'll need manual journal entries and monthly reconciliation between entities.
Read answerHow should a restaurant categorize expenses in QuickBooks?
The default QuickBooks chart of accounts doesn't work for restaurants. You need expense categories that separate food costs, beverage costs, labor, occupancy, and supplies so you can track prime cost and see where your money actually goes.
Read answerWhat records do I need to keep for a California business and how long should I keep them?
It depends on the agency. The FTB can audit 4 to 6 years back, EDD looks at 3 years of payroll, and the CDTFA can go back 8 years on sales tax. Keep bank statements, receipts, invoices, payroll records, tax returns, contracts, and resale certificates.
Read answerIs QuickBooks Online HIPAA compliant for medical practice bookkeeping?
No. QuickBooks Online is not HIPAA compliant and Intuit does not sign Business Associate Agreements. Medical practices can still use QBO for bookkeeping, but only summary financial data should go in. Patient health information belongs in your practice management or EHR system.
Read answerHow do I classify workers as employees vs. independent contractors under California AB5?
California's AB5 law presumes every worker is an employee unless your business can prove all three parts of the ABC test. Prong B is the toughest because you have to show the worker performs tasks outside your company's usual line of business.
Read answer