Cash flow worksheet
This worksheet walks you through the money that arrives in one typical month, the money you spend, and the gap between them. Print it or copy the tables into a spreadsheet, then fill it in from your statements.
What this measures
Your cash flow is the movement of money through your household over a period, here one typical month. It pairs with the net worth worksheet. That one is a snapshot of what you own and owe on a single date; this one is the flow through your accounts over a month, and together they describe where you stand and which way you are moving.
Money in means take-home pay: what lands in your account after taxes and payroll deductions come out. Money out means spending only. Transfers to a savings account, a brokerage account, or an individual retirement account are not spending and stay off the page, because the gap between money in and money out is exactly what this worksheet measures, and counting savings as an expense would hide it.
Before you start
Gather a recent pay stub and one month of bank and card statements, and work from those rather than from memory. For anything paid yearly or a few times a year, such as insurance premiums, property tax, or holiday gifts, divide the annual amount by 12 and enter that.
Money in
Use the amount deposited, not the salary figure on your offer letter, because the difference between the two is money you never get to spend. If you are paid every two weeks, multiply one paycheck by 26 and divide by 12 to get a monthly figure, since two paychecks a month understates the year.
One example row is filled in for each category to show what belongs there; the values are made up. Add as many rows as you need.
| Source | Example | Your number |
|---|---|---|
| Take-home pay | ||
| Your paycheck, and a partner’s if you share finances | $5,600 | $ |
| Side income | ||
| Weekend freelance work | $200 | $ |
| Other regular income | ||
| Rental, benefits, or support payments | $200 | $ |
| Money in total | $ |
Count a partner’s pay only if you share finances, and add a row for each paycheck. Side income and other income belong here only if they arrive regularly; a one-time gift or a tax refund is not part of a typical month. For income that varies, average the last six months and lean low.
Money out
Enter spending only, as above. Debt payments are different from transfers to savings: they are money leaving the household for good, so they belong in the table.
| Category | Example | Your number |
|---|---|---|
| Housing | ||
| Rent or mortgage, utilities, home insurance | $1,900 | $ |
| Transportation | ||
| Car payment, fuel, insurance, transit fares | $600 | $ |
| Food | ||
| Groceries and eating out | $800 | $ |
| Insurance and health costs | ||
| Health premiums not taken from pay, prescriptions, visits | $300 | $ |
| Debt payments | ||
| Minimums on cards and loans | $400 | $ |
| Everything else | ||
| Phone, subscriptions, personal, gifts averaged to monthly | $1,100 | $ |
| Money out total | $ |
Housing includes home insurance only if it is not already bundled into the mortgage payment; if it is, the payment already covers it. For debt payments, enter the minimum due on each card and loan. Anything you pay above the minimum is a choice to put money toward the debt, and it belongs in the left-over figure rather than in spending. The last category catches everything that does not fit above, and it is usually larger than people expect; the total is often the most useful number on the page.
The result
Add up each table, then subtract money out from money in.
| Line | Example | Your number |
|---|---|---|
| Money in total | $6,000 | $ |
| Money out total | $5,100 | $ |
| Left over (money in minus money out) | $900 | $ |
| Savings rate (left over divided by money in) | 15% | % |
In the example, $6,000 comes in and $5,100 goes out, leaving $900. Divided by $6,000, that is a savings rate of 15%. Your left-over figure is the money available each month to build a cash reserve, pay down debt faster, or fund a goal.
What the number does and does not tell you
A negative left-over number means you are spending more than your take-home pay. The gap has to come from somewhere, and that somewhere is savings being drawn down or debt being added to. One negative month after an unusual expense is not alarming. A negative typical month is the first thing to fix, because every other part of a plan depends on a positive gap.
A commonly cited starting reference for savings rate is 10% to 20% of take-home pay. Treat it as a reference point, not a target for you in particular. Someone early in a career with student loans may sit below it for a while; someone starting retirement saving late may need to be well above it.
Workplace retirement contributions taken out before your paycheck arrives are in neither column. They are not in money in, because they never reach your account, and they are not in money out, because they are not spending. That means the savings rate on this worksheet understates your total saving. If you and your employer together put 8% of your gross pay into a workplace plan, up to the yearly limit (see this year’s figures), your real saving is well above the 15% shown. Write the contribution amount, and any employer match, in the margin so the full picture is on one page.
What to do with it
Do the worksheet for a typical month, not an unusual one. A month with a wedding, a car repair, or a tax refund in it tells you about that month, not about your household. Repeat it a few months apart; two or three versions across a year show the real pattern.
Carry the left-over number into the goals conversation in Set goals, where it sets what can be funded from what you already earn, and set it beside the result of the net worth worksheet. The balance and the monthly flow together are the picture Take stock is meant to produce.
For advisors
A self-prepared cash flow worksheet makes a useful intake exercise, and the gaps between it and the statements are as informative as the numbers themselves: the categories a client cannot fill in, the “everything else” line that swallows a third of spending, and income figures given as gross. Ask specifically for pre-paycheck retirement contributions and the employer match, because the worksheet excludes them and the resulting savings rate can look far weaker than it is. The left-over figure, corrected and averaged over several months, is the amount actually available to fund goals, and it sets the boundaries of the goals conversation before any target is named.