Sales Invoice Essentials 模板
Invoice template for product-based sales. List items with quantities, unit prices, and descriptions - totals and taxes calculate automatically.
包含内容
- Product sales invoice layout with item name, SKU or reference, quantity, and unit price columns
- Automatic line total, subtotal, and tax calculations that update as you enter product quantities and prices
- Shipping and discount fields with separate rows for shipping charges, discounts, and adjustments before total
- Order reference number and purchase order fields for matching the invoice to the original customer order
- Print-ready professional format with company and customer details plus color-coded input cells for entry
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
预览
查看此模板的内容
如何使用这个Sales Invoice模板
Enter seller and buyer info
Fill in your company details and the customer name, address, and purchase order number if applicable.
Add product line items
Enter each product with name, SKU or reference, quantity ordered, and unit price. Line totals calculate automatically.
Apply discounts and shipping
Enter any discounts, shipping charges, or adjustments in the designated rows before the final total.
Finalize the invoice
Review the subtotal, tax, and grand total. Add the invoice date, payment terms, and due date before sending.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
Can I add a purchase order number?
Yes. The template includes fields for purchase order number and order reference to match invoices with customer orders.
How do I apply a discount?
Enter the discount amount or percentage in the discount row. The grand total subtracts the discount from the subtotal before adding tax.
Does it handle shipping charges?
Yes. A separate shipping row lets you add shipping costs that are included in the grand total but calculated outside of tax if needed.
Can I include SKU numbers?
Yes. Each line item has a SKU or reference field alongside the product name and description.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。