This site  The Web

Flex Accounts
Flex Accounts

HomeProductsDownloadsPurchaseF.A.Q.

The Flexible Spending Account Administration Solution

Importing data from your Payroll or HR system into Fast-Flex Plus

The key to importing data into Fast-Flex Plus lies almost entirely in being able to export data in text (ASCII) format from the program where it currently resides. We won't be of any help in telling you how to export data out of your other program(s) - you'll have to contact that program vendor.


Once you have gone to "Main Menu>File>Start New Company" to hold your imported data and have the text files ready to import in the proper formats (comma-delimited for the employee records and fixed-length for the paycheck withholdings) getting data from an external source into Fast-Flex Plus is easy. Refer to the manual for additional specifics. (pages 119 and 131)


For your practice or as an example, there are two small files that we have included in the root data folder for your installation of Fast-Flex Plus (probably in either C:\..\[My] Documents\FFP or X:\FFPRO4) that can act as a guide for you in building your own data import files. Open these file to examine them by first starting NOTEPAD.exe. Examine each file with Wordwrap turned off in NotePad. Also, it is important to set the Notepad font to Courier new, size 8, or a similar non-proportional font.



WHDIMPRT.DAT is an example of a fixed-length, paycheck withholdings import file. (Use the built-in guide at the top of the page to identify column numbers.) Importing Paycheck withholdings might turn out to be something you do regularly, so Fast-Flex Plus will save your import file layout settings so that you won't have to re-enter them each time.

HERCULEN.CSV is an example of an Excel-type *.CSV employee record file. If you double-click on it, it may open in Excel (if you have Excel) so open it by first starting Notepad instead. It also has a guide at the top of the page, but instead of column numbers, this one simply counts the number of data fields (separated by commas) in the first record. All subsequent records are assumed to have the same number of fields.


Note that the import files do not require you to have data available for all of the fields in the Fast-Flex Plus employee and transaction databases - just enter what you have available from your payroll or HR system.


Finally, please note that you can hold the mouse over our Employee Import File Layout form field labels for a more detailed description of the data format that is required. For example, the date fields require the slashes in the MM/DD/YY format and the Social Security field requires hyphens.


Below is how you would set up the importation of the HERCULEN.CSV employee records (make sure to indicate where YOUR input file is located rather than just accepting our default path) into a new Company data folder using our Import File Layout tool. For example, if ZIP Code is the fourth field in YOUR import file records, enter "4" into our "Zip" field.



 

 




One final suggestion: Depending on the number of employees you have, often it is best to get as much data as you can via the import tool and then use the Batch Update Employee Records (p.48) to hand enter the rest of the employee information.