Retail sales analysis report sample with checks

A retail sales analysis report sample should connect gross sales, discounts, returns and cost to checked net sales and gross profit by store and product. The report becomes useful when the reader can explain the change against a comparable period and assign the next action.

The example below uses an illustrative US retailer with stores in Austin and Denver. It is a report layout and worked calculation, with no downloadable workbook promised.

Put the reporting basis above the results

Elm Street Retail compares matched four-week periods for the same stores and product groups. Both stores follow the same trading schedule in the two periods. The prior-period column uses the same net-sales definition as the current period.

All amounts are USD. Gross sales are merchandise sales before discounts and returns; discounts and returns are separate positive deductions. Sales tax collected for remittance is excluded. The Census Bureau's retail-sales definitions likewise describe sales net of customer refunds and allowances and exclude sales taxes collected directly from customers and paid to government.

The cost column is the matched cost of goods sold, already reduced for returned merchandise recovered into inventory where appropriate. It is not purchases during the period. Finance supplies that classification and the cost amounts; the sales review does not change the accounting policy.

State these choices prominently. An attractive report cannot repair a current period that includes sales tax or a prior period covering a different set of stores.

Start with the store-and-product inputs

Keep transaction and return identifiers in the source workbook. The report below summarizes those source rows into a manageable review grain: one store and product group per reporting period.

These are the report's inputs, not independent totals copied into presentation cells. Each column must sum from its underlying transaction or finance rows. Discounts must not include the refunds already recorded in returns.

Net sales = Gross sales - Discounts - Returns

Gross profit = Net sales - Net cost of goods sold

Gross margin = Gross profit / Net sales

Sales growth = (Current net sales - Prior comparable net sales) / Prior comparable net sales

The IRS retail gross-profit illustration follows the same basic sequence: reduce gross receipts for returns and allowances, then subtract cost of goods sold. Use the fuller gross profit margin guide for the distinction between margin and markup.

Show the worked results beside the comparison

For Austin Home, net sales are 60,000 - 3,000 - 2,000 = $55,000. Gross profit is 55,000 - 33,000 = $22,000. Margin is 22,000 / 55,000 = 40.0%, and sales growth is (55,000 - 50,000) / 50,000 = 10.0%.

Apply those steps to every row:

Dollar amounts are exact in this example. Percentages are calculated from unrounded amounts and displayed to one decimal. The total growth calculation is 9,000 / 153,000 = 5.9%; total margin is 63,500 / 162,000 = 39.2%. Neither total is an average of the displayed percentages.

The report supports a focused conclusion: Home sales increased in both stores, while Denver Apparel declined and had a lower margin. The table alone cannot establish whether pricing, availability or customer demand caused those movements. The merchandising owner should review the product detail and return reasons before changing an assortment.

For a spreadsheet-oriented presentation of similar comparisons, see the monthly sales analysis report. Keep the store-and-product view here as the retail-specific review.

Reconcile the report in both directions

The first check is the revenue identity: 180,000 - 9,000 - 9,000 = $162,000. The second is the profit identity: 162,000 - 98,500 = $63,500. Both must hold for each row as well as the total.

Then regroup the same rows by store:

The store totals and the product-detail totals agree. Finally, reconcile net sales with the sales ledger and COGS with the finance cost extract for the same periods and stores. Document timing differences and approved adjustments explicitly. A mathematical identity proves consistency inside the report; agreement with the source exports checks completeness.

Retain row references for every exception. The practical test in citations on every number is whether the reader can get from a reported result back to the records that produced it.

Change one input: an additional refund

Suppose Denver Apparel records an additional $2,000 refund in the current reporting period. This specific refund has no recoverable inventory and no COGS adjustment; all other inputs remain fixed. The returns input increases from $2,500 to $4,500 for that row.

The refund reduces net sales and gross profit by the same dollar amount under this assumption. When merchandise is returned to usable inventory, include the corresponding approved cost reversal; do not carry this unchanged-cost assumption into that case. The treatment of credit notes and returns deserves a consistent period rule.

Where retail reports go wrong

• Gross and net mixed together. One period before discounts and another after discounts create artificial growth.
• Returns counted twice. A negative sale row and a separate refund extract can represent the same transaction. Match identifiers before combining them.
• Purchases treated as COGS. Inventory bought during the period is not necessarily inventory sold. Use the matched finance cost extract.
• Changed store populations. Separate openings, closures and temporary shutdowns from comparable-store results.
• Margin percentages averaged. Divide total gross profit by total net sales, especially when product margins differ.

Review your own retail workbook in Covirage

Bring your sales workbook, return records, prior comparable period and approved cost extract to Covirage. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows.

Create a free Covirage account and bring a sample of your own data. Creating the account takes about a minute; then you set up your business and bring your files.

See sales insights for the supporting sales-review context.