Google Sheets Invoice Templates; How to Create one

Are you struggling with finding the right template for your monthly invoicing?

Sometimes, that can be hard and struggling, especially when you are a perfectionist. I’ve been there. In my first freelance job, I was not sure what is the right format and template for my invoice.

I couldn’t find the good and FREE one online, and finally, I got some ideas from a colleague of mine.

My solution for that is the Google Sheets invoice template.

In this post, I will share some templates with you, that you can easily edit and adjust to your own need.

Before anything else, you need a Google account, if you don’t have one, follow this link, we have a guide to that. But if your Google account is set, let’s start.

Start with Google Sheets

Log In To Your Google Account

Use The Google Sheets Template Gallery

Now, Open The Template Gallery

Google Sheets Template Gallery

This is the link to the template gallery

Choose Your Invoice Template

Invoice Template Google Sheets

Yes, you just made it.

Customize Google Sheets Invoice Template

Now, you can customize this invoice with editing these items:

  • Add Name of your company (or Yourself if you are a freelancer)
  • Add the logo (if you have one)
  • Add the name, quantity, and price of items or services
  • Under Invoice For is a place for your customer information
  • Payable to is a place for you
  • Invoice # is a place for the invoice number. If you don’t know, An invoice number is a unique, sequential code that is systematically assigned to invoices.
  • A project is a place for the title and name of your project.
  • Due Date (Unsurprisingly, the main reason to state a set due date on an invoice is to encourage your customers to pay you within a certain period of time. While it is possible to agree on a later payment date, a customer should pay you within 30 days. I am writing 14 days 😉 )

Export The Templates

After that, your invoice is ready, you can export PDF file from it.


PDF Export


Now, your file is ready to send. I hope you will receive your money on-time and enjoy your earning.

Tips for using Google Sheets Invoice Template

But before leaving I have some more tips for you:

  • You can save the template with your data and use it for future needs
  • You can connect this with a sheet of your item and services when you have many items with different prices, you can call them and in the final version have just a drop-down menu.
  • If you log your working hours in the timesheet, that can be integrated into the invoice as well.

Google Sheets Formula for invoices

List of Google Sheets Formula that might be helpful for invoicing:

More Free Templates for Google Sheets Invoice

If you are unhappy with this google Sheets Invoice template, I have a list of more templates for you.

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.

Service Invoice Template

Invoice template

This Google Sheets invoice template is made for service providers and includes enough space for an itemized list of services, along with hourly rates and total costs.

You can add the tax rate for your state, or any other fees or expenses, and the template will automatically calculate the amount due. This template provides a simple layout with room for comments or instructions. Thank SmartSheets for all of their efforts

Copy the template


Packing Slip Template


A packing slip details the items ordered and sent in a delivery. Including a packing slip in a shipment can help rectify any discrepancies between items ordered and delivered, because customers can clearly see the reason(s) for undelivered items.

A packing slip can help reduce shipping errors and provide clear communication for buyers, especially for businesses that need to sort and manage inventory as it arrives. This template includes space for a manager’s approval to sign off on the items listed.


Copy the Open Packing Slip Template

Job Estimate Template

Job Estimate Template - Google Sheets

A job estimate provides clients with a description of services to be completed along with an estimate for hours spent and costs incurred. You can create an itemized list of services on this job estimate template so that clients understand all charges.

This basic template can be modified to include additional information, such as payment terms and deadlines.

Copy the Open Job Estimate Template

Blank Invoice Template

Open Blank Invoice Template

Use this blank template to enter all the crucial details needed to create a thorough invoice, including business information, customer info, a description of the product or service provided, and the amount due.

You may want to include an invoice ID and issue date for easy tracking, a payment due deadline, and any other important terms that the business or individual receiving the invoice needs to know. You can also include additional notes.

Copy the Open Blank Invoice Template

Purchase Order Template

A purchase order is similar to a commercial invoice, but the buyer provides it to a supplier in order to request goods or services.

By accepting it, the seller creates a contract with the buyer based on the terms outlined in the purchase order.

This purchase order template provides just enough detail to make the process straightforward for both buyers and sellers.

Open Purchase Order Template – Google Sheets

Sales Invoice Template

Sales Invoice Template - Google Sheets

If you’re invoicing for goods sold rather than services provided, this template includes fields for a salesperson name, shipping information, item numbers, and unit prices.

It calculates product costs into a subtotal, and you can add tax and shipping and handling charges for a final amount due.

Customize the template by adding a company logo or changing the colors or formatting.

Open Sales Invoice Template – Google Sheets

Billing Invoice Template

Open Billing Invoice Template

A billing invoice template is suitable for businesses providing goods or services. This template includes an invoice number and customer ID for tracking purposes, shipping information, unit prices, and more.

Additionally, you can modify the template to suit your needs and those of your customers.

This basic Google Sheets invoice template also includes the option for adding tax.

Open Billing Invoice Template

Legal Invoice Template

Legal Invoice Template - Google Sheets

This invoice template is designed for legal services, providing space for case details, billable hours, and costs. Attorneys can use this template to offer clients a professional and detailed invoice that documents the type of legal services provided and completed tasks. Additionally, you can personalize this Google Sheet template by adding a law firm name and logo.

Open Legal Invoice Template

Final words

As you see in templates before with Google Docs, you can create invoices that meet your needs and then save them to the cloud, so you can access the invoices from anywhere.

Enjoy 🙂