Finance Categorizer

Finance Categorizer

This command analyzes bank statement CSV files, corrects missing or incorrect categorizations, and generates comprehensive spending reports with visual indicators for high spending areas.

Instructions

• IMPORTANT: Use inline astral uv python code (with any libraries you need) to calculate the totals and percentages. Use uv run python --with pandas --with -c "import pandas as pd; print(\"whatever you want here\")" to test your code.
  • Example: uv run --with rich python -c "from rich.console import Console; Console().print('Hello', style='bold red')"
• IMPORTANT: Think hard about your calculations ALWAYS double check your work as you go along.
• IMPORTANT: After you generate your report, review your numbers comprehensively with python. Also, make sure you write emojis and not unicode characters.
• In your finance_report.yaml file, do not use yaml anchors or aliases and do not use !!python tags. Write everything out as primitive types even if it means duplicating data.

Variables

DROPPED_FILE_PATH: [[FILE_PATH]] DROPPED_FILE_PATH_ARCHIVE: agentic_drop_zone/finance_zone/drop_zone_file_archive/ FINANCE_OUTPUT_DIR: agentic_drop_zone/finance_zone/finance_output// - This is the directory where all processed files and reports will be saved - The date_time is the current date and time in the format YYYY-MM-DD_HH-MM-SS

Output File Paths

CATEGORIZED_STATEMENT: FINANCE_OUTPUT_DIR//categorized_statement.csv - The cleaned and properly categorized bank statement FINANCE_REPORT: FINANCE_OUTPUT_DIR//finance_report.yaml - The comprehensive financial analysis report in YAML format SPENDING_PIE_CHART: FINANCE_OUTPUT_DIR//spending_by_category.png - Pie chart visualization of spending by category BALANCE_LINE_CHART: FINANCE_OUTPUT_DIR//balance_over_time.png - Line chart showing account balance progression over time

Spending Thresholds (per category monthly spending)

LOW_SPENDING_THRESHOLD: 500 - Categories under this amount get 💰 emoji MODERATE_SPENDING_THRESHOLD: 1000 - Categories between LOW and MODERATE get 🔥 emoji HIGH_SPENDING_THRESHOLD: 2000 - Categories between MODERATE and HIGH get 🔥🔥 emoji - Categories over HIGH get 🔥🔥🔥 emoji

Individual Transaction Alerts

LARGE_TRANSACTION: 500 - Single transactions over this get 🚨 flag UNUSUAL_TRANSACTION: 1000 - Single transactions over this get ⚠️ flag MAJOR_PURCHASE: 2500 - Single transactions over this get 🔴 flag

Budget Warning Percentages

HOUSING_WARNING_PCT: 30 - Alert if housing > this % of monthly income DINING_ENTERTAINMENT_WARNING_PCT: 20 - Alert if dining/entertainment > this % of total expenses SHOPPING_WARNING_PCT: 15 - Alert if shopping > this % of total expenses TRANSPORTATION_WARNING_PCT: 20 - Alert if transportation > this % of total expenses SUBSCRIPTION_WARNING_PCT: 10 - Alert if subscri