Skip to content
Pocket Invoice: Free Invoice MakerFree Invoice Maker

Quantities, rates and totals

Google Sheets estimate and quote templates

Download the Excel file. Upload it to your Google Drive and edit it with Google Sheets. Or you can convert it to your own copy of a native spreadsheet. There are 6 rows for line items. Both templates. And you have discounts, tax rate, advance payment, outstanding balance. So, you can build an estimate or quote for a job.

These are XLSX files for you to import. These are not Google Sheets copy links hosted here on this website. To save it in your Google Drive (your own) you need a Google account. If you need mainly to edit long work descriptions, terms, read how to work with Google Docs templates.

Convert the downloaded file to your own Google spreadsheet

  1. Download the above estimate/quote Excel workbook.
  2. Google Drive → New → File upload.
  3. Open this file you've uploaded with Google Sheets.
  4. File → Save as Google Sheets. Create your own native copy of the spreadsheet.
  5. Edit all your business and customer information. Document and project references. Dates. Work descriptions. Amounts.

Google has a guide on how to import and convert from Excel to Sheets. Once you've done that, please check formatting, formulas before you use it for a customer document.

What are you inputting and what are you calculating through formulas?

LocationPurposeInput method
Line item rows 15-20.C - Quantity, D - Unit, E - Unit price, F - Taxable?, G - Amount.Input Quantity, Unit, Unit Price. Formula for Amount - Quantity*Unit Price. Leave it as is.
G22 G23.Subtotal, Discount.Formula for Sum for Subtotal. Leave it as is. Input the discount as an amount, not a percentage.
G24 G25.Tax rate, Tax.Enter % Tax rate. Leave the calculation if this method applies.
G26 G27 G28.Total. Advance Payment. Outstanding balance.Total = Subtotal - Discount + Tax. Input the actual amount of Advance payment you received. Outstanding balance = Total - Advance payment.

F - dropdown shows Yes/No. Tax formula takes Yes marked line items. If you only translate options without changing the formula, it will cause calculation errors. Currency name change doesn't automatically change the amount using an exchange rate.

There's a defined scope for the tax formula.

It sums the line items marked Yes. Then minus total document discount. If it's negative, then zero. Then multiply with one Tax rate. It doesn't allocate the discount proportionally to taxable/non-taxable items. It doesn't simultaneously calculate multiple Tax rates.

Let's say subtotal of $300 is all taxable. Minus discount $20. Tax rate is 5%. Tax = $14. Total = $294. You got an advance payment of $100. Outstanding balance = $194.

It's just an example. The spreadsheet formula doesn't tell you what tax rate or treatment should be used for the business.

If your actual transaction does discount allocation or Tax calculation differently, then you need to change the formula before issuing the document. Say if your price is inclusive of tax or exclusive of tax. You need to track the rate and relevant items.

For adding line items, you need to change sum ranges.

So the subtotal and tax formulas originally sum rows 15-20. If there're some new items that are not in that range, then although they're shown on the table, they're not automatically included. You need to include the new row's amount formula. And change the subtotal/taxable items sum ranges. You can test them with some known values that you can confirm. Don't mix number inputs and calculation cells.

Are you exporting the PDF or printing it out? Look at print area and page breaks. Check the customer info, quantity unit, currency, total amount and outstanding balance. Check the whole PDF after export.

Have an editable version with the document number. This way you can trace the content confirmed by your customer.