Cash Receipt Template (Excel)

What is in this template

This workbook has a Receipt sheet, a Log sheet and a How to use tab. The receipt prints on one page. The log keeps a running record of every receipt you issue.

Receipt

Enter the receipt number, date, who the payment is from, the payment method and who received it. List up to eight lines with a description, quantity and unit price. Amounts and the total are calculated. The page fits on one sheet of paper so you can print it or save it as a PDF.

Log

A table for the date, receipt number, payer, method (Cash, Check, Card, Bank transfer or Other) and amount of each receipt. The totals at the bottom add up each method and count the receipts, so you can match them to the cash in your drawer and your bank.

How to use

Steps with links to both sheets.

The sample data

The sample receipt, R-0001, is for $1,275 paid in cash: $1,200 of rent plus a $75 parking space. The log holds three made-up receipts. Cash is $1,275, check is $1,150 and bank transfer is $1,200, for $3,625 in total.

How to use it

1. Fill in the receipt header: number, date, payer, method and receiver.
2. List what the payment was for with the quantity and price.
3. Print the receipt or save it as a PDF and give it to the payer.
4. Add a line to the Log with the same receipt number.
5. At the end of the day match the Log totals to the cash and bank deposits.

Tips

• Number receipts in order and never reuse a number.
• Keep a copy of every receipt you give.
• Record the payment method, because cash and card are banked differently.
• For rent payments, see the rent receipt template.

Frequently asked questions

More free tools: All free calculators · Receipt template · Rent receipt template · How to write a cash receipt