Issue when importing QIF file with splits
warlord at MIT.EDU
Wed Jan 3 12:03:44 EST 2018
Edward Bridges <ebridges at eqbridges.com> writes:
> I am trying to import a QIF file with splits, but the splits are being
> created in an unexpected way.
> Here is an example of the QIF file that I'm trying to import (these
> are being generated to create splits, so I have control over their
> NAssets:Current Assets:Checking Account
> PSample Income (Imported)
> SAssets:Budgeted Cash
> This is what I'm hoping to get as a result of the import (screenshot
> is available at the link):
> However when the above QIF file is imported, I'm getting the following:
> The problem I'm seeing is that the $100 is not being debited from the
> Checking Account and credited to Income.
> I expected that additional split to be created because the record is
> in the context of the checking account (given the `N` field on line 2)
> and the transaction is categorized as "Income" (via the `L` field on
> line 11).
When doing splits, the "L" portion is ignored, which is why you're not
seeing anything to Income. You need:
> Please help me to understand what I'm doing wrong to make this import
> as I expect.
I think if you remove the LIncome and add those two lines then it should
do what you want. Try it out and let me know?
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
More information about the gnucash-devel