Short answer: A personal finance dashboard is a single spreadsheet tab that pulls your key numbers from a few simple data tabs and shows them on one screen. Track eight numbers each month: income, spending, savings rate, cash cushion (months of expenses), total debt, net worth, progress toward your top goals and the month-over-month change in net worth. Set up four tabs (Transactions, Accounts, Goals and Dashboard), use a handful of formulas such as SUMIFS, and update it once a month in about 20 minutes. The first build takes roughly an hour.
This guide is general education by the Pearset Editorial Team. It works in Google Sheets, Microsoft Excel, Apple Numbers or LibreOffice Calc. The formulas shown use the syntax common to Google Sheets and Excel. All numbers in the examples are made up for illustration.
What a personal finance dashboard is (and why a spreadsheet works)
A personal finance dashboard is a one-page summary of your money: what came in, what went out, what you own, what you owe and whether you are on track for your goals. Think of it as the instrument panel of a car. You do not need to see every part of the engine, just the speed, the fuel and the warning lights.
A spreadsheet is a good home for it because it is free or cheap, it is private (your data stays in a file you control), and it is fully flexible. Budgeting apps are faster at importing transactions, and our roundup of the best budgeting apps of 2026 compares them. Many people use both: an app or bank export for the raw transactions and a spreadsheet for the monthly big picture.
The goal is not perfect accounting. It is a monthly habit of looking at the same few numbers in the same place, so trends become obvious before they become problems.
The 8 numbers to track every month
More numbers do not make a better dashboard. These eight answer the questions that matter most: am I spending less than I earn, am I protected, and am I getting wealthier?
| Metric | How to calculate it | What it tells you | Example |
|---|---|---|---|
| 1. Income (after tax) | All money received this month: pay, side income, refunds you count as income | What you actually have to work with | $5,200 |
| 2. Spending | All money spent this month, excluding transfers to savings and investments | Your real cost of living | $4,160 |
| 3. Savings rate | (Income − Spending) ÷ Income | The share of income you keep; the single best progress indicator | 20% |
| 4. Cash cushion | Emergency savings ÷ average monthly essential spending | How many months you could cover if income stopped | 3.1 months |
| 5. Total debt | Sum of all balances owed: cards, loans, car, student loans, mortgage | Whether you are paying down or piling up | $18,400 |
| 6. Net worth | Total assets − total debts | Your overall financial position | $41,750 |
| 7. Net worth change | This month's net worth − last month's | Direction of travel; the trend matters more than the level | +$1,120 |
| 8. Goal progress | Amount saved toward each goal ÷ target | Whether big plans are on schedule | House deposit 46% |
Two optional extras are useful once the basics are running: your top three spending categories (where the money really goes) and your debt-to-income ratio (monthly debt payments divided by gross monthly income), which lenders look at when you apply for a mortgage or loan.
How to set up the spreadsheet: four tabs
Keep raw data and the summary apart. Data tabs are where you type or paste; the Dashboard tab only reads from them. That way you never overwrite a formula by accident.
Tab 1: Transactions
One row per transaction, with columns Date, Description, Category, Amount, Type. Use positive numbers and put "Income" or "Expense" in the Type column, which keeps formulas simple. Most banks let you download transactions as a CSV file; paste them in once a month and add the category. Keep the category list short, around 10 to 15 items such as Housing, Food, Transport, Insurance, Debt payments, Subscriptions, Fun and Giving.
Tab 2: Accounts (balance snapshot)
One row per account or asset and one column per month. Rows include checking, savings, retirement accounts, brokerage, other investments, the estimated value of a car or home, and every debt (entered as a negative number or in a separate debt section). On the first day of each month, type in the balances. This tab drives your net worth. Our guide on how to calculate your net worth explains what to include and how to value harder-to-price assets.
Tab 3: Goals
Columns for Goal, Target amount, Target date, Saved so far, Monthly amount needed. Typical goals: emergency fund, holiday fund, car replacement, home deposit, a sinking fund for annual bills.
Tab 4: Dashboard
A small table with the eight metrics for the current month, the same metrics for last month, and a change column. Add two charts: net worth by month (a line chart) and spending by category (a bar chart). That is the whole dashboard.
The formulas that do the work
You only need a few functions. Assume the Transactions tab has dates in column A, categories in C, amounts in D and type in E, and the Dashboard tab holds the month start date in cell B1.
| Purpose | Example formula |
|---|---|
| Income this month | =SUMIFS(Transactions!D:D, Transactions!E:E, "Income", Transactions!A:A, ">="&B1, Transactions!A:A, "<="&EOMONTH(B1,0)) |
| Spending this month | Same as above with "Expense" |
| Spending in one category | Add Transactions!C:C, "Food" to the SUMIFS |
| Savings rate | =IF(B2=0, "", (B2-B3)/B2) with income in B2 and spending in B3, formatted as a percentage |
| Net worth | =SUM(Accounts!F2:F20) where column F is this month's balances and debts are negative |
| Cash cushion | =EmergencyFund / AVERAGE(last 3 months of essential spending) |
| Goal progress | =SavedSoFar / Target, formatted as a percentage |
| Monthly amount needed for a goal | =(Target-SavedSoFar)/MAX(1, DATEDIF(TODAY(), TargetDate, "M")) |
Add simple conditional formatting as warning lights: turn the savings rate cell red below 10 percent, the cash cushion red below three months, and the net worth change red when it is negative. A glance then tells you where to look.
The one-hour setup plan
- Minutes 0 to 10: create the file and tabs. Make the four tabs and type in the headers. Freeze the top row on each data tab.
- Minutes 10 to 25: list your accounts and balances. Log in to each bank, card, loan and retirement account and record today's balance on the Accounts tab. This step usually takes longest the first time.
- Minutes 25 to 40: load one month of transactions. Download last month's transactions from your main checking account and card, paste them in and assign categories. Do not chase perfection; "Other" is fine for odd items.
- Minutes 40 to 50: add the formulas. Build the eight metrics on the Dashboard tab using the formulas above.
- Minutes 50 to 60: add goals, charts and warning colors. Enter two or three goals, insert the net worth and category charts, and set the conditional formatting.
After that, a monthly update takes about 20 minutes: paste transactions, categorize, type in month-end balances, and read the dashboard.
A worked example
Consider a hypothetical freelancer, Sam, with a variable income. In October Sam earned $5,200 after tax and spent $4,160, a 20 percent savings rate. Emergency savings of $9,000 divided by average essential spending of $2,900 gives a cushion of about 3.1 months. Accounts total $60,150 and debts total $18,400, so net worth is $41,750, up $1,120 from September.
The dashboard flags two things. Food spending was $780, about $200 above Sam's three-month average, and the holiday fund is only 30 percent funded with six weeks to go. Sam decides to move $150 a month from the "Fun" category to the holiday fund until December. Because Sam's income is irregular, the dashboard also tracks a rolling three-month average income, a technique explained in our guide to the 50/30/20 budget for irregular income.
How to read your dashboard each month
- Watch trends, not single months. One expensive month is noise. Three months of rising spending is a signal.
- Look at the savings rate first. If it is positive and stable, most other numbers will improve over time.
- Check the cushion before investing more. Many people aim for three to six months of essential expenses before taking on investment risk. Our plan to build an emergency fund from zero shows how.
- Make one decision. End each review with a single action, such as cancelling a subscription, raising an automatic transfer or adding an extra debt payment.
Common mistakes to avoid
| Mistake | Why it hurts | Fix |
|---|---|---|
| Counting transfers to savings as spending | Makes your savings rate look worse than it is | Use a separate "Transfer" type and exclude it |
| Too many categories | Categorizing becomes a chore and you stop updating | Keep 10 to 15; merge small ones |
| Overvaluing a car or home | Inflates net worth | Use conservative estimates and update them once or twice a year |
| Skipping months | Breaks the trend line, the most useful part | Put a recurring calendar reminder on the first weekend of each month |
| Sharing the file carelessly | Exposes account details | Store balances only, never passwords or full account numbers |
Tracking investments and real assets on the dashboard
Add one row per investment account on the Accounts tab and record the month-end value. For investments that pay income, such as dividend funds or fractional shares of an income-producing real asset, add an "Investment income" category on the Transactions tab so you can see that income separately from your salary. Record income only when it actually arrives, and treat projections as estimates, not figures to plan your spending on.
If you hold shares in a real asset through Pearset Assets, the Pearset Tracking view shows the asset's activity, and the Pearset Market is where shares can be listed for resale. For your dashboard, a conservative approach is to value such holdings at what you paid unless there is a clear, recent market price, because resale depends on finding a buyer. Automating contributions to savings and investments, as described in our guide on how to automate your savings, makes the dashboard's trend lines move in the right direction without extra willpower.
Frequently asked questions
What should a personal finance dashboard include?
At minimum: monthly income, spending, savings rate, emergency cash cushion in months, total debt, net worth, the monthly change in net worth and progress toward your main goals.
How long does it take to build a budget dashboard in a spreadsheet?
About an hour for the first version with four tabs: Transactions, Accounts, Goals and Dashboard. Monthly updates then take around 20 minutes.
Is a spreadsheet better than a budgeting app?
Neither is better for everyone. Apps import transactions automatically, while a spreadsheet is cheaper, private and fully customizable. Many people use an app or bank export for transactions and a spreadsheet for the monthly summary.
What is a good savings rate?
It depends on your income, costs and goals. A positive, stable savings rate that you can keep up is more important than hitting a particular number; many people aim for 10 to 20 percent or more.
How often should I update my money dashboard?
Once a month is enough for most people. Pick a fixed day, such as the first weekend of the month, and record balances as of the same date each time.
Should I include my home and car in net worth?
You can, using conservative estimates, but many people also track a version without them so they can see their liquid and investable wealth separately.
Sources
Reference pages checked on November 16, 2026. Formulas and examples are Pearset Editorial Team illustrations with made-up figures.
- CFPB: Budgeting, how to create a budget and stick with it (reference page)
- CFPB: Spending tracker tool (PDF) (August 2021 edition)
- CFPB: Track your spending with this easy tool (reference page)