Spreadsheet Import . . . Import Analysis

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 Import Analysis dialog opens automatically at the end of the spreadsheet import process. It presents a detailed summary of the import data and to a limited extent contrasts data from the client's existing Chart of Accounts.

To print a copy of the information displayed in this dialog, click the Print button.

To complete the import process, click the Done button.

See also: Spreadsheet Import [Utilities menu]

Contents of the analysis

Total accounts read: Displays the total number of accounts read from the import file.

Total new accounts: Displays the number of accounts in the import file that do not already exist in the selected client's Chart of Accounts.

Total existing accounts with no match in the transfer file: Displays the total number of accounts in the selected client's Chart of Accounts that are not duplicated by any accounts included in the import file.

Total accounts with duplicate account numbers in the import file: Displays the number of occurrences of duplicate account numbers within the import file. If account numbers are duplicated more than one time, they still are only counted once. (The duplicate account numbers are listed in the body of the report.)

Note: The last balance is the one that is used in the import if there are duplicate account numbers found in the import file.

Net beginning balance - current year: Displays the net balance for all debit and credit beginning balances within the import file for the current-year within the import file only, and not within the whole Chart of Accounts after the import. (This information is repeated as applicable for prior years 1-9.)

Net periods balance changes - current year: Displays the net balance for all debit and credit period balances within the import file for the current year within the import file only, and not within the whole Chart of Accounts after the import. (This information is repeated as applicable for prior years 1-9.)

Note: The status should be N/A unless the period(s) is out of balance.

Total accounts with amounts - current year: Displays the total number of accounts for which amounts existed in the import file. (This information is repeated as applicable for prior years 1-9.)

Top of page

Share This