Converting Brokerage Statements

DocuClipper extracts structured holdings data from monthly and quarterly US brokerage statements. The output is different from a bank statement: instead of a list of transactions, you get a position-by-position breakdown of what the account held at period close, plus the account summary totals (beginning value, ending value, dividends, deposits, withdrawals). From a broker's consolidated 1099 it extracts the Form 1099-B sales lot by lot and the box amounts of Forms 1099-DIV, 1099-INT and 1099-MISC.

What you get

For each account in the statement, DocuClipper extracts:

Per holding (one row per security):

• Symbol and CUSIP
• Description
• Quantity
• Price
• Market value
• Cost basis (when reported)
• Unrealized gain or loss (when reported)
• Estimated annual income and yield (when reported)
• Section (Cash, Money Market, Bonds, Equities, Mutual Funds, Options, Other)

Per account summary:

• Account number, broker, account type
• Statement period (start and end dates)
• Beginning value, ending value, change for the period
• Deposits and withdrawals
• Dividends and interest
• Reconciliation status (sum of position market values vs ending value, ±$1 tolerance)

From a consolidated 1099:

• Every Form 1099-B sale: date acquired, date sold, proceeds, cost basis, gain or loss, wash sale flag
• Every box of Forms 1099-DIV, 1099-INT and 1099-MISC (and 1099-OID where the broker prints it), as printed on the 1099's summary page

Step 1: Upload

1. From the project workspace, click Add Documents in the left sidebar and pick Brokerage Statements (PDF).
2. Drag and drop your PDF, or click the dropzone to select files.
3. Check the page count. Once the file finishes uploading, a preview of the PDF appears on the right and the page tells you how many pages the job will convert (for example This job will convert 18 pages).
4. Click Convert.

A broker's consolidated 1099 can also be uploaded on the Forms (W-2, 1099, Paystubs, Tax Forms) page or the bank statement page. DocuClipper recognizes a supported 1099 package there and reads it exactly as it would here, so its lots and income boxes land on the Brokerage tab; the Forms or bank tab shows a notice with a View brokerage results button. A PDF that combines the 1099 with other tax forms (a 1099-R, a W-2, an SSA-1099, scanned pages) stays with the Forms extractor, so upload the broker's 1099 as its own file. See Consolidated 1099s from a broker.

You can upload multiple periods from the same account in a single job. Each statement is processed independently, and you pick which one to review with the Document picker on the Brokerage tab (see Switching between statements).

Uploaded on the bank statements page?

If you add a brokerage statement on the Bank/CC Statements (PDF) page, DocuClipper checks it once the upload finishes. When it recognizes a statement from one of the supported brokers and the holdings tie to the statement's printed totals, a notice offers to convert it as a brokerage statement. Pick the output you need:

• Convert as a brokerage statement gives you holdings, cost basis and investment activity, as described on this page. The page switches to Convert brokerage statements and keeps your files; click Convert. Convert as a bank statement instead switches back.
• Convert without switching gives you the account's cash transactions, ready for Excel, QuickBooks or Xero.

If only some of the files are brokerage statements, the notice lists them. A conversion runs as one type, so remove those files and add them under Add Documents > Brokerage Statements (PDF) to get their holdings.

For best results:

• Download the statement directly from your broker's online portal as a PDF. Print-to-PDF and screenshot captures lose the text layer DocuClipper needs.
• Use full monthly or quarterly account statements. Trade confirmations are not supported. For 1099 tax documents, the Schwab Form 1099 Composite, the Fidelity Tax Reporting Statement, the Merrill Tax Reporting Statement, the Morgan Stanley and E*TRADE 1099 Consolidated Tax Statement, consolidated 1099s from Altruist, Ameriprise, LPL Financial, Raymond James, Robinhood, UBS and Vanguard, the Betterment Consolidated Tax Statement, the Apex Clearing Form 1099 Composite (Webull, Stash and other apps that clear through Apex), Coinbase's Form 1099-DA, the Pershing Tax Information Statement (issued for the advisers and brokers that clear through Pershing), the Edward Jones Consolidated 1099 Statement and the J.P. Morgan Securities Consolidated Forms 1099 are supported, including 1099s that report only dividends and interest (see Consolidated 1099s and Per-broker notes below).

Step 2: Review your holdings

When extraction completes, the project workspace lands you on the Brokerage tab with the Holdings sub-tab open. The PDF appears on the left and the extracted data on the right. Use Hide PDF / Show PDF to give the data more room.

