Petty Cash Management
Excel and Google Sheets Template
What's Inside the Petty Cash Management Template?
Details | 2 Sheets
Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac), Google Sheets
Category | Finance, Small Business
Tags | Expenses, Accounting, Ledger
Why Professionals Choose Simple Sheets
It's simple. Access to the largest library of premium Excel Templates, plus world-class training.
100+ Professional Excel Templates
Optimized for use with Excel. Solve Excel problems in minutes, not hours.
World-Class Excel University
With our university, you'll learn how we make templates & how to make your own.
How-To Videos
Each template comes with a guide to use it along with how-to videos that show how it works.
Inside Our Petty Cash Management
Excel and Google Sheets Template
It's not advisable to keep thousands of dollars tucked away in your office desk or a folder, even if it's securely locked away. Thus, the popularity of 'petty cash' - a small amount of money kept on hand for irregular or unplanned expenditures like buying stamps, office supplies etc., While it may not be a whole lot of money, you still want to record and account for it. Introducing our Petty Cash Management template for Microsoft Excel and Google Sheets.
This is a powerful yet intuitive spreadsheet template that makes it easy to record, track, and review petty cash expenditures. If you're interested in this template, you may also want to check out our Accounts Payable, Loan Amortization, or Invoice templates as part of our Accounting and Finance Template Collection.
Let's dive in to how this template works.
As with all of our templates, reference the Introduction sheet for any questions related to customization and unique features.
The second sheet is fittingly named Petty Cash Management. You can customize details about your Company Info and even insert an image of your logo.
Start on the right hand-side where there are four fields you want to fill out; Beginning Balance, From Date and To Date.
Before we dive into this template, you may also find our Accounts Receivable, Accounts Payable and Invoice templates useful in their own right. The End Balance calculates automatically based on your recorded transactions in the formatted table.
Once your spreadsheet is setup, you can simply begin to log transactions. Available fields include Date, Receipt Number, Description, Type, Charged To, Received By, Cash Out, Cash In, and Approved By.
Lists can be easily edited and added to your dropdown to streamline your data entry.
Above your table is a Dashboard for analyzing your petty cash. A slicer makes it easy to filter by data, as well as Type, Charged To, Received By, and Approved By so all your data points can be summarized without any additional formulas or visualizations.
This makes it easy to generate reports and insights into how your petty cash is being managed and accounted for.
More Finance Templates For You
