Google Sheets invoice template

As a small business owner, freelancer, or self-employed professional, you do it all: from marketing your business and developing sales strategies, to customer service, and troubleshooting. You don’t have much time left over for administrative chores like invoicing. Let Wave help you manage your time more effectively by using one of our easy-to-use, fully customizable Google Sheets invoice templates. Instead of working on invoices, you could be spending your valuable time helping your business thrive. And for easy reference, we also provide you with Excel, Word, PDF and Google Docs options.

Invoice template preview

Want personalized invoices? Create them with Wave.

Sign up for free

Choose the best Google Sheets invoice template for your business

Business professional

Whether your business provides products or services, this Google Sheets invoice template will capture all the details so you are paid properly. You can use formulas to calculate fees, and enjoy the convenience of accessing your invoices anywhere there is internet.

This professional services invoice template will capture all the details so you are paid properly. You can customize it in Google Sheets and use formulas to calculate fees. Enjoy the convenience of accessing your invoices anywhere.

Small business

This Google Sheets invoice template is fully customizable so it can be used to bill all your customers – no matter how complex the formulas need to be to calculate prices. Just add lines for all the details so customers completely understand what they are paying for.

This small business invoice template is fully customizable in Google Sheets so it can be used to bill all your customers – no matter how complex the formulas need to be to calculate prices. Just add lines for all the details so customers completely understand what they are paying for.

Freelancer

Don’t use your time working on invoices for your business. Concentrate on your customers while this fully customizable Google Sheets invoice template covers all the details and calculates fees, without taking up space on your hard drive.

Don’t use your time working on invoices for your business. Concentrate on your customers while this fully customizable freelance invoice template covers all the details and calculates fees, without taking up space on your hard drive.

Consulting

Download, customize, and send this invoice to all your consulting clients. The automatic formulas in this Google Sheets invoice template make it easy to calculate hourly fees, and the format is polished and professional – just like the excellent service you provide.

Download, customize, and send this consulting invoice to all your clients. The automatic formulas in this Google Sheets invoice template make it easy to calculate hourly fees, and the format is polished and professional – just like the excellent service you provide.

Contract labor

You work hard for your clients, so you deserve an invoice template that works hard for you too. This Google Sheets invoice template is flexible, easy to use, and helps you accurately calculate your fees.

You work hard for your clients, so you deserve an invoice template that works hard for you too. This Google Sheets invoice template for contract labor is flexible, easy to use, and helps you accurately calculate your fees.

Alternatives to using Google Sheets invoice templates

Make your business a success by finding out more about what Wave can offer you. Save time and take even more work off your hands by trying our free automated invoicing and powerful accounting.

Start sending free invoices today

Why you should send professional invoices to your customers

Illustration of invoice being sent

A Google Sheets invoice template combines the best of many worlds. It can automatically figure out complex fee calculations like an Excel spreadsheet, it stores data in the cloud like Google Docs so you can access your invoices anywhere there is internet, and it allows you to create beautifully designed invoices like you can in Word.

As if that’s not enough, it’s also extremely flexible, so it can capture all the details needed to describe your hard work and ensure your clients understand exactly what they are paying for. You’ll have a clear, well-organized, easy-to-understand invoice that reflects positively on your great reputation and builds confidence and credibility in your expertise.

How to fill out your Google Sheets invoice

Once you've downloaded your free invoice template, you'll need to customize it to fit your specific business. Here are the 10 key things to include on your invoice:

  1. Title and Description: Name the project and briefly describe what type of work your client is being invoiced for.
  2. Company Details: Add your company name, address, phone number, and logo to the top-right corner.
  3. Customer Details: Under "Bill To", add your customer's name, address, and contact information.
  4. Invoice Number: Include a unique invoice number to help you track down this invoice in the future. You can format this based on sequence and customer. For example, if you're sending your very first customer their first invoice,  the invoice number could be 001-001.
  5. Dates: Include the date when your invoice has been issued and the date when payment is due.
  6. Line Item: Add individual line items for each unique good or service you provided. For each line item, include a brief description, quantity, individual unit price, and total price.
  7. Subtotal: Add up the subtotal of your goods or services, before tax has been applied.
  8. Tax: Indicate the tax rate applied to the subtotal. This is legally required to provide on invoices, and your rate may differ depending on where you run your business.
  9. Total: Outline the total amount due from the customer, after tax.
  10. Notes: Include any additional info your customer should know, including terms of service and payment terms (for example, payments are due 30 days after the invoice has been issued).

