Acting Commissioner Kristin M. Woodlock, RN,
MPA
Governor Andrew M. Cuomo
Now You Can Import Data from Your Accounting System Into CFRS
What Data Can You Import?
- Expenses/Revenues
- Personal Services for Employees
- Personal Services for Contractors
- Fringe Benefits/Program Administration (OPWDD-4)
- Worksheet Detail
What Are The Benefits?
- Faster data entry
- More accurate data entry
- Data in a format used by auditors
- Data summed by software
What Are The Requirements?
- The Data from your accounting system must be fixed length, fixed field text files.
- You must generate and prepare your own data files, OMH cannot assist you with your exports from your accounting system.
How Does it Work?
- First, you must export your data into a spreadsheet.
- Then, edit your data file to conform to CFRS template.
- Save your data as a text file.
- 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.