Skip to main content

Importing Holdings from Schwab

Written by Taylor Stewart

How do I import holdings from Schwab?

Advisors import Schwab holdings by uploading 2 CSV exports from Schwab Advisor Center to Import holdings in Kerdora's practice sidebar. Kerdora suggests a household you already have for each Schwab account it can match, and you check every match before anything changes.

  1. In Kerdora, open your user menu, choose Integrations, choose Turn on on Schwab's row under Custodians, then choose Turn on Schwab.

  2. In Schwab Advisor Center, open Accounts → Positions, set View by to Accounts, and choose Export.

  3. In Schwab Advisor Center, open Accounts → Balances and export a Balances file at about the same time.

  4. In Kerdora's practice sidebar, open Import holdings, add both files, and choose Match accounts.

  5. Check every household and account destination on Kerdora's review screen.

  6. Choose Import N accounts, where N counts rows with a household selected.

Importing into an investment account replaces all of that account's holdings, so export complete accounts. For errors, see Schwab Import Troubleshooting. Using Altruist instead? See Importing Holdings from Altruist.

How do I turn on the Schwab import?

Turn on Schwab on the Integrations tab of Kerdora's Settings. Kerdora saves your choice right away, with no separate Save button.

  1. Open your user menu (your photo at the top right) and choose Integrations. From Advisor Settings, you can also select the Integrations tab.

  2. Under Custodians, find Schwab ("Holdings from exports") and choose Turn on on its row.

  3. In the Turn on Schwab pop-up, choose Turn on Schwab.

  4. Kerdora shows "Schwab is on." Choose Import holdings to open Kerdora's Schwab upload page now, or Not now to close it.

After that, Schwab's row shows a check mark. Selecting that row opens Schwab's drawer, which has Import holdings and Turn off buttons.

New advisors can also choose Turn on for Schwab under Custodians in Practice setup's Connect your tools step. Once households exist, Practice setup's Your first client step offers Import holdings for each custodian you've turned on.

Turning it on doesn't sign in to Schwab or load any data.

What Schwab files do I need?

On Import from Schwab, upload a Positions CSV from Schwab Advisor Center and, preferably, a Balances CSV exported at about the same time.

  • Positions is required. Export it from Accounts → Positions with View by set to Accounts. Kerdora reads account numbers, account titles, securities, quantities, prices, and market values.

  • Balances is optional. Export it from Accounts → Balances. Kerdora reads Cash & Cash Investments, registration type, primary account holder, and Market Value Long.

Kerdora's upload page asks you to export both files after the market closes, so their values agree. Use 1 Positions file and at most 1 Balances file, each no larger than 10 MB. Upload real CSV exports; a PDF or Excel workbook renamed to .csv won't work.

Export Positions and Balances for identical accounts. An account found only in Balances imports as cash only, with no warning, and replaces an existing investment account's securities with cash. Accounts with no positions and zero cash are left out. A Positions file is required even when every account holds only cash.

How do I export Schwab Positions with View by set to Accounts?

Export Positions from Schwab Advisor Center with View by set to Accounts, so each row says which account holds a position. Kerdora needs that Account column to put holdings on the right accounts.

  1. In Schwab Advisor Center, open Accounts, then Positions.

  2. Next to View by, choose Accounts.

  3. Choose Export in the toolbar above your positions table, and save that CSV.

With View by set to Securities, Schwab combines each security across all your accounts into one row. SPY held in 2 accounts, for example, shows once, with both accounts' shares added together. That export has no Account column, so Kerdora can't tell which account holds each position and shows "We don't recognize this file. Upload the Positions export from Schwab Advisor Center, and the Balances export if you have it." Set View by to Accounts and export again.

What happens if I leave out the Schwab Balances file?

On Import from Schwab, Positions alone imports securities without any cash, and account-type suggestions come from Schwab's account titles. Kerdora warns: "Without the Balances file, cash isn't included and account types come from the account titles. Upload the Balances export with the Positions one to include them."

A Positions-only import into an existing investment account replaces that account's full holdings set, including any cash it held before. Kerdora doesn't keep old cash separately. Accounts that hold only cash aren't in a Positions file, so a Positions-only upload doesn't update them.

For a complete refresh, upload Positions and Balances together. Even then, an account missing from your Balances file gets no cash, and Kerdora flags it: "Not in the Balances file, so its cash is missing."

Where do I find Import holdings for Schwab?

Import holdings appears in Kerdora's practice sidebar once Schwab or Altruist import is turned on for your advisor login. It doesn't appear while you're inside a household, so return to your client list first. On a phone, open Kerdora's app menu and choose Import holdings.

With only Schwab turned on, Import holdings opens Import from Schwab directly. With Altruist also on, Kerdora asks "Which custodian are your files from?" Choose Schwab.

With no custodian import on, the sidebar entry is hidden. Opening Kerdora's import page directly shows "No custodian import is on" and a Turn on Altruist or Schwab in Settings link.

You can also open Import from Schwab from Settings: open your user menu, choose Integrations, select Schwab's row, and choose Import holdings in its drawer.

How do I upload Schwab files for matching?

On Import from Schwab, add each file to its named row, then choose Match accounts. Uploading and matching prepare a review; nothing in your households changes yet.

  1. Choose Choose file beside Positions and select your Positions CSV.

  2. Choose Choose file beside Balances (optional) and select your Balances CSV.

  3. Check both filenames. To replace a file, choose Remove beside it, then choose another. You can also drag CSVs onto Kerdora's file rows.

  4. Choose Match accounts and wait while Kerdora shows "Reading the files…"

Match accounts stays unavailable until Kerdora's Positions row has a file. Kerdora tells your 2 exports apart by their columns, so files in swapped rows still work. Compare account counts and totals with your exports before approving any destination.

How do I review Schwab account matches?

On Kerdora's Schwab review screen, check every destination, including accounts Kerdora matched on its own. Kerdora checks stored account numbers first, then uses AI to suggest households, people, and accounts for remaining rows.

  • Suggested matches holds AI suggestions.

  • Needs your input holds rows with no household match.

  • Matched holds account-number matches. This group starts collapsed unless one of its accounts has a warning.

  • Skipped holds rows you've skipped.

A summary at the top says how many accounts matched automatically (counting AI suggestions) and how many need a check before you import. Expand Matched and check account numbers, households, account names, and types. Use the arrow at the start of each row to see that account's holdings from your files. An existing account's owner isn't shown on its review row, so check uncertain ownership in that household's Profile → Accounts.

A warning doesn't block importing. Resolve each flagged account before you continue.

How do I change a Schwab account match?

On Kerdora's Schwab review screen, change any destination before you choose Import N accounts. Match an existing Kerdora account when it's the same Schwab account; a second account can count that balance twice.

  1. For a row under Matched, choose Edit to show its controls.

  2. Select a household in Kerdora household. This clears that row's account, owner, proposed person, and Goal assignments.

  3. To use an existing account, choose Existing account and select it. Kerdora first selects that household's first account, so check your selection.

  4. To add an account, choose New account and select its proposed name. In account details, check Account name, Owner (it lists only people already in that household), Account type, and Goal assignments, then choose Save. Without Save after a household change, Kerdora creates that account with no owner. Cancel closes account details without keeping changes.

  5. Choose Skip for a row you don't want. Undo brings back Kerdora's suggestion and clears your Goal assignments.

Existing account appears only when that household has an investment account, or a cash account for a cash-only Schwab account. For a cash-only account, account details also offer Investment or Cash / Bank; Cash / Bank gets a balance update instead of holdings.

How do I finish a Schwab import?

On Kerdora's Schwab review screen, choose Import N accounts only after checking every destination. N counts rows with a household selected, not rows you've checked; rows with no household are skipped.

  1. Check destinations, owners, cash, and account types. Choose Skip for accounts you don't want.

  2. Choose Import N accounts and wait for "Import complete."

  3. Read Accounts imported and Accounts skipped. People added and Accounts added show only when they aren't zero. Holdings added counts imported investment holdings, including replacements.

  4. Choose Go to clients and open each affected household to check positions, quantities, cash, totals, owners, and Goal assignments.

Import more files returns you to Kerdora's Schwab upload step. "Import complete" gives counts only, with no detailed change list and no undo. Keep your exports and review notes so you can tell what changed.

How do I refresh Schwab holdings later?

Use Import holdings again with new, complete Schwab exports whenever you want current holdings in Kerdora. Stored account numbers let Kerdora match accounts from earlier imports; unfinished review choices aren't saved between sessions.

  1. Export Positions (View by set to Accounts) and Balances for identical accounts, at about the same time.

  2. Open Import holdings, choose Schwab if asked, add both files, and choose Match accounts.

  3. Expand Matched and check every destination, including rows you moved to a different account last time.

  4. Choose Import N accounts and check affected households.

Each imported investment account gets a replacement holdings set, not extra copies of earlier positions. Accounts missing from your exports stay as they are. Always export complete accounts: importing only changed positions removes every other holding from those accounts.

What does a Schwab import change in an existing account?

A Schwab import replaces an existing investment account's entire holdings set and switches its balance to come from holdings when needed. Positions missing from your export disappear from that account, including positions entered by hand.

Kerdora also saves the Schwab account number on an existing destination, which can replace a different saved number. If another account you can access already stores that Schwab number, Kerdora leaves it there, so later imports match that other account again. To move a match for good, clear or correct Account Number on the old account (choose Open details on its Profile → Accounts row, or select the row in the Balance sheet layout or on a phone).

An existing bank destination gets that Schwab account's total as its balance. Kerdora doesn't change an existing account's name, owner, type, institution, savings, time horizon, or beneficiary; Goal assignments saved during review are added.

New accounts get the name and type on their row, the owner saved or suggested, Schwab as institution, and the Schwab account number. Check each new account's savings, beneficiary, time horizon, and Goal assignments afterward. Skipped rows aren't refreshed.

What doesn't a Schwab import bring in?

A Schwab import doesn't bring in tax lots or cost basis. Every imported holding has a cost basis of zero, which replaces any basis on that account's earlier holdings. Correct basis before relying on gain or loss figures.

Tickers Kerdora recognizes use imported share counts and Kerdora's own prices, so values can differ from a dated export. Cash, bonds listed by CUSIP, and unrecognized securities become custom holdings valued at their exported market value. Check their classification and value after importing.

Schwab import doesn't create households, bring in spending transactions, or keep a live feed. Create households first. For PDF statements, use File & extract after Upload on a client's Documents page, or Upload & Extract in Profile → Accounts → Add account → Import (see Using Upload & Extract for Client Data), and check proposed accounts for duplicates.

Can a Schwab import add people to a household?

Yes. On Kerdora's Schwab review screen, a Suggested matches row adds a new person when Kerdora's AI matched the household but no person in it. Kerdora uses the first owner named on that Schwab account, even for a row going to an existing account, and adds one person per row: 3 accounts for one new owner add that owner 3 times. Each new person becomes a Client while a household has fewer than 2 Clients, then an Other adult.

No review row shows a proposed person. Choosing a different household clears it, so Needs your input rows never add one. Choosing Save in account details also clears it, because Owner lists only people already in that household.

To add an owner once, add that person on their household's Profile → Household page before uploading, then select them as Owner in each of their rows' account details and choose Save. For a row going to an existing account, follow "How do I stop a Schwab import from adding a person?"

If People added appears after importing, open Profile → Household in every household you imported into. Contact Support before removing an unexpected person if you're unsure what depends on that record.

How do I stop a Schwab import from adding a person?

On Kerdora's Schwab review screen, saving an existing person as Owner in a row's account details clears that row's proposed new person. For a row going to an existing account, also clear any proposed Goal assignments.

  1. Choose New account and select that row's proposed account name to open account details.

  2. Select your intended person in Owner. If that person isn't listed, add them on their household's Profile → Household page and start your upload again.

  3. For a row that will update an existing account, open Assign goals and uncheck each checked goal.

  4. Choose Save. For an existing destination, switch back to Existing account and select your intended account again.

Account details can preselect a goal, such as a household's only Retirement goal for an IRA; Save keeps it, and switching to Existing account doesn't clear it. Choosing Owner here doesn't change an existing account's saved owner, and unchecking goals here doesn't remove goals it already has.

Does a Schwab import keep accounts connected?

No. Import holdings loads Schwab CSV data once; it doesn't create an ongoing connection to Schwab. Neither advisors nor clients can make this import fetch later balances. To refresh, export new files and import again.

Linked accounts through Plaid are a separate workflow for connecting supported institutions. Advisors reach them from a household's Profile → Accounts → Connections. Missing cash in a Plaid-linked Schwab account belongs to Troubleshooting Linked Accounts, not to Schwab CSV import.

Who can use the Schwab import?

Every advisor can turn on Schwab import on the Integrations tab of Settings. Clients don't have Kerdora's import pages in their portal.

Turning it on is saved for your advisor login only; another advisor at your practice turns on their own.

Kerdora's review screen lists existing households you can access. Create any missing household before uploading files; see Adding Your First Client. Choosing New account during review adds an account to a selected household; it never creates a household.

How do I turn off the Schwab import?

Turn off Schwab from its drawer on the Integrations tab of Kerdora's Settings. This changes availability for your advisor login only; people, accounts, and holdings you imported stay in place.

  1. Open your user menu (your photo at the top right) and choose Integrations.

  2. Under Custodians, select Schwab's row to open its drawer.

  3. Choose Turn off at the top of Schwab's drawer. Kerdora turns it off right away, with no confirmation step.

If Altruist import is still on, Import holdings stays in your practice sidebar and opens Altruist. If neither is on, that sidebar entry disappears. To turn Schwab back on, choose Turn on on Schwab's row, then Turn on Schwab. Turning off an import doesn't undo past imports or disconnect a Plaid connection.

Did this answer your question?