Effortless Financial Management: Transforming Bank PDF Statements into an Automated Personal Monthly Expense Tracker on Google Sheets.
This script has the following functions:
- Extract transactions from PDF statements using regex in Python.
- Transform the extracted data into a consistent format.
- Separate transactions into hardcoded categories.
- Load transformed data into Google Sheets.
- Format the data in Google Sheets.
- DBS CSV
- CITI PDFs
- HSBC PDFs (after OCR)