[GNC] $0 splits in QIF imported incorrectly, flipping + and - values

Sun Sep 27 16:34:23 EDT 2020

Gnucash 4.2 was re.leased this morning, why don't you try the current
version - lots of fixes in the importers in version 4.1 I think it was ????

Cheers David H.

On Mon, 28 Sep 2020 at 06:24, B Wooster <bwooster47 at gmail.com> wrote:

> If zero amounts are the issue, any chance of getting an option to treat it
> as positive?
> Maybe there should be an option to treat it as +0?
> Or better still, if looking at other transactions can show that split
> amounts are to be treated - such as Salary shows up in Total Withdrawal
> column (of Checking account), if other non-zero split transactions
> indicated that.
>
> Manually fixing my Quicken QIF export to flip the signs on such
> transactions would be tedious, I am wondering what workarounds exist...
>
>
> On Sun, Sep 27, 2020 at 3:28 PM David Carlson <david.carlson.417 at gmail.com
> >
> wrote:
>
> > 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 <bwooster47 at 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 at 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 at 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.
>