[GNC] QIF Import Problem

[Brenda Leudke]

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 <mailto: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 live.com> <mailto:gmccollam at gyleshomes.com <mailto:gmccollam at gyleshomes.com> >           email

________________________________
From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> > on behalf of Brenda Leudke <leudke at gmail.com <mailto:leudke at gmail.com> >
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <gnucash-user at gnucash.org <mailto: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 <mailto: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