What should be included on a Google Sheets invoice?

A Google Sheets invoice has all the features and flexibility you need to get paid properly, without taking up room on your hard drive. Let the cloud help you create effective invoices by following these steps.

Start sending free invoices today
  • Look through our wide range of elegantly designed Google Sheets invoice templates in different styles and colors
  • Download the template you like best. Yes, it’s really free!
  • Insert your business name and your contact information, along with the type of business you are in. If you provide specialty services or products – you can mention it here as well
  • Add in your beautiful personal or business logo – along with your website address, and your professional designations and qualifications
  • Insert in your client’s name and up-to-date contact information
  • Generate a unique invoice number and job or client code, if applicable
  • Include the date of the invoice and the payment due date
  • List the products and/or services you provided. The Google Sheets invoice template has automatic formulas, so you can calculate all your prices and fees, as well as the amount for taxes
  • You can also easily add lines to include all the pertinent information for each individual client
  • If you are including a discount, the Google Sheets invoice template can calculate the figure. Make sure you also add a few lines to explain the reason for the lower price
  • The invoice template automatically calculates your total fees, including the applicable tax, and enters the total
  • Include your payment terms, including the methods of payment you accept
  • Make sure you add a personal touch by thanking your client for their business and telling them you’d be pleased to be of service again soon
  • Save the invoice – then send it off!

Ready to send professional invoices?

Start now

When is the right time to send a Google Sheets invoice?

If the customer has purchased a product, invoice at the time of purchase. If they have hired you for your services, you may want to invoice on completion. However, if the project is going to last for a long period of time, use a professional invoice template to calculate a percentage of the cost to be charged upfront, with the remainder being paid upon completion of the project, or send in monthly invoices.

Whatever payment period you decide, make sure it’s clearly noted on each invoice, and clarify what portion of the final ‘cost’ has been paid to date.

Illustration of hourglass timer

Quick Invoice tips before sending your first invoice

Add a little promotion

Your invoice needs to be clear and easy-to-read, but there is room on a flexible Google Sheets invoice template to add a little promotion for your business. Add a few lines to describe any other services or products you provide, or the dates of upcoming sales or special events. Let your invoice do double duty as a reminder of your great service and expertise.

Send a proforma invoice ahead of time

Make sure your clients know in advance how much you will be charging for your goods or services by sending them a proforma invoice before you start work. This can go a long way to help prevent misunderstandings that can delay payment.

Keep a record of your work with numbered invoices

Make sure you number all your invoices to help you keep track of how much money is coming in to your business. If you are providing ongoing services that will require several invoices, a job code or client code can help you keep all the invoices from that client organized and together.

Shorten your payment terms

Think about shortening your payment terms; after all, people are getting used to paying for services and products online right away. To get the money coming in even faster, you could offer a discount to customers who send in their payment early. Even just a small percentage off your bill can entice your customers enough to submit their payment ahead of time.

Free Invoice Template vs. Wave Invoicing Software

Wave
Free Invoice Template
Price
FREE
FREE
Send unlimited invoices and see when clients open them
Checkmark icon
X mark icon
Invoice anytime & accept payments online
Checkmark icon
X mark icon
Send automated late payment reminders
Checkmark icon
X mark icon
Know customers automatically get a receipt when they pay
Checkmark icon
X mark icon
Track sales and sales tax for accounting
Checkmark icon
X mark icon
Add business partners or accountants as collaborators
Checkmark icon
X mark icon
Connect your bank account easily
Checkmark icon
X mark icon
Access accountant-approved reporting for year-end
Checkmark icon
X mark icon
Do what you love. Leave the rest to us.
Let's do this