Template

Google Drive Invoice Template:Google Sheets Cells and Formulas, Invoice Numbering, PDF Export and an Indiana Garage Door Repair Example

Google Drive invoice template laid out as Google Sheets cells and formulas, with invoice numbering, PDF export and a filled Indiana garage door repair invoice.

Updated 10 min read

Download .xlsxExcel spreadsheet · 9 KB · Free, no sign-up

A Google Drive invoice template is an invoice built once in Google Sheets and copied for each job: business and customer, a number from a log, dates and terms, line items with formula totals, a taxable subtotal, sales tax, the balance due, and a PDF for the customer. The example is a garage door repair in Fort Wayne, Indiana.

The cell layout is one of the free field service templates published by FieldRanger, field service software that runs inside HubSpot. The page offers the layout as a free .xlsx download with no sign-up: a Template sheet with the cells and formulas below, which opens in Google Sheets, and a Sample sheet with the filled invoice. The fields themselves are those of the general invoice template; this page places them in cells, writes the formulas, and sets out how a folder of copies stays numbered and fixed once sent.

Google Sheets invoice cells, fields and formulas

The layout uses one tab for the invoice. Formulas sit in column E; everything else is typed.

Google Drive invoice template cells, fields and formulas
Cell or rangeFieldEntry or formula
A1Business nameTyped
A2:A4Address, phone and emailTyped
A5Tax registrationThe state sales tax registration, such as Indiana's Registered Retail Merchant Certificate number
E1Document titleINVOICE
E2Invoice numberTyped from the log, never generated inside the copy
E3Invoice dateA date, formatted as a date so arithmetic works
E4Terms in days15
E5Due date=E3+E4
A7:A9Bill toCustomer name, billing address and email
C7:C9Service address and dateThe job site and the date of the work
A11ReferencesEstimate and work order numbers
A13:F13Line headersDescription · Type · Qty · Unit price · Line total · Taxable
A14:D23Line entriesTen rows: description, Part or Labor, quantity, unit price
E14:E23Line totals=IF(C14="","",C14*D14), filled down
F14:F23Taxable flagY or N for each line, under the job site state's rule
E25Subtotal=SUM(E14:E23)
E26Taxable subtotal=SUMIF(F14:F23,"Y",E14:E23)
E27Tax rate7.00% in Indiana; the job site's combined rate elsewhere
E28Sales tax=ROUND(E26*E27,2)
E29Total=E25+E28
E30Amount paidTyped, with the date in the notes
E31Balance due=E29-E30
A33:A35Payment methods, late terms and warrantyTyped

The formulas follow Google's own function references. SUM takes values and ranges, as in =SUM(1,2,A2:A50) (Google Docs Editors Help, SUM, checked November 2026). SUMIF adds the cells of a sum range whose matching criterion cell meets a condition, as in SUMIF(A1:A10,"Paid",B1:B10) (Google Docs Editors Help, SUMIF, checked November 2026). ROUND takes a value and a number of places (Google Docs Editors Help, ROUND, checked November 2026).

Two formulas carry the design. The IF in column E leaves an unused line blank instead of showing $0.00. The SUMIF in E26 lets the Taxable column decide the tax base line by line, which a single tax rate on the subtotal cannot do when parts are taxed and labor is not. ROUND in E28 keeps the tax at whole cents, so the total on the PDF matches the total the customer adds by hand.

Both Google editors store files in Drive, and they produce different invoices. A Google Docs table holds text, so each line total and the tax are worked out by hand and typed. A Google Sheets file computes them, and a changed quantity changes the total. The layout above is for Sheets for that reason.

Google's gallery offers ready formats. Its help article on templates states that Sheets gives "an instant format for invoices, budgets, expense reports, or schedules", opened from the Sheets home page through the Template gallery at the top right; selecting a template opens a new file. Google Workspace accounts whose organization supports it can also submit a file as an organization template through the same gallery (Google Workspace Learning Center, Tips to format and customize documents, checked November 2026). A gallery invoice can take the Type and Taxable columns and the SUMIF row from the cell table above.

