QuickBooks Desktop for Retail: Inventory and Sales Made Simple

Set up inventory, daily sales and sales tax the right way from day one.

Retail is a numbers game played at speed. You're juggling stock, suppliers, sales tax, cash drawers and card deposits, often all before lunch. The right QuickBooks setup turns that daily chaos into clear numbers: what's selling, what's sitting on the shelf, and what you actually made this month.

Here's how to set up QuickBooks Desktop for a retail store, from choosing the right edition to the reports worth checking every week.

Which Version Fits a Retail Store?

Step 1: Turn On Inventory and Sales Tax

Go to Edit > Preferences > Items & Inventory and tick Inventory and purchase orders are active. Then go to Edit > Preferences > Sales Tax, turn it on, and set up your sales tax items and agency.

Step 2: Set Up Inventory Items

For each product you stock, create an Inventory Part item with:

• A clear name or SKU
• Purchase cost and sales price
• COGS, income and inventory asset accounts
• Reorder point, so QuickBooks reminds you when to restock
• Preferred vendor

Use sub-items to group products (Candles > Soy Candles > Lavender) so reports stay tidy. For many items, import them from a spreadsheet under File > Utilities > Import > Excel Files.

Step 3: Buy Inventory the Right Way

Create Purchase Orders to suppliers, then use Receive Inventory when the shipment arrives, and Enter Bill for Received Items when the bill comes in. This keeps your stock levels and costs accurate and shows exactly what's on order.

Step 4: Record Daily Sales

If you use a separate POS system, record one Sales Receipt per day (a "daily sales summary") with:

• Product sales by category or item
• Sales tax collected
• Discounts and returns
• Payment types: cash, card, gift card

Deposit card and cash totals into an Undeposited Funds account, then record the actual bank deposits so they match your bank statement.

Step 5: Do a Physical Count

At least once a year (quarterly is better), count your stock and use Adjust Quantity/Value on Hand to fix any differences. Shrinkage, breakage and miscounts add up, and your balance sheet should reflect what's really on the shelf.

Reports Every Retailer Should Watch

Retail Tips That Save Money

• Price with margin in mind. Compare cost and price in Sales by Item to spot products that aren't pulling their weight.
• Clear slow movers. Items that haven't sold in six months are tying up cash.
• Watch seasonal cash flow. Use last year's monthly P&L to plan stock buys before busy seasons.
• File sales tax on time. QuickBooks shows what you owe; mark your calendar for each deadline.