Running balance for cheque book record

[Charlie Donohue]

I would like to know how to have excel keep a running balance for my cheque
book record. I would have the usual col for date, cheque no etc and then
three for money date ie col C for Deposits, Col D deductions and Col E
Balance

Any help would be most welcome

Thanks Charlie
(e-mail address removed)

 

[Bernard S]

Here is something to try and it has worked for me. Do not use a column for
balance, not needed, but at top of worksheet, use a "dsum" function. If
there is more than one checking account then use a column to identify the
account and a criteria range to sum the amount by checking account. You can
also record credit card accounts and summarize them the same way.

 

[M. lane]

This is a formula I use in mine which has col E as checks and other debits,
col F as deposits and other credits, and the balance in col G which is where
this formula resides:

=IF(ISBLANK(E5),IF(ISBLANK(F5),"",G4+F5),G4-E5)
This formula was copied from cell G5

 

[M. lane]

Or to better work for you, the formula would look like this:

=IF(ISBLANK(C2),IF(ISBLANK(D2),"",E1+D2),E1-C2)

Paste it in cell E2, highlight cell E2 down to the last point of your
balance area, click edit, fill, down. The formula will be copied to all
highlighted cells in the E col.

 

[Don Guillett]

Here is a macro I use where debits and credits are in the same column. You
can modify to suit.

Sub balance()
[a7].Select
Sort
[h7] = [d7]
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
With frng
.Formula = "=h7+d8"
.Formula = .Value
End With
End Sub