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