If you have not already read our section on Petty Cash, we recommend you read this first before downloading your free Petty Cash Excel Template. Read our introduction to Petty Cash.
Our free template is designed to assist in the management of your businesses Petty Cash and save time in the reconciliation.
This software has been tested and works with Microsoft Excel 2003 and Microsoft Excel 2007.
By downloading this template, you are agreeing to the terms of our licence agreement:
BAB Petty Cash Template
Copyright © 2008-2011 Angela Boxwell t/a Business Accounting Basics. All rights reserved.
Permission is hereby granted, free of charge, to any person obtaining a copy of BAB Petty Cash template and associated documentation files (the "Software") to use, copy and modify the software for their own private or commercial use, subject to the following conditions:
Your rights under this licence will terminate automatically if you fail to comply with the terms and conditions set forth herein.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
When you have downloaded start by entering the opening balance of cash. The left hand colums are for any cash received including money withdrawn from the bank. The right hand colums allow you to enter payments made and allocate them to the correct category.
When all you transactions are posted in the petty cash excel template you will have a balance c/f at the bottom, this should equal the value of cash. If it does not then you will need to check your figures and see if any money was removed or added that has not been listed.
Return from Petty Cash Excel Template to Petty Cash page.