A zero amount is neither a deposit nor a withdrawal. It is merely a vehicle to hang a comment on. GnuCash wouldn't know the difference.
On Sun, Sep 27, 2020 at 1:43 PM B Wooster <bwooste...@gmail.com> wrote: > $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 > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
