- Print
- DarkLight
- PDF
How do I import FACTS summary investment returns?
Import investment returns directly into FIMS by using a comma-separated (.csv) file. This import creates or updates FACTS reconciliation records using values defined in the CSV file or specified on the import screen.
Note: Once you configure your import, you can click the Defaults button and save your configuration for use in future imports. If you name a configuration Default, it automatically loads each time you run the import. You can still choose to run the import based on a different configuration, but the one named Default will be your first choice.
Tip: You can create a .csv file by opening the data you want to import in a spreadsheet, selecting File > Save As, and then selecting the .csv file type.
Tip: Negative numbers need to be formatted with a negative sign.
Once your .csv file is ready to be imported, you can import the investment returns as follows:
- From the main menu, select File Maintenance > Import FACTS Account Summary Reconciliation.
- Select the file to import by clicking the browse icon next to the Import File field. Data from this file will be imported.
- Set your import options:
- If you want to specify which rows in the spreadsheet to include, you can enter the first and last row numbers.
- If the first row contains the column labels be sure to enter 2 in the Import Row From field.
4. In each drop-down, select one of the following. The available options vary depending on
the field.
Select: Select this option if you did not include the data in the spreadsheet, and you want to apply the same information to all records in this file. Once you choose Select, you will be able to enter the desired information or select it from a lookup.
Column #: If you included the data in your spreadsheet, and your columns are numbered, select this option and then enter the desired number.
Column Letter: If you included the data in your spreadsheet, select the letter associated with the appropriate column.
Be sure to identify which column the Investment Account ID code is in. This field is critical to make sure the right investment account is being updated in each case.
Notes:
The Begin Date field has the option to choose “From Last Cycle” versus an actual date field from the data file. You can also check the box to “Add day” to begin date. This will take the ending date from the previous cycle and add 1 day for the start date of the next cycle to be reconciled.
The Begin Market also has the option to choose “From Last Cycle” so that it will use the ending market value from the previous cycle reconciled.
The Unrealized Gains field has an option to “Calculate”. This will calculate the unrealized gains amounts based on the other values in the import file.
Once you have completed mapping the FIMS fields to your spreadsheet’s columns, save your import settings by clicking Defaults. This will prevent you from having to map the columns again each time you perform the import.
5. To complete the import and update the records, click Import.
Note: If you want to run the FACTS allocations and entries for the imported records. Click Yes.
Click yes to the pop-up message.
Continue processing as normal.
The screenshots below are of the data in the import data file and the report where you can review the data and finish creating the records.
Screenshot 1
Screenshot 2