Back
to top
Help creating a running total of outgoings.
Watch
Announcements
Page 1 of 1
Go to first unread
Skip to page:
I currently have an excel sheet with my monthly budget in but I really want another spreadsheet which has a running total of my outgoings in so I can keep a closer eye on my spending- the big pile of receipts doesn't actually help me see how much I'm spending!
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use
)?
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use
)?
0
reply
Report
#2
(Original post by feathered-soul)
I currently have an excel sheet with my monthly budget in but I really want another spreadsheet which has a running total of my outgoings in so I can keep a closer eye on my spending- the big pile of receipts doesn't actually help me see how much I'm spending!
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use )?
I currently have an excel sheet with my monthly budget in but I really want another spreadsheet which has a running total of my outgoings in so I can keep a closer eye on my spending- the big pile of receipts doesn't actually help me see how much I'm spending!
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use
)?
0
reply
(Original post by Reue)
Do you have a smart phone? There are a number of free apps which let you track and categorise spending as you do it. Much easier to keep track of and calculate monthly costs etc.
Do you have a smart phone? There are a number of free apps which let you track and categorise spending as you do it. Much easier to keep track of and calculate monthly costs etc.
Yeah I do, I'll look into one. I'd rather have one on my laptop as well though
0
reply
Report
#4
All you'd really need for the functions is SUM. You then add up your weekly / monthly income and take away your expenditure.
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
If you want to add several values, you'd do =SUM(A1:A10) This adds all numbers in A1 to A10.
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
If you want to add several values, you'd do =SUM(A1:A10) This adds all numbers in A1 to A10.
0
reply
Report
#5
(Original post by OU Student)
All you'd really need for the functions is SUM. You then add up your weekly / monthly income and take away your expenditure.
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
If you want to add several values, you'd do =SUM(A1:A10) This adds all numbers in A1 to A10.
All you'd really need for the functions is SUM. You then add up your weekly / monthly income and take away your expenditure.
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
If you want to add several values, you'd do =SUM(A1:A10) This adds all numbers in A1 to A10.
1
reply
Report
#6
(Original post by Ben_K)
She might want to create graphs using Monte carlo simulation and What If statements...
She might want to create graphs using Monte carlo simulation and What If statements...
0
reply
Report
#7
(Original post by feathered-soul)
I currently have an excel sheet with my monthly budget in but I really want another spreadsheet which has a running total of my outgoings in so I can keep a closer eye on my spending- the big pile of receipts doesn't actually help me see how much I'm spending!
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use )?
I currently have an excel sheet with my monthly budget in but I really want another spreadsheet which has a running total of my outgoings in so I can keep a closer eye on my spending- the big pile of receipts doesn't actually help me see how much I'm spending!
The problem is that its been years since I've had to deal with excel and I can't remember any of the functions. Can anyone help me with setting up the spreadsheet (or has one i can use
)?
DATE | DESCRIPTION | AMOUNT | <---Analysis-->
Where it says <--Analysis--> you type type different expenses into each column, for example: Food | Clothes | Travel | Other etc...
Then you take your pile of receipts and enter them into the table, for example:
DATE .. | .. DESCRIPTION | .. AMOUNT | Food | Clothes | Travel | .. Other |
1/1/14..|..Train ticket.......|...£15.........|. ............|...............|... £15...|............|
3/1/14..|..Cafe lunch........|...£.5..........| .....£5....|...............|... ........|............|
Then a few rows under you can total up the columns:
DATE .. | .. DESCRIPTION |.. AMOUNT | Food |.Clothes | Travel | .. Other |
1/1/14..|..Train ticket.......|...£15.........|. ............|...............|... £15...|............|
3/1/14..|..Cafe lunch........|...£.5..........| .....£5....|...............|... ........|............|
---------------------------------------------------------------------------------
................................ .....|....£20........|.....£5. ...|...............|...£15....| ...........|
================================ ===================
You can use =SUM(C2:C3) to automatically add each column up (just change the cell references).
Doing it this way you can see exactly how much you spend and and on what. Sound like a long way of doing it but if you set aside 10 minutes at the end of the day just to type in any receipts you have from the day then it won't take long. You can stop it at the end of each month and start a new one. Then you can see how much in total you have spent for the month (Amount column) and how this is split up (by the analysis columns). The total of the analysis columns should always equal to total of the 'Amount' column.
(Original post by OU Student)
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
For example:
=SUM(C7-D7)
C7 being total income and D7 being total expenditure.
2
reply
X
Page 1 of 1
Go to first unread
Skip to page:
Quick Reply
