Borrowing it
Nothing to install: this file belongs to ronnycoding/my-personal-assistant. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/ronnycoding/my-personal-assistant/main/.claude/skills/finance-process/consolidate-statements/SKILL.mdgit clone --depth 1 https://github.com/ronnycoding/my-personal-assistantWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/ronnycoding/my-personal-assistant/consolidate-statements)<a href="https://agentmods.dev/skills/ronnycoding/my-personal-assistant/consolidate-statements"><img src="https://agentmods.dev/badge/skills/ronnycoding/my-personal-assistant/consolidate-statements.svg" alt="Measured on agentmods" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00000 | $0.00558 |
| Opus 5 | $0.00000 | $0.00279 |
| Sonnet 5 | $0.00000 | $0.00112 |
| Haiku 4.5 | $0.00000 | $0.00056 |
Grade A, and why
consolidate-statements scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 87 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Consolidate Statements Skill
Combine multiple CSV/Excel transaction files into a single consolidated file.
Skill Metadata
- Name: consolidate-statements
- Category: Financial Data Processing
- Complexity: Low-Medium
- Privacy: Local processing only, no external APIs
Capabilities
This skill consolidates transaction data from multiple files:
- Multi-file processing - Handles CSV and Excel files
- Duplicate detection - Removes duplicate transactions
- Column standardization - Maps different column names to standard format
- Date sorting - Orders transactions chronologically
- Balance reconciliation - Validates running balances
- Summary statistics - Provides consolidation metrics
Usage
/finance-process consolidate --input="~/Documents/Finance/checking-*.csv" --output="~/Documents/Finance/combined-2024.csv"
How It Works
- File Discovery: Finds all CSV/Excel files matching the input pattern
- Data Loading: Reads each file into pandas DataFrames
- Column Mapping: Standardizes column names across different formats
- Deduplication: Removes exact and fuzzy duplicates
- Sorting: Orders transactions by date
- Export: Saves consolidated data to output file
Script
The main script is scripts/consolidate_statements.py which:
- Accepts CSV/Excel file paths (glob patterns supported)
- Combines all transactions
- Removes duplicates
- Standardizes format
- Outputs to CSV
Dependencies
Required Python packages:
- pandas (data manipulation)
- openpyxl (Excel support)
- python-dateutil (date parsing)
Output Format
The skill produces CSV files with standardized columns:
date- Transaction date (YYYY-MM-DD)description- Transaction descriptionamount- Transaction amountbalance- Account balance (if available)category- Transaction categoryaccount- Source account (if multiple)source_file- Original filename
Duplicate Detection
What ships with it
1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 4d ago First seen · 87 lines · 0 tokens per session scan A 1f4afec5c49c
consolidate-statements is a skill published in the GitHub repository ronnycoding/my-personal-assistant (12 stars, last pushed 10mo ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 558 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-02.
Other skills, from other repositories
dcf-model
Build discounted cash flow valuation workbooks in Excel.
comps-analysis
Build comparable-company valuation workbooks in Excel.
lbo-model
Build leveraged buyout workbooks with IRR/MOIC in Excel.
excel-author
Build auditable financial workbooks headless via openpyxl.
lbo-model
This skill should be used when completing LBO (Leveraged Buyout) model templates in Excel for private equity transactions, deal materials, or investment committee presentations. The skill fills in formulas, validates calculations, and ensures professional formatting standards that adapt to any template structure.
3-statement-model
Build integrated IS/BS/CF financial workbooks in Excel.