F. Financial Literacy · Money and Finances: Payments, Financial Plans, Budgets, Interest and Smart Spending

Tools for Tracking Income and Spending

F1.3 A1About 45 minutes

Learning goals

I can describe tools for tracking money: a notebook ledger, a spreadsheet, a budgeting app, online banking and envelopes.
I can keep a running balance of income and spending.
I can use simple spreadsheet formulas to total and track money.
I can compare a budget with actual spending and choose a good tool for a scenario.

Words to know

ledger
A record of every amount of money coming in and going out, in order by date.

running balance
The amount you have after each transaction: previous balance + income − spending.

transaction
Any time money comes in or goes out.

spreadsheet
A digital grid of cells (like A1, B2) that can hold numbers, words and formulas.

formula
In a spreadsheet, a calculation that starts with =, like =SUM(B2:B8).

bank statement
A list from the bank of all deposits and withdrawals in an account for a period of time.

Where did it all go?

At the start of October, Aiden had $45. During the month he earned money babysitting and doing chores. By the end, he had $76.15. He's sure he earned more than that! Was some money lost, or did small purchases add up?

Without a record, Aiden can only guess. With a tracking tool, he'd know.

Tools for tracking money

Notebook ledger with receipts. Write each transaction as it happens. Cheap and simple, but you have to do all the math, and it's easy to forget an entry.
Spreadsheet. Formulas add things up and keep a running balance for you. You can make graphs. It needs a device and some setting up.
Budgeting app. Can sort spending into categories and show charts. Some link to bank accounts. Check privacy settings and any costs, and use it with a grown-up.
Online banking and bank statements. Show every card and account transaction. But cash spending doesn't appear, so you still need your own notes.
Envelope (or jar) system. Put cash for each category in its own envelope. When the envelope is empty, that category is done for the month. Very clear, but only works with cash.

Many people use more than one tool, for example online banking plus a spreadsheet.

Date	Description	Income	Spending	Balance
Oct 1	Start			$45.00
Oct 3	Babysitting	$40.00		$85.00
Oct 5	Movie with friends		$14.50	$70.50
Oct 10	Allowance	$20.00		$90.50
Oct 14	Snacks		$6.75	$83.75
Oct 20	Birthday gift		$22.60	$61.15
Oct 27	Raking leaves	$15.00		$76.15

Aiden's October ledger with a running balance.

Aiden's ledger as a graph. Each jump up is income and each drop down is spending, so you can see exactly where his money went.

Worked example

Example 1: Check Aiden's ledger

Use the ledger. Find Aiden's total income and total spending for October, and check his ending balance.

Income: 40.00 + 20.00 + 15.00 = $75.00.
Spending: 14.50 + 6.75 + 22.60 = $43.85.
Ending balance = start + income − spending = 45.00 + 75.00 − 43.85 = $76.15. ✓ It matches.

Nothing was lost. Aiden earned $75 and spent $43.85. Seeing it written down helps him decide if that spending fits his goals.

Cell	What to type	What it does
B3 to B8	Income amounts	One income amount per row
C3 to C8	Spending amounts	One spending amount per row
D2	45	Starting balance
D3	=D2+B3-C3	New balance = last balance + income − spending. Fill down for each row.
B10	=SUM(B3:B8)	Total income
C10	=SUM(C3:C8)	Total spending

A simple tracking spreadsheet. Formulas start with =. "Fill down" copies a formula to the rows below, changing D2 to D3, D4 and so on.

Worked example

Example 2: Budget vs. actual

The Leblanc family budgeted $1 000 for food, $650 for transportation and $290 for other costs. Their tracking app shows they actually spent $1 036, $612 and $305. Find each difference and the overall result.

Food: 1 036 − 1 000 = $36 over.
Transportation: 650 − 612 = $38 under.
Other: 305 − 290 = $15 over.
Overall: budgeted 1 940, spent 1 953. 1 953 − 1 940 = $13 over.

They're $13 over in these categories. Food and "other" need attention next month. Tracking shows exactly where to adjust.

The Leblanc family's budget next to what they actually spent. Bars taller than the budget show where to adjust next month.

Worked example

Example 3: Tracking a class fundraiser

A Grade 8 class bake sale took in $312.50. They spent $86.40 on ingredients, $14.75 on plates and napkins, and $9.85 on poster paper. How much did they raise?

