• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

EVP Systems

  • Home
  • Support
    • Contact
    • FAQs
    • Tutorials
  • Software
  • Services
  • Accounts
    • Sign-Up
    • Mailing Lists
    • Pricing
    • Payments
  • About Us
    • The Company
    • EVP Office
    • Professional Services
    • EVP Everywhere
    • EVP Upload
    • Legal and Compliance
    • Sales Material
    • Contact Us

Gillett Publishing’s GEMS Tutorial

If you are a subscriber to the Gillett Estate Management Suite (GEMS) GEM706 or GEMAcct programs, the EstateVal/GEMS interface can eliminate manual entry of data between the packages.

EstateVal to GEMS

To export an EstateVal portfolio’s pricing data to GEMS, first you’ll need to configure the export file format. Select Tools → Options… → Export, and set Type to “GEMS”, Path to the folder you want the data file sent to, and Schedule to the Form 706 schedule you want the data exported to in GEMS: “B”, “E1”, “E2”, “F”, “G”, “H” or “I”.

Now that EstateVal is configured, enter and evaluate the portfolio as usual and select File → Export → From EstateVal → [Report Type]…. to export the data. You will be prompted to enter an export file name and click OK—remember, GEMS requires that you keep it simple: no special characters such as quotes, commas, or less-then or greater-than signs, etc. EstateVal will then show “The portfolio has been exported.”

Now that the data has been exported from EstateVal, you can import it into either GEM706 or GEMAcct. To do so, open the appropriate GEMS program, and then open the relevant client file. Select Utilities → EVP Pricing Interface. Click Import existing EVP portfolio, select Date of Death or Alternate Date, depending on what type of report you exported, enter the file you exported from EstateVal, and then click Transfer. The securities and their values will be displayed. You can select your File Import Options, and select or deselect individual items on the results page. To post the values, you’ll need to click Transfer again.

GEMS to EstateVal

GEM706

  • Open GEMS 706 – Federal Estate Tax Returns
  • Create a client and enter the stocks and bonds on the appropriate schedules as CUSIP numbers or ticker symbols; you should also enter a temporary description
  • When you are ready to send the securities for pricing, select Utilities → EVP Pricing Interface, then select Date of Death or Alternate Value—if you are doing the Alternate Value, you should download the Date of Death first
  • Next, click Transfer and the program will automatically look for the EstateVal executable in its default directory (c:\Program Files (x86)\EVP Systems\)—in cases where EstateVal has been installed in a different location, you will have to open the GEMS.INI file, located in the installation directory for GEMS, and edit the path under the [EVP] header
  • Once EstateVal is found, the securities are sent for valuation, and when that process completes, GEM706 displays the results
  • You can now select your File Import Options and select or deselect items on the results page; to post the values into GEM706, click Transfer again

A more detailed tutorial can be found in the GEM706 software—select Help → GEM760 Manual, and go to Chapter 11 (Utilities), Section 11.07 (EVP Pricing Interface).

GEMAcct

  • Open GEMS Acct – Fiduciary Accountings
  • Create a client and enter the stocks and bonds in the inventory; you must also enter their CUSIP numbers or ticker symbols
  • When you are ready to send the securities for pricing, select Utilities → EVP Pricing Interface. (Make sure to refer to the GEMAcct Manual for details on what to do with your account before sending it for valuation.) You will now be asked to select Acquisition, Alternate Value or Fair Market Value. If you elect to perform a fair market valuation, you must also enter the date of the valuation.
  • Next, click Transfer and the program will automatically look for the EstateVal executable in its default directory (c:\Program Files (x86)\EVP Systems\)—in cases where EstateVal has been installed in a different location, you will have to open the GEMS.INI file, located in the installation directory for GEMS, and edit the path under the [EVP] header
  • Once EstateVal is found, the securities are sent for valuation, and when that process completes, GEMAcct displays the results
  • You can now select your File Import Options and select or deselect items on the results page; to post the values into GEMAcct, click Transfer again

A more detailed tutorial can be found in the GEMAcct software—select Help → GEMAcct Manual, and go to Chapter 11 (Utilities), Section 10.07 (EVP Pricing Interface).

Within GEMS

You can also price securities entirely within GEMS, by configuring it to use EVP Everywhere.

For GEMS software support, please call (888) 436-7706.

Posted on August 18, 2020 • Tagged with Export, GEMS, Import, Tutorials

Primary Sidebar

Things You Should Know

  • Good to Know: Reports on April 9, 2025
  • Happy Holidays from EVP Systems! on December 9, 2024
  • Fee Changes for 2025 on November 1, 2024
  • We're Going to Disneyland---for NAEPC 2024! on October 18, 2024
  • CrowdStrike BSOD and EVP Systems
  • EVP Office 9.1.3 Now Available on July 18, 2024
  • EVP Office 9.1.0: Now Available, Featuring Name Preview on January 8, 2024
  • EVP Systems at Heckerling 2024 on January 3, 2024
  • Happy Holidays from EVP Systems! on December 11, 2023
  • EVP Systems at the California Probate Referees Conference on November 30, 2023
  • Join us at NAEPC 2023 on November 11, 2023
  • Good to Know: The Grid on August 23, 2023
  • Announcing Fee Changes for 2023 on October 7, 2022
  • "Single Broker Quotes" Available Again on April 14, 2022
  • EVP Systems Prepared for Russia / Ukraine Conflict on March 14, 2022
  • Expat and Open Source at EVP Systems on March 1, 2022
  • EVP Office 9.0.1 Offers Built-In Calculator, More Crypto, New Export on February 8, 2022
  • Jack Barthel, 1937 - 2021 on January 19, 2022
  • EVP Systems Unaffected by log4shell and Associated Vulnerabilities on December 13, 2021
  • EVP Office 9: Something Big! on October 13, 2021
  • EVP Office 8.5.3: Secure by Default on July 13, 2021
  • Ready for Windows 11 on July 2, 2021
  • EVP Office 8.5.2: Native Excel Export, Better Copy-and-Paste, Mailing Lists on April 8, 2021
  • A Lockdown Check-In on October 5, 2020
  • Upgrade Your Invoice on September 21, 2020
  • EVP Systems Introduces Modern, Streamlined Website on August 13, 2020
  • EVP Office 8.5.0 Released on June 17, 2020
  • EVP Systems Continues to Support Retired Versions of Windows on December 4, 2019
  • EstateVal 8.4.0 Prices Foreign Currencies, Precious Metals on October 25, 2019
  • GEMS Adds EVP Everywhere for Faster, Easier Pricing on April 15, 2019
  • EVP Office 8.3.1 Now Available; Features Easy Pricing of Puts and Calls on March 15, 2019
  • Reminder: Fee Changes Coming in 2019 on December 28, 2018
  • TEdec Adds Built-In Evaluations, with EVP Everywhere on December 3, 2018
  • Primary and Composite Exchange Pricing in EstateVal
  • A Brief Introduction to EstateVal

EVP Systems: Trusted for over 40 years!

Footer

About EVP Systems

Trusted by thousands of banks, brokerages, and law firms, Estate Valuations & Pricing Systems has been the leading provider of high-quality security evaluations for estate- and gift-tax purposes for over 40 years.

Get in Touch

1531 Chapala St., #1
Santa Barbara, CA 93101
(818) 313-6300 • FAX: (818) 313-6313
support@evpsys.com
sales@evpsys.com
Twitter
Mailing Lists

Explore the Site

Privacy Import Methodology GEMS Tutorials

All contents copyright © 1984–2025 Estate Valuations & Pricing Systems, Inc. • Do Not Sell My Personal Information • Service Status