Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Archive Investment Transactions Cash Balance

At the Beginning of Dec 2020 I used the Archive Investment Transactions feature for a bond account that is 16 years old and has a lot of transactions. Yes, it created the archive copy and removed all closed transactions up to that date. But it also created a negative cash balance in the account going forward. Apparently all interest, withdrawal and other cash events were not handled in the archive process. It seemed that only the purchase and sales of closed transactions were accounted for. I wound up with a negative 500,00 plus cash balance.
Has anyone tested this feature? Has anyone else had a similar problem.
I had to restore from a backup 3 weeks later when I performed my usual end of month reconciliation with the brokerage account.
I was unable to reconcile the archive account with the old account. Adjusting the cash did not work as the two accounts are linked and the cash adjustment affects the value of the account.
Quicken support recommended the cash adjustment when I called at the end of December.

Comments

  • Quicken Francisco
    Quicken Francisco Moderator mod
    edited January 30

    Hello @larschnur

    Thank you for reaching out on the community and telling us about your issue. I do apologize for the issue you're having. If you wouldn't mind could we get a screenshot of the issue so that we're able to see what we can find something that we're able to see. I'll leave a link down below on how to screenshot. 

    https://community.quicken.com/discussion/7867159/faq-how-do-i-post-a-screenshot-in-the-community-from-windows#latest

    Note you may need to drag the photos into the response box in order to add them into the response.

    Once you get the chance let us know how it goes and we'll see what we can find.

    Thanks,

    Quicken Francisco

  • larschnur
    larschnur Member ✭✭
    I believe the problem occurred because the rtncap is not handled correctly in Quicken for FNMA and FHLMC bonds. Here are the screen shots from the archived files. file 3 is the completed file. files 4 and 5 are the archive file. Note the rtncap. There is no stop on the rtncap and these insruments ultimately show negative cost basis. I also think withdrawals are not handled correctly.
    I would like to see the programming design for this feature. If a lot of debit types have not been handled, then the cash balance position will be corrupted.
  • larschnur
    larschnur Member ✭✭
    by the way I am not the person in your hello! katnahat?
Sign In or Register to comment.