TransAmerica 401k Downloads
I used to download TransAmerica 401k account activity via Quicken download files from their website. About 2 weeks ago, that functionality broke; when they repaired the transaction download feature, it now lacks the Quicken format files, and only includes eiither PDF or CSV. After communication with TransAmerica via my employer, it seems like they will not be bringing back quicken download format.
The CSV file format has these columns:
Transaction Type,Date,Source,Fund Name,Unit Count,Unit Value,Transaction Amount
However, if I go to import via moneydance, I am unsure how to match up these columns, as there is no "Action" field to match up with an investment account. Any tips on how to handle this moving forward?
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Stuart Beesley ... on 13 Sep, 2024 11:57 AM
Very difficult for investments with csv. You really need OFX format, or perhaps md+ downloads
2 Posted by bperboy on 13 Sep, 2024 12:08 PM
Unfortunately it seems TransAmerica is not supported by MD+.
3 Posted by dtd on 13 Sep, 2024 10:03 PM
Neither is Fidelity Investments - a lot of infighting going on between banks and aggregators on who gets to be in control of not giving you your data... (that was not a typo, sadly)
4 Posted by bperboy on 17 Sep, 2024 01:31 PM
Is there any recourse here? Any CSV to OFX converters? I don't have a choice to switch - this is my employer's 401k company that I'm locked into..
5 Posted by dtd on 17 Sep, 2024 09:34 PM
Probably manual entry... that's all that comes to mind.
I've looked for CSV to OFX converters for investment accounts, but none of them have been good, and a few were just scams.
6 Posted by dwg on 17 Sep, 2024 11:53 PM
For Investment account it not just matter of mapping the fields like it is in non-investment accounts.
Investment accounts are driven by the action field. The contents of this field can only be certain values and these values determine what other fields are available, which are mandatory etc. CSV files generally do no have this field, the only ones I have seen that do are CSV files that have been generated by another personal finance program and often these CSV files are still not quite right for conversion.
So any converter has to try and parse any CSV file you may give it and try to work out what the transaction is often from very limited and imprecise information.