Unable to create old reconciliation report in Quicken Deluxe 2019 R18.15

Question

When I try to create an old Reconciliation report, no matter what date I input and I select "all Transactions" it will only go back to 12/31/2018 for cleared transactions.  I am out of balance and attempting to go back and find the last correct reconciliation report.

I have run Validate and Repair - I get no errors and all internal consistency checks passed.  There are three old transactions back in 2017 that it reports appear to be damaged and it says I should delete them and recreate as appropriate.  I haven't done that yet but don't see how these would relate to this issue.

I have also opened a different quicken file that is for my dad, same problem.  I have uninstalled and reinstalled on a different computer and the same problem.

so either a problem with my file or quicken.

Any help or suggestions?

Sherlock · Accepted Answer

We can not create an old Reconciliation report.

The beginning balance of a reconcile is the total of the transactions marked as Reconciled.   If the beginning balance is incorrect, a Reconciled transaction has been added, removed, or modified.

To determine what changed, I suggest you compare the running balance of the account register with the running balance of the account register from a data file backup you saved before the issue appeared.

There are a variety of ways to compare the account registers.  The approach I use is to print the sorted account registers to text files (open an account, press Ctrl + P, set the date range, select Print, and choose Export to: and select Text file from the pull-down menu and Export).  I then use a text file comparison tool to quickly locate the differences between the files.

It is important to verify the registers are sorted appropriately and there aren’t any unexpected filters being applied:  select the Date column header (you want the small triangle to right of Date to point up) and Reset.