Convert Charles Schwab statements to Excel or CSV

Quick answer

Charles Schwab customers often hold a Schwab Bank checking account alongside a Schwab brokerage account, and the statements can cover both. QuickBankConvert is built for the bank side: deposits, withdrawals, card purchases, transfers and fees. Upload the PDF to QuickBankConvert, check the rows in the preview, and download CSV or Excel with a free account. Holdings, trades and dividends in a brokerage section are not bank transactions, so do not rely on them coming through. You never share your Schwab login.

Bank and brokerage: what converts

A Schwab Bank checking or savings statement is a ledger: a dated list of money in and money out, with a balance. That is exactly what the converter reads, and each transaction becomes one row.

A brokerage statement is a different document. Alongside cash activity it reports positions, market values, trades, dividends, interest and realised gains, often in several tables per page. Those are not bank transactions, and our exports have no columns for a security, a share quantity or a price. Two practical rules follow:

• For bank transactions, convert the bank statement. If Schwab gives you a separate Schwab Bank statement, upload that one.
• If one PDF covers bank and brokerage accounts, check the preview carefully. What comes out is a single list of transactions; rows from more than one account are not split for you, and brokerage activity may be missing or incomplete. Split the rows by account in the spreadsheet, and compare each account's totals with the statement.

For investment records, positions or cost basis, use the transaction history and tax forms Schwab provides for the brokerage account rather than a statement conversion.

How to download a Schwab statement

1. Sign in at schwab.com or in the Schwab Mobile app.
2. Open your statements. On schwab.com they are listed under Accounts, in Statements & Tax Forms. Choose the account and the period you need.
3. Download the PDF. Use the PDF Schwab generates, not a screenshot or a print to image: a native PDF contains real text and converts more accurately.

Menu names change from time to time, so follow what your screen shows. On a computer the file is saved where you will upload it from, which is simpler than moving it off a phone.

How to convert it

1. Upload the PDF to the converter. It travels over an encrypted (HTTPS) connection and is parsed on our servers.
2. Check the preview against the statement: the first row, the last row and the closing balance of the bank account.
3. Download CSV or Excel for a spreadsheet. For accounting software, see the QuickBooks guide, the Xero guide or the Quicken guide.

Each monthly statement is one upload. For a year of history, Pro's batch upload takes a set of PDFs in one go.

Checking, savings and transfers

Schwab Bank checking and savings statements convert through the same steps. Deposits are positive amounts; withdrawals, card purchases and fees negative. Two things are worth checking:

• Transfers to and from the brokerage account are ordinary rows on the bank statement. In accounting software, mark them as transfers so they are not counted as income or spending.
• ATM fee rebates and refunds appear as credits when the statement lists them as transactions, which makes them easy to total in a spreadsheet.

Which file to download

A statement longer than your plan's page limit is turned away before it is converted, so it does not use up a conversion. A combined statement with long brokerage sections can run to more pages than a bank-only one, so check the page count against your plan. Files can be up to 4.4 MB. Current plans are on the pricing page.

What comes out

One row per transaction with date, description, category, amount and balance (the balance only when the statement prints a running balance). Amounts are signed: money out is negative. The account number, statement period and opening and closing balances are read from the statement and shown above the preview so you can check them.

The QBO and QIF exports describe one bank account per file. You choose the real account when importing; details are on the PDF to QBO page.

What to check, and what can go wrong

• Compare the totals. Before downloading, check the first and last rows and the closing balance against the PDF. We do not publish accuracy figures for Schwab or any other bank; the preview is there so you can verify the result yourself.
• Combined statements. If one PDF covers more than one account, the result is a single list of transactions. Split the rows by account in the spreadsheet.
• Use the PDF Schwab generates. A scan or a phone photo of a paper statement is an image, and it is read less accurately.
• Password-protected PDFs are supported: you are asked for the password when you upload.
• Your file is uploaded. It travels over an encrypted (HTTPS) connection, is parsed on our servers, and a copy is stored. Ask us to delete it through the contact page. We never ask for your Schwab login. See the Privacy Policy.

Related guides

• How to convert Charles Schwab statements to Excel
• PDF bank statement to Excel
• PDF bank statement to CSV
• Import a PDF bank statement into QuickBooks
• For bookkeepers and accountants
• All bank guides