Cash Flow Mapping and Budget Reviews
Cash flow mapping tracks money entering and leaving your accounts each month. Unlike net worth, which measures accumulated wealth at a point in time, cash flow reveals the ongoing patterns that either build or erode that wealth. A structured approach to categorizing income and expenses makes budget reviews efficient and actionable.
Income Sources
Primary Income
Primary income comes from employment and represents the largest income source for most households.
Components of employment income:
- Base salary (gross pay before deductions)
- Overtime pay
- Commissions
- Tips
- Employer bonus payments
Tracking note: Use gross income for planning purposes, then account for taxes and deductions separately. This provides clearer visibility into your total compensation and tax burden.
Variable Income
Variable income fluctuates month to month and requires different treatment in cash flow planning.
Bonus income:
- Annual performance bonuses
- Signing bonuses
- Retention bonuses
- Profit-sharing distributions
Best practice: Do not include irregular bonuses in your baseline monthly budget. Instead, create a separate plan for bonus allocation when received.
Investment Income
Investment income comes from assets you own.
Types:
- Dividend payments from stocks and mutual funds
- Interest from bonds, CDs, and savings accounts
- Capital gains distributions from mutual funds
- Rental income from investment properties
Tracking note: Distinguish between income reinvested automatically and income deposited as cash. Only cash deposits affect monthly spending capacity.
Other Income Sources
Additional income streams:
- Side business or freelance income
- Rental income from property
- Alimony or child support received
- Social Security benefits
- Pension payments
- Annuity payments
Expense Categories
Fixed Expenses
Fixed expenses remain constant month to month and are contractually obligated.
Housing:
- Mortgage payment (principal + interest) or rent
- Property taxes (if not escrowed)
- Homeowners or renters insurance
- HOA dues
- Home warranty
Transportation:
- Auto loan or lease payment
- Auto insurance premium
Debt obligations:
- Student loan minimum payment
- Personal loan payment
- Credit card minimum payments
Insurance:
- Life insurance premium
- Disability insurance premium
- Health insurance premium (if not payroll deducted)
Subscriptions and memberships:
- Gym membership
- Streaming services
- Software subscriptions
- Professional dues
Variable Expenses
Variable expenses fluctuate based on usage and choices.
Utilities:
- Electricity
- Natural gas
- Water and sewer
- Trash collection
- Internet and phone
Food:
- Groceries
- Dining out
- Coffee shops
- Work lunches
Transportation:
- Gasoline
- Public transit fares
- Parking
- Tolls
- Rideshare services
Personal:
- Clothing
- Personal care and grooming
- Healthcare (copays, prescriptions, dental)
- Pet expenses
Discretionary:
- Entertainment
- Hobbies
- Travel
- Gifts
- Charitable donations
The 50/30/20 Framework
This framework allocates after-tax income into three categories.
50% Needs: Essential expenses required for basic living 30% Wants: Discretionary spending on non-essentials 20% Savings: Money directed toward financial goals
Framework Applied to $12,000/Month Income
Household profile:
- Gross monthly income: $15,000
- After-tax monthly income: $12,000 (effective 20% tax rate)
50% Needs ($6,000):
| Category | Amount |
|---|---|
| Mortgage (P&I) | $2,200 |
| Property tax and insurance | $450 |
| Utilities | $350 |
| Groceries | $800 |
| Auto payment | $450 |
| Auto insurance | $200 |
| Gas | $250 |
| Health insurance (employee portion) | $400 |
| Minimum debt payments | $300 |
| Phone | $150 |
| Internet | $80 |
| Total Needs | $5,630 |
Under budget by $370, providing buffer for unexpected essential expenses.
30% Wants ($3,600):
| Category | Amount |
|---|---|
| Dining out | $600 |
| Entertainment | $300 |
| Streaming services | $75 |
| Gym membership | $100 |
| Clothing | $200 |
| Personal care | $150 |
| Hobbies | $200 |
| Travel savings | $500 |
| Gifts | $150 |
| Miscellaneous | $400 |
| Total Wants | $2,675 |
Under budget by $925, which can absorb irregular wants or move to savings.
20% Savings ($2,400):
| Category | Amount |
|---|---|
| 401(k) contribution | $1,500 |
| Roth IRA contribution | $500 |
| Emergency fund | $200 |
| Extra debt paydown | $200 |
| Total Savings | $2,400 |
Meets target exactly.
When 50/30/20 Doesn't Fit
High cost-of-living areas often require adjusting the framework.
Alternative for high-cost areas (60/20/20):
- 60% Needs
- 20% Wants
- 20% Savings
Alternative for aggressive savers (40/20/40):
- 40% Needs
- 20% Wants
- 40% Savings
The key principle: savings should be at least 15-20% of gross income for those in the accumulation phase.
Worked Example: Monthly Cash Flow Map
Household: Dual income, $12,000 combined monthly take-home pay
Income Detail
| Source | Amount | Frequency |
|---|---|---|
| Spouse 1 salary (net) | $5,800 | Bi-weekly |
| Spouse 2 salary (net) | $4,700 | Bi-weekly |
| Dividend income | $150 | Monthly |
| Side business | $350 | Monthly (average) |
| Total Monthly Income | $11,000 |
Note: Actual take-home varies with bi-weekly pay schedules. Two months per year have three paychecks.
Expense Detail
| Category | Budgeted | Actual | Variance |
|---|---|---|---|
| Needs | |||
| Mortgage | $1,850 | $1,850 | $0 |
| Property tax/insurance | $380 | $380 | $0 |
| Utilities | $275 | $312 | -$37 |
| Groceries | $700 | $745 | -$45 |
| Auto loan | $385 | $385 | $0 |
| Auto insurance | $180 | $180 | $0 |
| Gas | $200 | $178 | +$22 |
| Healthcare | $150 | $185 | -$35 |
| Phone/Internet | $180 | $180 | $0 |
| Needs Total | $4,300 | $4,395 | -$95 |
| Wants | |||
| Dining out | $400 | $485 | -$85 |
| Entertainment | $200 | $150 | +$50 |
| Subscriptions | $85 | $85 | $0 |
| Clothing | $150 | $75 | +$75 |
| Personal care | $100 | $110 | -$10 |
| Hobbies | $150 | $200 | -$50 |
| Miscellaneous | $200 | $245 | -$45 |
| Wants Total | $1,285 | $1,350 | -$65 |
| Savings | |||
| 401(k) contributions | $1,800 | $1,800 | $0 |
| Roth IRA | $600 | $600 | $0 |
| Emergency fund | $400 | $400 | $0 |
| Extra mortgage principal | $200 | $200 | $0 |
| Savings Total | $3,000 | $3,000 | $0 |
Monthly surplus/deficit: $11,000 - $4,395 - $1,350 - $3,000 = $2,255 surplus
This surplus accumulates in checking and should be allocated monthly to specific goals or moved to savings.
Budget Review Cadence
Weekly Quick Review (5-10 minutes)
Purpose: Catch overspending early before it compounds
Review items:
- Check account balances against expectations
- Review transactions for errors or fraud
- Note any unexpected large expenses
- Assess discretionary spending pace for the month
Monthly Detailed Review (30-45 minutes)
Purpose: Complete accounting of the prior month
Process:
- Categorize all transactions
- Compare actual spending to budget by category
- Calculate total income received
- Calculate savings rate achieved
- Identify categories with consistent overages
- Adjust next month's budget if needed
- Roll over unused budget amounts or reallocate
Monthly review date: 3rd of each month (allows all transactions to post)
Quarterly Trend Analysis (45-60 minutes)
Purpose: Identify patterns across multiple months
Analysis items:
- Average monthly spending by category over 3 months
- Seasonal patterns (holidays, summer travel, heating costs)
- Income variability if self-employed or commission-based
- Progress toward annual savings goals
- Categories requiring structural changes vs. one-time adjustments
Annual Budget Reset (2-3 hours)
Purpose: Rebuild budget based on actual experience and updated goals
Process:
- Review full year of actual spending by category
- Compare to prior year for major changes
- Account for known changes (salary increase, mortgage refinance, new expenses)
- Set new category budgets based on actual data
- Align budget with updated financial goals
- Update automatic savings amounts if income changed
Best timing: December or early January
Tracking Methods
Spreadsheet tracking:
- Download transactions from bank
- Categorize manually
- Create monthly and annual summaries
- Full control over categories
Budgeting software:
- Automatic transaction import
- Pre-built categories
- Visual dashboards
- Examples: YNAB, Mint, Monarch Money
Envelope system (digital or physical):
- Allocate specific amounts to categories at month start
- Spending stops when envelope is empty
- Best for variable discretionary categories
Cash Flow Review Checklist
- Documented all income sources with amounts and frequency
- Listed all fixed monthly expenses
- Categorized variable expenses for past 3 months
- Calculated average spending by category
- Applied 50/30/20 framework to current income
- Identified categories exceeding framework targets
- Created monthly budget with specific dollar amounts per category
- Set up tracking system (spreadsheet or software)
- Scheduled weekly quick review time
- Scheduled monthly detailed review date
- Calculated current savings rate
- Compared savings rate to target (15-20% minimum)
- Created plan for regular surplus allocation
- Identified one category to reduce spending this month
- Set calendar reminder for quarterly trend analysis