# Google Sheets Invoice Template (2024 Update)

May 8, 2024

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

Select File > Make a copy.

## How to Create an Invoice Template in Google Sheets

### 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.