Importing client data from QuickBooks Online

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

If your clients use QuickBooks Online, Accounting CS enables you to import those clients' data (transactions, chart of accounts, vendor records, and bank accounts) for processing in Accounting CS.

Note: Intuit does not currently offer a way for Accounting CS to import payroll information from QuickBooks Online. Intuit may introduce this capability in a future release of QuickBooks Online.

If your firm runs Accounting CS locally, you must have Internet Explorer 10 or higher installed on that computer, or have the Internet Explorer 10 Compatibility View settings enabled by your network administrator, for the QuickBooks Online integration to work properly.

  1. Choose File > Import > QuickBooks Online.

    Note: The first time you choose this command, the application displays the QuickBooks Online Integration license agreement. You must read the license agreement, mark the I accept the terms of the license agreement checkbox, and then click OK before you can continue. Once you accept the terms, the application will not display the license agreement again.

  2. In the QuickBooks Online Import dialog, select the client for whom you want to import data.
  3. Click the Connect to QuickBooks button, and then enter the appropriate user ID and password to log in to the client's QuickBooks Online account.

    Note: After you successfully log in, the Connect to QuickBooks button changes to a Disconnect button. The application keeps you logged in to the client's account until you click the Disconnect button. QuickBooks Online sends a security token to Accounting CS, and that token is valid for 180 days. However, after 159 days, Accounting CS automatically attempts to re-authorize the token.

  4. In the Import details section, mark the checkbox for the types of data to import.
  5. In the Import date range fields, specify the date range for which to import the client's data.
  6. Click the Retrieve data button to retrieve client data from QuickBooks Online. After Accounting CS retrieves the data, it automatically opens the QuickBooks Online - Manage Data dialog, where you can map data to new or existing data in Accounting CS.
  7. In the QuickBooks Online - Manage Data dialog, select the transactions to import and then map the client's data from QuickBooks Online in each applicable tab. After you have mapped all items, click OK. If there is data ready for import, the application initiates the import process.

    Note: Every QuickBooks item must be mapped to an Accounting CS item before the import can proceed. If any items have not been mapped, Accounting CS will flag those items and include them in the error count in the Error navigation section.

  8. After the data has been imported, open the following screens in Accounting CS, as applicable, to verify that the data imported correctly.

    In addition, you may wish to generate the following reports to help you verify the data.

    • General Ledger
    • Chart of Accounts - Detailed
    • Vendor List - Detailed

Note: You can open the QuickBooks Online - Manage Data dialog at any time to review and/or change the item mapping for future imports. The application will not change the mapping of any data that has already been imported.

Related topics

Modifying multiple transactions

QuickBooks integration overview

Importing client data from QuickBooks

Importing QuickBooks account balances from a spreadsheet

Share This