How do I copy one of these Google Sheets receipt templates?

Select Copy Google Sheets Template on a preview and follow the copy prompt. Give the spreadsheet a name that includes the receipt number. Keep a blank version for later payments and fill in a separate working copy.

Can a teammate help fill in the receipt?

Yes. Share the working copy with the people who need to contribute. Agree who checks the actual payment before sending. Give the customer a finished PDF or a separate file containing only their receipt.

Does a calculated total mean the customer has paid?

No. The total is the charge for the listed items. Check your payment record and enter the amount actually received. In the rental example, the customer’s $111.24 payment covers the full booking.

Is the receipt date the rental or service date?

The receipt date is the date you received payment, even if you prepare or send it later. Label the rental period or service date separately in the item description or Notes. This keeps an advance payment clear when the rental or service takes place later.

What should the receipt for the remaining payment show?

Record only the new payment on a new receipt, using the date you received it. Show earlier payments separately so nothing is counted twice. Mark the booking paid in full once those payments settle the rental total.

Does copying the template also create a receipt in Docelf?

No. The copy link creates a Google Sheets file. Create Receipt Online opens Docelf separately, where you can create and email a receipt or download a PDF. The two copies do not update one another.

Free Google Sheets Receipt Template

Update receipt totals without fixing formulas

Skip formulas, manual totals and receipt formatting in Google Sheets. The online option keeps the payment details together and gives you a clear receipt to send or save.

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

Create Receipt Online

14-day free trial. No credit card required.

Copy a Free Google Sheets Receipt Template

Open a preview and follow the Google Sheets copy prompt. You can fill in your own spreadsheet while keeping an untouched version for reuse. Create Receipt Online takes you to Docelf, not to a Google Sheets file.

There are six more Google Sheets layouts below for hourly work and different item lists.

How to Prepare a Receipt in Google Sheets

Use a separate copy for each customer's payment. The illustration shows the main receipt fields; your Google Sheets layout may arrange them differently.

Payment already recorded on a Docelf invoice? Create the receipt from that invoice to keep them connected. For the Google Sheets option, fill in your copy using the steps below.

Your Business: Add your business name and contact details.
Your Logo: Use your logo without covering the header details.
The Customer: Confirm the customer's name and contact details.
Number and Date: Use a unique number and the date you received payment.
Items and Prices: List each item, quantity, and price.
Totals and Payment: Check tax and totals. Enter this payment and any balance.
Notes and Review: Include the payment method in Notes and review the finished receipt.

Show the Rental Cost and the Payment Received

For a rental paid in advance, the item rows show the booking's cost. The total paid confirms the payment for that booking.

In this fictional equipment rental, the customer paid $111.24 in full on September 20, 2026, for a September 26–27 rental. The receipt date is September 20, not the pickup date. This US-dollar example applies an illustrative 8% tax to all rental charges.

QTY	Description	Unit Price	Amount
2	Folding tables — weekend rental	$14.00	$28.00
12	Folding chairs — weekend rental	$2.50	$30.00
1	Pop-up canopy — weekend rental	$45.00	$45.00

	Subtotal	$103.00
	Sales Tax (8% illustrative)	$8.24
	Total Paid	$111.24

Each price covers the stated weekend, not one day. The $111.24 bank transfer pays for the booking in full. Use your actual rental prices and tax treatment for the customer's booking.

Put Payment Details in Notes, Not a Comment

A teammate may leave a comment while checking the sheet, but the customer needs the payment details on the receipt itself. Use Notes for the booking reference, payment method, and rental period. Include the amount received there when the layout has no separate payment line.

These Notes confirm the rental payment above. Use them as a starting point, replacing the booking details and amounts with your own.

Example: Notes

Received $111.24 by bank transfer for booking RNT-226 on September 20, 2026.
Rental period: September 26–27, 2026.
Paid in full for the rental period shown.

Keep Receipt Details in One Place With Docelf

Use Docelf to record a payment without arranging spreadsheet cells. It calculates totals and lets you email the receipt from the same place.

Create Receipt Online

More Receipt Layouts for Google Sheets

