Cash receipt template in Excel: free download

Cash receipt template in Excel: free download

A cash receipt is the document your business uses to record that a payment was received. When a customer hands you cash, when they make a partial payment against an invoice, or when they send an advance for an order, that money needs to be recorded with a date, an amount, a description and the signatures of both parties. Without that support document, any later difference turns into an argument with no proof: the customer says they paid and the cash drawer does not show it, or the drawer shows money that no one recognizes. So the cash receipt is not red tape: it is the reliable memory of every payment that comes into the business and the first thing requested in any review, audit or cash reconciliation.

This cash receipt template in Excel brings together everything a well-made receipt needs: a consecutive number, a date, a space for the name of the person paying, the amount in figures and in words, the payment method, the description and signature areas for the person who receives the money and the person who hands it over. Stores and shops use it to document cash sales, service companies use it to support the partial payments made by their clients, and any business that handles advances, installments or deposits will find it useful. Download the template for free, fill it out in under a minute and print as many copies as you need, always with the same clean layout.

What the cash receipt template includes

The template is an Excel file (.xlsx) organized in two sheets. The first one is the receipt form: a ready-to-use sheet with clearly marked cells for every piece of data and blocks sized just right for comfortable writing. The second one is the instructions sheet, which explains what goes into each field, how to keep the receipt sequence under control and how to leave the file ready to print. No complicated formulas and no macros: open the file, complete the data and the receipt is finished.

The layout follows the classic cash receipt format: the business name and details at the top, the receipt number and date on the right, and below them the blocks for who is paying, the amount, the description and the signatures. The print settings are already configured for portrait A4 paper, so the receipt comes out on a single sheet with reasonable margins, suitable both for handing to the customer and for filing the business copy.

When to use a cash receipt

A cash receipt is issued every time money comes into the business cash drawer and a written record of that payment is needed, signed by the person handing the money over and the person receiving it. The most common situations are these:

• Cash sale. The customer pays for the goods or the service at the moment they receive it, and the receipt supports that immediate payment.
• Partial payment on an invoice. The customer does not pay the whole amount at once but makes a partial payment; the receipt records how much they paid and leaves the invoice with a lower balance.
• Customer advance. The customer pays money in advance to reserve an order or secure a job; the receipt supports that advance until the product or service is delivered.
• Installment or deposit. Recurring payments such as plan installments, monthly charges or agreed deposits that are collected at the business cash drawer.
• Small payments. Low-value sales or services collected directly in cash that do not go through formal invoicing but still need to be supported.
• Other cash income. Refunds, security deposits, cash returned by a supplier or any other payment that needs to be identified with a date, an amount and a responsible person.

One important clarification: a cash receipt does not replace an invoice. The invoice is the proof of the sale and the receipt is the proof that the payment was received. In many transactions both documents are issued: the invoice for the operation and the receipt when the payment arrives in cash or through a method that is worth documenting.

How to fill out the template step by step

With the file open in Excel, this is the recommended order for filling out the receipt:

1. Check the sequence number. Every receipt has a unique number. Before writing, confirm which number was used last and assign the next one; never repeat a number and never leave gaps in the series.
2. Verify the date. The cell fills in by itself with the =TODAY() formula, which shows the current date. If the payment happened on another day, write the date on which the money actually came in, because that is the one that matters for control purposes.
3. Complete the Received from block. Write the full name of the person or company paying, with no nicknames or abbreviations, so there is no doubt about who made the payment.
4. Write the amount in figures. Enter the exact amount in the numeric cell and indicate the currency in its cell.
5. Write the amount in words. The written amount must match the figure in numbers. If the two do not agree, the receipt loses its validity because no one knows the true value; in that case, void the receipt and issue a new one.
6. Choose the payment method. Pick the right option from the dropdown list: cash, bank transfer, check, debit card, credit card or the other option when it applies.
7. Describe the concept. In the details block explain what is being paid: a cash sale, a partial payment on an invoice, an advance, a period or a reference. Write it as if another person were going to read it in the future, because someone probably will.
8. Write the reference document. If the payment applies to an invoice, an order or a contract, enter its number in the designated cell. That piece of data lets you link the receipt to the transaction that gave rise to it.
9. Both parties sign. In the Received by block, the person receiving the money writes their name, their ID number and their signature; in the Delivered by block, the person handing the money over does the same. Without the signatures, the receipt proves nothing.
10. Review and file. Before handing over the receipt, check that no field is left empty and no corrections remain. Hand a copy to the customer and file the signed receipt (the original) in order, by month, so you can reconcile the cash drawer and answer any question.

Common mistakes when filling out a cash receipt

Most receipt problems do not appear on the day the receipt is filled out, but weeks later, when someone tries to reconcile the cash drawer or settle a claim. These are the mistakes that happen most often and how to avoid them:

Example table: a properly filled-out receipt

This is what a complete cash receipt looks like when it is filled out carefully, ready to hand to the customer and to file:

In the amount-in-words cell of the receipt, two hundred fifty thousand was written out, which matches the figure $250,000.00 exactly. That match, together with the date, the concept and the signatures, is what turns a filled sheet into a valid proof of payment.

Receipt control: from paper to software

Printing and filing receipts solves the support document for each payment, but it does not solve control. With a drawer full of paper receipts, at the end of the month no one can tell you at a glance how much you have collected, which invoices still have an outstanding balance or whether a customer paid the same item twice. To know that, you have to move the data into a separate record, and that manual step is exactly where receipts get lost, payments get duplicated and cash differences appear.

That is why the next level is recording receipts in a system. With Kardex Tauro, for example, when you enter a cash receipt the payment is saved with its date, its payment method and its amount, and if the receipt is linked to an invoice, the system automatically deducts the amount paid from that invoice balance. The customer is up to date without anyone subtracting by hand, the receipt history stays organized and searchable by customer, date or value range, and reconciling the cash drawer no longer depends on the memory of whoever kept the paperwork.

The Excel template is the perfect starting point: it is free, it adapts to the size of the business and it can start being used today. When the number of receipts grows and the first difficult reconciliations appear, that is the natural moment to move to software that does the heavy lifting. In the meantime, a well-filled and well-filed receipt is already more than many businesses have.

Download the cash receipt template in Excel, try it with the next cash sale, the next partial payment or the next advance you receive, and see the difference it makes to have every payment supported by an orderly document. Filling it out takes less than a minute, but that minute saves you arguments, cash differences and headaches down the road.

Final note: the cash receipt supports the payment received, but it does not replace the tax documents required by the legislation of each country. Check the formal requirements that apply where you operate, such as the sequence number, the identification data and the mandatory documents for each type of transaction, and adapt the template to those requirements.