Google Sheets Receipt Template

There are two layouts on this page, and they do different jobs.

Itemized sales receipt — the receipt you give the customer. You enter an item, quantity and unit price on each line; the sheet multiplies quantity by price, adds the lines into a subtotal, applies the rate you enter in the tax-rate cell, and shows the total. For cash sales, enter the amount tendered and the sheet shows the change due back.

Receipt register — your own log of the receipts you have already issued. It is a record for your books, not a receipt to give a customer. Each row holds the receipt number, date, customer, description, payment method and amount. A running-total column adds each amount to the ones above it, and a "Total received this period" line at the bottom adds up the whole table.

You can use both together: issue the itemized receipt, then add one row for it to the register.

• Replace the sample details. The seller details, receipt details, line items and amount tendered are filled in with example values. Overwrite them with your own.
• Receipt number and date. Give every receipt its own number and never reuse one. A simple sequence with a prefix, like the sample numbers, is easiest to check against the register.
• Line items. Type only in the item, quantity and unit price cells. The amount column is a formula; typing a number over it breaks the link between the line and the total. The table has ten item lines, and the subtotal adds only those lines. If you need more, insert rows between existing item lines (not below the last one), copy the amount formula into them, and check that the subtotal formula's range now includes them.
• Tax rate. The tax-rate cell is set to 0%, so the file adds no tax until you change it. Type the rate that applies to your sale followed by a % sign, or leave it at 0% if you don't charge sales tax. The tax line's label has a "[Tax rate %]" placeholder; replace it with the same rate so the customer can see it. The template does not know your local rate.
• Rounding. The file already rounds for you: each line amount and the tax are worked out with ROUND(…, 2), so they come out to whole cents, and the total is the subtotal plus the rounded tax (ROUND function).
• Amount tendered and change. The change is the amount tendered minus the total, so fill in the amount tendered for every receipt; if you leave it blank, the change shows a negative number. For a card or bank payment, enter the total as the amount tendered so the change shows zero, and set the payment method.

Once a receipt is final, save a copy (or a PDF) under its receipt number and start the next one from a fresh copy of the template, so issued receipts are never edited later.

To stop the amount, subtotal, tax, total and change 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, which lets edits through after a confirmation prompt. Google notes that protection "shouldn't be used as a security measure" (Protect, hide & edit sheets).

If you protect cells in Excel before uploading, re-check them in Sheets: Google says locked and hidden cells from a protected Excel workbook become viewable and editable in Google Sheets (Edit Office files).

If a spreadsheet isn't the right fit, the same kind of receipt is available as an Excel receipt template, a Google Docs receipt template, a Word receipt template and a PDF receipt template. For other layouts, see the itemized receipt, sale receipt and cash receipt templates, or browse all receipt templates.