CSA: QuickBooks Pro Data Import

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:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

You can use Accountant's Assistant to import client data from Intuit's QuickBooks Pro (including both Premier (also Accountant's Edition) and Enterprise editions for the years currently supported by QuickBooks. Information can be imported into Accountant's Assistant only from the client's *.QBW files. Accountant's Assistant is provided with the CBS Master License. You can import client data from QuickBooks, and you can use Accountant's Assistant to transfer certain types of transactions (adjustments) back to the client's QuickBooks program.


Import procedure

  1. In QuickBooks Pro, QuickBooks Premier, or QuickBooks Enterprise, open the QBW file for the company from which you will be retrieving data.

    Note: If you do not own a version of QuickBooks, retrieving company information from QuickBooks is still possible with the use of the CS QuickBooks Data Utility. For more information on the CS Quick books Data Utility, refer to Using the CS QuickBooks Data Utility. If the company data has been created with a file by the CS QuickBooks Data Utility, skip this step and proceed to Step 2.

  2. Open the client in CSA that corresponds to the client's QuickBooks Pro company.

    Note: The General Ledger module must be selected for this CSA client. If you are importing payroll information from your client's QuickBooks Pro company, you must also select the Payroll Compliance module for the client.

  3. In CSA, choose Utilities > Accountant's Assistant > QuickBooks Pro.
  4. Choose Setup > Miscellaneous Information to open the Miscellaneous Information dialog. Choose the General Ledger account to use for unassigned by selecting it from the drop-down list.
  5. (Optional) You may choose to mark any of the following checkboxes:
    • Do not import employees or payroll checks
    • Import only employees and payroll checks
    • Do not import inactive employees
    • Do not import inactive vendors
    • Skip Chart of Accounts Assignment
    • Do not import classes
  6. (Optional) If you want to create a GL transaction when you retrieve payroll checks from QuickBooks Pro, mark the Create payroll journal entry checkbox, and then click the option for the type of journal entry to be created.
  7. Click one of the options to set the date for the payroll entry and then click OK.
  8. If you are bringing in payroll checks, you also have the option to choose how to update the Earnings. You can choose from the following two options:
    • Use the current Payroll period ending date - Choose this option to use the current Payroll period ending date as the period in which to update earnings and enter payroll checks.
    • Use the check date's month - Choose this option to use the check date's month to determine in which month the earnings will update and payroll checks will be entered.
  9. Choose Tasks > Retrieve to begin importing QuickBooks Pro information. You will be prompted to backup your client data before continuing to import QuickBooks data. After you have created the backup copy, the QuickBooks Pro Data Location dialog opens.
  10. The Retrieve Options dialog opens. Click the appropriate option to indicate whether you are importing from a .QBW company data file or from a file created by the CS QuickBooks Data Utility, and then click the OK button.
  11. Depending on the option you selected in the previous step, either the QuickBooks Pro Data Location dialog or the QuickBooks Export File Location dialog opens. Navigate to the appropriate location and then click Open or OK.
  12. The QuickBooks Pro Date Range dialog opens. Enter the date range in MMDDYY format for the data you want to import and then click Retrieve. (Only transactions that fall in the specified date range will be imported. If your client has entered a transaction since the last import with a date prior to your date range, that transaction will not be imported into Accountant's Assistant.)
  13. The QuickBooks - Application Certificate dialog opens automatically in QuickBooks:
    • Click the Yes, always; allow access to the data even if QuickBooks is not running option.
    • Mark the Allow this application to access personal data such as Social Security Numbers and customer credit card information checkbox.

If at any time, you need to verify the certificate is valid, or you need to delete the certificate, you can access it without going through another import. In QuickBooks, under Edit/Preference, select Integrated Applications and select the Company Preferences tab to see the applications that have been given permission to access the selected QB company file. If you have already granted permission to access a QB company file, Accounting CS – QuickBooks Import will be listed here.

  1. Click the Continue button, and then click the Done button at the Access Confirmation prompt.

    Note: When you attempt to retrieve data from a QuickBooks company file for the first time, you will be prompted by QuickBooks to grant permission to access the company data. You will not be prompted again if you subsequently attempt to import from that same company file. However, if you receive a new copy of the QuickBooks data for the same client company each period, you will be prompted in QuickBooks each time you import.

  2. The Chart of Accounts Assignment dialog opens automatically during the import process. If the QuickBooks account number is valid (based on CSA account number criteria) and is not mapped to an existing CSA account within this dialog, it will be automatically added to CSA upon transfer.
  3. If there is no active payroll subscription for the QuickBooks data being imported, a message prompt opens to alert you that no payroll checks will be imported. Employees may still be imported, but no checks or earnings will be included. (If you do not need to import payroll data, prior to the import you may choose Setup > Miscellaneous Information from within Accountant's Assistant and mark the Do not import employees or payroll checks checkbox.)
  4. If the client has been flagged to use the Payroll Compliance module, the Payroll Item List opens. From the drop-down list on the right side, choose the CSA payroll item that corresponds to the QuickBooks Pro Payroll Item and then click OK. You must choose a CSA item for each QuickBooks Pro item before you can proceed.
    • The CSA payroll item that you select should be the same type (pay, withholding, or deduction) as the item in QuickBooks.
    • Do not assign the CSA default item Direct Deposit to a QuickBooks Pro direct-deposit item. That would cause the transactions to appear twice in the Bank Reconciliation window.
    • Employer-paid withholding and deduction items must contain either the word company or the word unemployment in QuickBooks to be excluded from the Payroll Item List.
  5. The import from QuickBooks attempts to match existing CSA employees with employees from the import data based on Social Security Number. Any unmatched employees are displayed in the Assign QuickBooks Employees to CSA Employees dialog, which opens automatically during the import. Select an existing CSA employee to be matched to each employee or mark the New CSA Emp checkbox and assign a unique employee ID. Click OK to proceed with the import.
    • You may match only a single QuickBooks employee to each existing CSA employee.
    • When adding a new employee, you must assign a unique employee ID.
    • If no employees exist in CSA prior to the import, the Assign QuickBooks Employees to CSA Employees dialog does not appear and employee IDs are assigned starting with ID 1 and incremented by 1. You may renumber employees after the import; subsequent imports continue to use the employee IDs as you have renumbered them.
  6. When the import is complete, choose Tasks > Process Transactions to view the imported data. You will need to replace any blank accounts with the Undistributed Account or individually edit each transaction with a blank account and provide an account number using the Edit > Edit Accounts dialog.
  7. You can also run the diagnostic reports from the File > Print Reports dialog to see what Chart of Accounts, Vendors, and Employees have been added, changed or deleted and you can run the Transaction Report to view or print all the transactions imported from the client.
  8. Once the Process Transactions and Reports have been reviewed the last step is to Transfer to CSA available from the Tasks menu or clicking on the icon from the shortcut bar.

Additional information

Internal notes

Additional information regarding importing QuickBooks as Cash basis, see Issue Tracker 68251.  

Some success (not all) has been gained if the QuickBooks file is setup as cash basis and they follow these steps:

  1. Allow for separate journals (Client Properties > General Ledger tab).
  2. After import from QuickBooks, create temporary journal (Setup > journals).
  3. Transfer unwanted transactions into temporary journal (Transactions > F3 > Transfer Transactions),
  4. Then delete the temporary journal (Setup > Journals).
  5. Repost transactions.

There isn't a way to change the QuickBooks company to cash basis once it is set up. If the user skipped the "easy step interview" (in QuickBooks) when setting up the client, the client will be on an accrual basis.

When setting up a new QuickBooks company, you must go through the Easy Step Interview when setting up the company and answer no to "do you want to keep track of bills you owe," and no to "Do you want to use Invoices in QuickBooks?" to be on cash basis.

However, if the user ever uses Vendors > Enter Bills or Customers > Create Invoices for transactions in the range they are retrieving, QuickBooks will automatically accrue those transactions to A/R or A/P. This is why the user will see entries in CSA in Accounts Payable or Accounts Receivable accounts - it doesn't even matter if the bill was paid right away. The user may believe they are on cash basis because they have checked the box to make the report basis in QuickBooks "cash" under the display tab of the report.

Share This