[GNC] $0 splits in QIF imported incorrectly, flipping + and - values
B Wooster
bwooster47 at gmail.com
Sun Sep 27 14:41:08 EDT 2020
$0 split transactions are not getting imported from QIF correctly.
Non-zero transactions get imported fine.
The problem is gnucash is flipping what is a withdrawal vs a deposit for $0
splits.
The following QIF file shows the incorrect import.
The signs on the Savings transfer are the same on both transactions below,
but only the non-zero split gets imported correctly.
If I manually edit the QIF to flip the signs on the "Incorrect Withdrawal"
transaction, it imports correctly.
Correct import is that both transactions should deposit to the Savings
account, both are negative amounts in the input .qif.
Does anyone know if that is a known issue? Or is this a bug?
Or is there a workaround to avoid editing this type of QIF export (from old
Quicken, only .QIF export available).
Using GnuCash 3.10 Build ID: 3.10+(2020-04-11)
[Am a new user, periodically I try to see if I can get 15+ years of Quicken
data into gnucash, have found a lot of info about problems with QIF import
issues, but still trying to see if I can get this to work every year or so!
Fails a lot currently, this report is one of the problems.
Even importing both Checking and Savings QIF file at same time, instead of
one by one, causes this same problem.]
test-chk.qif:
!Type:Bank
D6/ 8' 0
U0.00
T0.00
CX
POpening Balance
L[Checking]
^
D9/15' 2
U0.00
T0.00
CX
PPay Check Incorrect Withdrawal from Savings
LSalary
SSalary
EPaycheck (before tax)
$1,400.00
S[Savings]
ETransfer to Savings
$-1,200.00
SAuto:Insurance
EMetLife Auto
$-100.00
STax:Soc Sec
$-100.00
^
D9/16' 2
U1,200.00
T1,200.00
CX
PPay Check Correct Deposit to Savings
LSalary
SSalary
EPaycheck (before tax)
$3,200.00
S[Savings]
ETransfer to Savings
$-1,500.00
SAuto:Insurance
EMetLife Auto
$-100.00
STax:Soc Sec
$-400.00
^
=================================================
After import:
Account Summary 12/31/2020
Code Account title Balance
Auto $0.00
Insurance $0.00 *** should be 200
Salary $1,800.00 *** should be 4600
Tax $0.00
Soc Sec $300.00 *** should be 500
Equity $0.00
Retained Earnings $0.00
Checking $1,200.00 *** Correct
Savings $300.00 *** Should be 2700
===================================================
Transaction Report
>From 01/01/2000 to 12/31/2020
Date Num Description Memo/Notes Account Amount
Insurance
09/15/2002 Pay Check Incorrect Withdrawal from Savings MetLife Auto
Auto:Insurance $100.00
09/16/2002 Pay Check Correct Deposit to Savings MetLife Auto Auto:Insurance
-$100.00
Total For Insurance $0.00
Checking
06/08/2000 Opening Balance Checking $0.00
09/15/2002 Pay Check Incorrect Withdrawal from Savings Checking $0.00
09/16/2002 Pay Check Correct Deposit to Savings Checking $1,200.00
Total For Checking $1,200.00
Retained Earnings
06/08/2000 Opening Balance Equity:Retained Earnings $0.00
Total For Retained Earnings $0.00
Salary
09/15/2002 Pay Check Incorrect Withdrawal from Savings Paycheck (before
tax) Salary -$1,400.00
09/16/2002 Pay Check Correct Deposit to Savings Paycheck (before tax)
Salary $3,200.00
Total For Salary -$1,800.00
Savings
09/15/2002 Pay Check Incorrect Withdrawal from Savings Transfer to Savings
Savings -$1,200.00 *** should be + not -
09/16/2002 Pay Check Correct Deposit to Savings Transfer to Savings Savings
$1,500.00
Total For Savings $300.00
Soc Sec
09/15/2002 Pay Check Incorrect Withdrawal from Savings Tax:Soc Sec -$100.00
09/16/2002 Pay Check Correct Deposit to Savings Tax:Soc Sec $400.00
Total For Soc Sec $300.00
Grand Total $0.00
More information about the gnucash-user
mailing list