Spreadsheet checks before running Alimony Child Support in Kansas

What the checker catches

Run this scenario in DocketMath using the Alimony Child Support calculator.

Before you run an alimony or child support calculation in Kansas with DocketMath, a spreadsheet-style “sanity check” can prevent downstream errors—especially when your workbook includes old case facts, partial dates, or mismatched timelines.

This Kansas-focused spreadsheet checker is designed to catch issues that typically distort support outcomes by affecting threshold eligibility, timing, or data mapping into the calculator inputs.

Common spreadsheet issues DocketMath checks (US-KS)

• Missing or inconsistent dates

  • Example: the “date of filing” is later than the “date of separation,” or your worksheet includes an “earlier effective date” that doesn’t match the case timeline.
• Wrong date formats or hidden text dates

  • A date entered as text may sort incorrectly (or be ignored by formulas), causing period calculations to drift.
• Off-by-one month ranges

  • If your spreadsheet calculates months using a crude 30-day approach, month boundaries can shift the number of payable months.
• Stale case parameters

  • Worksheet cells like “current support,” “custody schedule,” or “income effective date” might have been updated in one tab but not in the tab feeding the calculator.
• Calculator-input drift

  • If your worksheet has separate “gross income” and “net income” lines, confirm the value passed into DocketMath is the intended input type for the alimony-child-support calculator.

Kansas timing backdrop: why date integrity matters

Support calculations and modifications often depend on timelines. While this checker is not a substitute for legal analysis, Kansas timing rules make date accuracy a practical must in spreadsheet-based workflows.

For general time-limit context, Kansas provides a general statute of limitations (SOL) period of 0.5 years under K.S.A. § 21-6701:

• General SOL Period: 0.5 years
• General Statute: K.S.A. § 21-6701
• Source: https://www.kslegislature.gov/li/s/statute/021_000_0000_chapter/021_067_0000_article/021_067_0001_section/021_067_0001_k.pdf?utm_source=openai

Important clarity: The jurisdiction notes provided do not identify a claim-type-specific sub-rule. So this checker treats 0.5 years as the default/baseline timing context, not a specialized rule-by-rule entitlement standard.

When to run it

Run the checker before you press the button on any alimony or child support computation in DocketMath. In practice, there are two high-impact moments: at data entry time and after you revise assumptions.

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.

Best times to run the checker

1. Initial workbook setup

   • Right after you compile:

     • the relevant dates,
     • income figures,
     • and any custody/schedule assumptions.
2. After any revision

   • If you change one date cell (for example, an “income effective date”), re-run immediately. Spreadsheet dependencies can cascade silently.
3. Before exporting results

   • If you copy results into a filing packet, confirm the timeline inputs feeding DocketMath still match what you intend to submit.

Quick “run cadence” checklist

What outputs change when checks fail?

If the checker finds an issue, the most common downstream changes are:

• Period selection changes

  • Output totals shift because the number of months in scope changes.
• Income mapping changes

  • If your spreadsheet accidentally passed the wrong income column, DocketMath may compute using the wrong figure.
• Timeline constraints change

  • With inconsistent dates, the calculator may treat some periods as out-of-range (depending on how your spreadsheet mapping is configured).

Try the checker

Use DocketMath’s alimony-child-support tool workflow in a way that starts with validation, not calculation.

Upload the spreadsheet, review the warnings, and then run the calculation once the inputs are clean: Try the checker.

Suggested workflow (spreadsheet-first)

1. Open DocketMath’s alimony-child-support tool.
2. Enter or import your spreadsheet facts into the DocketMath input fields.
3. Run the Kansas spreadsheet checker pre-flight checks first.
4. Fix any flagged cells and re-run.
5. Only then generate calculation outputs.

Primary CTA

Start here: /tools/alimony-child-support

Input-to-output examples (what to correct)

• If the checker flags date order (end date before start date):

  • Correct chronology first, then re-run—because even one reversed date can alter which months are applied.
• If it flags text dates:

  • Re-enter or convert the cells so formulas recognize them as real dates; period math becomes much more reliable after conversion.
• If it flags a period mismatch (your month count doesn’t match DocketMath’s framing):

  • Update your spreadsheet’s period logic—for example, prefer month-based boundaries rather than day-approximation methods.

Related reading

• Alimony & Child Support Estimator Guide for Alabama
• Alimony & Child Support Estimator Guide for Arizona
• Alimony & Child Support Estimator Guide for Colorado