Showing results for 
Search instead for 
Did you mean: 

QuickBooks Desktop export troubleshooting (Mac, IIF, & One-Click)

In this article

General issues
QuickBooks for Mac
QuickBooks IIF
QuickBooks One-Click

General issues

Bogus accounts created

You may notice that bogus/spurious QuickBooks accounts are being created. This can happen when symbols, accents, and special characters are used in account names. Doing so may create new accounts as the symbol, accent, or special character is removed or replaced.

To resolve:

Use only alphabetical characters and numbers in the account names.

QuickBooks for Mac

Quick tip

Double-click on the export download, and then click Import.

Exporting failures, missing information and amounts, or error message "You cannot import a negative check".

This is issue can be caused by the embedded browser through QuickBooks.

  1. First, try exporting outside QuickBooks Desktop by logging into your payroll account directly through a browser.
  2. Close payroll within QuickBooks for Mac.
  3. Open a new browser, outside of QuickBooks.
  4. Go to
  5. Sign in using your normal username and password.
  6. Export the payroll file.
  7. Save the IIF file to your desktop.
    • The export file is called payroll.iif. We recommend that you accept that default name.
  8. Restart QuickBooks Desktop/
  9. Import the IIF file into QuickBooks.
    1. Open QuickBooks.
    2. At the File Menu, click Utilities > Import > IIF Files.
    3. Locate the payroll.iif file you saved.
    4. Click Open.
    5. Click OK

If after changing to the IIF file for exporting you receive further error messages, look up those messages here as well to resolve.

Error: "You cannot record a negative deposit."

This may indicate that your QuickBooks file is damaged. Try verifying the integrity of the file using these steps:

  1. In your QuickBooks for Mac file, go to File > Utilities > Verify Data.
  2. QuickBooks will check the file for damage and notify you if it finds any. If errors are found, continue with the next step.
  3. Go to File > Utilities > Rebuild Data.
  4. Once the Rebuild is complete, try importing your data once again.


Cannot locate IIF file to export after backing up QB file

If a customer is prompted to back up their QB file when attempting to import the IIF file, they may not know where to browse for the IIF file after doing so. Advise the customer to use the navigational bar at the bottom of the QB window to scroll all the way to the left. They should see "Desktop" as an option to select, and can locate the IIF file there.

Note that this behavior is different from QB for Windows. Otherwise, the customer may get stuck in an endless loop of backing up their QB file, with no option to select the IIF file.

QuickBooks IIF

Error on line ___. You can t change the type of a name or add duplicate name.

To resolve this error, the employee list must be re-sorted by first name:

  1. In QuickBooks Desktop, choose Edit > Preferences.
  2. In the window that opens, click the Company Preferences tab.
  3. From the left pane, select Payroll and Employees.
  4. Click Display Employee Names by First Name.
  5. Click OK.

Error on line ___. You can't change the type of account.

In the export file downloaded from Online Payroll, we indicate the type of account or category for each account to which transactions are posted. These account types are fixed. When the incorrect type of account is found when importing the file to QuickBooks, this message will appear.

For example, if you have a Wage Expense category in QuickBooks Desktop as a Cost of Goods Sold (COGS) account or liability account, you will receive this error.

To resolve this issue:

  1. Determine the exact source of the problem
    1. Save the export IIF file to your computer.
    2. Right-click the IIF file and click Open with Excel. (Or, open Excel and drag the .iif file on to the spreadsheet)
    3. Find the line indicated in the error message. For example, if the error message says "Error on Line 10," look at line 10 of the Excel spreadsheet. This provides the account name that you entered in the spreadsheet and the account type that QuickBooks is expecting.
  2. Look at your chart of accounts to determine the type of account as it is set up in QuickBooks.
  3. Make corrections to the account by doing one of the following
    • In QuickBooks update the type of the account to match the expected type in Online Payroll.
    • In the Export Preferences in Online Payroll update the account to match the type of account Online Payroll requires.
    • Refer to the Export data to QuickBooks for Windows (IIF) article for types of accounts
    • Contact Payroll Support for any further questions about types of accounts expected in Online Payroll.

Error 404: File not found

This error is generated when QuickBooks is unable to find the specified IIF file. To resolve this issue:

  • Verify that the IIF file name exactly matches the file that was saved.
  • Verify that the IIF file is located in the correct folder, or on your desktop.

Export changes account Tax Line

To resolve

  1. Set up the Chart of Accounts (COA) tax lines as desired.
  2. Export the COA from QuickBooks.
    1. Choose File > Utilities > Export > Lists > Chart of Accounts.
    2. Save the .iif file to your computer.
  3. Import the Online Payroll export file (the COA tax lines break again).
  4. Import the COA.iif file saved in step 2. The COA tax lines are restored to values as saved in COA.iif.

Invalid Reference to AccountList : in AccountRef

There are 3 possible causes:

Cause 1: A pay type or deduction is assigned to only terminated employees and is not appearing in the Export Preferences currently. If an account is missing from the Export Preferences window, exporting a check for the terminated employee will fail, even though the Export Preferences appear to be complete.

To resolve:

  1. Change the status of the terminated employee to Active.
    1. Click the Employees tab.
    2. Select All Terminated from the drop down box next to Show: on the right side of the page.
    3. Click the employee's name
    4. In the Employment box, click Edit.
    5. Select Active from the drop down next to Status.
  2. Review the Export Preferences window for missing accounts.
  3. Enter an account into the missing field(s).
  4. Click OK.
  5. Export the check for the employee.
  6. Return to the employee's employment status and mark them as Terminated again.

Cause 2: Subaccounts are setup with space before or after the colon between account name and subaccount name.

Correct: Payroll Liabilities:Federal Taxes Incorrect: Payroll Liabilities : Federal Taxes

To resolve:

  1. In Online Payroll, click the Setup tab.
  2. Under the Export heading, click Preferences.
  3. Remove the extra spaces surrounding the colon in the account name.
  4. Click OK.
  5. Export again.

Cause 3: A work location has been recently setup, but doesn't appear in the Export Preferences.

To resolve:
You will need to make sure the work location is active and temporarily assign at least one employee to it. Once the employee is assigned, map the missing items in the Export Preferences and save. Then, change the employee back to the original work location.

Invalid Reference to NameList : in PayeeEntityRef

This occurs when there is a mismatch in the employee name between QuickBooks and Payroll.

To resolve:

  • The name in the Payroll account must match exactly to what is listed in QuickBooks including middle names.
    • Compare the names listed in QuickBooks and the employee's names listed in Online Payroll to check for discrepancies.
  • Within QuickBooks, check to see if there is a period after the middle initial. If so, remove it. Although it appears there is one in the Payroll account, this is strictly cosmetic and really not part of the name or export file.
  • Within the Online Payroll account, check for extra spaces trailing after the employee's name.
    • Within the Basic information section for the employee, check to see if there are spaces entered in the first or last name field after the end of the name and remove the trailing spaces.

There is an error with your account mapping, your data was not imported.

Typically this happens when the subaccounts in the export preferences are not entered correctly. Correct: Payroll Liabilities:Taxes Incorrect: Payroll Liabilities

To resolve:

  1. Check your Chart of Accounts to verify if the account has subaccounts setup.
  2. Correct the export preferences to include the additional subaccount mapping.

You cannot import a negative check.

This is caused by a check being out of balance.

To resolve:

  1. Restart QuickBooks and try again.
  2. Export from a different browser.
  3. Export one check at a time to narrow down which check is causing the error.
  4. Contact Payroll Support to verify if the check is in balance.

Export is successful, but no information is in QuickBooks.

Most often this is due to the incorrect account names entered in Online Payroll.

To resolve:

  1. Check QuickBooks for new accounts created; specifically a new bank account. The import will create the accounts if they do not already appear in your account list.
    • If new accounts were created: Delete the transactions and delete the account. Update the Export Preferences in Online Payroll to enter the names of the accounts you want to use exactly as it appears in QuickBooks. Then attempt to re-export.
  2. Open the IIF export file in Excel.
    • If the file is blank: Clear browsing cookies following the instructions in Delete or disable cookies and temporary internet files in your web browser.
    • If the file does contain information: Look in QuickBooks again for new accounts and make sure you select the date ranges that apply to what was export. Also make sure you are importing the latest payroll .iif file and not a duplicate or an older import file.
  3. Contact Payroll Support if the export is not successful.

The download file is missing or tries to open as soon as it is downloaded.

The downloaded file settings are controlled by the browser. To change the default behavior for downloaded files for your browser, refer to the article Browser troubleshooting tips for strange account behavior in the section regarding issues with downloaded files.

Exported Checks not showing in Employee Center but do show in register properly:
This occurs when an employee is not setup in the employee center, or is setup but the name does not exactly match the name exported from online payroll.  These checks will have been exported to the Other names list in Quickbooks desktop.
To resolve this:

  1. Go to the other names list and find the correct name, right click on the name and click edit.
  2. Choose change type from the next screen
  3. Change the type from other to employee and then save

You will now notice the name is no longer in the other names list but is now in the Employee center and the exported check will also show here.  Future checks exported will go to the employee center properly.
If the employee was already in the employee center but did not exactly match the exported employee, you will need to merge them.  To do this simply edit the name that was already there to match the name that exported.
Note:    If at any time the customer used Quickbooks desktop payroll and payroll transactions were tied to the old employee name you will NOT be able to merge them as Quickbooks will not allow an employee with payroll transactions to be merged to another.

Important: Intuit does not offer assisted technical support for creating or importing .IIF files

QuickBooks One-Click

If you're having difficulty installing One-Click

If you use Internet Explorer (IE), update your browser's security setting:

  1. In IE, go to Tools > Internet Options > Advanced > Security.
  2. Uncheck Do not save encrypted pages to disk.
  3. Click OK.

Error code : FFFFFFFF80070003, or message "We're having trouble connecting to QuickBooks. Please contact us."

Both of these error messages indicate an issue with the One-click application. There could be multiple reasons for this occurring.

To resolve, attempt each of the following troubleshooting steps one at a time and attempt exporting again to see if the issue is resolved.

  1. Make sure that you are using Internet Explorer 7.0 or higher and that the correct QuickBooks file is open.
  2. What version of Windows are you using? We do not support 64-bit versions.
    • You may have been able to export in the past using your 64-bit operating system. It is possible to have intermittent success, but is not something our service supports. We advise that rather than troubleshooting any further, switching to the IIF option described in the article Export data to QuickBooks for Windows (IIF).
  3. Add * as a trusted site.
  4. Clear Internet Explorer temporary files and cookies (cache).
  5. Check ActiveX controls in Internet Explorer.
    1. Choose Tools > Internet Options.
    2. Click the Security tab.
    3. Near the bottom, click the Custom Level... button.

    Suggested settings:

    • Allow previously unused ActiveX controls to run without prompt: Enable
    • Allow scriptlets: Enable
    • Automatic prompting for Active X controls: Enable
    • Binary and script behaviors: Enable
    • Download signed Active X controls: Enable or Prompt.
    • Download unsigned Active X controls: Prompt or Disable.
    • Initialize and script Active X controls not marked as safe: Prompt or Disable.
    • Run Active X controls and plug-ins: Enable or Prompt.
    • Script Active X controls marked safe for scripting: Enable or Prompt.

    Scroll down to nearly the bottom of the list and under Scripting:

    • Active scripting: Enable
    • Scripting of java applets: Enable or Prompt
  6. Uninstall One-Click.
    1. Download the following installation file:
    2. Click Save.
    3. Run the installer file.
    4. Click Remove.
    5. Restart the computer to completely remove.
  7. Reinstall One-Click and reconnect to QuickBooks.
    1. Re-open the file downloaded in Step 6.
    2. Click Install and follow the next few prompts to complete the process.
    3. Click the Setup tab.
    4. Under Export, click Preferences.
    5. Click Next.
    6. Click Next again.
    7. Click Connect. The QuickBooks certificate should appear in QuickBooks.
    8. Select Yes, always; allow access even if QuickBooks is not running. (See screenshot below)
    9. Click Continue...
    10. After this is completed, go back to Online Payroll and click Next.
    11. Click Next to use our default accounts with only selecting the bank account or select Customize to enter accounts already set up in QuickBooks.
    12. Click OK.
  8. Remove the One-Click certificate from QuickBooks.
    1. In QuickBooks, choose Edit > Preferences.
    2. On the left, click Integrated Applications.
    3. Click the Company Preferences tab.
    4. Select the One-Click Export item.
    5. Click Remove.

  9. If you use either Vista or Windows 7 32 bit version, check Windows User Account Controls.

Not all of your checks can be exported at this time.

This message is typically associated with web browser issues.

To resolve:

  1. Make sure you are using Internet Explorer 7 or 8.
  2. Clear temp files and cookies following the instructions in the article Delete or disable cookies and temporary internet files in your web browser
  3. Restart the computer.

Runtime Error Program iexplorer.exe abnormal program termination

The One-Click application may not be installed or not installed properly.

To resolve:

  1. Uninstall One-Click Export if it is installed already.
    • Follow Step 6 in the Error code : FFFFFFFF80070003 error resolution instruction for uninstalling One-click
  2. Reinstall One-Click.
    • Follow Step 7 in the Error code : FFFFFFFF80070003 error resolution instruction for re-installing One-click
  3. Export again.

Visual C++ error occurred in IEXPLORER.EXE

Typically this error occurs by remoting into a server or from a toolbar added to Internet Explorer.
To resolve:

  1. From Internet Explorer, click Tools > Internet Options.
  2. Click the Advanced tab.
  3. Under Browsing, uncheck enable third party browser extensions.
  4. Click Ok.
  5. Restart the computer.

If you are using a remote server or Citrix, our One-Click application is not compatible in this environment. You must use a regular desktop machine.

Error message: Runtime Error C++ C:/programs files or Runtime Error - Vista C++.

Unfortunately, One-Click export for QuickBooks does not work with 64-bit operating systems.

To resolve:

  1. Verify the Operating System you're using.
  2. If you're on a 64-bit operating system, you will need to switch to the .iif export option.

We're having trouble accessing your QuickBooks company file because you currently have a different QuickBooks file open. Close that QuickBooks file try again.

You have a different company file open than what was originally set up in Online Payroll.

To resolve:

  1. Click Setup.
  2. Click Preferences under Export.
  3. Click Connect. (See screenshot below)
  4. Click Next
  5. Click Connect.
  6. Click Next.
  7. Click Ok.

Nothing happens after clicking Export

Most likely you have a popup blocker installed or turned on for this page. You need to remove or turn off the pop-up blocker.

  • IE:
    1. Click Tools button, and then click Internet Options.
    2. In the Privacy tab, clear Turn on Pop-up Blocker checkbox.
    3. Click OK.If you don't see the options, click here.
  • Firefox
    1. Click Tools menu> Options.
    2. Click the Content panel.
    3. Clear the Block pop-up windows checkbox.

Related articles

Export data to QuickBooks for Windows (IIF)
Exporting to QuickBooks for Mac
Export to QuickBooks for Windows (One-Click)


Was this helpful?

You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us