How to Build a Budget Spreadsheet (Teenagers)

How to keep track of how much you are spending when aged between 13 an dc 18...and how much you are receiving! Do you (like other teens) start off at the beginning of the month with money and somehow it has leaked away by the end? And you don't have anything to show for it. This is how to keep a spreadsheet, as a teenager, so you'll know where it has gone!

Steps

  1. Image titled Build a Budget Spreadsheet (Teenagers) Step 1
    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.
  2. Image titled Build a Budget Spreadsheet (Teenagers) Step 2
    2
    Put a jazzy title in the first row. Something like Budget-2016 in a cool font and colour. This is crucial, for teens.
  3. Image titled Build a Budget Spreadsheet (Teenagers) Step 3
    3
    Add the following headings, each heading a column: Month, Date, Source, Income, Item, Expenditure, Balance, Amount to be Banked.
  4. Image titled Build a Budget Spreadsheet (Teenagers) Step 4
    4
    Write the month in the first column e.g. MAY.
  5. Image titled Build a Budget Spreadsheet (Teenagers) Step 5
    5
    When you receive money that month, write down the Date e.g. 01-05-16, and in the same row, the source e.g. parents, and then the amount, e.g. 12,500/-.
  6. Image titled Build a Budget Spreadsheet (Teenagers) Step 6
    6
    If you spend money write down the item (or place) e.g. socks, in town and the Amount e.g. £10
  7. Image titled Build a Budget Spreadsheet (Teenagers) Step 7
    7
    About ten rows down from where you have written your first items, in the column INCOME (D) write this: =SUM(D4:D14) (if you started your income in row 4 and are writing this in 15. Other cell numbers depending on where you are in the table.)
  8. Image titled Build a Budget Spreadsheet (Teenagers) Step 8
    8
    Write the same sum, with a different set of column numbers e.g. (F4:14) in the same row in your EXPENDITURE column.
  9. Image titled Build a Budget Spreadsheet (Teenagers) Step 9
    9
    In the same row as your previous two sums, in the BALANCE column, write =SUM(D15-F15) (or other numbers). This will minus your two totals, leaving YOUR BALANCE! And it will keep changing, depending what you write in the columns.
  10. Image titled Build a Budget Spreadsheet (Teenagers) Step 10
    10
    At the end of the month look at your balance. 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.
  11. Image titled Build a Budget Spreadsheet (Teenagers) Step 11
    11
    If you have a positive number highlight the cell in green. 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.
  12. Image titled Build a Budget Spreadsheet (Teenagers) Step 12
    12
    If you have a negative number highlight in red. 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.
  13. Image titled Build a Budget Spreadsheet (Teenagers) Step 13
    13
    Congratulations, you have a budget spreadsheet. 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.

Tips

  • Don't lie on your budget. It is tempting, but can only lead you into debt.
  • Have a separate section for vouchers e.g. iTunes cards. And maybe for debts, if you owe people money.
  • Write down everything you receive on birthdays and at Christmas, etc. It will make you feel good. It is also an excellent time to bank.
  • If you can't remember an item, just put a place.
  • Try to budget after a shopping spree.

Article Info

Categories: Budgeting