Interactive Tool + Excel Export
📊

Interactive Budget Builder

Build a complete monthly budget, get a smart direct-deposit allocation across bill and play accounts, plan sinking funds for Christmas, emergencies, retirement, and vacation, and export the whole thing as an Excel workbook with 12 monthly tabs that track budgeted vs actual with automatic difference calculations.

📊 Or import 12 months of bank CSVs and let us pre-fill these numbers →

The Bill Account / Play Account Method

One of the most effective budgeting structures — especially for households with two earners — is the "bill account, play account" method. Here's how it works:

  • Bill account: A dedicated checking account that receives exactly enough from each paycheck to cover all fixed expenses, sinking fund contributions, and savings goals. Every autopay, every recurring bill, every transfer to savings comes out of this account. You never spend out of it.
  • Play account(s): Whatever's left after the bill account funding goes here — one for each earner. This is your "you can spend it" money. Groceries, dining out, entertainment, personal purchases. When the play account is empty, you stop spending until next paycheck.

The discipline is structural rather than willpower-based: bills and savings are funded automatically before either spouse can accidentally spend the money. Discretionary spending is limited to whatever lands in the play accounts. The system keeps household finances on track even when individual months are chaotic.

Why sinking funds matter

"Sinking funds" are dedicated savings buckets for predictable but irregular expenses — Christmas, vacation, car repairs, annual insurance premiums. By saving a fixed amount monthly, you avoid the December credit-card-debt pattern most households fall into. Each savings goal gets a small monthly contribution; by the time the expense arrives, the money is already there.

This tool calculates the right monthly contribution for each sinking fund based on the goal you set, shows you the recommended percentages of income to put toward each, and exports an annual budget you can track month by month in Excel.

1. Income Streams

Add each source of monthly income (after-tax / take-home, not gross). Include both spouses if applicable.

2. Fixed Monthly Bills

Recurring bills that are roughly the same each month. These will be funded from your "bill account."

3. Variable Monthly Spending

Expenses that change month-to-month: groceries, dining, gas, entertainment. Estimate average monthly amounts. These typically come from "play accounts."

4. Sinking Funds & Savings Goals

Monthly contributions toward future expenses and goals. The recommended percentages are based on standard personal-finance benchmarks for typical households.

GoalMonthly Contribution

Your Monthly Budget Summary

Total Income
Fixed Bills
Variable Spending
Savings & Goals
Net (Surplus / Deficit)

Direct Deposit Allocation

Tell your employer (or spouse's employer) to split paychecks across these accounts. Most payroll systems allow direct deposit splits across 2-4 accounts.

🏦 Bill Account (Required)

💸 Play Account(s)

Sinking Fund Recommendations

How your savings allocation compares to recommended percentages of net income:

Export Your Annual Budget

Download a complete Excel workbook with 12 monthly tabs. Each month has Budgeted, Actual, and Difference columns — fill in your actual spending each month to track variance.

How to Use Your Annual Excel Budget

The exported workbook contains:

  • Annual Summary tab: Year-to-date totals across all categories. Updates as you fill in monthly tabs.
  • 12 monthly tabs (January-December): Each has the same structure — your budgeted amounts pre-filled, with Actual and Difference columns to fill in as the month progresses.
  • Difference formulas: The Difference column auto-calculates Actual minus Budgeted. Negative numbers (in red) mean you spent less than budgeted; positive means you spent more.
  • Section totals: Each section (Income, Fixed, Variable, Savings) totals automatically.

Monthly review process (15 minutes)

  • End of each month: Open the workbook, fill in the Actual column for the month that just ended.
  • Review the Difference column: Where did you go over budget? Where under?
  • Adjust next month's budget if patterns emerge (e.g., always over on groceries — raise the line; always under on entertainment — reallocate).
  • Track sinking fund balances in your savings account — the Excel tracks contributions, but the actual cash should be in dedicated savings.

Recommended percentage targets (% of net income)

  • Housing: 25-30% maximum (mortgage/rent + insurance + tax + utilities)
  • Transportation: 10-15% (auto loan + gas + insurance + maintenance)
  • Food (groceries + dining): 10-15%
  • Insurance (health, life, etc., not in housing/transport): 5-10%
  • Emergency fund savings: 5-10% until 3-6 months of expenses are saved
  • Retirement savings: 10-15% of gross income (capture full employer match first)
  • Christmas / holiday fund: $50-150/month depending on family size
  • Vacation fund: $100-300/month depending on travel goals
  • Discretionary / play money: 10-20% (the rest)

The 50/30/20 rule

A simpler high-level guide: 50% of net income for needs (housing, food, transportation, utilities, insurance, minimum debt payments), 30% for wants (entertainment, dining, hobbies, subscriptions), 20% for savings and additional debt payoff. Households in debt resolution often shift toward 50/20/30 (more savings/debt, less wants) until the debt is resolved.

If you're carrying debt

The same budget structure applies, but the "savings" allocation should prioritize aggressive debt payoff or debt settlement contribution before building beyond a $1,000 emergency fund. The order: $1,000 emergency starter fund → capture 401(k) match → aggressive debt payoff or settlement contribution → build full 3-6 month emergency fund → long-term retirement and other savings.