Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account"
Few years back I imported about 20+ years' worth of Quicken data that had been accumulated over time that was in Quicken 2017 on Windows. There were number of lessons I had learned and shared here for others in the past (google search terms: "site:lists.gnucash.org quicken"). While I do not know particulars about Quicken 2002 (is that a typo?), here are general guidelines I recommend following which is what I formulated for Quicken 2017: - Clean up the Quicken file first --- In Quicken validate first followed by create copy, followed by validation of that copied file and continue doing so until no errors are in the file for at least two rounds. - Don't try to export/import anything other than transactions from Quicken (exception below). - Reset your security price history if you can as event (buy, sell, etc.) related prices will come over no problem. You can always import historical prices into GNC by other means afterwards. - Create your account hierarchy manually in GNC or by other means before importing (I did not go with the method of account list export from Quicken and import it into GNC so YMMV). - Import securities as part of the import as-is, bulk create them during import and then modify after all transactions have imported correctly. - Order of export/import to maintain: largest to smallest account size with investment account first, banking accounts second, and lastly credit card and/or loan accounts. If you can break it up into smaller chunks (one year worth then better, or best is to create a year-end file in Quicken and then perform import from that new year file with this stated order) - Export one account at a time from Quicken then import that single account into Quicken; never export all accounts in one qif file! Follow Liz's divide-&-conquer (binary split) approach on fixing a qif file if it errors out but don't change the order from what is mentions in the previous step. - Make a backup copy every time an import has worked. This will allow you to go back if there is large set of incorrect import on the next account without the loss of work up to the point it has worked. This will let you build upon it until all have been moved over. - Don't expect everything to look correctly after import is completed. In GNC transactions, account and many other things can be moved around and re-parented without much complex work that otherwise would be needed in Quicken so get transactions over into an accounts in GNC and move on to importing/exporting next account. - Pay attention to the way dates are formatted for years before 2000, and years 2000 and after if you are on Windows Quicken. Make them consistent (programmatically) before importing them if you see them differently formatted. GNC likes only one and consistent format throughout qif file. Hope this helps. -- Message: 10 Date: Sun, 22 Jan 2023 10:22:10 -0500 From: jhoe...@googlemail.com To: Subject: Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account" Message-ID: <077d01d92e75$4c72bee0$e5583ca0$@gmail.com> Content-Type: text/plain; charset="us-ascii" Good idea! Thanks, Jan -Original Message- From: gnucash-user On Behalf Of Liz Dodd Sent: Saturday, January 21, 2023 4:14 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account" On Sat, 21 Jan 2023 09:12:23 -0500 Jan via gnucash-user wrote: > I do have 20+ years of Quicken 2002 data (German Version), but only > tried to upload 2022 to GnuCash via a QIF down-/upload. It ends > abruptly (program vanishes completely) at the import step. The last > message I see on the screen is "Transaction with no or only one > associated account". One method of approaching this is the binary split method. Instead of all 2022, split it into two parts, try importing one. If it fails, ignore it, and try the other one. Split the one that fails... Repeat until you find the problem, then deal with the problem. We do suggest importing small files sequentially to train the importer, so you may choose to stick with small files until 2022 is finished. Liz ___ 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. -- ___ 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 upload ends abruptly at import step, last message "Transaction with no or only one associated account"
Good idea! Thanks, Jan -Original Message- From: gnucash-user On Behalf Of Liz Dodd Sent: Saturday, January 21, 2023 4:14 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account" On Sat, 21 Jan 2023 09:12:23 -0500 Jan via gnucash-user wrote: > I do have 20+ years of Quicken 2002 data (German Version), but only > tried to upload 2022 to GnuCash via a QIF down-/upload. It ends > abruptly (program vanishes completely) at the import step. The last > message I see on the screen is "Transaction with no or only one > associated account". One method of approaching this is the binary split method. Instead of all 2022, split it into two parts, try importing one. If it fails, ignore it, and try the other one. Split the one that fails... Repeat until you find the problem, then deal with the problem. We do suggest importing small files sequentially to train the importer, so you may choose to stick with small files until 2022 is finished. Liz ___ 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. ___ 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] Entering Dividend Confusion
Hi, On Sun, January 22, 2023 7:31 am, xboxboy.mageia+GnuCash wrote: > Thank you to all who have replied. > > I attempted to enter a split transaction in the 'dividend' income page, > and then it vanished: I found it had transferred to the company stock > tab: It appeared to be correct, and the amounts ending up in the correct > accounts :) The reason it "vanished" was because you had no splits tied to the open account. So there was nothing holding it to the current view. > > So I was able to enter ALL the data for that stock, and then I was even > able to enter the final sale and scrub the account correctly. > > I can not express how WILD, FRUSTRATED and angry I was with myself. But > it's now done, and I can always refer to that as a template/transaction > to copy. > > Is there a function to 'lock' an account so it can no longer be edited > accidentally? Yes. Mark the account as "placeholder" and you won't be able to add any transactions or otherwise edit the contents of the account. > > Thank you everyone, I really, really appreciate your patience and help. You're welcome. Happy Gnucashing! -derek > On 22/1/23 18:57, Maf. King wrote: >> On Sunday, 22 January 2023 04:50:47 GMT xboxboy.mageia+GnuCash wrote: >> >>> Thanks: Now which page/account/ledger do I do this on? The dividend >>> income one? the company dividend income one? the company stock one?? >>> >> When the dividends are being reinvested automatically, I enter the >> transaction >> in the relevant stock account. I just find it easier to see with the >> number/ >> price/value boxes in front of me. >> >> Instead of the usual approach of the cash to buy the shares being >> transferred >> from Assets:Bank, just transfer from Income:dividend[:etc] and also if >> requited ensure you have the split to show the tax credit too. >> >> HTH, >> Maf. >> >> >> >> ___ >> 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. > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Morgan Stanley Portfolio
Morgan Stanley is running an OFX server. I'd see if I could get online banking to connect with it and download that. I haven't tried it as I don't have an account there, but I think all the info you need to set it up is here: https://www.ofxhome.com/index.php/institution/view/500 I was able to download the profile with ofxget from ofxtools and it promises to support investments. Good luck, Steve On Sun, 2023-01-22 at 06:29 -0500, Ed Greenberg wrote: > I have a portfolio at Morgan Stanley which generates some dividends, > income, cap gains distribution, etc. All sorts of odd transactions. > MS > does not offer a QFX/OFX, but only an excel download which is > inadequate > for import. Near as I can tell. > > Does anybody have suggestions for interacting with Morgan Stanley? > > I'm considering writing a transformation program that will read the > csv > and rewrite it in a more importable set of csv columns. Or just > biting > the bullet and keying it all in manually. > > On the other hand, what procedures have people developed to track > just > the asset value of the entire portfolio and update it each month? > > Thanks, > > Ed Greenberg > > > ___ > 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. ___ 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] Entering Dividend Confusion
Thank you to all who have replied. I attempted to enter a split transaction in the 'dividend' income page, and then it vanished: I found it had transferred to the company stock tab: It appeared to be correct, and the amounts ending up in the correct accounts :) So I was able to enter ALL the data for that stock, and then I was even able to enter the final sale and scrub the account correctly. I can not express how WILD, FRUSTRATED and angry I was with myself. But it's now done, and I can always refer to that as a template/transaction to copy. Is there a function to 'lock' an account so it can no longer be edited accidentally? Thank you everyone, I really, really appreciate your patience and help. On 22/1/23 18:57, Maf. King wrote: On Sunday, 22 January 2023 04:50:47 GMT xboxboy.mageia+GnuCash wrote: Thanks: Now which page/account/ledger do I do this on? The dividend income one? the company dividend income one? the company stock one?? When the dividends are being reinvested automatically, I enter the transaction in the relevant stock account. I just find it easier to see with the number/ price/value boxes in front of me. Instead of the usual approach of the cash to buy the shares being transferred from Assets:Bank, just transfer from Income:dividend[:etc] and also if requited ensure you have the split to show the tax credit too. HTH, Maf. ___ 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. ___ 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] Morgan Stanley Portfolio
I have a portfolio at Morgan Stanley which generates some dividends, income, cap gains distribution, etc. All sorts of odd transactions. MS does not offer a QFX/OFX, but only an excel download which is inadequate for import. Near as I can tell. Does anybody have suggestions for interacting with Morgan Stanley? I'm considering writing a transformation program that will read the csv and rewrite it in a more importable set of csv columns. Or just biting the bullet and keying it all in manually. On the other hand, what procedures have people developed to track just the asset value of the entire portfolio and update it each month? Thanks, Ed Greenberg ___ 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] Entering Dividend Confusion
On Sunday, 22 January 2023 04:50:47 GMT xboxboy.mageia+GnuCash wrote: > > Thanks: Now which page/account/ledger do I do this on? The dividend > income one? the company dividend income one? the company stock one?? > When the dividends are being reinvested automatically, I enter the transaction in the relevant stock account. I just find it easier to see with the number/ price/value boxes in front of me. Instead of the usual approach of the cash to buy the shares being transferred from Assets:Bank, just transfer from Income:dividend[:etc] and also if requited ensure you have the split to show the tax credit too. HTH, Maf. ___ 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.