AU Taxes Prep (EFI)
AU Taxes Prep:
Goal: Need Buy/Sell Contracts + Comms for each Fund
Source: Excel for trades, CSV for Buy/Sell Contracts+Comms
Result: Excel for trades to include Buy/Sell Contracts+Comms
// Workflow //
Copy and Paste Excel Table for specific Fund
Copy and Paste CSV Table for specific Fund
AI will cross reference both tables then consolidate into one table
Copy and Paste Buy/Sell Contract IDs + Comms into Excel
Factcheck info then proceed to next Fund
// Data //
Reconcile EFI — Tradable Investment Acct
Source Data — Excel
Excel Buy/Sell Columns — Fund / Date / Price / Qty / Total
CSV Source Data — Buy/Sell Contract IDs + Comms
Filter by Fund