Filled Google Drive invoice: garage door spring and roller replacement in Fort Wayne, Indiana

The door's two torsion springs broke on a Wednesday morning, and the technician replaced them and the worn rollers on the same visit. The business, customer and prices are sample entries; the Taxable column follows the Indiana Department of Revenue bulletin cited in the next section.

Filled Google Drive invoice, header cells (sample business and entries)
CellFieldSample entry
A1:A5BusinessExample Garage Door Co. LLC · 800 Example Road, Fort Wayne, IN 46802 · 260-555-0171 · billing@example.com · RRMC 0000000000 (sample)
E2Invoice numberGD-2026-0142
E3Invoice dateNovember 12, 2026
E4, E5Terms and due date15 days · November 27, 2026
A7:A9Bill toJoan Pruitt · 4100 Example Court, Fort Wayne, IN 46815 · joan@example.com
C7:C9Service address and dateSame as billing · November 11, 2026
A11ReferencesTime-and-material work order WO-2026-0388, parts and labor stated separately
A33:A35Payment and warrantyCard by payment link, check or bank transfer · 1.5% a month after the due date, as the work order states · springs warranted 3 years, labor 1 year (sample)
Filled Google Drive invoice, line items and totals (sample prices)
RowDescriptionTypeQtyUnit priceLine totalTaxable
14Service call and door inspectionLabor1$89.00$89.00N
15Torsion springs, pair, 0.250 x 2 in x 32 in (sample size)Part1$148.00$148.00Y
16Spring replacement and door balanceLabor1.5$120.00$180.00N
17Nylon rollers, set of 10Part1$46.00$46.00Y
18Roller replacementLabor0.5$120.00$60.00N
19Lubrication, opener force and auto-reverse testLabor0.25$120.00$30.00N
25Subtotal$553.00
26Taxable subtotal$194.00
27, 28Sales tax at 7.00%$13.58
29Total$566.58
30, 31Amount paid · balance due$0.00 · $566.58

Row 14 is labelled as an inspection, not a trip or delivery fee. The visit was made to find the fault, and the Indiana bulletin ties a delivery or transportation charge to the taxability of the part it brings.

Indiana sales tax and the Taxable column

