Download free excel template for managing your cash in and cash out (cash management) for petty accounting. This template is useful for small to medium sized businesses.
Checkout: Simple petty cash book format in excel.
Understanding use of petty cash book
A petty cash logbook is important because it helps to track and record the amounts of cash received and spent from a petty cash fund. This can help to ensure that the fund is being used appropriately, and that there is a clear record of all transactions for accounting and auditing purposes.
Additionally, a petty cash logbook can be used to monitor cash levels and replenish the fund as needed. Overall, it is an important tool for managing and maintaining the integrity of a petty cash fund.
Types of Petty Cash book
There are 2 types of Petty Cash Systems that is normally followed –
- Ordinary System and
- Imprest System
Ordinary System
In Ordinary System, a sum of cash is given to the petty cashier. The petty cashier is responsible to record the sundry expenses. Once the amount is spent, the record is presented to the head cashier for the review. The head cashier reviews the expenses and provides new funds to run the day to day expenditure again
Imprest Petty Cash
Under the Petty Cash Imprest System, the head cashier provides a fixed feasible amount depending on previous spend history to the petty cashier for a given period. It can be either a week or a month depending on the volume of transactions. After expenditure is done and period is complete, the head cashier reviews and replenishes the balance.
Download and Use Petty Cash book Excel Template
To use this free petty cash book excel template, you should have Microsoft Office/ Microsoft Excel installed in your system.
After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
Once extracted, you can open the file using Excel and start entering data or customizing the template. You can customize the currency, color scheme, fields in this template as per your requirement.
