For your accountant, export the records that explain taxable sales, investment income, cost basis, transfers, and exceptions. Do not send every dashboard, chart, or daily balance by default. Send a pre-1099 review copy only if your accountant wants an early look, then send the final package after the broker tax forms arrive and you have reconciled the numbers.
Prepared by the Deep Digital Ventures Editorial Team, which builds investor portfolio-tracking tools and writes about portfolio organization, brokerage records, and tax-document workflows. This is educational, not tax advice; have a qualified tax professional apply it to your return. Expert review note: no CPA or enrolled agent reviewer was provided for this update.
An accountant usually does not need screenshots of portfolio charts, daily balances, or every dashboard page. They need a clean export that explains realized sales, dividend and interest income, cost basis, transfers, account type, and anything that may not match the broker’s official year-end tax package. Use Portfolio Tracker as the working place to keep the year organized, then reconcile the export against official broker documents before your accountant relies on it.
Quick export checklist
Send these 5 items: taxable-account realized sales, dividend and interest summaries, year-end holdings by account, transfers and rollovers, and a short exceptions memo for missing basis, corrected forms, corporate actions, wash sales, and manual tracker edits.
Do not send these by default: every dashboard screenshot, every daily valuation, every watchlist, full retirement-account trade history, or performance charts that do not explain a tax form. Keep those available, but start with the files that help the accountant tie your tracker to the broker package.
Export realized activity first
Start with taxable-account sales because those are the trades most likely to connect your tracker to the broker’s sale and basis reporting, and then to capital-gain reporting on the return.[1][2] Your realized-gain CSV should include account name, institution, account type, security name, ticker or CUSIP if available, quantity sold, acquisition date, sale date, proceeds, cost or other basis, fees, short-term or long-term status, wash-sale amount if shown, adjustment code if shown, and a notes column.
Do not treat the tracker as the final tax document when it disagrees with the broker’s form. If the broker reported basis to the IRS, the accountant needs to see the broker number and any correction or adjustment, not just one unexplained tracker total.[2] The export is most useful when it shows the tracker number, the official 1099-B number, and a short reason for any difference.
- Realized gain and loss report: export every taxable sale or exchange, including proceeds, cost basis, holding period, broker wash-sale amount, and adjustment code when one appears on the broker form.
- Dividend and interest summaries: export ordinary dividends, qualified dividends, capital gain distributions, exempt-interest dividends, foreign tax paid, and taxable interest by account and payer so totals can be compared with the broker’s 1099-DIV and 1099-INT forms.[3][4]
- End-of-year holdings by account: export the December 31 position list with ticker, security name, quantity, account type, and whether each position is taxable, IRA, Roth, rollover, education, or business-related.
- Transfers, contributions, withdrawals, and rollovers: export dates, amounts, sending account, receiving account, and memo fields so movement between institutions is not mistaken for a sale, distribution, or missing cash.
- Cost-basis exceptions: flag missing basis, noncovered lots, inherited assets, gifted shares, employee stock, mergers, spin-offs, and fractional-share cash-in-lieu payments. Basis records matter because basis is used to figure gain or loss, and investors need records of items that affect it.[5]
- Unusual events memo: write a short note for corrected forms, broker transfers, corporate actions, wash-sale adjustments, and manual edits made inside the tracker.
Two review checks catch many problems before the file reaches the accountant. First, compare income totals by payer and account against the broker forms instead of relying on a combined tracker income number. Second, review wash-sale fields because a tracker’s simple gain/loss view can differ from the amount currently deductible for tax reporting.[6]
A third timing check is practical: if your tracker export is ready in January, mark it “pre-1099 review copy.” After the broker forms arrive, send a “final reconciled package” with the official PDFs, the CSV exports, and the mismatch memo together. FINRA says investors should receive Form 1099-B from their brokerage firm by February 15 for the previous tax year and should compare the broker’s basis with their own records promptly.[7]
Use a reconciliation workflow before sending the file
Use this source-based mini-workflow before you email a spreadsheet or upload it to a client portal. Step 1: export realized sales by account from the tracker. Step 2: download each broker’s consolidated tax package. Step 3: match each sale by account, security, sale date, proceeds, and basis. Step 4: put each mismatch into one of three labels: “broker form controls,” “needs accountant review,” or “needs broker correction.” Step 5: attach purchase confirmations or transfer statements for any lot where basis is missing or not reported to the IRS. Step 6: send the accountant the export, the official forms, and the mismatch memo together.
| Issue | What to export | Why it matters |
|---|---|---|
| Reinvested dividends | Dividend detail, reinvestment purchases, and adjusted basis by lot. | Reinvested income can increase basis, so the original purchase price alone may overstate taxable gain. |
| Wash sales | The sale, replacement purchase, broker wash-sale amount, and any adjustment code. | The tracker’s simple gain/loss view may not match the tax-reportable loss for the year. |
| Transferred or older lots | Transfer statements, purchase history, and a note that basis is missing or noncovered. | The broker may not have complete basis, but the accountant still needs support for the number used. |
The point of the examples is not to copy sample numbers into your return. It is to show the format your accountant can use: original activity, official-source adjustment, and a short note explaining why the final export differs from a simple profit-and-loss view.
Separate accounts clearly
Keep taxable brokerage accounts, traditional IRAs, Roth IRAs, inherited IRAs, 401(k) rollovers, education accounts, and business-related accounts in separate tabs or files. Taxable accounts need the most detailed sales, basis, dividend, and interest exports. Retirement accounts usually need clearer contribution, distribution, rollover, and year-end balance context, while internal trades inside the retirement account are usually secondary unless the accountant asks for them.
Use account labels that would still make sense if the file were printed: “Fidelity taxable ending 1234,” “Schwab traditional IRA ending 9876,” “Vanguard Roth IRA ending 4567,” or similar plain labels. Account type matters because the same security can have different reporting treatment depending on where it is held.
For dividend investors, account separation is also how you avoid double-counting income. A dividend in a taxable brokerage account, a bond-fund distribution inside an IRA, and a dividend reinvestment inside a Roth IRA may all appear in a portfolio tracker, but they do not belong in one combined “income for taxes” total without account context.
Include questions and assumptions
Make uncertainty visible. If basis is missing, write “basis missing on broker form,” not “basis zero,” unless your accountant tells you that is the right treatment. If a transfer occurred, include the sending broker, receiving broker, date, and whether a transfer statement or purchase history came across. FINRA notes that there may be situations where a firm is not required or able to provide cost basis, including some older or transferred securities.[7]
Flag corrected forms separately. If a broker issues a corrected Form 1099-B or 1099-DIV after you already sent the first package, do not silently replace one spreadsheet with another. Send the corrected form, the date received, and a two-line note that says which totals changed.
A clean final package has four parts: the tracker export, the official tax-form PDFs, a mismatch memo, and supporting records for missing or unusual basis. The decision rule is simple: do not send a tracker export as “final” until every realized sale is either matched to the broker form, labeled as a known difference, or marked as a question for the accountant.
One final tax note: this checklist helps organize records; it does not decide the tax treatment. Ask your CPA, enrolled agent, or other qualified tax professional how to handle mismatches, missing basis, corrected forms, wash sales, inherited assets, gifts, and employee stock.
FAQ
Should I send CSV, PDF, or both? Send both when possible. The CSV lets the accountant sort, filter, and reconcile details; the PDF preserves the official broker form and page labels. Name files by year, institution, account type, and whether they are pre-1099 or final.
Should I export IRA trades? Usually not as the first file. For IRAs and rollovers, start with contributions, distributions, rollovers, transfers, account labels, and year-end balances. Keep trade history available if the accountant asks, especially for inherited accounts or unusual transactions.
When is a pre-1099 export useful? A January export can help find missing lots, transfers, manual edits, and obvious tracker errors before broker forms arrive. Label it clearly as a review copy so it is not mistaken for the final tax package.
What if a broker later sends a corrected tax form? Send the corrected form to the accountant with the original form date, corrected form date, and the tracker totals that changed. Do not assume the original export is still final after a corrected 1099 arrives.
Sources
- IRS, About Form 1099-B – Broker reporting for securities sales and related proceeds.
- IRS, Instructions for Form 8949 – Reporting sales, basis, and adjustments when reconciling capital transactions.
- IRS, About Form 1099-DIV – Dividends and distributions reported by payers.
- IRS, About Form 1099-INT – Taxable interest income reported by payers.
- IRS Publication 551, Basis of Assets – Basis records used to figure gain or loss.
- IRS Publication 550, Investment Income and Expenses – Investment income, capital gains, and wash-sale discussion.
- FINRA, Cost Basis Basics – Broker basis records, investor recordkeeping, and Form 1099-B timing.