Video: https://www.loom.com/share/3b00762353ff47aabb793217854bde9b
Summary
I've always setup my brokerage account as a basic asset account, and then I manually add transactions to keep a general balance, but it doesn't properly show me cost basis and profits, etc.
I'm trying to get the brokerage account added to Quicken and connected so I can remove the manual one and use it properly going forward.
I was able to add/connect it, but it only went back to 9/23/24 when the account was actually opened in April of 2023.
As such, it created placeholders for the stock holdings that it didn't have purchase entries for. I'm now trying to get this all cleaned up.
First, I updated the opening balance date to reflect 3/31/23 since my first transactions were in April of that year.
I then went to my checking account and updated all of the transfers I had from there into my manual account so that they would reflect being transferred into this newly connected account instead. That propped up the cash balance in the account as expected.
Now I'm trying to get everything prior to 9/23/24 caught up, so I'm going through each statement to enter any Int/Div income and the stock purchases to offset the placeholders for those.
I was able to get the first two months reconciled after adding some small interest payments, and it correctly updated my cash balance.
However, starting with the 6/30/23 statement, Quicken is fighting me for some reason.
On that statement I have a withdrawal, some Div income, and some stock purchases (that would offset the placeholders.)
My cash balance is correctly up to the date when I try to enter the first div deposit. When I do this, Quicken is adding a "balance adjustment" as a negative amount which offsets the amount of the deposit, so the cash balance doesn't increase at all.
This happens again for the next Div income on that same statement, and also for the stock purchase.
For some reason it keeps adding these adjustments for everything instead of following the actual cash balance showing up in the register. So it adjusts to offset the exact amount of the deposit/purchase, and the cash balance just stays the same.
I can't for the life of me figure out how to resolve this. The adjustments are linked to the actual deposit, so if I delete the adjustment the deposit gets deleted too.
For the Div income deposits, I found that if I just enter those as "Deposit" with the Div category instead of "Income", then it doesn't add the adjustment. However, that feels weird to have to do that, and it also doesn't fix the problem where the stock purchase continues to add adjustments instead of reducing the cash balance.
I'm at my wits end. Any information on this would be greatly appreciated. Thanks!
