Master Listing by Owner

This gives a general overview by owner. One of the most common ways to research. This report provides suspense detail by Owner/Property/Distribution line. This report also has options to define the report further to include choosing a specific invoice number or range of invoice numbers. The end of the report will have the totals broken down by owners that have negative net balances versus those with positive net balances. There is also an additional option that checks for owners coded as "Don't Pay". If exporting the list to a CSV file, the invoice number will be added. Note: This listing will only be able to list and/or filter by the suspense code and not the "Extra Suspense Code."

Detail Listing by Owner

This report provides suspense detail by Owner/Property/Invoice.

Suspense Unclaimed Property Status

This report provides suspense amounts by owner for a designated unclaimed property reporting year. Select whether you want to include owners that have a historical amount, a current amount, an exempt amount, or suspense but all 3 amounts are zero. All options can 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.

Note: Owners in states with reporting years that are not escheatable, will be marked with Not Escheatable and a footnote will list the reason.

Owners with Negative Suspense

Typically, owners shouldn’t have negative suspense. This report will allow you to research so you can fix accordingly. This report gives some visibility of the suspense accounts both legal and petty suspense that might be negative and a determination if and when it might be recovered.

The generated report is sorted by:

1.Owners with Negative Petty Suspense but Positive Legal Suspense

2.Owners with Negative Petty Suspense whose payments indicates recovery of negative amounts in 12 months or less

3.Owners with Negative Petty suspense with greater than 12 months of recovery or no recovery at all

4.Owners with Negative Legal Suspense with non-zero petty coded to Don’t Pay

5.Owners with Negative Legal Suspense with no recovery in last 12 months

6.Remaining owners with Negative legal.

Suspense Master Listing by Property

This report provides suspense detail by Property/Owner/Distribution Line/Suspense Code/, including "PAY-DN" for owners marked as "Don"t Pay". Note: This listing will only be able to list and/or filter by the suspense code and not the "Extra Suspense Code." This listing can also be printed by operator and then by lease.

Suspense vs G/L Balance

This report is used to compare amounts in suspense to Petty/Legal G/L accounts for reconciliation as the G/L accounts should always equal amounts in suspense.

Suspense Change History

This report provides a detail audit trail of any suspense changes by property, owner, and distribution. See Suspense vs GL Balance. The "Types of Changes" section includes multiple check boxes that allows you to manually select what changes will be included on the report. The "File/Save to..." button will provide the account and Sub-Account within the file. This listing includes the option to only print one sided detail for a single owner. Leaving this option blank will include all owners.

Paid from Suspense

This reports check history that originated from Suspense.

Distributions to Suspense

This reports revenue distributions that are in suspense

Suspense Trend Report

This report will give you balances by month for each type of suspense movement such as voiding revenue checks that adds the monies back into suspense, changing owners on a DOI from Legal to Pay status and even the Unclaimed Property cycle. The report will also display any differences that a reference may have between G/L and the Suspense Change Log.

Historical Suspense Owner Report

This report provides detail by owner/lease or owner level as of two different historical dates and differences. This report could take a while to run if you have a large suspense history. This report starts with current suspense information and backs out the changes between current date and date 1. Then, if date 2 is specified, it reverses out all the changes between Date 1 and Date 2 in order to create the report.

This report was designed specifically for Auditors that need lots and lots of detail, and to satisfy the question asked in the middle of June: From December 31 of last year to the prior year, what exactly changed in suspense? This report is based on you keeping the General Ledger and suspense in balance at all times, otherwise it will report problems with finding the correct detail for the back dated "As of Date(s)."