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 is the best way to sync Shopify or Amazon sales data with QuickBooks?
Use summary-level syncing rather than individual transactions, and map sales, fees, shipping, and refunds to separate QuickBooks accounts. Middleware tools like A2X make this cleaner for most sellers.
Read answerHow should an e-commerce business track COGS when products come from multiple suppliers?
Calculate the full landed cost for each product including the supplier price, inbound shipping, duties, and any prep or labeling fees. Set up QuickBooks Online to track inventory on a FIFO basis and review COGS by product category monthly to catch margin changes early.
Read answerWhat triggers an EDD audit for California small businesses and how can I prepare?
The most common triggers are high 1099 contractor usage, a former worker filing an unemployment claim, employee complaints, and large gaps between 1099s filed and payroll reported. Clean payroll records and proper worker classification documentation are your best defense.
Read answerHow do I handle security deposits in my rental property bookkeeping?
Security deposits are not income when you receive them. Record them as a liability on your balance sheet and only recognize income if you retain part or all of the deposit for damages or unpaid rent when the tenant moves out.
Read answerHow do I manage accounts payable for multiple food vendors with different payment terms?
Set up each vendor in QuickBooks Online with their specific payment terms and batch your payments into weekly A/P runs instead of paying bills one at a time. Separate COD vendors from Net 7 and Net 30 vendors so you never miss a delivery, and track vendor credits for returned or damaged product.
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 answer