# Thread: Excel Formula for Cashbook entries

1. ## Excel Formula for Cashbook entries

Can someone please help me with setting up an excel formula that will allow me to keep a running record in a cashbook type excel worksheet? I want three columns operating eg Deposit, Withdraw and Balance, set up so that excel automatically calculates the running balance as I enter either a deposit or make a withdraw on the row below.

Thanks in anticipation.

2. ## Re: Excel Formula for Cashbook entries

Assuming the following:

Column A is Deposit
Column B is Withdrawals
Column C is the running balance

In cell C2, type =SUM(\$A\$1:A1)-SUM(\$B\$1:B1)

Copy down as need be.

3. ## Re: Excel Formula for Cashbook entries

Thanks Bogan. Have tried this formula but it doesn't seem to work I am using Excel 2007 not sure if that creates a problem?

4. ## Re: Excel Formula for Cashbook entries

Shouldn't do.

How are you copying it? Are you selecting the bottom right corner of the cell and dragging?

Actually, I realised one big fault with that formula I gave. Sorry about that.

In cell C2, type =SUM(\$A\$2:A2)-SUM(\$B\$2:B2)

This assumes row 1 has a description of the columns.

Oh and both deposits and withdrawals are positive. If withdrawals are negative, use =SUM(\$A\$2:A2)+SUM(\$B\$2:B2)

5. ## Re: Excel Formula for Cashbook entries

Ok will try this soon...thank's for your help which is much appreciated

6. ## Re: Excel Formula for Cashbook entries

Thank me when you have it sorted. Good luck.

7. ## Re: Excel Formula for Cashbook entries

I use =C4+A5-B5 in column C.
This assumes an actual amount in C4 as there has to be a starting balance somewhere.
Use fill down to populate column C as far as you need to.
Formula is saying the current balance is the previous balance plus any deposit minus any withdrawal.
You can format the cells as currency
As usual there are many different ways of doing the same thing ..

8. ## Re: Excel Formula for Cashbook entries

Thanks Othesea......that looks good too. Much appreciated

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•