BillCanvas
USUnited States

Home/Templates/Google Sheets

Templates · Google Sheets

Free invoice template for Google Sheets

Import the XLSX into Google Sheets and the formulas come with it: enter quantities and rates, set the tax rate, and the totals update.

Invoice template (.xlsx for Google Sheets)

US Letter print area · live formulas · 10 line rows

Download .xlsx Fill it in online

Google Sheets imports .xlsx. Formulas carry over; check the print area and column widths after import.

What the workbook includes

  • Invoice sheet with 10 line rows and a US Letter print area
  • Amount, subtotal, tax, total and balance formulas
  • A Read me sheet with the steps
  • No macros or protected sheets
Free invoice template for Google Sheets preview
Invoice template (.xlsx for Google Sheets) · Google Sheets · open full size

How to import it into Google Sheets

  1. Download the .xlsx file.
  2. In Google Drive, choose New → File upload, then upload the workbook.
  3. Right-click the file and choose Open with → Google Sheets.
  4. Enter the quantities, rates and tax rate; the formulas recalculate.
  5. Choose File → Download → PDF or Print, and check the print area.

What carries over

The formulas, number formats and most styling carry over. Google Sheets may adjust column widths and the print area; check File → Print and set the paper to Letter, portrait, fit to width.

Adding rows

Insert a row above the last line item so the SUM range expands, or extend the subtotal formula to the new row. Do not type over the amount or total formulas unless you intend to replace them.

Sharing

For approval, share the sheet with “Commenter” access or send a PDF export. If you share edit access, the client can change the numbers. Save the final PDF for your records.

FAQ

Do the formulas work in Google Sheets?

Yes. The amount, subtotal, tax, total and balance formulas carry over from the XLSX. Check the tax rate cell after import.

Is a Google account required?

Yes, to edit in Google Sheets. The XLSX also works in Excel and LibreOffice without an account.

How do I print it?

File → Print, set Letter, portrait, fit to width. Google Sheets may reset the print area; select the invoice range if needed.

Can I add more line items?

Insert a row above the last line so the SUM range expands, or extend the formula to the new row.

Related templates

Invoice for Google Docs

DOCX import with fields ready.

Invoice template for Excel

Formulas for amount, tax and balance.

Invoice generator

Fill the same layout online and download a PDF.

All templates →