💰 SUBU Personal Finance Tracker

An advanced Excel-based personal finance management system designed to help individuals track expenses, manage income, monitor bank balances, analyze spending patterns, and achieve budget goals. Features automated calculations, visual dashboards, and comprehensive financial insights.

📋 Overview

This system solves a critical personal finance challenge: How to understand where your money goes, control spending, and achieve financial goals through data-driven insights.

The system helps you by:

• Dashboard Overview: See your complete financial picture at a glance
• Expense Tracking: Daily expense recording with automatic categorization
• Income Management: Track all income sources with date-wise details
• Budget Analysis: Compare actual spending vs. budget targets
• Wealth Visualization: Pie charts showing asset allocation
• Time-Period Analysis: Flexible date range for financial reports
• Savings Calculator: Automatic calculation of savings (Income - Expenses)

📸 View & Play with the File

Access Personal Finance Tracker

Click the link above to access the live system

Password for all sheets: 123

📊 System Screenshots

Budget Summary & Variance Analysis

Monthly budget comparison with actual expenses vs. target budget, highlighting overspending categories

Budget Analysis with Spending Trends

Detailed spending analysis with color-coded visual indicators for budget adherence

Time Period Data & Financial Ratios

Comprehensive time-period analysis with expense ratios, savings ratios, and budget targets

Expense Categories Setup

Customizable expense categories with helpful notes showing what each category includes

Dashboard - Wealth Holding Pie Chart

Visual wealth distribution across bank accounts, cryptocurrency, and stock holdings

Expense Data Entry Sheet

Daily expense tracking with categorization, store/vendor details, and optional notes

Income Data Entry Sheet

Income tracking with source, amount, category and detailed notes for each entry

🎯 Why I Built This

I created this finance tracker for my personal use to:

• Understand my spending habits
• Identify areas where I was overspending
• Set and track budget goals
• Monitor my wealth across different holdings
• Make data-driven financial decisions

I'm sharing it publicly so others can benefit from organized financial tracking and gain control over their finances.

✨ Key Features

1. Dashboard (Overview)

Your financial command center:

• Total Bank Balance: Current cash in hand
• Holdings Summary: Stocks and cryptocurrency investments
• Total Wealth: Combined value of all assets
• Wealth Distribution Pie Chart: Visual breakdown of asset allocation
• Quick Financial Snapshot: All key metrics at a glance

2. Expense Tracking

Daily expense management:

• Date-wise Entry: Record expenses as they happen
• Category-based: Organize by expense type (Food, Transport, Bills, etc.)
• Amount Tracking: Precise expense recording
• Automatic Totaling: Daily, monthly, and category-wise totals
• Notes Field: Add context to each expense

3. Income Tracking

Complete income management:

• Multiple Income Sources: Track salary, freelance, investments, etc.
• Date-wise Recording: When income was received
• Category Classification: Type of income source
• Automatic Calculations: Total income by period
• Source Tracking: Know where money comes from

4. In Hand (Bank Balance)

Personal account management:

• Account Details: All bank accounts in one place
• Transaction History: Date-wise balance changes
• Category Tags: Classify transactions
• Source Tracking: Why balance changed
• Notes Section: Additional transaction details

5. Comparison to Budget Target

Powerful budget analysis:

• Flexible Time Periods: Set start and end dates
• Expense by Category: See spending breakdown
• Budget vs. Actual: Compare planned vs. real spending
• Conditional Formatting: Visual alerts for overspending
• Period-over-Period: Track trends across time ranges
• Automatic Calculations: No manual math needed

6. Total Budget Target

Annual budget planning:

• Annual Spending Goals: Set targets for each category
• Category-wise Budgets: Allocate amounts to expense types
• Automatic Distribution: Calculates monthly allowances
• Progress Tracking: See how you're doing vs. goals
• Budget Recommendations: Suggested amounts based on patterns

7. Budget Analysis

Detailed spending insights:

• Overspending Alerts: Highlighted categories exceeding budget
• Underspending Tracking: Categories with budget remaining
• Percentage Analysis: How much of budget used
• Visual Indicators: Color-coded spending levels
• Actionable Insights: Know where to cut back

8. Selected Time Period Data

Custom date range analysis:

• Expense Summary: Total spending in selected period
• Income Summary: Total earnings in selected period
• Savings Calculation: Income minus expenses
• Ratio Analysis: Expense-to-income ratio
• Average Calculations: Daily/monthly averages
• Budget Comparison: vs. allocated budget

9. Category Setup

Customization options:

