It is 6 p.m. on the last day of the month, your shop holds 4,000 SKUs across two locations, and your accountant wants an ending inventory number by morning. Shutting down to count everything is out of the question — so how do you put a credible dollar figure on the stock sitting on your shelves? If you sell at reasonably consistent markups, the answer is the retail inventory method: a way to estimate what your ending inventory cost you, using nothing more than your sales records and the relationship between what you pay for goods and what you charge for them.
This guide walks through how the method works, the cost-to-retail ratio at its heart, a worked example you can adapt to your own books, and the traps — markdowns, shrinkage, uneven markups — that make the estimate go wrong.
What the Retail Inventory Method Actually Does
The retail inventory method (RIM) estimates your ending inventory at cost by working backward from retail values. The logic runs in three moves:
- You know the retail value of everything you had available to sell (beginning inventory plus purchases, all at selling price).
- You subtract what you sold (net sales at retail) to get the retail value of what should still be on hand.
- You convert that leftover retail value back to cost using your cost-to-retail ratio.
It is an estimate, not a count. It assumes that the mix of goods you sold has roughly the same markup as the mix you still hold — which is why the method works best when your markup percentages are similar across products. Large department stores and chain retailers use it to produce monthly inventory figures without counting every location; small shop owners can use the same math to close their books on time.
The Core Formula: The Cost-to-Retail Ratio
Everything hinges on one percentage: the cost-to-retail ratio (sometimes called the cost complement). It answers a simple question — for every dollar of selling price, how many cents did the merchandise cost you?
Cost-to-retail ratio = Cost of goods available for sale ÷ Retail value of goods available for sale
If you buy a candle for $12 and sell it for $20, your ratio on that item is 60%. A shop-wide ratio blends every product together: total cost of beginning inventory plus purchases, divided by the total retail value of that same merchandise.
Once you have the ratio, the ending inventory calculation is straightforward:
Ending inventory at retail = Retail value of goods available for sale − Net sales Ending inventory at cost = Ending inventory at retail × Cost-to-retail ratio
And from there, cost of goods sold falls out automatically:
Cost of goods sold = Cost of goods available for sale − Ending inventory at cost
A Worked Example: Juniper Home Goods
Say you run a home-goods boutique. At the start of March, your inventory is worth $40,000 at cost and $66,667 at retail (a 60% ratio). During March you purchase $25,000 of merchandise at cost, priced to sell at $41,667. Net sales for the month are $70,000.
Step 1 — Cost-to-retail ratio. Goods available for sale are $65,000 at cost ($40,000 + $25,000) and $108,334 at retail ($66,667 + $41,667). The ratio is $65,000 ÷ $108,334 = 60%.
Step 2 — Ending inventory at retail. Goods available at retail ($108,334) minus net sales ($70,000) leaves $38,334 still on hand at retail value.
Step 3 — Convert to cost. $38,334 × 60% = $23,000 (rounded). That is your estimated ending inventory at cost.
Step 4 — Cost of goods sold. $65,000 − $23,000 = $42,000.
In four lines of arithmetic, you have the two numbers your month-end close needs — ending inventory for the balance sheet and cost of goods sold for the income statement — without touching a single shelf.
Markups and Markdowns: Where the Math Gets Real
The simple example above assumes every item sells at its original ticket price. Real shops raise and cut prices constantly, and the retail method has specific vocabulary for tracking those changes:
- Additional markups raise a price above its original retail (a supplier cost increase you pass through). These go into both the cost column (if cost rose too) and the retail column of the ratio.
- Markup cancellations reverse part of an earlier additional markup.
- Markdowns cut a price below original retail — clearance sales, seasonal discounts, damaged-box discounts.
- Markdown cancellations reverse part of an earlier markdown (you raise a clearance price back up because stock is running low).
Net markups and net markdowns are simply each pair netted against its cancellation. Your point-of-sale system should already record sales at the actual selling price, so markdowns taken at the register flow through automatically in the net sales figure. The adjustments above matter for goods still on hand whose ticket prices changed during the period.
The Conventional Retail Method: A Conservative Twist
There are two flavors of the calculation, and they differ only in how markdowns enter the ratio:
- The average-cost version includes net markdowns in the retail denominator, spreading their effect across the whole ratio.
- The conventional retail method excludes markdowns from the ratio calculation (they are still deducted later, in the retail column, when computing ending inventory at retail).
Excluding markdowns keeps the denominator larger, which keeps the cost-to-retail ratio higher — and since that ratio multiplies a smaller ending-inventory-at-retail figure, the net effect is a lower ending inventory value. That is deliberate: the conventional method approximates the lower-of-cost-or-market rule, recognizing the loss in value from markdowns immediately rather than deferring it. It produces a lower inventory balance and higher cost of goods sold than the average-cost version whenever markdowns exist. If you take frequent markdowns, the conventional method is the more conservative — and usually more appropriate — choice.
The Shrinkage Problem: What the Formula Cannot See
The retail method assumes every dollar of retail value that was not recorded as a sale is still sitting in your store. Reality disagrees. Shoplifting, employee theft, receiving errors, damage, and spoilage all remove merchandise without generating a sale, so the formula overstates what you hold by the amount of that shrinkage.
There are two ways to handle it:
- Estimate and deduct it. Many retailers apply a historical shrinkage rate — say 1.5% of net sales — reducing ending inventory at retail before converting to cost. If your March sales were $70,000 and your shrinkage rate is 2%, you would deduct $1,400 from ending inventory at retail first.
- Reconcile with periodic physical counts. Count on a rotating or cycle-count schedule, compare the count to the method's estimate, and book the difference as a shrinkage loss. The gap between the two is itself valuable information: a widening gap means theft or process breakdowns are growing.
Never let the estimate run uncorrected for too long. The method's results are not considered adequate for year-end financial statements on their own — a physical count remains the backstop that keeps years of small errors from compounding into a fiction.
When the Method Works — and When It Misleads
It works well when:
- Your markups are consistent across products and stable over time.
- You operate multiple locations or long hours that make simultaneous physical counts impractical.
- You need monthly or quarterly inventory figures for management reporting and interim statements.
- Your point-of-sale system reliably tracks sales at retail by department or category.
It misleads when:
- Markups vary wildly. A shop blending 20%-margin electronics with 70%-margin accessories produces a blended ratio that represents neither category. The fix is to compute separate ratios per department — most POS systems can report sales by department, making this straightforward.
- Markdowns are heavy and unrecorded. If clearance discounts never make it into your retail records, ending inventory at retail stays inflated and so does the cost estimate.
- The merchandise mix shifts. After an acquisition, a big category expansion, or a season that sells through one department disproportionately, the historical ratio no longer describes what remains.
- Spoilage and damage are significant. Grocers and other perishables sellers face constant non-sale reductions that the basic formula ignores unless separately tracked.
A useful discipline: track your ratio by department, update it every period rather than reusing last quarter's, and investigate whenever the ratio moves sharply — a sudden drop often means markdowns are outpacing your records.
Retail Method vs. Gross Profit Method
Shop owners sometimes confuse the retail inventory method with the gross profit method, and the two are cousins. The gross profit method estimates cost of goods sold by applying a historical gross profit percentage to sales; it is quick but crude, and generally accepted accounting principles do not accept it for annual financial statements. The retail method is more refined because it derives its ratio from current-period cost and retail data rather than history, and the conventional variant's link to lower-of-cost-or-market gives it firmer standing. Use the gross profit method for a back-of-the-envelope check (or an insurance claim after a fire destroys your records); use the retail method for your actual interim books.
Putting It in Your Books
To use the method month after month, you need two running figures your accounting must maintain: goods available for sale at cost (from purchase records) and goods available for sale at retail (from receiving logs at ticket price, adjusted for markups and markdowns). Most small retailers already have the cost side in their bookkeeping; the retail side usually comes from the POS or inventory system. Reconciling the two each month — and booking the resulting ending inventory and cost of goods sold — is what turns a pile of sales reports into a proper month-end close.
Tracking purchases and sales in separate, clearly labeled accounts makes this routine dramatically easier. When every purchase lands in an inventory-purchases account and every sale is recorded at its actual selling price, computing the ratio is a ten-minute exercise instead of a weekend project.
Simplify Your Financial Management
As you tighten up inventory accounting and month-end routines, maintaining clear financial records is essential. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.
