Re: [GNC] QIF Import Problem
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 ECot
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 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
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
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 ___ 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
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
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.
[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_Import.QIF Description: Binary data ___ 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
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
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
... 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
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
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.
[GNC] QIF Import Problem
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.
[GNC] Qif import problem: matching transactions properly
I am sure I saw this addressed somewhere but; I can not seem to relocate it. The qif importer does not seem to distinguish visibly to the user whether a transaction is a debit or credit, nor does it show me which suggested transactions have already been matched. Inevitably, I end up matching multiple transactions to one that has already been matched, or a credit to a debit (or vice versa). PayPal is the worst, I should buy their stock with as many transactions my wife does thru them for personal and business use. How do I distinguish the suggestions at import? -- --JEffrey Black M.B.A. ___ 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.