Your broker mails a multi page PDF, and Excel will not open it as rows. Upload the statement and BankXLSX pulls every trade, dividend, holding, and cash transaction into a clean spreadsheet with date, symbol, action, quantity, price, and amount columns. Start free, no credit card.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
A brokerage statement is a designed PDF, not a data file. It mixes account summaries, holdings tables, trade confirmations, and disclosures across many pages, so copying it into Excel by hand rarely lines up. Here is what slows people down.
Paste a holdings table out of a brokerage PDF and the symbol, quantity, and market value end up stacked in one cell or shifted a row, so nothing totals.
Buys, sells, reinvested dividends, interest, and fees sit in different sections with different layouts, so building one transaction list means stitching pages together.
Realized gain and loss detail and cost basis sit apart from the trade list, which makes tax season math slow when you need both side by side.
Schwab and Fidelity export recent transactions as CSV, but older months, closed accounts, and the year-end statement are PDF only, so the full history still comes from the document.
A household statement can carry a brokerage account, an IRA, and a cash account together, so pulling one account out by hand is tedious.
A statement that arrived on paper and was scanned has no copyable text at all, so a plain PDF reader gives you nothing usable.
Upload the PDF and the converter reads the statement layout, then writes trades, income, and holdings into spreadsheet rows you can sort, filter, and total right away.
Each trade, dividend, interest payment, and fee lands as its own row with date, symbol, action, quantity, price, and amount in separate columns.
Positions are extracted with symbol, description, quantity, price, and market value so you can drop them straight into a portfolio tracker.
Income transactions are labeled so you can total qualified dividends, interest, and reinvestments without sorting them by hand.
Brokerage, IRA, and cash accounts inside one statement are separated so you can work one account at a time.
Download a real .xlsx workbook for analysis or a clean CSV you can load into tax software, a tracker, or your accounting system.
256-bit encryption in transit and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
Save the monthly, quarterly, or year-end statement from your broker. Scanned and image only PDFs work too.
Tip: The year-end statement carries the full year.
Drag the statement into the box above. The converter reads trades, income, holdings, and cash activity across every page.
Tip: Multi account statements are fine.
Save the result as XLSX or CSV and open it in Excel, Google Sheets, your tax software, or a portfolio tracker.
Tip: Columns are ready to total.
Investment statement data feeds taxes, books, and portfolio tracking, so the people converting it are usually preparing a return, closing the books, or analyzing positions.
Turn a client year-end statement and 1099 detail into a spreadsheet of trades and dividends ready for the return.
Record investment income and capital activity from the statement into QuickBooks or the general ledger.
Pull holdings and trade history into a personal tracker to measure cost basis, allocation, and performance.
Consolidate statements from several custodians into one sheet for reporting and reconciliation.
A brokerage statement holds the numbers you need for taxes, bookkeeping, and tracking performance, but it is built as a designed PDF rather than a spreadsheet. Trades, dividends, interest, and holdings sit in separate tables across several pages, often for more than one account. Converting the statement turns all of that into rows you can sort and total, which is the difference between an hour of retyping and a one minute upload. It also captures the official record. Your broker shows recent activity online, but the statement is the dated, period summary that a tax preparer or auditor will ask for.
BankXLSX reads the main sections of a typical US brokerage statement and writes each into clean columns. The table below shows what shows up in your spreadsheet.
| Statement section | What it contains | Columns you get |
|---|---|---|
| Account summary | Beginning and ending value, change for the period | Period, opening value, closing value |
| Holdings | Positions held at period end | Symbol, description, quantity, price, market value |
| Transactions | Buys, sells, dividends, interest, fees | Date, action, symbol, quantity, price, amount |
| Income | Dividends and interest paid in the period | Date, symbol, income type, amount |
| Realized gain and loss | Cost basis detail for closed lots | Symbol, quantity, proceeds, cost, gain or loss |
The layout differs by custodian, but the converter handles the major US brokers the same way: upload the PDF and get rows. A few firm specific notes that come up most.
| Broker | Native export | When you need the PDF |
|---|---|---|
| Charles Schwab | Recent transactions export to CSV | Older months, year-end statement, closed accounts |
| Fidelity | History downloads as CSV | Full holdings detail and the official statement |
| Vanguard | Activity export, OFX for Quicken | Statement level holdings and period summary |
| Morgan Stanley, Merrill, E*TRADE | Varies by account | Advisor statements are usually PDF only |
Already on a per firm page? Convert a Charles Schwab statement to Excel, a Goldman Sachs statement, or a Morgan Stanley statement. For the simpler format pages, see investment statement to Excel and brokerage statement to CSV.
The monthly statement and the consolidated 1099 are not the same document. The statement lists every transaction during the period, while the consolidated 1099 (which bundles the 1099-B, 1099-DIV, and 1099-INT) is the year-end tax form your broker files with the IRS. Tax preparers often want both: the 1099 for the reportable totals and the statement detail to reconcile trades and sourced cost basis. Converting either one to Excel makes that reconciliation a sort and a sum rather than a page by page read.
Once the statement is in a spreadsheet, loading it elsewhere is quick. For QuickBooks, map the cash side through the QuickBooks QBO format or the IIF format for QuickBooks Desktop. For Quicken portfolio tracking, use the OFX converter or the Quicken bank statement converter. If you also handle plain bank statements, the general bank statement converter and the PDF bank statement to Excel converter produce the same structured output.
Most teams do not stop at Excel. If the next step is QuickBooks Online, you can turn the exported file into an importable QBO with a CSV to QBO converter. For any other financial PDF you need as a sheet, a general PDF to Excel converter handles reports and tables, and firms that process investor or client documents at volume can extract them with enterprise document OCR.
Download the statement PDF from your broker and upload it to BankXLSX. The converter reads the trades, dividends, interest, and holdings across every page and writes each to its own row, then lets you download an XLSX or CSV with date, symbol, action, quantity, price, and amount columns ready to sort and total.
Yes, for recent activity. Schwab and Fidelity both let you export recent transaction history to CSV from the account activity page. The catch is coverage: older months, closed accounts, and the official year-end statement are usually PDF only, so the full history still comes from converting the statement document.
Yes. It extracts the holdings table with symbol, description, quantity, price, and market value, in addition to the transaction list of buys, sells, dividends, interest, and fees. That lets you load positions into a portfolio tracker and the activity into tax or accounting software from the same upload.
Yes. If your statement arrived on paper and was scanned, or the PDF has no copyable text, the converter reads it as an image and still extracts the rows. A plain PDF reader gives you nothing usable from a scan, which is the case the converter is built for.
The statement lists every transaction during a period, while the consolidated 1099 is the year-end tax form your broker files with the IRS, bundling the 1099-B, 1099-DIV, and 1099-INT. Tax preparers often use both: the 1099 for reportable totals and the statement to reconcile trades and cost basis.
Yes. Convert each broker statement to a spreadsheet and combine them into one consolidated sheet, which is how RIAs and family offices report across custodians. Each statement keeps the same column layout, so stacking Schwab, Fidelity, and Vanguard rows together is straightforward.
When the statement includes a realized gain and loss section, the converter extracts the closed lot detail with symbol, quantity, proceeds, cost, and gain or loss. For full year cost basis, pair the statement with the broker consolidated 1099, which carries the IRS reported basis.
Uploads use 256-bit encryption in transit, you can delete your files at any time, and your financial data is never resold or shared. The conversion runs without installing anything, so the statement stays under your control while it is processed.
The investment statement format page.
Convert brokerage statements to CSV.
Convert PDF bank statements to Excel.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