Indiana's sales tax is seven percent, collected by businesses that sell tangible personal property (Indiana Department of Revenue, sales tax, checked November 2026). Repairs to property fixed to a building follow the department's contractor rules (Indiana Department of Revenue, Sales Tax Information Bulletin #60, March 2024). The example treats the door, fastened to the house, as real property, so those rules apply.

The bulletin divides contracts in two. A time-and-material contract states the cost of materials and the cost of labor separately; the contractor is then a retail merchant selling the materials, buys them exempt with Form ST-105, holds a Registered Retail Merchant Certificate, and collects sales tax on the material portion. Installation charges separately stated on the invoice are not included in gross retail income. Under any other contract, such as a lump sum, the contractor pays tax when buying the materials and does not charge the customer sales tax. For repairs, separately stated repair parts in a time-and-material contract are taxable, and the service call and labor follow the same split.

The Taxable column is how the sheet applies that split. Under the time-and-material work order, the springs and rollers carry $13.58 of tax and the labor carries none. Quoted as one price of $553.00, the same job would show no tax at all; the business would instead pay 7% when buying the parts, $6.51 on a sample cost of $93.00, inside its price.

Invoice numbering in a Drive folder

Each invoice is a separate copy of the template, so a numbering formula inside one copy cannot see the numbers already issued. The sequence lives in a second file, an invoice log, with one row per invoice: number, date, customer, total, date paid and a link to the PDF. The next invoice takes the last number plus one. Numbers are never reused, and a voided invoice keeps its row with "void" in the paid column, so the sequence shows no gap that needs explaining.

A sent invoice has to stay as it was sent. A shared link opens the live file, which changes if anyone edits it afterwards; a PDF is fixed at export. Google's download steps are File, then Download, then a file type; for a long document in Chrome, File, then Print, with Save as PDF as the destination (Google Docs Editors Help, Create, view, or download a file, checked November 2026). Version history marks the sent state in the sheet itself: from Last edit at the top right, a version can be chosen and named through More, then Name this version (Google Docs Editors Help, version history article, checked November 2026).

The formula cells can be guarded. Data, then Protect sheets and ranges, then Add a sheet or range, with "Show a warning when editing this range", prompts anyone who edits E5 or E25:E31 to confirm the change (Google Docs Editors Help, Protect, hide and edit sheets, checked November 2026). The warning does not prevent the edit.

Google Drive invoice instructions from blank copy to sent PDF

  1. Open the master template and make a copy for the job, named with the next number from the log, such as "GD-2026-0142 Pruitt".
  2. Type the invoice number, the invoice date and the terms; confirm that E5 shows the due date.
  3. Fill the bill-to, service address and date, and the estimate and work order references.
  4. Enter one row per part and per labor operation, with Type and quantity, and mark each Taxable Y or N under the job site state's rule.
  5. Enter the job site's tax rate in E27, and check that E26 equals the sum of the Y lines.
  6. Type any payment received in E30.
  7. Download the invoice as a PDF, attach it to the email, and name the sheet's current version with the send date.
  8. Add the invoice's row to the log, then check that the log total matches E29 and that no number in the log is used twice.

Contractor invoicing software and the Drive folder

A Drive folder of copies records each invoice and nothing upstream of it: the work order the lines came from, the hours worked and the payment are typed in from elsewhere.

In FieldRanger, the invoice is generated from the completed work order instead of a copied sheet. Payment can be taken in the field through Stripe, and invoices and payments sync with QuickBooks. Job completions, notes and updates are logged to the HubSpot timeline, and job files and photos can be kept in Google Drive through the HubSpot Google Drive integration. The contractor invoicing software page sets out the invoice, and the contractor invoice template covers trade invoices with change order and deposit lines.

Each line's tax treatment, the Taxable column here, is decided by the business and its accountant. Recurring work can be charged automatically to a card on file, and a deposit invoice can go out before the job, with the balance invoiced on completion; progress billing is not built.

Frequently asked questions

Does Google Drive have an invoice template?

Google Sheets offers invoice formats in its template gallery, opened from the Sheets home page through Template gallery at the top right. The cell table on this page is a free layout with a Taxable column and a SUMIF formula, for states that tax parts and labor differently.

How to make an invoice in Google Sheets?

Put the business, customer, number and dates at the top, one row per part or labor line with quantity and unit price, a line total of quantity times price, then SUM for the subtotal, SUMIF for the taxable subtotal, ROUND for the tax, and the balance due. Export it as a PDF to send.

Is there a free Google Drive invoice template to download?

Yes. The page offers a free .xlsx download with no sign-up: the cell and formula layout on a Template sheet and the filled Fort Wayne invoice on a Sample sheet. Uploaded to Drive, the file opens in Google Sheets.

How to number invoices in Google Sheets?

Keep a separate log with one row per invoice and give each new copy the last number plus one. A formula inside one copy cannot see the other copies, and a voided invoice keeps its row so the sequence has no gaps.

Is garage door repair labor taxable in Indiana?

Under Indiana's Sales Tax Information Bulletin #60, repairs to property fixed to a building follow the contractor rules. On a time-and-material contract, separately stated repair parts are taxed at 7% and separately stated labor is not; on a lump-sum contract, the contractor pays tax on the parts and charges none.

Invoice GD-2026-0142 in the Drive folder

The PDF of GD-2026-0142 went to Joan Pruitt on November 12 with $13.58 of tax on $194.00 of springs and rollers, and the sheet's version named "sent 11-12" sits behind it. Its row in the log waits for a payment date, due by November 27. Estimate, work order and other invoice layouts are in the free field service templates hub. FieldRanger's per-technician plans are on pricing; Start free trial runs 14 days with no card, enough time to compare a generated invoice with a copied sheet on the same job.

FieldRanger runs field service inside HubSpot

Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.

Book a demo