Vanguard Advantage Account and Quicken

TromboneAl

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Joined
Jun 30, 2006
Messages
12,880
Any of you have a Vanguard Advantage Account, and download transactions to Quicken? I'm deciding how to handle it -- current idea is to not download the transactions from the VA account, and handle the checks in the Money Market account.

What do you do?
 
We struggled with this issue too.

Ultimately, we set up a brokerage account called "Vanguard Advantage". Quicken then allows you to create a checking account linked to the brokerage account - "Vanguard Advantage-Cash". The linked account is then set up in Quicken like any other account in the cash flow center (e.g. checking). Finally, we set up the sweep money market account as "Vanguard Sweep" in Quicken as a seperate Investment Account. (We had Vanguard assign our linked money market account an account number different from our other taxable investment accounts to keep it cleaner in Quicken.)

Essentially, we have two tranasctions for each payment or deposit. When an item is paid from the checking, Quicken downloads both the sale of the linked money market sweep shares and the payment from the linked checking account. The only thing I need to really deal with is editing the sweep money market sale transaction to transfer the cash proceeds to the checking account ("SoldX"). To do that, in the edit sell box, you will see an option "Record Proceeds?" to this account's cash balance or to another account to be selected. Choose your linked account where the payment was withdrawn. You should end up with $0.00 cash balance in each account when everything has cleared.

It's just the reverse with deposits. When there's a deposit to the checking there will be a corresponding purchase in the sweep. Just edit the bought transaction in the sweep account to have the cash for the purchase taken from the linked cash account ("BoughtX") where the deposit was made.

It's a little more work, but our interest in the PMM fund is 20 times what we were getting in our credit union checking account. :eek: It's definitely worth it.

I hope this helps. If you come up with a more efficient method though, I'd love to hear about it.
 
Thanks for the help SS.

I've now handled some checks and EFT's and this works for me:

When I download, I uncheck the option for downloading the VanguardAdvantage account transactions. This works because any VA transaction will appear in the money market fund.

So, for example, when I write a check a Sold transaction is downloaded. I then enter a matching WriteCheck or Withdraw transaction, and everything is copacetic.
 
What I did was just set up an Investment Account In Quicken. I do not download transactions to it. When I rarely write a check. I just enter a transaction called 'Write Check'. It's in the drop down box under Other Cash transactions.
 
I'm now finding that my system has a disadvantage: I don't get the individual checking account transactions downloaded, and I have to enter them manually. This can get complicated, espcially since VG will combine several checks in one "SWEEP TO BROKERAGE" transaction.
 
I now do it the standard way. I let Quicken create an account for the Vanguard Advantage checking account, and I enter the check information there. Works OK so far.
 
Back
Top Bottom