CREATIVE SOLUTIONS ACCOUNTING
Warning
Product support for the Creative Solutions Accounting platform ended on September 30, 2020.
Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.
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.)
Was this article helpful?
Thank you for the feedback!