North America
August 19, 2019
To Aggregate or Not to Aggregate – There Is No Question – Not
How many of you use the aggregate function when reporting? Be careful. It has a lot of pitfalls. Here are a few of them and how to avoid them.

Danielle Herring

Author

Sovos

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.

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.
Sign Up for Email Updates
Stay up to date with the latest tax and compliance updates that may impact your business.
See for yourself how the Sovos Compliance Cloud can meet your business' unique tax compliance challenges.
Start Here
© 2025 Sovos Compliance, LLC. All rights reserved.
Why Sovos?
Resources
About
Products
Indirect Tax Suite
Information Reporting and Withholding Suite
Specialty Products
Solutions
By Tax or Document Type
By Industry
By Team or Initiative
By Region