Dear All, Please let me know Petty cash format, i Have started handling petty cash of our company. with Regards Kavitha
From India, Bangalore
Acknowledge(0)
Amend(0)
1From India, Bangalore
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
I hope the details mentioned above will suffice for your query.
Best regards,
Mannmad
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Petty cash statement.xls
Management Accounting.doc