Skip to Main Content

Office of Mental Health

Now You Can Import Data from Your Accounting System Into CFRS

What Data Can You Import?

What Are The Benefits?

What Are The Requirements?

How Does it Work?

  1. First, you must export your data into a spreadsheet.
  2. Then, edit your data file to conform to CFRS template.
  3. Save your data as a text file.
  4. Finally, Import the data into CFRS.

What are the CFRS Templates?

Expense and Revenue

Data Elements for Expenses and Revenue Import
Data Element Data Type Width Positions
Site Key Character (text) 6 1 – 6
Cost Code Character (text) 5 7 – 11
Amount Numeric 10 12 – 21

Personal Services for Employees

Data Elements for Personal Services Import
Data Element Data Type Width Positions
Site Key Character (text) 6 1 – 6
Position Code Character (text) 3 7 – 9
Std. Workweek Numeric 5, 1 decimal place 10 – 14
Hours Paid Numeric 7 15 – 21
Amount Numeric 10 22 – 31

Contract Services for Contractors

Data Elements for Contract Services Import
Data Element Data Type Width Positions
Site Key Character (text) 6 1 – 6
Position Code Character (text) 3 7 – 9
Hours Paid Numeric 7 10 – 16
Amount Numeric 10 17 – 26

Fringe Benefits and Program Administration

Data Elements for Fringe Benefits and Program Administration Import
Data Element Data Type Width Positions
Site Key Character (text) 6 1 – 6
Cost Code Line Number Character (text) 2 7 – 8
Amount Numeric 10 9 – 18

Worksheet Detail

Data Elements for Worksheet Entry Import
Data Element Data Type Width Positions
Reference Type Character (text) 4 1 – 4
Site Key Character (text) 6 5 – 10
Schedule Character (text) 8 11 – 18
County Code Character (text) 2 19 – 20
Line Number Numeric 4 21 – 24
Amount Numeric 10 25 –34
Description (for custom entries only) Character (text) 60 35 – 94

For More Information:
Contact us at 1-800-HELP-NYS or email and we will send you a free training CD, Importing Data into CFRS.

Back   |   CFRS Home Page   |   Table of Contents