Running a creditor claims window without a spreadsheet

Record the one date that matters, in words

Everything downstream depends on when the claims period ends, and that depends on what your statute counts from: the date of first publication, the date notice was mailed to a known creditor, the date of appointment, or some combination. Work it out once, with the statute open, and write down both the date and the reason in a note on the file: "Window closes [date]; [the period your statute sets] from [what it runs from] on [that date], §___." A date with its reason survives a change of paralegal. A date on its own gets re-derived, wrongly, by the next person.

Do not let software derive it for you. Rules differ by state and sometimes by county, and a default that is right most of the time is the most dangerous kind.

Log every claim the day it arrives

A claim is a record, not a letter in a folder. For each one keep the creditor, the amount claimed, the date received, how it arrived, and what it is for. Scan or file the claim itself against the record. The date received is the one you will be asked about later; it is also the one most often lost when the claim came in by email and was answered the same day.

Known creditors you notified directly belong in the same list from the start, with "notified" as their status, so the question "did we hear back from the hospital?" has somewhere to be answered.

Give each claim one status, and agree what "open" means

Five statuses cover almost everything: pending (received, not yet decided), allowed (will be paid), disputed (rejected or partly rejected, and the creditor may still act), paid, and rejected with no further action possible. The office should agree that a claim is open while it is pending, allowed or disputed. Allowed claims are open because they still need paying; disputed claims are open because the creditor still has a move to make. Only paid and finally rejected claims are closed.

This matters when someone asks for "the open claims" before a distribution. If open means pending only, allowed claims drop out of the answer and get paid late or twice.

The weekly check

Once a week, for every estate in its claims period, look at three things: claims received this week that have no status yet, disputed claims whose response period (your statute again) is coming up, and the window’s closing date itself. The check takes a minute per estate if the list is in one place and a morning if it is not.

When the window closes, note it on the file the same day, with the total allowed and the total disputed. The closing is a milestone the family will ask about, and the totals are the start of the distribution plan.

What to tell the family

Beneficiaries hear "creditor period" and imagine the estate is in trouble. Say early, in writing, that the period is routine, that nothing can be distributed until it ends, and roughly when that is. A standing message like that removes a quarter of the calls an estate generates.