Sales Invoice - Excel Template

In plain language: Identifies both parties by their full legal names, registered addresses, tax IDs, and designated contacts for billing and accounts payable.

Common mistake: Using a trade name instead of the registered legal entity name — corporate AP systems match the invoice entity to the vendor master record, and a mismatch stalls payment or triggers a dispute.

In plain language: Assigns a unique identifier to the invoice, records when it was created, and states the specific calendar date by which payment is due.

Common mistake: Writing 'due upon receipt' instead of a specific due date — buyers interpret this inconsistently and AP systems cannot auto-schedule payment without a fixed date.

In plain language: Lists each product sold on its own row with a specific description or SKU, the number of units, the price per unit, and the calculated line total.

Common mistake: Using vague descriptions like 'Merchandise' or 'Goods' — customs authorities, auditors, and buyers' AP teams all require specific product descriptions to approve and classify the purchase.

In plain language: Calculates the sum of all line items before adjustments, deducts any agreed trade or volume discounts, and applies the correct tax rate to the post-discount subtotal.

Common mistake: Applying tax to the pre-discount subtotal rather than the post-discount amount, which overcharges the buyer and creates a tax filing discrepancy.

In plain language: States the final payable amount prominently in a specified currency so there is no ambiguity about what is owed.

Common mistake: Omitting the currency code on invoices sent to international buyers — USD and CAD, or GBP and EUR, are easy to confuse and a currency mismatch can result in underpayment that the seller has no clean remedy for.

In plain language: Provides the complete information the buyer needs to remit payment — bank wire details, ACH routing, check payable to, or a payment-portal link — so there is no delay caused by missing information.

Common mistake: Including payment instructions only in the email body and not on the invoice itself — when the invoice is printed or forwarded, the payment details are lost.

In plain language: Establishes the interest rate or fixed fee that accrues on overdue balances, providing a contractual basis to charge interest without separate negotiation.

Common mistake: Setting a penalty rate above the statutory maximum in the buyer's jurisdiction — courts will void the clause entirely rather than reduce it, leaving the seller with no contractual interest remedy.

In plain language: Specifies the point at which ownership of goods and the risk of damage or loss transfers from the seller to the buyer during transit.

Common mistake: Leaving FOB terms undefined — if goods are damaged in transit and neither party has specified who bears the risk, the dispute defaults to costly litigation rather than an insurance claim.

In plain language: States the window within which the buyer must raise defects, shortages, or disputes, and the process for handling returns or adjustments.

Common mistake: No claims period at all — without one, buyers in many jurisdictions can raise disputes months after delivery, well after the seller has closed the books on the transaction.

In plain language: Identifies which jurisdiction's laws govern the invoice and payment obligation, and where disputes must be resolved, providing certainty for both parties.

Common mistake: Choosing a governing law jurisdiction with no connection to where the buyer or seller operates — some jurisdictions refuse to enforce choice-of-law clauses that are purely opportunistic, leaving the governing law undefined.

A sales invoice is a commercial document a seller issues to a buyer to formally request payment for goods sold and delivered. It identifies both parties, itemizes the products with quantities and unit prices, states the total amount due, and sets a specific payment deadline. In most jurisdictions, a properly issued sales invoice creates a legally enforceable payment obligation and serves as the primary evidence for accounts-receivable management and tax compliance.

A sales invoice is a general-purpose billing document used for any product sale. A commercial invoice is a specific version used in international trade that adds customs-required fields such as country of origin, harmonized tariff codes (HTS), declared value, and Incoterms. For domestic sales, a standard sales invoice is sufficient. For cross-border shipments, a commercial invoice is required by customs authorities in most countries.

A sales invoice is generally enforceable as evidence of a payment obligation when it references an underlying purchase order, contract, or accepted order confirmation. The invoice itself is not a contract — it documents a transaction that the parties already agreed to. Courts typically treat a signed or accepted invoice as prima facie evidence of the debt. Including governing-law language and a signed acknowledgment strengthens enforceability significantly.

In most jurisdictions, a sales invoice does not require a signature to be valid as a billing document. However, a seller's signature or authorized stamp strengthens enforceability and is required by some buyers' AP policies, certain government procurement rules, and customs authorities for international shipments. Including a signature block costs nothing and reduces disputes over invoice authenticity.

Requirements vary by jurisdiction. In the US, invoices must show the seller's EIN and the applicable sales tax amount and rate for taxable goods. In Canada, GST/HST-registered sellers must show their GST registration number and the tax amount. In the UK and EU, VAT invoices must include the seller's VAT registration number, the VAT rate, and the VAT amount as a separate line item. Missing tax information can result in buyers being unable to claim input tax credits and can trigger tax authority inquiries.

Net 30 is the most common standard for B2B product invoicing. Smaller suppliers often negotiate Net 15 to improve cash flow. Large corporate buyers may impose Net 45 or Net 60. Always pair the terms with a specific due date and include a late-payment penalty clause — typically 1.5% per month — to incentivize timely payment and preserve your right to charge interest without separate negotiation.

FOB stands for Free On Board and specifies the point at which title and risk of loss transfer from seller to buyer during shipping. FOB Origin means the buyer takes responsibility once the carrier picks up the goods at the seller's facility. FOB Destination means the seller retains responsibility until the goods arrive at the buyer's location. Leaving FOB terms undefined on a product invoice is a common and costly mistake — if goods are lost or damaged in transit and no FOB term is stated, both parties may dispute liability and neither may have adequate insurance coverage.

The IRS requires businesses to retain records supporting income and deductions for at least 3 years from the filing date, and up to 7 years if there is any possibility of underreported income. In Canada, CRA requires 6 years. In the UK, HMRC requires 6 years for VAT records and 6 years for corporation tax records. For cross-border sales subject to customs audit, retain invoices for at least 5 years. Storing both the editable Excel source and the signed PDF export gives you the best audit trail.

A proforma invoice is a preliminary document issued before goods are shipped or delivered, used to confirm pricing and terms, request a deposit, or satisfy customs pre-clearance requirements. It does not create a formal accounts-receivable entry or a legal payment obligation. A sales invoice is issued after delivery and creates the enforceable payment demand. Use the proforma to set expectations and the sales invoice to collect.