Retail Invoice Template

Setup takes about 20 minutes the first time. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Product Catalog sheet: add your SKUs, product descriptions, units of measure, costs, and prices. You don't need to enter every product before creating your first invoice — add products as you use them and the catalog will grow naturally. Once a SKU is in the catalog, it auto-populates the Invoice sheet every time you enter that code, so you never have to retype a product name or look up a price again.

For each new invoice, fill in the customer's billing and shipping address, their PO number if they have one, and the invoice date and payment terms. Enter SKU codes in the line item table and quantities — the description and unit price pull from the Product Catalog automatically. Enter any trade discount for this customer's account in the discount column. Check the tax rate cell at the bottom and adjust it if the customer's state or jurisdiction has a different rate. When the invoice looks correct, print it or export to PDF and send it. Log the invoice in the Order Log with a status of Outstanding.

Check the Order Log at least once a week to see which invoices are approaching their due date or already overdue. Most wholesale buyers and trade account customers pay on Net 30 terms; following up at day 25 with a reminder prevents late payments from becoming disputes. At the end of each month, open the Sales Summary and review your gross margin for the period — if margin is below your target, the order-level detail in the Order Log shows which customers or product categories are driving the gap. Retail businesses that track gross margin monthly catch pricing and discount problems before they compound across a season.

Most retail invoice templates are built for freelancers — they have a single service line and a due date. That structure doesn't work for retail because retail invoices are fundamentally different: they have multiple SKUs, unit prices that need to match a price list, trade discounts that vary by account, and tax rules that depend on the customer's location and the product category. When a retailer invoices a wholesale buyer with a generic template, they typically spend 10–15 minutes manually entering product details for each invoice, and pricing errors from typing prices by hand are common. A retail-specific template with a product catalog and SKU lookup eliminates both problems.

The other dimension that generic templates miss is accounts receivable management. Retail businesses that sell to trade accounts — interior designers, property managers, B2B buyers, boutique chains — routinely have 20–50 open invoices at any given time with different due dates and partial payment histories. Without an order log that tracks payment status across all open invoices, it's easy to let Net 30 invoices slide to Net 60 or beyond without realizing it. The cash flow impact compounds quickly: if your average wholesale order is $1,200 and you have 15 outstanding invoices, that's $18,000 in receivables that your bank account doesn't reflect. Tracking it in a structured log, not a mental list, is what keeps accounts from going stale.

The metric that drives retail profitability isn't revenue — it's gross margin. A retail business can grow top-line sales by offering steep discounts to wholesale accounts and end up with less cash than the year before. The standard gross margin benchmarks for specialty retail run between 45% and 55%; for fashion and apparel they run higher, and for electronics and commodities lower. Tracking gross margin monthly, not just annually, lets you catch when trade discounts are eroding margin before they affect your ability to reorder inventory. This template is built around that workflow: invoice at the right price, track what's owed, and measure margin on what you sold.