Also make note of cash withdrawn for petty cash expenses at the start of the month.
Note down Money remaining at the end of month after the months expenditure,and put it as Cash balance.
If you need a more methodical accounts entry go for TALLY Accounting package.
11th June 2012 From India, Hyderabad
as mentioned above put Description, amount spent along with the allotted petty cash to u for that particular month and put an excel formula and subtract the daily spending's with allotted petty cash hence u'll going to the get pending amount on regular basis.
I hope above mentioned details will gonna suffice your query
12th June 2012 From India, Mumbai