Government backed securities

Options
Airship56
Airship56 Member, Mac Beta Beta

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.

Tagged:

Comments

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    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 VP

  • Airship56
    Airship56 Member, Mac Beta Beta
    Options

    Here is a comparison of the values in Schwab and Q (most recent download):

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    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 VP

  • Airship56
    Airship56 Member, Mac Beta Beta
    Options

    Yes, Freddie Mac. And yes, I've been receiving principal repayments for 8 years.

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    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 VP

  • Airship56
    Airship56 Member, Mac Beta Beta
    Options

    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.

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    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 VP