icsv2ledger

+1 for ledger. I switched from GnuCash to ledger about 8 years ago and never looked back. I have a script that pulls my bank account using aqbanking [1] and icsv2ledger.py [2]. The latter can match transactions to templates and set transaction accounts and payees automatically. It also supports autocompletion of account names when a transaction is not matched by a template. For cash entries, I use ledger-mode in Emacs. (I also use Org mode, so I spent a lot of time in Emacs anyway.) ledger-mode also supports autocompletion. I only use the command line for reporting and have aliases for the most common reports. These mostly revolve about showing my current budget. [1] https://wiki.gnucash.org/wiki/AqBanking [2] https://github.com/quentinsf/icsv2ledger Fun fact: The second program I wrote was a database in Turbo Pascal to keep track of my l

It's a nice system in PHP. There are quite a few of them. Like ledger-cli [1] in C++ and emacs lisp, hledger [2] in Haskell and beancount [3] with fava [4] in python. We used ledger-cli and beancount with fava and built automatic creation of accounting entries using machine learning and Bayesian alogrithms by analyzing bank and credit card statements. You can use powerful icsv2ledger [5], smart importer [6] and the awesome list [7] to get importers for various banks and other utilities. [1] https://www.ledger-cli.org/ [2] https://hledger.org/ [3] http://furius.ca/beancount/ [4] https://beancount.github.io/fava/ [5] https://github.com/quentinsf/icsv2ledger [6] https://github.com/beancount/smart_importer/blob/master/READ... [7] https://github.com/siddhantgoel/awesome-beancount/blob/maste... Note: corrected the entry for ledger-cli, its prim

Use this https://github.com/giacomos/qifparse combined with https://github.com/quentinsf/icsv2ledger to automatically generate journal entried in ledger-cli format which can be used by hledger directly. You can also fork and modify it to generate hledger format files directly.

I have built the scripts using https://github.com/quentinsf/icsv2ledger/blob/master/icsv2le... as base. You can do the same as the scripts I wrote are specific to banks I am using and the pdf files they send, except one of the banks which provide qif format file which I convert to CSV. You can look at https://github.com/beancount/beancount/tree/master/examples/... for beancount custom import example.

I successfully switched to ledger a few years ago after a few failed attempts years earlier. I attribute success to: https://github.com/quentinsf/icsv2ledger It is the transaction import script that has really worked well for me without quirks. A lot of people recommend "reckon"--which I've tried--but I found that while Bayesian scoring sounds good, a solid set of regex work better. icsv2ledger does a great job of allowing you to build up a pool of search terms to map inputs to categories. And since the regex set is an artifact that you can tweak and add to, you end up with a very stable and comprehensive import process. I also like that it will (optionally) add the raw CSV that was imported as a comment in the transaction, and use that to avoid reimporting transactions. While this is a little visually noisy in the ledger file, I'm blind