Betterment plugin for ofxstatement
This is an ofxstatement plugin for Betterment CSV statements downloaded from the site’s activity page. ofxstatement converts the CSV into a series of “check” transactions in an OFX file, so Moneydance (for instance) will only consider bank and credit card accounts for the generated OFX file’s import. Given Betterment’s daily gain/loss transaction data, the “check” transaction type works well enough.
ofxstatement is a tool for converting proprietary bank statements into the OFX format, suitable for importing into GnuCash, Moneydance, and other compatible applications. The plugin for ofxstatement parses a particular proprietary bank statement format and produces a common data structure that is then formatted into an OFX file.
As with ofxstatement, this plugin requires Python 3. You will need to have ofxstatement installed; the package will be brought in as a dependency if you install the plugin via pip.
You can install the plugin via most of the normal Python methods (be sure to install using your environment’s python3 installation). Remove the –user option if you wish to install the package globally.
pip3 install --user ofxstatement-betterment
python3 setup.py install --user
Note that you can specify ‘bank’ and ‘account’ in ofxstatement’s configuration file (accessible using the ofxstatement edit-config command or directly at ~/.local/share/ofxstatement/config.ini (on Linux, at least). Setting these values makes it easier for your personal finance application to recognize which account the file’s data belongs to.
Also note that transactions for zero amounts are filtered by default. If you wish to include zero-amount transactions, set ‘zero_filter’ to ‘false’ in your settings. Here is an example of a settings block for the betterment plugin:
[betterment] account = 8675309 plugin = betterment zero_filter = false
Export your Betterment activity into a CSV file (it’s currently transactions.csv). Then run:
$ ofxstatement convert -t betterment transactions.csv betterment.ofx
You can then import betterment.ofx into the personal finance application of your choice.
Updated to support newer CSV format by using header row rather than index, support the new date format, and sort by date for beginning and ending balance.
Changed to a SHA-256 hash for the pseudo-unique transaction ID in order to improve ID stability while preserving uniqueness.
Added filter to remove pending transactions (which have a blank ending balance)
Small documentation improvements.
Wired up to Travis CI
Added coveralls test coverage reporting.
Uploaded to pypi
Added to github
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for ofxstatement-betterment-0.3.1.tar.gz