Mathproven

Uncashed check escheat list

Open or paste the outstanding-check list from a bank reconciliation, with the payee's state, the issue date, and whether each check is a vendor check or a payroll check. Each check gets the date the uncashed check dormancy table's row for that state runs to, worked out by the same calculation as the one-check calculator on the dormancy periods page, and the checks are grouped by state with counts and totals in whole cents, split into those whose period ended by the as-of date and those still ahead. The list is tied back to the outstanding-check total. A payee state with no row in the table is listed with no date, never guessed. The page counts dates and adds amounts. It does no due diligence and says nothing about what to report or send.

Everything is worked out in your browser. The list opened or pasted here is not uploaded and is not kept. The as-of date and the typed total are kept as a draft in this browser's own storage until you clear the form. This page reads rows (.csv, .xlsx, or pasted). It does not read PDF files or scans.

Outstanding-check totalPeriod endedStill aheadNo row in the tableGroup totals tie to the list total
Every outstanding check lands in one state group, and the groups add back up to the list total.
1. Outstanding-check list

Or paste the rows with a header row first (for example Check No, Issue Date, Payee, Payee State, Type, Amount):

The rows are read in this browser and are not uploaded or kept. This tool reads rows; it does not read PDF files or scans.

The end dates come from the uncashed check dormancy periods table, with its sources and the dates each row was read. This page adds a row's years to each issue date and adds up the amounts. It does no due diligence and makes no statement about what to report, remit or send. Rules change; this is general information, not legal advice.

What gets checked

Your numbersThe mathThe checksVerifiedNot verified
A result that fails a check is marked not verified. It is never shown as correct.

How it works

  1. Open the outstanding-check list. Drop the list of outstanding checks as a .csv or .xlsx file, or paste it, with a header row first: check number, issue date, payee, payee state, type, and amount. A list kept beside a bank reconciliation, with the payee's state and the type added, is the usual source.
  2. Check the columns. The columns are matched from the header words; change any that are wrong. Pick how dates like 03/04/2026 are written, whether checks are written as positive or negative amounts, and, if the list has no type column, whether every check in it is a vendor check or a payroll check.
  3. Type the as-of date and the total. The as-of date is the day the end dates are counted from, such as the statement date of the reconciliation. The outstanding-check total from the reconciliation is typed so the list is tied back to it.
  4. Read the groups, export or print. Each state group shows its count and total, how many checks' periods ended by the as-of date and how many are still ahead, the first and last end dates, and the row's annual report wording. Download Excel or CSV with the groups, every check, and the certificate, or print the page.

Worked example

A made-up outstanding-check list for Example Supply Co., as of the October 31, 2026 statement date, with an outstanding-check total of $5,892.50 on the reconciliation. Alabama's row has 3 years for a vendor check and 1 year for a payroll check; Florida's has 5 years and 1 year.

Check numberPayee stateTypeIssue dateAmountPeriod endsFrom the as-of date
3021Alabama (AL)Vendor2023-05-12$412.602026-05-12Ended 172 days before
3022Alabama (AL)Payroll2025-06-30$1,284.152026-06-30Ended 123 days before
3023Alabama (AL)Vendor2025-06-30$980.002028-06-30608 days ahead
2988Florida (FL)Vendor2024-02-29$2,150.002029-02-28851 days ahead
3040Florida (FL)Payroll2025-09-15$640.252026-09-15Ended 46 days before
3051PRVendor2025-01-10$300.00No row in the tableNo date
3060No payee stateVendor2026-03-01$125.50No row in the tableNo date

Seven checks, $5,892.50, tying to the reconciliation's outstanding-check total. Alabama: 3 checks, $2,676.75, of which 2 checks, $1,696.75, have periods that ended by October 31, 2026 and 1 check, $980.00, is still ahead. Checks 3022 and 3023 have the same issue date, but the payroll check's 1-year period ended in 2026 while the vendor check's 3-year period runs to 2028. Florida: 2 checks, $2,790.25, 1 ended ($640.25) and 1 ahead ($2,150.00); check 2988, dated February 29, 2024, ends on February 28, 2029. PR is not a state or DC in the table and check 3060 has no payee state, so those two checks, $425.50, are listed with no date, and the certificate says so in a warning.

The example uses made-up names and numbers.

Questions

Where do the end dates come from?

From the uncashed check dormancy periods table on this site, the same rows and the same calculation as its one-check calculator: the row's years for a vendor or payroll check added to the issue date. Each row cites the state law or the state unclaimed property office's table it was read from, with the date it was read. The certificate checks every date against that calculator. Rules change, and each law has its own conditions, so the row's source is the place to read the current text.

What happens to a check whose state has no row?

It is listed in a group of its own with its count and total, and no date. A payee state that is blank, or text that is not one of the 50 states or the District of Columbia, such as a territory or a foreign province, is grouped the same way. Nothing is guessed, and the groups still add up to the list total.

Why do a payroll check and a vendor check of the same day get different dates?

Most state laws set a shorter period for wages than for other property. In the example, Alabama's row has 1 year for a payroll check and 3 years for a vendor check, so two checks issued on June 30, 2025 end on June 30, 2026 and June 30, 2028.

Does the page say which annual report a check goes on?

It shows each state row's annual report wording beside the group, as the dormancy table has it, such as before November 1, covering the 12 months before July 1. It does not work out which year's report a check is in, because each law counts its own way and has its own conditions. The page does no due diligence, and it is general information, not legal advice.

What does ended by the as-of date mean?

The row's years added to the issue date fall on or before the as-of date. Still ahead means that date is after it. The day count is whole calendar days. The law counts from when the property became payable, and the page counts from the issue date given.

Is the list I open uploaded?

No. The list is read in this browser tab and never leaves it. The rows are not kept; only the as-of date and the typed total are kept as a draft in this browser, and the Clear the form button removes them.

This tool calculates and checks numbers. It is not legal, tax, or medical advice.

Template updates by email

At most four emails a year, when the free templates and rate tables for bookkeepers and accountants are updated for a new quarter. Each has a one-click unsubscribe link.

Only the address typed here is sent, never anything from a file opened on this page. Nothing is added until the link in the confirm email is opened. Mathproven is a product of OpenSlot LLC, PO Box 96, Paintsville, KY 41240, USA. Privacy.