Creative Solutions>ACS Transactions

Accounting CS™ (ACS) is a registered trademark belonging to Thomson Reuters™.

Transactions posted in ACS may be imported into FCA by exporting the ACS General Ledger report for the desired periods to Excel.

Open Accounting CS (ACS) and the client file.

1. Select Reports.
2. Select General Ledger.
3. Select Range in the Date field and enter the desired Dates.
4. Check options as desired in the Journal Entry Format field.
5. Click Print Selected.
   
   
6. Uncheck Output to printer.
7. Check Output to file.
8. Select Microsoft Excel.
9. Check Open file when complete.
10. Click OK.
    
    
    In Excel:
    
    
11. Select File>Save As.
12. Select CSV (Comma delimited) in the Save as type field.
13. Click OK on the dialog box which says: "The selected file type does not support workbooks that contain multiple sheets."
14. Close the file.
    

Open Full Contact Accounting™ (FCA).

1. Select File>Imports>Creative Solutions>ACS Transactions.
2. Click the browse icon next to the Import File box and locate the desired file.
3. 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 on 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.

4. Map the accounts. The Account number and Description from Creative Solutions will be on the left. 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.
5. 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 appear 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.