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 <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 _______________________________________________ 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.
