The Ultimate FIRE Spreadsheet: Tracking Your Net Worth and Expenses

FIRE Spreadsheet Overview

A FIRE spreadsheet is a structured way to track two things that drive most FIRE math: your net worth and your spending rate. Net worth tracking shows whether your assets are compounding and whether liabilities are shrinking. Expense tracking shows how much money you actually spend to live, not how much you think you spend. When you connect the two, you can spot patterns like “spending rises after a job change” or “net worth grows but cash flow is still negative.”

Start with a simple premise: you need repeatable inputs. Bank and credit card statements feed balances and transactions; brokerage statements feed holdings and cost basis; retirement account records feed balances. For a practical example, if you export transactions from a bank on the 1st of each month, you can reconcile the prior month’s spending with the same date range every time. That consistency matters more than fancy formulas, which many people skip because they look intimidating.

In spreadsheets, “repeatable” usually means separate tabs for transactions, categories, and monthly summaries. A clean layout prevents category drift, like when “eating out” quietly turns into “groceries” after a few months. I’ve seen versions of this spreadsheet break after a single column rename; on my side, I once watched a sheet built in Excel 365 (version 2408) stop updating because a referenced column moved. The fix was simple, but the lesson stuck: treat your sheet like a system, not a one-off report.

Common Tracking Pain Points

People often track the wrong number, then build a decision around it. A common mistake is using account balances as a proxy for spending. Balances move with deposits, transfers, dividends, and market changes, so they do not measure lifestyle costs. Another mistake is mixing one-time expenses into monthly averages without labeling them. A $1,800 car repair in March can distort a “monthly spend” chart for the next year if it stays in the same bucket as recurring bills.

Category design also causes silent errors. If you let categories overlap, you get inconsistent tagging. “Home” might include utilities one month and only rent the next. “Health” might include prescriptions in one month and dental in another. The spreadsheet then reports a spending trend that reflects your labeling habits rather than your actual spending behavior.

Dependencies matter because FIRE spreadsheets pull from multiple sources. Net worth depends on accurate account balances and consistent valuation rules for each account type. Expenses depend on transaction exports and a stable mapping from merchant descriptions to categories. If you use credit cards, you also need a rule for whether you categorize by transaction date or statement date. That choice changes the month totals, and it rarely matches how you mentally track bills.

Finally, many spreadsheets fail at the reconciliation step. Without a monthly check, you can miss missing transactions or double-count transfers. A transfer from checking to a brokerage account should not count as spending, but it can look like spending if you categorize it as “investments” in the wrong tab. The spreadsheet needs a “do not count” rule for internal transfers, or your expense totals will quietly inflate.

Build It With Practical Rules

Set Up Tabs And Columns

Create a small set of tabs that match your workflow. A typical set includes: Accounts (account name, type, currency, starting balance), Transactions (date, description, amount, account, category, notes), Category Map (merchant keywords or manual rules), and Monthly Summary (month, total spending, net worth, cash flow). Keep the column names stable and avoid renaming headers after you start using the sheet. If you use Google Sheets, I’ve found that named ranges reduce breakage when columns shift, though they add a learning curve.

For net worth, decide how you value each account. Cash and checking use the balance. Brokerage uses market value. Retirement accounts use the reported balance. If you track crypto, use a consistent exchange or valuation method and record the date of valuation. Market value changes can dwarf your contributions in some months, so the spreadsheet should show both “net worth change” and “contributions” if you want a clearer view of progress.

Track Expenses With Categories

Use categories that reflect decisions you can change. A workable set often includes housing, utilities, groceries, transportation, insurance, healthcare, debt payments, subscriptions, and “other.” Split discretionary spending into at least two buckets, like “eating out” and “entertainment,” because those often move together. Keep a “one-time” or “irregular” label for expenses that do not repeat. Then decide whether your FIRE “spending rate” includes irregular items; many people exclude them for a conservative baseline, but you should state your rule in the sheet.

Choose a transaction date rule and stick to it. If you categorize by transaction date, you align with how bank exports are timestamped. If you categorize by statement date, you align with how credit card bills feel. Either works, but mixing rules creates month-to-month noise. A practical compromise is to categorize by transaction date and add a reconciliation note when statement timing causes a mismatch.

Reconcile Monthly Without Drama

Once per month, reconcile the sheet to your source data. Compare the sum of categorized spending for the month to your bank and credit card totals for the same date range. Then check that transfers between accounts appear as transfers, not as spending. If you track net worth, confirm that the net worth tab matches the sum of account balances on the same day or within a defined window.

Set a “reconciliation tolerance” so you do not chase pennies. For example, you might accept a $5–$20 difference due to pending transactions and exchange rate timing. If the difference grows beyond that range, you investigate. This habit prevents the spreadsheet from becoming a guessing game, which tends to happen when people skip reconciliation for months.

Measure Progress With Two Views

Track progress using both a net worth view and a spending view. Net worth view answers: are assets growing and liabilities shrinking? Spending view answers: is your lifestyle cost moving toward a stable baseline? In the monthly summary, show total spending for the month, average spending over the last 3–6 months, and a separate “irregular-adjusted” average if you exclude one-time items. This dual view helps when markets drop while your spending stays controlled, or when spending rises temporarily due to a planned expense.

