Spreadsheet checks before running Alimony Child Support in Florida

What the checker catches

DocketMath’s Spreadsheet Checker for Florida alimony + child support helps you stop the most common spreadsheet mistakes before you run the Alimony Child Support calculator. It’s a pre-flight list for inputs that drive the outputs under Fla. Stat. § 61.30 (child support) and § 61.08 (alimony, as amended by SB 1416, 2023).

Use it to validate assumptions and spreadsheet lookups that are easy to miss when you’re copying numbers across tabs.

High-impact input issues to catch first

• Jurisdiction alignment

  • Make sure your spreadsheet is using:

    • child support rules for Fla. Stat. § 61.30
    • alimony rules for § 61.08 (as amended by SB 1416, 2023)
• Income limits / presumptions

  • Your spreadsheet should reflect the verified income cap configuration used by the Florida calculator logic:

    • Income cap type: presumptive
    • Income cap: $120,000
    • Income cap notes: Combined net income limit raised from $144,000 to $600,000 effective Jan 1, 2026 under Fla. Stat. § 61.30
• Schedule table consistency

  • Spreadsheet errors often come from pulling the wrong bracket row or sorting incorrectly.
  • The checker validates your combined monthly net values against the verified schedule table anchors (examples include $800, $1,000, $3,250, $3,500, $4,000, $6,000, and additional steps up through $30,000).
• Alimony duration + marriage-length tiers

  • Because alimony duration is tied to marriage-length tier inputs under § 61.08, the checker confirms your tier inputs fall within the verified boundaries:

    • Long term: min 20 years
    • Mid term: min 10 years, max 20 years
    • Short term: max 10 years
• Alimony formula caps

  • The checker also enforces verified guardrails that affect the output:

    • Durational cap percentage: 0.35
    • Marriage-length cap (moderate term max pct): 0.6

Common spreadsheet problems the checker prevents

• Wrong unit (annual vs monthly net) feeding a table that expects combined monthly net
• Mis-typed combined monthly net amounts that don’t match the schedule table anchors your spreadsheet references
• Copy/paste row mismatch when you have multiple children or multiple scenario tabs
• Alimony term inputs that don’t align with the verified tier boundaries (10/20 year boundaries)
• Missing or incorrect income cap type (for the verified ruleset, it should be “presumptive”)

When to run it

Run the checker at moments where input mistakes are most costly—so you catch them before you interpret results.

1) Before any calculator run

After you populate inputs, but before you calculate outputs. This catches:

• schedule lookup bracket mismatches tied to Fla. Stat. § 61.30
• alimony cap and tier logic mismatches tied to § 61.08 (SB 1416, 2023)

2) After you import or rebuild the spreadsheet

Rerun it if you:

• copied from an older template
• changed your net income calculation formulas
• added a new worksheet tab
• changed labels/column order

The checker is designed to validate your numbers against the verified ruleset, including schedule anchors like $800, $1,000, $1,250, $1,500, $1,750, $2,000, and higher combined monthly net values.

3) After scenario changes (not after every tiny edit)

When you update scenario assumptions—like a new combined monthly net figure or different marriage duration inputs—treat that as a new “batch”:

• Update scenario inputs → run checker → run calculator

This keeps your results consistent and reduces the chance that one corrected value is left behind in another tab.

Try the checker

To keep the process consistent, follow this sequence.

Step-by-step workflow

1. Open DocketMath’s Florida Alimony Child Support tool at: /tools/alimony-child-support
2. Enter your inputs for:

   • combined net income used for the child support schedule under Fla. Stat. § 61.30
   • marriage duration / term inputs used by the alimony formula and caps under § 61.08 (as amended by SB 1416, 2023)
3. Run the Spreadsheet Checker within the tool flow.
4. Fix anything flagged in your spreadsheet (don’t just overwrite the output number).
5. Re-run the checker after each meaningful fix.
6. Only then run the calculator to generate outputs.

Quick “sanity checks” aligned to the verified ruleset

Use these to confirm your spreadsheet is aligned before you rely on calculator results:

• Confirm your combined monthly net values align with the schedule bracket you expect (verified anchors include $800, $1,000, $1,250, $1,500, $3,000, $4,000, $6,000, $10,000, $20,000, $30,000, etc.).
• Confirm your marriage-length tier selection matches the verified thresholds:

  • short: max 10 years
  • mid: 10–20 years
  • long: min 20 years
• Confirm your alimony settings don’t conflict with the verified caps:

  • durational cap percentage: 0.35
  • marriage-length cap (moderate term max pct): 0.6

Gentle reminder: This is a spreadsheet-validation workflow to reduce input errors; it’s not legal advice.

Related reading

• How Alimony Child Support rules vary in New York — What varies by jurisdiction
• How to calculate Alimony Child Support in Philippines — Full how-to guide with jurisdiction-specific rules
• Worked example: Alimony Child Support in Philippines — Worked example with real statute citations