Store Credit Ledger Excel
A digital ledger that automatically calculates, per customer, the credit extended, the amount paid, the remaining balance and the number of days overdue.
Payment Receipt Example (Excel Template)
A payment receipt is a signed document that a business draws up and hands to the payer when it receives money from a customer or debtor, showing who paid how much, on what date, by what method and for what. It documents a single payment: the daily cash book runs every amount going into and out of the till during the day, while the debt itself is held by the credit ledger or the customer account tracking template. The first tab of this file is the printable receipt itself; the same page has two copies, one for the customer and one for you. When you enter the amount, the previous balance and the payment method, the remaining balance is calculated by formula and the second copy fills in on its own. On the second tab you keep the receipts you have issued in a single list by serial number.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 21 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Series / Serial No | The receipt's number (e.g. A-0142). Numbers are issued in order without gaps; a cancelled receipt is not deleted but stays in the list marked "Cancelled". This is the first piece of information to look up when a payment is questioned. |
| Date | The day the money was actually received. If a check or promissory note was accepted, the due date is also written in the description. |
| Payer (Person / Company) | The full name of the person paying or the company's legal name; plus their phone number or account code if you have one. If the payment is made on someone else's behalf, both names are written. |
| Amount (in Figures) | The amount received. If there are cents (kuruş), they are written out. |
| Amount (in Words) | The amount in words, written by hand in the form "Only … Turkish Lira … Kuruş". It is the oldest and most effective protection against the figure being altered afterward. |
| Payment Method | Drop-down list: cash, bank transfer / EFT, credit card, check, promissory note. For a check or note, the bank, serial no. and due date are written in the description. |
| Description | What the money was received for: such as "against the August credit balance", "invoice no. 1180" or "deposit". This is where it becomes clear which debt was settled. For auto service and repair jobs, write which job the payment belongs to using the work order number; when the vehicle comes back, the receipt and the work order will find each other. |
| Previous Balance / Remaining Balance | Optional: if you enter the debt before the payment, the remaining balance is calculated by formula and shown on the receipt. The customer reads from the receipt how much they still owe. |
| Received By and Signature | The name and signature of the person who received the money; a space for the business's stamp. There is also room for the payer's signature if you wish. |
| Receipt List (Data tab) | A one-line record of each receipt with its serial no., date, payer, amount, payment method and status. The Summary tab breaks total collections down by payment method and counts the cancelled ones. |
How to use it
- Download the file and enter your business name, address and phone number at the top of the "Payment Receipt" tab.
- When you receive the money, give the serial number as the continuation of the previous receipt, and enter the date and the payer's name.
- Enter the amount in figures, fill in the "In Words" line by hand and choose the payment method from the list; write what the money was received for in the description.
- If you know the customer's previous debt, enter it in the "Previous balance" cell; the remaining balance is calculated automatically and the second copy below fills in with the same details.
- Print the page, sign both copies and cut them apart: give the top one to the customer and keep the bottom one. Add the receipt to the "Data" tab as a single row, and also post the same payment to your cash book and your credit/customer account record.
Who is it for?
- Grocers, supermarkets and tradespeople who sell on credit or in installments and want to give the customer a written document when they take payment
- Property managers and small businesses documenting payments such as dues, rent, deposits, down payments and tuition, for which an invoice is issued separately or not at all
- Field sales reps who collect payments in the field and account for the money they hand in to head office with a receipt book
- Those who want a numbered, reproducible, computer-searchable system instead of a ready-made receipt book
Frequently asked questions
What is a payment receipt?
A payment receipt is a signed document that the party receiving the money gives to the payer, showing that a certain amount was received from a certain person on a certain date for a certain purpose. For the payer it is proof of "I paid", and for the business it is the record of which debt was settled.
How do you fill out a payment received receipt?
In order: the receipt serial number, the date, the payer's name or company name, the amount in figures, the amount in words ("Only two thousand five hundred Turkish Lira"), the payment method (cash, bank transfer, card, check, promissory note), what the payment was for, and the name and signature of the person who received the money. For payments by check or promissory note, also write the bank, serial number and due date. If the remaining debt is known, write it on the receipt too; it answers the "how much do I still owe?" question before anyone asks it.
Does a payment received receipt replace an invoice?
No. A payment received receipt shows that a payment was collected; it does not replace the invoice or sales slip that documents the sale itself. Whether you need to issue an invoice, a sales slip or a freelancer's receipt depends on tax regulations and your business's situation, so ask your accountant. This template is not an official form; it is an example to help you document payments in an orderly way.
What is the difference between a payment received receipt and a payment made receipt (tediye makbuzu)?
It is a difference of direction. A payment received receipt (tahsilat makbuzu) is issued by the business that takes the money and handed to the payer when money comes INTO the business. A payment made receipt (tediye makbuzu) is issued when money goes OUT of the business, for example when cash is paid to someone, and it is signed by the person who receives the money. This file is for payments received, meaning money coming in; for the reverse document you will use when you make a payment, see the payment made receipt example Excel template.
Should I give a receipt when I collect a payment on a customer's tab?
Yes, it protects both sides: the customer can prove they paid, and you have a written record of which debt you were paid against. For partial payments, writing the remaining debt on the receipt settles any argument before it starts. After issuing the receipt, don't forget to close the same amount in your credit ledger; otherwise the customer keeps showing as owing even though they have paid.
Is there a payment received receipt example in Word or PDF?
The file is in Excel (.xlsx) format because the remaining balance and the second copy are filled in by formula. You can open it in Excel, Google Sheets or LibreOffice and print it directly, or use "Save as PDF" and send it to the customer by email or WhatsApp.
Is the template free, and is membership required?
Yes, it is free. The file doesn't ask for an email, a sign-up or a payment, and it has no watermark or cell protection. You can change the business details, payment methods and receipt wording to suit you.
Related templates
Daily Cash Book
Keeps a day-by-day record of cash going into and out of the cash box; automatically finds the difference between the end-of-day count and the book.
Payment Voucher
A printable two-copy voucher that has the person receiving a cash, bank-transfer, or check payment from the business sign for it; the list of issued vouchers and the total by expense type are on separate tabs.
Cash Count Report
Counts the money in the drawer by banknote and coin denomination, compares it with the recorded balance and works out the cash shortage or overage; a printable document for the person handing over and the person taking over to sign.
Last updated: October 5, 2026
Search terms: payment received receiptpayment received receipt example excelwhat is a payment received receipthow to fill out a payment received receiptpayment received receipt example wordreceipt example