# How do I create a rolling bank account balance?

1. ## How do I create a rolling bank account balance?

Hi Everyone,

I want to create a spreadsheet which shows my current bank account balance. In the spreadsheet I want to have fields which show monthly outgoings. Under each month I will enter how much I have spent during a day on a specific thing, i.e. petrol. So once I have entered that amount I want my balance cell to minus that amount, however, I also want the balance cell to recognise when I get paid. So for example, if I get paid on the 28th of every month, I want the balance cell to plus the amount I get paid, (this amount will be the same every month) once the current date exceeds the 28th.

I have attached a spreadsheet which contains formulas which hopefully you can see and workout what I am trying to do. Please let me know if you need anymore information.

Balance.xls

2. ## Re: How do I create a rolling bank account balance?

Hi Dubby20

May be in B1: =SUM(176.21-SUM(B22:M22)+B25)

3. ## Re: How do I create a rolling bank account balance?

try the macro, I recommend you input the expenses on the Ledger tab and the orignal tab summarizes them automatically

4. ## Re: How do I create a rolling bank account balance?

Kevin UK - Thanks for your reply, this sum is useful however, I need it to plus the salary every month rather than just the once, is that possible? Thanks.

RCM - Thanks for your reply, I am working in Office 2003 so the spreadsheet you have sent me won't open the formulas properly. Is it possible to produce some formulas that work in 2003? Thanks.

5. ## Re: How do I create a rolling bank account balance?

Deleted post.

6. ## Re: How do I create a rolling bank account balance?

Hi Kevin, looks good to me, can you just explain to em exactly what it is doing? Looks to me that the balance will be shown at the bottom of each 'Month' column? Thanks, Archie.

7. ## Re: How do I create a rolling bank account balance?

Hi Dubby20

Have a look at the attached.

8. ## Re: How do I create a rolling bank account balance?

Hi Kevin, sorry there is no attachment?

9. ## Re: How do I create a rolling bank account balance?

Hi Dubby20

See the attached, Last attempt!
The income row should update month to month. See how you get on with that. it was that 176.21 in B2, I have moved it!
Change the date in C1 and see if your happy with that!

10. ## Re: How do I create a rolling bank account balance?

Kevin that works perfectly, thank you so much for your help! Really appreciate it.

Regards

Archie (Dubby20)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1