Petty Cash Log Template

Are you running a business or working in any organization? If yes then you might know the value of petty cash and its 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 a 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 are 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 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 logs. 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

Petty cash log template given here is a comprehensive solution to keep a record of petty cash amounts deposited and withdrawn at a place. This Excel template provides you with ease of updating the petty cash record easily. Let’s 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
  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 the “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.