Industry Guides · 10 min read

Retail Bookkeeping: Managing Inventory, COGS, and Seasonal Cash Flow

Retail businesses face unique bookkeeping challenges — from inventory valuation to seasonal cash crunches. This guide shows you how to manage your retail finances and know your true profitability.

By Steady Books Team ·

Seasonal business planning calendar showing retail inventory and cash flow cycles

Retail is one of the most complex business types to manage financially because of inventory tracking, cost of goods sold calculations, sales tax complexity, and extreme seasonality. Retailers who understand their numbers make smart buying decisions, avoid cash crunches, and know which products are actually profitable.

Inventory Valuation Methods

How you value inventory affects your reported profit and your tax bill. The three main methods are: FIFO (First In, First Out) — you assume the oldest inventory is sold first. In a period of rising prices, FIFO results in lower COGS and higher profit (higher taxes). LIFO (Last In, First Out) — you assume the newest inventory is sold first. LIFO is not permitted under international accounting standards (IFRS) and many businesses are phasing it out. Weighted Average Cost — all inventory is valued at the average cost of all units on hand. This smooths out price fluctuations.

For most small Minnesota retailers, FIFO or weighted average cost is simplest and most practical. Choose a method and stick with it — changing methods requires IRS approval.

Calculating Cost of Goods Sold

COGS is the direct cost of the products you sold. The formula is: Beginning Inventory + Purchases During Period - Ending Inventory = Cost of Goods Sold. This means you must count your inventory at the start and end of each accounting period. Many retailers do quarterly or annual physical counts and use their POS system's perpetual inventory tracking in between. Your gross profit margin = (Revenue - COGS) / Revenue. Know your margin by product category, not just overall.

Point-of-Sale Reconciliation

Your POS system is the heart of retail bookkeeping. Daily, you should reconcile POS sales reports to: actual cash in drawer, credit card batch settlements, gift card sales and redemptions, and sales tax collected. Discrepancies must be investigated immediately. Monthly, reconcile your POS inventory adjustments to your physical counts and your QuickBooks inventory records.

Minnesota Sales Tax for Retail

Minnesota sales tax has unique rules retailers must understand. Clothing is exempt from Minnesota's 6.875% state sales tax (though accessories, sports equipment, and fur clothing are taxable). Food for home preparation is exempt, but prepared food (restaurant sales, hot foods) is taxable. Candy and soft drinks are taxable even though most food is not. Gift wrapping is taxable. Many retailers get this wrong and either over-collect or under-collect — both create problems.

If you sell in multiple Minnesota locations with different local tax rates, your POS must be configured to charge the correct combined rate for each location.

Seasonal Cash Flow Planning for Minnesota Retailers

Minnesota retail is highly seasonal. Holiday season (October-December) often represents 30-40% of annual sales for gift and specialty retailers. Summer seasonality affects outdoor, garden, and sporting goods retailers. The bookkeeping challenge: you must buy inventory weeks or months before your peak season, creating a cash crunch right before your highest revenue period.

Plan for this by: building a cash reserve from profitable seasons, negotiating payment terms with suppliers (Net 60-90 during your peak buying period), establishing a business line of credit during your profitable season (not when you need it), and using your prior year inventory and sales data to forecast purchases more accurately.

Shrinkage, Returns, and Write-Offs

Retail inevitably involves inventory shrinkage (theft, damage, counting errors). Track shrinkage as a separate expense line item and benchmark it against industry norms (0.5-2% of retail sales is typical). Returns require reversing the original sale and deciding whether to return the item to inventory (at original cost) or write it off. Damaged or obsolete inventory should be written down to net realizable value and expensed — do not wait until disposal to recognize the loss.

Topics

  • retail-bookkeeping
  • inventory-management
  • cogs
  • seasonal-business

Browse all bookkeeping resources