To Aggregate or Not to Aggregate – There Is No Question – Not

Danielle Herring
August 19, 2019

This blog was last updated on October 20, 2020

Article written By Bill Dadmun, Records and Receipts Manager, State of Virginia
 
How many of you use the aggregate function when reporting?  Does it make your life easier?  Listen to this scenario and tell me if it sounds familiar.
 
You get a call from someone that is due $49.95 from a credit balance.  You know based on the time frame that this account has already been reported to the state, so you refer them to the proper state, even providing them with the searchable website and how to submit a claim form.  You have done all of the right things only to get another call within the hour.  This time, the customer is mad, because the state says they cannot locate any property in their name, in particular not from your company.  “What is the problem with them!?!” You think to yourself.
 
You pick up the phone and call the state and find that because you have included the remittance and report data in the aggregate, it has not been listed in their database in such a way for their claims representatives to be able to locate it.  Not only that, but they say the only way they can pay the rightful owner is to first receive a letter from you stating details about the property and indicating which aggregate it was reported in.  Great, now you have to dig out that information all over again.  What a pain.
 
In the past, when a majority of the data reported by you and then entered into unclaimed property databases had to be handled by both of you in a manual data entry function, aggregating property not only made sense, it was absolutely necessary!  But today is different.  Most data today is handled within electronic files, where the data was already entered a long time ago.  You don’t have to retype anything.  The reporting software used today is happy to import data from your files to create the NAUPA format text files that the states require.  The states are now very happy to have detail data, and you don’t have to do any more work than you did before!  Just specify that the file to be created should supply detail information for all property owners.
 
Now, I am not saying you cannot aggregate.  If there are good reasons to do so, based on your company’s circumstances, then by all means do so.  The law allows you to do so in most states.  But consider whether this is in your best interest long term.  The best possible scenario for you is to report it and forget it, right?  By reporting detail all the time, you are going a long way towards reaching that goal.

Take Action

Get in touch with a Sovos unclaimed property expert to learn more about managing your unclaimed property compliance processes.

Sign up for Email Updates

Stay up to date with the latest tax and compliance updates that may impact your business.

Author

Danielle Herring

In her role as compliance manager for unclaimed property reporting, Danielle Herring oversees support of the product, researches changes in state unclaimed property laws so the system is updated to comply with them, and tests changes to the system before they are released. Danielle also completes some report and letter processing for current clients, assists with their direct support, provides customer training, and helps with troubleshooting and questions about using the product. Outside of work, Danielle loves to garden and is a master gardener.
Share this post

dtc shipping law updates
North America ShipCompliant
March 12, 2025
The Case for DtC Beer Shipping Reform: Key Takeaways from the 2025 Report

This blog was last updated on March 12, 2025 Craft beer drinkers want more choices. Brewers want more opportunities. And yet, legal barriers still stand in the way of direct-to-cconsumer (DtC) beer shipping. The 2025 Direct-to-Consumer Beer Shipping Report, produced by Sovos ShipCompliant in partnership with the Brewers Association, reveals how consumer demand, regulatory restrictions […]

DtC wine market
North America ShipCompliant
March 7, 2025
From Decline to Opportunity: Lessons from the 2024 DtC Market

This blog was last updated on March 7, 2025 The 2025 Direct-to-Consumer Wine Shipping Report offers more than just data—it provides valuable insights into the trends shaping the industry and the factors driving change. To delve deeper into these findings, industry experts Andrew Adams from WineBusiness Analytics and Alex Koral from Sovos ShipCompliant joined forces […]