Petty Cash with Running Balance
Does anyone have a spreadsheet (Excel) template for Petty Cash, with a running balance column ?
Tried several times to create my own, but main problem is the imprest (top up) from the bank.
Can maintain the running balance from the total of the expenditure columns, but have not managed to include a test that also works for the imprest column cells. ![]()
Hope you can understand this request. ![]()
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.
More posts from this group
-
Comments: 1
-
Comments: 3
-
Comments: 0
-
Comments: 4
-
Comments: 13
-
Comments: 4
-
Comments: 16
-
Comments: 7
-
Comments: 3
-
Comments: 3



Is This What You Want?
How I would do it is to have 3 columns, as well as a column for date and details.
Col C Col D Col E
Expenditure Cash top up Balance
Items in columns C and D are amounts. Column E has a formula copied into each row:
Balance previous row less expenditure plus top up
The Excel formula might be:
E9-C10+D10