Each account card shows the broker name (for example Charles Schwab or Raymond James), account number, statement period, and a Reconciled or Not reconciled badge. Below the header, positions are grouped by section: Cash, Money Market, Bonds, Equities, Mutual Funds, Options, Other. Each row is one security: the Security column shows the symbol with the description under it, followed by quantity, price, market value, cost basis, unrealized gain or loss, yield, and estimated annual income when the statement reports them.

The tables always fit the space they have. When there is room (for example after Hide PDF, or on a wide screen) you get one table row per security. When the pane is narrower, such as beside the PDF on a laptop or on a phone, each security becomes a compact block: the security and its market value on top, and the other values labelled underneath. Nothing is cut off and there is no sideways scrolling. The Activity and Realized Gains sub-tabs work the same way.

The reconciliation badge tells you whether the sum of position market values matches the printed ending value within $1. A green Reconciled badge means the extraction is internally consistent. A yellow Not reconciled badge means there's a gap worth a quick visual check before you trust the totals.

Switching between statements

When a project holds more than one brokerage statement, a Document picker sits above the sub-tabs, showing how many statements are available. Pick a statement and the Summary, Holdings, Activity, and Realized Gains sub-tabs, along with the PDF on the left, all switch to it. Your choice stays in place as you move between sub-tabs. The first statement in the project opens by default.

Summary

The Summary sub-tab shows the period-level totals: beginning value, ending value, change for the period, dividends and interest, deposits, withdrawals, and account type (taxable, IRA, advisor-managed, etc.).

For a consolidated 1099, the Summary sub-tab shows the tax year and the 1099's income forms instead: one table each for Form 1099-DIV, Form 1099-INT and Form 1099-MISC, listing every box that carries an amount with its IRS box number and name. A form whose boxes are all zero says so in one line. See Consolidated 1099s.

Activity

The Activity sub-tab lists every transaction the statement reports - buys, sells, dividends, withdrawals, journal entries, and other - with the date, action, security, quantity, price, and amount. Use the action filter to narrow the list to a single type.

Realized Gains

When the statement includes a Realized Gain or (Loss) section (year-end statements, 1099-B-style detail), the Realized Gains sub-tab shows the total realized gain or loss and the number of dispositions, then one entry per lot: date sold, security (option symbols such as NVDA 09/26/2025 177.50 P are shown in full, with the description under them), quantity, cost basis, proceeds, gain or loss, and a Short-term or Long-term badge. Lots flagged as wash sales carry a red Wash sale badge. The date acquired is in the Excel download. Periodic monthly and quarterly statements typically don't include this section, and the tab says so. A consolidated 1099 with no Form 1099-B (no sales that year) has no lots; the sub-tab says so and points you to the Summary sub-tab for its income.

Documents

The Documents sub-tab lists every brokerage PDF in the project. Click a row to open that statement in the Holdings sub-tab; when the project has several statements, the one you're viewing is highlighted. Click Download on a row to download the original source file.

Step 3: Download to Excel

Click Download Excel in the project toolbar (top right, next to Automations). The workbook covers the statement selected in the Document picker, plus any other statements uploaded together with it in the same batch. It contains five sheets:

