Billed

Google Sheets Invoice Template

Two spreadsheet invoices to open in Google Sheets, a calculator with discount, shipping and tax and an hourly timesheet invoice, as Excel files plus Word and blank PDF versions

Create Your InvoiceView All Templates

No credit card required.

Quick answer:These Google Sheets invoice templates are two spreadsheets with formulas. The invoice calculator multiplies quantity by unit price on each line, then applies a discount rate, a shipping amount and a tax rate (on the subtotal less the discount, plus shipping) to reach the amount due. The hourly timesheet invoice lists each work session's date, task, start and end times and hours × rate. Each comes as an Excel file to open in Google Sheets, a Word version and a blank PDF. The formulas haven't been tested in Google Sheets, so check them after opening.

INVOICE

From

Business name:
Example Office Supply
Address:
31 Example Street, Sampletown
Phone / email:
[Phone or email]

Invoice details

Invoice no.:
GS-5104
Invoice date:
Nov 9, 2026
Payment terms:
Net 30
Due date:
Dec 9, 2026

Bill to

Company:
Example Accounting LLP
Address:
400 Sample Way, Sampletown
Email:
[Email]

Items

  • Description: Wireless keyboardAmount: 245.00
    Qty:
    5
    Unit:
    each
    Unit price:
    49.00
  • Description: USB-C hubAmount: 162.50
    Qty:
    5
    Unit:
    each
    Unit price:
    32.50
  • Description: Setup and configurationAmount: 150.00
    Qty:
    2.5
    Unit:
    hour
    Unit price:
    60.00
Subtotal
557.50
Discount (10%)
55.75
Shipping
18.00
Sales tax, if applicable (0%)
0.00
Amount due
519.75

How to pay

Accepted methods:
Bank transfer or check
Account name:
[Account name]
Bank details:
[Bank name, account and routing numbers]
Payment reference:
Invoice GS-5104

Notes

  • Sample terms: a 10% discount on this order, as quoted.
  • The tax applies to the subtotal less the discount, plus shipping.

Thank you for your business.

Invoice calculator with tax and discount: sample preview. Download it below with the other layout.

Key Features

Everything you need in a professional invoice template.

Invoice calculator: quantity × unit price on every line, a discount rate cell, a shipping amount and a tax rate cell
Tax worked out on the subtotal less the discount, plus shipping, then the amount due
Hourly timesheet invoice: date, task, start and end times, hours × rate for each session, and a billing period
Rate cells start at 0% for tax; set a rate to 0% or shipping to 0.00 instead of deleting rows
Excel (.xlsx) files to open in Google Sheets, Word versions and blank PDFs

Download one of 2 invoice layouts

The PDF is a blank invoice to print and fill in by hand. The Word and Excel files contain the sample details shown in the preview, ready for you to replace with your own.

INVOICE

From

Business name:
Example Office Supply
Address:
31 Example Street, Sampletown
Phone / email:
[Phone or email]

Invoice details

Invoice no.:
GS-5104
Invoice date:
Nov 9, 2026
Payment terms:
Net 30
Due date:
Dec 9, 2026

Bill to

Company:
Example Accounting LLP
Address:
400 Sample Way, Sampletown
Email:
[Email]

Items

  • Description: Wireless keyboardAmount: 245.00
    Qty:
    5
    Unit:
    each
    Unit price:
    49.00
  • Description: USB-C hubAmount: 162.50
    Qty:
    5
    Unit:
    each
    Unit price:
    32.50
  • Description: Setup and configurationAmount: 150.00
    Qty:
    2.5
    Unit:
    hour
    Unit price:
    60.00
Subtotal
557.50
Discount (10%)
55.75
Shipping
18.00
Sales tax, if applicable (0%)
0.00
Amount due
519.75

How to pay

Accepted methods:
Bank transfer or check
Account name:
[Account name]
Bank details:
[Bank name, account and routing numbers]
Payment reference:
Invoice GS-5104

Notes

  • Sample terms: a 10% discount on this order, as quoted.
  • The tax applies to the subtotal less the discount, plus shipping.

Thank you for your business.

Invoice calculator with tax and discount

A spreadsheet invoice that does the math: quantity times unit price on every line, a discount rate cell, a shipping amount, a tax rate cell and the amount due, all recalculated as you type.

A request for payment — shows the amount due

In the Excel file, each line amount is a formula: "Qty" × "Unit price". The subtotal, discount, tax and amount due are formulas too. The discount and tax rates sit in their own cells, so you can change them.

Download

TIMESHEET INVOICE

From

Name or business:
Example Data Services
Address:
17 Example Road, Sampletown
Phone / email:
[Phone or email]

Invoice details

