Petty Cash Balance Sheet in Excel Download Free Template

Thus, the difference is only reconciled when the petty cash box must be replenished. By maintaining a petty cash fund, businesses can efficiently handle low-value transactions, avoid the hassle of processing paperwork for minor expenses, and maintain a proper audit trail of expenditures. The petty cash amount may appear as the first https://accounting-services.net/ or second item listed in the current asset section of the balance sheet. However, the petty cash amount might be combined with the balances in the other cash accounts and their total reported as Cash or as Cash and cash equivalents as the first current asset. Cash on hand is any accessible cash the business or liquid funds have.

This acts as a receipt, logging the amount of the withdrawal, the date, the purpose, and other details. Increasingly, these slips are electronic ones, entered in a digital spreadsheet or ledger. But it can be helpful to keep paper slips too, along with receipts from the purchases or payments (if possible). A petty cash fund is a small amount of company cash, often kept on hand (e.g., in a locked drawer or box), to pay for minor or incidental expenses, such as office supplies or employee reimbursements. These receipts can be exchanged for a new cheque made to cash for the total amount equal to the receipt.

Petty cash is stored in a petty cash drawer or box near where it is most needed. There may be several petty cash locations in a larger business, probably one per building or even one per department. A separate accounting system is used to track petty cash transactions.

The amount listed in the petty cash account is almost always overstated, since the various petty cash custodians are always disbursing petty cash in exchange for receipts for expenses incurred. Consequently, petty cash balances are rarely updated just to improve the accuracy of the financial statements. When a petty cash fund is in use, petty cash transactions are still recorded on financial statements.

  1. The specific format and labeling may vary depending on the company’s policies and reporting preferences.
  2. If you need to replenish the funds every few days, it probably means your fund is too small.
  3. No matter what, ensure anyone with that title and responsibility is trustworthy and loyal to the company.
  4. Instead, designate one employee to be responsible for the petty cash fund.
  5. These costs can be urgent, and you may have to handle them immediately.

If every employee has access to petty cash, bad or nonexistent record keeping usually results. Instead, designate one employee to be responsible for the petty cash fund. Current assets are assets that provide economic benefit within one year. Since petty cash funds can resolve scenarios with readily available cash, this can be considered as providing economic benefits. Sometimes, the balance in your petty cash fund becomes too low to purchase small expenses. In these cases, the custodian should tally and summarise the receipts.

Step 5: Apply Formulas

This article illustrates how to make a Petty Cash Balance Sheet in Excel. 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. Each time you tap into a petty cash fund—that is, take money out—a slip or voucher should be filled out.

Steps to Make a Petty Cash Balance Sheet in Excel

Because petty cash is capable of providing an economic benefit as is, it is always considered a current asset. Petty cash refers to spending cash that a company has readily available. Because it is capable of providing an economic benefit as is, it is considered a current asset. Petty cash is used to cover minor expenditures, which can aid employers in reimbursing employees and clients for small expenses. Some examples may include snacks, transport fares, office supplies, etc.

Grow and improve your business with QuickBooks software!

Those with prior financial accounting experience are especially great with this, but anyone that’s handled expense accounts should be fine. Furthermore, keep a Microsoft Excel doc or other spreadsheets that tracks who spent what, when it was spent, and the total amount of spending for both the month and year to date. Not only will this help you hold employees accountable, it will also ensure you’re more prepared at tax time. Add up the total expenditure listed on each petty cash voucher in the petty cash fund (the information can also come from the petty cash book). If there is a residual balance, then there is a cash overage in the fund.

When the petty fund is replenished, usually by drawing on a company-issued check, it’s recorded as a debit to the petty cash account and a credit to the cash account. The petty cash fund is reconciled periodically to verify that the balance of the fund is correct. Typically, as the petty cash balance falls to a preset level, the custodian applies petty cash balance sheet for additional cash from the cashier. At this time, the total of all of the receipts is calculated to ensure that it matches the disbursed funds from the petty cash drawer. If new funds are needed, the cashier writes a new check to fund the petty cash drawer and takes, in exchange, the receipts from the purchases that depleted the cash.

As the petty cash total declines, the receipts should increase and add up to the total amount withdrawn. Require that employees maintain a running petty cash log for every transaction, including receipts. Each entry in the petty cash book should include the date, the amount, and what was purchased with the petty cash. Review your petty cash register before you replenish the petty cash fund.

What is petty cash?

Many small businesses will do this monthly, which ensures that the expenses are recognized within the proper accounting period. In the event that all of the cash in the account is used before the end of the established time period, it can be replenished in the same way at any time more cash is needed. If the petty cash account often needs to be replenished before the end of the accounting period, management may decide to increase the cash balance in the account. If, for example, management of the Galaxy’s Best Yogurt decides to increase the petty cash balance to $100 from the current balance of $75, the journal entry to do this on August 1 would be as follows.

The only problem is she has no cash and her credit card is maxed out. The remaining $185 on hand is what’s left of the $500 petty cash fund after reimbursements. These types are based on the amount of information recorded and the formatting of the balance sheet. On the downside, the convenience of petty cash can also make it a problem, and a risk. Cash is hard to secure and impossible to track; it’s very easy for bills to disappear without a trace—even if you’ve established a careful system of receipts or vouchers.

Give the receipt to your finance department or the person who handles your small business books. For example, you might send an employee to pick up office supplies, like staples or printer paper. You would use your petty cash fund to reimburse your employee for the purchase of the supplies. Read on to learn about establishing a petty cash fund, handling petty cash accounting, reconciling your petty cash account, and claiming a tax deduction. No matter how large the balance is, it is important for companies to set up a good internal control system that keeps track of all cash inflows and outflows from the petty cash account. For example, anyone who requires such cash should be required to write their name, the date, time, and the specific amount and description of the transaction.

However, the balance in the petty cash account is so small that it is rarely listed on the balance sheet as a separate line item. Instead, it is aggregated with the other cash accounts of a business into a single cash line item; this form of presentation is known as a classified balance sheet. As part of a company’s cash, a petty cash fund is drawn on its checking account, cashing that check and giving the currency and coins to the custodian.

Related Post