How do I copy a Google Sheets invoice template?

Select Copy Google Sheets Template under a preview. Follow the copy prompt and sign in to Google if asked. Name the copy with the customer and invoice number before editing. Keep a blank version for the next invoice.

Can someone else help fill in the invoice?

Yes. Share the working file with the people who need to edit or review it. Give each person the access they need and agree who will do the final check. Send the customer the finished PDF or a file containing only their invoice.

Will the subtotal include rows I add to the sheet?

Check the subtotal formula after adding rows. Each new charge needs an amount calculated from its own quantity and price, and the subtotal must include that amount. Compare the result with the sum of the line amounts before sending.

Can I hide other customers’ tabs before sharing the spreadsheet?

Do not rely on hidden tabs to keep customer details private. Send a PDF containing only the current invoice, or create a separate file for that customer. Review the whole file before giving anyone access.

How do I print only the invoice, not the whole spreadsheet?

On a computer, select the invoice sheet or highlight the invoice cells. Choose File, then Print, and select Current sheet or Selected cells. Check that the preview includes the total and terms, with readable text and no unrelated tabs or extra pages.

Can I reuse the sheet for next month’s invoice?

Yes. Make a new copy and give it a new invoice number. Update the billing period and dates. Check visits and rates for the new month. Review the formulas again, and keep the invoice you previously sent unchanged.

Does the template record customer payments automatically?

Record payments and follow-up dates yourself. Check your payment records rather than assuming the spreadsheet updates automatically. To keep payments with an invoice in Docelf, create the invoice there first. You can record each payment and see the remaining balance.

Free Google Sheets Invoice Template

Update rates and totals in Google Sheets

Use an online invoice layout instead of formatting a shared spreadsheet for your customer. Keep the charges and payment instructions together so your customer can see how to pay.

Prefer to work in Google Sheets? Use a free template below.

Create Invoice Online

14-day free trial. No credit card required.

Copy a Free Google Sheets Invoice Template

Open a template in Google Sheets and follow the copy prompt. Keep a blank version for reuse, and prepare a separate invoice for each customer.

Browse six more Google Sheets invoice layouts below.

How to Fill In a Google Sheets Invoice

Gather the details for this invoice before you start. The Docelf illustration shows the main invoice fields; your Google Sheets layout may arrange them differently.

Docelf invoice illustration with numbered fields for business, customer, charges, and payment details

Add Your Business: Enter your business name and billing contact details.
Add Your Logo: Keep your logo clear of the header text and use readable colors.
Check the Customer: Confirm the customer’s billing name and email.
Add the Number and Dates: Set a unique invoice number, issue date, and payment due date.
List What You Provided: Add each service or product with its quantity and price.
Check the Calculations: Review the formulas and check any discount or tax before you send.
Write Payment Instructions: Add the payment method and agreed terms to the invoice.

How to Fill In Google Sheets Invoice Line Items

List the work completed during the billing period. Check dates and quantities against your shared job record so you do not bill for a visit twice.

This fictional property maintenance invoice covers one month of visits. It uses US dollars and adds an illustrative 8% sales tax to all three charges.

QTY	Description	Unit Price	Amount
4	Courtyard cleanup — visits	$45.00	$180.00
2	Trash bin cleaning — visits	$25.00	$50.00
1	Walkway rinse	$70.00	$70.00

	Subtotal	$300.00
	Sales Tax (8% example)	$24.00
	Total	$324.00

In this example, $180.00 + $50.00 + $70.00 gives a $300.00 subtotal. The example tax is $24.00, making the total $324.00. Use the tax treatment that applies to your services.

What to Include in Google Sheets Invoice Terms

Keep the Terms and Conditions field on the invoice itself. Your customer may not see payment instructions left in a comment or another tab.

Update the billing period and due date for this invoice. Use the payment instructions and terms you agreed with the customer. Adapt the example below for the visits you are billing.

Example: Terms and Conditions

This invoice covers the visits listed for [Billing Period].
Payment is due by [Due Date] using the payment details shown.
Include invoice [Invoice Number] as the payment reference.
Please contact [Billing Email] with questions about the listed visits.

Keep the Invoice and Its Payment Status Together

Record each payment on your Docelf invoice. You can see how much the customer still owes. Reuse saved customer details for the next bill.

Create Invoice Online

Check the Details With Your Team

A teammate may know how many visits were completed while someone else has the agreed prices. Choose one person to review their entries against the job record before sending, checking for duplicate visits and old rates.

Show Teammates Which Cells to Edit

Show teammates where to enter quantities and prices. When you add or move a charge, check that its line amount uses that row’s quantity and price, and that the subtotal includes it. Protect formula cells to help prevent accidental edits. This does not keep customer information private.

Keep Each Customer’s Copy Separate

Do not send a spreadsheet containing other customers’ invoices, even when those tabs are hidden. Send a PDF of the customer’s invoice or use a separate file with only their information.

Preview the Invoice Before You Share It

On a computer, select the invoice sheet or highlight the cells containing the invoice. Choose File, then Print, and select Current sheet or Selected cells. Check the preview before continuing.

Include all charges, totals, and payment instructions in the selected area.
Check the currency and dates in the final copy.
Make sure long descriptions and the logo do not cover amounts.
Check that the customer can open the file when you send a link instead of a PDF.

To save a PDF, choose File, then Download, and select PDF as the file type. Check that the export includes only the intended invoice, then keep the exact copy you send. A short invoice email message can identify the bill and its due date, with a thank-you rather than a repeat of the spreadsheet details.

Choose Between Google Sheets and Docelf

Google Sheets gives your team a shared place to enter quantities and prices. Check the formulas before you send the finished invoice. Keep your own payment record.

Choose the Docelf online invoice template when you prefer to create and email the bill in one place. You can see whether the emailed invoice was delivered and opened. After you record a payment, create a receipt from the invoice.

The Google Sheets file and a Docelf invoice are separate. Select Create Invoice Online to create the invoice in Docelf.

More Google Sheets Invoice Layouts

These six layouts include hourly, itemized, and sample invoices. Each preview opens its own Google Sheets copy link.

Compare Spreadsheet and Document Formats

Use Excel for an XLSX file, or keep working with Google Sheets in your browser. Google Docs and Word suit invoices you prefer to edit as documents rather than spreadsheets.

Google Sheets Invoice Template FAQs

How do I copy a Google Sheets invoice template?

Select Copy Google Sheets Template under a preview. Follow the copy prompt and sign in to Google if asked. Name the copy with the customer and invoice number before editing. Keep a blank version for the next invoice.
Can someone else help fill in the invoice?

Yes. Share the working file with the people who need to edit or review it. Give each person the access they need and agree who will do the final check. Send the customer the finished PDF or a file containing only their invoice.
Will the subtotal include rows I add to the sheet?

Check the subtotal formula after adding rows. Each new charge needs an amount calculated from its own quantity and price, and the subtotal must include that amount. Compare the result with the sum of the line amounts before sending.
Can I hide other customers’ tabs before sharing the spreadsheet?

Do not rely on hidden tabs to keep customer details private. Send a PDF containing only the current invoice, or create a separate file for that customer. Review the whole file before giving anyone access.
How do I print only the invoice, not the whole spreadsheet?

On a computer, select the invoice sheet or highlight the invoice cells. Choose File, then Print, and select Current sheet or Selected cells. Check that the preview includes the total and terms, with readable text and no unrelated tabs or extra pages.
Can I reuse the sheet for next month’s invoice?

Yes. Make a new copy and give it a new invoice number. Update the billing period and dates. Check visits and rates for the new month. Review the formulas again, and keep the invoice you previously sent unchanged.
Does the template record customer payments automatically?

Record payments and follow-up dates yourself. Check your payment records rather than assuming the spreadsheet updates automatically. To keep payments with an invoice in Docelf, create the invoice there first. You can record each payment and see the remaining balance.

Ready to Keep Your Invoices in Docelf?

Create the invoice in Docelf and keep it with your other business documents.

Calculate the charges without spreadsheet setup
See when the customer opens the emailed invoice
Record payments and see the remaining balance

Create Invoice Online

Free Google Sheets Invoice Template

Copy a Free Google Sheets Invoice Template