How to Create A Petty Cash Sheet

The Bookkeeping Master believes it is time for another Excel tutorial, this time the tutorial being on How to Create a Petty Cash Account using Excel.

Petty cash refers to a small amount of physical/tangible cash that is kept by a business for small expenses. These expenses generally include purchases like refreshments, postage, subsistence and minor stationery expenses. The cash is generally kept on the business premises or in the owners pocket (if a tradesman).

To learn How to Create a Petty Cash Spreadsheet, please watch the video below. The tutorial covers all you need to know but if you have any questions, please make a donation and email me at

Petty cash is usually recorded with greater accuracy when receipts are kept for purchases and petty cash slips are used. Petty cash slips are a voucher containing information (usually hand written & signed) on who took the money, what they purchased, how much was spent and other notes. These vouchers can be used also when

money is paid into petty cash to increase the amount in petty cash.

From my experience Petty Cash is often not accounted for in small businesses, this adds to the workload of the year end accountant which normally increases fees and can provide inaccurate management records.

If you have any questions about petty cash, please make a donation and get in contact

  • Facebook Social Icon
  • Twitter Social Icon
  • YouTube Social  Icon
  • Instagram Social Icon



The information on this site cannot be relied on as accurate and up to date. We strongly advise you seek the advice of accounting and tax professionals before making any accounting related decisions.

Visit SM Accounting Ltd

This site contains free bookkeeping and accounting courses and is ideal for anyone looking to learn finance, bookkeeping or accounting. This site contains information on double-entry bookkeeping, basic accounting, credit control, business planning, etc. 

* We do not offer refunds on any digital products purchased on this site.