Using Excel 2000 the same way you would use Quicken or MS Money

I would like to know if I could set up my Excel program to be used the same way that Quicken or MS money is used to keep track of my checking account. If so could I get step by step details on how to do this?

Originally Posted by pauliez

I would like to know if I could set up my Excel program to be used the same way that Quicken or MS money is used to keep track of my checking account. If so could I get step by step details on how to do this?

Hi pauliez,

The best thing to do is to buy one of the programs, but if you only want to keep a record of money going in or out with a running balance then try this
A3 = Cheque number
B3 = Description
C3 = Withdrawals
D3 = Deposits
E3 = Balance
E4 = IF(C4=0,SUM(C4:D4),IF(D4=0,D4-C4,D4-C4))
E5 = IF(AND(C5="",D5=""),"",SUM($D$4:D5)-SUM($C$4:C5)), then drag this one down as far as you like

Hope this helps

oldchippy

I don’t understand your reply. What do you mean by A3, B3? Column A, row 3? Also what do E4 and E5 mean? Can you simplify you info?

Thanks oldchippy for your reply. Sorry I haven't gotten back sooner. I set up an Excel spreadsheet according to your instructions and it works fine. This Excel is great. I would like to add columns to the check register. If I do, do I need to change the letters in the formulas to compensate for the extra column? Such as “D” to “E” and so on.

Originally Posted by pauliez

Thanks oldchippy for your reply. Sorry I haven't gotten back sooner. I set up an Excel spreadsheet according to your instructions and it works fine. This Excel is great. I would like to add columns to the check register. If I do, do I need to change the letters in the formulas to compensate for the extra column? Such as “D” to “E” and so on.

Hi pauliez,

Glad you got it working and yes Excel is a great tool.

If you put more columns in, the formulas will adjust to take account of this, for example if you click on column D (at the top) to highlight the whole column, then right click and select Insert, this will insert a new blank column called D. You will see that the formulas now in column F have changed to take account of this.

If you insert extra rows, just will have to drag the formulas down from the cell above by the small black cross hair again.

oldchippy