If you use hledger, you can actually write a csv importer directly in the tool: https://hledger.org/import-csv.html

I wrote my own idempotent parser before this existed but would give this a try first