mint.rb

# Clean up Mint exported transactions for working with a spreadsheet
#
# Usage:
#
# ruby mint.rb <transactions.csv>
#
# Export a CSV of transactions from Mint
#
# Tags are not exported, so it must be filtered out before export:
#
#  https://mint.intuit.com/transaction.event?#location:{"query":"-tag:Reimbursable, -tag:Tax Withholding"}
#
require 'csv'
require 'date'

csv = CSV.new(ARGF.read, headers: :first_row, converters: [:numeric], return_headers: true)

csv.each do |row|
  # print out headers
  puts row and next if row['Date'] == 'Date'

  next unless row['Date'] =~ /2016/  # date converter not working
  next if ['Transfer', 'Paycheck', 'Credit Card Payment', 'Income', 'Interest Income'].include?(row['Category'])

  row['Amount'] = -row['Amount'] if row['Transaction Type'] == 'debit'
  puts row
end