search

rlan / convert-csv-schwab2pp

Converts a Charles Schwab transaction CSV file to a ready-to-import CSV file for Portfolio Performance.
MIT License
7 stars 1 forks source link

Support Bank Interest Transactions #16

Open ipaulo opened 1 month ago

ipaulo commented 1 month ago

(Some?) Bank Interest transactions use the date format "07/16/2024 as of 07/15/2024". Date conversion currently fails.

Example transaction:

"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount" "07/16/2024 as of 07/15/2024","Bank Interest","","BANK INT …9999-999999 SCHWAB BANK","","","","$0.80"

ipaulo commented 1 month ago

Sorry, the title may be bad since I found two other transaction types that use the same format...

"07/01/2024 as of 05/31/2024","REINVEST DIVIDEND","","FAKE STOCK LLC","73.56","$1.00","","" "06/04/2024 as of 05/01/2024","Received","","FAKE STOCK LLC","4,000","$1.00","","

And by the way, I'm new to PP so I don't know yet if these transaction types are even useful to import. Just reporting import errors I'm finding as I use PP for the first time.

ipaulo commented 1 month ago

Oh! My transaction export doesn't have the first line in your example. This report may be completely wrong. I will keep working on it and see what's up.

ipaulo commented 1 month ago

When I add the "Transactions for account..." first line from your example, I get the same result for these 'as of' dates.