Once you have matched all columns of imported data to valuation extract results, you are ready to finalize plan coding.

The documents gathered at the start of the conversion include benefit calculations and, if available, benefit statements. These will be used to confirm that you have coded the plan correctly and in a manner which is consistent with prior calculations.

You should have a representative sampling of different possible benefit calculations when testing the calculation coding. Different situations such as early retirement, late retirement, breaks-in-service, and lump sum calculations should all be covered if applicable.

When checking benefit calculations, all calculation details and benefit options should be verified. Any benefit calculation detail that you want to include in benefit calculation output will need to be its own Formula Derived Item.

If you have benefit statement results that are available, these results should be used to help validate that you have coded the plan correctly. You should copy all of the statement data into a separate tab in your conversion Excel Workbook and then create compares for each row similar to what was done with the initial import. You should then compare prior statement results with the results from a plan-level export (see next topic).