Personal finance tracker

Financial Health Overview

• The available balance of $127,167 indicates strong liquidity and good short-term financial stability.

• However, total spending ($159,863) exceeds total income ($32,696) in the visual summary — signaling the need to reassess budget priorities or verify the data entry for major expense items.

• The system automatically identifies whether all bills are paid or overdue, helping maintain a clean credit and avoid penalties.

Income and Expense Management

• Income Sources: The primary revenue comes from Salary ($9,046) and Google AdSense ($8,260), followed by E-commerce ($7,775) and My Shop ($7,615). This diversification suggests multiple income streams but also highlights that passive income sources like AdSense are becoming significant contributors.
  Action: Focus on scaling high-performing digital income sources (like AdSense) to balance total earnings.

• Expense Patterns:

  • The largest expense categories are Housing ($43,200) and Transportation ($43,200), making up the bulk of total outflow.

  • Personal expenses ($14,400) are moderate but can be optimized further by identifying non-essential subcategories.
    Action: Review fixed housing and transport costs — for instance, negotiate rent, refinance vehicle loans, or switch to cheaper utilities.

• Late Payments: Several housing and personal subcategories (e.g., Internet, School Loans, Gas) were marked “Late,” highlighting payment scheduling issues.
  Action: Set automated reminders or allocate due dates into a bill management system to prevent overdue bills.

Asset and Wealth Insights

• The total asset portfolio exceeds $350K, distributed across Land ($135K), Warehouse ($120K), Bonds ($65.8K), Stock ($22.5K), and Gold ($15.7K).

• Real estate assets (land and warehouse) account for nearly 70% of total wealth, indicating stability but limited liquidity.
  Action: Consider diversifying with more liquid investments (e.g., stocks, ETFs) for quicker access to funds and portfolio balance.

• The Assets Trend Chart shows steady growth from $23,111 in January to a peak of $45,742 in September, followed by a slight year-end decline.
  Action: Investigate the cause of the dip — possibly increased year-end spending — and plan to maintain consistent contributions to assets in Q4.

Spending Efficiency and Goal Progress

• The Goal Summary section effectively compares short-term goals (e.g., saving $1,000) and long-term goals (e.g., retirement investment).
  Action: Reinforce progress tracking by assigning KPIs — e.g., monthly saving % toward each goal.

• Expense-to-Income ratio indicates high outflow during some months, calling for stricter budgeting or expense categorization.

Monthly and Behavioral Insights

• The monthly breakdown table reveals that December has the highest number of expense transactions, especially in housing and transportation — a seasonal spending pattern that should be anticipated in annual budgeting.
  Action: Pre-allocate additional funds or apply saving buffers before high-expense months (like holidays).

• Regular monitoring of “Main vs. Side Income” ensures visibility into how supplementary income offsets expenses, improving long-term savings discipline.

Usability and Automation Insights

• Automated visual feedback (“All bills paid, no overdue bills”) improves financial accountability and reduces manual tracking effort.

• The dashboard’s interactive monthly slicers empower quick insights into month-to-month cash flow and spending shifts — aiding proactive decision-making.

• The modern UI and navigation system simulate a finance app experience, encouraging consistent use and engagement.

Strategic Recommendations

1. Implement savings automation — set recurring monthly transfers to investment or emergency funds.

2. Reduce housing and transport costs by 10–15% to improve monthly net savings.

3. Diversify assets toward more liquid investments to increase flexibility.

4. Set quarterly reviews using this dashboard to track progress and adjust targets.

5. Integrate the tracker with Power BI or Tableau for predictive insights (e.g., forecasting next month’s cash flow).