Setup and Items to Review
Table of Contents
Setup and Items to Review
1. Setup a Revenue Unclaimed Property Transfer Clearing Account
Use Account Maintenance.
Accounts should be in your Revenue type account range as an OTHER deduction category. The Unclaimed process will use this account to transfer the suspense monies from the owner’s suspense to the state's suspense and to offset cash for Payroll and Accounts Payable checks that have been marked for Pending Unclaimed.
2. Bank Reconciliation for all Accounts
Pak Accounting is an integrated system! Bank Reconciliation is a huge part of the Unclaimed Property Reporting Process. Make sure the bank accounts have been reconciled at least through November (escheating usually begins in January of each year), and revenue checks that are older than 6 months should be voided and returned to suspense. Do NOT void any old Payroll or Accounts Payable checks; the software will automatically flag any of these old checks as “Pending Unclaimed” if they become old enough to be escheated to the state. The cutoff dates vary based on state and type of check. Any revenue checks that have been outstanding for more than 3 years as of the end of December will prevent the unclaimed property reporting process from running and force the user to void or clear the checks before allowing the start year process to complete.
3. Review Owner/Vendor/Employee address
Use Sub-Account Maintenance. Pak Accounting assumes that the address in the system is the last known address. This is a critical requirement for the escheat funds to be sent to the correct state and to protect companies from any future liabilities for misfiling Unclaimed Property.
- When the unclaimed funds are sent to the state, the owner’s last known address is also reported. The state coded in that address determines which state’s rules to use when processing the unclaimed property reporting.
- Do not delete bad addresses. Instead, indicate in the notes field that the address is bad and change the vendor to a Do Not Pay status.
- If an owner's address is unknown, change their DOI to have a Legal suspense code that indicates a Bad Address instead of changing it.
If, for some reason, the address was changed to “Returned by Post Office” or to something else of that nature, then address cleanup is necessary to ensure that the Unclaimed Property files will contain the most accurate information possible.
As part of the Due Diligence for most states, holders are required to send a letter to the last known address. If the address for owners/vendors/employees that is on file is a known bad address, the letters should still be mailed to the bad address, and then, the letter with “undeliverable” stamps should be saved for future reference.
Tip: Use the View Change History button on the Owner Master to see what the previous address was to be able to change back to. Pak Accounting maintains two years of Sub-Account change history.
4. Contacted Notes
Notes on the owner or vendor can help to determine or prove whether as part of the Due Diligence for most states, holders are required to send a letter to the last known address. If the addresses for owners/vendors/employees that is on file is a known bad address the letters should still be mailed to the bad address, and then, the letter with “undeliverable” stamps should be saved for future reference.
However, notes may also be used for logging when Due Diligence letters were sent out, if it was returned with a bad address, or to log the different methods that were used to attempt to locate the owner. All notes may be listed and printed at a future date and when scanning is a part of the software package images may even be attached to the notes.
5. Review Suspense Codes
Pak Accounting assumes that all owners in suspense are unclaimed and, as such, are subject to being escheated to the state. If some owners should not be reported, then use a different Suspense Code to represent these interests and code the suspense code as exempt. Be sure to check the rules for the state in which the owner(s) live before coding interests to this exempt suspense code to ensure that legal requirements have been met.
Review Suspense Codes by running a List in Revenue/Billing > Company Maintenance > Suspense Code Maintenance. If needed, define any new Suspense codes, or change Exempt flags.
6. Review the Suspense Unclaimed Property Status
This report provides suspense amounts by owner for a designated unclaimed property reporting year. Filters may be set to include owners with a historical amount, a current amount, an exempt amount, or suspense, but all three amounts are zero. All options may be selected if desired. The generated report includes the owner's minimum pay code, suspense codes, current and historical suspense amounts, check information, and whether the owner would be included in a cycle if started now.
The report is currently located in the Revenue/Billing Module > Reports > Suspense > Suspense Unclaimed Prop. Status. (Legend to assist with reading the report follows below.)
Owner# | Owner Sub-Account number in Pak Accounting. |
Owner Name | Owner description in Owner Maintenance. |
ST | State of last known address for the owner. If there is no last known address the state of incorporation for the business will be listed |
MP |
It stands for Minimum Pay. The payment Code is located in Sub-Account Maintenance > Revenue/Billing tab > General Tab > Payment Code. |
Prod Dates | Production Date range for suspense that would potentially be eligible for the escheat process. |
Susp Codes | Suspense Codes for the monies in suspense that could potentially be eligible for the escheat process. There really should not be any PAY suspense codes pulling in as possible escheat, since that indicates that the location of the owner is known. |
Contacted | will display the Contacted date from Sub-Account Maintenance > Notes Tab – check box Contacted. The contacted box triggers a time/date stamp note for the user to create a notation in regards to what form of contact was made with the owner. If the Contacted box is not check marked, the note will not trigger a restart of the dormancy period. The note will just serve for informational purposes. Any Contacted check boxes during the dormancy period triggers a restart on the dormancy period for that particular owner, meaning they would not be escheated in the current escheat process. |
Cleared | Date of the most recent check that cleared for the owner. If there is an * to the right of the date this indicates that the check cleared within the dormancy period for that owner’s state which will trigger that owner’s dormancy period to restart as of the cleared date preventing the owner from being a part of the current escheat process. |
Bank-Check# | Refers to the most recent check number that cleared the bank for this owner. |
Check Date | Displays the date of the “Bank-Check#” which is displayed to the left. |
E? | Will this owner be escheated for the Reporting Year that is being reviewed? Y – Yes, the owner will be included in the escheat process for that reporting year. N# - Indicates that the owner will not be escheated and the legend that is displayed below the owners will define why the owners will be excluded. i.e. N1: Contacted within the dormancy period. N2: Check Cleared within dormancy period. N3: Amount not > zero. |
Current Susp | Amount of current suspense that could potentially be pulled into the escheat process for that owner. Negative suspense will not be escheated to the state, and current suspense will only be escheated in current pay states for owners that are eligible for escheat as labeled in the E? column with a Y. |
Historical Susp | Amount of historical suspense that could potentially be pulled into the escheat process for that owner. The owner’s historical suspense should pull in for all owners that are labeled in the E? column with a Y. Historical suspense is suspense monies that meet the dormancy period cutoff dates for that owner’s state. |
Exempt SC | Any suspense code for that owner that contains suspense monies that is marked as Exempt from Unclaimed Property in Revenue/Billing Module > Company Maintenance > Suspense Code – Suspense Code Maintenance Screen. |
Exempt Susp |
Dollar value for any suspense monies that are exempt from the unclaimed property reporting process for that owner. TIP: Owners in state with reporting years that are not escheatable, will be marked with Not Escheatable and a footnote will list the reason. |
7. Oklahoma and Arkansas Lease Location
Oklahoma and Arkansas require a record for each property that is reporting with TR-CODE 8. This code has the legal description (section, township & range), property name, owner percentage, and the amount being reported for the property. We have added the Lease Location options for the legal description to the Other tab in Property Maintenance. The NAUPA file will pull in the section, township, and range from this location on the property maintenance (see below):
The ownership percentage will pull from the most recent suspense record for that property regardless of previous percentages.
***TR-CODE 8 for the state of Oklahoma all owners being reported to the state of Oklahoma the legal description TR-CODE 8 must be included for each property being reported regardless of the property’s location and home state. For the state of Arkansas, the TR-CODE 8 is for only the properties located in AR.
8. Review the Checks by Payee Reports
Found in the Bank Reconciliation Module > Reports > Checks by Payee. Not as useful when there are multiple states with multiple cutoff dates. However, when the majority or all vendor checks are in the same state, this report will provide a listing of the checks eligible for the Escheat process based on the cutoff date.
9. Review Checks by Payee Report for Payroll
This report is the same as the previous report, but when run with the Payroll parameters, below will provide a listing of Payroll checks that will be escheated. The majority of states/territories have a one-year dormancy on payroll checks. The settings below are for the 2023 reporting year: