Monthly Budget Spreadsheet for January showing income, bills, variable expenses, savings, and debt with visual charts.

The image shows a Monthly Budget Spreadsheet for January (JAN), with sections for income, bills, variable expenses, savings, and debt. The goal of this spreadsheet is to track budgeted vs. actual spending and savings, helping to manage finances effectively.

Let’s analyze the data and solve the problem step by step.

---

🔍 1. Income

| Source | Budget | Actual |
|--------------|--------|--------|
| Job | 2000 | 2200 |
| Side Hustle | 200 | 400 |
| Total | 2200 | 2600 |

✔ Total Income:
- Budgeted: $2,200
- Actual: $2,600
➡️ Surplus: $2,600 - $2,200 = $400 extra income

---

💵 2. Bills (Fixed Expenses)

| Item | Budget | Actual |
|-------------------|--------|--------|
| Rent | 900 | 900 |
| Phone | 60 | 60 |
| Insurance | 25 | 25 |
| Internet | 65 | 65 |
| Car Payment | 200 | 200 |
| Credit Card Payment | 45 | 45 |
| Total | 1295 | 1295 |

✔ Bills Total:
- Budgeted & Actual: $1,295
➡️ No overspending here — perfect adherence!

---

🛒 3. Variable Expenses

| Item | Budget | Actual |
|------------------|--------|--------|
| Groceries | 300 | 325 |
| Dining Out | 100 | 90 |
| Fuel | 150 | 80 |
| Shopping | 25 | 15 |
| Utilities | 50 | 75 |
| Gifts | 0 | 0 |
| Home | 0 | 25 |
| Medical | 0 | 30 |
| Miscellaneous | 0 | 0 |
| Total | 625 | 640 |

➡️ Variable Total:
- Budgeted: $625
- Actual: $640
➡️ Overspent by: $640 - $625 = $15

> Note: While groceries and utilities were over budget, dining out and fuel were under budget.

---

💰 4. Savings

| Fund | Budget | Actual |
|--------------------|--------|--------|
| Emergency Fund | 50 | 100 |
| Sinking Fund 1 | 25 | 50 |
| Sinking Fund 2 | 40 | 100 |
| Total | 115 | 250 |

✔ Savings Total:
- Budgeted: $115
- Actual: $250
➡️ Extra saved: $250 - $115 = $135

> This is great! More than double the savings target was met.

---

💳 5. Debt

| Item | Budget | Actual |
|----------------|--------|--------|
| Credit Card | 100 | 100 |
| Total | 100 | 100 |

✔ Debt Paid:
- Fully paid as per budget → No issue

---

📊 Summary Calculations

#### ✔ Total Budgeted Spending:
- Bills: $1,295
- Variable: $625
- Savings: $115
- Debt: $100
→ Total Budgeted:
= 1295 + 625 + 115 + 100 = $2,135

#### ✔ Total Actual Spending:
- Bills: $1,295
- Variable: $640
- Savings: $250
- Debt: $100
→ Total Actual:
= 1295 + 640 + 250 + 100 = $2,285

#### ✔ Income vs. Spending
- Income: $2,600
- Spending: $2,285
→ Left to Spend / Surplus: $2,600 - $2,285 = $315

This matches the value shown in the top-right corner:
> "Left to spend: 315"

---

📈 Charts Interpretation

1. Bar Chart (Available to Budget vs. Available to Spend)
- "Available to budget": $2,200 (budgeted income)
- "Available to spend": $2,600 (actual income)
→ Shows extra income available.

2. Pie Chart (Budget Breakdown)
- Bills: ~61%
- Variable: ~29%
- Savings: ~5%
- Debt: ~5%
→ Most money goes to fixed bills, which is typical.

3. Budget vs Actual Bar Chart
- All categories show actual spending ≤ or equal to budget, except variable expenses, which slightly exceeded.
- But savings and debt were fully met or exceeded.

---

✔ Final Answer & Recommendations

#### ✔ Problem Solved?
Yes. The spreadsheet has been analyzed completely.

#### 🎯 Key Insights
- Total surplus: $315 (income > spending)
- Only one category overspent: Variable expenses ($15)
- Savings significantly exceeded: $135 more than planned
- All debts paid on time
- Bills perfectly managed

#### 💡 Recommendations:
1. Keep saving momentum — continue contributing to emergency and sinking funds.
2. Review variable spending — while only $15 over, consider tracking trends monthly.
3. Use surplus wisely:
- Allocate extra $315 toward future savings or debt payoff.
- Or set aside for unexpected costs.

---

✔ Conclusion

This is a very healthy budget for January. The person earned more than expected, stayed within most limits, saved more than planned, and paid all debts. The "Left to spend" amount of $315 reflects financial flexibility for future months.

Would you like help creating formulas for automatic calculations or setting up alerts for overspending?