[GNC] QIF Import Problem

[Brenda Leudke]

Hi Gyle:

Thank u for the reply. I appreciate any help.

 

The program (Vacation Rent Pro - VRP) that I am using to generate the import
file only creates QIF files for Quicken or IIF files for Quickbooks. So I
have to use QIF files to import into gnucash.

Note: I use OFX files when downloading my banking transactions into gnucash
with no problem.

 

I have discussed this with the VRP support person and he says that the QIF
file works properly for Quicken. So he says it's a gnucash problem.

 

When I import the data (as shown by my example), the payment as well as the
income both enter as a debit. Then I have to manually change the income
entries to a credit.

 

I would be open to doing some type of conversion of the qif file before it
gets imported (to reduce the amount of manual effort). Not aware of a qif
conversion to ofx or qfx. But that would be a "good enough" workaround, if
there is no other solution.

 

Brenda

 

From: Gyle McCollam <gmccollam at live.com> 
Sent: August 5, 2023 10:58 AM
To: Brenda Leudke <leudke at gmail.com>; gnucash-user at gnucash.org
Subject: Re: [GNC] QIF Import Problem

 

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

 <mailto:gmccollam at gyleshomes.com> gmccollam at live.com           email

  _____  

From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org
<mailto:gnucash-user-bounces+gylemc=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