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.
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.
These are matched from the header words. Check them and change any that are wrong. The payee state is a two-letter code or a full name. The type reads Vendor or Payroll (Accounts payable, AP, Wages and PR are read too). A line whose first cell or payee reads Total, with no issue date, is read as the file's own total line.
The as-of date is the day the end dates are counted from, such as the reconciliation's statement date. A check's period has ended when its end date falls on or before it.
Summary
By payee state
Every check, by state and end date
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
- Every check in the list is shown once, with the payee state, issue date, type and amount it was given. The list total is added again in whole cents a second way, and the list ties to the outstanding-check total typed from the reconciliation, and to the file's own total line when it has one.
- Every check is in exactly one state group, the one its payee state names, the groups with no row in the table included. The group counts and totals add up to the list's, and each group's count and total are its own checks, split into ended and still ahead with nothing over or missing.
- Each check's end date is the one the uncashed check dormancy table's calculator gives for its state, type and issue date, and passes that calculator's own second-way counts: the end date written out again, counted back to the issue date, and the days from the as-of date counted again. A February 29 check ends on February 28 in a year without one.
- A check whose payee state has no row in the table is given no date. The states with no row are listed in a warning with their counts and totals.
- A warning shows when a vendor check is in a state whose row notes an exception for checks between businesses, since the date is only the row's years added to the issue date.
- Every row with data in the file is accounted for: read as a check, listed as a row that could not be read (which leaves the result unverified), or left out as the file's own total line or a note.
How it works
- 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.
- 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.
- 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.
- 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 number | Payee state | Type | Issue date | Amount | Period ends | From the as-of date |
|---|---|---|---|---|---|---|
| 3021 | Alabama (AL) | Vendor | 2023-05-12 | $412.60 | 2026-05-12 | Ended 172 days before |
| 3022 | Alabama (AL) | Payroll | 2025-06-30 | $1,284.15 | 2026-06-30 | Ended 123 days before |
| 3023 | Alabama (AL) | Vendor | 2025-06-30 | $980.00 | 2028-06-30 | 608 days ahead |
| 2988 | Florida (FL) | Vendor | 2024-02-29 | $2,150.00 | 2029-02-28 | 851 days ahead |
| 3040 | Florida (FL) | Payroll | 2025-09-15 | $640.25 | 2026-09-15 | Ended 46 days before |
| 3051 | PR | Vendor | 2025-01-10 | $300.00 | No row in the table | No date |
| 3060 | No payee state | Vendor | 2026-03-01 | $125.50 | No row in the table | No 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.