Quick Search Results

    Not finding your answer?

    View More Results
    Top

    Export to QuickBooks for Windows (One-Click)

    Article ID: 1001370

    Overview

    It's easy to update QuickBooks with your payroll data with one click using the Intuit One-click application.

    This article explains how to export your payroll data and what to do each time you run payroll.

    Expected Outcome

    You can export your payroll data to QuickBooks.

    Assumptions

    You have completed Intuit Online Payroll setup, are setting up export to QuickBooks and are not using QuickBooks 2009 Contractor Edition.

    Details

    One-Click export for QuickBooks does NOT work consistently with 64-bit operating systems. If you are using a 64-bit operating system, use the IIF export method for QuickBooks explained in the Export data to QuickBooks for Windows (IIF) article.

    One-Click Requirements:

    • Internet Explorer 7.0 or later
    • Windows 32-bit operating system (one-click is not supported with 64-bit)
    • One of these editions of QuickBooks for Windows:
      • QuickBooks Pro 2006 or later
      • QuickBooks Premier 2006 or later
      • QuickBooks Enterprise Solutions 8.0 or later

    Move your payroll and your payroll tax transactions into QuickBooks for Windows with a single click. You don't need to re-enter any numbers or import any files.

    Set up your QuickBooks Online Edition accounts for payroll data

    If you have not yet set up payroll accounts in QuickBooks, Intuit will set them up for you the first time you import data into QuickBooks. Just enter the account names you prefer at the Export Preferences page following the instructions in Step 4.

    If your QuickBooks company already contains appropriate accounts, you can choose the accounts directly from your QuickBooks Chart of Accounts. If you need to add an account (perhaps for a new deduction), type the name you want for the account in our payroll service and they will be set up the account in your QuickBooks company the first time you transfer data.

    If you have not set up employees in QuickBooks they will be entered the first time you transfer data. If you have already set up employees in QuickBooks, ensure the name in QuickBooks is the exact same names in the Online Payroll employee setup. Note that we export employee names with a period after any middle initial, for example: John M. Smith.

    • To check the list of accounts in QuickBooks, click Lists > Chart of Accounts. Find the name of the bank account you use to write payroll checks and the expense accounts for employee wages and employer payroll taxes. Find the liability accounts you use for tax and deduction liabilities. (For cash advance and loan repayment, use asset accounts.)
    • If you use subcategories or subaccounts, use a colon to separate the category name from the subcategory; for example: Payroll:Gross Wages (no space before or after the colon)

    Set up QuickBooks classes

    If you have not yet set up classes that apply to your employees in QuickBooks, create them now. Once the classes have been set up, write down their names or print the list of classes and hightlight the ones you will use for the payroll data.

    Install One-Click on the computer where you saved your QuickBooks company file

    1. In Online Payroll service, click the Setup tab.
    2. Under the Export heading, click Preferences.
    3. Select QuickBooks for Windows (One-Click) from the software drop down list.
    4. Click Install.
    5. Click Run.
    6. Click Install.
    7. Click Finish.

    Connect Online Payroll to your QuickBooks company file. This connection tells us where your QuickBooks company file is and gives us permission to export to it.
    1. In QuickBooks, open your company file.
    2. Back in Online Payroll, click Next.
    3. In the Connect to QuickBooks window, click Connect.

    4. Click Connect again.
    5. In QuickBooks, select Yes, always; allow access even if QuickBooks is not running.
    6. Click Continue.
    7. Click Done.
    8. Back in Online Payroll, click Next.

    Set up accounts in your Intuit Online Payroll account.

    You will use the Export Preferences page to enter your QuickBooks accounts. Use the exact same names of the QuickBooks accounts you will use for the payroll data.
    1. Click Customize to enter the account names exactly as they appear in QuickBooks or select from the drop down list.
      • When entering accounts, read the help topics next to each field to choose the right account type. In general, enter or select an expense account for the Wage and Tax Categories. For the Liaibility accounts, enter or select the corresponding QuickBooks Liability account.
      • If using a cash advance or employee loan deduction, enter or select an asset account to receive the payroll data
      • If you use different accounts for different groups of employees, select that option in the wage/tax cagetory section to enter or select different QuickBooks accounts for each employee.
      • If you use different accounts for different types of wages/taxes, select that option in the wage/tax cetegory section to enter or select different QuickBooks accounts for each pay type and tax type
    2. Specify whether you use QuickBooks classes. These classes must be set up already in QuickBooks.
    3. If classes are selected, you will enter them on the next page after clicking OK at the bottom of this page.
    4. If you want to print checks using QuickBooks, select I will print paychecks using QuickBooks. Note: If you select this ption, see pay split between paper check and direct deposit below.
    5. Click OK.



    What to do after you create paychecks or tax payments

    1. Create paychecks or tax payments as usual.
    2. Approve your checks or payments.
    3. From the Pay Day tab, click Export.
    4. Select the checks and payments you want to export.
      • If you're exporting for the first time, checks and payments from the last six months should already be selected.
      • If you don't see your checks, change the date range.
    5. Click Export.
    6. We begin transferring the payroll data to QuickBooks.
    7. When you see the Congratulations message, close the window.
    8. Verify that all transactions appear in your QuickBooks register.

      Note: Because of the complexity of moving transactions from one web site to another, it's important to verify that all transactions have been transferred. If any transaction does not appear in your QuickBooks register after a few minutes, transfer it individually. (Go to the Pay Day tab, click Export, then click Show Checks and Payments Already Exported. Update the date range to include paychecks to transfer, select the paychecks, then click Export.)

    What happens when data is transferred to QuickBooks

    When your payroll data is transferred to QuickBooks, the process creates one transaction in your Bank account register for each payroll service paycheck. Depending upon how you set your preferences, handwritten checks appear in the checking register with or without check numbers. If you set your preferences to mark paychecks to print in QuickBooks, the transactions will not have check numbers but will be marked to print. (Transactions for direct deposit are also included in the checking account register but have no check numbers and are not marked to print.)

    The Bank account transaction contains splits that affect multiple accounts, depending on the number of accounts you selected to receive deductions:
    • A split appears for the Wage Account you specified in the export preferences.
    • A split appears for the Tax Account you specified in the export preferences.
    • One or more splits appear for each Liability account for federal, state and local taxes owed.
    • Additional splits are entered for each deduction/garnishment, one for the employee's deduction and one for any company contribution.


    When tax payments are exported, they are recorded in the corresponding QuickBooks tax liability account and reduces the liability.

    These transactions in QuickBooks accounts keep your balance sheet and profit and loss statements up to date. Remember that you should continue to do all of your payroll reporting using our payroll service.

    Pay split between paper check and direct deposit

    We recommend that you print checks in our payroll service, not in QuickBooks. If you choose to print checks from QuickBooks, only the paychecks can be printed from QuickBooks. The pay stubs will still need to be printed from Online Payroll.

    Currently, you must NOT print a paper check in QuickBooks for a paycheck created with our payroll service if your employee receives part of the pay as a direct deposit and part as a paper check. If you print a check in QuickBooks for this type of a pay transaction, the printed check will include the amount already direct deposited and you will overpay the employee.

    Working with more than one QuickBooks company

    If you export payroll to more than one QuickBooks company, you must change your export connection.
    1. In QuickBooks, open the company file you want to export to.
    2. In our payroll service, click the Setup tab.
    3. Under the Expot heading, click Preferences.
    4. At the Export Preferences page, next to QuickBooks File, click Connect.
    5. Follow the instructions on the page to complete the new connection.

    Top Answers

    Resources

    Most Used Forms

    Find and download individual and federal forms required for your business.

    Payroll Tax Support

    Stay in compliance, ensure you're up to date on all necessary tax agency information from Federal to State agency

    ViewMyPaycheck

    Give employees 24/7 access to payroll information they need.