Cash Receipt Format Free Sample Excel Download
A cash receipt format is a simple document you issue when you receive money from a customer or any other party. It works as proof of payment and helps you record collections, avoid disputes, and match entries with your cash book. For most small businesses, a cash receipt template Excel file is the easiest way to make receipts quickly and keep records organised.
India’s No.1 GST Billing & Accounting Software
check_circleLightning-Fast Billing with Barcode scanning
check_circleAuto E-Way Bill & E-Invoicing
check_circleMobile App
check_circleComplete Accounting
check_circleAdvanced Inventory Management
check_circleAuto Payment Reminders
check_circle1-Click GST Filing & Reconciliation
check_circle24*7 support
Download Cash Receipt Format in Excel
Download the free cash receipt format in Excel. Customise it as per your requirements at no cost.
What is a cash receipt format and when should you use it?
A cash receipt is issued whenever you collect money through cash, UPI, or any instant payment mode and you need a written record of the payment. It is typically used for customer payments against an invoice, advance payments taken before delivery, part payments received for an order, and service payments collected at the counter. A cash receipt helps avoid confusion because it clearly mentions who paid, how much was received, and the exact purpose of the payment.
Cash receipt template: fields you should include
A clean cash receipt template should include these details:
- Receipt number
- Date
- Received from name
- Mobile number or reference (optional)
- Amount received in numbers
- Amount in words
- Payment mode (cash, UPI, bank transfer, cheque)
- Transaction reference (UTR or cheque number if applicable)
- Purpose (invoice number or order reference)
- Receiver signature or stamp
- Company name and address
Optional but useful:
- Balance due after payment
- Notes or remarks
Quick checklist before you issue a cash receipt
- Use a unique receipt number in a running series (CR 001, CR 002).
- Confirm date and payer name are correct (customer or party).
- Enter amount in numbers and words and ensure both match.
- Mention payment mode clearly (cash, UPI, transfer, cheque).
- Add reference details where applicable (UPI ID, UTR, cheque number).
- Write purpose clearly and link invoice or order number if applicable.
- If it is part payment, mention balance due after this receipt.
- Take signature or stamp and save the receipt copy month wise.
Explore Accounting & Billing Software for Small Businesses
Frequently Asked Questions
-
What is a cash receipt format used for
It is used as proof of money received. A cash receipt confirms who paid, how much was paid, the payment mode, and why the payment was made. It helps both the business and the customer.
-
Can I use a cash receipt template for UPI payments
Yes, you should use it for UPI payments too. UPI record shows transaction, but receipt adds purpose and invoice reference clearly. It helps in bookkeeping and payment tracking.
-
What should I include in a cash receipt template
Include receipt number, date, payer name, amount, and purpose. Also mention payment mode and reference number. If it is part payment, mention balance due.
-
Is a sample cash receipt template enough for small businesses
Yes, a simple template is enough for most small businesses. It should capture key details and have a proper series. You can add more fields only if your business needs them.
-
Why is cash receipt template Excel better than handwritten receipt
Excel reduces mistakes and keeps records organised. A cash receipt template excel is easy to store, search, and share. It also helps you maintain a proper receipt series.
-
Should I issue a receipt for advance payment
Yes, you should issue a receipt for advance payments. It avoids disputes and makes it clear that money was received before delivery or service completion.