• Expense Categories: Define your own expense types
• Income Categories: Customize income sources
• In Hand Categories: Set up account types
• Easy Modification: Change categories anytime
• Auto-propagation: Changes reflect across all sheets

10. Portfolio Tracking Integration

Investment monitoring:

• Crypto Holdings: Track cryptocurrency investments
• Stock Portfolio: Monitor share holdings
• Import Range Formula: Data from external sheets (Google Sheets)
• Real-time Updates: Connected to live data sources
• Wealth Aggregation: Combined view with bank balance

🚀 Complete Step-by-Step Guide - How to Use

📥 PART 1: Initial Setup (One-Time, 15 Minutes)

Step 1: Download and Open the File

1. Click the Access Link
2. Click Download to save the file to your computer
3. Open the file in Microsoft Excel (2016 or later recommended)
4. When prompted for password, enter: 123
5. Save a copy with your name: "YourName_Finances_2025.xlsx"

---

Step 2: Customize Your Expense Categories

1. Click on the "Category Setup" sheet tab (at the bottom)
2. Look at the "Expense Categories (up to 40)" section
3. Review the pre-filled categories:
   • Bills & Utilities, Childcare & Baby Needs, Commute, Education
   • Electronics & Gadgets, Entertainment, Family, Fitness
   • Snacks & Quick Bites, Fuel, Gifts, Groceries, etc.
4. Each category has helpful notes on the right showing what it includes
5. Customize to match YOUR lifestyle:
   • Keep categories you use regularly
   • Delete categories you don't need
   • Add new categories specific to your life
   • Examples to add: "Pet Care", "Hobbies", "Charity", "Gaming"

Important: Don't delete the headers or change the structure, only modify category names!

Pro Tip: Start with the default 27 categories for the first month, then customize based on your actual spending patterns.

---

Step 3: Set Up Your Income Categories

1. In the same "Category Setup" sheet
2. Scroll to find the "Income Categories" section
3. Default options include: Job/Salary, Freelance, Investments, Side Income
4. Add YOUR income sources:
   • Bonus, Rental Income, Gifts, Interest, Dividends, etc.
5. These will automatically appear as dropdown options in your Income sheet

---

Step 4: Set Your Budget Targets (Important!)

1. Open the "Total Budget Target" sheet
2. You'll see all your expense categories listed
3. In the "Your Budget Target" column (yellow highlighted)
4. Enter your MONTHLY spending limit for each category:

Example Budget Setup:

Bills & Utilities         → ₹0 (if you want to track without a limit)
Groceries                 → ₹5,000 per month
Fuel                      → ₹3,000 per month
Restaurant & Dining Out   → ₹4,000 per month
Entertainment             → ₹2,000 per month

5. Tips for Setting Budgets:

   • Start conservative (lower amounts)
   • Track for 1 month without budgets to see your baseline
   • Then set realistic budgets based on actual spending
   • You can adjust anytime!

6. The "Implied Annual Spend" column auto-calculates (Monthly × 12)

---

Step 5: Enter Your Current Bank Balance

1. Navigate to "In Hand" sheet
2. Add your starting balance:

Example Entry:

