Hello Pradneshwaje,
You can prepare a petty cash report directly from the attached bank statement by summarizing only the small, frequent expenses and matching them with the funding entries.
Identify petty cash funding
Look for credits like “petty ca”, “M S NEW T / ICIC / petty ca”, etc.
These are the amounts issued to petty cash.
Example entries appear multiple times between 25-12-2025 and 07-01-2026
List petty cash expenses
Include small day-to-day payments such as:
Tea/snacks (Chai Paani, sweets)
Local shops (kirana, medical)
Transport, lunch, minor supplies
These are mostly UPI P2M debits of small values (₹5–₹300)
Create the report table
Use this format:
Date
Description
Voucher/UPI Ref
Amount (₹)
02-01-2026
Tea & snacks
UPI ref
15
04-01-2026
Lunch
UPI ref
1140
…
…
…
…
Reconciliation
Opening petty cash
+ Petty cash received
– Total expenses
= Closing petty cash balance
The closing balance should align with the statement balance if all entries are captured.
Attach proof
Attach this bank statement as supporting evidence for the petty cash report.