Anyone in business knows that giving out receipts for payments received, and keeping records of those receipts, is important for balancing your books and preparing your year end taxes forms. Here is a receipt book format that can be used in Microsoft Excel® 2007 and higher which will dramatically keep the process of issuing and recording receipts much easier.
The template has eleven sheets, the first of which is the settings page where you record the basic information about your business. You’ll input:
- your company name
- the sales person’s or account receivable person’s name
- the company address
- the symbol for the currency your company accepts.
Once you save these settings, each receipt issued will contain all of the mentioned data, along with a unique and sequential receipt number.
Sheets 2 through 11 are labeled Pages 1 through 10, and contain multiple receipts per sheet. There are fields for entering the following specifics per transaction:
- name of the person receiving the receipt
- the purpose of the transaction for which the receipt was issued
- the amount of the payment
- whether it was paid in cash, by money order, or check
- the current accounting balance, minus the payment received and whether there is any balance due
Save the data, print it out, or convert the spreadsheet to a PDF format for emailing, and you’re done.
The beauty of this template is that you can have as many versions of it as you have sales people, or accounts receivable staff, or company locations, or divisions within a company, etc. All of these variables can be accommodated without any additional cost to you. If you move or change company names, just update the settings information on the first sheet.
Receipt Book Format (Setting Sheet),
Receipt Book Format (Receipt Sheet),