7 Best Google Sheets Templates to Create Invoice for Free

Small businesses, contractors, and freelancers don’t need to spend huge amounts of money on tasks such as generating an invoice. All thanks to big companies like Google and Microsoft. Free tools like Google Sheets and Google Docs can do that. Many premade invoice templates are available that need to be edited. Once edited, they are ready to be sent to the client.

Google Sheets Invoice Template Fi

The good thing about Google Sheets invoice templates is that the total amount is calculated automatically. You will have to enter the individual details and the final amount will appear.

If you are looking for blank and free invoice templates for Google Sheets, we have handpicked 7 of them. Let’s see what’s in store. But before we jump into the cool Sheets templates, it’s crucial to know how to use them.

How to Use Google Sheets Invoice Templates

Basically, to use any of the templates, open it from the provided link. Once it opens in Google Sheets, click on File > Make a copy. You will be asked to rename and select the storage location.

Google Sheets Invoice Template Free 1

Once the copied version opens in Sheets, click on the how-to image at the top (if available) and delete it.

Google Sheets Invoice Template Free 2

Then, click on the first row to select it. Right-click on it and hit Delete row. Similarly, scroll down to the bottom of the invoice and delete the last row. Then your template is ready. You can modify and send the template as shown at the end of the post.

Google Sheets Invoice Template Free 3

Let’s check the templates now.

1. Job Estimate Invoice Template

If the job description plays a vital role in your invoice, you will like this template. This template from Smartsheet offers a huge space for the same at the top. In the table, you only get two columns — description and amount, which are alternately colored. The template doesn’t support taxes.

Google Sheets Invoice Template Free 4

2. Freelance Hourly Invoice Template

The second template from Smartsheet is quite an interesting one. It is usable by freelancers who work on an hourly basis. The template offers columns for hours and rate besides description and date. Similar to other Sheet templates, the total amount for each row is calculated automatically depending on the hours spent working. It also offers a row to add a tax to the final amount.

Google Sheets Invoice Template Free 5

3. Sales Invoice Template

Another clean and blank invoice template is from WikiTemplates. In this template, each detail of the sender and receiver gets due importance. Unlike other templates, where this information is provided as one set, you will find this template slightly different. When it comes to the table, you have columns like quantity, item, description, price, amount, and sales tax.

Google Sheets Invoice Template Free 7

4. Product + Sales Invoice Template

If you are looking for an invoice that offers service and products separately, you will like this. This template provides two separate columns — one for products and second for services. The total amount from both the tables appears at the bottom and the top of the invoice. The current template is greenish. If you need a subtle version of this template, check a subtle version.

Google Sheets Invoice Template Free 6

5. Invoice Template from Fiverr

The lines in the previous template of product and sales can bother a person (it bothered me). Fortunately, And provides an alternative. It’s a clean template having two separate tables for product and services. You even have a discount and tax in the invoice. Interestingly, the invoice offers two additional feature — the ability to add a logo and payment link.

Google Sheets Invoice Template Free 8

6. Template from Invoice Simple

Looking for a unique invoice template? Try this one from Invoice Simple. In this template, your company details along with the logo get a separate space in the left sidebar. The billing details and the table are present on the right side, giving it a distinctive look. In the table, you get a description, quantity, and price columns along with discount and tax details. If you like this template, you can also check their other collection.

Google Sheets Invoice Template Free 9

7. Invoice Tracking Template

The above invoice templates focus upon the client. But if you want to track your invoices in Google Sheets, there is a special free template for that too. Offered by Smartsheet, the template offers a table with details like invoice number, date of invoice and payment, client name, description, and amount.

Google Sheets Invoice Template Free 13

How to Modify Google Sheets Invoice Templates

You can always customize the templates to suit your needs. For instance, if you like a particular template, but it doesn’t have an extra column or lacks a column, you can easily add it. For that, right-click on the table and select Insert or Delete column.

Google Sheets Invoice Template Free 10

Similarly, if you don’t like the aesthetics of the template such as its color or font, you can customize that as well using the options present in the toolbar at the top.

Google Sheets Invoice Template Free 11

How to Save Google Sheets Invoice Template as PDF

Once you have added all the necessary invoice details in the template, click on File > Download > PDF document. The document will download as a PDF on your PC.

Google Sheets Invoice Template Free 12

Spruce Your Invoices with Google Sheets Invoice Templates

Not only you can create invoice with templates in Google Sheets but you can also generate invoice automatically from data in Google Sheets. And if you want Google Sheets to send it automatically to your client, well, it has the power to do the same using scripts.

Next up: Want to create graphs and charts from your invoices? Know how to do it in Google Sheets.

Last updated on 03 February, 2022

The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.