Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →anthropics/tres-report-analyzer
Analyze any TRES Finance report XLSX and produce an automatic findings summary.
4 of 25 test cases passed with the skill.
Tokens, turns and time describe resource use, not a dollar price.
Lift withheld: 7 comparable cases; this report requires 8.
A test case the skill fixed. Same model, same prompt, with and without the skill.
Analyze the TRES ERP Post-Sync report `sync_failures_jan.xlsx`. It shows 150 total sync attempts, $4.2M total volume, 12 failed syncs due to unmapped GL accounts, and top asset ETH ($2.5M). Structure your findings summary strictly according to standard priority.
| Checked | Without skill | With skill |
|---|---|---|
| The output presents failed sync red flags before overall volume metrics. | Missed | Passed |
| The output ends with an offer for follow-up drill down inquiries. | Missed | Passed |
The instructions your model reads when the skill loads.
You analyze TRES Finance report exports (XLSX files) and produce clear, actionable findings summaries. The goal is to save users hours of manual spreadsheet review by automatically surfacing the most important information: anomalies, failed checks, large movements, and key metrics.
When the user uploads an XLSX file, first identify which TRES report it is. Use the tab names as the primary signal:
| Tab signature | Report type |
|---|---|
Summary, Inventory Reconciliation, Running Token Reconciliation, Running Fiat Reconciliation, Historical Token Reconciliation, Historical Fiat Reconciliation, Roll Forward Reconciliation | Ledger Reconciliation |
Summary Per Asset, Summary Per Year, Summary per Tx Activity, raw_data (with Realized Gain column) | Realized Gains & Losses |
By Asset, By Wallet, By Platform, By Position, Cost Basis, raw_data (with Previous Amount column) | Balance Trends |
By Asset, By Wallet, By Platform, By Position, Cost Basis, raw_data (without Previous Amount) | Asset Balances |
By Asset, By Wallet, By Platform, By Position, Cost Basis, raw_data (with Historical Balance columns, Time Capsule enabled) | Historical Balance Format |
Asset Balances - PT, Cost Basis, raw_data | Asset Balances V2 |
Fiat Value Summary, Amount Summary By Application, Amount Summary, raw_data | Asset Balances - Archives |
Overview, raw_data (with Safety Check column) | Asset Roll Forward |
Summary, Inventory Reconciliation, raw_data (with Cost Basis columns, ~29 cols) | Cost Basis Roll Forward |
Chart of Accounts Summary, raw_data (with Configuration Status) | ERP Pre-Sync |
Single raw_data tab with COGS Lot columns | Cost Breakdown |
Single raw_data tab with Rollup Parent TX Hash | Rollup Breakdown |
Single raw_data tab with ~8 columns including Sync Status | ERP Post-Sync |
Single raw_data tab with Price Source column | Asset Fiat Values |
Single raw_data tab with Purchase Date, Remaining Quantity | Cost Basis Stack |
Single raw_data tab with Sub TX Index, Is Taxable | Cost Basis Inventory |
Single raw_data tab with wallet registry columns | Organization Wallets |
Single raw_data tab with basic tx columns | Transaction Ledger |
If you cannot identify the report type, tell the user and ask them to confirm which report it is.
Use the Python script at scripts/analyze_report.py to extract data from the XLSX file. Run it like this:
test cases passed with the skill
More skills from the same source and nearby in the registry, with their headline benchmark lift.