Are you running a business or working in any organization? If yes then you might know the value of petty cash and it’s monitoring in a corporate. Petty cash is a small proportion of money kept at the office or reception for little or emergency expenses. The cash is kept secured and a log is maintained to monitor the flow of this cash.

Uses of petty cash

• Purchase of daily minor items like stationery, snacks or beverages, etc.
• To give as change
• Holding some amount of money that is not sent to the bank account

A typical petty cash holder is a box in which separate sections remade to keep notes, coins, and vouchers. A lock system is installed for safety. You have to decide the floating amount initially that you withdraw from your bank account to keep as petty cash. Do not forget to take some coins of the cash and write a voucher about this petty cash which has to be stored with the petty cash.

Another crucial thing in holding and maintaining petty cash is the use of a petty cash log book. This petty cash register should include the initial and daily petty cash in and outflow. You can buy an ordinary notebook and record your daily log into it or you can easily download free templates for petty cash log. The user-friendly customizable option drafts a precise log where you can add your petty cash entry with no hassle.

File: Excel (.xls) 2007/10
Size 15 Kb | Download

Petty cash log template given here is a comprehensive solution to keep a record of petty cash amount deposited and withdrawn at a place. This Excel template provides you with ease to update the petty cash record in an easy way. Let see how it works!

1. Download and save the template to your computer.
2. Open the template file using MS Excel of any version.
3. Once you open the file you will see the template interface as shown in the preview
4. If you are using it for a company write the company name at the top
5. Below you will see a table with multiple columns having different headings
6. Start writing from the 1st column by putting the ‘Date’ of deposit or withdraw the petty cash money
7. Write the ‘receipt no.’ of the payment receipt
8. Give ‘description’ to this record for later understanding
9. Next, you can either insert ‘Amount Deposited’ or the ‘Amount Withdrawn’. Choose and enter the amount
10. In the next column write to whom this amount has been charged
11. In the last column mention who approved this transaction
12. The sum of “Amount Deposited” and the “Amount Withdrawn” will be calculated automatically.

Note: Do not alter the columns that carry formulas. Altering these cells may stop the worksheet from working properly.