Spreadsheet help needed

[Kenzie]

A colleague at work needs help with automating a spread sheet for budgets. He has a balance at the top going into the month with outgoings listed below with a remaining balance at the bottom. He would like to automate this so the outgoings are deducted ad the date passes as well as being able to add unexpected outgoings. It would also need roll back to the start of the month. Any ideas?

Sent from my Xperia T

[Sir Trev]

So he has a list of standard outgoings on specific dates and he needs to know the balance today/on a specific day? Against the outgoing line add a cell that looks to the expected date and compares it to current date - if it is equal to or greater than then 1 else 0. Then do a sumif. You can do a similar thing with another column on the same range but this time comparing to a date you choose, giving you three outcomes: expected total at end of month, running total, total at specific date.


Add rows for the unexpected items and simply add the dates as well as a flag to identify them as different to expected. That way you can ignore them when you set up the following month.

[Kenzie]

I think so, its hard to describe what he wants. He also needs to be able to add money coming in from another job.

[DJ123]

Originally Posted by Kenzie

A colleague at work needs help with automating a spread sheet for budgets. He has a balance at the top going into the month with outgoings listed below with a remaining balance at the bottom. He would like to automate this so the outgoings are deducted ad the date passes as well as being able to add unexpected outgoings. It would also need roll back to the start of the month. Any ideas?

Sent from my Xperia T

It would be an easy formula to deduct the outgoings & show the remaining (and add extras in). But I am unsure if Excel has the capability to do it date by date. Only way I could see it happening is if he input the figures in on the day which would automatically update the balance.

[Kenzie]

Like you say, I think he needs more than the software can handle.

Sent from my KFTT

[Grant66]

I have a simple spreadsheets which gives a current balance based on date. Rolling year from start date.

Regular payments: enter your DDs & Standing orders in this sheet
Adhoc: enter stuff you buy, uses current month/year or figures in override box (i.e. if you want to enter a receipt from a different month). Updates the date when you enter a day in the row (on enter macro).
Income: enter your pay packet as you get it or other money coming in.

On the Totals tab you get current total & moth end.

Fairly simplistic but it usually tallies with my balance when i check with the bank.

source file can be found here if its any use:

https://drive.google.com/file/d/0B35uGsVrZUY8S2Zqb3hGQUw3Slk/view?usp=sharing

I took the lazy option and bought some software. Program is called acemoney and it helps me anyway keep an eye on things


http://personal-finance-software-rev...ey-review.html


Sent from my iPhone using Tapatalk