Edit properties

You can edit properties one by one manually or with an import in bulk.

Edit properties manually

On the Properties page, use the filters or search to find the property, then click the property's row to open the Property details page.
Edit the property details and owner details, then click Save.
The following fields can't be edited:
Due date
The date when the property must be reported to the state. We automatically calculate this for you.
Report year
The year the property's dormancy period ends. We automatically calculate this for you.
Report state
The state where the property will be or has been reported. This is based on the property owner's State/province/territory or Alternate filing state field. If these are unknown or are outside of the U.S. or Canada, this is based on your business's state of incorporation.
Total amount due
The total value of the property. We automatically calculate this for you based on the Initial amount, Addition amount, and Deduction amount fields.
Note:
Read about property statuses for details about the Status field.

Bulk edit properties

Download the properties from the Properties page.
1. Click Properties on the menu.
2. Edit the properties table using the tabs and the quick and advanced filters to view only properties you want to download. Click Download properties as .xlsx.
3. Click Download properties as .xlsx.
Edit the properties in the .xlsx file, then save the file.
Tip:
- The Claim cut-off date field does not appear in the import template but can be updated with this process. The source system ID can also be updated, but only if the ID field is present.
- Read about more bulk editing tips.
Import the file.
1. Click Properties on the menu.
2. Click Add properties, then select Bulk Import from the dropdown.
3. Verify that your business's state/province/territory of incorporation and business category are correct. Click Next.
  If the information is not correct, click Edit business information and make changes to the incorrect fields.
4. Click Browse, select the file on your computer, then click Upload.
  You can only upload files with a .csv, .xls, or .xlsx extension.

Your file will go through a data validation process to identify missing or incorrect data. The system will read the entire file and update the properties that have differences between what is in the file and what is currently in the system. Properties and fields with no changes will not be updated.

If the import is successful, check if the number of properties that were added, updated, and deleted match your file.
Note:
The number of rows found may not always equal the sum of added, updated, and deleted properties. Rows containing properties already in the system with no changes are not imported to avoid duplicating properties. These rows will be included in the Found category but will not be included in the Added, Updated, or Deleted categories. Additional owners are counted as part of the properties and will not be included in the Added, Updated, or Deleted categories either. Click Download import summary to view information on how each row was handled during import.
If the import has warnings or is unsuccessful, read about import errors for explanations of all import warnings and critical errors and what to do next.

Bulk editing tips

Do not change the following fields and rows

The ID field is created when you add properties to the system. When you re-import the downloaded file, ID is used to identify properties. This field should not be edited or deleted. Changes to the ID value will cause a critical error at import.

When editing the file, make sure any additional owners are directly in the rows following their primary owner. If they are not, and you make a change to the property, the bulk import process will interpret it as if there were no additional owners in the file and delete them from the system. If you sorted your file by last name, or another field, you may not see the additional owners even if they are in the file. Sort by the ID field to bring them back to their associated primary owner.

Some fields that are not in the import template will appear in the download file but can't be updated with this process. Changes to these fields will be ignored at import:

Amount due
Date archived
Date created
Last modified
Owner name (full name; if you need to update this, use the First name and Last name fields to do so)
Report date
Report state
Report year

Field used to identify properties from an import

The bulk import process uses the following logic to check for existing properties to update:

The ID field is used as the primary identifier if it's available in the file downloaded from the Properties page.
If there is no ID, the Source system ID provided during the initial import is used.
Note:
The Source system ID must have been included in your original property import as well as in the updated file to be used as a means of identification.
If there is no Source System ID, the following fields are used to check for existing properties:
- Property code
- Property ID
- Account number
- Owner tax ID (if known); if not known, last name + first letter of first name
- Initial amount
- Last owner activity date or Maturity date

Add, archive, and delete properties with the same import

Add: You can add new properties in the file and import them along with the edits. When you import the file, you'll see the number of new properties as added properties at the Summary step.
Archive: You can also archive properties with this process. In the Current or History field, enter an "H." This action is permanent. Properties can't be un-archived. When you import the file, you'll see the number of properties archived as updated properties at the Summary step.
Delete: If you were testing or accidentally added records and need to delete them, you can mass delete them with this process. In the Property code field, enter the full word "DELETE." The ID or Source system ID field must be present. When you import the file, you'll see the number of properties deleted this way as deleted properties at the Summary step.
CAUTION:
The properties will be permanently deleted and can't be recovered. We recommend voiding and archiving properties instead of permanently deleting them. By changing the status of a property to Voided (V), you will keep the audit history of the property. If you delete a property, you are also deleting its audit trail.

Sovos Docs