Invoice no.:
GS-5110
Invoice date:
Nov 16, 2026
Payment terms:
Net 15
Due date:
Dec 1, 2026
Billing period:
Nov 2-13, 2026

Bill to

Company:
Example Retail Co.
Attention:
Morgan Example
Address:
220 Sample Plaza, Sampletown
Email:
[Email]

Timesheet

  • Task: Data cleanupAmount: 192.50
    Date:
    Nov 2
    Start:
    9:00 a.m.
    End:
    12:30 p.m.
    Hours:
    3.5
    Rate:
    55.00
  • Task: Monthly report buildAmount: 220.00
    Date:
    Nov 3
    Start:
    1:00 p.m.
    End:
    5:00 p.m.
    Hours:
    4
    Rate:
    55.00
  • Task: Client call and revisionsAmount: 68.75
    Date:
    Nov 5
    Start:
    10:00 a.m.
    End:
    11:15 a.m.
    Hours:
    1.25
    Rate:
    55.00
  • Task: Dashboard updatesAmount: 137.50
    Date:
    Nov 9
    Start:
    9:30 a.m.
    End:
    12:00 p.m.
    Hours:
    2.5
    Rate:
    55.00
  • Task: Weekly sales reportAmount: 137.50
    Date:
    Nov 12
    Start:
    2:00 p.m.
    End:
    4:30 p.m.
    Hours:
    2.5
    Rate:
    55.00
Subtotal
756.25
Sales tax, if applicable (0%)
0.00
Amount due
756.25

How to pay

Accepted methods:
Bank transfer or check
Account name:
[Account name]
Bank details:
[Bank name, account and routing numbers]
Payment reference:
Invoice GS-5110

Timesheet notes

  • Hours are recorded to the nearest quarter hour: 13.75 hours in this period.
  • Detailed notes for each session are available on request.

Thank you for your business.

Hourly timesheet invoice

A spreadsheet invoice built from a timesheet: each work session with its date, task, start and end times and hours at an hourly rate, a tax rate cell and the amount due.

A request for payment — shows the amount due

In the Excel file, each line amount is a formula: "Hours" × "Rate". The subtotal, tax and amount due are formulas too. The tax rate sits in its own cell, so you can change it.

Download

Which spreadsheet to use

Both are spreadsheet invoices: the line amounts and totals are formulas, so the invoice recalculates when you change a quantity, rate or hours. Each one comes as an Excel (.xlsx) file you can open in Google Sheets, a Word file with the same layout, and a blank PDF.

  • Invoice calculator with tax and discount. For orders that need more than a total, it has a discount rate, a shipping amount and a tax rate, each in its own cell. In the sample, an office supplier bills an accounting firm on Net 30 terms:

    • 5 keyboards at 49.00, 245.00;
    • 5 USB-C hubs at 32.50, 162.50;
    • 2.5 hours of setup at 60.00, 150.00.

    That's a subtotal of 557.50. Less a 10% discount (55.75), plus 18.00 shipping, with tax at 0%, the amount due is 519.75.

  • Hourly timesheet invoice. For time billed at an hourly rate, each work session is its own row: date, task, start, end, hours, rate and amount. In the sample, a data analyst bills a retailer for five sessions over a billing period, 13.75 hours at 55.00. That's 756.25 due on Net 15 terms.

For a document-style invoice that reads like a letter, use the Google Docs invoice template.

How to open the .xlsx file in Google Sheets

The downloads are Excel files, not shared Google Sheets links. There are two ways to bring one into Google Sheets:

  1. Upload and open from Google Drive. Upload the .xlsx to Drive, double-click it, and click Open with Google Sheets at the top of the preview. To convert it to a native Sheets file, choose File › Save as Google Sheets. If you don't convert it, Google says "any changes you make are saved in the original Excel format" (Use both Excel & Sheets).
  2. Import into a spreadsheet you already have open. In Sheets, choose File › Import and pick the .xlsx (Import data sets & spreadsheets).

The formulas were written as Excel formulas and haven't been tested in Google Sheets. After opening, change one quantity and one rate, and check that the line amount, subtotal and amount due all update before you rely on the sheet.

How the calculator works out the total

The totals run in this order, so you can check them by hand:

  1. Subtotal: the sum of the line amounts, each quantity × unit price.
  2. Discount: the subtotal × the discount rate. The sample's 10% is labeled "Sample terms" in the notes in the Word and Excel files.
  3. Shipping: an amount you type.
  4. Sales tax, if applicable: the tax rate × (subtotal − discount + shipping). The sample note says so: "The tax applies to the subtotal less the discount, plus shipping."
  5. Amount due: subtotal − discount + shipping + tax.

