Download Petty Cash Log Template In Excel

A business uses a petty cash account for tracking physical cash used to make small payments. The cash we keep in a small safe or locked file cabinet, perhaps in an manila envelope. Petty cash for meeting refreshments, reimbursing an employee for office supplies she, or other miscellaneous expenses. A petty cash log can be taped to the envelope or stored with the cash so that whenever you remove or add cash you can use the form to record the date, payee, purpose, and amount.

At the end of the reporting period or when the petty cash log is filled up, the custodian in charge of the cash will count the money and compare to the ending balance on the form. Differences are resolved and a new cash log is created with a new balance for the new reporting period. The custodian will likely be entering transactions into whatever accounting software he/she is using, and may require an employee to complete a voucher and submit receipts. The petty cash log provides a physical paper-based record of the cash-in and cash-out. To customize a petty cash form for your business, download the free template below.

Petty Cash Excel Template

This petty cash log template allows you to easily modify the heading labels as needed and contains working formulas in the Balance column in case you want to track the petty cash log using the spreadsheets itself, rather than printing a blank form.

What is petty cash?

Petty cash is the money a business keeps on hand to pay for miscellaneous purchases. Most purchases made with petty cash are unexpecting expenses that can pop up.

One of the main reasons to have petty cash on hand is to quickly reimburse employees who have spent their own money on items for the business or to tip the delivery service driver who brought the office lunch.

Petty cash, like any other expenditure, needs accounting into your accounting software or manual accounting system since the expenses are business related and need to be properly recorded to ensure financial statement accuracy.

How to set up and use petty cash in your business

If you’re ready to set up a petty cash fund for your office have a secure place to store your petty cash funds, such as a lockbox or locked drawer.

1. Set account limits

Before you start a petty cash fund, you’ll need to decide how much you want the fund to be. Between $100 and $200 is fairly common, though you can go lower or higher, depending on your business.

You’ll also want to decide the replenishment point, so that your expenses can record, and a new check will write in the petty cash total back to its original amount. For example, if your petty cash fund is $100, you may want to reimburse the fund when it drops below $15.

2. Determine who will manage petty cash

If you have an office manager, they’re the most likely choice to manage the petty cash fund. If you only have a few employees, fund management may fall to you.

Whatever you decide, it’s important that only one person have access to the fund at any time. Thus to avoid unaccounted for withdrawals and/or theft. Once you determine who will handle petty cash, you’re ready to cash a check and deposit the funds into the petty cash lockbox.

3. Create a Petty Cash Register

The petty cash log is one of the most important components of managing petty cash. Any transactions from petty cash or out of petty cash need to be recorded on the petty cash log. It’s also important that any money disbursed out of the petty cash fund have a receipt.

Download this Petty Cash Log template in Excel Format

Our easy to use editable Excel templates and save your significant amount of time and effort. Here’s how to download and use one of our templates:

  1. Download this free Excel Template: Once you’ve browsed through our collection of templates and find the one that best fits your needs. Once you’ve found the template you want, click on the download button.

  2. Replace sample data with your actual data: Once the template is downloaded, open it in Excel. You’ll see that it is already set up with sample data. To start analyzing your own data, simply replace the sample data with your actual data.

  3. Customize the template: Our templates are completely editable, which means you can customize them to fit your specific needs. For example, you can change the formatting, add or remove columns, or create new charts and graphs.

  4. Use the Excel template: Once you’ve fed in your data and customized the template, you’re ready to start using it for data analysis. Use the various tools and features of Excel to analyze and visualize your data, and make informed business decisions.

  5. Save and share: Once you’ve finished working on the template, save it to your computer and share it with other members of your team or stakeholders as needed.

Click Download Button To Get Petty Cash Log Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Download Free Editable Excel Templates | Popular Templates

Task Order Billing Format

Task Order Billing Format

Task Order Billing Format Template: Your Key to Efficient Milestone-Based Invoicing In a landscape where project dynamics shift and evolve, billing clients based on project

Read More »
Simple Tax Invoice

Simple Tax Invoice

In the realm of business, clarity, precision, and simplicity can be the key to smooth transactions. A Simple Tax Invoice Template is designed to cater

Read More »

Free editable professional Excel templates can be a useful tool for businesses, organizations, and individuals looking to streamline their data management and reporting processes. These templates can provide a pre-designed and pre-formatted framework for storing and organizing data, as well as for creating charts, graphs, and other visualizations to help communicate that data more effectively.

One advantage of using professional Excel templates is that they are often designed by experienced professionals who understand best practices for data management and visualization. This means that the templates are likely to be well-organized, easy to understand, and aesthetically pleasing, which can make working with them more efficient and enjoyable.

Another advantage is that these templates are often fully editable, allowing users to customize them to meet the specific needs of their organization or project. This can include adding or deleting rows and columns, changing the formatting and layout, and adding custom formulas and functions.

Some examples of professional Excel templates that may be available for free include budgeting templates for personal or business use, project management templates for tracking tasks and deadlines, and sales tracking templates for analyzing and forecasting sales data. There are also a wide variety of templates available for specific industries, such as real estate, marketing, human resource, Payroll management and among others.

Overall, free editable professional Excel templates can be a valuable resource for anyone looking to improve their data management and analysis skills. By providing a pre-designed and customizable framework for storing, organizing, and visualizing data, these templates can help users save time and make more informed decisions.