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