Retail Invoice Template

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.

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.