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

[B Wooster]

On Sun, Sep 27, 2020 at 4:21 PM 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.
>

Another automated processing should be doable when I'm importing both
Checking and Savings QIF files - the Savings file should provide the hint
on how to treat that $0 split transaction...


>
> 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
>>
>