I am trying to write a QIF file manually so I can learn to convert csv files to QIF myself without a third party app on Linux.

I am having difficulty understanding how to record a split transaction.

The following is an example transaction where we receive income, $1000. It must be split between health care deduction, taxes, and deposit to checking. This is what I have, but GNU Cash doesnt properly import it. How can I fix this? What should a split transaction look like in a qif file?

SAssets:Current Assets:Checking
SExpenses:Insurance:Health Insurance
PD02/08/2019 Pay Check
  • 1
    Can you export a QIF file from gnucash as an example? Dec 21 '19 at 0:43
  • @mhoran_psprep "copy a working example" is older than humanity... :)
    – RonJohn
    Dec 21 '19 at 3:16

Here is a real-wold QIF split transaction exported from Quicken 2016, and successfully imported into GnuCash:

D7/ 2'15
PAmazon Marketplace Seattle Wa
Moffice stuff / roku
LHousehold:Office Related
SHousehold:Office Related/Deductable Expense
EPens & Pads
SAuto & Transport:Service & Parts
EAuto emergency escape tool
ERoku 3 & holder

Consider including an M line for the transaction and S lines for each split even if they are empty. I've had problems importing a file the worked once I made that change.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.