Petty Cash Balance Sheet in Excel – Download Free Template

This article illustrates how to make a Petty Cash Balance Sheet in Excel. A petty cash balance sheet usually contains minor small payments. It is very important, especially for big companies, to have petty cash balance sheets. Fortunately, you can easily create such balance sheets in Excel or use free templates as required.


Download Petty Cash Balance Sheet Free Template

You can download the petty cash balance sheet free template from the download button below.


What Is a Petty Cash Balance Sheet?

Petty means trivial or of less importance. An actual balance sheet contains all the important transactions that occur within a company. So petty or small amounts can easily go unnoticed. Moreover, it is an extra hassle for the chief cashier to keep track of these petty transactions while also managing the larger amounts which may even be in billions. Therefore, an assistant cashier keeps track of all minor transactions like stationary, beverages, cartage, etc in a separate balance sheet called the petty cash balance sheet or petty cash log.

Petty Cash Balance Sheets have a few types or categories as follows. These types are based on the amount of information recorded and the formatting of the balance sheet.

  • Simple
  • Analytical
  • Columnar
  • Imprest

It is very important for big companies to have a petty cash balance sheet. This makes the main balance sheet look more neat and informative as small payments become excluded. It is also helpful for managing petty transactions more efficiently.


Steps to Make a Petty Cash Balance Sheet in Excel

Step 1: Create a Header

  • First, create a header for the balance sheet along with the company logo as shown below.

header for petty cash balance sheet

Read More: Balance Sheet Format in Excel with Formulas (Create with Easy Steps)


Step 2: Add Summary Row

  • Then, add a summary row showing the cashier’s name, beginning, and current balances for a quick overview.

petty cash balance summary


Step 3: Create Labels

  • Next, create labels to record the petty cash balances (for example, dates, deposits, expenses, etc).

create labels for petty cash

Read More: How to Create Vertical Balance Sheet Format in Excel


Step 4: Enter Data

  • Now start entering data as shown in the picture below.

data entry

Read More: Balance Sheet Format of a Company in Excel (Download Free Template)


Similar Readings


Step 5: Apply Formulas

  • Then, enter the following formula in cell C38 and drag the fill handle icon to the right.
=SUM(C7:C37)

total of rows

  • Next, apply the following formula in cell K7 and drag the fill handle icon to the cells below.
=SUM(E7:J7)

total of petty expenses

  • After that, enter the following formula in cell K4 to get the current balance.
=SUM(H4,C38,-K38)

current petty cash balance

Read More: How to Create Common Size Balance Sheet in Excel


Step 6: Finalize Petty Cash Balance Sheet

  • Finally, select the ranges for data entry and apply the Accounting Number Format. After that, the petty cash balance sheet format will look as follows.

Petty Cash Balance Sheet

Read More: How to Create a Balance Sheet for Small Business in Excel


Things to Remember

  • You can insert rows between rows 7:37 and columns between columns E:J if needed.
  • You can search for online templates in Excel using the keyword “Petty Cash” before creating a new workbook. You will find some simple petty cash balance sheet templates to work with.

Conclusion

Now you know how to make a petty cash balance sheet in Excel. Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about Excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo