Spreadsheet checks before running Wage Backpay in Mississippi

What the checker catches

Before you run wage backpay calculations in Mississippi (US-MS) with DocketMath, a spreadsheet-level review can prevent avoidable errors. The “Spreadsheet checks” pattern focuses on one thing first: whether your workbook is set up to respect the jurisdiction-aware statute of limitations rules that control whether backpay periods are potentially recoverable.

For Mississippi, the applicable default limitation period is the general statute of limitations—3 years, set by Miss. Code Ann. § 15-1-49. You should treat this as the default because no claim-type-specific sub-rule was identified for this checker setup. In other words: unless your situation triggers a different limitation scheme (not covered by this checker), start with 3 years.

Here’s what the checker catches in a wage backpay spreadsheet workflow:

• Accidentally including time outside the 3-year window

  • Common issue: a sheet totals wage shortfalls from “employment start” through “today,” without trimming to a limitations cut-off.
• Cut-off date calculated from the wrong anchor

  • Example: using “end date” instead of the violation/filing anchor (your sheet should be explicit about what date starts the 3-year clock in your model).
• Mixed timebases in different columns

  • Example: one tab uses calendar days while another uses pay periods; totals don’t reconcile after trimming.
• Partial-period errors around the 3-year boundary

  • Examples:

    • Off-by-one day logic (e.g., including the boundary day when it shouldn’t be).
    • Rounding pay periods inconsistently after the cut-off is applied.
• Incorrect rate application after trimming

  • If your worksheet updates hourly rates over time, the checker flags when rate changes continue to apply even after the period is supposedly excluded.
• Inconsistent employee classification inputs

  • Wage backpay models often branch by pay type (hourly vs. salary), overtime treatment, or deductions. Even without changing the SOL window, inconsistent pay-type flags can make the “included days” concept look correct while the dollars don’t.

To keep it actionable, the checker is designed around spreadsheet integrity checks that directly affect the wage-backpay totals you’ll feed into DocketMath.

Jurisdiction rule the checker uses (US-MS)

When to run it

Run the spreadsheet checker before you execute the wage backpay calculator run in DocketMath—specifically at points where your spreadsheet chooses dates, includes/excludes pay periods, or converts work time into dollars.

A practical sequence:

1. Confirm the limitation anchor date is explicit

   • Your workbook should include a single “clock start/anchor” date used to define the 3-year window.
   • If you have multiple tabs, make sure the same anchor date is referenced everywhere.
2. **Trim the pay-period list (or mark exclusions)

   • Apply the 3-year filter before aggregating:

     • Hours
     • Hourly rates / salary conversions
     • Gross wages
     • Any deductions you model
3. Reconcile totals after trimming

   • Your “total backpay included” should drop when you apply the SOL window.
   • If totals don’t change, your spreadsheet likely never actually excluded out-of-window periods.
4. Only then run DocketMath

   • Feed DocketMath the cleaned, jurisdiction-aware totals or period set so the calculator isn’t forced to compensate for workbook structure problems.

You should also rerun the checker whenever you change any of these inputs:

• filing/claim anchor date in your model
• employment dates
• pay period start/end dates
• pay-rate schedule (raises, job changes, bonus conversions)
• overtime logic or pay-type mapping
• deduction rules that affect net wage backpay

Try the checker

You can use DocketMath to do the wage backpay work, but first push your spreadsheet through the checks described above so the SOL filter (default 3 years under Miss. Code Ann. § 15-1-49) is applied consistently.

Here’s a quick “walk-through” checklist for your workbook:

After those are satisfied, run the wage backpay calculation in DocketMath using your cleaned inputs via: /tools/wage-backpay.

You can also review your approach to calculations and data structure with the DocketMath workflow tools here: tools/wage-backpay.

What to expect when outputs change

Once the 3-year filter is applied:

• Total backpay included typically decreases

  • by excluding the earliest periods outside the 3-year window.
• Net vs. gross differences can shift

  • because deductions modeled per period may be tied to periods you now exclude.
• Any “average rate” columns may change

  • if those averages were computed over all employment dates rather than included periods only.

If your numbers don’t move after trimming, that’s a signal to rerun the checker—your filter logic may not be wired into the calculation columns.

Related reading

• Wage & Backpay Calculator Guide for Alabama
• Wage & Backpay Calculator Guide for Arizona
• Wage & Backpay Calculator Guide for Colorado