3

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?

!Type:Bank
D02/08/2019
T1000.0
SAssets:Current Assets:Checking
$800
SExpenses:Taxes
$100.0
SExpenses:Insurance:Health Insurance
$100.0
PD02/08/2019 Pay Check
LIncome:Company:Salary
^
2
  • 1
    Can you export a QIF file from gnucash as an example? Commented Dec 21, 2019 at 0:43
  • @mhoran_psprep "copy a working example" is older than humanity... :)
    – RonJohn
    Commented Dec 21, 2019 at 3:16

1 Answer 1

2

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

D7/ 2'15
U-158.32
T-158.32
CX
PAmazon Marketplace Seattle Wa
Moffice stuff / roku
LHousehold:Office Related
SHousehold:Office Related/Deductable Expense
EPens & Pads
$-22.89
SAuto & Transport:Service & Parts
EAuto emergency escape tool
$-16.23
SHousehold:Electronics
ERoku 3 & holder
$-119.20
^

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.

1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .