Retail P&L analysis: sales, markdowns and store costs

Retail P&L analysis explains why a store or category earned more or less after markdowns, returns, merchandise costs and operating expenses. Start with a net-sales reconciliation, then compare the same stores and trading periods before assigning the change to pricing or execution.

The general P&L method establishes the line-by-line review. Retail adds two demanding checks: whether price reductions have already entered sales, and whether the merchandise mix changed.

Start with exports that can reconcile

Use a sales export containing transaction date, store, category, item, quantity, selling price, discount and refund amount. Add the inventory cost or merchandise-cost export and an expense ledger with account, location, posting date and amount. Retain transaction and document identifiers so disputed totals can be traced back.

Choose one month-end cutoff and document whether your sales file starts at list price or the amount customers actually paid. The example below starts at list price, before discounts. Refunds are recorded at the price refunded, after the original discount; no discount is deducted twice.

The IRS explanation of gross profit subtracts returns and allowances from gross receipts to find net receipts, then subtracts cost of goods sold. That basic bridge is useful here, although your financial reporting policies determine the actual account mapping.

Exclude collected sales taxes from revenue. Keep card-processing fees in their assigned expense account rather than subtracting them from sales merely because the processor settles a net amount.

Build the monthly worksheet

A US apparel and essentials retailer compares August and September 2026 for the same stores. Both months use the same accounting classifications; the example isolates the financial movements without claiming equal trading-day productivity. Amounts below are USD, and cost lines are positive deductions.

Put the labels in column A, August in B and September in C. The first data line is spreadsheet row 2.

Enter these Excel formulas in B5, B7, B11 and B13, respectively, then copy them across:

=B2-B3-B4
=B5-B6
=B7-SUM(B8:B10)
=B11-B12

Microsoft's SUM documentation explains adding a cell range. Covirage is not affiliated with Microsoft.

Store contribution is a management subtotal with the costs shown above, rather than a universal accounting definition. Keep corporate allocations visible so a revised allocation does not appear to be a store manager's spending decision.

Net merchandise COGS includes cost reversals for saleable returned goods and any inventory adjustments assigned there. A customer refund reduces revenue; the inventory recovery reverses cost. These are separate sides of the return.

Explain the profit decline with a complete bridge

Net sales rose by $30,000, but operating profit fell by $35,000. Subtract August from September for revenue lines; reverse that sign for deductions. The bridge is:

The proof is $60,000 minus $35,000 equals $25,000. For a spreadsheet check, =C13-B13-SUM(F2:F9) must return zero when column F holds the eight effects above. This is a reconciliation of recorded movements, not proof that discounts caused every change in demand or merchandise cost.

Use flux analysis to attach an explanation and an owner to each material movement. The merchandising lead investigates discounts and category economics; store operations investigates payroll and controllable costs; finance validates postings and allocations.

Separate category mix from category margins

The same net sales and COGS split into these categories:

August category margins are 45% and 30%. At those rates, September's actual category sales would earn 558,000*45%+372,000*30%, or $362,700. At August's overall 40% margin, September's $930,000 would instead earn $372,000.

Using this stated sequence, sales growth adds $12,000 to August's $360,000 gross profit; category mix removes $9,300; within-category margin changes remove another $17,700. The reconciliation is $360,000 plus $12,000 minus $9,300 minus $17,700 equals $345,000.

This is a decomposition of the gross-profit change, already included in the operating-profit bridge. Do not add its effects to that bridge again. Overall gross profit margin falls from 40.0% to 37.1%, rounded to one decimal place.

Where retail comparisons go wrong

• Subtracting discounts twice. A net selling-price export already contains the markdown. Start at its recorded revenue and use discounts only as explanatory detail.
• Ignoring return costs. Refund totals alone do not measure lost profit. Check merchandise cost reversals, damaged stock and the return posting cutoff.
• Changing the store population. Separate new stores and closures, then explain calendar and trading-day differences before judging productivity.
• Moving expense classifications. Rent or freight shifted between COGS and operating expenses changes gross margin without necessarily changing operating profit.

Restaurants need a different operating breakdown; restaurant P&L analysis covers food and labor rather than merchandise categories.

Analyze your own retail file in Covirage

Bring your sales, return, merchandise-cost and expense exports: Covirage maps the columns, and its tools compute the comparisons and check their reconciliation. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data after setting up your business.

See FP&A reporting for the supporting finance workflow.