QuickBooks HelpQuickBooksHelpIntuit

Fix QBwin.log encryption errors

by Intuit• Updated 4 days ago

Learn how to fix the following errors in the QBWin.log after the Verify Data utility fails in QuickBooks Desktop.

  • LVL_SEVERE_ERROR--GetDecryptedCreditCardNumber Failed: The decryption has failed. CHECKPOINT: Failed to decrypt customer's credit card number. Customer ID: nnnn
  • LVL_ERROR--Unable to decrypt social security number/Social Security number

These errors come from damaged encryption of sensitive fields such as credit card, Social Security, and bank account numbers. Here’s how you can fix them.

Note: Before troubleshooting, update QuickBooks Desktop to the latest version and create a backup or a portable company file.

Check the QuickBooks admin user for damage

  1. Sign in to your company file as an admin.
  2. Change the admin password, and QuickBooks will re-encrypt your file.
    Important:  If QuickBooks crashes while encrypting, contact us. We may need to send your file to Data Services to remove sensitive information.
  3. Go to File, then select Close Company.
  4. Close QuickBooks.
  5. Open QuickBooks, then sign in as an admin.
  1. Run the Verify Data utility.
  2. Check the most recent entry in the log file.
  3. If you see these errors, contact us to fix your file.
    1. LVL_SEVERE_ERROR--GetMasterKey Failed: The decryption has failed.
    2. LVL_SEVERE_ERROR--GetDataAccessKey Failed: The decryption has failed.

Important: Send your file to Data Services only for admin master key errors. For non-admin errors, delete and recreate the users.

Follow these steps to fix missing or damaged encrypted fields. These steps apply to credit card numbers, vendor tax IDs, and employee SSNs.

Check for possible data damage using the Verify Data utility.

  1. Locate the QBWin.log file and save it to your desktop or any easy-to-access location.
  2. Right-click the QBWin.log file.
  3. Select Open with, then select Notepad.
  4. Note customer names and IDs in QBWin.log.

Editing the credit card number fixes the damaged data. If many customers are affected, use advanced imports to override.

  1. Go to the Customers tab, then select the Customer Center.
  2. Select the Active Customer filter â–Ľ dropdown, then select All Customers.
  3. Locate the names of the customers or jobs you noted. If not on the list:
    1. Export your customer list as an IIF file.
    2. Right-click on the IIF file.
    3. Select Open With, then select Microsoft Excel.
    4. Match the customer ID from the log note to the IDs in the REFNUM column.
  4. Select the customer or job, then select the Edit pencil iconImage of the edit icon. icon.
  5. Go to the Payment Settings tab.
  6. Enter dummy credit card information, then select Ok.
  7. Go back to the Payment Settings tab.
  8. Enter the correct credit card information, then select Ok.

Note: Edit the credit card number for each affected customer or job in the QBWin log file.

Run Verify Data to check if the issue is fixed.

  • If no problem is found, the issue is fixed.
  • If verification fails, check QBwin.log for errors. If customers still appear, edit the affected customer's credit card number again.

Note: If you see "Verify Error: QuickBooks found a problem with the Acct #/Card #/Note field for other asset," check for a damaged admin user or edit the information manually.

Reenter encrypted data

When we fix your company file, some encrypted data might be removed. Don't worry, you can usually restore it from an older backup (.qbb or .qbw) and paste it into the fixed file.

Note: These steps won't recover employee bank accounts or routing numbers for accounts.

  1. Open your backup file.
  2. Go to the Reports tab.
  3. Select List, then Employee Contact List.
  4. Select Customize Report.
  5. Select these columns on the Display tab:
    • Active Status
    • Employee
    • SS No.
    • Date of Birth
      Note: Uncheck everything else.
  1. Go to the Filters tab, then select Active Status, then set it to All.
  2. Select OK, then select Refresh.
  3. Select the Excel â–Ľ dropdown, then select Create New Worksheet.
  4. Select Export, then select a location on your desktop, then select Save.

Copy the data to the fixed file

  1. Open the Excel file you exported.
  2. Copy the SSN and the date of birth for each employee.
  3. Open the fixed company file.
  4. Go to the Employees tab, then select the Employee Center.
  5. Select the employee, then select the Edit Image of the edit icon. icon.
  6. Enter the correct SS No. and date of birth in the Personal tab.
  7. Select OK to save, then set up the employees’ direct deposit.

If an employee uses direct deposit, turn off the direct deposit before you enter their SSN. Here’s how:

  1. Go to the Employees tab, select the Employee Center.
  2. Select the employee, then select the Edit Image of the edit icon. icon.
  3. Select the Payroll Info tab, then select Direct Deposit.
  4. Uncheck the box for Use Direct Deposit, then select OK.
    Note: Once done with entering the employee SSNs and dates of birth, you can set up the employees’ direct deposit again.
  1. Open your backup file.
  2. Select the Reports tab, then select List.
  3. Select Vendor Contact List.
  4. Select Customize Report.
  5. Select these columns on the Display tab:
    • Active Status
    • Vendor
    • Tax ID
      Note: Uncheck everything else.
  1. Go to the Filters tab, then select Active Status, then set it to All.
  2. Select OK, then select Refresh.
  3. Select the Excel â–Ľ dropdown, then select Create New Worksheet.
  4. Select Export, then select a location on your desktop, then select Save.

Copy the data to the fixed file

  1. Open the Excel file you exported.
  2. Copy the tax ID for each vendor.
  3. Open the fixed company file.
  4. Go to the Vendors tab, select Vendor Center.
  5. Select the vendor, then select the Edit Image of the edit icon. icon.
  6. Select the Tax Settings tab.
  7. Enter the tax ID in the Vendor tax ID field.
  8. Select OK to save.
  1. Open your backup file.
  2. Select the Reports tab.
  3. Select List, then Account Listing.
  4. Select Customize Report.
  5. Select these columns on the Display tab:
    • Active Status
    • Account
    • Bank No./Note
      Note: Uncheck everything else
  1. Go to the Filters tab, then select Active Status, then set it to All.
  2. Select OK, then select Refresh.
  3. Select the Excel â–Ľ dropdown, then select Create New Worksheet.
  4. Select Export, then select a location on your desktop, then select Save.

Copy the data to the fixed file

  1. Open the Excel file you exported.
  2. Copy the account number.
  3. Open the fixed company file.
  4. Go to the Lists tab, then select Chart of Accounts.
  5. Select the account, then select the Account â–Ľ dropdown.
  6. Select Edit Account, then update the Bank Acct. No. field.
  7. Select Save & Close.
QuickBooks Desktop Mac PlusQuickBooks Desktop Premier PlusQuickBooks Desktop Pro Plus