• Summary - one row per account with all period totals
• Holdings - every position across the job, with broker, account, and statement period as columns so you can pivot or filter across multiple statements
• Activity - every transaction (buys, sells, dividends, etc.)
• Realized Gains - lot-by-lot detail (empty for periodic statements that don't report it)
• 1099 Income - for a consolidated 1099, one row per box of Forms 1099-DIV, 1099-INT, 1099-MISC and 1099-OID: broker, account, tax year, form, box, the IRS box name, and the amount (zero boxes included)

On the free trial

The free trial exports up to 10 transactions per account, across all jobs, and every holding, activity row and realized lot in the workbook counts toward it. The Summary and 1099 Income sheets are totals rather than transactions and are always included in full. On the trial, Download Excel gives you a sample workbook: the first rows that fit in what is left of the 10, holdings first, then activity, then realized lots. Every sheet starts with a note stating the trial limit and linking to the upgrade page. Downloading the same job again gives you the same sample and does not use more of the allowance.

Once the 10 transactions are used, Download Excel on another job opens the upgrade window instead. Everything extracted stays on screen in the Summary, Holdings, Activity and Realized Gains sub-tabs, and once you subscribe or buy pages the same job downloads in full without re-processing. See DocuClipper free trial.

Supported brokers

DocuClipper extracts holdings from these US and Canadian brokers:

Brokers we don't support yet

Interactive Brokers is on the roadmap. If you upload a statement from a broker that isn't listed above, the job will run but the Holdings tab will be empty or incomplete. Email support@docuclipper.com with a sample PDF if you need extraction for one of these and we'll let you know when it ships.

Per-broker notes

• Wells Fargo Advisors vs Wells Fargo Bank. WFA brokerage statements (advisor-managed accounts, WellsTrade) are supported. Wells Fargo Bank deposit-account statements (checking, savings, Way2Save) are processed by the standard bank statement converter, not the brokerage extractor. If you have both, upload them through their respective entry points.
• Schwab options and preferred shares. Option positions are read with their contract quantity, short positions as negative quantities and values, and preferred shares keep their series symbol (for example BAC+B).
• Schwab 1099 Composite. Upload a Schwab consolidated Form 1099 as a brokerage statement and DocuClipper reads its 1099-B section: every realized lot appears on the Realized Gains sub-tab with date acquired, date sold, proceeds, cost basis, and gain or loss. Option contracts are included, with the contract (for example AMD 07/03/2025 138.00 C) as the symbol. A 1099 has no positions or transaction history, so the Holdings and Activity tabs say so and point you to the Realized Gains tab. The Reconciled badge checks the extracted lots against the 1099-B's own printed short-term and long-term totals for proceeds, cost basis, and gain or loss; the Year-End Summary pages that follow the 1099-B repeat those figures and are not counted twice. Upload the whole composite: a file with some 1099-B pages removed shows Not reconciled, because its lots no longer add up to the printed totals.
• Fidelity Tax Reporting Statement. Fidelity's consolidated 1099 (including the preliminary version Fidelity posts before the figures are final) is read the same way: every Form 1099-B lot lands on the Realized Gains sub-tab, short-term and long-term, covered and noncovered, including option expirations and cash in lieu. A lot with a disallowed wash sale loss is flagged; its gain or loss is shown as Fidelity prints it, proceeds minus cost basis, with the disallowed amount reported separately in box 1g. The Supplemental Stock Plan Lot Detail pages are not part of Form 1099-B and are left out. The Reconciled badge checks the lots against the form's own Summary of Proceeds From Broker and Barter Exchange Transactions for proceeds, cost basis, wash sale loss disallowed, and realized gain or loss.
• Merrill Tax Reporting Statement. Merrill's consolidated 1099, including the Supplemental Tax Reporting Statement, is read the same way: every Form 1099-B lot lands on the Realized Gains sub-tab, short-term and long-term, covered and noncovered, including bond redemptions, principal payments and option contracts. Wash-sale lots are flagged. Lots in the Other Transactions section, where Merrill prints N/A because the cost basis is not available, are listed with a cost basis and gain of zero, the same way the form leaves them out of its totals. The Reconciled badge checks the lots against the form's Sales Proceeds and Net Gains and Losses row for proceeds, cost basis, wash sale loss disallowed, and gain or loss. A download that bundles monthly statements with the 1099 is read as monthly statements; upload the 1099 on its own to get its realized lots.
• Morgan Stanley and E*TRADE 1099 Consolidated Tax Statement. Morgan Stanley prints the consolidated 1099 for both Morgan Stanley and E*TRADE accounts, and DocuClipper reads it the same way: every Form 1099-B lot lands on the Realized Gains sub-tab, short-term and long-term, covered and noncovered, labelled with the account's broker. Wash-sale lots are flagged; their gain or loss is shown as printed, proceeds minus cost basis, with the disallowed amount in box 1g. Lots in the Noncovered Securities with Undetermined Holding Period section print only proceeds, so they are listed with no acquired date and a cost basis and gain of zero, as in the form's Unknown Term total. The Reconciled badge checks the lots against the 1099-B Totals Summary for proceeds, cost basis, wash sale loss disallowed, and gain or loss.
• Consolidated 1099s from Altruist, Ameriprise, LPL Financial, Raymond James, Robinhood, UBS and Vanguard. These are read the same way as the Schwab composite: every 1099-B lot lands on the Realized Gains sub-tab, including lots from a sale that closed several tax lots and option contracts (which have no CUSIP; the contract, for example AAPL 11/29/24 C 237.500, is the symbol), and wash-sale lots are flagged. Robinhood's crypto section (Form 1099-DA) is included. The monthly expense sales of a gold or silver trust (UBS prints them as Principal payment, with no date acquired and no cost basis) are listed with a cost basis and gain of zero, the way the form counts them. The Reconciled badge checks the lots against the form's own Grand total for proceeds, cost basis, wash sale loss disallowed, and gain or loss. If you upload only some 1099-B pages without the summary page, their lots are still read, but the document shows Not reconciled because there is no Grand total to check against; upload the full 1099 to get the badge. A consolidated 1099 that lists no sales (dividends and interest only) shows its 1099-DIV, 1099-INT and 1099-MISC amounts on the Summary sub-tab.
• Betterment Consolidated Tax Statement. DocuClipper reads the 1099-B detail: every sale, including fractional-share lots, with dates, proceeds, cost basis, gain or loss, short or long term, and any wash sale loss disallowed. The Reconciled badge checks the sales against the Short-Term and Long-Term totals Betterment reports to the IRS, and the Form 1099-DIV Summary boxes appear on the Summary sub-tab. Upload the full PDF from Betterment's Tax Documents page.
• Webull and other Apex Clearing 1099s. Webull, Stash and other apps that clear through Apex Clearing issue the Apex Form 1099 Composite. DocuClipper reads its 1099-B section: stock and option sales, covered and noncovered lots, and wash sales (marked D). The Reconciled badge checks the sales against the Summary Of Sale Proceeds totals on the Tax Summary page, and the 1099-DIV, 1099-INT and 1099-MISC boxes appear on the Summary sub-tab. Upload the complete composite PDF.
• Coinbase Form 1099-DA. DocuClipper reads every sale or exchange of digital assets on Coinbase's 1099-DA, with the asset, units, dates, proceeds, cost basis and gain or loss, and the Reconciled badge checks the rows against the Total line of the Summary For Trading. A PDF with only the transaction sections (Section 1, Section 5 and so on, without the cover and summary pages) is read too, and each asset's rows are checked against that asset's own Total: line. Crypto you transferred in from elsewhere shows Unknown cost basis on the form; those rows come through with a cost basis of 0, so enter your own basis from your other exchange or wallet records.
• Pershing statements. The statement carries your adviser's or broker's name, but Pershing LLC prints it, so DocuClipper reads it by its layout ("Portfolio at a Glance", "Portfolio Holdings"). Cash sweep balances come from the Closing Balance column. When a security is held in tax lots, each lot row is a holding with its own cost basis, named after the security above it. A PDF that holds several quarterly statements or several accounts is read as one document: the Holdings sub-tab shows each account's latest holdings, the Activity sub-tab lists every statement's transactions in date order, and the Reconciled badge checks the holdings against each statement's Total Portfolio Holdings.
• Pershing Tax Information Statement. Many advisers and introducing brokers send their clients the 1099 that Pershing LLC prints ("YOUR TAX INFORMATION STATEMENT", Pershing named as payer). DocuClipper reads every Form 1099-B lot, covered and noncovered, with quantity, dates, proceeds and cost basis. Pershing prints no gain or loss column, so the gain shown is proceeds minus cost basis; noncovered lots that print no cost basis are listed with a cost basis and gain of zero. The SALE DATE TOTAL rows are Pershing's subtotals and are not repeated as lots. The Reconciled badge checks the lots against the form's Total row for proceeds and cost basis, and the 1099-DIV and 1099-INT boxes appear on the Summary sub-tab.
• Edward Jones Consolidated 1099 Statement. Upload the 1099 on its own (the monthly Edward Jones statement is read separately). Every Form 1099-B lot lands on the Realized Gains sub-tab, whatever its activity type (Sale, Redemption, Cash in Lieu), with symbol and CUSIP. Gain or loss is shown as Edward Jones prints it, the Unadjusted Gain/Loss (proceeds minus cost basis), with any wash sale loss disallowed alongside. Uncosted lots, where the form prints Unknown, are listed with a cost basis and gain of zero. The Reconciled badge checks the lots against the Net Totals row of the 1099-B Totals page for proceeds, cost basis, gain or loss, and wash sale loss disallowed.
• J.P. Morgan Securities Consolidated Forms 1099. Every Form 1099-B lot lands on the Realized Gains sub-tab with the security's full name and CUSIP, including lots printed below the CUSIP line. The gain or loss is shown as printed, with any wash sale loss disallowed added back. The Reconciled badge checks the lots against the Total Short-Term, Total Long-Term and Total Unknown Term rows of the Realized Gain / Loss Summary for proceeds, cost basis, wash sale loss disallowed, and gain or loss. A scanned J.P. Morgan 1099 is read with OCR; compare a Not reconciled scan against the PDF.
• RBC statements in two currencies. An RBC statement that holds both Canadian and US dollar assets prints one section per currency. DocuClipper reads both into the same job: each currency's cash shows on the Holdings tab as its own row (for example Cash (U.S. DOLLAR)), and the Reconciled badge checks every currency against its own printed Total Value and cash balance. Upload one month per PDF; a file that combines several months is not read.
• Morgan Stanley share class details. Some MS statements with very large balances may show small reconciliation gaps (a few dollars on six-figure accounts) due to source-side rounding in the statement itself, not extraction error.
• Several Schwab statements in one PDF. A download that combines several monthly Schwab statements for one account is read one statement at a time: the Holdings tab shows the positions of the latest statement, the Activity tab lists every month's transactions, and the badge shows Reconciled only when every statement in the file ties to its own printed total.

Consolidated 1099s

A consolidated 1099 combines several IRS forms for one account and tax year. DocuClipper reads two parts of it:

• Form 1099-B (sales) - every lot, on the Realized Gains sub-tab and the Realized Gains sheet. See Per-broker notes for how each broker's 1099-B is read.
• Forms 1099-DIV, 1099-INT and 1099-MISC (income) - every box on the 1099's summary page, on the Summary sub-tab and the 1099 Income sheet: ordinary and qualified dividends (1a, 1b), capital gain distributions (2a-2f), nondividend distributions (3), federal tax withheld (4), section 199A dividends (5), foreign tax paid (7), exempt-interest dividends (12, 13), interest income (1), U.S. savings bond and Treasury interest (3), tax-exempt interest (8, 9), market discount and bond premium (10-13), royalties, other income and substitute payments (MISC 2, 3, 8), and state tax withheld. Morgan Stanley and E*TRADE also print a Form 1099-OID block, which is read the same way.

This works for the Schwab Form 1099 Composite, the Fidelity and Merrill Tax Reporting Statements, the Morgan Stanley and E*TRADE 1099 Consolidated Tax Statement, the consolidated 1099s from Altruist, Ameriprise, LPL Financial, Raymond James, Robinhood, UBS and Vanguard, the Pershing Tax Information Statement, the Betterment Consolidated Tax Statement, and the Apex Clearing Form 1099 Composite (Webull, Stash). A 1099 that reports only dividends and interest, with no sales, is extracted too: it shows its income on the Summary sub-tab and has no lots. When one PDF holds the 1099s of two accounts, each account gets its own card.

The amounts are the ones printed on the 1099, never recomputed. The Reconciled badge on a 1099 means every box row on the summary page was read and checks out against the form itself: a box the IRS defines as part of another is not larger than it (qualified dividends within total ordinary dividends, for example), and where the broker prints a detail total that names its box (Morgan Stanley's "1099-DIV box 1a", Merrill's "LINE 1A 1099-DIV", Schwab's "Box 1a" in the Year-End Summary), the box equals it. For a 1099 with sales, the 1099-B lots must also tie to the printed totals.

Upload the 1099 as the PDF your broker provides. A scanned or photographed 1099 is read with OCR, and a box whose label or amount the scan garbles shows Not reconciled; compare it with the PDF before relying on it.

Common questions

Does this work for IRAs? Yes. Schwab IRAs, Fidelity combined CMA + IRA statements, Edward Jones IRAs, and equivalent at the other supported brokers all work. The extracted summary will show the account type (IRA, Roth IRA, taxable, etc.) when the statement labels it.

Can I upload multiple statements at once? Yes. Drop them all in the upload widget. Each statement is extracted independently; use the Document picker on the Brokerage tab, or click a row in the Documents sub-tab, to switch between them. The Excel download includes every position from all the statements uploaded in that batch.

What about historical statements going back several years? Yes. The extractor doesn't depend on statement date. Older statement layouts that match the current format are handled the same way.

Why is my balance off by a few dollars? Two common causes: the broker's own statement contains small rounding gaps (most often on Morgan Stanley statements with large balances), or the statement covers an options sub-account where DocuClipper didn't capture every line. The Reconciled badge flags these for you.

Can I use this output for tax filing? Monthly and quarterly statements show holdings and summary totals, not the tax-cost-basis detail required for Schedule D. For tax work, upload your broker's consolidated 1099 itself: if your broker is Schwab, Fidelity, Merrill, Morgan Stanley, E*TRADE, Altruist, Ameriprise, LPL Financial, Raymond James, Robinhood, UBS, Vanguard, Betterment, Webull or another Apex Clearing app, or clears through Pershing, you get its 1099-B realized lots and its 1099-DIV, 1099-INT and 1099-MISC box amounts in one spreadsheet. Edward Jones and J.P. Morgan 1099s and Coinbase's 1099-DA give you the realized lots. Check the figures against the 1099 before you file.

Related

• Extract data from bank statements
• Brokerage Statement Converter (overview)