I have a client that QB for Mac 2016 to 2020 earlier this year. They had reconciled their books thru 2018 and I was hired to reconcile 2019. When I go in to reconcile Jan 2019 the reconciliation window says December 2018 is not reconciled. However, when the cc register has the Dec 2018 transactions checked off as clear and reconciled. If I uncheck the transactions so they can show up in the reconciliation window the beginning balance for December is not correct. I spoke with a QB support representative yesterday and they suggested I undo the November 2018 reconciliation to undo December. I am not very confident in that solution and do not want to create more work for myself unnecessarily. I am hoping the QB community can help.
Glad to see you here again in the Community, @sas00.
I'd like to ensure that you'll be able to reconcile your transactions for 2018 accurately in QuickBooks Desktop.
To get this issue sorted out, I recommend verifying and rebuilding your data. This helps fix data-related issues on your company file since the transactions for 2018 are showing as reconciled in the register and not in the reconciliation window.
To verify the data:
Press on File at the top menu bar.
Select on Utilities.
Hit on Verify Data, then select OK to close all windows. If you see “Your data has failed the integrity check” you need to rebuild your file. If there are no problems with your data, you’re done.
To rebuild your data:
Go to the File menu at the top.
Press on Utilities.
Select on Rebuild Data.
Hit on OK to close all windows.
QuickBooks will ask to make a backup before rebuilding your company file, select OK. If you don’t want to do a backup, select Cancel to continue rebuilding your company file.
@BettyJaneB, thank you for responding. I tried the steps to verify data and received an error message. Now what do I do. The reconciliation window still shows December 2018 as unreconciled while the register has the December transactions checked off as cleared/reconciled. I have pulled the previous reconciliation report for November to see if any changes were made and everything remains the same. What do I do now?