Investment Ledger Reconciliation

What it does

Reconstruct long positions from trades, splits and dividends, with FIFO gains and cash reconciliation.

• Fees included in basis and proceeds
• FIFO matching of sales
• Stock splits update quantities and unit costs
• Reject overselling and duplicate transactions

Try saying

Use my supplied records to reconstruct long positions from trades, splits and dividends, with FIFO gains and cash reconciliation.

Export a reproducible report with the assumptions, key metrics and detailed CSV. Ask me for missing facts first.

Calculation scope

Supply transactions in chronological and actual within-day order. buy/sell use quantity/price/fee; split uses new shares divided by old shares; dividend uses an explicitly consistent amount convention and any additional fee. Long-only FIFO is bookkeeping, not a tax calculation.

Deliverables and runtime

Includes executable Python 3.10+ standard-library calculations, independent numerical tests, fictional examples and an input reference. Supported flat collections accept CSV. No extra market-data key is needed. Files stay in the active assistant workspace, with input and output hashes. Analysis only; no account access or automatic trading.

References

• Investor.gov — How Fees and Expenses Affect Your Investment Portfolio ↗