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.

Installation

First, install uv.

Then:

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

Verify installation:

sh uv tool list

txt schwab2pp v1.0.0 - schwab2pp

Try it out!

sh schwab2pp --help

```txt Usage: schwab2pp [OPTIONS] [SCHWABCSV] [PPCSV]

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 ─────────────────────────────────────────────────╮ │ schwabcsv [SCHWABCSV] CSV file from Charles │ │ Schwab │ │ [default: None] │ │ ppcsv [PPCSV] 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:

sh schwab2pp example.csv example_out.csv

Update to a new version

sh uv tool upgrade schwab2pp

Uninstallation

sh 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"^1
• "Sell"^2

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