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 do I separate personal and business expenses when a doctor owns the practice building?
The standard approach is to hold the building in a separate LLC from the medical practice. The practice pays fair market rent to the property LLC, and both entities maintain completely separate books.
Read answerWhat is the cost of setting up payroll for a small business in California?
The upfront setup cost is just the beginning. Between payroll software, employer taxes, workers' comp insurance, and potential setup fees, expect total payroll overhead to add 20-30% on top of gross wages for a small team.
Read answerHow do I set up QuickBooks Online for a new California business?
Start by creating your QBO account and selecting an industry-appropriate chart of accounts. From there, connect your bank accounts, configure California sales tax with the correct local district rates, and set up invoicing and payroll.
Read answerWhat is the difference between cash basis and accrual basis bookkeeping?
Cash basis records revenue when you receive payment and expenses when you pay them. Accrual basis records revenue when earned and expenses when incurred, regardless of when money changes hands. The right choice depends on your business type and how you get paid.
Read answerHow much does a bookkeeper cost for a small business in Orange County or Los Angeles?
Monthly bookkeeping for small businesses in Orange County and Los Angeles typically runs $200 to $800 per month. The actual cost depends on your total monthly expenses, number of accounts, and whether you need specialized industry knowledge.
Read answerHow do I handle equipment depreciation for medical devices and clinical equipment?
Medical devices and clinical equipment are capitalized as fixed assets and depreciated over their useful life rather than expensed in one year. Most equipment falls into 5 to 7 year recovery periods, though Section 179 and bonus depreciation can accelerate the deduction. Proper tracking with serial numbers and a fixed asset register is essential for audits and insurance.
Read answer