> I was able to automate every part of this except syncing it with my account (since there's no API to access my financial records.)

It's actually possible to simulate a browsing session and have the App Script log in to your broker's site and scrape the data you need. Here is some prototyping code: https://gist.github.com/aaf74e50b9a281396722