cancel
Showing results for 
Search instead for 
Did you mean: 
sas00
Level 2

Reconciliation

Hi,

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.

Thank you in advance for your help.

3 Comments 3
BettyJaneB
QuickBooks Team

Reconciliation

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:

  1. Press on File at the top menu bar.
  2. Select on Utilities.
  3. 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:

  1. Go to the File menu at the top.
  2. Press on Utilities.
  3. Select on Rebuild Data.
  4. Hit on OK to close all windows.
  5. 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.
  6. Once the rebuild's finished, tap on OK.

Here's a link that you can refer to give you complete details in this procedure: Verify and rebuild data in QuickBooks Desktop for Mac.

 

Once done, make sure that your QuickBooks is updated to its latest release so it will be up-to-date so you have the latest features and fixes.

 

Lastly, I'm sharing these references below to guide you on what are the best thing to do if you encounter issues when reconciling your account in QuickBooks Desktop:

I got you covered if you have any other questions about this or any concerns with QBDT. I'm always here to lend a helping hand. Thanks for coming, and have a lovely day!

sas00
Level 2

Reconciliation

@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? 

Rubielyn_J
QuickBooks Team

Reconciliation

Hello there, @sas00.

 

I appreciate you doing the steps given by my colleague. If the reconciliation window still showing unreconciled, let me provide you some steps to fix this. 

 

To start, we'll need to open the Previous Reconciliation Detail reports. This way we can check the reconciliation discrepancies.

 

Here's how:

  1. Go to the Reports menu.
  2. Select Banking then choose Previous Reconciliation.
  3. In the Previous Reconciliation Report, choose the Account.
  4. Under Type of Report, select the Detail option.
  5. Select the Statement Ending Date.
  6. Under In this report, include section, open both reports on your screen so you can check and compare balances and determine the last correct reconciled transaction.

After, identify the transactions that were un-reconciled and manually calculate the difference.

 

If a transaction is modified, it gets un-reconciled. You need to recognize these transactions so you can easily calculate the difference in your ending balance and fix it.

 

I've added this article that can guide you in doing special reconciliation to fix the transaction after calculating the difference in the ending balance on the two reports.

 

Should you need additional information, don't hesitate to click the Reply button. Have a great day.

Need to get in touch?

Contact us