FAQ 2186: Importer: Nationwide new file layout

Problem: Nationwide just created a new file layout - How can we import this into ASC?

Solution: We have reviewed a few of these downloaded files. The format appears to be a match for the csv file which works through Importer-American Funds-Recordkeeper direct. The main issue is the source identification. The Nationwide file is showing only numbers for the source column and not source text or money type names. We "think" it's possible Nationwide continued their same source naming structure from their PPA system. We do have this source legend in the DC 401k training manual, chapter 5 as well as in the ASC system, Importer-Nationwide-Values-Sources. We advise checking individual participants dollar values per source prior to importing to insure proper source mapping. Then we suggest altering the csv file for the Source numbers to be a match to the ASC plan. (Do this in excel using find/replace). Some clients are experiencing issues with the loans mapping to loan accounts properly. After working with one client's files exclusively, we came up with this VIF to import and fix the loans using the same csv file (no manipulation as long as the ASC source numbers are in the file - noted above) that was imported via Importer. Below is a link to the VIF -- caution should be used - the fund number can be altered based on the formula FUNDNUM it defaults to fund #1. The Loan number must be LOAN#1. https://csc.asc-net.com/csc/asc_client/download/User%20Documentation/Nationwide_Loan_Adjustment.VIF Step 1: Manipulate the csv file for the fund columns if needed but most importantly change the source numbers to match the exact source number for the ASC plan. Step 2: Import csv file via American Funds - Recordkeeper Direct map funds/sources and import. Step 3: Loans will import to the LOAN accounts (loan 1) but they will be incorrect and the ending balances for the Values and Loans will be incorrect. From the opened plan, go to Ascript-Import-and open the Nationwide_Loan_Adjustment.VIF and then open your original csv used to import through Importer from Nationwide, click on Finish, NO, and UNCHECK the Print Report option and check to either Run Test or Update. Included here is a link to Nationwide's transition website https://www.nationwide.com/campaigns/TPAtransition