Open editor

Receipt Template for Google Sheets

Download a ready-to-use receipt template and import it into Google Sheets. Edit your details, check the totals, and print or download a PDF.

Download for Sheets import

XLSX import workflow

4 simple steps to use in Google Sheets

Get from file to finished receipt in minutes.

  1. Download XLSX

    Save receipt-template.xlsx on your computer.

  2. Open Google Sheets

    Go to sheets.google.com and create a blank spreadsheet.

  3. File → Import → Upload

    Choose File → Import, open the Upload tab and select the downloaded XLSX file. Choose Replace spreadsheet to keep all three sheets.

  4. Review inputs and totals

    Fill in the yellow input cells, then check the formulas and the totals.

Edit and recalculate

The Example sheet after import. Change quantities and prices in the yellow cells; the line amounts and totals recalculate.

=D31-N(D32)+D33+N(D35) Input cells Calculated cells
ABCD
14 Description Qty Unit price Amount
15 Notebook 1 4.99 4.99
16 Pen 2 3.49 6.98
17 Sticker 3 2.50 7.50
…
31 Subtotal 19.47
32 Discount (amount) 5.00
33 Tax rate (%) 8.25 1.61
34 Tax applies to Before discount
35 Tip (amount) 3.00
36 Total 19.08

Compatibility notes

This is an Excel workbook (.xlsx). Google Sheets converts it when you import it, so check these after each import:

  • The formulas in the Amount, Subtotal, Tax and Total cells
  • The "Tax applies to" drop-down (before or after discount)
  • Number formats, column widths and fonts
  • The print settings and paper size

Currency and date formatting

Adjust the currency symbol, decimal places and date to match your receipts.

  1. Currency: select the amount cells, then choose Format → Number → Currency, or Custom currency for another symbol. The symbol changes how amounts look; it does not convert them.
  2. Decimal places: use the Decrease and Increase decimal places buttons in the toolbar.
  3. Date: the Date cell is text, so it shows exactly what you type, for example Oct 25, 2026 or 25/10/2026.
  4. Locale: File → Settings → Locale sets the default number and date style of the spreadsheet.
Date
Oct 25, 2026
Subtotal
19.47
Discount
−5.00
Tax (8.25%)
1.61
Tip
3.00
Total
19.08

When the details are right, print the receipt or save it as a PDF from Google Sheets.

  1. Select the receipt cells on the Receipt or Example sheet.
  2. Choose File → Print and pick Selected cells, then check the preview.
  3. Print, or choose File → Download → PDF for a PDF file.

Review formulas and formatting after import. The print area set in the file is for Excel; Google Sheets may not keep it, so choose Selected cells when you print.

File information

One file for Excel and Google Sheets.

File receipt-template.xlsx (12 KB)
Format XLSX (Excel Workbook), imported into Google Sheets
Sheets How to use, Receipt (blank), Example (fictional data)
Needs A Google account for Google Sheets

Frequently asked questions

Quick answers about using the Google Sheets template.

Do I need a Google account?

Yes. Google Sheets needs a Google account. You import the XLSX file into your own Google Drive; nothing is sent to this site.

Is this a native Google Sheets copy link?

No. The template is an Excel (.xlsx) file that you import into Google Sheets. There is no "Make a copy" link to a Sheets file.

Do the formulas work after import?

The file uses ordinary spreadsheet formulas for line amounts, subtotal, discount, tax, tip, total and change or balance due, and Google Sheets recalculates them when you change an input. Check the formulas and totals after every import.

Explore more templates

Need a different format? Check out our other templates and tools.