Skip to content
Cash Receipt cover: a sample sheet with receipts issued, cash taken and card taken and a bar chart, beside the Summary, Receipt and Sales tabs

Cash Receipt

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Cash Receipt workbook suits shops, market stalls and small service counters that take cash and card payments. The Receipt tab is a form you can print, with item lines, a discount, the total, the cash tendered and the change due. The Sales tab logs each receipt with its number, date, customer, category, total and payment method. The Summary tab counts receipts, shows cash and card takings, and breaks sales down by category with a chart.

The sample receipts run for ten days and include cash, card and gift card sales across four categories, so every figure on the Summary has data behind it. Spell category names the way the Summary lists them, or those sales will be missed in its totals. Start each day at the next receipt number, and copy each receipt into the Sales tab when the shop closes.

Useful for

  • Giving a customer a numbered receipt at the till
  • Working out change when a customer pays in cash
  • Totaling cash and card takings after closing

What's included

  • 4 tabs: Summary, Receipt, Sales, How to use
  • Summary: a dashboard with 4 summary figures
  • Receipt: a ready-to-fill form
  • Sales: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Receipt tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the change calculated?

Change due is the cash tendered minus the total. The MAX function keeps the figure at zero, so a short payment shows zero rather than a negative number. Enter the amount the customer hands over on the Cash tendered line.

Can I give a discount on a receipt?

Yes. Enter the discount in dollars on the Discount line of the Receipt tab. The total is the subtotal minus the discount, and the change is worked out from that total. For a percentage, multiply the subtotal by the rate and enter the result.

How do I keep receipt numbers in order?

Start at the number after the last one in the Sales tab and count up by one for each sale. Never repeat a number, voided receipts included. A voided receipt still goes on the Sales tab, with a zero total, so the sequence has no gaps.

  • #receipt
  • #cash-receipt
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More receipt templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…