When you compute FIRE-relevant spending, use a consistent method. If you exclude irregular items, exclude them every time using the same label. If you include them, include them every time. The spreadsheet should not change its logic based on mood, because that makes charts look better than they are.

Case Examples For Real Scenarios

Job Change With Timing Mismatch

Alex changes jobs in March and starts a new health plan mid-month. Alex’s credit card statement shows a $220 premium payment in early April, while the bank export shows the transaction on March 28. Alex categorizes by transaction date, so the March spending includes the premium. The monthly summary shows March spending higher than April, even though the bill “arrived” in April. Alex resolves the confusion by adding a note field for timing issues and by keeping the transaction-date rule consistent.

In the spreadsheet, Alex also labels the premium as “insurance/health” and marks it as recurring. That prevents the premium from being treated as irregular when it repeats in later months. The key outcome is not a perfect chart; it is a chart that matches the chosen accounting rule.

Car Repair And Irregular Label

Sam budgets for transportation but forgets to plan for a $1,050 brake job in September. The spreadsheet categorizes it under “transportation” by default. Sam then adds an “irregular” tag in the transaction notes and sets a rule that irregular items do not count toward the FIRE spending baseline. The monthly summary shows September total spending spiking, while the irregular-adjusted average stays closer to the prior months.

Sam reviews the irregular label at year-end to confirm it was truly one-time. If a repair becomes recurring, Sam moves future similar costs into the recurring bucket. This keeps the spreadsheet honest about what “baseline spending” means.

Checklist And Comparison Table

Use the checklist below to decide whether your spreadsheet design supports decision-making. The goal is fewer surprises during reconciliation, not a perfect model.

Step-by-step checklist for your next month:

1. Export transactions for the same date range you used last month.
2. Import into the Transactions tab and run your category mapping rules.
3. Mark transfers with a “transfer” category so they do not count as spending.
4. Label irregular items and decide whether they count toward your FIRE baseline.
5. Update account balances for the net worth date and reconcile totals.
6. Review the top 10 spending categories and confirm each looks plausible.
7. Record any reconciliation differences and fix the cause before next month.

Common Mistakes That Break Trust

One mistake is hiding logic inside complex formulas. If you cannot explain how a number is produced, you cannot debug it when it looks wrong. A better approach uses a few clear helper columns, like “is_transfer” or “is_irregular,” so the monthly summary stays auditable.

Another mistake is changing category definitions midstream. If you rename “subscriptions” to “digital services” and merge categories, you lose comparability. Keep a category map history or avoid renaming once you start tracking. When you must change, add a new category and migrate old transactions only if you can do it consistently.

People also overfit to a single month. A spreadsheet that shows a dramatic improvement after a budget push can still be misleading if the prior month included a one-time expense. Use rolling averages and a rule for irregular items so the chart reflects your baseline rather than your luck.

Finally, many spreadsheets ignore currency and timing issues. If you travel and spend in another currency, the transaction export may store amounts in the local currency and convert them. If the conversion rate differs from your bank’s rate, totals can drift. Record the conversion method in a notes field and keep it consistent.

FAQ

What Accounts Should I Track?

Track every account that affects your net worth: checking, savings, credit card balances (as liabilities), brokerage accounts, retirement accounts, and any other assets you can value reliably. If you include a debt account, include it consistently so net worth changes reflect both sides.

How Do I Separate Spending From Investing?

Use a “transfer” or “investment contribution” category for internal moves and purchases of investments. Then exclude those categories from the spending total while still including them in net worth and cash flow views.

Should I Use Transaction Date Or Statement Date?

Pick one rule and apply it to all credit card and bank transactions. Transaction date aligns with most exports; statement date aligns with billing cycles. Consistency matters more than which one you choose.

How Many Months Of History Do I Need?

For expense baselines, 3–6 months often reveals recurring patterns, while 12 months helps confirm irregular items and seasonal spending. If your spending is stable, a shorter window can work, but reconciliation still needs to stay monthly.

How Do I Handle Irregular Expenses?

Label irregular items at the transaction level and decide whether your FIRE spending baseline excludes them. Keep a review step so you can reclassify costs that turn out to be recurring.

Author's Insight

A FIRE spreadsheet succeeds when it turns messy financial data into consistent monthly numbers. The most reliable designs separate transactions from summaries, use stable category rules, and include a monthly reconciliation step with a tolerance for timing differences. Net worth tracking needs clear valuation rules for each account type, because market value changes can overwhelm contributions. Expense tracking needs a decision about irregular items and a single date rule for credit cards. If you treat the spreadsheet as an accounting system with repeatable inputs, the charts become easier to trust.

Key Takeaways

• Track net worth and spending separately, then connect them through monthly summaries.
• Use stable categories, a single transaction-date rule, and a transfer exclusion rule.
• Label irregular expenses so your FIRE baseline reflects recurring lifestyle costs.
• Reconcile monthly with a tolerance and fix the cause of differences before they compound.
• Keep the spreadsheet logic auditable so you can debug it when numbers look off.