A Charles Schwab CSV Converter for Portfolio Performance

A command-line tool that converts a Charles Schwab transaction CSV file to a ready-to-import CSV file for Portfolio Performance (PP).

After conversion, this step-by-step guide creates a new portfolio file in PP and imports the converted example CSV.

After importing the converted example CSV.

Installation

First, install uv.

Then:

uv tool install git+https://github.com/rlan/convert-csv-schwab2pp

Verify installation:

uv tool list

schwab2pp v1.0.0
- schwab2pp

Try it out!

schwab2pp --help

 Usage: schwab2pp [OPTIONS] [SCHWAB_CSV] [PP_CSV]

 Convert transactions from Charles Schwab for Portfolio
 Performance.

 Convert a transactions CSV file from Charles Schwab to an
 equivalent and ready-to-import CSV file for Portfolio
 Performance.

╭─ Arguments ─────────────────────────────────────────────────╮
│   schwab_csv      [SCHWAB_CSV]  CSV file from Charles       │
│                                 Schwab                      │
│                                 [default: None]             │
│   pp_csv          [PP_CSV]      Resulting CSV file for      │
│                                 Portfolio Performance       │
│                                 [default: pp.csv]           │
╰─────────────────────────────────────────────────────────────╯
╭─ Options ───────────────────────────────────────────────────╮
│ --install-completion          Install completion for the    │
│                               current shell.                │
│ --show-completion             Show completion for the       │
│                               current shell, to copy it or  │
│                               customize the installation.   │
│ --help                        Show this message and exit.   │
╰─────────────────────────────────────────────────────────────╯

Example:

• An example Schwab CSV: example.csv.
• The converted ready-to-import CSV file: example_out.csv.

To replicate this conversion:

schwab2pp example.csv example_out.csv

Update to a new version

uv tool upgrade schwab2pp

Uninstallation

uv tool uninstall schwab2pp

Details

Supported transactions:

• "NRA Tax Adj"
• "Credit Interest"
• "NRA Withholding"
• "Short Term Cap Gain"
• "Long Term Cap Gain"
• "Cash Dividend"
• "Buy"
• "Wire Received"
• "Wire Sent"¹ (Thank you, @ipaulo)
• "Sell"² (Thank you, @ipaulo and @mgillman)

Not-yet-supported transactions:

• ACH deposit and withdrawal

I have actual transactions for the supported transactions. If you could share actual transactions for not-yet-supported ones, please let me know. Thank you.

Duplicate transactions:

As far as I can test, PP will detect and skip duplicate transactions. So it is safe to import overlapping transactions in the future.

Dates:

If date is in "date1 as of date2" format, "date1" will be used and "as of date2" will be appended to the resulting "Note" column.

Development

See development.md

Citation

If this project helps your research, don't hesitate to spread the word! Click on the badge below and find citation formats (e.g., BibTeX and etc) at the bottom of that page.

License

MIT

Footnotes

1. https://github.com/rlan/convert-csv-schwab2pp/issues/2 ↩

2. https://github.com/rlan/convert-csv-schwab2pp/issues/3 ↩