Total spending: 86.40 + 14.75 + 9.85 = $111.00.
Profit: 312.50 − 111.00 = $201.50.

They raised $201.50. For a group, a shared spreadsheet and kept receipts let everyone see where the money went.

Small amounts add up

A $4 drink 5 school days a week is $20 a week. Over a 40-week school year that's $800! Tracking every amount, even small ones, is how you notice this.

Be honest with yourself

A tracker only helps if it's complete. If you forget to write something, add it as soon as you remember. Reviewing your spending without judging yourself helps you make calmer choices next time.

Just for fun

Many people who track their spending for the first time solve the great mystery of "Where did my money go?" The answer is often less exciting than a thief: it was snacks, a little bit at a time.

Hands-on activity

One week of tracking

You need: a notebook or a spreadsheet, and any receipts you get.

Write your starting amount (the money in your wallet, piggy bank or account).
For one week, record every transaction: date, description, income or spending.
Keep a running balance. At the end, check: start + income − spending = what you actually have. Do they match?
If you used a spreadsheet, use =SUM(...) for totals and =D2+B3-C3 (or similar) for the running balance.
Sort your spending into 3 or 4 categories. Which category was biggest? Was there a surprise?

What to look for: every row filled in, a balance that matches real money (or an explanation if it doesn't), and one thing your child would change.

Your turn

Start with $30. Then: earn $25, spend $12.40, earn $10. What is the running balance at the end?

Write a spreadsheet formula to add the amounts in cells B2 to B8.

The fun budget was $60, but $72.35 was spent. Over or under, and by how much?

Give one advantage and one disadvantage of a budgeting app compared with a notebook.

How does the envelope system work?

You start a month with $20, earn $85 and spend $67.20. What should you have at the end?

Groceries: budget $120, actual $131.50. Transit: budget $40, actual $36. What is the overall difference?

More practice: warm-up

Start with $20, earn $15, spend $8. What is the balance?

What is a receipt?

In a ledger, does babysitting money go in the income or spending column?

Budget $50, spent $42. Over or under, and by how much?

What does the spreadsheet formula =B2+B3 do?

More practice: on your own

Start $12.50. Earn $35 (dog walking). Spend $9.99 (app). Spend $18.40 (gift). Earn $20 (allowance). What is the final balance?

In a spreadsheet, income is in column B, spending in column C and the balance in column D. What formula goes in D3?

A family's food budget is $900. Four weekly receipts: $212.45, $238.10, $199.80, $261.35. Over or under, and by how much?

A class sells 85 items at $2.50 each. Supplies cost $64.30. What is the profit?

Why should you track cash spending even if you use online banking?

Challenge

A student's spending for a month: food $54, fun $36, transit $18, gifts $12. Find each category's percent of the total and the angle each would have in a circle graph.

A spreadsheet goal tracker has the goal $500 in cell F1 and monthly savings in B2 to B7. The savings add up to $365. (a) Write a formula for the percent of the goal reached. (b) What does it show?

Your own records say your account has $214.60. The bank statement says $199.60. What might have happened, and what should you do?

Check your understanding

Quiz

Start $50, earn $30, spend $22.75. What is the balance?

Which formula adds the numbers in cells C2 to C9?

Which tracking tool will miss cash spending unless you also keep your own notes?

A budget for fun is $40. Actual spending is $31.80. What is the result?

In a running-balance spreadsheet, which formula belongs in D5 (income in B, spending in C)?

Why is it useful to compare budgeted amounts with actual amounts?

For parents and teachers

Big idea: F1.3 asks students to use appropriate tools to track all income and spending, for several different scenarios. Students compare tools (notebook, spreadsheet, app, online banking, envelopes) and practise running balances and simple spreadsheet formulas.

How to help at home:

Help your child set up a simple spreadsheet (Google Sheets, Excel, LibreOffice or Numbers all work) and track a week of their money.
If they use any money app, review its privacy settings together.
Show how you check a statement or receipts (with private details covered).

Common difficulties:

Forgetting small or cash purchases. Encourage writing things down the same day.
Spreadsheet formulas without =, or adding spending instead of subtracting it in the running balance.
Mixing up over and under budget. Ask, "Did you spend more or less than planned?"