Parse PDF Statements to SQLite

I have several bank statements saved as PDFs where each transaction is presented line-by-line. I need a small utility that can read those files, pull out every transaction, and insert the information into an SQLite database.

The essential fields are the date, description and amount shown on each line; if a running balance is available it would be great to capture that as well. Accurate numeric handling is critical—please strip currency symbols, recognise minus signs or debit/credit markers, and make sure amounts are stored as real numbers rather than text.

I use macOS but a cross-platform command-line solution is ideal. Python with pdfplumber / PyPDF2, pandas and the built-in sqlite3 module would suit me perfectly, though I’m open to another stack if you clearly outline the advantages.

Deliverables
• Well-documented source code for the parser
• SQLite schema (single table is fine) and a sample database produced from one of my PDFs
• Simple run instructions so I can feed in new statements whenever I need
• A brief log or report highlighting any rows that could not be parsed cleanly or looked suspicious

If you can build in light data cleaning—trimming whitespace, removing duplicates, flagging malformed dates—that will be a plus. Let me know your expected timeframe and a short outline of how you plan to tackle the extraction when you place your bid.