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