Rares Vernica <[email protected]> writes:
> 1. Import transactions directly from the Bank website using AqBanking
> and OFX Direct Connect.
>
> 2. Use transaction names to Auto-complete account names.
Thanks for your answers.
It seems that (1) can be done with some custom scrips and (2) is kind-of
done in Emacs.
If I were to switch to Ledger, I would use (1) periodically (every
week/month) to get the transactions from my bank accounts and (2) from
time to time to manually add few transactions. The most important is
(1).
Let me get into more detail about (1).
Step I: Get transactions from the bank.
I can use ofx.py from http://www.jongsma.org/gc/ or AqBanking (not
sure this is doable yet) to get OFX files from my banks with the
latest transactions.
Step II: Get transactions into Ledger.
It seems that Ledger understands OFX, but there are a couple of
intermediary steps that are necessary in order to get the
transactions into it.
a. For each transaction I need to figure out the second
account. GnuCash remembers the second account given a transaction
name. A previous poster mentioned that he/she does that in a
script. I guess I will have to do a similar script and remember
for each unique transaction name to which acount it goes.
b. I need to skip duplicated transactions. In case I already have a
transaction from the previous OFX import, I need to make sure I
do not insert it again. GnuCash also skips duplicated
transactions.
Step (I) seems easy, but steps (II.a) and (II.b) are not trivial...
What are your thoughts on this? Can this be generalized? Has somebody
done something similar that can be reused?
Thanks,
Rares
