What is on the payment receipt template
- Invoice or account number
- The link between the payment and what it pays for. Without it, a bookkeeper has to guess which open invoice to clear.
- Total invoiced, previously paid, paid today, remaining balance
- The four numbers that describe where the account stands. If the customer pays in parts, each receipt shows the running position.
- Payment method and reference
- Check number, ACH or wire reference, card last four digits, or the app and transaction ID. This is what the bank statement will show, so it is how the payment gets matched.
- Installment schedule
- On the plan design: each installment with its due date, paid date, amount and the balance after it. The customer sees the whole plan on every receipt.
- Received by and signature
- Who at the business accepted the payment. For card and bank payments the signature is a formality; for cash it is the evidence.
Payment receipt vs ordinary receipt
A general receipt says "you paid this much for these items". A payment receipt says "you paid this much against this invoice, and this is what is left". The second is what businesses need once they bill first and collect later, because a single invoice can be paid in several pieces and a customer can have several invoices open at once.
Accounting software issues these automatically. The printable version is for businesses that still invoice from Word or Excel, for clubs, schools and clinics that take payments at a desk, and for anyone collecting on a payment plan who wants to hand over something on paper.
Which design to use
- Payment against an invoice: trades, freelancers, suppliers. One receipt per payment, tied to one or more invoices.
- Installment plan: dental and medical balances, tuition, layaway, equipment sold on terms, repayment of a private loan. The schedule is filled in as payments arrive, and each receipt shows the whole history.
- 2 per page: a receipt book for membership fees, class fees, dues, registration payments.
How to fill it in
- Number the receipt in its own series (PR-) seperate from invoices (INV-) and estimates.
- Enter the invoice or account number and, on the standard design, each invoice this payment touches with the amount applied to it.
- Fill Previously paid from your records so Remaining balance is right. On the Excel version it calculates.
- Record the method and the reference exactly as the bank will show it.
- Sign and date. Email a scan or hand over the paper copy; keep yours with the invoice.
Mistakes that break the audit trail
- Applying one payment to several invoices without listing which ones. The standard design has a line per invoice for this reason.
- Forgetting previous payments, so the balance line is wrong and the customer is chased for money they paid.
- No reference number on bank and card payments, making reconciliation a search instead of a match.
- Marking an installment "paid" on the plan before the check clears.
The sequence is estimate, invoice, payment receipt, and if the invoice goes unpaid, payment reminder. The client billing tracker keeps the running list of open invoices and payments received so that Previously paid on this receipt is always a lookup, not a memory test.
Editing the Word and Excel versions
In Excel, the standard design sums the invoice totals and the amounts applied, then subtracts previously paid; the installment design sums payments to date and subtracts them from the plan total. Add your business block once, save as a master, and duplicate the sheet per customer on a plan so the schedule accumulates. In Word, everything is a table cell; click and type.
Questions
What is the difference between a payment receipt and an invoice marked paid?
An invoice marked "paid" does not say when, how, or how much was paid, and it cannot handle partial payments. A payment receipt records the payment itself. Keep both.
Can one receipt cover several invoices?
Yes. The standard design has a line per invoice with the amount applied to each, and the totals show the combined position.
How do I handle a payment plan?
Use the installment design. Fill the schedule rows as each payment comes in and issue a copy each time; every receipt then shows the full plan and the remaining balance.
Does the PDF calculate the balance?
No. The fillable PDF is for typing and printing. The Excel version calculates paid today, remaining balance and, on the plan design, paid to date and remaining.
Do I need a tax ID on the receipt?
Only if the customer needs it for their records, which is common in B2B. There is an optional box on the standard design.
Comments and questions
Have a question about this template, or an idea to make it better? Leave a comment.
Leave a comment