What is financial-summary?

This Claude skill provides a robust solution for automated financial data analysis by parsing personal transaction CSV exports. It streamlines the process of calculating account totals, detecting internal transfers to prevent double-counting, and generating organized financial summaries across various account groups including traditional banking, fintech, and crypto platforms. It is designed to transform raw transaction data into actionable financial insights with precision and speed.

When should I use financial-summary?

financial-summary is useful in the following scenarios: • Monthly Financial Review: Automatically consolidate and summarize spending and income across multiple bank accounts (e.g., HSBC, Galicia) and digital wallets (Mercado Pago). • Business Expense Tracking: Process LLC and Relay account exports to generate detailed breakdowns of wages, invoices, and operational expenses for better cash flow management. • Investment & Crypto Monitoring: Analyze performance and transaction history for investment platforms like Quiena and crypto wallets like Fiwind or Nexo, including value increments and withdrawals. • Internal Transfer Reconciliation: Use the automatic detection feature to identify and exclude transfers between linked accounts, ensuring net totals are accurate and not inflated by moving money between pockets.

name	financial-summary
description	Parse and analyze personal financial transaction CSV exports to calculate account totals and generate detailed breakdowns. Use when the user asks to analyze transaction data, generate financial summaries, calculate account balances, or review spending from CSV exports. Supports account grouping (Galicia, Mercado Pago, Quiena, LLC/Relay, HSBC, Crypto), automatic internal transfer detection, and detailed transaction listings.

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

financial-summary

When & Why to Use This Skill

Use Cases