Petty Cash Log Template – Everyone dealing with company’s finance is familiar with Petty Cash Log. It is a term for a table or list which contains the more-detailed description about the use of petty cash. Petty cash itself is a term which is used to call the amount of money (usually the small one –petty comes from a French word ‘petite’ which means small) put in one’s hand, in a company or business. Therefore, it is also often called cash ‘on hand’.

Petty Cash Template Excel

Purpose of Creating Petty Cash Log in Microsoft Excel

Petty Cash Log is important to be managed well; just like the cash which must be kept well in order that small purchases can be covered. The reason why –even- petty cash should be well-documented is just that it is related to finance. Good company or business should never ignore that good finance means that every income and expense, no matter how small, is recorded righteously.

To generate Petty Cash Log, especially for your company, you need to be familiar with Microsoft Excel, another program which enables you creating tables in easier way. Create the table with several columns on it; which number will depend on what petty cash information you want to put there. The rows for the table can be made as many as you wish; because petty cash expense is often unpredictable and different from day to day.

Some common details appeared in Petty Cash Log are, for example, date, receipt number, description on expense, the deposited amount, the withdrawn amount, the receiver, and the approver.

Check this template >  Stock Valuation Calculator

How to Use Petty Cash Log Excel Template

It is pretty easy to use Petty Cash Log in your daily work. Just open the file whenever transaction involving petty cash happens. Ask the receipt form from the cash receiver, and type the used amount in the table. Remember to always note down the amount of deposited and withdrawn cash before, as well as the name of the receiver.


You can also download other useful finance template, profit and loss template.


Using Microsoft Excel to simplify your spreadsheet tasks is not as difficult as you think. I learned how to use it in less than 24 hours and rely on internet to find the solution if I got stuck. I am not an Excel expert, but here are all useful spreadsheets I have collected and created.