Spreadsheet checks before running Alimony Child Support in New York

What the checker catches

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

Before you run an alimony and/or child support calculation in New York with DocketMath’s alimony-child-support tool, use this spreadsheet checker to catch common “garbage-in” problems—especially those that break results after you export values, copy formulas, or adjust payor/payee columns.

This checker focuses on three practical categories of spreadsheet issues:

1. Jurisdiction mismatches in a multi-tab workbook

   • Example: you copied an input tab from another state, but the “NY” worksheet still points to the wrong cell range.
   • What to check in your spreadsheet:

     • Make sure the workbook is explicitly labeled with jurisdiction code US-NY.
     • Ensure every calculation tab references the same New York jurisdiction inputs (not an older copy that still contains different assumptions).

2. Time-window errors caused by incorrect date arithmetic

   • Alimony/child support worksheets often include start date, modification date, retroactive period, arrears period, or document entry date.
   • Run the checker to verify:

     • Date ordering: no “end date” earlier than “start date” for any retroactive/arrears window.
     • Consistent date formats (for example, YYYY-MM-DD).
     • No mixed formats: Excel sometimes stores typed dates as “text,” which makes formulas behave unexpectedly.

3. Arrears/collection logic conflicts—especially when your time window exceeds New York’s general limitations benchmark

   • DocketMath can only compute with what you provide in your inputs; it can’t automatically infer every legal nuance from your spreadsheet.
   • If your spreadsheet uses a retroactive or arrears horizon, the checker helps ensure your workflow is aligned with a general/default limitations period of 5 years.
   • Jurisdiction data you provided states that the general/default period is 5 years, referencing N.Y. Crim. Proc. Law § 30.10(2)(c):

     • Source: https://www.nysenate.gov/legislation/laws/CPL/30.10

   Important note (based on your jurisdiction data): No claim-type-specific sub-rule was found. That means this checker treats 5 years as the general/default period, not as a claim-type-specific deadline. If your workflow depends on a specialized limitations rule, confirm that separately before relying on any retroactive-range inputs.

A practical checklist (quick pass)

When to run it

Run the spreadsheet checker at three decision points so you catch issues early—before calculation outputs cascade into the tool results.

1. Before you enter values into DocketMath

   • This prevents the fastest failures.
   • Common issues caught here: wrong date format, off-by-one month windows, and mislinked cells.

2. After you revise dates or retroactive/arrears periods

   • If you update any of these, rerun the checker:

     • agreement/filing date changes
     • modification effective date changes
     • start/end of arrears window changes
   • Spreadsheets can “look right” while formulas still reference an older range—so this step matters even if totals seem unchanged.

3. Right before you finalize an output for review or sharing

   • Treat this as a “preflight” step.
   • Goal: confirm the exported inputs still match what the output claims to calculate.

Date-window sanity rules to enforce

Limitations-period alignment (general/default benchmark)

If your spreadsheet includes a retroactive or arrears time horizon, the checker should flag when the window exceeds your general/default 5-year benchmark.

• General/default: 5 years
• Basis (jurisdiction data you supplied): **N.Y. Crim. Proc. Law § 30.10(2)(c)
• Source: https://www.nysenate.gov/legislation/laws/CPL/30.10

Warning (workflow-focused, not legal advice): A limitations period is not the same thing as “how long you can calculate arrears” in every context. Your spreadsheet may be doing arithmetic over a longer window, but this checker surfaces whether your window is exceeding a general benchmark so you don’t accidentally present results as time-permitted when you haven’t validated the rule that applies to your situation.

Try the checker

Use DocketMath to run your alimony-child-support workflow, but do it after a spreadsheet preflight.

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

Capture the source for each input so another team member can verify the same result quickly.

Step-by-step: spreadsheet checks → tool inputs

1. Open your spreadsheet and complete the quick pass:

   • confirm jurisdiction label US-NY
   • validate date ordering and formats
   • confirm your “months” fields match the date window

2. Compare your date window to your single general/default benchmark:

   • If you’re using the 5-year general/default period, ensure your retroactive/arrears window doesn’t silently exceed it.

3. Export or enter the cleaned values into the tool.

   • Remember: any output is only as reliable as the inputs you validated.

DocketMath tool call-to-action

Use the calculator here:

• /tools/alimony-child-support

Input → output behavior map (what changes when you fix inputs)

Related reading

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