Google Sheets Invoice

The Google Sheets (and Docs) Invoice Templates utilize Google Drive’s user-friendly and free platform, making them the perfect guides for creating orderly, useable invoices ready to send to clients. All five (5) versions below are fully editable once copied into a Google Drive Account. A few of the fields and features that the invoices include are: tables to list out charges, auto-calculating fields, note areas for payment instructions, and fields for the contact information of both the seller and provider, to name a few.

  1. Google Sheets Invoice Templates
  2. Google Sheets Invoice Template Free
  3. Google Sheets

Below are the download links to 5 Google Sheets Invoice Templates. To aid in selection, a brief description of each invoice has been included as well.

In this tutorial we'll create an invoice template in Google Sheets. Access Google Sheets: The first thing that you are going to have to do when it comes to making an invoice via Google Sheets is to learn how to access it. What this means is that you will need a Gmail account if you want to be able to make it in Google Sheets. Google Sheets Invoice Template Options The Google Sheets invoice templates created by JobFLEX have become very popular for contractors. However, it does not matter which industry you are in because our templates are versatile and flexible to meet the needs of nearly any small business. This tutorial will show you how you can create a data entry form in Google Sheet. With Google Sheets, it has many advantages over data entry forms like MS Access installed on your local computer. The default form option comes with the Google sheet (Google Form) is not suitable for mass data entry works. Instead of that, you can use Google Apps.

The Simple Invoice is just as it sounds. With limited color, basic fields, and a minimalist design, the Simple Invoice is ready to be customized to a company’s theme, or left alone to appear clean and professional. For formats in Adobe PDF, Microsoft Word, or Excel, visit the Blank Invoice page.

Google Sheets Invoice Templates

This version should be used by companies or workers that need to be reimbursed for materials that were purchased or sold to a client in addition to service(s) that were rendered to the client as well. Examples of professions that should use this invoice are Mechanics, Contractors, Landscapers, Photographers, and HVAC Workers.

Use the Sales Invoice if a company is selling a product to their customers. Examples of who would use this invoice include Retail companies, Salesman, Online Merchants, and several others. Essentially, anyone that requires payment for a good can utilize this invoice.

The Service Invoice should be used only when a service was conducted for the client. Some professions where this invoice is commonly used include Attorneys, Consultants, Medical Professionals, Graphic Designers, House Cleaners, and Artists. Click the link below to download the Service Invoice in Google Sheets.

The Shipping (Proforma) Invoice is very similar to the Sales + Product Invoice, with the major difference being that it is designed to be used with a company that also needs to ship goods to the customer or worksite. Out of the 4 invoices above, this is the most comprehensive. For formats in PDF (.pdf), Word (.docx), or Excel (.xlsx), visit the Proforma Invoice page.

Google Sheets Invoice Template Free

Step 1 – Click either the green or blue button next to the invoice type that would like to be used. If the user is currently signed out of their Google Account, they will be brought to a screen that either says “Sign In” or “Choose an account”. If either of those screens are shown, head to Step 2. If the “Copy document” page appears, proceed to Step 4.

Google sheets invoice tracker

Google Sheets


Step 2 – If “Choose an account” is displayed, select the Google Account that would like to be used to save the invoice, and proceed to the next step. If “Sign In” appears, enter the email address or phone number of the Google account that would like to be used. Once entered, click the “Next” button.

Step 3 – Enter the password for the Google Account and click the blue “Next” button. If the password is unknown, select “Forgot password?” to reset the password for the Google Account.


Step 4 – On the “Copy document” screen, click “Make a copy” to download the invoice to the user’s account.

For those looking for an editable invoice in either PDF or Word, download the simple invoice – this form contains bare-essential fields and minimal colors and is ready to be customized to the preferences of the providing company, sole-practitioner, or freelancer.

Google Sheets Invoice

Optional cookies and other technologies

We use analytics cookies to ensure you get the best experience on our website. You can decline analytics cookies and navigate our website, however cookies must be consented to and enabled prior to using the FreshBooks platform. To learn about how we use your data, please Read our Privacy Policy. Necessary cookies will remain enabled to provide core functionality such as security, network management, and accessibility. You may disable these by changing your browser settings, but this may affect how the website functions.

To learn more about how we use your data, please read our Privacy Statement.