North America

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

Supreme Court Peters v. Cohen
North America Unclaimed Property
August 5, 2025
Supreme Court Petition Challenges State Unclaimed Property Laws: Peters v. Cohen

This blog was last updated on August 5, 2025 Supreme Court Peters v. Cohen: Major Unclaimed Property Case By Freda Pepper, General Counsel, Unclaimed Property Sovos regulatory team is tracking the latest Supreme Court Peters v. Cohen, a landmark case that raises fundamental questions about how state unclaimed property laws handle dormant assets and the […]

NAUPA III file format
North America Unclaimed Property
August 5, 2025
NAUPA III File Format: What Compliance Teams Need to Know

This blog was last updated on August 5, 2025 The National Association of Unclaimed Property Administrators (NAUPA) has approved a major update to their electronic reporting standards with the introduction of the NAUPA III file format. This significant advancement in unclaimed property reporting represents a modernization effort that aims to streamline the submission process while […]

See for yourself how the Sovos Compliance Cloud can meet your business' unique tax compliance challenges.
Book a Demo
© 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