PDF Bank Transactions to SQLite

Python, Website Design, Graphic Design, Data Processing, Data Entry, Software Architecture, MySQL, Database Programming, Data Extraction, Database Management · I have a set of PDF bank statements and I need every transaction imported into a single, well-structured SQLite database. The database only has to hold one field—Amount—so you can ignore dates and descriptions unless you find them useful for your own processing logic.

You can choose whichever parsing approach you prefer (Python + PyPDF2, tabula-pdf, or any other reliable library) as long as the final result is a self-contained .sqlite file I can open directly with standard SQLite tools.

Deliverables • The populated .sqlite file with an Amount column containing every transaction value from the PDFs • The script or notebook you used, clearly commented so I can rerun it on future statements • A short read-me explaining setup and execution steps

Acceptance Criteria • Every monetary value appearing in the PDFs is present in the Amount column, no duplicates, no omissions • The database opens without errors in the latest SQLite browser • Your script runs on a clean machine with only the documented dependencies installed