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.  crash.gif

Hope you can understand this request.   confuse

 

Comments
scalloway's picture

Is This What You Want?

scalloway | | Permalink

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

 

 

 

Add comment
Log in or register to post comments
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.