Manufacturing Invoice Template

Setup takes about 20 minutes. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Customer Price List sheet — enter your part numbers and the negotiated prices for each customer. If you have multiple customers on different pricing tiers, create one section per customer. This one-time setup means every future invoice pulls the correct price automatically when you enter the customer name and part number, eliminating the most common billing error in manufacturing. Then update the Invoice sheet header with your company name, address, EIN, and default payment terms.

To create an invoice, open the Invoice sheet and enter the customer name, their PO number, your internal job or work order number, the invoice date, and the ship-to address. Add line items for each billable component: production units (part number, quantity, unit price from the price list), setup fees if applicable, any outside processing charges passed through from subcontractors, and material surcharges if your contract includes commodity price adjustments. The net amount due, early payment discount, and freight charges calculate automatically. When done, export to PDF and log the invoice in the Invoice Log.

The Invoice Log is where ongoing management happens. After each payment clears, update the status from Outstanding to Paid and enter the payment date. The log calculates average days to payment over time — useful for identifying which customers consistently pay late and whether your Net 30 terms are actually being respected. Check the Tooling and Setup Log quarterly to confirm that all tooling charges for new part introductions have been billed and that no amortized tooling fees have been missed. Manufacturers who use the log consistently report that it cuts their receivables follow-up time in half because every outstanding invoice is visible in one place.

Manufacturing invoicing is more complex than most industries because a single invoice can contain five different billing types at once: a production run at a negotiated per-unit price, a setup charge for the job, a material surcharge tied to a commodity index, an outside processing pass-through from a heat treater, and freight on top. Generic invoice templates have none of this structure — they're designed for consultants billing hourly or retailers billing for single items. The result for manufacturers is hours spent reformatting templates, billing errors when the wrong price tier gets used, and tooling or setup charges that slip through unbilled because there's no system for tracking them.

Every manufacturing invoice should tie back to a customer purchase order. This isn't just good practice — most manufacturing customers will not pay an invoice that doesn't reference their PO number, and many require the PO number to match exactly. The ship-to address matters just as much as the bill-to address, particularly for distributors and OEM customers who receive goods at a different location than their accounts payable department. Material surcharges and freight terms (FOB origin vs. FOB destination) need to be explicit on the invoice to avoid disputes. Tooling fees deserve their own line item, not just because they're large, but because they often have different billing timing than production runs — sometimes invoiced upfront, sometimes amortized, sometimes billed on first production ship.

The operational discipline around manufacturing invoicing is about making sure every billable event actually gets billed. Setup fees are the most commonly missed item — a changeover costs $200–$500 in machine time and labor, and shops that don't invoice it consistently are subsidizing their customers without realizing it. Outside processing is the second common gap: a subcontracted plating job gets paid to the vendor but never invoiced to the customer because it was treated as overhead rather than a pass-through. And volume pricing tiers, if not enforced systematically, lead to under-billing customers who've grown past a price break threshold. The Customer Price List and Tooling Log in this template are specifically designed to close those gaps.