This post has been closed and is not open for comments or answers.
Quicken Community Home Page

TD Ameritrade Deposit

I just ACH funds into my TD ameritrade account.  The funds are showing up now, however it says unidentified security w/ 26,730 shares.  I deposited 27,000 cash, I have not bought any shares yet.  I just deposited cash into this account.I am new to Quicken and trying to figure out what I need to do here.  I am sure it is something I am doing wrong, since I am new to this.  Help is appreciated.
    Quote:" TD Ameritrade Deposit: I just ACH funds into my TD ameritrade account.  The funds are showing up now, however..."I'll suggest the first thing to do is clarify some language._ What you have done in the real world and what you have done in Quicken are not apparent from your first message._ What is clear (I think):_ in the real world you had your bank transfer $27K to your TDA account._ "The funds are showing up now"_ Showing up where?_In Q, on your TDA statement/website?"however it says unidentified security w/ 26,730 shares"_ What 'it' says?_ Quicken?_ How has Quicken learned any of this?_ Downloads from TDA?What is your setup with TDA?_ Do they automatically purchase money-market shares with all available cash (a sweep account)?_ What does your TDA account statement/website say about the 26,730 vs. 27,000?A lot more info will help get you a clearer answer._
      Quote:" TD Ameritrade Deposit: I'll suggest the first thing to do is clarify some language._ What you have done in the..."Your right I should have been alot more specific when explaining my issue.  As I am sure you can tell I am new to Quicken, and trying to rapidly ramp up my knowledge level.You are correct that I did transfer $27K from my bank account to my TDA acct(Real World).  Now when I log into my TDA acct my money is deposited in a Money Market Deposit Account (MMDA).  When I go and look at the transactions for the account I see the following:07/23/2007  19:48:07   CLIENT REQUESTED ELECTRONIC FUNDING RECEIPT (FUNDS NOW) Amount   Net Cash Bal.27,000.00 $27,000.00    07/24/2007  03:02:04 MONEY MARKET PURCHASE Amount   Net Cash Bal.-27,000.00 $0.00    07/24/2007  03:02:19 MONEY MARKET PURCHASE (MMDA1) Amount   Net Cash Bal.0.00 $0.001.  I can see the $27K coming into the TDA acct as cash.2.  Then that cash being used to buy $27K into the MMDA3.  Then see the cash balance going to zero.Now when I go to Quicken (program world) and look at my TDA acct there on the Summary Tab I see on the 1st line Name = Unidentified Security, Shares = 26,7302nd line Name = Cash, Market Value 27,000, Cost Basis 27,000When I go to the Transactions tab in Quicken I see the first entry as Misc. Income @ 27K.Then a place holder entry for Unidentified Securitys @ -270 shares.Then a +27,000 Cash Amount making my balance $54,000Then a buy for Unidentified Security 27,000 sharesThen the following line says cash amount -27,000 and the cash balance says 27,000So from all that I have a few questions:1.  When I look at my TDA acct I can not find anything in regards to 26,730 shares that Quicken is reporting on my Summary tab.2.  How the heck do I get to a cash balance of 54,000?I just want to get this account rectified and looking exactly how it does in TDA.  Can someone please help me.  I hope this is enough detail to elicit some help.  Please let me know if I need to provide anything else to help someone give me assistance.I have also added screen prints of my Summary and Transaction Tabs
        Quote:" TD Ameritrade Deposit: Your right I should have been alot more specific when explaining my issue.  As I am..."That hlps greatly and although this is not my area of expertise, I'll offer some thoughts._ 1)_ Did you enter a transaction (or adjust a downloaded transaction) moving the 27K from your bank to the TDA account?_ I notice you have 2 trasnactions adding 27K to the TDA account on two separate days._ The latter one is cleared, the first one is not._ I am guessing that the first was a transfer from your bank account_ the second was downloaded from TDA and_did not match to the first transaction as it should have._ Thus 54K of deposits instead of only 27K.2) I suggest you talk to TDA (or perhaps another client will chime in here or maybe there are other relevant comments about TDA in other posts) about how they download data._ It seems they are feeding you rather sloppy data._ The opening -270 placeholder suggests that your MM fund was 'overdrawn' (sold short?) to begin with._ Seems really unlikely to me._ Then later you have the Bought 9ZZTD109 which in reality is (or should be) the purchase of the MM fund.3) You need to be clear in your own mind what is really taking place and be willing to clean up after TDA if they give you garbage._ My suggestion is that you need to create the MM fund (MMDA1?) separately from the downloaded data._ All that you really need in your register at this point relative to these transactions is the transfer of 27K from bank to TDA (the first register entry?) and one purchase of 27,000 shares of MMDA1 at $1/share._ Good luck
          Quote:" TD Ameritrade Deposit: That hlps greatly and although this is not my area of expertise, I'll offer some thoughts._ ..."Tod:I'm going to reply to you instead of the original poster because I do not have the downloading expertise._ I do however have a TD Ameritrade account with a money market account._ The money market account that I have with TD Ameritrade is through a third party that they use._ The name of the financial institution is "The Reserve."I enter all of my TD Ameritrade transactions manually._ The primary problem, if I am understanding everything correctly, is that Quicken allows only ONE linked cash account and in this real world example we are dealing with TWO accounts._ The money is transferred from an external source by ACH into the CASH account at TD Ameritrade._ TD Ameritrade has two available "Money Market" accounts (distinct from their Cash account) that can be used by their customers_ the one that the poster mentioned and the one I just mentioned._ Both of these are optional._ Normally, cash would just sit in the Cash account and would not earn interest._ I don't know the details about the money market account that the poster has, but the money market account that I have "The Reserve," acts like a sweep account.Any cash I have at "The Reserve" is immediately available to me, either to transfer (ACH) to an external account or for the purchase of securities._ When I sell securities, the proceeds are first shown as CASH and then automatically transferred to "The Reserve."_ The problem arises with Quicken because of the restriction of a single linked cash account._ This situation is one of the few times in my long experience with Quicken where I have been unable to match the "Real World" with that of Quicken.I hope this will help you in trying to assist the original poster with the associated downloading issues._ I will try to keep my eye on this thread._ Email notifications have_not been very reliable._
            Quote:" TD Ameritrade Deposit: Tod: I'm going to reply to you instead of the original poster because I do not have..."iiimaf: That is exactly the sort of TDA-specific relevance that I lack and that the OP needs to understand._ As you mention this, I recall prior threads on just these sort of issues (mblanco2000 should search them out)._ Certainly for some brokers and situations (and this may be one) manual entry is the most prudent approach._ I too am old enough in_Quicken-years _that I remember when manual entry was the only option._ It still offers a very reliable quality-control approach that has much going for it.I don't see the linked cash accounts as a particular issue in this thread at this time._ That too is a Quicken-feature I avoid as unnecessary to my financial management._
              Quote:" TD Ameritrade Deposit: iiimaf: That is exactly the sort of TDA-specific relevance that I lack and that the OP needs..."The only issue I see with the linked cash account is one that I don't fully understand because I don't download._ Since I understand the problem (Quicken only allows one linked cash account) I deal with it by simply ignoring my money market account (The Reserve) in Quicken.At the end of every month, my TD Ameritrade statement shows a dividend for_my balance in The Reserve._ I simply enter this transaction as a DivX to the linked CASH account I have with_TD Ameritrade._ My statements usually show a zero balance in my CASH account unless I make a trade at the end of the month._ For reconciliation purposes I just add the cash balance and The Reserve balance shown on the statement and compare it to_the linked Cash Balance in Quicken._ If they match and they always do, I'm reconciled as far as the cash and money market accounts are concerned.Another thing comes to mind with respect to this money market account at TD Ameritrade._ The Reserve accrues_and POSTS_the_dividends daily._ Since I don't download, I have no idea how this_is handled by TD Ameritrade._ When I log on to my account, I see a Cash Balance and_a Money Market Balance._ Because The Reserve accrues daily, this balance is different every day._ I only post the dividends at month end._ I wonder how TD Ameritrade handles this for someone who downloads transactions._ On my monthly statement there is one transaction for the dividends, but the_balance in The Reserve changes daily._ I've never asked the question to TD Ameritrade, but I suspect that even though The Reserve accrues and posts dividends on a daily basis, TD Ameritrade only posts them monthly._ So, like the broken analog watch that is right twice a day, Quicken and TD Ameritrade are right once a month.
                Quote:" TD Ameritrade Deposit: That hlps greatly and although this is not my area of expertise, I'll offer some thoughts._ ...""All that you really need in your register at this point relative to these transactions is the transfer of 27K from bank to TDA (the first register entry?) and one purchase of 27,000 shares of MMDA1 at $1/share."That was my interpretation too.My guess is that part of the problem may lie in the Quicken new account setup process (I'm assuming op just_created the account and allowed Quicken to handle all the setup automatically, including initiating the first download)._ In some of my tests, I have noticed some odd results when Quicken automatically does the first download to a new Quicken account, including_automatically entering all the downloaded_transactions into the account and_the automatic entry of placeholders where they aren't truly needed, but where Quicken seemed to have a problem identifying one or more of the "new" securities being downloaded._ The un-needed_placeholder problem_could be caused by the fi not supplying some info correctly ... I never really tried to look that deeply into the problem.I never let Quicken setup an account for me, and I try to do some minimal preparation before "activating" a new Quicken account for download.__For one thing,_I enter a dummy transaction (in addition to any "opening balance" transaction that might be present)_in the account so Quicken will not treat the account as empty and I will then get to process/accept each downloaded transaction individually.
                  Quote:" TD Ameritrade Deposit: The only issue I see with the linked cash account is one that I don't fully understand...""The Reserve accrues_and POSTS_the_dividends daily".I believe you have hit upon the source of the $270._ I have a similar situation with Smith Barney.Smith Barney accrues interest on my mm fund there daily, and when I download, Smith Barney downloads the "current balance" (the one that includes the accrued interest) in the holdings area of the download._ But Smith Barney does not download any transactions that would account for that accrued interest._ So every day except the last day of the month, Smith Barney's downloaded holdings for the mm fund are greater than the sum of the transactions for the mm fund that have been downloaded._ So I am always asked if I want to accept a placeholder for that difference_ I always say no.But if the very first download to the account does not give the user the opportunity to reject a suggeseted placeholder, I think one could wind up with an unwanted placeholder for the month's accrued interest.
                    Quote:" TD Ameritrade Deposit: "The Reserve accrues_and POSTS_the_dividends daily". I believe you have hit upon the source of the $270._ I..."Depending on whether you finally determine this to be the problem, I'm glad I was able to help in some small way._
                      Quote:" TD Ameritrade Deposit: Depending on whether you finally determine this to be the problem, I'm glad I was able to..."iiimaf,Sorry for the slow response.  I have been out of the country, with no internet connection.  By looking at your experience with Quicken and TD Ameritrade, I would like to follow suit with yourself in the methods that you use to get your account information.Instead of downloading my TDA account information, How would I do this manually properly.  I can look at the History and Statements page on my TDA acct., and copy the transactions from there into Quicken.  I am just wondering what I need to do to make sure this acct reflects correctly in Quicken.  I am just very new to Quicken and any help is appreciated.
                        Quote:" TD Ameritrade Deposit: iiimaf, Sorry for the slow response.  I have been out of the country, with no internet..."mblanco2000:Let me look at your prior posts again and put some suggestions together._ I will post back later today.
                          Quote:" TD Ameritrade Deposit: iiimaf, Sorry for the slow response.  I have been out of the country, with no internet..."Just for the record, you have said that you are a new Quicken user, but you haven't indicated how long you have been a TD Ameritrade client._ Do you currently have investments with TD Ameritrade in addition to the $27,000 in question?As I said in my prior post, I will be back later this afternoon with some suggestions.
                            Quote:" TD Ameritrade Deposit: Just for the record, you have said that you are a new Quicken user, but you haven't..."Within TDA I have 3 different accounts.  One IRA, One Rollover Acct, and this acct that we are currently talking about.I figure if I can get the one in question corrected, I can follow suit with the other two accts.  The acct. that we are talking about is a new acct and the transactions that are posted are the only transactions thus far, except for a one time purchase of securities about two weeks ago.
                              Quote:" TD Ameritrade Deposit: Within TDA I have 3 different accounts.  One IRA, One Rollover Acct, and this acct that..."First things first._ Since the TD Ameritrade brokerage account is new, I would start by deleting all of the transactions in the register._ It would also be a good idea to re-read my original post and the comments to it._ If, as I suspect, your MMDA account works like my sweep account, the following should help you get things going.The next thing you need to do is check that you have the TD Ameritrade Brokerage account setup properly._ It should have a linked cash (checking) account._ From what I see in the attachments you posted earlier, you do not have the TD Ameritrade account setup properly because there is a cash balance column in the brokerage account register._ You can create a cash account by clicking on TD Ameritrade in the Investing Center which is part of Quicken's Account Bar and by default is on the left hand side of the screen._ Then click on the Summary Tab and look for the Account Attributes Box._ Click on Edit Account Details._ In that dialog box you should see Show cash in a checking account._ At this point, the No radio button should be selected._ You will want to click the Yes radio button next to Show cash in a checking account and then click OK._ Quicken will stop in its tracks and insist that you back up your fileset._ Do it._ Once your fileset has been backed up, Quicken will create a new cash (checking) account for you in the Cash Flow Center._ Since you said you want to go to manually entering transactions, while your here in the Account Attributes you can also de-activate Online Services._ Click on Change Online Services and de-activate the account.The next thing that you need to be aware of is how to interact with the two TD Ameritrade accounts._ Virtually every transaction that you enter will be entered in the register for the brokerage account._ They will be BoughtX, SoldX, DivX, IntIncX, etc._ The "X" indicates transfer either to or from the cash account._ There are other actions that will occasionally take place like a Stock Split (StkSplit) but most of the actions you will use have the appended "X."_ At the moment, I can only think of one reason why you would enter a transaction directly in the TD Ameritrade Cash (Checking) account and that would be when you externally move money into or out of the cash account._ If anyone can think of other reasons, please sound off.I'm using the register that you attached earlier to get you going on the transactions that need to be re-entered._ At this point the TD Ameritrade register should be empty._ Go to the account (probably a money market account or your checking account) that you used to fund the initial deposit at TD Ameritrade._ On the register's menu, click Transfer and then fill out the transfer dialog information._ The To Account: will be TD Ameritrade-Cash, (or the name you gave it) the Date: will be the date of the ACH, the Description: is up to you, (Initial Funding for example) and the Amount: will obviously be $27,000._ Click OK._ Your funding account is now $27,000 lighter and the TD Ameritrade-Cash account has the money._ The rest of the transactions have no relevance because Quicken can only deal with a single linked cash account._ More on this in a minute.As I said in an earlier post, my sweep account at TD Ameritrade is not the same as yours._ You are using the Money Market Deposit Account (MMDA) and as I said, I am not familiar with the specific workings of this account, but for now let's assume that it works the same way._ After you understand what's going on from what I'm contributing, it would be a good idea to call TD Ameritrade and check to see that the MMDA account works as I have assumed.Continued
                                Quote:" TD Ameritrade Deposit: First things first._ Since the TD Ameritrade brokerage account is new, I would start by deleting all..."Continued from Above:OK, what happened to your money?_ Your $27,000 ACH initially got deposited in your "Cash" account at TD Ameritrade._ A couple of days later, the money was transferred from your "Cash" account to the MMDA account and as part of this transfer probably a "Buy" of 27,000 shares of the MMDA at $1.00 per share was made._ As long as the money (shares) remain in the MMDA account you will earn interest and will see that interest on your monthly TD Ameritrade Statement._ Your statement for July is now available on line and will show in the Account Activity Section your interest for the month as Div/Int - Interest Credit Payable 07/31/2007 then the amount of interest and then the balance in your cash account.To enter this amount in Quicken, click on the TD Ameritrade brokerage account and then click on the Transactions tab if you aren't already there._ Enter 07/31/2007 and then click the arrow in the "Action" dropdown box and select "IntIncX" then click into Security and click on the dropdown arrow._ Click on Add new security._ There isn't a Ticker Symbol so just enter TD Ameritrade - MMDA for the name and then uncheck "Include this security on my watch list."_ Click Next._ Click "Add manually, enter Other for Security Type and click Next._ Single "Unclassified" if fine, click Done._ Click on the Amount and fill it in._ If you want, enter a memo and then click Enter._ The entry is made in the brokerage register but the deposit shows up in the TD Ameritrade-Cash account._ If you ever need to edit an entry, REMEMBER to edit it at the source, the brokerage register, not in the linked cash account.I think the reason for the problems with Quicken and the single linked cash account should be clean at this point._ This is one of the few places where Quicken cannot mirror the real world and we just have to deal with it._ As long as you properly work with the single cash account as suggested above, your cash balance will be correct._ Unless you trade frequently, the "Cash" Balance reported by TD Ameritrade will usually be zero._ The "MMDA Balance" at TD Ameritrade will equal your Quicken TD Ameritrade-Cash balance._ If it's not zero, the sum of the TD Ameritrade "Cash" and your MMDA should equal your Quicken TD Ameritrade-Cash account.When you buy a security the money will immediately be transferred out of the MMDA account and will be used to cover the purchase._ In Quicken you would enter a "BoughtX" to record the purchase in the TD Ameritrade brokerage account and Quicken will reduce the linked cash account accordingly._ When you sell a security at TD Ameritrade, the proceeds will make a first stop in your "Cash" account._ A day or two later these funds will be transferred to your MMDA._ In Quicken you would enter a SoldX to record the the sale in the TD Ameritrade brokerage account and Quicken will increase the linked cash account accordingly.I think this should get you going._ If you have any other questions post back.
                                  Quote:" TD Ameritrade Deposit: Thank you so very much for your detailed response.  So for each TDA acct. I need..."Thank you so very much for your detailed response.  So for each TDA acct. I need to make sure I have a linked cash acct, or would I use this same Cash acct for the other TDA accts.  I would assume that I would need to create a separate cash acct. for each TDA acct.Also I went back and read all the comments and then closely read the latest posting on instructions on how to properly setup my acct. for manual transactions.  First, I deleted all the transactions in the TDA acct.  So I then added the Linked Cash acct, and deactivated the online updates.  I went to the register from the originating checking acct and did the transfer to the linked cash acct. as you stated my checking acct. was 27K lighter and 27K was showing in the TDA Cash Acct.Ok this is where I mess up somehow.  When I go to the TDA brokerage acct. to enter the ?IntlncX? into the register and add all the details the 27K shows up in the TDA Cash acct. like you say.  So now I have 54K there in this cash acct. one being the original transfer from the Checking then the action in the brokerage acct ended up putting 54K in that Cash acct.  I wish I had 54K in there, but am wondering how I get this adjusted correctly.  I am sure it is something I am not doing correctly.  Thank you so much for helping me out with this.
                                    Quote:" TD Ameritrade Deposit: Thank you so very much for your detailed response.  So for each TDA acct. I need...""Thank you so very much for your detailed response. So for each TDA acct. I need to make sure I have a linked cash acct, or would I use this same Cash acct for the other TDA accts. I would assume that I would need to create a separate cash acct. for each TDA acct."No, not necessarily._ The only reason I_use a linked cash account with my TD Ameritrade brokerage account is for the perceived amount of additional exposure I get from it._ Although I don't use the account as a checking account (and I'm not even sure TD Ameritrade permits this) that would be another reason to do so._ I'm not a day trader by any stretch, but I do have 5 - 6 ACH's per month into or out of the cash account._ A linked cash account is in no way necessary to accomplish what you want to do and I apologize for not making that clear in my last post._ I explained what I do without giving my reasons or providing instructions for the alternative which is simply using the cash balance that comes with any Quicken investment account._ If you look back in this thread, Tod_commented that he basically thought linked cash accounts were unnecessary to his use of Quicken.I have both a Traditional IRA and a Roth IRA._ Neither of these accounts have a linked cash account because the number of external cash transactions are minimal."Ok this is where I mess up somehow. When I go to the TDA brokerage acct. to enter the ?IntlncX? into the register and add all the details the 27K shows up in the TDA Cash acct. like you say. So now I have 54K there in this cash acct. one being the original transfer from the Checking then the action in the brokerage acct ended up putting 54K in that Cash acct. I wish I had 54K in there, but am wondering how I get this adjusted correctly. I am sure it is something I am not doing correctly."I'm_confused by these comments.__The_interest shown on your July 31st statement_and any trades you made during the month are the only things you should be adding at this point._ The cash has already been transferred from your checking account._ In a normal month, once you get up and running, you would have entered stock trades as they occurred and the statement would be a second confirmation of these trades._ If you entered the $27,000 again from the statement, delete that transaction._ If that's not what's going on, please post back._
                                      Quote:" TD Ameritrade Deposit: "Thank you so very much for your detailed response. So for each TDA acct. I need to..."Tod,Rather than having a linked cash account, can't the op just set up a money market fund within the account to keep track of their cash?In my own personal case, I found a linked cash account very cumbersome and limited in its use._ I finally changed to a money market fund within my account, removing the linked cash account._ It is much easier to implement for buys and sells.
                                        Quote:" TD Ameritrade Deposit: Tod, Rather than having a linked cash account, can't the op just set up a money market..."You replied to me but you addressed the reply to Tod._ Confused as usual, but you did manage to up_your POST COUNT.Also, it appears that you haven't bothered to read much of this thread._ The money market in question is a sweep account that only earns interest._ The purchase of securities in this type of_account is not possible.
                                          Quote:" TD Ameritrade Deposit: You replied to me but you addressed the reply to Tod._ Confused as usual, but you did..."It was just a suggestion, not a request.Sorry about the mislabeled addressee.
                                            Quote:" TD Ameritrade Deposit: "All that you really need in your register at this point relative to these transactions is the..."iiimaf, John and gmalis1,Thanks for your detailed responses.  I have gone back and read and reread your posts.  I just posted the interest received from my TDA cash acct into my TDA brokerage acct. and everything seems to be working just fine.  However, I do not do that many ACH transfers, and as you iiimaf said it is unnecessary to have a linked cash acct. if your external money transfers are minimal.So what I would like to figure out is how to just have my cash in my existing brokerage acct.?Tod's earlier post said, 'i'"My suggestion is that you need to create the MM fund (MMDA1?) separately from the downloaded data.  All that you really need in your register at this point relative to these transactions is the transfer of 27K from bank to TDA (the first register entry?) and one purchase of 27,000 shares of MMDA1 at $1/share." That is what I am trying to figure out how to do...
                                              Quote:" TD Ameritrade Deposit: iiimaf, John and gmalis1, Thanks for your detailed responses.  I have gone back and read and..."Where do you "park" your cash from your investments?I seriously doubt that your brokerage company has it just laying around._ Wherever your brokerage company has your cash, simulate your real life accounts._ I would assume that this cash is in a money market account (sounds like your TDA cash account is a money market account).You can do one of two things:1 Leave the cash as a cash balance in your investment account2 Create a security for the money market account at $1 per share (which should rarely, if ever, change)._ Then purchase "shares" for each dollar you have in the money market._ Sell shares of the MM and buy securities, or sell securities and buy shares of the MM.The only sticky point I could see is if you use the ONE TDA cash account to fund_MULTIPLE investment accounts._ In that case I would create a TDA cash investment account, then transfer cash in/out of as needed.Almost everyone on this forum advocates replicating your real life situation._ Try to emulate that.
                                                Quote:" TD Ameritrade Deposit: iiimaf, John and gmalis1, Thanks for your detailed responses.  I have gone back and read and..."Mblanco2000:<STRONG>"So what I would like to figure out is how to just have my cash in my existing brokerage acct.?"</STRONG>You can eliminate the linked cash account we created by reversing the steps we took to create it._ Click on your TD Ameritrade brokerage account in the Investing Center which is part of Quicken's Account Bar and by default is on the left hand side of the screen._ Then click on the Summary Tab and look for the Account Attributes Box._ Click on Edit Account Details._ In that dialog box you should see Show cash in a checking account._ At this point, the Yes radio button should be selected._ Click the No radio button next to Show cash in a checking account and then click OK._ Quicken will stop in its tracks and insist that you back up your fileset._ Do it._ Once your fileset has been backed up, Quicken will_delete the_linked cash (checking) account from_your TD Ameritrade brokerage account._ When you click back into the TD Ameritrade brokerage account you will_notice that it_now has the Cash Balance column again.I'm pretty sure that Tod will agree, at this point, that you do not want to mess around with the suggestion of his that you just quoted._ Since you are just getting started with Quicken, you are missing the problem that arises if you were_to do so._ A cash account in a brokerage account has one primary purpose, it accumulates cash._ When you sell securities the cash account is where the proceeds go and when you buy securities it provides an immediate_way to fund the purchase.The problem here is that you have TWO cash accounts with TD Ameritrade, their normal cash account that pays <STRONG>NO</STRONG> interest and the MMDA which <STRONG>Does</STRONG> pay interest._ All that should matter to you is that you can record the interest in the MMDA account and keep track of the balance._ The fact that TD Ameritrade is apparently following Tod's suggestion should not matter to you._ They are doing this because that's how their accounting system works._ As I said, they have TWO cash accounts, the money MUST be transferred from one to the other._ In Quicken, you only have ONE cash account.These transactions (you originally downloaded them) were part of your original problem._ Each time you move cash between the cash account and the MMDA or the MMDA and the cash account TD Ameritrade generates a transaction to convert cash to MMDA or MMDA to cash._ For your purposes, they are totally meaningless because the cash is already in the Quicken cash account.If you have added all of your transactions as I have suggested, including the purchase of securities that you mentioned, your Quicken balances (cash and securities) should now be in-sync with your TD Ameritrade July 31, 2007 statement and you will notice that everything_is in balance even though we ignored the misc., transactions that TD Ameritrade reported on your statement between your cash account and the MMDA account._ As I said, they are meaningless to you.As you know, this is a User to User forum._ When you post a question, anybody can respond with an answer._ You have no way of knowing whether that user (myself included) has the right answer to your question or not._ Before you follow any suggestions or try things on your own, you should make sure that you have a good backup so that if the suggestion turns out to be a lot of hot air, you can restore your Quicken fileset to its previous state.
                                                  Quote:" TD Ameritrade Deposit: Where do you "park" your cash from your investments? I seriously doubt that your brokerage company has..."<STRONG>"Where do you "park" your cash from your investments?</STRONG><STRONG>I seriously doubt that your brokerage company has it just laying around._ </STRONG><STRONG>Wherever your brokerage company has your cash, simulate your real life accounts._ I would assume that this cash is in a money market account (sounds like your TDA cash account is a money market account)."</STRONG>You have just proven my case._ You haven't taken the time to read this thread._ Your lame comments and all the assuming you want to do doesn't cut it._ This thread is way past the general suggestion level._ There are lots of facts provided_by the original poster and other users that you would know_<STRONG>IF</STRONG> you had bothered to <STRONG>READ</STRONG> the thread._ Your comments (above) are a waste of time and forum space._ They are a self-indulgence and only serve to increase your Post Count.
                                                    Quote:" TD Ameritrade Deposit: Mblanco2000: "So what I would like to figure out is how to just have my cash in..."iiimaf,>b I'm pretty sure that Tod will agree, at this point, that you do not want to mess around with the suggestion of his that you just quoted.  Since you are just getting started with Quicken, you are missing the problem that arises if you were to do so.  A cash account in a brokerage account has one primary purpose, it accumulates cash.  When you sell securities the cash account is where the proceeds go and when you buy securities it provides an immediate way to fund the purchase.From what you are saying here I can not tell if I should get rid of the linked cash acct. or not.  I do understand now how TDA is handling my cash with two of their cash accts.  One that bears zero interest and another that garnishes some interest in the MMDA acct.So I do not do very many ACH transfers.  Hardly ever except to get this acct opened really.  So it seems from alot of the talk here that linked cash accts. might be some what of a headache if you do not do frequent external transfers. so I am trying to figure out if I would be better off switch the way this is now with a linked cash acct or do it another alternate way.  Also at the end of the day I still have two more older TDA accts. that I have to get going properly.
                                                      Quote:" TD Ameritrade Deposit: iiimaf, b I'm pretty sure that Tod will agree, at this point, that you do not want..."Absolutely, get rid of it if you don't like the way it operates._ There really isn't very much of a difference._ On the one hand, the linked cash account stands alone in its own register and on the other hand, the cash is included in the same register with_other security_information._ Follow the instructions in my last post if you want to delete it._ The other two accounts don't need the linked cash account.You didn't mention whether_you were able to get the Quicken TD Ameritrade account in balance with their July 31, 2007 statement?_
                                                        Quote:" TD Ameritrade Deposit: Mblanco2000: "So what I would like to figure out is how to just have my cash in..."I'm pretty sure that Tod will agree, at this point, that you do not want to mess around with the suggestion of his that you just quoted._ Since you are just getting started with Quicken, you are missing the problem that arises if you were_to do so._ A cash account in a brokerage account has one primary purpose, it accumulates cash._ When you sell securities the cash account is where the proceeds go and when you buy securities it provides an immediate_way to fund the purchase.Actually, I don't agree._ I think this is a fine time to explore both possibilities and see which makes more sense to the OP.__In my view, having the linked checking account is extraneous._ If one uses that account as a checking account (as some folks do), it may make sense, but I prefer to see the cash balance column in my brokerage account (in Q) and make that go to zero as necessary buying and selling shares of the MM fund._ With a linked checking account, you'll have all the transactions with 'X' appended to them as iimaf indicated earlier and the linked account ebbs and flows with those transactions._ Without the linked account, the 'X' is omitted_(not applicable) and the cash balance in the brokerage account ebbs and flows.There may also be a perception problem as different users see their FI data differently._ iimaf states that "The problem here is that you have TWO cash accounts with TD Ameritrade, their normal cash account that pays <STRONG>NO</STRONG> interest and the MMDA which <STRONG>Does</STRONG> pay interest."_ Again the caveat that_ I am not familiar with TD Ameritrade, but I would not generally perceive his description as having two cash accounts._ I tend to see this as having a cash balance in the brokerage account_and having a MM security._ In TDA accounting world, they may treat your cash as in a different account (indeed, I am fairly sure they do), but I would offer you do not have to._ In Quicken, I prefer to have no Cash Account for my investment funds (whereas iimaf indicated you would have one cash account)._ Repeating myself, this is where different users can have different perceptions._ [Note: In this paragraph and posting, I have tried to be rigorous in using the term 'account' in the same fashion Q uses the term.]I think iimaf and I are on the same page of advising users to model their Quicken files after real world accounts._ This discussion just exemplifies that even that leaves room for interpretation._ Final note:_ You have some experience (albeit not good) at downloading transactions._ If you think you may want to move back that direction in the future, you may want to consider or explore what account configuration better supports that feature._ _
                                                          Quote:" TD Ameritrade Deposit: I'm pretty sure that Tod will agree, at this point, that you do not want to mess..."Tod:Personally, I don't care which alternative mblanco2000 takes._ I tried to explain_that either_alternative will work just fine_and apologized earlier for only suggesting the linked cash account alternative._ I haven't disagreed with anything you have said._ Again, the problem, as I see it, is that TD Ameritrade <STRONG>does in fact</STRONG>_treat these accounts, cash and the sweep money market as two distinct accounts._ On my TD Ameritrade statement, I see three lines at the top of the first section on the first page of the statement._ They are, CASH, MMDA and Money Market._ These lines are followed by Short balance, Stocks, Short stocks, Bonds, Options, Short options, Mutual funds and Other._ My sweep account is held at The Reserve (a third party) and shows up under line #3 Mutual funds._ The only thing it's good for is earning interest on the money swept from my Cash account._ It acts just like the TD Ameritrade Cash account but it earns interest._ The money held in this account is <STRONG>immediately</STRONG> available for investment at TD Ameritrade only._ I can't buy anything at The Reserve._ From what I have read on the TD Ameritrade website, this is exactly how the MMDA account works, but since I don't have the MMDA account and haven't called TD Ameritrade to ask about it, I could be wrong.In my opinion there is no straight forward way that Quicken can keep up with this._ If you look back toward the beginning of this thread you will see that mblanco2000 tried to download the transactions from TD Ameritrade._ There was confusion because of the purchase of the money market shares which were being purchased as an internal TD Ameritrade mechanism as part of the transfer._ This confusion will only get worse if mblanco2000 tries to add these transactions to the Quicken TD Ameritrade register every time there is a purchase or a sale._ From mblanco2000's perspective and from Quicken's perspective, these transactions are meaningless.The conversion of "Cash" between the MMDA and the TD Ameritrade Cash account is going to show up in the TD Ameritrade transaction history and their statements._ These transactions are going to occur whenever a sale or purchase is made and the funds are either withdrawn from or transferred to the MMDA account at TD Ameritrade._ As long as there is only one Cash account in Quicken, these transactions should be ignorred because they have no impact on the Quicken linked cash account or the cash balance in the Quicken TD Ameritrade brokerage account.Tod, you said, "In Quicken, I prefer to have no Cash Account for my investment funds (whereas iimaf indicated you would have one cash account)."_ This may be because I haven't clearly stated my definition of cash._ Whether it be a linked cash account in Quicken or a Cash Balance in the TD Ameritrade transaction register in Quicken, I consider them both to be the Cash held in the account at TD Ameritrade.If this isn't clear, I give up._
                                                            Quote:" TD Ameritrade Deposit: Tod: Personally, I don't care which alternative mblanco2000 takes._ I tried to explain_that either_alternative will work just..."Guys I appreciate all the help on this issue and hope that I have not created any animosity between anyone.So what I have done was I got rid of the linked Cash Acct. that I created earlier.  The reason I did so was b/c I do not do very many ACH transfers and do not use this as a checking account, and I would like to have everything in one acct.  I feel like I am at ground zero again, but I am understanding that I need to get Quicken to mimic the real world transactions.Now within my register I have the initial deposit of the 27K from my checking acct as action "XIn".  Then the following day I have a purchase of 27,000 shares of MMDA1 @ $1 a piece as action "Bought".  Then two days later I bought a security.  So I have that in the register as a "Bought action.Now I know I need to mimic the "Redemption" event that it shows on my TDA statement for the same cash amount that it took for me to buy the securities, but I am not what I need to do in Quicken to do so.  What would be the action in Quicken that I need to show for this?  Is there anything else that I need to do to mimic the events in Ameritrade at this time?Since things have changed I thought I would post screen prints of my Transactions Tab and Summary Tab.  Thanks again for the assistance.
                                                              Quote:" TD Ameritrade Deposit: Guys I appreciate all the help on this issue and hope that I have not created any..."No animosity on my part._ iimaf has offered you well presented and well thought out advice._ If he had not offered that I might be interested in retracting my prior advice, I would have kept quiet as you were working things out well._ He certainly has a better perspective on the TDA paper interface and that is what you have to deal with._ His personal experience in that regard should not be overlooked._ As to your next transaction, I would expect there to be a sale of the MMDA funds to cover the $4,137.56 price of the Schlumberger shares._ I'd sell 4137.56 shares of MMDA at $1/sh which will generate the cash in your account to cover the cash deficit currently shown._ I'd date the transaction the same date as the Schlumberger purchase and not concern myself with lots of the MMDA to sell._ Q defaults to a FIFO assignment and for a MM fund at a constant $1/sh, lots don't matter - there is no cap gains involved.._ But again, you have to systematically coordinate this with your TDA statement to which you'll be reconciling casually or formally._ If it is going to show some other series of transactions, be prepared.
                                                                Quote:" TD Ameritrade Deposit: No animosity on my part._ iimaf has offered you well presented and well thought out advice._ If..."All right so I am getting there now.  I added the action "Sold" to my MMDA @ $1.000135 per share to equal $4,137.56 total.  So I have my cash balance where it needs to be zero.  However now when I go to the Summary Tab (shown below) I have a gain.  I have not put any interest in my transactions yet or anything. So the amount I have in my MMDA acct is off a bit.  Any suggestions?
                                                                  Quote:" TD Ameritrade Deposit: All right so I am getting there now.  I added the action "Sold" to my MMDA..."You need to sell 4137.56 shares of MMDA at $1/sh._ Yuo didn't include the 0.56 on shares you sold throwing off the price and creating a false gain._
                                                                    Quote:" TD Ameritrade Deposit: No animosity on my part._ iimaf has offered you well presented and well thought out advice._ If..."Tod:I guess mblanco2000 took my comment of "I give up," for something it wasn't._ You and I have disagreed about a couple of things during my time on this forum and as I recall I may have been wrong on a couple of points._ I respect your opinions and have never questioned your knowledge of Quicken._ I suspect that Mblanco2000 hasn't seen any of my more down to earth posts to gmalis1 because there we have something akin to animosity.Back to the point._ In Mblanco2000's recent posts, I see the confusion (not necessarily mblanco2000's) but the confusion that the MMDA transactions bring to the Quicken transaction register._ Yes, if we truly try to follow the "Real World," these transactions need to be there._ But my point is and has been that they are meaningless, add confusion and are a source for error._ Remember, a rose by any other name is still a rose and this rose is CASH, no matter how you cut it._ The only difference between TD Ameritrade's Cash account and TD Ameritrade's MMDA account is interest.During a telephone call this morning with TD Ameritrade I confirmed that the MMDA account and my Money Market at The Reserve are for all practical purposes identical._ The only reason TD Ameritrade has multiple Cash accounts is to differentiate whether interest is paid, at what rate interest is paid and when the interest begins to accrue._ It's an internal accounting transaction._ The transactions between the two accounts are mandatory (I didn't push the TD Ameritrade representative for chapter and verse) but I suspect the SEC and maybe various banking laws come into play._ Her bottom line was that money stays in the CASH account until the trade settles, then it is swept to the MMDA account where it begins to accrue interest. That said, other than taking the "Real World" to an extreme, why bother with the transactions necessary to transfer money from CASH to MMDA and then back again when a purchase is made._ Just leave it in Quicken's Cash, either in a linked cash account or in the cash balance column of the brokerage account._ At the end of the month, simply add the TD Ameritrade interest transaction to account for the interest accrued and paid and check the Account Activity section of the statement to reconcile security purchases and sales while ignoring the transfers between TD Ameritrade's Cash account and their MMDA account.
                                                                      Quote:" TD Ameritrade Deposit: Guys I appreciate all the help on this issue and hope that I have not created any..."Mblanco2000:Please see my last post to Tod._
                                                                        Quote:" TD Ameritrade Deposit: Tod: I guess mblanco2000 took my comment of "I give up," for something it wasn't._ You and...""as I recall I may have been wrong on a couple of points"As have I.I respect your opinions and have never questioned your knowledge of Quicken._ Right back at-cha.As I see it from a somewhat ill-informed distance, MMDA is nothing other than a money market fund._ I have several MM funds with their 'security type' set as Money Market, and their 'Asset Class' set to 'Cash'.__I think you have summarized well that this asset by whatever name can be in a brokerage account cash, a linked checking account cash, or as_MM fund shares (a cash equivalent)._ I see no real consequential difference among the three and think most users should make their choice based on two factors:_what makes the most sense to them individually and what meshes best with their FI reports and data._ This thread all started particularly because TDA's data (downloaded) didn't seem to mesh well with Q to begin with and the OP wanted help in essence to determine the first part what would make sense to him._ Anyway, I thnk he is getting there._ Essentially the question you have placed on the table is "why use a MM fund in Q when a cash balance provides the same effect with fewer transactions?"_ In my case, it is probably a matter of having started that way (using a MM fund)._ I do find that treating the cash as a MM security allows_me to better include that asset in various portfolio views._ Thus it provides a way to see and compare some performance figures for the MM funds (cash) that holding it as pure cash does not offer._ And I have noticed that if I group a portiolio view by security the 'cash' is omitted from the presentation.__MM fund holdings (also_cash) are included in that grouping._ Further, I will confess that I do not necessarily keep my brokerage cash at zero by sweeping in and out the buys sells, dividends received etc. on a daily basis._ As I am more concerned with month-end balancing to_the brokerage statement, I will often group all the buys and sells into a respective pair of transactions at month end.As you say, a rose by any other name ... ._ This is a case where there is certainly no right or wrong way in Quicken._
                                                                          Quote:" TD Ameritrade Deposit: "as I recall I may have been wrong on a couple of points" As have I. I..."Tod:"This is a case where there is certainly no right or wrong way in Quicken."I completely agree!This thread's questions and answers from all concerned_can really be boiled down to different strokes for different folks as you imply._ Only because mblanco2000 specifically stated early on, the desire to do away with downloading from TD Ameritrade did I get into this as deeply as I did._ If that comment hadn't been made I would have watched the thread from afar and I would have been much less obvious.Habit, as you say, "In my case, it is probably a matter of having started that way (using a MM fund)," is a powerful detriment to change, especially when there is nothing wrong with the habit, as is the case here.I think I'm also seeing something you have been saying for the first time._ Until I read this post, I didn't realize you were talking about a separate money market account (treated like any other security) in the TD Ameritrade brokerage account in Quicken.__If this is the case, I now see your point with a totally different_perspective._ I have been wondering just how the transfers between Cash and the MMDA could be handled in Quicken since Quicken only allows one cash account._ Since I don't treat my so called money market account, "The Reserve," at TD Ameritrade as anything but a cash account with a very good interest rate (currently 4.49%) and I try to keep my money at TD Ameritrade invested in securities, not cash, I see no benefit in looking at or tracking its performance._ My "real" money market accounts are set up in Quicken in the normal fashion and like you, I do track and monitor their performance.In closing, I hope_you will permit me to quote you, and say, "In my case, it is probably a matter of having started that way (<STRONG>not</STRONG> using a MM fund)."
                                                                            Quote:" TD Ameritrade Deposit: You need to sell 4137.56 shares of MMDA at $1/sh._ Yuo didn't include the 0.56 on shares..."I was not grasping the fact that with this cash or MM account I really had virtual shares.  Since they are not literal shares I was not grasping the fact that you could sell or buy .56 of a share.So I got that corrected.  Now from IIImaf's post I want to go back and add in the interest that has generated on the MMDA acct. which is 8.73 (big money, lol).When I do so I go the Transactions Tab and make an action "IntInc" to the MMDA1 security, but it allocates this interest to just plain cash.  Does that mean I need to make the action a "buy" to MMDA in the form of 8.73 shares @ $1/share?If that is the case I might agree with iiimaf as to just making my classifying my MMDA acct as cash, so that at the end of the month I just add the interest to the cash.  I have included my transaction tab screen print
                                                                              Quote:" TD Ameritrade Deposit: I was not grasping the fact that with this cash or MM account I really had virtual..."It is not that the MM shares are 'virtual._ They are real shares._ It is just that you are allowed to buy and sell partial shares._ Same is generally true with all mutual finds._ For MM funds at a fixed $1/sh, trading to 0.01 shares keeps everthing accurate to the penny._ For the interest income, use a Reinvest transaction._ That will simultaneously record the interest received and buy the new shares._
                                                                                Quote:" TD Ameritrade Deposit: I was not grasping the fact that with this cash or MM account I really had virtual..."Mblanco2000:Now that Tod has replied to you, I want to make a very simple suggestion._ By the way, everything he said in his last post is correct.<STRONG>But, the question you have to ask yourself and answer is, why do you have this MMDA account?</STRONG>When you opened the TD Ameritrade account, did you want a money market account to go along with your brokerage account,_or, did you just want a cash account that paid interest?_ If you wanted a money market account to go along with your brokerage account, you need to open one_at TD Ameritrade and treat it as a money market account._ If you just wanted a cash account that pays interest, then forget about all this and_deal with your cash in the brokerage account.The basic difference between the two is that a cash account (be it the TD Ameritrade Cash account, the MMDA or any other interest bearing sweep accounts at TD Ameritrade) is a "TEMPORARY" holding account for the cash that you_intend to use for investing in the brokerage account._ Using the facts that you have already provided, let's look at an example.You ACH'ed $27,000 to your brokerage account._ Do you want to use all of that money to invest in securities?_ If so, forget about everything you have heard about setting up a money market account in Quicken and just deal with one of the two possible ways to see your cash._ However, if you only want to invest $15,000 of the initial deposit (buy securities other than money market securities) then, take a good look at everything Tod has said.Bottom line, I think something has gotten lost here, your intent for the money._ Before anyone can help you with the "correct" Quicken transactions, you need to decide how you want to invest the money!
                                                                                  Quote:" TD Ameritrade Deposit: Mblanco2000: Please see my last post to Tod. _"Everyone thanks again for all your help on this subject!  I feel like I have come a long way in understanding how to replicate the real world through Quicken.  Different people can setup their accts. in  different ways that sometime end up in the same result.Since this is a new acct. and I do not have many external deposits or withdraws I decided to just use a cash acct. and add the interest at the end of the month.  It seemed the most simple way to have a setup for my purposes.  I really appreciate you guys helping me out with this new acct.Now I am going to rectify my old TD Ameritrade accts.  I will end up starting a new thread for this task.  Thanks for all your patience.

                                                                                    Similar questions other people found helpful: