Petty Cash Excel Template

Petty cash Excel template

The free petty cash Excel template is available to download below.

If you have not already done so, it is worth spending some time reading our section on Petty Cash. The section also includes a free voucher template, which can be used to authorise payments and record transactions.

It is important to ensure that the correct procedures are put in place to issue and authorise the spending. These procedures may include authorisation, keeping cash secure, and when to top up the cash amount.

Petty Cash Guide

Petty Cash Log

Most businesses use petty cash, but do not account for it, this means that you are not recording all the business transactions. Our petty cash template will make it easier to log your transactions, which you can then record in your accounts software or spreadsheet.

The software has been tested and works with Microsoft Excel 2003, 2007 and Microsoft Excel 2010.

Instructions for Petty Cash Template

When you have downloaded the spreadsheet, save it either to your hard disk or to the cloud. Open up the template and save it again using a new name. It will mean that you always have a blank template available.

If you complete your accounts monthly or have lots of cash transactions, it is useful to have a new sheet for each month. Some smaller businesses could record several months together.

To start, enter the opening balance of cash (balance b/f), ensuring it is the amount of cash in the petty cash float.

The categories of travel, stationery, postage etc. can be changed if you require different categories.

Each transaction can then be entered line by line. Include as much detail as possible. The voucher number can be left blank. If your business is VAT registered enter, the net, VAT and the gross will calculate automatically. For non-VAT registered businesses, enter the total amount in the net figure.

Use the categories to enter the Net amount, a total for each category is at the bottom of the sheet.

After posting all the transactions 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 balance, you will need to check your figures and confirm all the transactions are included and correct. It is called a petty cash reconciliation.

Petty Cash Log Example

Petty Cash – Licence Agreement

By downloading this template, you agree to the terms of our licence agreement:

Petty Cash Excel Template

Copyright © 2008-2019 Angela Boxwell t/a Business Accounting Basics. All rights reserved.

If you are looking for other accounting spreadsheets to help with you booking tasks, check out our other free Excel Bookkeeping templates.

Return from petty cash Excel template to Petty Cash page.