Financial Summary

Process transaction CSV files and generate comprehensive financial summaries with account grouping and internal transfer detection.

When to Use

Use this skill when the user:

Asks to analyze or summarize financial transactions from a CSV file
Wants to calculate totals for specific account groups
Needs to review spending or income across multiple accounts
Requests detailed transaction breakdowns by account group

CSV Format Requirements

The CSV file must be semicolon-separated (;) with these columns:

account: Account name
category: Transaction category
currency: ARS or USD
amount: Transaction amount (negative for expenses)
type: Income or Expenses
transfer: true or false
date: Transaction date

Account Groups

The script organizes accounts into these groups:

| Group | Accounts | |-------|----------| | Galicia | Galicia Mas - Caja de ahorro | | Mercado Pago | Mercado Pago | | Quiena | Quiena | | LLC | Relay Checking Account, Relay Saving Account | | HSBC | HSBC Current Account, HSBC Saving Account | | Crypto | Fiwind, Uglycash, Nexo |

Usage

Generate Financial Summary

To generate a complete financial summary:

python scripts/process_transactions.py <path-to-csv-file>

Example:

python scripts/process_transactions.py ~/Downloads/report_2025-11-30.csv

The script will output:

Summary totals for each account group
Transaction counts
Warnings for unknown accounts not mapped to groups
Values formatted without thousand separators using decimal points

View Detailed Transactions

To see all transactions for a specific account group:

python scripts/process_transactions.py <path-to-csv-file> --details=<GROUP>

Available groups: Galicia, Mercado Pago, Quiena, LLC, HSBC, Crypto

Example:

python scripts/process_transactions.py ~/Downloads/report.csv --details=LLC

This shows:

Date, account, currency, amount, type, and notes for each transaction
Transfer markers [T] for transfer transactions
Totals by currency (ARS and USD)

Key Features

Internal Transfer Detection

The script automatically identifies and excludes internal transfers between accounts in the same group (e.g., transfers between Relay Checking and Relay Saving). This prevents double-counting when calculating withdrawal totals.

Internal transfers are detected by matching:

Same date
Same currency
Opposite amounts (within 0.01 tolerance)
Both marked as transfers

Account Group Calculations

ARS Accounts:

Bank account (Galicia): Sum of all ARS transactions
Mercado Pago FCI: Sum of all ARS transactions

Quiena (USD):

Posición: Transfer income transactions
Incremento de valor: Financial investment category, non-transfers
Dividendos: Always 0
Retiros: Always 0

LLC/Relay (USD):

Ganancia: "Wage, invoices" category transactions
Gastos: Expense transactions that are not transfers
Retiros: Transfer expense transactions (excluding internal transfers)

HSBC (USD):

Ingresos: Transfer income transactions (excluding internal transfers)
Retiros: Transfer expense transactions (excluding internal transfers)
Gastos: Expense transactions that are not transfers

Crypto (USD):

Posición: Transfer income transactions
Incremento de valor: Financial investment category, non-transfers
Retiros: All expense transactions (transfers + non-transfers)

Workflow

Ask the user for the path to their transaction CSV file
Run the script to generate the summary
Review the output and check for unknown accounts
If unknown accounts are found, ask the user how they should be categorized
If the user needs detailed transaction breakdowns, run the script again with --details=<GROUP>
Present the results clearly to the user

Output Formatting

When presenting the financial summary to the user:

Use the raw numeric format from the script output (without thousand separators)
Use decimal points (.) for decimals, not commas
Example: 246325.62 NOT 246,325.62
Keep the same format as the script provides - do not add formatting