Cash Receipt Template

If your company dealing with the receipt of money from different means during a day and you do need a proper procedure to track it, then it is time that you start using the Cash Receipt Template. Simple and easy to use template generates cash receipts to record all the financial transactions. You can create three receipts per page. The perfectly formatted cash receipts can be given to the customer or kept as a record for later use. Template conteins following two formats of cash receipts:

Advertisement

Money received from any mode could be easily tracked which includes: Cash, Cheque and Money Orders.

Each receipt should have two copies one for your record and one for the customer. The receipts can be verified later to match the net amount received. Typically, a cash receipt should provide information like:

Cash Receipt

for Excel® 2003+, OpenOffice & Google Docs

Cash Receipt Screenshot

Screenshots Like This Template? Excel 2003(XP)
File: XLS Excel 2007 +
File: XLSX OpenOffice
File: OTS Google Docs
File: SPREADSHEET Download via our Add-on! Template Specifications Version
1.0.1 Requirements
Microsoft Excel® 2003 or Higher (PC & Mac) Macros
Not Used Installation
Not Required Author
Alex Bejanishvili of Spreadsheet123.com Help & Questions?
Contact Us

Disclaimer - The cash receipt template and information on this page is intended for educational an illustrative purposes only. Use information at your own risk. It is strongly advised to consult legal representative about specific requirements and regulations exercised by the government of your country prior to applying this templates to you practise.

Using Cash Receipt Template

Cash Receipt template has a Settings worksheet that stores all the company details that would get automatically populated on to the receipt. This sheet records the name of the person or the company that is issuing the receipts. Company Address should also be recorded on this sheet to save you from re-typing the address on every copy of the receipt. There is an option to select a color scheme for the receipt, you can select the preferred color through the design picker. You can predefine country setting to specify the currency symbol that needs to be published on the receipts.

The next two worksheets of the spreadsheet are Cash Receipt and the Cash Receipt with Slip. Depending on your requirement you can publish any of the two receipts. Both the sheets records same information and the only difference is that second sheet publishes an extra slip along with the receipt. This extra slip can be given to the customer as a proof of transaction. Company address get populated , automatically and other fields recorded are as follows:

The cash receipts template helps you to maintain a record of all money transactions. The printed receipts can be given to the customers as a confirmation for having received the payment. You can stamp and sign them to further authenticate the receipts.

We recommend you not to change or delete the pre-defined formulas of the template. By doing so the entire template would get altered as the various fields have interconnected formulas and the results in such a scenario would be doubtful.

Function used in template

Other Cash Receipt Resourses