Importing both sides of a transaction

[Ewan Slater]

Hi,

I'm trying to automate pulling work expenses into GnuCash.

I can download my bank / credit card information as QIF or OFX.

I can download my work expenses in CSV format.

What I would like to do is to merge the data from the bank with that for
the expenses application so I can then import one file which contains both
sides of the transaction.

Can anyone tell me how to represent both sides of the transaction in QIF or
OFX, so that the debit and credit sides of the transaction can be assigned
automatically to the correct account please?

If I know how to represent it in either file format I can then write an app
to merge the data for import.

Cheers,

Ewan