Re: [GNC] QIF Import Problem

[Brenda Leudke]

Hi David:

Thx for the reply.

 

The qif file is not coming from a financial institution. It is being created 
from a 3rd party software. I was trying to determine if the file was created 
incorrectly or if gnucash wasn’t reading it properly. That’s why I was editing 
the file to see if I could “fix” the qif file to work right in gnucash.

 

Thank u for the link though because it helped me figure out the qif contents. I 
made some changes to the pluses and minuses in the file and was able to get the 
file to work right in gnucash.

So I have contacted the support person for this 3rd party software to let him 
know that it appears to me that the qif file he is creating is not right.

 

Thx again for your help. It did point me in the right direction to resolve 
this. I will wait for a reply from the guy who creates the qif file.

 

Brenda

 

From: David Carlson  
Sent: August 5, 2023 12:27 PM
To: Brenda Leudke 
Cc: Gyle McCollam ; gnucash-user@gnucash.org
Subject: Re: [GNC] QIF Import Problem

 

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 mailto:leu...@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 mailto:david.carlson@gmail.com> > 
Sent: August 5, 2023 11:40 AM
To: Gyle McCollam mailto:gmccol...@live.com> >
Cc: Brenda Leudke mailto:leu...@gmail.com> >; 
gnucash-user@gnucash.org <mailto:gnucash-user@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 mailto:gmccol...@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

gmccol...@live.com <mailto:gmccol...@live.com> <mailto:gmccol...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com> >   email


From: gnucash-user mailto:gmail@gnucash.org> > on behalf of Brenda Leudke mailto:leu...@gmail.com> >
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
mailto:gnucash-user@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

SAss

