Read a sample: 1. Your First Household Spreadsheet
A household budget begins with a few ordinary questions: How much money came in? Where did it go? How did the month turn out compared with what you expected?
You may already have pieces of the answer in a bank account, a stack of receipts, a payment app, or a list of bills. The difficulty is that those pieces live in different places. A spreadsheet gives you one place to bring them together, organize them, and check the totals.
You do not need to be a math expert or an experienced computer user to get started. You do need a willingness to enter information carefully and review it now and then. The spreadsheet can do useful arithmetic, but it cannot know whether you forgot a purchase, entered a payment twice, or chose a plan that does not fit your household. Those decisions remain yours.
In this chapter, you will get acquainted with what a household budget tracks and how a spreadsheet represents that information. You will also meet the fictional household used in the examples and see how to use the exercises throughout the book. There is no need to build a complete budget today. First, let’s make the work ahead feel familiar.
A household budget is a way to organize money coming in and money going out over a chosen period. In this book, that period is usually one month.
Income is money available to the household from sources such as take-home pay or other payments received. Spending is money used for expenses such as housing, groceries, transportation, and utilities. A budget can also include a plan: the amounts you expect to receive and spend before the month is finished.
These three views answer different questions:
- Income and spending records show what you have entered as having happened.
- A plan shows what you expected or intended to happen.
- A comparison shows the difference between the plan and the recorded result.
Suppose a fictional household plans to spend $400 on groceries during a month and records $430 in grocery purchases. The recorded spending is $30 more than planned. That difference is not a verdict on anyone’s character. It is a prompt to look more closely. Perhaps the plan was too low, perhaps the household bought supplies for a special occasion, or perhaps a purchase was categorized incorrectly.
A useful budget makes room for questions like these. It helps you notice a difference; it does not automatically explain it.
A budget also does not have to capture every detail of your financial life at once. The starting point in this book is a straightforward record of household income and spending. Later, you will organize that record into categories, make a monthly plan, and compare the plan with actual entries.
Think of a spreadsheet as a large sheet of paper divided into boxes. Each box can hold an item of information, such as a date, a description, a number, or a formula.
The vertical sections are called columns. Spreadsheet programs commonly label them with letters: A, B, C, and so on. The horizontal sections are called rows, and they are usually labeled with numbers: 1, 2, 3, and so on.
A single box is a cell. A cell’s address combines its column letter and row number. For example, A1 is the cell where column A and row 1 meet. B1 is immediately to its right, and A2 is immediately below it.
That naming system is useful because it gives every entry a location. Instead of saying “the number near the top of the page,” you can refer to a specific cell. Later, formulas will use cell references to find the numbers they need.
A worksheet is one page of cells. A workbook is the spreadsheet file that holds one or more worksheets. You might keep a monthly record on one worksheet and use another worksheet for a different month or a separate summary. For now, it is enough to know that the workbook is the file and the worksheet is a page inside it.
Different spreadsheet programs arrange their menus and buttons differently. The basic ideas, however, are shared: select a cell, enter something, and use rows and columns to keep related information together. You can follow this book with common spreadsheet software even if your screen does not look exactly like someone else’s.
A transaction is a money event you want to record, such as receiving pay or buying groceries. In the worksheet you will build, each transaction will generally have its own row. Columns will hold the details that describe it.
Here is a small hypothetical example. The dates and amounts are invented for practice, and the amounts are in dollars.
Read across the first transaction row. It tells you when the money arrived, what it was, how it was categorized, and how much income was recorded. The next two rows describe spending.
Read down the spending column and you can see the individual expenses. In this hypothetical example, $85 for groceries plus $40 for transportation equals $125 in recorded spending. The $1,800 in recorded income minus that $125 leaves a difference of $1,675 for these entries.
That figure is not necessarily the household’s bank balance or the amount it can safely spend. The table contains only three sample transactions. Other bills, purchases, income, or account activity may be missing. Even a complete income-and-spending total for a…