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. Once the copied version opens in Sheets, click on the how-to image at the top (if available) and delete it. 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. 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. View Job Estimate Template
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. View Freelance Template
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. View Sales Invoice Template
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. View Product + Sales Invoice Template
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. View Invoice Template from Fiverr
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. View Template from Invoice Simple
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. View Invoice Tracking Template
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. 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.
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.
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.
