cancel
Showing results for 
Search instead for 
Did you mean: 
billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Hello,

I use Quickbooks Desktop 2021 for MAC.

 

When I run FILE->UTILITIES->VERIFY DATA

I get an error saying

"*** Verify Date Detected Errors *** your data has failed the integrity check. To repair the data use Rebuild Data in File > Utilities."

 

I ran Rebuild Data in File > Utilities, but when I run VERIFY DATA again, I get the same error.

 

How can I fix this?

 

Thank you!

9 Comments 9
MirriamM
Moderator

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Hi there, @billhdz. I appreciate the steps you've taken to get this issue resolved. 

 

Since the issue persists, I recommend performing some basic troubleshooting. But before doing so, let's ensure that your QuickBooks Desktop for Mac is updated to the latest release. It helps improve the performance of the software and fixes common and complicated errors automatically.

 

After that, let's try and locate your QBWin.log to help determine the cause of the error. You can check out this article and continue performing the steps for additional data damage: Resolve data damage on your company file.

 

Please let me know how things go on your end. I want to ensure this gets resolved for you. Take care.

billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Thank you @MirriamM 

 

I am using Quickbooks Desktop MAC 2021 version V20.0.7 R8.1

 

I can't find a file called "QBWin.log", but I have a log file from my MAC computer called "Quickbooks.log" This is a file from today.  Is this the one? Do you want me to ZIP it and upload it here?

 

 

billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Thank you @MirriamM 

 

I am using Quickbooks Desktop Mac 2021 Version V20.0.7 R8.1

 

I can't find the file "QBWin.log", but I do have a log file from my MAC ( from today ) called Quickbooks.log.

Do you want me to ZIP it and upload it here?

 

 

billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

The bottom of the log file says:

 

QBW (Graphics Interactive, LLC 2021.qb2021) 12/18/21 23:31:11

RN: 43918 CC: 42

 

QBW (Graphics Interactive, LLC 2021.qb2021) 01/11/22 15:05:37

Verify Name: Invalid name. Rcrd = 1401

Verify Name: Invalid name. Rcrd = 1454

Verify Item History: Quantity-on-hand doesn't match. Item = 74394320.

Verify Item History: Value on hand doesn't match. Item = 74394320.

Verify Item: Invalid inventory data. Rcrd = 32

Verify Reconcile Discrepancies: Invalid master = 43546

Verify Reconcile Discrepancies: Invalid target = 43547

Verify Completed

 

There are some more things with earlier dates on the log, but the bottom reads like the above comment.

If you need to look at the entire log file, let me know if you need me to upload it here.

 

Thanks for your help!

 

MichelleBh
Moderator

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Thanks for the quick response and for providing your QuickBooks version, @billhdz.

 

I'll share some details about log files in QuickBooks Desktop for Mac. 

 

Yes, QuickBooks.log and QBWin.log are the same. In Windows, the file is called QBWin.log, while for Mac, it is called QuickBooks.log. That said, zip it and upload the data from there. Verify the cause of the error and follow the onscreen instructions.

 

You can run QuickBooks File Doctor as well. This tool may solve some corporate file problems too in QuickBooks Desktop. For more details, see this link: Fix company file and network issues with QuickBooks File Doctor.

 

Did you know that we have QuickBooks Mac Pluss 2022? This version introduces several features to help automate and streamline your daily accounting tasks. To know the different features, see this link: What's new in QuickBooks Mac Plus 2022.

 

Also, check out our 2021 QuickBooks Desktop Mac User Guide for your future use. This page gets to grips with everything in QuickBooks.

 

I always check my notifications to monitor any replies. That said, don't hesitate to tag my name in the comment section if you have follow-up questions. I'm always here for you, billhdz. Keep safe.

billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

The "QuickBooks File Doctor" on your comments seems to be a fix for the windows version.  It's an .exe file that cannot be run on the Mac.

 

katherinejoyceO
QuickBooks Team

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

Thanks for following this thread, @billhdz. Currently, the file doctor tool only works for Windows users. 

 

In your case, I'd suggest rebuilding your data in QuickBooks for Mac to scan your company files for damaged data.

 

Before doing so, it's good to back up your QuickBooks Desktop for Mac company file. Then, follow these steps to fix current data issues in a company:

 

  1. Select File, then select Utilities.
  2. Select 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.

 

Once your data is verified, you can now rebuild your company files by following these steps:

 

  1. Select File, then select Utilities.
  2. Select Rebuild Data, then select OK to close all windows.
  3. QuickBooks will ask to make a backup before rebuilding your company file, select OK.
    1. If you haven’t set up any backup preferences, QuickBooks will ask you to update them. Select Backup Preferences and edit as needed, then select OK.
    2. When the backup's finished, select Show in Finder to locate the backup or select OK if you’re done.
  4. Once the rebuild's finished, select OK.

 

To ensure it is free from errors, you can verify and rebuild your company file again.

 

You can also check out this article and continue performing the steps for additional data damage: Resolve data damage on your company file.

 

If the issue persists, contact our Customer Care team. They can conduct a screen-sharing session to help you find the cause and fix the problem.

 

Get back here if you have additional questions. We're always around to help in any way we can. 

Fiat Lux - ASIA
Level 15

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

@billhdz 

Chat Support and ask for Data Service to fix your file. Otherwise, consider buying a 3rd party file repair service.

billhdz
Level 5

Verify Data failed the integrity check? Quickbooks Desktop 2021 for MAC

@katherinejoyceO 

 

Thanks for the reply. I talked to Intuit support yesterday and the error does not mean that my Quickbooks file is corrupted, even though the wording makes it sound like it is.  We did some troubleshooting and it turns out that there is a discrepancy on my inventory quantities that I need to address and fix or adjust.

 

 

 

Need to get in touch?

Contact us