Get a copy of our free Google Sheets invoice template here.
Select File > Make a copy.
Follow the steps below to create a Google Sheets invoice template.
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.
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.
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.
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.
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.
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.
