summarize_operations
Aggregate mBank operations by category, account, or month to compute counts, inflows, outflows, and net per bucket. Build monthly expense reports and review VAT-relevant categories with grand totals.
Instructions
Aggregate operations by category, by account, or by month. Returns count, total inflow, total outflow, net per bucket, plus the grand totals over the filtered set. Ideal for building a monthly expense report or checking VAT-relevant categories.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | Substring match against account label (case-insensitive) | |
| date_to | No | YYYY-MM-DD, inclusive | |
| category | No | Substring match against mBank's assigned category (case-insensitive) | |
| contains | No | Substring match against operation description (case-insensitive) | |
| group_by | No | category | |
| date_from | No | YYYY-MM-DD, inclusive | |
| file_path | Yes | Absolute path to the mBank CSV file | |
| max_amount | No | Maximum amount (inclusive) | |
| min_amount | No | Minimum amount (inclusive). Signed — negative for expenses. |