bin/monzo.py

   1 #!/usr/bin/env python3
   2
   3 from datetime import datetime
   4 import json
   5 import sys
   6
   7 outformat = "qif"
   8 # outformat = "csv"
   9
  10 if __name__ == "__main__":
  11     if outformat == "qif":
  12         print("!Type:Bank")
  13     cnt = 1
  14     with open(sys.argv[1], 'r') if len(sys.argv) > 1 else sys.stdin as fp:
  15         data = json.load(fp)
  16         for t in data.get("transactions"):
  17             try:
  18                 date = datetime.strptime(t["created"], "%Y-%m-%dT%H:%M:%S.%fZ")
  19             except ValueError:
  20                 date = datetime.strptime(t["created"], "%Y-%m-%dT%H:%M:%SZ")
  21             amount = t["amount"] / 100
  22             if "name" in t.get("counterparty", {}):
  23                 payee = t["counterparty"]["name"]
  24             elif t["merchant"] is None:
  25                 payee = t["description"]
  26             else:
  27                 payee = t["merchant"]["name"]
  28             memo = t["description"]
  29             memo += "\n{local_amount} {local_currency}".format(**t)
  30             notes = t["notes"]
  31             if outformat == "csv":
  32                 print('{date:%Y-%m-%d},{amount},"{payee}","{description}","{notes}"'.format(date=date,
  33                                                                                             payee=payee,
  34                                                                                             amount=amount,
  35                                                                                             **t))
  36             elif outformat == "qif":
  37                 print("D{:%Y-%m-%d}".format(date))
  38                 print("T{}".format(amount))
  39                 print("P{}".format(payee))
  40                 print("M{}".format(memo))
  41                 print("#{}".format(t['id']))
  42                 print("^")
  43             cnt += 1