[GNC] QIF Import Problem

[David Carlson]

Brenda,

It appears that you are editing the QIF file incorrectly.  It should not
need to be edited at all if it is coming from a financial institution.  I
have not used that format for income accounts so I cannot tell you exactly
what is wrong in your case but I think that one side should be appearing in
an income account, and the other side in a bank account.  If you go to
https://en.wikipedia.org/wiki/Quicken_Interchange_Format you will see some
examples of how the format is used, but I think that it is not 100%
correct.  Try to find a more authoritative source for exact usage.
Also, I see that you are in a jurisdiction that has HST, which we do not
have in the US.  Others in this maillist may be able to better guide you.

On Sat, Aug 5, 2023 at 10:55 AM Brenda Leudke <leudke at gmail.com> wrote:

> Hi David:
>
> I was instructed to import into Assets. But I have tried everything –
> Bank, cash, accountsreceivable, accountspayable. The results are all the
> same.
>
> Here is my import (my last try I used AccountsPayable) as a last ditch
> attempt. I think I have tried everything else.
>
>
>
> !Type:Cash
>
> D07/29'23
>
> U0.00
>
> T0.00
>
> PCustomer1
>
> MCottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> L
>
> SIncome:Business Income:Cottage Rental:Cottage #4
>
> ECottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> $1300.00
>
> SIncome:Business Income:HST Collected
>
> ECottage #4 Bkg 1047 HST
>
> $169.00
>
> *SAPayable:Accounts Payable*
>
> ECottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> $-1469.00
>
> ^
>
> D07/31'23
>
> U1469.00
>
> T1469.00
>
> PCustomer1
>
> MCottage #4 Bkg 1047 Payment bank draft
>
> L
>
> *SAPayable:Accounts Payable*
>
> ECottage #4 Bkg 1047 Payment bank draft
>
> $1469.00
>
> ^
>
>
>
> *From:* David Carlson <david.carlson.417 at gmail.com>
> *Sent:* August 5, 2023 11:40 AM
> *To:* Gyle McCollam <gmccollam at live.com>
> *Cc:* Brenda Leudke <leudke at gmail.com>; gnucash-user at gnucash.org
> *Subject:* Re: [GNC] QIF Import Problem
>
>
>
> Brenda,
>
>
>
> GnuCash also supports QIF imports as they are exported from many financial
> institutions.  Is there a chance that one of your GnuCash accounts has an
> incorrect account type?
>
>
>
> On Sat, Aug 5, 2023 at 9:58 AM Gyle McCollam <gmccollam at live.com> wrote:
>
> Brenda,
> Are you using Quicken or QuickBooks?  The Quicken file import used by
> Gnucash is QFX, not QIF?  I don't know anything about the format of the
> import file, but I did a quick download of a QFX file and the layout looks
> very different.  I hesitated to respond, because I don't know much about
> how it works, I just know it works fine for me and the only difference was
> QIF vs QFX.  Gnucash will also import OFX and CSV files if you want to try
> a different format.  I didn't see any responses to your question, so I
> decided to offer what little help I could.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on
> behalf of Brenda Leudke <leudke at gmail.com>
> Sent: Wednesday, August 2, 2023 3:12 PM
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: [GNC] QIF Import Problem
>
> Good afternoon:
>
> I am a first time poster, long time user of gnucash...
>
> I am trying to import a QIF file into gnucash. Gnucash is entering
> everything as a debit. I can't verify this but am being told that it works
> with Quicken. Is there a problem with the file or is there a problem with
> gnucash? I would appreciate any help.
>
> Here is the qif file (an attachment is also included):
>
> !Type:Cash
>
> D06/10'23
>
> U0.00
>
> T0.00
>
> PCustomer1
>
> MCottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> L
>
> SIncome:Cottage Rental:Cottage #3
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $1075.00
>
> SIncome:HST Collected
>
> ECottage #3 Bkg 1032 HST
>
> $139.75
>
> SAssets:TD Business
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $-1214.75
>
> ^
>
> D06/10'23
>
> U1214.75
>
> T1214.75
>
> PCustomer1
>
> MCottage #3 Bkg 1032 Payment etransfer
>
> L
>
>
>
>
>
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
>
> David Carlson
>


-- 
David Carlson