How to Modify "Prior Cash Balance" for Investment Account Reconcile
I am trying to reconcile an investment account and the Prior Cash Balance does not match my previous statement. My Quicken register cash balance matches the current month Statement ending cash amount so there should be no reconciliation issues. There are no unreconciled transactions. If I try to put in any placeholders, added s Reconciled transactions, or any other adjustments, it affects my register balance and it no longer matches my current month statement. I can't modify any Reconciled transactions without similarly affecting the register balance. Is there any way to manually adjust the "Prior Cash Balance" to make it match the previous month statement without affecting the Quicken Account register balance? I'm at the point of closing the current account in Quicken and creating a "Start over" account to bring everything in line.
Answers
-
Just as it is in a banking type account, the Prior Balance is the sum of all transactions in the account that have an "R" in the CLR column.
SO, if you look backward in time in the investment account, you should be able to find the last transaction that has such an R … and work from there.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0