A receipt template lets you give customers a clear, professional record of every sale or payment in seconds. Below you can download three free receipt templates in Excel and Word: an itemized sales receipt that calculates discounts, sales tax, and change automatically, a printable cash receipt with two copies per page, and a payment receipt that shows the amount received and the balance still due on an invoice.
The Excel receipts do the math for you with built-in formulas, while the Word cash receipt is designed to be printed and filled in by hand. All three include placeholders for your business name and contact details, so they are ready to use as soon as you add your own information.
What Is a Receipt?
A receipt is a written acknowledgment that a payment has been received. It is given by the seller or service provider to the buyer after the payment is made. A receipt typically shows who was paid, who paid, the date, what the payment was for, the amount, and the payment method.
Receipts protect both sides of a transaction. For the customer, a receipt is proof of purchase that may be needed for returns, warranty claims, expense reports, or tax deductions. For the business, receipts create a record of income that supports bookkeeping, sales tax reporting, and the reconciliation of cash and card payments.
A receipt is different from an invoice. An invoice is a request for payment sent before the customer pays. A receipt confirms that the payment has already been made, either in full or in part.
Why Use a Receipt Template?
- It looks professional. A branded, well-organized receipt builds trust with your customers.
- The calculations are automatic. The Excel receipts total items, apply discounts and tax, and work out change or remaining balance.
- It keeps records consistent. Every receipt includes the same key details, which makes bookkeeping easier.
- It works without a point-of-sale system. Ideal for market stalls, freelancers, landlords, tutors, and small service businesses.
- It supports partial payments. The payment receipt shows exactly how much has been paid to date and what is still owed.
- It is easy to share. Print the receipt, or save it as a PDF and email it to the customer.
What to Include on a Receipt
- Business name and contact details: name, address, phone number, and email.
- Receipt number: a unique, sequential number for every receipt you issue.
- Date of payment: the date the money was actually received.
- Customer name: the person or company who paid.
- Items or description: what was sold or what the payment covers, with quantities and unit prices for itemized sales.
- Subtotal, discounts, and tax: shown separately so the customer can see how the total was calculated.
- Total and amount paid: the total due and the amount the customer actually paid.
- Payment method: cash, card, check, bank transfer, or mobile wallet, with a reference number if available.
- Balance or change: change given for cash sales, or remaining balance for partial payments.
- Signature or name of the person receiving payment: especially important for cash receipts.
How to Fill Out a Receipt
- Enter your business details once. Replace the placeholder name, address, and contact details and save the file as your master copy.
- Assign a receipt number. Use the next number in your sequence, for example SR-20482 after SR-20481.
- Add the date and customer. Record the payment date and the customer’s name or company.
- List the items or describe the payment. For a sales receipt, enter each item with its quantity and unit price. For a payment receipt, enter the invoice number and what the payment covers.
- Check discounts and tax. Enter your discount percentage and sales tax rate in the yellow and shaded cells. The totals update automatically.
- Record the payment. Choose the payment method from the dropdown and enter the amount tendered or received.
- Give a copy to the customer and keep one. Print two copies or save a PDF for your records.
Download the Free Receipt Templates
All three receipt templates are hosted on this website and are free to download and edit. Each preview image matches the download button directly below it. The Excel files open in Microsoft Excel, Google Sheets, and LibreOffice Calc, and the Word file opens in Microsoft Word, Google Docs, and LibreOffice Writer.
1. Sales Receipt Template (Excel)
An itemized retail sales receipt with item codes, descriptions, quantities, and unit prices. It calculates the subtotal, a percentage discount, sales tax, the total, and the change due from the amount tendered. A payment method dropdown, return policy notes, and an items-sold count are included.
2. Cash Receipt Template (Word)
A printable cash receipt with two receipts per page, a customer copy and an office copy, separated by a cut line. Each receipt has fields for the receipt number, date, received from, the sum in words, the amount, what the payment is for, payment method checkboxes, account balance lines, and a signature.
3. Payment Receipt Template (Excel)
A payment receipt for money received against an invoice. Enter the invoice total, previous payments, and the amount received today, and the template calculates the remaining balance, shows the percentage paid to date, and automatically displays PAID IN FULL or PARTIALLY PAID.
Tips for Issuing and Keeping Receipts
- Never reuse receipt numbers. Sequential, unique numbers make it easy to spot missing receipts and to find a transaction later.
- Write the amount in words on cash receipts. It makes the receipt harder to alter.
- Show tax separately. Customers who claim business expenses often need to see the tax amount on its own line.
- Record partial payments clearly. Always show the remaining balance so there is no confusion about what is still owed.
- Keep copies for your records. Tax authorities in many countries expect businesses to keep sales records for several years. Check the rules where you operate.
- Back up digital receipts. Save PDFs in a dated folder structure, such as one folder per month, and back them up regularly.
- Match receipts to deposits. At the end of each day or week, check that cash and card receipts match what was deposited in the bank.
Types of Receipts and When to Use Them
Sales receipts are used for retail purchases where several items are sold at once. They show each item, the quantity, and the price, and are common in shops, market stalls, cafés, and online stores.
Cash receipts confirm that cash, a check, or a money order was received. They are often handwritten from a receipt book and are used by landlords, schools, clubs, churches, contractors, and small service providers.
Payment receipts acknowledge a payment against an existing invoice or account. They are widely used by B2B suppliers, agencies, consultants, and anyone who accepts deposits or installments.
Other specialized receipts include rent receipts, donation receipts for charities, and taxi or travel receipts. Each follows the same basic structure, with details added for the specific type of payment.
Receipt vs. Invoice: What Is the Difference?
An invoice is issued before payment and asks the customer to pay a certain amount by a due date. A receipt is issued after payment and confirms the money was received. In many small businesses, the same document is converted from one to the other: once the invoice is paid, you issue a receipt that references the invoice number. The payment receipt template on this page is built for exactly that situation.
How to Customize the Receipt Templates
In the Excel templates, change the color scheme by selecting the header cells and choosing a new fill color. Update the tax rate in the Sales Tax % cell, or set it to zero if you do not charge sales tax. To add more item rows to the sales receipt, insert rows inside the item table and copy the Amount formula down. Add your logo with Insert > Pictures and place it beside the business name.
In the Word cash receipt, replace “[Business Name]” and the phone number, and update the starting receipt number on both copies. If you prefer three receipts per page, copy one receipt block and paste it below the second, then reduce the spacing slightly so all three fit.
You can also check these important templates like the rent receipt template for landlords and tenants, the payment voucher template for recording payments made by your business, and the service invoice template for billing customers before they pay.
Frequently Asked Questions
How do I make a receipt in Excel?
Download the sales receipt or payment receipt template on this page and open it in Excel. Replace the business details, enter the items or payment information, and the formulas calculate the subtotal, tax, total, and change or balance due. Print it or save it as a PDF for the customer.
What information must be on a receipt?
A receipt should show the business name and contact details, a receipt number, the payment date, the customer name, what was purchased or paid for, the amount, any tax, the payment method, and the name or signature of the person who received the payment.
Is a receipt the same as an invoice?
No. An invoice asks for payment before the customer pays, while a receipt confirms that a payment has already been received. A receipt often refers to the invoice number it relates to.
Can I use a receipt template for partial payments?
Yes. The payment receipt template is designed for partial payments. Enter the invoice total, earlier payments, and today’s payment, and it calculates the remaining balance and shows whether the invoice is paid in full or partially paid.
How long should I keep copies of receipts?
It depends on your country and type of business, but many tax authorities expect sales records to be kept for several years, often between three and seven. Check the record-keeping rules that apply to you and store copies safely.
