Convert the client data before importing into Accounting CS
Complete these steps to create the Sage 50 Accounting conversion files. These files are specially formatted files that Accounting CS uses to import your data.
- To begin the conversion program, right-click the CS Data Conversions icon on your desktop and selectRun as Administrator. If you didn’t install the shortcut, selectStartfrom the Windows taskbar, thenAll Programs,CS Professional Suite, thenCS Data Conversions.
- In theConversion Typefield, selectAccounting CSfrom the dropdown.
- In theCompetitorfield, selectSage 50 Accounting.
- In theOutput Data Folderfield, enter the path to the folder that you want the converted files placed in. The path defaults to the current users Documents folder,C:\Users\XXXXXX\Documentswhere XXXXXX represents the current user ID. SelectBrowseto go to an alternative location of your choice. The conversion files will be created in this location in a subfolder using the Client ID.
- SelectStartto begin the conversion.
- The conversion program lists all clients found in the specified data folder. Select a client, thenContinue.
- Enter the bank name and routing number for your checkbook and savings accounts. SelectAdd Bank Accountsto add all accounts associated to the bank and the routing number entered.
- Enter the bank account details in the fields provided.Account DescriptionandAccount Numbermust be unique for each account.
- Select theAccount Type. If the account type isChecking, enter theNext Check Number, 100 or greater, the associatedGL Account Number, and select whether this item is a vendor checkbook, payroll checkbook, or both. You may select only 1 payroll checkbook and\or 1 vendor checkbook per client. Once the details are entered for a single account, selectAdd.
- Complete step 8a for every account associated with the same bank and routing number.
- After adding all accounts, selectDone.
noteA vendor checkbook and a payroll checkbook are both necessary for a detailed conversion. Failure to add either of the checkbooks will prevent the conversion of employee earnings, vendors, and\or GL transactions. If you need to start over, selectClearto erase all information in the data entry fields, but retain the data that is already saved to the grid. - Verify all bank information. SelectDone.noteTo remove a row in the grid, highlight a row and selectRemove. Double-click in a specific field to edit the detail for that field.
- Repeat steps 7 through 9 until all banks and checkbooks/savings accounts are added.
- SelectDone.
- If local taxes are used for a client, select the tax name from the dropdown, enter the two-character state ID, then selectAdd. Repeat this step to enter all localities. SelectDone.
- When the conversion is complete, the program replaces the Conversion Status message with a message indicating the data is ready for import. SelectOK.
- To convert data for another client, repeat steps 5 through 13.
- The Sage 50 Accounting to Accounting CS conversion generates a PDF conversion report and saves the report to the data location specified in step 4. The report contains notes and information on changes you may need to make to the client data in Accounting CS. You can view and print the report using Adobe® Reader® version 7.0 or later. If Adobe Reader is not already installed on your computer, open Accounting CS and go to . This takes you to the Adobe website, where you can download and install the Reader.