Government backed securities
I have several GBS in my Schwab portfolio (a couple purchased several years ago). The market value of these bonds (FNMA, FHLMC…) in Quicken is completely out of whack with actual and it throws the balance of my account off by tens of thousands of dollars. I've gone back through the transaction history of all these bonds and can't figure out how to rectify this…or even enter a placeholder to make the balance right. I know this has been a plaguing problem forever but wondering if anyone can offer any advice on how to address this.
Comments
-
So, is the number of units/bonds incorrect, or the quote? Bonds should be input into Q as "per $1000" so a $10,000 bond would be recorded as 10.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
Here is a comparison of the values in Schwab and Q (most recent download):
0 -
There's somethings wrong with Schwab's numbers. There's no math by which 20,000 and $89.68 come to $2,283.24.
What type of security is this? Perhaps a Ginnie, or Fannie, were you've been receiving principal repayments for several years?
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
Yes, Freddie Mac. And yes, I've been receiving principal repayments for 8 years.
0 -
OK, so how have you been recording those principal payments.
And see this for an extended discussion re: GNMA, which has the same issues as your Freddie.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
The principal payments are downloaded from Schwab to Quicken, going back about 8 years. There are two transactions per month: Interest Income and a Payment/Deposit (Return of Capital). These transactions increase cash balance but don't affect share balance.
I've read through the GNMA discussion and I'm still completely baffled about how to bring my Cost Basis back into reality. Oddly, the wide discrepancy has only become a problem in the last few months. It was off prior to that but not to such an extreme degree.
0 -
What does your Schwab statement show as the unit balance for these GBS? Does it agree with your numbers in Q?
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0
