How to create an invoice in Google Sheets or accounting software

You will build a simple invoice by filling in a spreadsheet template, then see when accounting software is the better choice. It suits freelancers and small business owners sending their first invoices. You only need a free template and your business and customer details.

How to Create an Invoice, by Accounting Stuff on YouTube. 2 min 6 s.

Video length
2 min 6 s
Time to do it
15 minutes
Difficulty
Easy
Steps
10

What you need

Steps

  1. Open a free invoice template in Google Sheets or Excel. Make a copy so the blank original stays clean for next time.

  2. Add your business details at the top: business name, address, phone, email and any tax or registration number.

  3. Fill in the customer's name, address and contact details in the bill-to section.

  4. Give the invoice a unique number, such as 2026-001, and set the invoice date and due date.

  5. Write the payment terms, for example net 14 or net 30, so the customer knows when payment is due.

  6. List each line item with a clear description, quantity, unit price and line total.

  7. Add sales tax if it applies. Check the rate for your area and apply it to the correct lines.

  8. Add payment instructions: bank name, account number, or a link to pay online.

  9. Check the totals add up, then save as a PDF and send it by email. Keep a copy for your records.

  10. If you send many invoices, try accounting software like QuickBooks Online, Xero or FreshBooks for automatic reminders and payment tracking.

Tips and common mistakes

Never reuse an invoice number, since duplicates cause confusion in your records and with customers.

Save and send invoices as PDF so the layout and totals cannot be changed by the customer.

Set the due date before you send, not after, and follow up as soon as it passes.

Keep a folder of sent invoices and mark each one paid when the money arrives.

Questions

Do I need accounting software to send an invoice?

No. A spreadsheet template works fine when you send a few invoices a month. Software helps once you want automatic reminders, online payments and tracking.

What should every invoice include?

Your business details, the customer details, a unique invoice number, the date, due date, line items, tax, total and payment instructions.

Can I make an invoice in Excel instead of Google Sheets?

Yes. The same template works in Excel. Fill in the same fields and save or export it as a PDF before sending.

This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.

More in Money & Office

See all