Handling Petty Cash for the First Time: What Format Should I Use?

Petty Cash Format Request

Please let me know the petty cash format, as I have started handling the petty cash for our company.

Regards,
Kavitha

Daily Cash Transactions in Excel

Enter the daily cash transactions in an Excel spreadsheet. You can use the following columns: Date, Item Name, Amount Spent, Description of the Item/Expense. At the end of the month, total up all the expenses.

Also, keep a record of any cash withdrawn for petty cash expenses at the beginning of the month. Note down the money remaining at the end of the month after all expenditures and label it as Cash Balance.

If you prefer a more structured accounting approach, consider using the TALLY Accounting package.

Hi there! As mentioned above, input the description and amount spent, along with the allotted petty cash for that particular month. Insert an Excel formula to subtract the daily spendings from the allotted petty cash. This way, you will determine the pending amount on a regular basis.

I hope the details mentioned above will suffice for your query.

Best regards,
Mannmad