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 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

• In addition to the features listed below, the spreadsheet import enables the following items to be imported:
  • Adjusted budget balances
  • Creative Solutions tax codes or M-3 tax codes
  • AccountWare tax codes that will convert to CSA tax codes
  • Tax code unit (to support multiple units; this number is prefixed to the Creative Solutions tax code)
  • Tax code account groupings, or Schedule M-3 tax code account groupings
  • Grouping codes and subcodes (for a Trial Balance CS client only)
• To create a valid spreadsheet file for import into the CSA Chart of Accounts, you must specify at least one account number column and one type column.
• To open the Column Title dialog, double-click within the column heading, or right-click within a column and choose Edit Column Title from the context menu.
  • The column title specifies where the data from the selected column is to be placed when the spreadsheet information is imported into the CSA Chart of Accounts.
  • You may specify the column titles either before or after data has been entered or pasted into the Spreadsheet Import grid.
  • Each column title (including amount type and period) must be unique and can be used only once in the Spreadsheet Import grid.

    Note: Any attempt to create a previously established column title will result in an error message that indicates the column already exists.

  • You may use any column order within the Spreadsheet Import grid. If each column heading has been identified correctly, the data will flow to the appropriate fields within the CSA Chart of Accounts window.
  • Information copied and pasted from a source spreadsheet should be formatted in like columns within the Spreadsheet Import grid - for example, with account numbers listed in column A, account types in column B, and so forth.
  • If you require additional columns beyond the number available by default in the Spreadsheet Import grid, and then specify the column titles.
• To record a credit amount in a Dr > Cr column, enter the amount as a negative number using the - or ( ) symbols.
• To record an amount in a Credit column, enter the amount as a positive number.
• To ensure that the information is imported properly into the CSA Chart of Accounts, verify that the account numbers conform to the Chart of Accounts mask for the selected client and that the account types and descriptions conform to the standard Chart of Account specifications. Also note that the application automatically truncates data from the Spreadsheet Import grid during the import if the data field exceeds the maximum length of the corresponding field within the CSA Chart of Accounts window. Account numbers with leading 0 will not import, so any such numbers would need to be adjusted prior to the import.

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.

Fields & buttons

Setting

Paste button

Spreadsheet Import grid

Year-to-date balances (checkbox)

OK button

Related topics

• Did you know (Spreadsheet Import)
• Spreadsheet Import > Column Title dialog
• Spreadsheet Import > Save Spreadsheet Setting dialog
• Spreadsheet Import > File Options dialog

Was this article helpful?

Yes No

Submit