The Account Balances Report is incorrect and greater than the actual register account balances

ChuckDB Member
edited June 2022 in Reports (Windows)
On some, not all, accounts the balances in the Account Balance/Net Worth report are much greater that what is reported in the account register.


  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭

    Go to Reports > Net Worth and Balances and view the built in Net Worth and Account Balances Reports. Do these reports both show different current balances than your registers?

    When did you first see this problem? Was it before or after Mar. 4, when R39.17 was first released?

    Previous to the current version, did you ever have R39.17 or R39.21 installed?

    In the affected account(s), have you ever used the Paycheck Wizard to enter split transfers in your paycheck?

    If your answers are Yes affects both reports, first seen after Mar. 4, Yes ran R39.17 or R39.21, and Yes have used Paycheck Wizard, you have probably encountered the problem discussed at great length here:

    If this is your problem, you should update to R39.23 or newer if you have not already. The newer versions fix this problem going forward, but they do not repair the damage caused by R39.17 and R39.21.

    Then print a report that shows all the transactions you have entered since the problem occurred, in case you need to re-enter them. To do this, 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

    QWin Premier subscription
This discussion has been closed.