In this article:

Google Sheets Invoice Template (2024 Update)

May 8, 2024

Google Sheets Invoice Template

Get a copy of our free Google Sheets invoice template here.

google sheets invoice template

Select File > Make a copy.

invoice template google sheets

How to Create an Invoice Template in Google Sheets

Follow the steps below to create a Google Sheets invoice template. 

1. Set Up Invoice Information

In the section where you list products or services, create columns for Description, Quantity, Unit Price, and Total Price. Label each column at the top, starting from Column A to Column D. Create a dedicated section for your client's information. Include rows for the client's name, address, phone number, and email, making sure to label each row clearly.

2. Input Formula to Calculate Total Price for Each Item

Click on the first cell under Total Price (assuming D9, following the previously mentioned structure). Enter the formula =B9*C9 to multiply Quantity by Unit Price, then press Enter. After applying the formula, click on the cell again to see a small square (fill handle) in the bottom right corner. Drag this down to apply the formula to the rest of the Total Price column.

3. Sum Up All Item Total Prices to Calculate Subtotal

At the end of your product or service list, add a row for calculating the subtotal.  Select the cell under Total Price where you want the Subtotal to appear. Enter the formula =SUM(D9:D10) to sum all values in the Total Price column.

4. Use Formula to Calculate Tax Based on Subtotal

Select the cell under Subtotal for Tax (D13, following the example), enter the formula to calculate tax. If your tax rate is 10%, use =D12*0.10. Press Enter to see the tax amount calculated based on the Subtotal.

5. Add Any Additional Fees Below Tax Calculation

Manually input any flat fees in the next row under Tax (D14). If the fee is a percentage of the subtotal, use a formula similar to the tax calculation.

6. Calculate Total Due 

Create a final row at the bottom for the Total Due. This row will sum the Subtotal, Tax, and any Additional Fees.

We hope that you now have a better understanding of how to create a Google Sheets invoice template and use our Google Sheets invoice template. If you enjoyed this article, you might also like our article on how to create a budget template in Google Sheets or our article on setting up a Google Sheets expense tracker template.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->