Date: 01-01-2025 (today's date)
Category: Bank Balance (or create "Opening Balance")
Source: HDFC Savings Account
Amount: ₹50,000 (your actual current balance)
Notes: Starting balance for January 2025

3. If you have multiple accounts, add separate rows:
   • Row 1: HDFC Savings - ₹50,000
   • Row 2: ICICI Checking - ₹20,000
   • Row 3: Cash in Hand - ₹5,000
   • Total In Hand: ₹75,000

---

Step 6: Add Your Wealth Holdings (Optional)

1. Go to "Dashboard" sheet
2. Find the "Your Actual Data of Income" section
3. Enter your current investment values:
   • InHand (Bank) Holding: Your total bank balance
   • Crypto Holdings: Total cryptocurrency value
   • Shares & Commodities Holdings: Stock portfolio value
4. The Wealth Holding Pie Chart will automatically update!
5. This gives you a complete picture of where your money is

---

📝 PART 2: Daily Usage (Only 2-3 Minutes Per Day!)

Recording Expenses (The Most Important Part!)

Every time you spend money, log it immediately:

1. Open the "Expense Data" sheet
2. Add a new row with these details:

Example Daily Expense Entry:

Date: 03-01-2025
Month: Jan 25
Store/Vendor: Kings Restaurant LLP
Amount: ₹208.00
Expense Category: Restaurant & Dining Out (select from dropdown)
ExpenseKeys: Dining Out, Fast Food, Café, Home Delivery
Notes (Optional): Ice Cream thing at dis

3. The ExpenseKeys column shows what that category includes
4. Notes are optional but helpful for remembering context
5. Everything else calculates automatically!

Pro Tips for Expense Tracking:

• ✅ Log expenses the same day (don't wait!)
• ✅ Use your phone to take a quick note if you're out
• ✅ Small expenses matter (₹20 coffee adds up!)
• ✅ Be specific with Store/Vendor (helps identify patterns)
• ✅ Use Notes for anything unusual or important

---

Recording Income (When Money Comes In)

Every time you receive money:

1. Open the "Income Data" sheet
2. Add a new row:

Example Income Entry:

Date: 03-01-2025
Source: Ondirect Company Salary
Amount: ₹21,929.00
Income Category: Job / Salary (select from dropdown)
Notes: Feb Salary

Special Income Types:

- Salary transfer to savings: 
  Source: "Transfer to Expenses accounts"
  Category: "Job / Salary"
  Notes: "Use for Expenses"

- Freelance payment:
  Source: "Client Project Work"
  Category: "Side Income"
  Notes: "College Project Work of Priya Naidu"

3. The system tracks:
   • Total income by month
   • Income by category
   • Automatically calculates savings (Income - Expenses)

---

Updating Bank Balance (When It Changes)

When your bank balance changes (beyond expenses/income):

1. Open "In Hand" sheet
2. Add an entry:

Examples:

Transfer to savings:
Date: 05-01-2025
Category: Bank Transfer
Source: Moved to Fixed Deposit
Amount: -₹10,000 (negative for money out)
Notes: 1-year FD investment

Received gift money:
Date: 10-01-2025
Category: Gift/Other
Source: Birthday gift from parents
Amount: +₹5,000 (positive for money in)
Notes: Birthday gift

---

📊 PART 3: Weekly/Monthly Analysis (Understanding Your Money)

Check Your Dashboard (Weekly)

1. Open "Dashboard" sheet
2. Review at a glance:
   • Total bank balance
   • Total wealth holdings
   • Wealth distribution (pie chart)
   • How your money is spread across accounts/investments

What to look for:

• Is your bank balance decreasing too fast?
• Are investments growing?
• Is wealth distribution balanced?

---

Compare Budget vs. Actual (Monthly)

1. Open "Comparison to Budget Target" sheet
2. Set your time period:

At the top, enter:

Start of time period: 01-01-2025
End of time period: 31-01-2025

3. The sheet automatically shows:
   • Expenses by Category (Actual vs. Budget)
   • Variance to Budget (how much over/under)
   • Color coding: Red = overspent, Green = under budget
   • Budget Summary with total variance

Example Analysis:

Groceries: ₹5,000 actual vs. ₹4,000 budget = ₹1,000 OVER
Fuel: ₹2,000 actual vs. ₹3,000 budget = ₹1,000 UNDER
Restaurant: ₹6,000 actual vs. ₹4,000 budget = ₹2,000 OVER (ALERT!)

4. Action Steps:
   • Identify categories where you overspent (RED)
   • Think about why (special occasion? habit?)
   • Adjust behavior or budget for next month

---

View Budget Analysis (Detailed Spending Patterns)

1. Open "Budget Analysis" sheet
2. This shows:
   • Your Actual Spending (based on entered data)
     • Monthly Average
     • Total for 11 months
   • Your Budget Target (to be manually entered)
     • Monthly Spend
     • Implied Annual Spend
3. Color indicators:
   • Green: Well under budget
   • Yellow: Approaching budget
   • Red: Over budget (needs attention!)

Use this to:

• See which categories consume most of your budget
• Identify trends (are you spending more each month?)
• Make informed decisions about budget adjustments

---

Review Time Period Data (Custom Analysis)

1. Open "Selected Time Period Data" sheet
2. This automatically shows (based on Comparison sheet dates):
   • Totals: Expenses, Income, Savings
   • Ratios: Expense Ratio, Savings Ratio
   • Averages: Daily/monthly averages
   • Budget Targets: How you're doing vs. goals

Key Metrics to Watch:

Savings Ratio: 30%+ is excellent, 20%+ is good, <10% needs work
Expense Ratio: Should be 60-70% of income maximum

Example Reading:

Month 1 (Jan 2025):
- Expenses: ₹9,701.00
- Income: ₹21,929.00
- Savings: ₹12,228.00
- Savings Ratio: 55.8% (EXCELLENT! 🎉)

---

🎯 PART 4: Monthly Review Process (30 Minutes)

Do this on the last day of each month:

Step 1: Review Your Spending (15 minutes)

1. Open "Comparison to Budget Target"
2. Set dates: 1st to last day of month
3. Ask yourself:
   • Which category surprised me?
   • Where did I overspend and why?
   • Which categories were well-controlled?
   • Any one-time expenses (gifts, repairs)?

Step 2: Analyze Patterns (5 minutes)

1. Go to "Expense Data" sheet
2. Sort by Expense Category
3. Look for patterns:
   • Too many restaurant visits?
   • Impulse purchases?
   • Unexpected high bills?

Step 3: Adjust Budget for Next Month (5 minutes)

1. Open "Total Budget Target" sheet
2. Based on your analysis:
   • Increase budget for categories you consistently overspend
   • Decrease budget for categories with room
   • Keep total monthly budget realistic

Step 4: Set Goals for Next Month (5 minutes)

Write down (in a separate note or journal):

• "Next month I will reduce dining out by 20%"
• "I will track every small expense under ₹50"
• "I will increase savings from 25% to 30%"

---

💡 PART 5: Pro Tips for Success

Best Practices:

1. Track EVERYTHING - Even ₹10 expenses add up to ₹3,000/month!
2. Update Daily - Takes 2 minutes, saves hours of catching up
3. Review Weekly - Sunday evening dashboard check
4. Analyze Monthly - Last day of month full review
5. Be Honest - Don't hide expenses from yourself
6. Use Notes - Future you will thank you for context
7. Stay Consistent - Works only if you track regularly

Common Mistakes to Avoid:

❌ Waiting to update - You'll forget transactions
❌ Skipping small expenses - They matter most!
❌ Setting unrealistic budgets - You'll just ignore them
❌ Not reviewing reports - Data without action is useless
❌ Modifying formula sheets - Unless you know Excel well
❌ Giving up after one month - Takes 2-3 months to see patterns

Quick Daily Routine (2 minutes):

Morning: Check if any expenses from yesterday were missed
Evening: Log today's expenses (usually 2-5 entries)
Before bed: Quick glance at Dashboard to see daily total

How to Handle Special Situations:

Forgot to track for a week?

1. Check bank statements/credit card statements
2. Estimate categories based on vendors
3. Add all missed transactions with notes: "Catch-up entry"

Made a big purchase?

1. Create a note explaining why (necessary vs. impulse)
2. See how it affects monthly budget
3. Adjust next month if needed

Got unexpected income?

1. Add to Income sheet immediately
2. Decide: Save it? Use for pending expenses?
3. Don't let it "disappear" into general spending

Shared expenses with family/roommate?

1. Track your share only
2. Use Notes: "Split with roommate - my half"
3. Or create category: "Shared Expenses"

---

🔧 PART 6: Customization & Advanced Features

Changing Currency (₹ to $ or other)

1. Select all sheets (Ctrl + Click each tab)
2. Find & Replace: Ctrl + H
3. Find: ₹
4. Replace with: $ (or your currency)
5. Click "Replace All"
6. Format cells as currency for your region

Adding More Expense Categories

1. "Category Setup" sheet
2. Add new categories in empty rows
3. They automatically appear in dropdown menus
4. Don't exceed 40 categories (limit in formula)

Creating Custom Reports

1. Duplicate "Comparison to Budget Target" sheet
2. Rename: "Q1 2025 Report" or "Year Review 2025"
3. Set custom date ranges
4. Use for quarterly or yearly analysis

Tracking Multiple People (Family Tracking)

1. Add a new column in Expense sheet: "Person Name"
2. Use data validation dropdown: You, Spouse, Kids
3. Filter by person to see individual spending
4. Combine for family total

Integrating with Google Sheets (Auto Portfolio Updates)

1. If using Google Sheets version
2. Use IMPORTRANGE formula to pull data from:
   • Stock portfolio tracker
   • Crypto portfolio tracker
3. Dashboard updates automatically!

---

📊 Technical Implementation

Technology Stack:

• Microsoft Excel / Google Sheets
• Advanced formulas:
  • SUMIFS: Category-wise expense totaling
  • IMPORTRANGE: Portfolio data import (Google Sheets)
  • DATEDIF: Time period calculations
  • IF/AND/OR: Conditional logic for alerts
  • VLOOKUP: Category matching
• Conditional Formatting: Visual spending alerts
• Data Validation: Dropdown menus for consistency
• Pivot Tables: Dynamic reporting
• Charts: Pie charts for wealth distribution

Data Structure:

SUBU Finances Tracker
├── Dashboard (Overview & Charts)
├── Expense (Daily expense entries)
├── Income (Income tracking)
├── In Hand (Bank balance management)
├── Comparison to Budget Target (Period analysis)
├── Total Budget Target (Annual budget setup)
├── Budget Analysis (Spending vs. targets)
├── Selected Time Period Data (Custom reports)
├── Category Setup (Customization)
│   ├── Expense Categories
│   ├── Income Categories
│   └── In Hand Categories
└── Portfolio Tracking (Optional)
    ├── Crypto Holdings
    └── Stock Portfolio

Key Calculations:

Total Expenses = SUMIFS(Amount, Category, Selected_Category, Date, Date_Range)
Savings = Total Income - Total Expenses
Budget Remaining = Budget Target - Actual Spending
Savings Ratio = (Savings / Income) × 100
Average Daily Expense = Total Expense / Number of Days

📈 Reports You'll Get

Daily Reports:

• Today's expenses by category
• Cash flow for the day
• Running bank balance

Monthly Reports:

• Total income vs. total expenses
• Category-wise spending breakdown
• Budget vs. actual comparison
• Savings amount and percentage
• Top spending categories

Custom Period Reports:

• Any date range you select
• Trend analysis over time
• Spending patterns identification
• Budget adherence tracking

Visual Reports:

• Wealth distribution pie chart
• Expense category breakdown
• Income sources visualization
• Budget utilization graphs

💡 Financial Insights You'll Gain

✅ Know Where Money Goes: Category-wise breakdown of every rupee
✅ Identify Overspending: Automatic alerts for budget violations
✅ Track Savings Progress: See savings trends over time
✅ Plan Better: Data-driven budget adjustments
✅ Achieve Goals: Monitor progress toward financial targets
✅ Reduce Waste: Spot unnecessary expenses
✅ Build Wealth: See investment portfolio growth
✅ Financial Discipline: Visual accountability for spending

📈 Future Enhancements

Personal roadmap for this tracker:

• Mobile app version for on-the-go expense entry
• Automatic bank statement import (CSV)
• Receipt photo attachment feature
• Bill payment reminders
• Savings goal tracker with progress bars
• Credit card payment tracking
• Loan/EMI management module
• Tax calculation assistance
• Year-end financial summary report
• Multi-currency support
• Family expense sharing features
• Automated email reports (weekly/monthly)

🎓 Tips for Success

Best Practices:

1. Daily Updates: Enter expenses same day (don't wait)
2. Be Specific: Use detailed category names
3. Check Weekly: Review spending every Sunday
4. Adjust Budget: Based on real patterns, not wishes
5. Use Notes: Add context to unusual expenses
6. Track Everything: Small expenses add up
7. Review Monthly: Full analysis once a month
8. Set Realistic Goals: Budget should be achievable

Common Mistakes to Avoid:

❌ Don't skip small expenses (they matter!)
❌ Don't set unrealistic budgets
❌ Don't forget to update income
❌ Don't ignore the reports (use them!)
❌ Don't modify formula sheets (unless you know Excel)

💼 For Freelancers & Finance Enthusiasts

Skills Demonstrated:

• Personal finance management
• Data analysis and visualization
• Excel formula mastery (SUMIFS, IMPORTRANGE, conditionals)
• Budget planning and tracking
• Financial reporting
• Dashboard design
• User experience thinking (simple 3-sheet update system)
• Problem-solving (organized chaos of personal finances)

This project shows:

• Ability to solve real-life problems with data
• Understanding of financial concepts
• Excel automation expertise
• Attention to detail in calculations
• User-friendly design principles

Available for:

• Custom financial tracking systems
• Budget planning tools
• Personal finance consulting
• Excel automation projects
• Financial dashboard development
• Data analysis and reporting

🤝 Contributing & Feedback

This is a personal project I'm sharing with the community. If you:

• Find it useful and want to improve it
• Have suggestions for new features
• Spot any calculation errors
• Want to create a version for your country/currency

Feel free to:

• Open an issue with suggestions
• Share your customized version
• Provide feedback on what works/doesn't work

📞 Contact

For questions, customization help, or freelance work:

• GitHub
• Email: suubhamghadge@gmail.com
• LinkedIn

📄 License

This project is available under the MIT License - use it, modify it, share it!

Note: This is a tool for personal finance management. Always consult with a qualified financial advisor for important financial decisions.

---

🌟 Project Stats

---

💰 Take Control of Your Finances - One Entry at a Time

⭐ If this helps you manage your money better, please star this repository!

💬 Have questions? Open an issue and I'll help you get started!

🎯 Start tracking today - your future self will thank you!