Mathproven

Timely filing days-left list

Open a CSV or Excel list of open claims with a claim number, payer, date of service, and open amount. For each payer, pick its row in the site's timely filing limits table (Medicare or a state's Medicaid fee-for-service program) or type the limit from the payer's contract or manual. The list shows each claim's last day and the days left from your as-of date, soonest first, with claims past the limit and claims inside the number of days you choose flagged, and counts and dollar totals per payer that tie to the list.

Your file never leaves this computer. It is read and processed inside this page, which is built so it cannot make network requests. It keeps working with your internet turned off.

Days left to each claim's last dayMB-1006MB-1001MB-1002MB-1003MB-1004MB-1005Days leftPast the limitPayer totals tie to the list in cents
Each open claim's days left to its payer's last day, soonest first.

1. Open claims

2. Each payer's limit

Medicare and each state's Medicaid fee-for-service program come from the rows of the timely filing limits table, with the rule or manual each was read from. For any other payer, choose a typed limit and enter it; it is labeled as typed wherever it shows.

Open a claims list to see its payers here.

3. As of

How the days are counted: the day after the date of service is day 1, and the last day is inside the limit (a 90-day limit's last day is day 90). Days left are the calendar days from the as-of date to the last day: 0 means the as-of date is the last day, and below 0 means the last day has passed. Weekends and holidays do not move the last day, and no exception in a source is applied.

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 claims list. Drop a CSV or Excel export of open claims, one claim per row, and pick the claim number, payer, date of service, and open amount columns. Dates can be year-month-day, month/day/year, or day/month/year. Or press the button that loads the made-up example below.
  2. Give each payer its limit. Every payer name in the file gets a row. Choose Medicare or a state's Medicaid program from the timely filing limits table, or choose a typed limit and enter it in days, months, or years, counted from the date of service or from the end of the month of service. A payer named exactly like a table program ("Medicare", "Ohio Medicaid") starts on that row; any other payer starts with no limit until one is chosen.
  3. Set the as-of date and the window. The as-of date starts as today on this device. The window (30 days unless you change it, up to 365) decides which claims are flagged as inside that many days.
  4. Read the list. Claims are listed soonest first with the limit used, the last day, the days left, and the group. Above the list, each payer's counts and dollar totals by group, with the certificate showing every check. The list, the payer totals, and the certificate can be downloaded as Excel or CSV, or printed.

Worked example

A made-up list of six open claims totaling $2,467.45, read on an as-of date of November 12, 2026, with a 30-day window. Medicare and New York Medicaid use their table rows (1 year and 90 days from the date of service); Lakeview Health Plan, a made-up commercial payer, uses a typed limit of 180 days.

ClaimPayerDate of serviceLimit usedLast dayDays leftGroupOpen amount
MB-1006New York Medicaid2026-07-0190 days (table)2026-09-29-44Past the limit$150.00
MB-1001Lakeview Health Plan2026-05-01180 days (typed)2026-10-28-15Past the limit$412.50
MB-1002New York Medicaid2026-08-2090 days (table)2026-11-186Inside 30 days$96.00
MB-1003Medicare2025-12-011 year (table)2026-12-0119Inside 30 days$1,240.00
MB-1004Lakeview Health Plan2026-07-15180 days (typed)2027-01-1160More than 30 days$250.75
MB-1005Medicare2026-09-301 year (table)2027-09-30322More than 30 days$318.20

Past the limit: 2 claims, $562.50. Inside 30 days: 2 claims, $1,336.00. More than 30 days: 2 claims, $568.95. Together $562.50 + $1,336.00 + $568.95 = $2,467.45 across 6 claims, the total of the list. By payer: New York Medicaid $150.00 + $96.00 = $246.00, Lakeview Health Plan $412.50 + $250.75 = $663.25, Medicare $1,240.00 + $318.20 = $1,558.20, and $246.00 + $663.25 + $1,558.20 = $2,467.45. Ninety days after August 20, 2026 is November 18, 6 days after the as-of date; one year after December 1, 2025 is December 1, 2026, 19 days after it. The typed Lakeview limit shows a warning that it was not read from a source.

The example uses made-up names and numbers.

Questions

How are the last day and the days left counted?

The same way as the timely filing limits calculator: the day after the date of service is day 1, and the last day is inside the limit. A limit in days ends that many days later; a limit in months or years ends on the same day of the month that many months or years later, or on that month's last day when it is shorter. Days left are the calendar days from the as-of date to the last day: 0 means the as-of date is the last day, and a number below 0 means the last day has passed by that many days. Weekends and holidays do not move the last day.

Where do the limits come from?

For Medicare and each state's Medicaid fee-for-service program, from the row in the site's timely filing limits table, which names the rule or manual it was read from and the date it was read. For any other payer, from the limit you type, which is labeled as typed in the list, the totals, and the downloads. The tool does not apply the exceptions a source lists, and it does not say whether a claim can still be filed or appealed.

What happens to a payer I leave without a limit?

Its claims stay in the list, at the bottom, in a group called no limit chosen, and their amounts stay in the totals. A warning names the payer, so nothing is left out quietly.

Is the claims file uploaded?

No. This page is served with a policy that blocks every kind of network request from the page, so the file is read in this browser tab and has no way to leave it. You can disconnect from the internet after the page loads and it still works.

Which files does it read?

CSV and .xlsx exports with one claim per row and a heading row. You choose the four columns. An amount can be written with a dollar sign, commas, or in parentheses for a negative, and dates can be year-month-day, month/day/year, day/month/year, or a spreadsheet date.

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