What data fields fill the Account Balances Report in the Investment Accounts section?
One of my 401K accounts shows only negative numbers in The Account Balances Report. I ran it via Reports->Reports & Graphics Center->Net Worth & Balances->Account Balances. The report is set-up to Include All Dates with Interval Month. Under the section Investment Accounts, the 401K account in question is listed (John Hancock) as well as a previous 401K (Vanguard) and an IRA (Vanguard) that it was rolled over to. The Vanguard accounts are fine. The account that shows negatives is the John Hancock account. I wonder if it has to do with the field types the report pulls from? Transactions are downloaded from the John Hancock website (no Express Web Connect). It adds two contribution Deposits and one Bought transaction each week. I have to manually enter a quarterly fee and any dividend transactions. The report appears to calculate by subtracting the deposits, adding the fees & dividends, ignoring the shares Bought - giving a negative monthly balance instead of a positive. The Vanguard account are primarily BoughtX transactions, fees use the Removed Action, and dividends are a ReinvDiv transaction. The columns for both accounts are the same; Share Bal. Inv Amt, Cash Amt, Cash Bal. The BoughtX transaction adds shares to the balance, has an Inv Amt with a + number, a Cash Amt with a + number and a Cash Bal of zero. For the Deposit/Bought transactions, shares are added to the balance, the Deposit creates a Cash Amt with a + number, and the Bought creates an Inv Amt with a + number and the Cash Amt is a - number, which makes sense. After the Deposits and Bought transactions are entered, the Cash Bal for the account is zero. However, their website enters the Bought transaction before the Deposits, adding to my suspicion and desire to know which data fields Q is using to calculate the Monthly balance on the Account Balance Report. Could it be the format John Hancock downloads their data? Why wouldn't a Bought transaction with a + Inv Amt number be used to calculate the account balance? With an Investment account, it appears Q is only calculating the Cash Amt.
Thanks in advance for looking at this for me.
This discussion has been closed.