Almost duplicate transactions

[Derek Atkins]

Chris Roat <croat at SLAC.Stanford.EDU> writes:

>>So you have a single QIF file two multiple accounts but the
>>transactions don't match up internally?  This sounds like a problem
>>with whatever created the QIF file.  The importer can't match that
>>together if the QIF file itself doesn't map them together.
>
> Oh.  That's what I thought the duplicate transaction finding was
> all about.

Nope, the duplicate detection is about match transactions in the
qif file to transactions already in the gnucash data file.

>>You might be better off loading the accounts as separate QIFs --
>>either in one process or two -- I'm not sure.
>
> It doesn't work properly either way (though I do finally get the
> duplicate transaction window).  Question then:  in the QIF
> standard what should be different to map these transactions
> together?

Ahh, the problem here is that you're mapping them to payees and not
to QIF Accounts.  Change the P... to L[other-acct] and it will do the
right thing.

Basically, you can't map a Payee to an asset account.

> In my checking account QIF:
>
> DAA/BB/CCCC
> TXX.YY
> Cc
> PTRANSFER IN
> ^
>
> In my savings account QIF:
>
> DAA/BB/CCCC
> T-XX.YY
> Cc
> PTRANSFER OUT
> ^

Change the "PTRANSFER IN" to "L[savings]" and "PTRANSFER OUT" to
"L[checking]" and then you can map the qif-accounts to each other.

> Thanks for all your help, Derek!
>
> Chris

-derek

>>> Chris
>>
>>-derek
>>
>>> *** Today, Derek Atkins allegedly wrote ***
>>>
>>>>Of course you wont get it in this process -- there are no duplicates
>>>>to match, because you've got not transactions in your CoA to match
>>>>against.
>>>>
>>>>Try importing these files a second time and you'll see the
>>>>"match duplicates" page.
>>>>
>>>>-derek
>>>>
>>>>Chris Roat <croat at SLAC.Stanford.EDU> writes:
>>>>
>>>>> I run "gnucash --nofile" to get a clean startup and then I do
>>>>> the import.  Through the following I never get a chance to
>>>>> match duplicates.   Am I doing something incorrectly or do I
>>>>> have some switch set wrong?
>>>>>
>>>>> 1. File->Import->Import QIF...
>>>>>    [start the import]
>>>>> 2. Press "Next" on "Import QIF files" Window
>>>>>    [get started]
>>>>> 3. Select my QIF file on "Select a QIF file to load", Press "Next"
>>>>>    [this file has 2 accounts - savings & checking]
>>>>> 4. Press "Next" on "QIF files you have loaded" Window
>>>>>    [only one file to load]
>>>>> 5. Press "Next" on "Accounts and stock holdings" Window
>>>>>    [purely informational]
>>>>> 6. Press "Next" on "Match QIF accounts with GnuCash accounts" Window
>>>>>    [just leave the default matchup to 2 new accounts]
>>>>> 7. Press "Next" on "Income and Expense categories" Window
>>>>>    [purely informational]
>>>>> 8. Press "Next" on "Match QIF categories with GnuCash accounts" Window
>>>>>    [blank category gets matched to Unspecified]
>>>>> 9. Press "Next" on "Payess and memos"
>>>>>    [purely informational]
>>>>> 10. Get to "Match payess/memos to GnuCash accounts"
>>>>>    [This is where I've tried both 1) hitting next, and 2)
>>>>>     matching my "TRANSFER IN" and "TRANSFER OUT" transactions
>>>>>     to their corresponding accounts]
>>>>> 11. Press "Next" on "Match payess/memos to GnuCash accounts"
>>>>>     Window
>>>>> 12. Press "Next" on "Enter the currency used for new accounts"
>>>>>     Window.
>>>>> 13. Press "Finish" on "Update your GnuCash accounts" Window
>>>>>
>>>>> Cheers,
>>>>> Chris
>>>>>
>>>>>>
>>>>>>> Chris
>>>>>>
>>>>>>-derek
>>>>>>
>>>>>>>>> Chris
>>>>>>>>
>>>>>>>>-derek
>>>>>>>>
>>>>>>>>>
>>>>>>>>> *** Today, Derek Atkins allegedly wrote ***
>>>>>>>>>
>>>>>>>>>>Generally they don't care about the transaction.. You have to
>>>>>>>>>>match it to the correct "far account" for it to detect the
>>>>>>>>>>duplication.  The "problem" is that you are leaving it as
>>>>>>>>>>"unspecified" instead of actually specifying the destination.
>>>>>>>>>>
>>>>>>>>>>-derek
>>>>>>>>>>
>>>>>>>>>>Chris Roat <croat at SLAC.Stanford.EDU> writes:
>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>>
>>>>>>>>>>> I'm just starting out with 1.8.8
>>>>>>>>>>>
>>>>>>>>>>> I import two different accounts (using either QIF or OFX) that
>>>>>>>>>>> have a transfer between them.  Thus, there are two transactions
>>>>>>>>>>> imported that have an identical date and amount... one being a
>>>>>>>>>>> credit, the other debit. Gnucash doesn't seem to recognize them
>>>>>>>>>>> as the same, and each gets it's 2nd entry in the "unspecified"
>>>>>>>>>>> account.  Quadruple-entry booking is new to me. :)
>>>>>>>>>>>
>>>>>>>>>>> As far as I can tell, this must be because the entry's
>>>>>>>>>>> descriptions are different: "TRANSFER IN" vs. "TRANSFER OUT".
>>>>>>>>>>> Is there a way to loosen the criteria for duplicate
>>>>>>>>>>> transactions?  Or is there an after-import mechanism to sort
>>>>>>>>>>> this out?
>>>>>>>>>>>
>>>>>>>>>>> Thanks for any help,
>>>>>>>>>>> Chris
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> gnucash-user mailing list
>>>>>>>>>>> gnucash-user at lists.gnucash.org
>>>>>>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available