Net worth and account balances reports not correct for checking account

timl62

I noticed a problem with my checking account balance shown when I run a net worth report and an account balances report. The checking account balance in these reports do not agree to the balance shown in the check register (which is correct). I think this problem is due to an error in the version 39.xx releases of the software related to the paycheck wizard. Does anyone else know about this and whether or not Quicken is going to fix the problem?

timl62

When I open the paycheck split details, all of the items are duplicated - gross pay and all deductions listed twice. The balance in the check register is correct (somehow) but the net worth report and account balances report include all of the duplicate items causing the amount shown for the checking account in these reports to be significantly incorrect.

Jim_Harman

It sounds like you are experiencing the problem discussed at length here
https://community.quicken.com/discussion/7909601/r39-17-r39-21-paycheck-corruption-edited/p1

If this is your problem, you should update to R39.23 or newer, which fixes this problem going forward.

Then you will want to print a report that shows all the transactions you have entered since the problem occurred, in case you need to re-enter them. 

Go to Reports > Banking transactions. Set the Date range to Custom and set the starting date to 3/4/2022. Choose Subtotal by Account. Click the Customize gear at the top right of the report and check the Show splits box. Under Show Columns, you can un-check the Tax item box to make the report narrower. Click OK to display the report. Adjust the column widths if necessary, then print the report.

Then you should back up your current data file in case you want to return to it and restore a backup from before you installed R39.17. This would be about March 4. Verify that the problem is no longer present in the restored backup.

If the problem is still present in the restored backup, you have a different problem. You should return to your newer file and investigate further.

If the problem is not present in the restored backup, you will have to keep the backup and re-enter any transactions you entered since then. 

Accept Reminders as you normally would. Be careful when accepting Bill Pay reminders to avoid double payments. Then you can download transactions and accept them as you normally would. Compare the transactions in your registers to those in the report you printed earlier and enter anything that is missing. 

See this Announcement

https://community.quicken.com/discussion/7909593/windows-r39-xx-release-us

timl62

Thanks Jim. It is the same problem. The errors went back to 2019. I had to go into the paycheck splits and delete all the duplicate entries. Tedious and took some time, but fixed now. I'm surprised Quicken rolled out the software updates with this bug. But to be clear, the duplicate entries covered three years.

Jim_Harman

Thanks for the update, I am glad to hear you are back on track.

Given that it has been about 6 weeks since these errors were introduced, perhaps it was easier to repair the paychecks than to restore a backup from the beginning of March and re-enter all the transactions since then.