How to upload a manual broker report CSV or XLSX

Manual broker report import is a powerful tool for maintaining a complete picture of your trading history. It is particularly useful when:

• Your broker is not yet supported for direct sync.
• You need to backfill historical trades from previous years.
• You want to cross-reference broker data against existing cycles.
• You need to fill specific data gaps after complex rolls or assignments.

---

Before you upload

For the most accurate results, ensure your broker export contains the following data points:

• Execution Details: Trade dates, symbols, and quantities.
• Option Data: Put/Call indicators, strike prices, and expiration dates.
• Financials: Executed price and any associated fees or commissions.
• Share Activity: Assignment or exercise records, especially if the "wheel" moved into shares.

---

Recommended workflow

1. Export the file from your broker

Download a standard CSV or XLSX report from your broker’s web portal.

2. Navigate to the Import Section

Open Wheelytics and click on Import in the top navigation menu.

3. Configure the Smart Trade History Import

Locate the Manual Upload panel.

• Account: Select the target account from the dropdown or leave it as "Use broker-detected account". Our AI will attempt to assign the trades to the correct account automatically.

4. Upload and Process

Drag and drop your file (up to 1MB) into the upload area. Click the Process File button.

Note: You do not need to manually map columns. Our AI-powered engine automatically detects the format and maps the fields for you.

5. Verify the Import

Once processing is complete, check the Latest Imports table at the bottom of the page. It will display the source, the number of trades added, and the timestamp of the import.

---

Troubleshooting & Data Accuracy

If your dashboard doesn't reflect the expected numbers, the issue is typically related to the source file's scope rather than the processing:

• Check Export Range: Ensure the date range you selected during the broker export covers both the opening and closing legs of your trades.
• Include Corporate Actions: Some brokers exclude assignments and exercises from standard "Trade Reports". Ensure your export includes these "Deliveries" or "Corporate Actions" to keep cycle data accurate.
• Duplicate Detection: If the "Added Trades" count is lower than the rows in your file, Wheelytics likely identified and skipped trades that were already imported to prevent data doubling.

---

Why manual import matters

While direct sync offers convenience, manual uploads provide the flexibility needed for deep audits and backfilling. Wheelytics takes these raw records and organizes them into clean wheel cycles, giving you a clear view of your premiums, adjusted cost basis, and net cash flow.