How to Make an Invoice in Excel or Google Docs (Free, 2026)
How to make an invoice in Excel, Google Sheets or Google Docs: the fields to include, the formulas, saving as PDF, emailing it, and when to use software.
By Seayora Editorial Team · Published · Facts checked · 2 min read
Short answer: To make an invoice in Excel or Google Docs, start from a blank sheet or a template, add your business details, the customer, a unique invoice number, the date and due date, a line for each item with quantity, rate and amount, a subtotal, tax and total, and your payment terms and methods. In a spreadsheet, use formulas so each amount is quantity × rate and the total adds itself. Save the invoice as a PDF and email it with a short message. A spreadsheet works for a few invoices a month; software saves time once you need reminders, online payment and records.
Key takeaways
- Include your details, the customer, invoice number, dates, lines, totals and terms.
- In Excel or Sheets, let formulas do the arithmetic.
- Send a PDF, never an editable file.
- Keep a log of invoice numbers so none is skipped or reused.
What should an invoice include?
- Your business name, address and contact details.
- The customer’s name and billing address, and the job address if different.
- A unique invoice number, the invoice date and the due date.
- The customer’s PO number, if they use one; see PO numbers on invoices.
- Each item or service: description, quantity, rate and amount.
- Subtotal, any sales tax, and the total due.
- Payment terms (for example net 30) and how to pay.
How do you make an invoice in Excel or Google Sheets?
- Put your business details at the top left and "INVOICE" with the number and dates at the top right.
- Add the customer block below.
- Make a table with columns Description, Quantity, Rate, Amount.
- In the Amount column use a formula such as =B10*C10 and copy it down.
- Add Subtotal (=SUM of the Amount column), Tax (=Subtotal × your rate) and Total.
- Add terms and payment instructions at the bottom.
- Save a copy as a template, then File → Download or Save as → PDF for each invoice.
How do you make an invoice in Google Docs?
Insert a table for the line items and type the details around it, or start from a template. Docs does not calculate, so check every amount and total by hand, then File → Download → PDF. If you send many invoices, a spreadsheet or the free invoice template avoids arithmetic mistakes.
How do you send an invoice by email?
Attach the PDF and write a short message with the invoice number, the amount, the due date and how to pay; use a subject such as "Invoice 1042 from [your business], due December 15". Keep a log of what you sent and when. Seayora’s software for contractors is free: estimates, invoices, scheduling, crews, client records and online payments, with 3.8% taken only when you are paid for a completed job. Each invoice is sent from the app with a link the customer can pay online, and reminders go out on the schedule you choose.
Frequently asked questions
Does Excel have invoice templates?
Yes, Excel and Google Sheets include invoice templates. Check that the formulas are correct and that the invoice number is unique each time.
Is it OK to send an invoice as a Word or Excel file?
Send a PDF instead: it looks the same on every device and cannot be changed by accident.
How do I make an invoice for free?
Use a spreadsheet or document template, or a free online invoice template, and save it as a PDF.
How Seayora helps
Free invoice template: Fill in the lines and download a numbered, totaled invoice as a PDF.
How we write and check these guides: editorial standards.
Related on Seayora
- Free Invoice App for Small Business (2026): What to Look For — Guide. What a free invoice app for a small service business should do: simple invoices, online payment, reminders, sales tax, estimates, and what free costs later.
- Batch invoicing, emailing invoices and follow-ups — Documentation. Invoice every finished job at once, email each invoice to its customer, and send reminders on unpaid invoices until they are paid.
- Net 30 Payment Terms: Meaning, Examples and Other Invoice Terms (2026) — Guide. What net 30 means on an invoice, how to work out the due date, and what due on receipt, net 15, EOM and 2/10 net 30 mean, with examples.
- Field Service Management Software for Small Business (2026) — Guide. Field service management software for small businesses: what it should do, free options, working with QuickBooks, and pricing that fits a crew of one to ten.
- Writing Estimates — Documentation. How to keep your clients and their service addresses, build an accurate estimate with hours, your costs and discounts, get it approved inside your team, send it with Approve and Decline buttons and the PDF, forward it, answer your customer’s replies, plan and get reminded about the site visit, and turn an accepted estimate into an invoice or scheduled work.
- Take-offs: Count the Materials for a Job and Price It Into an Estimate — Documentation. Measure a job once — or read the rooms from a blueprint with AI — and work out every trade on it: drywall sheets laid out wall by wall, tiles counted in their pattern, receptacles and circuits by the electrical code your state adopted, and more. Then price it from your own prices into a draft estimate.