TD Statement Extractor
Extract machine readable transaction data from TD credit card statements. Useful for importing data quickly into a bookkeeping or accounting system!
Installation
Install from the command line:
$ gem install td_statement_extractor
Usage
You can process a single file from the command line like so:
td_statement_extractor ~/path_to/INPUT_FILE ~/path_to/OUTPUT_FILE.csv
Or you can process a number of files and produce a single CSV output. This is great for processing an entire year's worth of statements and outputting a CSV ready for import into your accounting software come tax time. It is recommended that you only process statements for a single account at a time:
# Process multiple files using a wildcard operator in the input path
td_statement_extractor ~/path_to_statements/* ~/path_to/OUTPUT_FILE.csv
# Process multiple files by listing each file manually
td_statement_extractor INPUT_FILE_1 INPUT_FILE_2 [etc...] ~/path_to/OUTPUT_FILE.csv
After processing each file the system will generate a summary of the output, including a Total activity amount that should match up with the Total activity from the PDF statement. This is a great way to sanity check the output of the script and make sure it's accurate:
Decrypting and pre-processing file... This may take a minute.
Decryption and pre-processing completed.
Processed file: /Users/SomeGuy/Downloads/TD_EMERALD_FLEX_RATE_VISA__CARD_XXXX.pdf
Details:
Transactions: 15
Total activity: $908.41
Transactions:
Date | Description | Amount
-----------|---------------------------------------|----------
2024-07-15 | PAYMENT - THANK YOU | $286.66
2024-07-18 | GITHUB, INC. HTTPSGITHUB. | -$5.62
2024-07-27 | SPOTIFY STOCKHOLM | -$12.42
2024-08-01 | UBER* TRIP HTTPSWWW.UBE | -$14.34
2024-08-01 | UBER CANADA/UBERTRIP | -$18.56
2024-08-01 | UBER* TRIP HTTPSWWW.UBE | -$7.83
2024-08-01 | PAYMENT - THANK YOU | $831.0
2024-08-02 | Amazon.ca Prime Member amazon.ca/pr | -$11.29
2024-08-01 | WAL-MART ONLINE PHOTO | -$75.05
2024-08-02 | UBER CANADA/UBERTRIP | -$3.0
2024-08-02 | UBER CANADA/UBERTRIP | -$10.67
2024-08-02 | UBER CANADA/UBERTRIP | -$18.67
2024-08-06 | PREAUTHORIZED PAYMENT | $10.0
2024-08-09 | INTUIT *QBooks Online | -$27.12
2024-08-13 | GOOGLE *YouTubePremium g.co/helppay | -$14.68
-----------|---------------------------------------|----------
Development
After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.
To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/aarongough/td_statement_extractor.
License
The gem is available as open source under the terms of the MIT License.