A simple budget in Sheets
Plan your money with income and expenses, use formulas to see what's left, and work out how long it takes to save for a goal.
Plan your money with a simple budget. A budget is a plan for your money. It shows what comes in, what goes out, and what's left. It helps you save for things you want, and avoid running out of money before the end of the week or month.
Income and expenses
Income is money coming in, like pocket money, wages, or money from selling things. Expenses are money going out, like transport, food, data and airtime. Here's Kemi's weekly budget. She gets ten thousand naira. She spends three thousand on transport, four thousand on lunch, and fifteen hundred on data. In the last cell, the formula takes away all her expenses from her income, and shows what's left, fifteen hundred naira. Kemi wants a school bag that costs nine thousand naira. If she saves fifteen hundred a week, dividing the price by her weekly saving shows it will take six weeks.
Make your own budget
First, list the money you get in a week or a month. Second, list everything you spend money on. Third, add up your expenses with a SUM formula. Fourth, take your expenses away from your income to see what's left. And fifth, check it every week, and adjust it if things change.
Money tips
Pay yourself first. Put a little into savings as soon as money comes in, before you spend. Track small spending, like snacks and airtime. It adds up faster than you think. And put needs, like transport and food, before wants, like a new game.
Quick check
Quick check. Your income is 8,000 naira and your expenses are 6,500 naira. How much is left? 1,500 naira. Income minus expenses is what's left over. Options: ₦1,500; ₦14,500; ₦6,500; ₦8,000.
Recap
A budget is a plan for your money. Income comes in, and expenses go out. What's left over is income minus expenses. Save first, and track your small spending.
Key points
- A budget is a plan for your money, showing income (money in) and expenses (money out).
- In Sheets, add expenses with SUM and take them away from income, for example =B2-SUM(B3:B5).
- To find how long a goal takes, divide the price by what you save each week, for example =B2/B3.
- Pay yourself first, track small spending and put needs before wants.
Try it: Plan a week's budget
Type your weekly income and expenses (real or made up). Try to make the left over ₦0 or more.