Record-keeping systems, tax software and the trader CPA
Lesson 18 · about 9 min
Education, not tax advice: rules, rates and thresholds change every year, so confirm anything you plan to act on with a qualified tax professional.
Everything in this course reduces to two practical questions: what records do you need, and who turns them into a return. Both have answers that scale with complexity. A stock trader with one broker and no elections has a very different problem from a trader with three brokers, a futures account, a crypto wallet and a 475 election.
The record-keeping system
A working system has four layers.
Layer 1: source documents. Every 1099 (B, DIV, INT, MISC, NEC, DA), every year-end statement, every K-1, as PDFs in a folder per year and per account. Download them in February; brokers remove old documents and closed accounts disappear entirely.
Layer 2: trade-level data. A CSV export of every fill from every account, pulled monthly. This is what wash-sale software, crypto software and CPAs actually consume. Monthly, not yearly, because exports have row limits, platforms change formats, and an account you closed in March may not let you back in come January.
Layer 3: a trade journal with tax fields. Your trading log (the one from the risk management course) needs four extra columns: account, instrument type (stock, equity option, 1256, forex, crypto), and, for options, whether the position ended by exercise or assignment, plus a note for anything that adjusts basis. This is the layer that catches what the broker cannot see.
Layer 4: a decisions file. Dated statements of any elections (475(f), the 988 election out), the evaluation of trader status for each year with the counts from Module 3, the identification of any segregated investment account, and a copy of each filed return. If a return is ever examined, this file is the case.
Retention: three years from filing for the general statute, six if income was understated by more than 25%, and forever for anything establishing basis of a position still held. Store in two places; a cloud folder plus a local copy is enough.
Software: what each kind does
Consumer tax software (the well-known filing packages) imports 1099-B data from most brokers directly and fills Form 8949 and Schedule D. It handles a single-broker stock and options account well, including the wash sales that broker already computed. It does not compute wash sales across brokers, does not handle a 475 election's Form 3115 gracefully, and treats crypto as a spreadsheet import you supply.
Trade accounting software (products such as TradeLog and GainsKeeper, among others; no endorsement) imports trade-level exports from multiple brokers, applies the wash sale rule across all of them including options and substantially identical matches, handles 1256 separation and 475 mark-to-market, and produces a corrected Form 8949 that can differ from the brokers' 1099-Bs. The difference is reported as an adjustment. This category exists because the 1099-B is, by design, incomplete for multi-account traders.
Crypto tax software (Module 4) reconciles exchanges and wallets, prices events and generates 8949 data and income reports. It is a separate category because crypto data lives in places brokers do not.
The pattern: each tool covers one blind spot of the others. A multi-asset trader may need all three, plus a person to reconcile them.
Choosing between software and a CPA
The honest framing is cost against risk. Illustrative costs, which vary widely by region and complexity:
| Situation | Reasonable path | Rough annual cost |
|---|---|---|
| One broker, stocks and equity options, no elections, under a few hundred trades | Consumer software | Under $200 |
| Several brokers, heavy same-ticker activity, options assignments | Trade accounting software plus consumer software, or a CPA | $300 to $1,500 |
| Futures plus stocks, or spot forex | Software handles 6781 well; forex often needs a professional's position on 988 | $300 to $2,000 |
| Trader status claimed, Schedule C expenses | A CPA familiar with TTS case law; the deductions are the audit exposure | $1,000 to $3,000 |
| 475(f) election, entity, S-corp payroll | A trader-specialist CPA; the election year involves Form 3115 and a 481(a) adjustment | $2,000 to $6,000+ |
| Crypto with DeFi, many wallets, staking | Crypto software plus a CPA who has seen 8949 volume before | $500 to $4,000 |
A CPA is not a guarantee of correctness. Many excellent general practitioners have never seen a Form 6781, a 475 election or a wallet-by-wallet crypto report, and will either decline or learn on your bill. The questions that separate a trader specialist from a generalist:
- "How many clients do you have with a 475(f) election?" (A number, not a nod.)
- "How do you handle wash sales across multiple brokers?" (Software name, process.)
- "What is your position on the 988 election for retail spot forex?" (Any confident answer, with reasoning.)
- "Have you filed a return with a 1099-DA and reconciled it to wallet records?"
Worked comparison. A trader with $60,000 of net gains, two brokers and heavy same-ticker activity. Consumer software imports both 1099-Bs and reports $70,000 because $10,000 of cross-broker wash sales were never applied; at an illustrative 24% rate, $2,400 of tax that is really a deferral gets paid now. Trade accounting software at $300 finds and applies the cross-broker washes correctly, reporting $60,000. In this case the software paid for itself eight times over. In a year with no cross-broker washes it would have found nothing. The value of the tool is proportional to the mess.
The calendar
Exports and the tax set-aside monthly; 1099 collection and reconciliation in February; the trader-status count and any 475 decision before April 15; estimates on the four dates; a wash-sale and mark-to-market review in early December.
Key idea: Records live in four layers (source documents, trade-level exports, a journal with tax fields, a decisions file). Software covers specific blind spots; a trader-specialist CPA is worth the fee when elections, entities, multiple brokers or crypto volume are involved, and worth interviewing before hiring.
Try it: Score yourself on the four layers: for each, write "have it", "partial" or "missing". Then pick your row in the situation table. If your row says CPA and you use consumer software alone, or vice versa, note the mismatch and what it would cost to fix it.
Recap
- Four layers: 1099s and statements, monthly trade-level exports, a journal with tax fields, and a decisions file with elections and status analysis.
- Consumer software handles one broker well; trade accounting software handles cross-broker wash sales, 1256 and 475; crypto software handles wallets.
- The right level of help scales with brokers, instruments, elections and entities; costs are illustrative and vary.
- Interview a CPA with specific trader questions; generalists may not know the forms.
- Run a calendar: exports monthly, estimates quarterly, wash-sale review in early December, election decisions before April 15.