Inserting rows in a Checkbook Register

[daleslad]

Hi All,
I've been looking for a free checkbook register template that will automatically calculate the balance as you add or subtract various amounts.

I found one which seemed to be just what I wanted but once I had reached the end of the rows for the worksheet and tried to add more rows the automatic feature quit working.

I found another Checkbook Register which seemed even better than the first one as it had a notation at the end of the rows.
It said to " Insert new rows above this point" and it had the last row greyed out.
I tried adding a new row and tested it out by adding some amount but it did not continue with the automatic calculation either.

I'm sure there must be a simple way around this but can't figure out just what it could be, so I'm hoping that someone can give me a few pointers.
I'm using MS Excel for Mac 2011
Thanks

 

[Michael M]

Hi and welcome to the forum
Try something like this

Excel 2007
	A	B	C	D	E
5	Date	Description	Deposits	Expenditure	Balance
6
7
8		Starting Balance			$ -
9	25/12/2002	Wages	$ 1,000.00		$ 1,000.00
10	26/12/2002	Rates		$ 300.25	$ 699.75
11	27/12/2002	food		$ 50.00	$ 649.75
12	28/12/2002	wages	$ 900.00		$ 1,549.75
13	29/12/2002	food		$ 75.00	$ 1,474.75
14	30/12/2002	petrol		$ 40.00	$ 1,434.75
15	31/12/2002	wages	$ 1,000.00		$ 2,434.75
16	1/01/2003	food		$ 120.00	$ 2,314.75
Sheet1

Cell Formulas
Range	Formula
E9	=IF(B9="","",IF(C9<>"",E8+C9,E8-D9))
E10	=IF(B10="","",IF(C10<>"",E9+C10,E9-D10))
E11	=IF(B11="","",IF(C11<>"",E10+C11,E10-D11))
E12	=IF(B12="","",IF(C12<>"",E11+C12,E11-D12))
E13	=IF(B13="","",IF(C13<>"",E12+C13,E12-D13))
E14	=IF(B14="","",IF(C14<>"",E13+C14,E13-D14))
E15	=IF(B15="","",IF(C15<>"",E14+C15,E14-D15))
E16	=IF(B16="","",IF(C16<>"",E15+C16,E15-D16))

 

[daleslad]

Hi Michael, thanks for the prompt response.
I'm afraid all of that is over my head, I'm looking for the register to be already formatted for the auto. calc so I don't have to do anything but enter data.
I really appreciate all of the work you have done to illustrate it for me.

 

[Michael M]

well, it's fairly simple....copy the block of data into your worksheet and then copy each formula into the respective cell reference.
Notwithstanding that, you'll just have to keep googleing to find what suits you.
Try googling "Bank balance" or "Home Budget"

 

[daleslad]

Thanks again Michael for the suggestions,