Choose the arrangement that gives your items and Notes enough room. Each of these previews opens a separate Google Sheets copy link.

Give Your Team a Clear Working Copy

When two people help prepare a receipt, one may know the item counts while the other has the payment record. Agree who checks the final figures so the same payment doesn't get entered twice.

Keep Entries and Formulas Distinct

Show teammates which cells hold quantities, prices, and payment entries. Protecting formula cells can help prevent accidental edits. Before sending, check that the formulas still include every item row.

Add Rows Without Losing the Calculation

Insert new rows in the item area and copy the existing formatting and formulas where needed. Check that each copied formula points to the correct row. A readable font, wrapped descriptions, and a modest color accent help the finished sheet look tidy.

Give the customer a PDF of this receipt or a separate file containing only their information. Hidden tabs and protected cells do not keep other customers' details private, so keep the team workbook internal.

Preview Only the Receipt You Plan to Send

On a computer, select the receipt sheet or highlight the cells you want to send. Choose File, then Print, and select Current sheet or Selected cells.

For a PDF, choose File, then Download, and select PDF. Review the export settings before saving.

Include all receipt details in the selected area.
Keep descriptions and amounts readable without squeezing the text.
Check the finished PDF for extra pages or missing rows.

Save the exact copy you send. A short receipt email can identify the payment and booking without repeating the whole sheet.

Create a New Receipt When the Next Payment Arrives

If a customer pays for a rental in installments, give each new payment its own receipt number and payment date. Record only the amount received now and show earlier payments separately, along with any remaining balance.

Keep the first receipt unchanged. When reusing a blank sheet, enter a fixed payment date rather than a formula that changes to today's date. The rental period stays labeled as the period the customer booked.

For future payments on a Docelf invoice, record each payment there and create its receipt from the invoice. The online receipt guide explains how to keep those records together.

Compare Spreadsheet and Document Options

Google Sheets gives you a browser-based working file. Excel provides an XLSX download; Word and Google Docs offer document layouts when you prefer to edit the wording directly.

The receipt format guide compares the file formats and online option.

Choose a Guide for the Payment You Received

Use the rent receipt guide when the payment covers a property. For a purchase or equipment rental, the itemized guide helps explain the charges.

Google Sheets Receipt Template FAQs

How do I copy one of these Google Sheets receipt templates?

Select Copy Google Sheets Template on a preview and follow the copy prompt. Give the spreadsheet a name that includes the receipt number. Keep a blank version for later payments and fill in a separate working copy.
Can a teammate help fill in the receipt?

Yes. Share the working copy with the people who need to contribute. Agree who checks the actual payment before sending. Give the customer a finished PDF or a separate file containing only their receipt.
Does a calculated total mean the customer has paid?

No. The total is the charge for the listed items. Check your payment record and enter the amount actually received. In the rental example, the customer’s $111.24 payment covers the full booking.
Is the receipt date the rental or service date?

The receipt date is the date you received payment, even if you prepare or send it later. Label the rental period or service date separately in the item description or Notes. This keeps an advance payment clear when the rental or service takes place later.
How do I print the receipt without the other sheets?

On a computer, select the receipt sheet or highlight the receipt cells first. Choose File, then Print, and select Current sheet or Selected cells. Check that the preview includes every item, the payment amount, and Notes.
What should the receipt for the remaining payment show?

Record only the new payment on a new receipt, using the date you received it. Show earlier payments separately so nothing is counted twice. Mark the booking paid in full once those payments settle the rental total.
Does copying the template also create a receipt in Docelf?

No. The copy link creates a Google Sheets file. Create Receipt Online opens Docelf separately, where you can create and email a receipt or download a PDF. The two copies do not update one another.

Send the Next Receipt From Docelf

Record a payment and send its receipt in Docelf

Confirm the payment in Docelf and keep a receipt you can find when the customer has a question.

Reuse saved customer and item details
Record the payment and show any balance
Email the receipt and see when it is opened

Create Receipt Online

Free Google Sheets Receipt Template

Copy a Free Google Sheets Receipt Template