Spreadsheet checks before running Alimony Child Support in Mississippi
5 min read
Published April 15, 2026 • By DocketMath Team
What the checker catches
Before you run DocketMath’s alimony-child-support calculator in Mississippi (US-MS), use a spreadsheet-focused checklist to catch the most common problems that distort results. This is especially helpful because spreadsheet outputs depend heavily on whether your “from/to” date logic and totals windows match the calculator’s period timing.
1) Misaligned date rows (the #1 spreadsheet error)
Most alimony/child support spreadsheets fail because the dates driving “how far back” calculations don’t match the worksheet structure. The calculator may compute amounts correctly, but your spreadsheet totals can still be wrong if you:
- Put the wrong start date in one tab but not another
- Use filing date in one row and effective date in another
- Split periods into columns that don’t match your calculator’s period logic
Quick check: verify that every column representing a month/year points to the same “from” and “to” dates across the workbook.
2) Statute of limitations (SOL) mismatch in arrears summaries
Mississippi has a general SOL period of 3 years. The general default period is stated in Miss. Code Ann. § 15-1-49.
No claim-type-specific sub-rule was found in the jurisdiction data you provided—so in this workflow, treat 3 years as the general/default SOL period for spreadsheet-based arrears summaries.
What this checker catches:
- When your spreadsheet “lookback” exceeds 3 years
- When your totals row includes months older than the SOL boundary (even if the line items look reasonable)
Note: This checker helps you keep your worksheet math consistent with a 3-year general/default SOL framework using Miss. Code Ann. § 15-1-49. It does not predict what a court will do.
3) Reversed or inconsistent jurisdiction fields
In multi-state templates, spreadsheets sometimes carry over fields incorrectly. If your worksheet says “MS” in one place but the rules applied are effectively for another state, output totals can swing significantly.
Checklist item: confirm the jurisdiction code is US-MS everywhere it appears in your workbook (including hidden sheets and “settings” tabs).
4) Output/assumption drift between tabs
A common failure mode: one tab calculates monthly/weekly support using one assumption set, while another tab calculates arrears totals using a different assumption set (rate changes, rounding, or period length).
The checker is designed to help you spot “drift” by comparing:
- Period lengths (e.g., how you treat days in a month vs. a fixed convention)
- Rounding approach (rounding monthly then summing vs. summing first then rounding)
- Rate schedules (step changes applied to different months)
Quick practice: pick 2–3 months and confirm the same rate and the same rounding method drive those months in every relevant tab.
5) Missing or empty cells that silently default to zero
If your spreadsheet uses formulas like =IFERROR(value,0), missing inputs can masquerade as zeros—making totals look “clean” while being wrong.
What to catch:
- Empty income fields
- Blank date boundaries
- Unchecked flags that determine whether a month is “in scope”
Pitfall: a missing “effective date” cell can cause the arrears portion to look artificially low while still producing a polished number.
When to run it
Use the spreadsheet checker at three points in your workflow—each one catches different failure patterns.
Run the checker before importing a spreadsheet into the Alimony Child Support workflow. It is especially helpful when you have multiple entries or when a teammate provided the inputs.
Step A: Before you enter dates into the calculator
Run the checker on your draft worksheet first. That helps you avoid feeding incorrect “from/to” date logic into DocketMath.
Do this when:
- You’re building a new spreadsheet from scratch
- You’re converting a previously used template
- You’re changing reporting periods (e.g., monthly to biweekly)
Step B: After you finalize the date boundaries, but before arrears totals
At this stage, confirm your lookback window aligns with the general 3-year SOL framework tied to Miss. Code Ann. § 15-1-49.
Do this when:
- You’re summarizing totals for “arrears”
- You’re labeling totals as “past due” or “recovery period”
- You’re generating a timeline exhibit
Step C: Immediately after importing or copying values across tabs
If you copy results from one sheet to another (or import from paystubs/banking), run the checker again.
Do this when:
- Values appear “off” by a constant factor
- Only some months look wrong
- You changed rounding settings or formatting
Try the checker
You can run DocketMath’s alimony-child-support workflow while applying spreadsheet checks to keep your inputs aligned for Mississippi (US-MS).
Upload the spreadsheet, review the warnings, and then run the calculation once the inputs are clean: Try the checker.
Checklist for spreadsheet inputs (MS / US-MS)
Use this sequence while preparing your worksheet:
How inputs change outputs (practical effects)
Even small spreadsheet errors can change numeric outcomes:
| Spreadsheet input issue | Likely effect on calculator totals |
|---|---|
| Lookback window exceeds 3 years for arrears summary | Inflated “past due” totals |
| Start/end dates differ across tabs | Some months counted twice—or not at all |
| Rate changes applied to wrong months | Step-change months shifted, changing totals materially |
| Rounding done at different stages | Totals drift by a few dollars per month that accumulate quickly |
What to do with your results
After you run DocketMath, do a final “sanity sweep” before you rely on the totals:
- Compare the number of months counted in your arrears section to the expected window based on 3 years (general/default SOL per Miss. Code Ann. § 15-1-49)
- Spot-check the first month in the window and the last month in the window
- Confirm the worksheet sums match the tool’s period breakdown
Primary CTA: **Run alimony-child-support calculations in DocketMath