Visual Solutions offers import modules for these key data entry areas of the FUNDamentals program:
These imports have been designed to be extremely flexible and easy to configure. The imports can work with any comma-separated text file that contains the necesary data elements. The field positions are completely user-defined and data elements may be the result of a computation on two or more fields. The Meal Counts, Inventory, and Labor Hours imports have the optional ability to import revenues and/or expenditures. All imports create monthly summaries by cost center. All imports provide full error checking and error reporting before the actual import takes place. The user may print the error list and cancel the import in the event that errors were detected. Other custom imports may be purchased based on a small hourly rate. Please call Visual Solutions at (888) 228-3120 for details.
In order to give you an idea of the data elements needed for each import, the following screen shots have been provided.
New Flash Video shows you how easy it is.
Financial Import for FUNDamentals
Import File Layout Screen
Please note the data elements in the Field Positions section. The Special Code is an optional means of identifying a particular revenue or expenditure where code combinations are used. The import accepts a wide variety of date formats.
General Ledger Mapping Setup Screen
Please note that the expression in the Expense Code box is a range of expense codes. The import also accepts single codes or multiple single codes separated by commas. The expression may even be a combination of single codes and ranges, for example, 610-629, 632, 635-640. The Sub Categories are user-defined and may be added or edited through the FUNDamentals program. Also, note that a revenue or expense category or sub category may be excluded from the import. This may need to be done when these revenues or expenditures are being captured from another source, for example, Student Meals Sales or Federal Reimbursements. It may be preferable to capture these from a Point of Service export, or by generating the revenue based on meal counts obtained through a Point of Service export.
Point of Service Import for FUNDamentals
Point of Service Import Module for FUNDamentals Main Screen with Import Options
This screen shows the available import options and preferences for the Point of Service Import Module.
Data Element Mapping Setup Screen
This screen shows available data entry elements for this import. A 0 means that the data element does not have a source and will not be imported. This example shows a useful feature of this import that allows the user to view the elements by actually loading a file and displaying the information as defined by the map.
Revenue Mapping Setup Screen
This screen is used to map field positions in the import file to optional revenues. The revenue categories may be user defined and added or deleted as needed. Again, please note that the file has been loaded, and sample data is available for easy setup and troubleshooting.
Inventory Values Import Module for FUNDamentals
Data Element Mapping Setup Screen
This screen shows the data elements used for the importing of inventory values. This example shows a file loaded for testing.
Custom Fields Setup Screen
This screen shows the custom fields setup. Notice that the same field may be used for a revenue and expense simultaneously. An unlimited number of Custom Fields may be added.
Labor Hours Import Module for FUNDamentals
Data Element Mapping Setup Screen
This screen shows the required data elements needed for the Labor Hours Import. Notice the option for Labor Hour Formatting. The example shown is using a payroll system export with a total time column expressed in hours and minutes. (e.g. 8:15) In this instance the import will convert this value to a decimal format. (e.g. 8.25)
Custom Fields Setup Screen
This screen allows the user to define custom fields for import into the FUNDamentals program. The custom fields may be revenues or expenditures and may be mapped to any revenue or expenditure subcategory.
