Excel is perfect for invoices because it handles math automatically. Set up a template once with formulas, then reuse it for every client. No manual calculations or spreadsheet mistakes. Here’s how to build an invoice that works on repeat.
Create Your Column Headers and Structure
Start in a new Excel workbook. In rows 1-4, add your business name, address, phone, and email on the left side. Move to the upper right and add “INVOICE” in large, bold font. Below that, add “Invoice Number,” “Date,” and “Due Date,” leaving cells blank to fill in for each invoice.
Also in rows 1-4, add a “Bill To:” section with client name, company, and address below. This keeps all contact information in one place and clarifies who is invoicing whom.
Move down to row 6 for your table headers. Use columns A-D: “Description,” “Hours/Quantity,” “Rate,” and “Amount.” Bold these headers and add a light background color (light blue or gray) to distinguish them from data. This visual separation makes the invoice easier to scan.
Set Up Formulas for Automatic Calculations
In row 7, start entering your first service. Put the service description in column A (e.g., “Website design consultation”). Enter hours worked or quantity in column B, your hourly rate or per-unit price in column C. In column D, create a formula to multiply B times C. Type =B7*C7 and press Enter. Excel calculates instantly.
Copy this formula down for every service you plan to add. Select cell D7, copy it, then select cells D8-D20 and paste. All those cells now have formulas ready.
Below your last service row, add summary rows. Put “Subtotal” in column A with =SUM(D7:D20) in column D. On the next row, add “Tax” if applicable and multiply the subtotal by your tax rate (e.g., =D22*0.08 for 8% tax). Then create a “Total Due” row. Use =D22+D23 to combine them.
Format for Clarity and Professionalism
Make content readable by adjusting column widths. Double-click the border between column headers to auto-fit, or drag them wider manually. Column A should fit full service descriptions. Columns B and C can be narrower. Column D needs enough space for currency.
Format numbers as currency. Select all cells in column D with amounts, right-click, and choose “Format Cells.” Select “Currency” and pick your symbol. This turns 1500 into $1,500.00 automatically. For subtotal, tax, and total due rows, bold the text and add a background color to make them stand out.
Below the total due, add a “Payment Terms:” section explaining your terms (Net 15, Due upon receipt). Add a “Payment Methods” section listing how clients can pay: bank transfer, PayPal, check, or credit card.
Save and Protect Your Template
Once your invoice looks good, save it as “Invoice Template - Services Rendered.xlsx” in a templates folder. Before creating your first real invoice, test it with sample data and verify all formulas work. Check that the total due matches your manual math.
Protect your template from accidental changes using Excel’s Sheet Protection. Go to the Review tab, click “Protect Sheet,” and set a password if you want. This locks all cells but allows editing in specific cells (like client name and service descriptions).
Create a new copy of your template file for each invoice. Name it with the invoice number and client name (e.g., “INV-001 - Acme Corp.xlsx”). This keeps your records organized. Export to PDF before sending to lock formatting and create a professional archive.
Related: For faster invoicing across multiple formats, see how to make an invoice as a freelancer for workflow tips.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
