Finance Manager

1---2name: finance-manager3description: Comprehensive personal finance management system for analyzing transaction data, generating insights, creating visualizations, and providing actionable financial recommendations. Use when users need to analyze spending patterns, track budgets, visualize financial data, extract transactions from PDFs, calculate savings rates, identify spending trends, generate financial reports, or receive personalized budget recommendations. Triggers include requests like "analyze my finances", "track my spending", "create a financial report", "extract transactions from PDF", "visualize my budget", "where is my money going", "financial insights", "spending breakdown", or any finance-related analysis tasks.4---5 6# Finance Manager7 8A comprehensive toolkit for personal finance management that processes transaction data, performs sophisticated financial analysis, generates actionable insights, and creates beautiful visual reports.9 10## Core Capabilities11 121. **Transaction Data Processing**: Extract financial data from PDFs, CSVs, or JSON files132. **Financial Analysis**: Calculate key metrics, identify spending patterns, and track savings143. **Visualization**: Generate interactive HTML reports with charts and graphs154. **Budget Recommendations**: Provide personalized, actionable advice based on spending patterns165. **Trend Analysis**: Identify spending patterns, anomalies, and opportunities for optimization17 18## Workflow19 20### 1. Data Extraction and Preparation21 22**For PDF files:**23```bash24python scripts/extract_pdf_data.py <input.pdf> <output.csv>25```26 27**For CSV/JSON files:**28- Ensure data has columns: `Date`, `Description`, `Income` (category), `Type`, `Amount`29- Date format: YYYY-MM-DD or parseable date string30- Amount: Positive for income, negative for expenses31 32### 2. Financial Analysis33 34Run comprehensive analysis on transaction data:35```bash36python scripts/analyze_finances.py <transactions.csv> > analysis_output.json37```38 39**Output includes:**40- Summary statistics (total income, expenses, net savings, savings rate)41- Spending trends (daily averages, top expenses, category percentages)42- Budget recommendations (personalized based on spending patterns)43- Visualization data (prepared for charting)44 45### 3. Report Generation46 47Create interactive HTML report with visualizations:48```bash49python scripts/generate_report.py <analysis_output.json> <report.html>50```51 52**Report features:**53- Summary dashboard with key metrics54- Interactive pie chart showing spending by category55- Bar chart comparing income vs expenses over time56- Color-coded indicators (green for positive, red for negative)57- Personalized recommendations section58- Responsive design for all devices59 60### 4. Complete Workflow Example61 62```bash63# Extract data from PDF64python scripts/extract_pdf_data.py finance_data.pdf transactions.csv65 66# Analyze the data67python scripts/analyze_finances.py transactions.csv > analysis.json68 69# Generate visual report70python scripts/generate_report.py analysis.json financial_report.html71```72 73## Key Metrics and Benchmarks74 75### Savings Rate76```77Savings Rate = (Total Income - Total Expenses) / Total Income × 10078```79 80**Benchmarks:**81- Below 10%: Needs improvement82- 10-20%: Good83- 20-30%: Excellent  84- Above 30%: Outstanding85 86### Category Guidelines (% of income)87- Housing: 25-30%88- Transportation: 10-15%89- Food: 10-15%90- Utilities: 5-10%91- Savings: Minimum 20%92 93For detailed frameworks and methodologies, see `references/financial_frameworks.md`.94 95## Analysis Features96 97### Summary Statistics98- Total income and expenses for the period99- Net savings (can be positive or negative)100- Savings rate percentage101- Transaction count102- Date range covered103 104### Spending Trends105- Daily average spending106- Top 5 largest expenses with details107- Category percentage breakdown108- Spending patterns over time109 110### Budget Recommendations111 112The system generates personalized recommendations based on:113- Savings rate thresholds114- Category spending percentages115- Income diversification116- Budget guideline comparisons117 118**Example recommendations:**119- "⚠️ Your savings rate is below 10%. Consider reducing discretionary spending."120- "🍽️ Food spending is 18% of expenses. Consider meal planning to reduce costs."121- "✅ Excellent savings rate! You're on track for strong financial health."122 123## Visualization Components124 125### Category Spending Chart (Doughnut)126Shows proportional breakdown of expenses by category with color coding.127 128### Income vs Expenses Chart (Bar)129Displays monthly comparison of income and expenses to identify cash flow trends.130 131### Interactive Features132- Hover tooltips showing exact values133- Responsive design adapting to screen size134- Color-coded positive (green) and negative (red) indicators135 136## Tips for Best Results137 138### Data Quality139- Ensure all transactions are properly categorized140- Use consistent category names141- Include complete date information142- Verify amounts are correctly signed (+ for income, - for expenses)143 144### Analysis Frequency145- Run monthly analysis for trend tracking146- Generate reports at month-end for review147- Compare month-over-month to identify changes148 149### Action on Recommendations150- Prioritize recommendations by potential impact151- Set specific, measurable goals based on insights152- Track progress by re-running analysis regularly153 154## Dependencies155 156All scripts require Python 3.7+ with standard libraries. Additional requirements:157 158**For PDF extraction:**159```bash160pip install pdfplumber --break-system-packages161```162 163**For data analysis:**164```bash165pip install pandas --break-system-packages166```167 168All visualization dependencies are loaded from CDN in the HTML output (Chart.js).169 170## File Organization171 172```173finance-manager/174├── scripts/175│   ├── extract_pdf_data.py     # PDF → CSV conversion176│   ├── analyze_finances.py     # Financial analysis engine177│   └── generate_report.py      # HTML report generator178└── references/179    └── financial_frameworks.md # Detailed analysis methodologies180```181 182## Customization183 184### Adding Custom Categories185Edit the category definitions in `analyze_finances.py` to match your tracking system.186 187### Adjusting Thresholds188Modify recommendation thresholds in the `generate_budget_recommendations()` function to match personal goals.189 190### Styling Reports191Customize the HTML_TEMPLATE in `generate_report.py` to adjust colors, fonts, or layout.192 193## Common Use Cases194 195**Monthly Review:**196"Analyze my October spending and create a report"197 198**Budget Optimization:**  199"Where am I spending too much money?"200 201**Trend Analysis:**202"How does my spending this month compare to last month?"203 204**Goal Setting:**205"What's my savings rate and how can I improve it?"206 207**Category Insights:**208"Break down my food spending by transaction"209 210**PDF Processing:**211"Extract all transactions from my bank statement PDF"212 213## Best Practices214 2151. **Consistent Categorization**: Use the same category names across all transactions2162. **Regular Analysis**: Run monthly to spot trends early2173. **Act on Insights**: Use recommendations to make specific spending changes2184. **Track Progress**: Compare reports month-over-month2195. **Verify Data**: Always check extracted PDF data for accuracy before analysis220 221## Reference Materials222 223For comprehensive financial frameworks, budgeting guidelines, and analysis methodologies, read:224```bash225view references/financial_frameworks.md226```227 228This includes:229- The 50/30/20 budget rule230- Category spending benchmarks  231- Financial health indicators232- Analysis workflow details233- Visualization best practices234- Recommendation logic