How to Build a Budget Spreadsheet (Teenagers)
Open EXCEL on your computer., Put a jazzy title in the first row., Add the following headings, each heading a column: Month, Date, Source, Income, Item, Expenditure, Balance, Amount to be Banked. , Write the month in the first column e.g., When you...
Step-by-Step Guide
-
Step 1: Open EXCEL on your computer.
Teens should use a computer, or a laptop or even a table.
You can use Excel or any other spreadsheet creating software.
You could use a sheet of paper, but this will involve you doing a whole lot of unnecessary maths. -
Step 2: Put a jazzy title in the first row.
Something like Budget-2016 in a cool font and colour.
This is crucial, for teens. ,, MAY. , 01-05-16, and in the same row, the source e.g. parents, and then the amount, e.g. 12,500/-. , socks, in town and the Amount e.g. £10 , Other cell numbers depending on where you are in the table.) , (F4:14) in the same row in your EXPENDITURE column. , This will minus your two totals, leaving YOUR BALANCE! And it will keep changing, depending what you write in the columns. , Then count up all the money in your piggy bank.
It should (in theory) look the same.
If it isn't either add something to the expenditure or income column. , Well Done! You haven't spent more than your income.
If it is over £50 you should consider banking some of it.
If you are, put the amount in the BANKED column.
Set this aside in a different purse until you can bank it. , Look at your ITEM column.
If it is presents or necessary items, we forgive you.
Your other months will make up for it.
If it is all chocolate and DVDs, you need to watch your spending more.
Make sure that negative months are made up for by positive months. , After a few months, you will know where you are with your accounts.
And hopefully be better at saving.
And you can show your parents what a responsible, mature young adult you are. -
Step 3: Add the following headings
-
Step 4: each heading a column: Month
-
Step 5: Source
-
Step 6: Income
-
Step 7: Expenditure
-
Step 8: Balance
-
Step 9: Amount to be Banked.
-
Step 10: Write the month in the first column e.g.
-
Step 11: When you receive money that month
-
Step 12: write down the Date e.g.
-
Step 13: If you spend money write down the item (or place) e.g.
-
Step 14: About ten rows down from where you have written your first items
-
Step 15: in the column INCOME (D) write this: =SUM(D4:D14) (if you started your income in row 4 and are writing this in 15.
-
Step 16: Write the same sum
-
Step 17: with a different set of column numbers e.g.
-
Step 18: In the same row as your previous two sums
-
Step 19: in the BALANCE column
-
Step 20: write =SUM(D15-F15) (or other numbers).
-
Step 21: At the end of the month look at your balance.
-
Step 22: If you have a positive number highlight the cell in green.
-
Step 23: If you have a negative number highlight in red.
-
Step 24: Congratulations
-
Step 25: you have a budget spreadsheet.
Detailed Guide
Teens should use a computer, or a laptop or even a table.
You can use Excel or any other spreadsheet creating software.
You could use a sheet of paper, but this will involve you doing a whole lot of unnecessary maths.
Something like Budget-2016 in a cool font and colour.
This is crucial, for teens. ,, MAY. , 01-05-16, and in the same row, the source e.g. parents, and then the amount, e.g. 12,500/-. , socks, in town and the Amount e.g. £10 , Other cell numbers depending on where you are in the table.) , (F4:14) in the same row in your EXPENDITURE column. , This will minus your two totals, leaving YOUR BALANCE! And it will keep changing, depending what you write in the columns. , Then count up all the money in your piggy bank.
It should (in theory) look the same.
If it isn't either add something to the expenditure or income column. , Well Done! You haven't spent more than your income.
If it is over £50 you should consider banking some of it.
If you are, put the amount in the BANKED column.
Set this aside in a different purse until you can bank it. , Look at your ITEM column.
If it is presents or necessary items, we forgive you.
Your other months will make up for it.
If it is all chocolate and DVDs, you need to watch your spending more.
Make sure that negative months are made up for by positive months. , After a few months, you will know where you are with your accounts.
And hopefully be better at saving.
And you can show your parents what a responsible, mature young adult you are.
About the Author
Linda Barnes
Creates helpful guides on pet care to inspire and educate readers.
Rate This Guide
How helpful was this guide? Click to rate: