Skip to main content

Schwab Import Troubleshooting

Written by Taylor Stewart

Why can't I upload my Schwab file?

On Import from Schwab, "Choose a CSV file." means Kerdora didn't get a file with a .csv filename. Export a CSV from Schwab Advisor Center.

  1. Check that each CSV is no larger than 10 MB.

  2. Choose Remove beside a wrong file, then Choose file to select a fresh export.

  3. Use 1 Positions export and at most 1 Balances export.

An oversized upload can show "Internal server error" instead of a size message. To make files smaller, export fewer complete accounts, keeping every holding for each account you include. For setup and matching steps, see Importing Holdings from Schwab.

Why doesn't Kerdora recognize my Schwab export?

On Import from Schwab, "We don't recognize this file. Upload the Positions export from Schwab Advisor Center, and the Balances export if you have it." means Kerdora couldn't find the columns it expects. Kerdora recognizes Positions by its Account and Symbol/CUSIP columns, and Balances by Account or Account Number together with Cash & Cash Investments.

A Positions export made with View by set to Securities causes this message. That view combines each security across all your accounts and has no Account column. To fix it:

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

  2. Next to View by, choose Accounts.

  3. Choose Export and upload that new CSV in Kerdora's Positions row.

A PDF or Excel workbook renamed to .csv also fails here: it passes Kerdora's filename check, but its contents lack Schwab's columns. Export a fresh CSV with original column names.

What does "This looks like a Altruist export" mean on a Schwab import?

On Import from Schwab, "This looks like a Altruist export. Use the Altruist import instead." means you added an Altruist holdings report to Schwab import. Kerdora tells exports apart by their columns, so a renamed Altruist file still gets this message.

  1. If you meant to import Schwab holdings, export Positions from Schwab Advisor Center's Accounts → Positions with View by set to Accounts, and upload that file instead.

  2. If you meant to import Altruist holdings, open Import holdings and choose Altruist.

If Import holdings opens Import from Schwab directly, Altruist import is off for your login. Open your user menu, choose Integrations, and choose Turn on on Altruist's row under Custodians. In that pop-up, choose Turn on Altruist, then Import holdings to open Import from Altruist. For Altruist file steps, see Importing Holdings from Altruist.

Why does Schwab import ask for Positions?

On Import from Schwab, "Upload the Positions export too. The Balances file has no holdings." means Kerdora found a Balances export but no Positions export. A Balances CSV alone can't start a Schwab import, even for accounts that hold only cash.

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

  2. In Kerdora's Positions row, choose Remove if a file is there, then Choose file, and select your Positions export.

  3. Put your Balances export in Kerdora's Balances row, replacing any wrong file with Remove first.

  4. Choose Match accounts.

Kerdora identifies exports by their columns, not by filenames or Kerdora's row labels. This message can appear when Kerdora's Positions row holds a Balances file, so check each file's contents before retrying.

Why does Schwab import reject duplicate files?

On Import from Schwab, "Upload one Positions file and at most one Balances file." means Kerdora read both CSVs you uploaded as Positions exports. Use 1 Positions export and no more than 1 Balances export, covering identical accounts and exported at about the same time.

  1. Check each file's contents; different filenames don't make different export types.

  2. Choose Remove beside a wrong file.

  3. Use Choose file to put Positions in Kerdora's Positions row and Balances in its Balances row.

  4. Choose Match accounts again.

If you have several Positions exports, run separate imports of complete accounts. Don't split one investment account's positions across imports: each import replaces that account's full holdings set.

Why does Schwab import say cash is missing?

On Kerdora's Schwab review screen, "Not in the Balances file, so its cash is missing." means that account is in your Positions export but its account number isn't in your Balances export. Kerdora doesn't fill in cash from an earlier import.

If you left out Balances entirely, Kerdora instead 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." Export Positions and Balances for identical accounts at about the same time, then restart Import holdings with both files.

Don't import an account with incomplete cash into an investment account you mean to refresh fully. An import replaces earlier holdings, including cash. You can choose Skip for affected rows while you check. Missing deposit cash in a Plaid-linked Schwab account is a separate issue; see Troubleshooting Linked Accounts.

Why does a Schwab account show only cash?

On Kerdora's Schwab review screen, an account found in your Balances export but missing from your Positions export imports as cash only. Kerdora doesn't warn that its securities might be missing.

If that account really holds securities, importing its cash-only row into an existing investment account replaces all of its earlier holdings with cash. Check every cash-only row against Schwab before importing.

  1. Check whether your Positions export left out that account or filtered out its securities.

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

  3. Restart Import holdings with both exports and look at that account's holdings on Kerdora's review screen.

Choose Skip for an incomplete account while you check. Accounts with no positions and zero cash are left out entirely.

Why do Schwab holdings and Balances disagree?

On Kerdora's Schwab review screen, "Holdings add up to $X; Balances says $Y." means an account's Positions market values differ from its Market Value Long in your Balances export. Kerdora flags a difference larger than $1 or 0.5% of that Balances value, whichever is larger.

This check compares securities only, not securities plus cash. Likely causes are exports made at different times or with different account or position filters.

  1. Compare both exports for that account.

  2. Export Positions and Balances again with identical coverage, after the market closes.

  3. Restart Import holdings with those files and check that account before importing.

A warning doesn't block importing. Choose Skip if you can't reconcile an account. After importing, tickers Kerdora recognizes use Kerdora's prices, so values can still differ from your export even when both files agree.

Why does Schwab import say an account was set to Taxable?

On Kerdora's Schwab review screen, a "Set to Taxable" note means Kerdora couldn't map that account's Schwab registration or title to an account type it knows. It shows one of 2 notes:

  • "Set to Taxable: Kerdora doesn't know Schwab's "<registration>" registration yet." Your Balances file named a registration type Kerdora can't map.

  • "Set to Taxable: the Schwab title doesn't say the account type." Kerdora had no registration type from Balances, and the account title didn't name a type.

  1. Check that account's registration in Schwab. If you uploaded Positions alone, add your Balances export, which carries registration type.

  2. For a proposed new account, choose New account, open its details, set Account type, Owner, and Account name to match its registration, then choose Save.

  3. For an existing account, check its saved type in its household's Profile → Accounts before importing.

An existing match keeps its saved type. A Taxable note doesn't confirm tax treatment. Contact Support if Kerdora doesn't offer a type that fits.

Why were no accounts found in my Schwab export?

On Import from Schwab, "No accounts found in CSV" means Kerdora recognized your export but found no accounts to import. Export a fresh report with complete accounts and holdings, not a summary or an empty selection.

Schwab rows need account numbers that contain digits. Accounts with no positions and zero cash are left out.

  1. Check your exports for account rows and account numbers.

  2. Export complete accounts from Schwab Advisor Center with original column names, and Positions with View by set to Accounts.

  3. Restart Import holdings, add your files, and choose Match accounts.

Compare account counts with your exports before importing. If a complete export still finds no accounts, contact Support with your export type, file sizes, and the exact message.

Why are values missing from my Schwab import?

On Kerdora's Schwab review screen, missing or unreadable numbers in your export become zero. A review screen that loads doesn't prove every value was read correctly.

  1. Compare quantities, market values, and totals with your Schwab exports.

  2. Look for empty cells or edited column names, then export a fresh CSV with original headers.

  3. Restart Import holdings, upload complete accounts, and compare values again before choosing Import N accounts.

To include cash, upload your Balances export with Positions. Positions alone has no cash.

Why are Schwab accounts in Needs your input?

On Kerdora's Schwab review screen, Needs your input means Kerdora didn't suggest a household for those rows. Name differences, a missing household, or unavailable AI matching can leave rows here.

  1. Check that you can open your intended household from Clients. Create a missing household before restarting your upload.

  2. Select that household in Kerdora household.

  3. Choose Existing account and select your intended account, or choose New account, open its proposed name, set Owner and Account type, and choose Save.

Only households you can access are listed. Check uncertain ownership in Profile → Accounts. Rows with no household are skipped when you import other accounts; Kerdora won't create a household for them. Suggested and account-number matches need review too.

How do I recover from a failed Schwab upload or match?

On Import from Schwab, an upload or matching failure happens before Import N accounts and doesn't replace any holdings. Check your error message, fix your upload, and try again.

  • "No CSV file uploaded": add your Positions CSV and choose Match accounts again.

  • "Unknown custodian": reopen Import holdings and choose Schwab.

  • "Failed to parse CSV file": an unexpected error while reading your files. Check format and original headers, then retry once with fresh exports; if it repeats, contact Support.

  • "Couldn't read the files. Try again." or a browser message such as "Failed to fetch": your connection may have dropped. Retry.

  • "Unauthorized user": sign in again, then restart your upload.

  • "API call failed" or "Internal server error": check file sizes and formats, then retry once. These messages don't point to a single cause.

If a valid export still fails, contact Support with your export types, file sizes, time, and exact error text.

What happens if I leave a Schwab import review?

Leaving Kerdora's Schwab review screen before you choose Import N accounts discards your unfinished matches without importing them. At "Leave without saving?", choose Stay to keep working or Leave anyway to leave.

  1. If you left before importing, reopen Import holdings from Kerdora's practice sidebar.

  2. Choose Schwab if asked and upload your complete exports again.

  3. Choose Match accounts, then check every household, account destination, owner, and account type again.

Closing or reloading your browser tab shows your browser's own leave prompt instead. Kerdora doesn't save unfinished review choices for later. If you had already chosen Import N accounts before leaving or losing your connection, check affected households before another import; some may already have changed.

How do I recover from a failed Schwab import?

After you choose Import N accounts on Kerdora's Schwab review screen, treat "Failed to execute import," "Import failed," or a lost connection as a possible partial import. Kerdora saves each household separately, so some households may already have changed.

Don't choose Import N accounts again on that review screen. Retrying unchanged new-account or new-person rows can create duplicates in households already saved. Leave that review; at "Leave without saving?", choose Leave anyway. Then:

  1. Open affected households from Clients and check accounts, people, holdings, and stored account numbers.

  2. Compare saved changes with your exports. Contact Support before retrying if you can't tell what changed.

  3. Start a fresh upload through Import holdings. Check account-number matches against accounts already created, and skip finished rows or select existing accounts and owners.

"No access to selected clients" means a selected household isn't available to your login. That check rejects your request before anything is written. Restart with households you can access, or contact Support.

What does "Request body too large" mean during a Schwab import?

On a Schwab import, "Request body too large" appears when your reviewed data is too big to submit, even though each CSV is within Kerdora's 10 MB file limit. Kerdora limits each final import submission to 2 MB. A submission rejected with this message imports nothing, so you can retry with smaller exports.

Export smaller groups of complete accounts and import each group separately, using matching Positions and Balances exports for each group. Keep all holdings for each account you include. Don't split one account's positions across runs: each run replaces that investment account's holdings.

Choosing Skip for many rows won't shrink your submission. Restart with smaller files instead. If a single complete account still fails, contact Support with your file sizes, account and holding counts, and the exact message.

How do I recover after a Schwab import into a wrong account?

A Schwab import into a wrong account replaces that account's holdings and can save a Schwab account number on it. Importing into your intended account afterward won't restore the wrong account's overwritten holdings.

  1. Identify both affected accounts and keep their complete source reports.

  2. In the wrong account's household, open Profile → Accounts. On that account's row, choose Open details (the settings icon at the end of the row; in the Balance sheet layout or on a phone, select the row instead), then correct or clear Account Number. Restore its holdings from its own complete, correct source.

  3. In your intended account's household, open Profile → Accounts. On that account's row, choose Open details, then enter its correct Account Number. Check that no other account keeps that number.

  4. Restart Import holdings, expand Matched, and check every destination before importing.

  5. Compare both accounts' numbers, holdings, and totals afterward.

There's no undo after an import. Contact Support before going further if you can't establish earlier holdings. Correcting an account number prevents repeat mismatches; it doesn't restore positions.

How do I fix a duplicate account after a Schwab import?

A Schwab import can create a duplicate when an existing account has no stored Schwab account number and you accept a New account suggestion. Both accounts can then count toward that household's balances on Profile → Accounts.

  1. On that household's Profile → Accounts page, find both accounts and decide which to keep. Compare Goal assignments, savings, beneficiaries, and connections; an older account can hold planning details the imported copy lacks. Contact Support before deleting anything if you're unsure which one your plan relies on.

  2. On the unwanted account's row, choose Open details (the settings icon at the end of the row; in the Balance sheet layout or on a phone, select the row instead). Choose the trash icon at the top of its details, then confirm with Delete. Read any connection warning before confirming.

  3. On your remaining account's row, choose Open details and enter its Schwab number in Account Number. Check that no other account keeps that number.

  4. Upload complete exports through Import holdings, expand Matched, and check that your remaining account is selected before importing. Check holdings and planning assignments afterward.

Deleting a duplicate doesn't move its holdings or planning settings to your remaining account. Keep complete source reports so you can check both.

Did this answer your question?