How to Build a Personal Finance Aggregator with Screen Scraping in Python

Personal finance aggregators like Mint and Plaid connect to your bank accounts and show you everything in one place. While you cannot replicate Plaid's bank partnerships, you can build a personal aggregator using screen scraping and CSV imports for your own financial data. The Architecture Bank CSV Exports / Screen Scraping --> Normalizer --> SQLite DB --> Analytics Setting Up pip install requests beautifulsoup4 pandas sqlite-utils playwright playwright install chromium The Aggregator Framework import sqlite_utils import pandas as pd from datetime import datetime import hashlib class FinanceAggregator : def __init__ ( self , db_path : str = " finances.db " ): self . db = sqlite_utils . Database ( db_path ) self . _init_tables () def _init_tables ( self ): if " transactions " not in self . db . table_names (): self . db [ " transactions " ]. create ({ " id " : str , " date " : str , " description " : str , " amount " : float , " category " : str , " account " : str , " source " : str ,