If you are a subscriber to Thomson Reuters’ ONESOURCE FPS (706 and Fiduciary Accounting Software) software package, and use EstateVal as your source for security valuations, the EstateVal/ONESOURCE interface can help eliminate unnecessary manual entry of data between the two packages.
EstateVal to ONESOURCE FPS
To send evaluation data from EstateVal to ONESOURCE FPS, you’ll need to first configure the export file format. In EstateVal, select
Tools → Options… → Export and set the
Type field to “ONESOURCE” and the
Path field to the folder where you want the data sent.
Now that EstateVal is configured, evaluate the portfolio as usual, and then select
File → Export → From EstateVal… → Date of Death. You will then be prompted to enter an export file name; do so and click
OK. EstateVal will then write the data and show an alert that “The portfolio has been exported.”
Now that the data has been exported from EstateVal, you are ready to import it into ONESOURCE FPS. Run ONESOURCE and open the client you are working on. Select
File → Import → EVP and a dialog box will appear that asks you to select the filename you exported from EstateVal. Once you’ve picked the file, select the schedule and click
Now, a list of assets will be displayed. Here you can
Select NONE, or manually select and unselect individual items. When your selections are complete, click
Import. A message “Import complete” will appear. Hit
Alt+F9 to update the list, and click on the schedule at the bottom of your screen to view the imported assets.
Note: This method of data transfer only works for Date of Death evaluations. In order to transfer Alternate Date valuations, you need to start in ONESOURCE, as described below.
ONESOURCE FPS to EstateVal
To use EstateVal to gather security pricing directly from a portfolio on ONESOURCE, first you’ll need to create a client in ONESOURCE FPS and enter your asset information.
Once assets are entered, select
Edit → Asset Values → Securities Pricing. In the dialog box that appears, click
Set Evaluation Service, select
EVP, and enter the path were EstateVal is installed.
Now, select the report type under
Values and enter the
Valuation Date. Select some or all of the securities to send to EstateVal for pricing, and then click
Get Values. ONESOURCE FPS will then automatically run EstateVal, which will price your securities, and send the data back to ONESOURCE FPS.
For ONESOURCE FPS support, please contact Thomson Reuters at 1 (800) 327-8829, options 1, 2.