Skip to main content

Betterment plugin for ofxstatement

Project description

https://img.shields.io/travis/cmayes/ofxstatement-betterment.svg https://img.shields.io/pypi/v/ofxstatement-betterment.svg https://coveralls.io/repos/cmayes/ofxstatement-betterment/badge.svg?branch=master&service=github

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.

Requirements

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.

Installation

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.

pip

pip3 install --user ofxstatement-betterment

setup.py

python3 setup.py install --user

Configuration

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

Usage

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.

History

0.3.0 (2015-11-15)

  • 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.

0.2.4 (2015-10-18)

  • Changed to a SHA-256 hash for the pseudo-unique transaction ID in order to improve ID stability while preserving uniqueness.

0.2.2 (2015-10-04)

  • Added filter to remove pending transactions (which have a blank ending balance)

0.2.1 (2015-09-27)

  • Small documentation improvements.

0.2.0 (2015-09-27)

  • Added tests

  • Wired up to Travis CI

  • Added coveralls test coverage reporting.

0.1.0 (2015-09-26)

  • Uploaded to pypi

  • Added to github

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

ofxstatement-betterment-0.3.0.tar.gz (21.9 kB view details)

Uploaded Source

Built Distribution

ofxstatement_betterment-0.3.0-py2.py3-none-any.whl (8.9 kB view details)

Uploaded Python 2Python 3

File details

Details for the file ofxstatement-betterment-0.3.0.tar.gz.

File metadata

File hashes

Hashes for ofxstatement-betterment-0.3.0.tar.gz
Algorithm Hash digest
SHA256 d1f9f9e8b22ee047722a362c3f21e80b2362a44d0fee6dbad9169f40874edec2
MD5 9993de2cc04127a6bd57fe6d9f6e5f6b
BLAKE2b-256 8c3bb09c6f6308b186738cc3d14cbbf77418ed7911b213bccde2ddc91d736c76

See more details on using hashes here.

File details

Details for the file ofxstatement_betterment-0.3.0-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for ofxstatement_betterment-0.3.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 b2dbb92d2b03c14b0ffa35c514797cce80ed7497b5b4baf0485541066d71ef0b
MD5 e5cf9cfa29382614a41d6044c5b3c92b
BLAKE2b-256 573482c056c0a7bbf459961e2ffef87216a5ab5afa69d86f91e63980710eb5a7

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page