> Maybe you just update it once a month from statements?

In my experience, this is the only reliable way. Most banks also support exporting transaction data as CSV, but the data quality is usually too poor for automatic account assignments.