Personal Finance Dashboard — Google Sheets & Excel

About this product

A complete personal finance system in one spreadsheet: log every transaction once, and it automatically builds your monthly income/expense summary, category budgets, and an overall dashboard — all with live formulas, no manual recalculating, no subscription.

What you get

• 5 connected tabs: Categories, Transactions, Monthly Summary, Dashboard, Instructions
• 20 built-in categories (17 expense + 3 income) — add unlimited custom ones
• Auto-filled transaction Type — pick a category, the Income/Expense type fills itself in (no mismatches possible)
• Per-category Monthly Budgets, with live "Budget Used %" tracking
• Jan-Dec Monthly Summary table for any year — income, expenses, net savings
• Full Dashboard — all-time totals, savings rate, this month's numbers, budget status
• Top Spending Categories This Month, auto-ranked (Google Sheets QUERY)
• 150 transaction rows built in — about a year of activity for most households
• Color-coded, protected cells — formulas can't be accidentally overwritten
• Works in Google Sheets AND Excel

One-time payment vs. subscription apps

• Most budgeting apps charge you every single month, forever:
• | | Monthly subscription apps | Personal Finance Dashboard (Sheets) |
• |---|---|---|
• | Price | ~$5–15 / month ($60–180 / year) | $4.49 **once** |
• | Account required | Yes, theirs | No — just your own Google account |
• | Your data | On their servers | In your own Google Sheets / Excel file |
• | Customizable | Rarely | Fully — it's a spreadsheet you own |

How it works

1. Download the .xlsx file
2. Upload it to Google Sheets (File → Import → Upload) or open it directly in Excel
3. Set up your categories and monthly budgets first (Categories tab)
4. Log transactions as they happen (Transactions tab) — 16 demo rows show you the pattern
5. Watch your Monthly Summary and Dashboard update automatically, in real time

20 categories included

• Expense: Bills · Dining Out · Education · Entertainment · Gifts · Groceries · Health · Insurance · Loan · Personal Care · Pets · Rent · Savings · Shopping · Subscriptions · Transport · Travel
• Income: Salary · Freelance · Other Income

100% private

Your data lives in your own Google Sheets copy or local Excel file — nothing is sent anywhere, no account with a third party required beyond your own Google/Microsoft login.

Questions