Convert a bank CSV into reviewed GnuCash import rows
At a glance
A small-business owner uses an AI-written local script to reuse their existing GnuCash account assignments. This workflow is listed under Money & Bills, Bookkeeping, CSV.
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Gather a bank CSV and examples of how you previously categorized transactions in GnuCash. Use those existing assignments as the reference for the account names and matching rules. 2) Ask an AI coding assistant to write a small Python converter that reads the bank CSV, applies those established mappings and emits a clean CSV for GnuCash import. 3) Read the generated script and inspect its proposed matches locally; the commenter chose a simple script they could understand. 4) Run it on the downloaded bank file and examine the output account assignments. Correct mismatches before importing the result into GnuCash. 5) Review the import in GnuCash and reconcile it against the bank statement to complete the bookkeeping pass.
How it went
The commenter reports saving about an hour a week while continuing to review imports and reconcile with the bank.
Worth knowing
The AI product and script were not supplied. Reproduction requires generating the converter for your bank's columns and your own account mappings.