Download the Petty Cash Book Template in Excel, OpenOffice Calc & Google Sheets to chronologically record routine sundry expenses.
It consists of an Ordinary Petty Cash Book Template and an Imprest Petty Cash Book Template. You can use whichever suits your needs.
Moreover, it consists of printable formats of the Petty Cash Book as well as the Imprest Petty Cash Book. The summary section helps you to easily reconcile and spot the difference in the Petty Cash Book in just minutes.
In addition to the above, this article consists of definitions, types, processes, printable formats, journal entries, advantages, disadvantages, and much more about the petty cash book. It can be helpful to students as well as individuals to easily learn Petty Cash Management.
This template can be useful to accountants, department heads, accounting officers, students, and individuals to manage their petty cash expenses.
Table of Contents
Key Takeaways
- Petty Cash Book Template helps record small, routine business expenses in a structured way.
- Helps with easy reconciliation by comparing the book balance with actual cash.
- Automatically tracks receipts, payments, and balances.
- The imprest system ensures better control and reduces misuse of funds.
- Includes printable formats, receipts, and vouchers for proper documentation.
- Useful for accountants, businesses, students, and department heads.
Download Petty Cash Book Template (Excel, OpenOffice Calc & Google Sheets)
Petty Cash Book and Imprest Petty Cash Book Template with predefined formulas to easily record and manage routine sundry expenses. Download by clicking below on the desired format:
Additionally, you can download other useful templates like Accounts Payable Template, Accounts Receivable Template, Payroll Template With Attendance, and Employee Salary Sheet.
Feel free to contact us for the customization of this template as per your requirement. We also design new templates based on your needs. You can hire us for our services on Fiverr or directly contact us at info@msofficegeek.com.
How To Use Petty Cash Book Template?
This template consists of 2 types of Petty Cash Books: Simple Petty Cash Book Template and Imprest Petty Cash Book Template.
Simple Petty Cash Book
The debit side consists of the following columns:
Date
Description
CBN
Amount
Insert the date on which you receive the lump sum petty cash funds. Add a description and insert a receipt number.
The credit side consists of the following columns:
Date
Description
VN
Amount
Insert the date of payment, add a description, and insert a voucher number. The template automatically totals the debit and credit sides.
Lastly, enter the petty cash amount. On the credit side, record date-wise petty cash expenses along with the voucher number.
In the end, the template consists of a summary section. This helps in the reconciliation process. It displays the total amount of receipts, payments, and the balance as per the book.
Count the cash in hand in the petty cash box and enter the amount in the Actual Cash column, and it will show the difference. It also shows the reconciliation status.
If the Actual amount of Petty Cash is 0, it displays “Reconciled”. If the amount is less than the Petty Cash Book Balance, then it shows “Deficit,” and displays “Excess” if the amount is greater than the Petty Cash Book Balance.
Imprest Petty Cash Book
Insert the month and the fixed amount of the imprest petty cash fund. This amount automatically reflects on the debit side. If there are additional amounts received during a month, you only need to record them in this section.
The debit side consists of the following columns:
Date
CBN
Receipts
The credit side consists of the following columns:
Date
Description
VN
Payments
Courier
Pantry
Stationary
Traveling
Repair
Telephone
Fuel
Advertising
On the credit side, insert record the date, select the appropriate description of the payment, enter the voucher number and the amount of payment.
The template will automatically record the payment in the respective column based on your selection in the description column.
Similar to the Simple Petty Cash Book, the Imprest Cash Book also consists of a Petty Cash Summary. This helps in the reconciliation process. It displays the total amount of receipts, payments, and the balance as per the book.
Count the cash in hand in the petty cash box and enter the amount in the Actual Cash column, and it will show the difference. It also shows the reconciliation status.
If the Actual amount of Petty Cash is 0, it displays “Reconciled”. If the amount is less than the Petty Cash Book Balance, then it shows “Deficit” and displays “Excess” if the amount is greater than the Petty Cash Book Balance.
Furthermore, the analytical or the imprest petty cash book also consists of a graphical representation of the spending during the period.
Petty Cash Receipt Template
Use the following receipt and voucher template for petty cash purposes.
Select the Receipt from the drop-down list.
Fill in the date, description of the receipt, and the amount. Print the receipt.
Petty Cash Voucher Template
Fill in the date, description of the payment, and the amount. Print the voucher.
What Is a Petty Cash Book?
The petty cash book is a ledger book. The petty cash book records routine small expenses of the business that are recurring in nature in chronological order.
To avoid too many cash entries in the Cash Book, businesses allocate small funds to handle petty expenses. The petty cashier makes a payment and issues a voucher for the payment. At the end of the defined period, the cash book is reconciled, and petty cash is replenished.
A petty cash book is maintained in both small and large businesses. Small businesses have one petty cash fund, whereas big businesses have department-wise petty cash funds. It solely depends upon the volume of transactions.
Basically, it is a type of cash book that handles small, routine, and recurring expenses like courier, repairs, pantry, etc.
The word petty comes from the French word “petit,” which means small. Hence, as this book records small, routine cash payments, it is a petty cash book.
Purpose Of Petty Cash Book
The main purpose of the petty cash book is to decrease the workload of head cashiers or accountants by managing small routine transactions. A petty cashier is appointed to record, manage, and reconcile the petty cash funds.
Moreover, this book helps to reduce unnecessary cash entries in the cash book. Generally, cashiers of big companies have lots of cash entries that amount to thousands of dollars each day.
To simplify the work of the head cashier and reduce his unnecessary workload, businesses maintain petty cash. Thus, petty cash funds are given to other responsible staff of that particular department.
In simple terms, the main objective of a petty cash book is to cater to small day-to-day expenses where the use of alternative payments like cheques or credit cards is neither feasible nor cost-effective.
Types of Petty Cash Book
There are two types of Petty Cash Book in accounting: Ordinary Petty Cash Book and Imprest Petty Cash Book. These two types of Petty Cash books differ based on the petty cash management systems.
Let us understand each type in brief.
Ordinary Petty Cash Book
An ordinary petty cash book or Simple cash book consists of two sides: debit and credit. In the ordinary petty cash system, a petty cashier receives a lump sum amount. The cashier records date-wise receipts of cash from the head cashier.
The petty cashier makes payments for sundry expenses like pantry, couriers, promotions, stationery, telephone, etc against a voucher.
When the petty cash funds amount to zero, the petty cashier prepares an expense report and presents it to the head cashier. The head cashier reconciles the expenses and allocates other petty cash funds.
Ordinary Petty Cash Book Format
Given below is the Ordinary or Simple Petty Cash Book Format:
The debit side consists of cash receipts from the head cashier, whereas the credit side consists of the payments made against each petty expense. It is advisable to record inward cash entries against receipt numbers and outward payments against voucher numbers.
Imprest Petty Cash Book (Analytical Petty Cash Book)
In the Imprest Sytem of Petty Cash, the head cashier allocates a fixed amount of petty funds for a specific period. Another name for the Imprest Petty Cash Book is the Analytical Petty Cash Book.
The petty cashier records the petty transactions and presents an expense report for reconciliation to the head cashier at the end of the period. After reconciliation, the head cashier issues the same amount of cash previously fixed.
Imprest Petty Cash Book Format
Given below is the Imprest or Analytical Petty Cash Book Format:
This type of cash book also consists of two sides. But there is a different column for each type of expense. This book is perfect when the volume of transactions is higher.
Process To Manage Petty Cash Book
Simple 7-step process to manage your petty cash book:
- Receive Petty funds from the head cashier; issue a receipt for the amount received.
- Report the receipt on the debit side of the petty cash book with the date, receipt number, and amount.
- Make payments to authorized payees under petty cash.
- Issue a voucher for payments to keep a record.
- Report the voucher on the credit side of the petty cash book with the date, voucher number, details of payment, and amount.
- Balance the petty cash and review the actual petty cash in the Petty Cash box.
- Reconcile at the end of the period and replenish the petty cash funds.
Journal Entries For Petty Cash
There are two stages of petty cash reporting in the ledger.
Journal Entry for Petty Cash Funds Issued to Petty Cashier
Initially, the cash is issued from the head cashier to the petty cashier. Debit the Petty Cash Account and credit the Cash Account.
Petty Cash Account – Dr
To Cash Account – Cr
Journal Entry for Payments From Petty Cash
Whenever a petty cashier makes a payment, they issue a voucher and report the same in the petty cash book. The head cashier reports these to office expenses. Hence, the cashier debits the Sundry Expense account and credits the petty cash account.
Sundry Expenses Account – Dr
Petty Cash Account – Cr
Where the volume of expenses is higher in sundry expenses, you can directly debit each expense account.
Repair & maintenance Account – Dr
Stationery Account – Dr
Fuel Account – Dr
Petty Cash Account – Cr
Advantages and Disadvantages of Petty Cash
Petty Cash has both advantages and disadvantages.
Advantages
- Decreases the workload of the head cashier or accountant.
- Simple and easy to use.
- It provides convenience to handle small day-to-day expenses.
- The imprest system helps reduce misuse of cash, as the head cashier can reduce the float if it is more than the adequate requirement.
Disadvantages
- Security risk: Hard to track and subject to fraud, theft, and misuse
- Requires manual monitoring and record-keeping
Reconciliation of Petty Cash Book
The reconciliation of petty cash is very important to prevent any fraudulent use of petty cash. A periodic reconciliation is compulsory.
It is a simple 4-step process:
- At the end of the period, check the actual cash in hand balance.
- Match the actual cash balance with the Petty Cash Book balance.
- If there is an excess of funds, there are chances of double reporting, whereas if there is a deficit there are chances of missed entries.
- Furthermore, the head cashier checks the receipts and payment vouchers against the said payment along with the vendor invoices.
Frequently Asked Questions
Petty Cash Float is the amount of physical cash with the petty cashier. The float can be decreased or increased based on the expenses during the previous period. The petty cash float varies depending on the volume of transactions in the companies. Some companies have higher floats up to $2000 whereas some have as low as $200. What is a Petty Cash Float?
What is a suitable amount for a petty cash float?
If you like this article, kindly share it on different social media platforms so that your friends and colleagues can also benefit from it. Sharing is Caring.
Please send us your queries or suggestions in the comment section below. We will be more than happy to assist you.