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
How should a wholesale company handle inventory valuation in QuickBooks?
QuickBooks Online uses FIFO by default, which works well for most wholesale distributors. The bigger challenge is keeping your book inventory accurate through regular physical counts and variance reporting.
Read answerHow should a medical practice allocate shared overhead costs across multiple locations?
Pick an allocation method that reflects how each location actually drives the cost. Revenue-based, patient volume, headcount, and square footage are the most common approaches. The method you choose matters less than documenting it and applying it consistently.
Read answerWhat financial reports should a healthcare practice owner review monthly?
Focus on your P&L by location and provider, A/R aging for both insurance and patient balances, net collection rate, overhead ratio, and cash flow statement. These reports together tell you whether your practice is financially healthy or heading toward trouble.
Read answerHow do I manage cash flow when inventory purchases are large and payment terms are long?
The gap between paying vendors and collecting from customers can stretch 60 to 120 days for wholesale businesses. Shortening that cycle requires tracking inventory turnover, negotiating terms on both sides, and forecasting cash flow weekly.
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 answerWhat is landed cost and how do I track it for imported goods?
Landed cost is the total cost of getting a product to your warehouse, including freight, duties, insurance, and handling fees. For accurate COGS, all of these costs must be allocated to inventory rather than expensed separately.
Read answer