Budgeting

A one-page money dashboard: the eight tiles worth having

A one-page personal money dashboard with eight tiles: income, spend, savings rate, fixed ratio, top category, runway, goal status and unusual items.

Editorial illustration for A one-page money dashboard: the eight tiles worth having

A useful one-page money dashboard has eight tiles: income, spending, savings rate, fixed-cost ratio, top category, runway, goal status and a count of unusual transactions. Each tile shows one number and how it compares with last month, so a glance tells you whether something needs attention. Anything beyond eight starts to bury the signal.

What are the eight tiles and what does each show?

TileHow to calculate itHypothetical this monthLast month
IncomeAll money received for the month₹85,000₹85,000
SpendingAll spending, excluding transfers between your accounts₹58,000₹61,000
Savings rate(Income − spending) ÷ income31.8%28.2%
Fixed-cost ratioRent, EMIs, insurance and fixed bills ÷ income37.6%37.6%
Top categoryLargest category by spendingGroceries ₹14,200Groceries ₹13,100
RunwayCash you can count ÷ monthly essentials6.0 months5.75 months
Goal statusSaved against expected to dateHoliday fund: on trackOn track
Unusual countTransactions flagged for a second look35

Check the arithmetic: (₹85,000 − ₹58,000) ÷ ₹85,000 = ₹27,000 ÷ ₹85,000, about 31.8%. Last month: (₹85,000 − ₹61,000) ÷ ₹85,000 = ₹24,000 ÷ ₹85,000, about 28.2%. The fixed-cost ratio is ₹32,000 ÷ ₹85,000, about 37.6%, in both months. Runway is ₹2,40,000 ÷ ₹40,000 = 6.0 months, compared with ₹2,30,000 ÷ ₹40,000 = 5.75.

Why these eight and not others?

  • Income and spending give you the basic picture each month.
  • Savings rate turns them into a single number you can compare over time.
  • Fixed-cost ratio shows how much of your income is already committed before the month starts.
  • Top category points to where the next saving or the next question will come from.
  • Runway measures resilience, which matters more than one month's spending.
  • Goal status keeps long-term plans in view.
  • Unusual count is a quick safety check on your own records.

What makes a tile good?

  1. One number. If a tile needs a paragraph to explain it, split it or drop it.
  2. A comparison. A number alone says little; "31.8%, up from 28.2%" says something.
  3. An action. If the tile moves in the wrong direction, you should know what to look at next.
  4. A clear definition. Write the formula under each tile, so next year's version means the same thing.

How do you read it in one minute?

Start with savings rate and compare it with last month. If it is stable, glance at the runway and goal tiles. If savings rate dipped, look at the top category and the unusual count, which are the most likely explanations. If the fixed-cost ratio rose, something new has become a commitment, such as a larger EMI or a new subscription, and that deserves a closer look, because it will repeat every month.

How do you build it in a sheet?

Use one row per month, with columns for income, spending, fixed costs, essentials, cash and a few others. Then each tile is a formula pointing at the latest row and the one above it. For example, the savings rate is =(B3-C3)/B3 and the change from last month is =(B3-C3)/B3-(B2-C2)/B2. These work in Excel and Google Sheets. Format the cells as percentages and use conditional formatting for green or red arrows if you like.

Does a tracker already show some of this?

SpendixAI has a dashboard and insights, a library of 25 ready-made reports and a Report builder, plus weekly summaries. Which of these eight tiles appear there is something to check in the app itself, and you can always keep a small sheet for any you want that are missing.

Setting yours up

  • Write down the eight definitions first.
  • Fill in last month and this month.
  • Decide the day each month you will update it.
  • After three months, drop any tile you never look at and replace it with something you act on.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports