Spreadsheet Import [Utilities menu]

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.

The Utilities > Import > Spreadsheet command enables you to copy and paste data from an existing spreadsheet for import into the CSA Chart of Accounts window for the selected client. The Spreadsheet Import dialog enables you both to view the data you will be importing and to format the columns so the data will flow appropriately into the CSA Chart of Accounts window or, if applicable, to the Tax Code Account Groupings dialog or the Schedule M-3 Tax Code Account Groupings dialog.

Choose Utilities > Import > Spreadsheet. Double-click each column heading (or choose Edit Column Title from the right-click context menu) and specify the type of information to be entered or pasted into that column. You may copy and paste or enter data directly into the grid on the Spreadsheet Import dialog.

The columns from import may include many different types of information.

Special information

Import features and steps

Additional steps for import of location/department accounts

If you are importing accounts that contain location and/or department designations, you may need to take a few additional steps.

If this is a new Chart of Accounts, do the following:

  1. Change the client's Chart of Accounts mask (on the General Ledger tab or Trial Balance tab of the File > Client Properties dialog) to include the number of Ls and/or Ds that you will need.
  2. Open the Chart of Accounts window.
  3. Enter location and department descriptions for the client.
  4. Import the combining or core accounts only, without balances.
  5. From the Chart of Accounts window, choose Edit > Renumber Range of Accounts. In the Renumber Range of Accounts dialog, click the Change to Loc/Dept button, select your accounts, and enter the first location and/or department number. Click OK to renumber all your accounts to the desired location and/or department and create the necessary combining accounts.
  6. From the Chart of Accounts window, choose Edit > Enter Combining Accounts and verify that the Chart of Accounts has been correctly converted and that all core account numbers are listed, and then click Done to close the Combining Accounts dialog.
  7. Choose Utilities > Import > Spreadsheet Import and then copy and paste your Chart of Accounts data into the grid, assign column headings, and complete the import your Chart of Accounts.

Note: If your CSA client already has an established location/department Chart of Accounts and you are simply importing new accounts, you must first add a combining account for each new core account. After confirming that the combining accounts have been added, follow step 7 above to import the new accounts.

Top of page

Fields & buttons

Did You Know button

Related topics

Top of page

Share This