Whether shipping is taxed, and whether tax is worked out before or after a discount, depends on where you sell. If the rule where you work differs, change the tax formula to match, and change the note too. Check with the tax agency where you work. The tax rate starts at 0%.

To leave out the discount or the tax, set its rate to 0%; to leave out shipping, set it to 0.00. Don't delete those rows, because the amount due refers to them. The items table has seven rows. For more, insert rows inside the table and copy the amount formula into them so the subtotal includes them.

Filling in the timesheet invoice

  • Billing period. Put the dates the invoice covers in "Billing period", so the client can match it to their own records.
  • One row per session. Enter the date, a task description the client will recognize, and the start and end times.
  • Hours. Type the hours for each session. The Hours column isn't calculated from the start and end times, so check that they agree. The sample's notes say hours "are recorded to the nearest quarter hour", for example 10:00 a.m. to 11:15 a.m. is 1.25 hours.
  • Rate and amount. Each row's amount is hours × rate, and the rows add up to the subtotal. A different rate for some work, such as meetings, goes in that row's rate cell.

The timesheet has ten rows. For a longer period, insert rows inside the table and copy the amount formula into them. To leave tax out, keep the rate at 0% rather than deleting the row.

Protecting the formula cells

To stop the amount and total cells from being typed over, select them and use Data › Protect sheets and ranges. You can limit who can edit the range, or choose "Show a warning when editing this range". Google notes that protection "shouldn't be used as a security measure" (Protect, hide & edit sheets).

If you protect cells in Excel before uploading, set the protection again in Sheets. Google says that in a protected Excel workbook, "your locked and hidden cells become viewable and editable in Google Sheets" (Work with Office files).

Sending the invoice from Google Sheets

Send the client a PDF rather than the spreadsheet, so the formulas and other tabs stay with you. In Sheets, click File, then Download, and choose "PDF Document (.pdf)" (Download a file). The file's template tip sits below the invoice and is meant to stay off the printout. Check that it doesn't appear in the PDF, or print only the invoice cells: Google's Print from Google Sheets explains how to print just the cells you've selected.

For the next invoice, make a copy of your filled-in sheet with File › Make a copy (Create, view, or download a file). Then change the invoice number, dates, client and lines.

Invoice, estimate or receipt?

An invoice asks for payment for work done or goods supplied, by a due date. Two other documents come at other points in the sale, and both have Google Sheets versions:

Other invoice formats

The same kind of invoice is also available as templates for Excel, for Word, as a PDF and for Google Docs. All invoice templates are in the invoice template gallery.

Invoicing in Billed

If you track your hours in Billed, you can invoice hourly projects from tracked time: set a project's hourly rate, and Billed tracks the charge for each task as you log it, so you can invoice one task or several from the project dashboard. Clients can pay online by card or PayPal, and Billed can send automatic reminders for overdue invoices.

Skip the Templates — Create Invoices Online

Create and send invoices with Billed, accept card and PayPal payments on them, and send payment reminders.

Try Billed For Free

No credit card required.

What's included in this invoice template

Spreadsheet Best for Calculates
Invoice calculator Orders with a discount, shipping or tax Lines, discount, tax, amount due
Hourly timesheet invoice Time billed by the hour Hours × rate per session, amount due

When this isn't for you

If you want a plain document-style invoice without formulas, the Google Docs invoice template fits better. If you're pricing work before it starts, use the Google Sheets estimate template; for a payment you've already received, use the Google Sheets receipt template.

How To Send Invoices With Billed

Billed lets you send invoices by email or link, take card and PayPal payments on them, and send payment reminders.

1

Sign Up Free

Create your free Billed account. No credit card required.

2

Create Your Invoice

Choose an invoice template and add your logo, business details and payment terms.

3

Send It and Follow Up

Email the invoice or share its link. Connect Stripe or PayPal to accept card and PayPal payments on it, and send payment reminders.

Frequently Asked Questions

Common questions about this invoice template.

Related Templates

Explore more templates for your business.

Free Excel Invoice TemplateView Template
Google Docs Invoice TemplateView Template
Free PDF Invoice Templates (Blank, Print and Fill)View Template
Simple Invoice Template: Free Template & GuideView Template
View all templates

Related Articles

Learn more about creating professional invoices for your business.

Estimating

Estimate vs Invoice Best Practices for SMBs

Read Article
Invoicing

AI Invoicing Automation: What It Does and Where to Start

Read Article
Invoicing

Best Invoicing Software for Mac: Native Apps vs Browser Tools

Read Article

Ready To Create Your Invoice?

Create and send invoices with Billed, accept card and PayPal payments on them, and send payment reminders.

Get Started For Free

No credit card required.