Troubleshoot your customer data using Excel if, when performing tasks in QuickBooks Desktop, you encounter the message,

QuickBooks found a problem with the Customer:Job Credit Card Number field.

User-added image


  • The outcome of these troubleshooting steps is IRREVERSIBLE. Create a backup of your file before following the steps discussed in this article. If the backup fails due to data damage, you can either turn off verification (File > Back Up Company > Create Local Backup > Local Backup > Options > No verification) or create a copy/paste version of your file.
  • DO NOT run rebuild utility because it will damage the file more.
  • NEVER attempt to follow the steps in this article unless you are able to secure a good backup that you can restore.