Skip to content
Pearset logoPearset

How to Build a Personal Finance Dashboard in a Spreadsheet (in About an Hour)

A one-page money dashboard shows whether you are moving forward without a budgeting app. Here are the numbers worth tracking every month, the tabs to set up and the formulas that do the work, with a one-hour plan.

By Published Updated Budgeting
Pearset blog cover: how to build a personal finance dashboard in a spreadsheet

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?

Core dashboard metrics. Pearset Editorial Team; example figures are illustrative.
MetricHow to calculate itWhat it tells youExample
1. Income (after tax)All money received this month: pay, side income, refunds you count as incomeWhat you actually have to work with$5,200
2. SpendingAll money spent this month, excluding transfers to savings and investmentsYour real cost of living$4,160
3. Savings rate(Income − Spending) ÷ IncomeThe share of income you keep; the single best progress indicator20%
4. Cash cushionEmergency savings ÷ average monthly essential spendingHow many months you could cover if income stopped3.1 months
5. Total debtSum of all balances owed: cards, loans, car, student loans, mortgageWhether you are paying down or piling up$18,400
6. Net worthTotal assets − total debtsYour overall financial position$41,750
7. Net worth changeThis month's net worth − last month'sDirection of travel; the trend matters more than the level+$1,120
8. Goal progressAmount saved toward each goal ÷ targetWhether big plans are on scheduleHouse 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.

Starter formulas for Google Sheets and Excel. Adjust ranges to match your sheet.
PurposeExample formula
Income this month=SUMIFS(Transactions!D:D, Transactions!E:E, "Income", Transactions!A:A, ">="&B1, Transactions!A:A, "<="&EOMONTH(B1,0))
Spending this monthSame as above with "Expense"
Spending in one categoryAdd 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

  1. 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.
  2. 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.
  3. 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.
  4. Minutes 40 to 50: add the formulas. Build the eight metrics on the Dashboard tab using the formulas above.
  5. 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

Frequent dashboard pitfalls and fixes. Pearset Editorial Team.
MistakeWhy it hurtsFix
Counting transfers to savings as spendingMakes your savings rate look worse than it isUse a separate "Transfer" type and exclude it
Too many categoriesCategorizing becomes a chore and you stop updatingKeep 10 to 15; merge small ones
Overvaluing a car or homeInflates net worthUse conservative estimates and update them once or twice a year
Skipping monthsBreaks the trend line, the most useful partPut a recurring calendar reminder on the first weekend of each month
Sharing the file carelesslyExposes account detailsStore 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.

  1. CFPB: Budgeting, how to create a budget and stick with it (reference page)
  2. CFPB: Spending tracker tool (PDF) (August 2021 edition)
  3. CFPB: Track your spending with this easy tool (reference page)