To download Business Accounting Basics' free petty cash Excel template, follow the instructions below. If you have not already read our section on Petty Cash, we recommend you read this first. The section includes a free voucher template, which can be used to authorise payments and record transactions. Click on this link to read our introduction to Petty Cash.
Most businesses run a cash book, but do not account for it, our petty cash template will make it easier to record transactions, which can then be added to your accounts software or spreadsheet.
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-2014 Angela Boxwell t/a Business Accounting Basics. All rights reserved.
To download your free template you must agree to our licence agreement
By clicking on the link you agree to the licence agreement download free petty cash template.
When you have downloaded start by entering the opening balance of cash. The left-hand columns are for any cash received including money withdrawn from the bank. The right-hand columns 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.