Payment Receipt Excel Template
- 5'734 Downloads
- 41 KB File Size
- June 1, 2017 Updated
- 0 Number of comments
Payment receipt is a form with your signature that inform buyer that you already received the goods and paid the agreed amount. Basically, you can purchase general receipt forms for this purpose. But, small business owners or freelancers might need it in a digital format. Also, they might print it with their own logo printed in the receipt and keep the record of their customers.
These payment receipt templates are simple excel spreadsheets that you can use for your purposes. There are three models of them. They are differentiated by your company information/logo position. You can choose among top, side or bottom company information position. Also, they all have different format and paper size. You can manually alter them by typing your own information. These models should give you options on selecting the most suitable one for your businesses.
Payment Receipt Template Model 1
As informed, this is a general form where you must type your customer/client information manually in respective boxes. There is an amount box with green color that will convert the amount value that you type at the bottom of receipt into words automatically. You can change company information on top of this receipt with your own.
Payment Receipt Template Model 2
If you want to place your company information at the left side of the receipt, you can choose this one. There are four white boxes in payment area that you can fill particular information. The amount box, box with blue background, will show you the amount in words automatically based on the amount value that you put at white box at the bottom.
Payment Receipt Template Model 3
This model has logo position at the bottom. Number and Date information are placed at top right side. You can type any information at all available lines and boxes except the "Amount" in words area. The excel formula will generate the amount in word automatically based on the amount value that you put in blue box as you see in its dummy sample.
All of them don't have database capability. You need to create it by yourself if you want to track people who you paid. You can start by creating a database in separate worksheet and put payment and client information there. Set either employee or receipt ID as lookup reference. Then you can use Excel Data Validation feature to select that reference. Use VLOOKUP or Index/Match function to map it into payment receipt.
We are sorry 🙁
Help us improve!
How we can improve this template?