Works with the AI tools you already use
Claude Code
Cursor
Codex CLI
Muse
Dots+22 moreClaude CodeCursorCodex CLIMuseDots
OpenClaw
Manus
Grok
Grok Bot+18 agentstrading pnl reconciliation
Reconstruct positions and cash from fills to identify discrepancies against broker statements.
$15
trading pnl reconciliation
Example session with this skill installed
Reconcile the account 'Alpha-01' for 2023-10-27. Compare the execution logs in fills.json against the snapshot in broker_statement.json. Focus on the BTC/USDT pair.
- Read your context and instructions
- Compiled the trading pnl reconciliation
- Generated the document
The reconciliation for account Alpha-01 is complete. I have processed 42 fills and 3 cash adjustments. There is a minor discrepancy in the final BTC position equivalent to 0.000012 BTC, likely due to a rounding mismatch on a taker fee.
Reconciliation Report: Alpha-01 (2023-10-27)
| Metric | Opening Snapshot | Reconstructed | Closing Snapshot | Variance |
|---|---|---|---|---|
| Cash (USDT) | 1,250,400.00 | 1,185,210.50 | 1,185,210.50 | 0.00 |
| Asset (BTC) | 12.50000000 | 14.12000000 | 14.12000000 | 0.00 |
| Asset (ETH) | 50.00000000 | 48.00000000 | 47.99998800 | -0.00001200 |
Discrepancy Analysis
| ID | Type | Asset | Amount | Resolution |
|---|---|---|---|---|
| DISP-001 | Fee Mismatch | ETH | -0.000012 | Unresolved. Detected on Fill #8922. Likely precision difference. |
| ADJ-001 | Deposit | USDT | +50,000.00 | Confirmed. Match found in internal treasury logs. |
Data References
- Source Fills:
fills.json(v2.1) - Statement:
broker_statement.json(Ref: 99821-X) - Interval: 2023-10-27 00:00:00 to 23:59:59 UTC
Next steps
- Review Fill #8922 in the execution log to confirm the fee calculation method.
- Export the reconciled ledger to the strategy performance folder.
- Update the precision settings in the config file to match the broker's 8-decimal output.
trading-pnl-reconciliation.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
The problem
Manual reconciliation of trading activity is error-prone and slow. Discrepancies between execution logs and broker snapshots often lead to inaccurate P&L reporting and hidden accounting errors.
What it does
- Reconstructs signed positions and cash balances from raw fill data and manual adjustments.
- Identifies missing or duplicate fills by comparing reconstructed state against closing snapshots.
- Distinguishes between settlement cash and trade-date cash to ensure timing accuracy.
- Processes deposits, withdrawals, and dividends while preventing double-counted fees.
- Generates a structured ledger and a dedicated discrepancy table for audit trails.
Frameworks & tools
Python 3 for analysis scripts, JSON for data contracts, and standardized ledger modeling for spot and linear instruments.
Why this beats prompting it yourself
General-purpose LLMs struggle with the strict mathematical consistency required for position reconstruction. This skill enforces a specific accounting workflow that separates trade-date logic from settlement events, ensuring you don't miss small but compounding fee errors or timing mismatches.
Use cases
- Verifying daily trading activity against prime brokerage or exchange statements.
- Auditing strategy performance by isolating execution fills from external cash movements.
- Pre-processing raw trade data for tax-lot accounting or performance reporting systems.
- Investigating broken trade sequences and unexplained cash variances.
Known limitations
Does not handle tax reporting, FX conversions, or corporate actions like splits. Limited to spot and fully paid linear instruments; no native derivative margin accounting.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 13 days ago
- Passed all security checks, Safe to install
Needs access to
Alpaca