Creative Solutions>CSA Transactions

Creative Solutions Accounting™ (CSA) is a registered trademark belonging to Thomson Reuters™. Use this function to import historical data from CSA when converting a client.

Export File from CSA

1. Open CSA and the client file.
2. Select Utilities>Export.
3. In the Export dialog box, under Report Layout, select General Ledger.
4. Put a checkmark in the box to Include column headings.
5. The Format should be ASCII.
6. Under File, change the Location of file to be exported: by clicking on the Change Location box.
7. Change the name of the file to be created to be the company name and then add GL.ASC so another file is not overwritten.
8. Click the Options button.
9. In the General Ledger Report Options dialog box, under the General Tab, choose the following options from the drop-down lists:
   • Primary Sort order: Account Number
   • Secondary Sort order: select Reference.
   • Data range:
     • One period—Select the desired period to export.
     • Multiple periods—Select Selected Ranges which will make the Start and End boxes available to enter the range, as desired.
10. Click OK to save changes.
    
11. Click Export to create the file.

Import to Full Contact Accounting™

1. Open Full Contact Accounting (FCA).
2. Select File>Imports>Creative Solutions>CSA Transactions.
3. Click the browse icon next to the Import File box and locate the desired file.
4. Decide whether data is to be imported into the current period or Multiple Periods by Date.
   • Import a single period's data or data from multiple periods into the current period.
   • Import multiple periods by date range.
     • If this is a new file without any transactions, the dates in this dialog box will be ignored.
     • If this is a file with previous data into which data for additional periods is being imported, then enter the date range of the data to import.
     • Select multiple periods by date at the lower left.
       

       Note: As transactions are being imported into FCA™, periods will be created matching the dates of the transactions in the file. With imports to NEW files only, opening balances will be created in a period prior to the earliest transaction period found in the file.

5. Map the accounts. On the left will be the Account number and Description from Creative Solutions. Map them to the appropriate general ledger account in FCA.
   
   If the Chart of Accounts has been imported from Creative Solutions, click on the Find Matches button on the right and they will be mapped to the right accounts. Mapping can be edited prior to the import if desired.
6. Record checking account information in the right grid. In order for FCA to determine which checking account cash disbursements are made from, it needs to know the check range. For each checking account enter the following information:
   • Account—The map to the account.
   • Ref #—Enter the Credit to Cash Reference Number used in CSA.
   • Start Check and End Check—Enter the Start Check number and the End Check number of the range. If there is only one checking account, enter the Start Check number as 1 and End Check number as 99999.
7. Repeat this for all checking accounts.
8. Click OK when mapping is complete.

Note: A "Not Responding" message in the Windows Task Manager does not mean that the program is not working. A dialog box will open when the process is complete. DO NOT end the task or interrupt the import.

Undo—To delete all imported transactions, click on the Undo by batch drop-down list and select the desired batch. Click Undo to delete all transactions imported in the selected batch.