Re: [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  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 
> *Sent:* August 5, 2023 11:40 AM
> *To:* Gyle McCollam 
> *Cc:* Brenda Leudke ; gnucash-user@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  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
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: gnucash-user  on
> behalf of Brenda Leudke 
> Sent: Wednesday, August 2, 2023 3:12 PM
> To: gnucash-user@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@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
___
gnucash-user mailing list
gnucash-user@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.

Re: [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  
Sent: August 5, 2023 11:40 AM
To: Gyle McCollam 
Cc: Brenda Leudke ; gnucash-user@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 mailto:gmccol...@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

gmccol...@live.com <mailto:gmccol...@live.com> <mailto:gmccol...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com> >   email


From: gnucash-user mailto:gmail@gnucash.org> > on behalf of Brenda Leudke mailto:leu...@gmail.com> >
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] QIF Import Problem

[David Carlson]

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  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
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Brenda Leudke 
> Sent: Wednesday, August 2, 2023 3:12 PM
> To: gnucash-user@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@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
___
gnucash-user mailing list
gnucash-user@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.

Re: [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  
Sent: August 5, 2023 10:58 AM
To: Brenda Leudke ; gnucash-user@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:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

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

Re: [GNC] QIF Import Problem

[Gyle McCollam]

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

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Brenda Leudke 
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@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@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.

Re: [GNC] QIF Import Problem

[Christopher Lam]

For completion, Colin sent me 2 QIF files from 2 different bank accounts.
Some lines indicated transfer from 1st QIF acct to 2nd QIF acct.

The solution is tedious. Importing QIF acct will require careful mapping of
QIF account/category, and when importing the 2nd QIF account, the importer
*will* *(very slowly)* attempt to find duplicates if the account names are
correctly chosen, and allow you to correctly match transfers. Matched
transfers are skipped thereby avoiding duplicates.

The good news is the QIF account/category -> GnuCash account mapping is
saved between imports.

Thus it'sa good idea to import accounts in short date periods; the mapping
will thus be preserved inbetween.

The next release *will* feature a much faster duplicate finder.

On Sun, 4 Aug 2019 at 19:52, Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

[Clint Chaplin]

Pleasant idea, but not feasible in my case...

I am exploring converting over because my Quicken is hitting unauthorized
memory access errors when I attempt to modify report filtering.  I am
unsure just how much longer it will muddle through with any usefulness.

On Sun, Aug 4, 2019 at 2:12 PM David Carlson 
wrote:

> I would suggest that it would probably create a very ponderous data file to
> cover 15 years' data.  I have 10 years' history in my current file and I
> regret putting so much into one file, as it generates lags of several
> seconds for some very common operations, and minutes to open or close..
>
> I would suggest at most one or two years of history for your GnuCash file.
> Then the one-account-at-a-time procedure is not so overwhelming.
>
> I think, but I am not sure, that Quicken will continue to work off-line if
> you want to review older history in the future.
>
> David Carlson
>
> On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
> wrote:
>
> > Hi,
> >
> > I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> > problem where all transfers between accounts are duplicated after the QUF
> > import.  I am aware that this is not a new problem and I have read meany
> > threads on here going back at least ten years about this.
> >
> > I tried exporting just one month of my chequing and savings accounts to
> > separate QIF files and then importing them into GnuCash simultaneously
> and
> > separately.  In each case, 100% of the time all transfers between the
> > accounts are duplicated in each account.  Whatever is supposed to be
> > flagging these duplicates is not working.  If I do them separately, I do
> > get the option to select the duplicates, but ultimately I want to import
> > the past 15 years of transaction level detail, and I am not willing to go
> > the manual route.
> >
> > My question is: Is there any new information about a solution to this
> > problem?
> >
> > Thanks,
> >
> > Colin
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Clint (JOATMON) Chaplin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

[David T. via gnucash-user]

... And I have none of these problems with 13 years of history. No lags, 
loading, while slow, has neither decreased nor increased over the years 
with a growing file size. YMMV, but I've used both Mac versions, and now 
the Windows version (currently 3.5).


I've said it before, but it bears repeating. When I imported many years 
ago, I exported everything from Quicken into GnuCash in one grand pass. 
GnuCash set up the accounts based on the transactions and picked up the 
matching sides of transfers such as the OP mentioned.


David T.

On 8/5/2019 2:38 AM, David Carlson wrote:

I would suggest that it would probably create a very ponderous data file to
cover 15 years' data.  I have 10 years' history in my current file and I
regret putting so much into one file, as it generates lags of several
seconds for some very common operations, and minutes to open or close..

I would suggest at most one or two years of history for your GnuCash file.
Then the one-account-at-a-time procedure is not so overwhelming.

I think, but I am not sure, that Quicken will continue to work off-line if
you want to review older history in the future.

David Carlson

On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
wrote:


Hi,

I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
problem where all transfers between accounts are duplicated after the QUF
import.  I am aware that this is not a new problem and I have read meany
threads on here going back at least ten years about this.

I tried exporting just one month of my chequing and savings accounts to
separate QIF files and then importing them into GnuCash simultaneously and
separately.  In each case, 100% of the time all transfers between the
accounts are duplicated in each account.  Whatever is supposed to be
flagging these duplicates is not working.  If I do them separately, I do
get the option to select the duplicates, but ultimately I want to import
the past 15 years of transaction level detail, and I am not willing to go
the manual route.

My question is: Is there any new information about a solution to this
problem?

Thanks,

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

[Christopher Lam]

Hi I'm currently looking at the QIF importer and would be grateful for a
sample datafile that contains data between matching accounts. Would you
mind sending me a small QIF? eg. a couple days' worth of data.

On Sun, 4 Aug 2019 at 19:52, Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

[David Carlson]

I would suggest that it would probably create a very ponderous data file to
cover 15 years' data.  I have 10 years' history in my current file and I
regret putting so much into one file, as it generates lags of several
seconds for some very common operations, and minutes to open or close..

I would suggest at most one or two years of history for your GnuCash file.
Then the one-account-at-a-time procedure is not so overwhelming.

I think, but I am not sure, that Quicken will continue to work off-line if
you want to review older history in the future.

David Carlson

On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.