Vanguard investments sweep in/out transactions net out to zero

Hi all, I’m having an issue with my vanguard transactions where I ‘fund’/transfer money from my bank account into vanguard, that transaction appears as a ‘transfer in’ in tiller to my vanguard ‘cash’ account, but then vanguard ‘sweeps in’ that $ to the money market account and it’s shown as a negative transaction, so now my vanguard account balance in tiller is back to zero, which is not an accurate depiction of my funds/net worth.

I realize this would be similar to putting money into an investment that tiller doesn’t have the ability to track, but it seemed that in the thread linked below, folks were able to track investments.

Is the solution here to make a manual vanguard account in tiller and to manually add in these ‘transfer in’ transactions so that transfer in is still accounted for in my tiller net worth?

I read this post but it didn’t seem to mention this dymamic:

Annotated screenshot:

Thanks,
Kyle

Hi @kyle.sullivan.me I believe for your situation it could more appropriate to use the “Transfer” category for those transactions. Learn more here.

1 Like

Hi @twalane –coming back to this a year later XD
I think I explained my situation poorly and also might not have understood it fully. For every contribution from my checking account to a vanguard stock purchase this is what happens, each # is a row/transaction in tiller:

  1. $ transfers out of checking (- amt)
  2. $ transfers into vanguard described as “cash contribution” (+ amt)
  3. negative amount called ‘sweep in’, vanguard acct
  4. negative amt denoting purchase of a stock/fund

#3 and 4 above are double counting a transfer out from the vanguard account, which isn’t right. I get that once the stock/fund is purchased it’s out of the view of tiller.

Only solution I see is to delete the sweep in transactions. What are your thoughts on this?

Thanks

hi @kyle.sullivan.me ! :waving_hand:t5:
hmm interesting ! I think those are still “Transfer” transactions, but different categories. so 1 &2 would be perhaps “stock purchase” and 3 & 4 “sweeps” let’s say. I’m only thinking to do this to avoid the overhead, however if you wish to do the deletions periodically that could work.

Ok, so you’re not expecting the “Transfer” category in tiller to net out to zero–you’re using it for more purposes. Is that accurate?

@kyle.sullivan.me no that wasn’t what I was thinking initially, but I think I had misunderstood? or I’m misunderstanding now.:see_no_evil_monkey: I thought they would net to zero because you’re tracking both checking and market accounts? And I thought 1-4 all net to zero essentially where you end up is really money moved from 1-2 , and in the grand scheme of things this is money already accounted for from whatever transactions populate your checking account in the first place?