General Cleanup Questions
My pilgrimage to Moneydance from Quicken is almost complete. It's taken a few attempts over a couple of year end headaches with Quicken to get here.
I have 31 years of quicken data that I would like to bring across. For the most part things look good now that I've eliminated most of the obvious one-sided transactions, but I still have some messiness left that I'm seeking some advice on.
Investments seem to be my remaining large headache.
1) Securities are showing up in the category list.
- I have traced this to first time security adds when I set up quicken. For example, I already owned a couple of CD's and I added them as securities into quicken. Now that they are in MD, the show up as BuyXfr, Security = CD#123, Transfer = CD#123, Category = <none>. I realize that I need to assign a category, but I'm not sure what category I should assign this too. Is the best thing to create a category called Existing Holdings and simply assign everything there? Most accounts can be set up with an initial balance but I need to add the balances for multiple securities.
2) Is there a way to pop out a separate register view for individual transactions (formatted a little prettier)? I find the double line entry view to be a little confusing especially since Action and Check # have some strikingly similar values (e.g. DivReinvest and ReinvDiv). Not sure which one is actually the one that matters...
3) My Investment accounts don't seem to have the option a parent account. Normal?
4) Some investment accounts look to have sub-investment accounts (indented in the left window), but have no parent option and they are also securities that are contained within. The ending balance is correct - but the portfolio view values are totally whacked. Any suggestions as to what I might be looking for here? I mean one of the accounts has a 55 million dollar transaction in it. Would be super nice if it were real, but it's not.. :(
5) all the account start dates are import date as opposed to first transaction date. Any impact or cosmetic only?
6) Single investment accounts - I have a couple of IRA accounts from a 401k rollover, and the IRA accounts are one account=one security. Looks like some of my balances are hosed because movements between accounts didn't come across correctly. Which is odd, because the transaction looks ok on the quicken side. e.g. sell 100 share of ABC for $1 each, then transfer $100 dollars to the other IRA account and buy 50 shares of DEF for $2. They came through to MD twice. Once as a BuyXfr with shares and price and once as a simple Xfr with a dollar amount. I don't seem to see a difference in investment account types between a single security no cash balance and a 'normal' account that holds multiple securities and a cash balance. Just want to confirm this before I start blowing away transactions.
That's enough for now, I'm sure more questions will appear.
Thanks in advance.
Comments are currently closed for this discussion. You can start a new one.
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac
1 Posted by Stuart Beesley ... on 16 Jan, 2023 06:02 PM
BuyXfr does NOT have a category field... It's should be greyed out... There is only the transfer field and the FEE category if there was a fee..? When you say "I need to add the balances for multiple securities", what do you mean..? Do you mean to setup the initial security holding qty for each security..? If so, then BUY or BuyXfr is the correct method (using the cost basis as the total)... Best bet is to create a JUNK category that you exclude from all reporting and transfer the cash in from that JUNK category..
flip to the Securities Detail screen in the investment account.. Then select the security.. On the left is a mini register. Action names should all be the same.. Check numbers do NOT matter in the slightest..
Correct.. all investment accounts are attached to the internal ROOT account.. They cannot have (user) sub accounts...
Correct... all investment accounts have a sub account for each security held in that investment account.. This is system driven. You will need to supply more info about the 55 million... Best bet... Extension, extract_data: option: extract investment transactions... open in excel. Do some digging in there for the errant values.
kind cosmetic... but why not just change them..?
When I originally converted from Quicken I remember that MD created a SellXfr from one account to a category and then a BuyXfr in from the category... I manually when through them all and changed them to SellXfr with the category set to the target account and then a Buy (both using the correct cost basis)..
2 Posted by netr@cer on 16 Jan, 2023 06:46 PM
Thanks for the reply Stuart, helps a ton.
Re 6, normally I'd agree with that approach, but that assumes the account is able to hold a cash balance. These particular accounts with the investment house are not permitted to have a cash balance and I recall a problem setting them up online in quicken when they were traditional investment accounts and I had to switch them to the type that wasn't allowed to have a cash balance.
In MD, I don't seem to see a way to make a single transaction on each side of the account. SellXfr appears as a Xfr of cash in on the receiving account and I can't find a way to directly buy shares within the xfr on the receiving end, nor will it change to BuyXfr. In quicken single fund accounts automatically created a boughtx on the receive side with a share and price.
Is there a type of investment account in MD that is not permitted to have a cash balance?
3 Posted by Stuart Beesley ... on 16 Jan, 2023 07:02 PM
Remember, in MD it doesn't care if you can't really hold cash.. This is just a transitory txn to allow you to make the MD buy..
There is no single transfer txn type - e.g. Sell/Xfr and Buy/Xfr linked pair.. You have to do either
Sell/Xfr and then Buy or
Sell and then Buy/Xfr.
On your last txn - NO.. Just don't put cash in there and keep the cash at zero..
4 Posted by netr@cer on 16 Jan, 2023 07:14 PM
got it thanks. Hopefully online sync will still work with this (fingers crossed)
Also, only some investment accounts have 'sub accounts' indented under them in the left window. And thoughts as to why only some of the securities in some of the accounts might be triggering this?
Aggressive Age Based
Moderate Age Based
Aggressive Age based
Moderate Age based
Billy has the same securities as John and Joe but they don't appear like sub accounts...
5 Posted by netr@cer on 16 Jan, 2023 08:19 PM
and an additional question. Securities seem to come across missing everything except the full name. For example.
Security ID: ^WALT DISNEY-DISNEY C
Security Name: WALT DISNEY-DISNEY C
Ticker Symbol: ^WALT DISNEY-DISNEY C
Value Prefix: blank
Value Suffix: ^WALT DISNET-DISNEY CShares
Is there anything I can do to make the import better (specifically retaining tickers)?
Or do I just need to suck it up and redo all of my securities?
And perhaps a description of the proper use of value prefix and value suffix? Looks like it can be used for options and the like, but how?
6 Posted by Stuart Beesley ... on 16 Jan, 2023 09:06 PM
Ah. You mean the left side bar. Qif imports sometimes add these. Don’t worry. Just remove all the sub accounts from the side bar. If you look in tools/accounts then you will see all the sub accounts.
7 Posted by Stuart Beesley ... on 16 Jan, 2023 09:07 PM
Prefix and suffix are purely for reporting and cosmetic. Set however you like.
8 Posted by Stuart Beesley ... on 16 Jan, 2023 09:08 PM
As for names in import. Dunno. Just manually edit them afterwards.
netr@cer closed this discussion on 22 Jan, 2023 07:20 PM.