Glossary
Cost Basis Tracking
Cost basis tracking records each investment tax lot and every adjustment needed to calculate taxable gain or loss.
Cost basis tracking is the process of recording what an asset cost for tax purposes, then applying adjustments until it is sold, exchanged, transferred, or otherwise disposed of. The result is an adjusted basis used to calculate capital gain or loss. It matters across stocks, exchange-traded funds (ETFs), mutual funds, options, and digital assets because a missing fee, reinvested dividend, split, return of capital, or transferred tax lot can change the reported gain.
The Tax-Lot Ledger Behind the Number
Reliable tracking cost basis starts with a tax-lot ledger, not a single average purchase price. Each acquisition needs a date, quantity, asset identifier, acquisition value, fees, account, source transaction ID, and remaining quantity. Later events append adjustments rather than overwriting history.
- Purchases and reinvestments create new lots.
- Splits change quantity and per-unit basis without changing total basis.
- Return-of-capital distributions generally reduce basis.
- Transfers move lots between custodians; they should not be mistaken for sales.
- Disposals consume lots under the selected cost basis tracking method.
A common production failure appears after an account transfer: positions arrive before their lot history. The portfolio value looks right, yet basis shows zero or uses the transfer-date value. Operators reconcile lot quantities and total adjusted basis against statements before trusting gain reports.
Choosing a Cost Basis Tracking Method
The selected method must match the broker election and the tax return. A spreadsheet for keeping track of cost basis may show an attractive specific-lot result, but it does not control the sale if the broker executed FIFO because no timely lot instruction was accepted.
Stocks, Funds, Options, and Reinvestments
Brokerage cost basis tracking is strongest for covered securities. US brokers generally began mandatory basis reporting for stock acquired from January 1, 2011, and for mutual fund or dividend reinvestment plan shares acquired from January 1, 2012; later rules covered additional specified securities. Older holdings may remain noncovered, so the taxpayer still needs statements, confirmations, corporate-action notices, and issuer records.
Trading Software Development Services for Demo Brokerages
Trading software development services for a polished demo brokerage with secure login, portfolio balances, P&L, stock holdings, and ESOP views in one web app.
Explore Trading Software Development Services for Demo Brokerages serviceMutual fund cost basis tracking must capture every reinvested distribution as a purchase. Options need separate treatment for expiration, closing trades, exercises, and assignments because premiums may affect proceeds or share basis. MLP units are harder: Schedule K-1 income, losses, contributions, and distributions adjust basis, so broker values may not be tax-ready.
Crypto Across Exchanges and Wallets
Crypto cost basis tracking follows US property-tax rules under IRS Notice 2014-21, but its data path is messier than a brokerage account. A crypto cost basis tracker must join exchange fills, wallet transfers, network fees, rewards, token migrations, and disposals. Missing acquisition history creates incomplete lots; recording a withdrawal and matching deposit as taxable events creates false gains.
CoinTracker, Koinly, and exchange tax modules can help, but imports need review. Symbol collisions, duplicate API and CSV records, unsupported chains, and incorrect wallet ownership often corrupt reports. Form 1099-DA expands digital-asset reporting, yet taxpayers still need complete records for assets acquired elsewhere.
Spreadsheets, Software, and Reconciliation
A cost basis tracking spreadsheet or cost basis Excel worksheet suits modest portfolios when formulas are locked and every row has a stable lot ID. Useful columns include transaction type, dates, quantity, gross value, fees, adjustment, lot consumed, proceeds, holding period, and source document. Keep raw imports separate from calculated outputs so corrections remain traceable.
Cost basis tracking software for stocks, crypto, and ETFs adds API imports, corporate-action handling, and tax-form exports. Quicken and GnuCash can maintain investment histories; specialist crypto tools handle wallet-level data; portfolio tools such as Snowball Analytics focus more on performance. No app removes the need to compare positions, cash flows, realized gains, and Forms 1099-B or 1099-DA.
Missing Records, Transfers, and Audit Readiness
For long-held assets, rebuild basis from trade confirmations, monthly statements, transfer-agent records, historical prices, and corporate-action archives. Do not substitute an old market price for purchase cost unless a tax rule specifically sets basis by fair market value, as may occur with inherited property. Keep the calculation schedule beside the evidence used to support it.
Use a three-way reconciliation: open-lot quantities must equal holdings, closed lots must equal disposals, and basis plus adjustments must explain gain or loss. Failures often point to missing reinvestments, duplicate imports, unprocessed splits, wash-sale adjustments, or transfers recorded as sales. The administration is tedious, but reconstructing years of activity during filing is worse.
Frequently Asked Questions
How to track cost basis for stocks held for years?
Reconstruct each lot from statements, confirmations, reinvestments, and corporate actions. Keep the records supporting every adjustment.
Does coinbase keep track of cost basis?
Yes, for supported Coinbase activity. External transfers may lack acquisition history, so users must complete missing basis.
When did brokerages start tracking cost basis?
US reporting generally began for stock acquired from January 1, 2011. Mutual funds and DRP shares followed from January 1, 2012.
Can vanguard track other acounts cost basis?
Vanguard can receive basis with transferred assets. It does not maintain authoritative lots for unrelated external accounts.
Do broker track higher cost basis from reinvestment?
Yes, each reinvestment normally creates a new lot and increases total basis. Missing lots can overstate gain.
Do brokerage accounts track cost basis?
Yes, brokers track lots and report covered-security basis. Taxpayers remain responsible for noncovered or incorrect records.
Do drps track cost basis?
Usually, each reinvested dividend becomes a recorded purchase lot. Older or transferred plan shares may need reconstruction.
Do i need to track cost basis for ira?
Not for each trade inside a traditional IRA. Track nondeductible contributions because they create IRA basis, usually reported on Form 8606.
Do i need to track cost basis for roth ira?
Not for internal capital gains. Track contributions, conversions, and distributions because Roth withdrawal ordering depends on them.
Do mutual funds track cost basis?
Yes, providers track covered shares and reinvestments. Available methods commonly include average cost and specific identification.
Does computershare track cost basis?
Yes, when Computershare has the required data for covered shares. Historical or transferred shares may need separate evidence.
Does quicken 2019 deluxe track cost basis?
Yes, from entered or downloaded investment transactions. Placeholders and incomplete downloads can make its calculation wrong.
How do i track cost basis rollover?
Carry forward original lots and acquisition dates for a nontaxable transfer. Do not reset basis to the transfer value.
How does m1 finance track cost basis?
M1 records tax lots and applies its tax-minimization sell sequence. Transferred or noncovered lots may require supporting records.
How to keep track of cost basis?
Maintain a lot ledger for purchases, fees, adjustments, transfers, and disposals. Reconcile it with statements and tax forms.
How to keep track of cost basis fifo?
Consume the oldest open lot first for each sale. Retain the broker confirmation showing that FIFO was applied.
How to keep track of cost basis lifo?
Consume the newest open lot first and preserve partial balances. Confirm the broker and applicable rules support LIFO.
How to keep track of cost basis mutual funds?
Record every purchase and reinvestment. Apply the elected average-cost or lot-identification method consistently.
How to keep track of cost basis of mlp?
Roll basis forward annually using Schedule K-1 items and distributions. Broker displays often omit partnership-level tax adjustments.
How to track btc cost basis?
Combine all Bitcoin trades, fees, and wallet transfers in one ledger. Link transfers so they are not treated as disposals.
How to track cost basis on options?
Record premiums, fees, closes, expirations, exercises, and assignments. Each event can affect gain, share basis, or proceeds differently.
How to track investco cost basis?
Use Invesco statements and Form 1099-B data, including reinvestments and fund exchanges. Older noncovered shares may need reconstruction.
How to track stock cost basis on excel?
Use one row per lot event with dates, quantity, fees, adjustments, and remaining shares. Keep raw data separate from formulas.
What apps track crypto trading for cost basis?
CoinTracker, Koinly, and some exchange tools track supported crypto lots. Chain coverage and duplicate handling vary, so reconcile imports.
Will vanguard track cost basis?
Yes, Vanguard tracks covered securities and may display some noncovered basis. Investors must correct missing historical data.