Warning
Product support for the ended on September 30, 2020.
- Write Up CS
- Payroll CS
- Engagement CS
- Client Bookkeeping Solution
- Financial Analysis CS
Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.
Use this dialog to format each data column within the Spreadsheet Import grid.
Choose Utilities > Import > Spreadsheet. Double-click any column heading within the Spreadsheet Import dialog (or right-click within a column and choose Edit Column Title from the context menu) to open the Column Title dialog and then specify the appropriate column title. For a Beginning Balance or Period Balance column, you also need to specify additional information.
Note: 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 or, if applicable, to the Tax Code Account Groupings dialog or the Schedule M-3 Tax Code Account Groupings dialog.
See also: Spreadsheet Import [Utilities menu]
Special information
- It is possible to have two columns for the same period in the spreadsheet - one with debit balances and one with credit balances, in which case the column title represents a unique combination of name, period, and amount type.
- For a Beginning Balance column (GL client only), the period selection is based on year.
- For a Period Balance column (GL or Trial Balance client), the period selection is based on period-end date.
- Only one Tax Code column (for either the CS tax code or the AccountWare tax code) may be specified within the spreadsheet grid.
- For a Trial Balance client: Be sure to verify that the Grouping Schedule Codes or Subcodes to be imported have already been defined within CSA.
Fields & buttons
Highlight the appropriate item from the following list to specify the column title (type) for the selected column within the Spreadsheet Import grid:
- Account Number
- Account Type
- Description
- Beginning Balance (for a GL client only; compatible only with account types A and L; also specify the Period and Amount Type)
- Period Balance (also specify the Period and Amount Type)
- Current Year Budget
- Current Year Adjusted Budget (imports a Budget journal entry with a reference of BJE99)
- Creative Solutions Tax Code
- Creative Solutions M-3 Tax Code
- AccountWare Tax Code
- Tax Code Unit (to support multiple units; this number is prefixed to the Creative Solutions tax code)
- Tax Code Account Groupings
- M-3 Tax Code Account Groupings
- Grouping Schedule Code or Subcode (for a Trial Balance client only)
- Not Used
Notes
- 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 is 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. (The OK button is grayed out if a column title is repeated.)
- For Beginning Balance column (GL client only), choose the appropriate year by selecting it from the F4 drop-down list. Also specify the amount type - Dr/Cr, Credit, or Debit.
- For a Period Balance column (GL client or Trial Balance client), choose the appropriate period-end date by selecting it from the F4 drop-down list. Also specify the amount type - Dr/Cr, Credit, or Debit.
Example
For a Beginning Balance column (GL client) or a Period Balance column (GL client or Trial Balance client), you also need to specify the amount type - Dr/Cr, Credit, or Debit.
Notes
- 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.