• 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

EstateVal 8.2 Features Data-Entry Smarts

EstateVal has one of the cleanest user interfaces in the industry, and getting your data into it—while always easy—is now even easier, with the paste-from-Excel feature in EVP Office 8.2. But what if that data is wrong?

EstateVal has always been able to do a little sanity checking as you go (it will tell you if the check-digit on a CUSIP is incorrect, for instance) but what if it could be smarter than that? What if it could check for other errors? Bad dates, and mis-entered share amounts, and logical inconsistencies in inventory adjustments?

Now, it can.

EstateVal 8.2 will light up the lot numbers on the grid in a warning shade of yellow, if it thinks there is something wrong with the lot. If you hover the mouse over the yellow number, it will show you a summary of the problems in a pop-up windows.

For instance, in Tools → Options → Methodology, it’s possible to set EstateVal to accept either the face value of a mortgage-backed security in the Shares/Par column of the grid, or the remaining principal. If the setting one way, and the value you enter is another, you’ll end up with an evaluation that’s either much too high (if the program expected remaining principal and you entered face-value) or much too low (if the situation is the other way around).

EstateVal will now warn you about this error, by turning the lot number yellow if it expects face-value and the number in Shares/Par is not divisible by 1,000 (which his how mortgage-backeds are distributed). Likewise, if the program expects remaining-principal and sees a nice, round value, that’s sign that something is wrong.

(Because EstateVal needs to run the evaluation to discover if a security is a mortgage-backed, these warnings will only show up after you’ve evaluated a portfolio, so be sure to check for them then.)

If there’s problem with a lot’s inventory, the lot number will also show yellow, a description of the problem will appear when you hover over it, and there will be a warning icon on the “Adjust Inventory” button. Select the lot and click “Adjust Inventory” to discover what it is.

Since the problem with the lot might be with the adjusted inventory for any report, the one with the issue will have the warning icon on its tab. In this case, it’s the Alternate Date. Click it to show the Alternate Date inventory.

It looks like this lot was sold before the Alternate Date and the sale inventory item is the source of the problem, since it is also highlighted in yellow. If you select it and click “Edit,” you can see the details of the item, and the trouble.

Ah! The problem is with the sale date, which is why it’s highlighted. If you hover over it, a pop-up will appear to explain. It looks like a typo caused the sale-date of the item to be entered as a year after the Alternate Date. That’s an obvious error now that it’s been pointed out, but it could have been hard to spot in a large portfolio.

There are a lot of errors like this that EstateVal is now smart enough to spot and flag for you: zero-share sales, acquisition dates after the Date of Death, invalid CUSIPs in inventories, zero-values or zero-accruals for user-defined data, inventory action dates before the Date of Death or after the evaluation date. Each of the fields will turn yellow and show a pop-up explaining the problem when you hover over them. Some make it so you can’t even exit the adjusted inventory item dialog until they’ve been corrected.

If you’re looking at the grid in a portfolio that as a problem, any of these issues will cause the warning to bubble back up, through the adjusted inventory item list, to the report tab in the lot dialog, all the way back to the lot numbers on the grid.

That’s EstateVal’s new way of helping you out!

Posted on March 9, 2018 • Tagged with EVP Office, Release

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

Vulnerabilities Good to Know Website Tutorials Training Mode

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