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.
1. Open claims
First rows of the file, as read:
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.
Verification
Totals by payer
Open claims, soonest last day first
Arithmetic on the limits shown: it does not say whether a claim can still be filed or appealed. Rules change; the table rows show the day each was read. Mathproven is not affiliated with any payer or agency named here.
What gets checked
- Every claim read from the file is in the list exactly once, with its own claim number, payer, date of service, and amount.
- Each claim is counted with its payer's chosen limit, exactly as the table row holds it (with its citation) or as it was typed; a typed limit is labeled as typed everywhere it shows.
- Each last day is worked out a second time on a separate whole-number calendar, and each days-left figure is counted again by day numbers from the as-of date.
- Each claim is in exactly one group (past the limit, inside the chosen number of days, more than that, or no limit chosen), and it is the group its days left put it in.
- The list runs soonest first, and claims whose payer has no limit chosen come last.
- Each payer's claim counts and dollar totals in each group are recounted from the list in whole cents and must tie to the list and to the claims read; the payers together must equal every claim.
- A row in the file that has something in the chosen columns but cannot be read makes the result not verified, and the row is named.
- Warnings show for a payer with no limit chosen, a typed limit, a date of service after the as-of date, a claim number on more than one row, and a date of service whose day of the month does not exist in the month its count ends in (such as February 29 plus one year).
How it works
- 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.
- 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.
- 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.
- 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.
| Claim | Payer | Date of service | Limit used | Last day | Days left | Group | Open amount |
|---|---|---|---|---|---|---|---|
| MB-1006 | New York Medicaid | 2026-07-01 | 90 days (table) | 2026-09-29 | -44 | Past the limit | $150.00 |
| MB-1001 | Lakeview Health Plan | 2026-05-01 | 180 days (typed) | 2026-10-28 | -15 | Past the limit | $412.50 |
| MB-1002 | New York Medicaid | 2026-08-20 | 90 days (table) | 2026-11-18 | 6 | Inside 30 days | $96.00 |
| MB-1003 | Medicare | 2025-12-01 | 1 year (table) | 2026-12-01 | 19 | Inside 30 days | $1,240.00 |
| MB-1004 | Lakeview Health Plan | 2026-07-15 | 180 days (typed) | 2027-01-11 | 60 | More than 30 days | $250.75 |
| MB-1005 | Medicare | 2026-09-30 | 1 year (table) | 2027-09-30 | 322 | More 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.