The latest articles on DEV Community by Francesco Gabrieli (@francesco_gabrieli_). https://dev.to/francesco_gabrieli_ https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3799726%2Fb7c3fda1-b130-45d0-be3f-e0aebf64c0ac.jpg https://dev.to/francesco_gabrieli_ en Francesco Gabrieli Sun, 01 Mar 2026 09:48:23 +0000 https://dev.to/francesco_gabrieli_/spectra-automate-personal-finance-from-bank-csvpdf-exports-python-4cf7 https://dev.to/francesco_gabrieli_/spectra-automate-personal-finance-from-bank-csvpdf-exports-python-4cf7 <p>Every month I was doing the same manual work: export bank statements, clean messy CSV/PDF formats, decode ugly descriptions, categorize transactions, then update spreadsheets by hand.</p> <p>So I built Spectra.</p> <p>Spectra is a file-based Python pipeline that ingests bank exports (CSV/PDF), normalizes them, optionally categorizes transactions with an LLM (OpenAI/Gemini), detects recurring payments, converts historical FX rates, and updates a Google Sheets dashboard automatically.</p> <p>Core parsing/normalization/dedup runs locally; categorization can be cloud-based depending on configuration.</p> <p>If you’ve dealt with bank exports before, I’d love feedback on the worst edge cases you’ve seen and what you’d prioritize next.</p> <p>Repo: <a href="https://github.com/francescogabrieli/Spectra" rel="noopener noreferrer">https://github.com/francescogabrieli/Spectra</a><br> <a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F1an65wi37m5xgm2uapeg.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F1an65wi37m5xgm2uapeg.png" alt=" " width="800" height="520"></a></p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fras6kh1rdmfu9l5safqa.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fras6kh1rdmfu9l5safqa.png" alt=" " width="800" height="331"></a></p> python opensource automation sideprojects