Transaction Imports

[Henry Law]

On 26/09/15 03:30, Barry wrote:
> I cannot import transactions to an account without laboriously
> double-clicking each and every transaction to identify each one¹s correct
> Expense/Income category.  There could be hundreds!

Sorry to be late to this party; holiday, y'know - no internet access.

Like some of the other posters I too have written a little utility which 
takes the QIF that I can download from my bank (Lloyds in the UK) and 
which uses an "associations" file to pick out the ones that belong in 
particular accounts; it can also ignore particular transactions if 
appropriate (typically those that are done as balancing transactions 
from some other account, such as a credit card).  It writes out 
"massaged" QIF, but transactions for new payees still have to be 
assigned to their accounts manually (along with a new entry in the 
associations file if desired).

It's written in Perl and runs from the command line.  It was developed 
entirely for my situation, although it has a fair degree of generality, 
especially in respect of the associations between payees and accounts. 
You're welcome to it if you wish; mail me if you do (it's a single file, 
plus a template for the associations file, which is XML).  You'd need to 
be able to code a little Perl, I expect, to remove the bits that are 
specific to me and to Lloyds; I'd try to help you to do that.

-- 

Henry Law            Manchester, England