> - is there an easy way in all of this (perhaps in Ledger itself?) to change > the sign of all of the transactions for some account? One of my credit cards > uses the opposite sign convention to all my other accounts.
This feature is in many of the CSV to ledger conversion tools already. > - how do people deal with avoiding duplicates? Several of these importing > options produce MD5 hashes from the original line in the csv file, which > should presumably make this straightforward. One solution that's useful but not pure is the "transfer account pattern" I wrote about on this list 2012-02-19. Basically, if you have say a credit card and a checking account, and pay one from the other, you create a 3rd "transfer" account that, when both are balanced, has a zero balance. > With my new icsv2ledger setup, each account now produces a ledger file, and I > then manually copy it into my main accounts file. Of course, I could write a > script to append it to the main accounts file, but is there a better way to > import the transactions, avoiding any duplicates, to deal with csv files with > overlapping date ranges? For the first part of this, Ledger supports including other files via: !include /path/to/file I use this heavily. For the latter parts... you'll have to figure out what to do. Personally, I don't download overlapping date ranges (as I scrape end of month PDF statements), so it's not a problem. - Zack
