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

undefined

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