Buzz
Creating a Receipt Template in Excel
The receipt template you will create in Excel will be as follows:
To create the receipt template in Excel according to Circular 133, follow these steps:
Step 1: Open Excel 2016 or whichever version of Excel you are using.
Step 2: Proceed with drafting, formatting in Excel based on the following information:
Company, address: You specify the name, address of the unit, department, or you can stamp the unit.
Document template: You can use normal text input or you can use a Textbox (go to Insert
Date ... month ... year ... : This is the date you create the receipt -> you enter normal text as with editing in Word.
Book number, Number: You enter and specify the number of the Book containing the receipt and the number of the receipt in that book in Excel. Usually, receipts must be bound into books and numbered and used in one year. In each receipt, you must specify the book number and the number of each receipt. Receipt numbers must be consecutively numbered in an accounting period. In each Receipt, you must specify the date, month, year of receipt and the date, month, year of payment.
Debit, Credit: You specify the Debit account, Credit account. You edit normally in this section.
Full name of the money contributor: Specify the full name of the money contributor.
Address: Address, department of the money contributor.
Reason for contribution: You clearly enter the reason for contributing money. Example: Receive money for selling products, receive advance payment ABC...
Amount: You write in numbers and in words the amount of money deposited into the fund, specify the unit as VND or USD or other units.
Attached with: You specify the number of original documents attached.
Full name, signature: In this section, you can edit normally or continue to use Textbox as above and then add text inside. You pay attention to edit, align carefully, because this is the part for the Director, Chief Accountant, Money contributor, Receipt maker, Treasurer.
Received full amount: Write in numbers and in words the amount received
Exchange rate, Converted amount: You specify information about the exchange rate and the converted amount of foreign currency.
Step 3: You review the information you just presented in step 2, then adjust any discrepancies. If you need to align in Excel then you need to standardize to have a beautiful, standard and correct receipt in Excel.
- Download the latest receipt template Excel here.
Some notes when creating receipts
Receipts are typically prepared by accountants in triplicate, with all information filled out and signed on the receipt. Then it will be sent to the Chief Accountant for review and approval, then forwarded to the Director for final approval, and then sent to the Treasurer to proceed with fund entry procedures. When the Treasurer receives the full amount, they will write the actual fund entry amount (in words) on the receipt, sign it, and clearly write their name.
- 1 copy will be retained by the Treasurer for recordkeeping.
- 1 copy will be given to the money contributor.
- 1 copy will be kept for record at the place of receipt issuance.
At the end of the day, all receipts along with the original documents will be returned to the accountant to record in the accounting ledger.
Above is the guide on how to create a receipt template in Excel by drafting, formatting, and presenting on the Excel spreadsheet application so that you can have a receipt that complies with regulations.
If you only need a regular receipt template, you can use the file that Mytour has shared for your convenience. Additionally, you may want to check out Mytour's sample expense form too!
