Spreadsheet checks before running interest in Connecticut

What the checker catches

Before you calculate interest in Connecticut, spreadsheets tend to fail in predictable ways—especially when you’re importing dates, prorating periods, or compounding monthly. DocketMath’s interest workflow can help, but you’ll get the cleanest results if you first run a few spreadsheet sanity checks.

Below are the most common problems the checker is designed to surface, using the core timing rule that Connecticut generally applies a 3-year statute of limitations period as a general/default limitation period for certain actions to recover damages. The relevant statute is Conn. Gen. Stat. § 52-577a (general SOL period: 3 years). Importantly, your brief notes that no claim-type-specific sub-rule was found, so this article uses the 3-year general/default period consistently unless your spreadsheet has a documented reason to do otherwise.

Here’s what to check, and why it matters:

• Date parsing and formatting

  • Symptom: Interest outputs change drastically after “recalculating,” or some rows show blank/zero interest.
  • Check: Verify all date columns are true dates (not text). Watch for mixed formats like MM/DD/YYYY vs DD/MM/YYYY.
  • Effect on interest: Day-count calculations shift by days, which changes interest totals.

• Start date vs. demand/trigger date logic

  • Symptom: You see interest accruing from an earlier date than intended.
  • Check: Confirm the spreadsheet uses the correct “interest start” date consistently across all rows/line items.
  • Effect on interest: Even a few weeks of shift can produce large differences on high principal balances.

• End date and “as-of” date inclusion

  • Symptom: Totals look off by a small but consistent amount.
  • Check: Decide whether you’re counting inclusive or exclusive dates and apply it consistently (e.g., through the day before the end date).
  • Effect on interest: Off-by-one day errors accumulate across many line items.

• **Wrong day-count basis (360 vs 365)

  • Symptom: Spreadsheet results don’t match expectations, even when dates look right.
  • Check: Identify whether your sheet uses 365-day or 360-day conventions (and whether DocketMath is configured similarly for your method).
  • Effect on interest: The same principal and period can yield different outputs under different day-count bases.

• Compounding vs. simple interest

  • Symptom: Interest grows too fast or too slowly relative to your expectation.
  • Check: Ensure the spreadsheet matches the compounding frequency used by your interest method (monthly, quarterly, annual, etc.).
  • Effect on interest: Compounding frequency can materially increase totals over multi-year spans.

• **Sign errors (credits treated as charges)

  • Symptom: Negative interest values appear or principal reduces when it should increase.
  • Check: Confirm whether inputs are positive-only and whether payments/credits are applied as reductions.
  • Effect on interest: A single sign inversion can reverse interest direction.

• Statute of limitations (SOL) window applied inconsistently

  • Symptom: Some rows appear filtered to the last 3 years, but others still compute interest for older periods.
  • Check: Use one consistent rule for which dates qualify—and ensure every row that feeds interest uses it.
  • Effect on interest: The statute of limitations rule should drive whether you compute interest outside the covered period. With your brief’s constraints, that rule is the general/default 3-year SOL period under Conn. Gen. Stat. § 52-577a.

To make the timing rule concrete for your sheet, anchor your “limitations cutoff” to either:

• a chosen event date (often the relevant accrual/start date your spreadsheet uses), or
• a chosen calculation as-of date plus the 3-year lookback window—depending on how your spreadsheet structures the timeline.

Because your brief specifies the general/default period (and “no claim-type-specific sub-rule was found”), keep your spreadsheet strictly aligned with the 3-year default and document that assumption in a cell or note.

When to run it

Run the checker before you generate any final interest report. If you’re running many scenarios (different as-of dates, amended principals, alternative start dates), rerun it each time you change any timing inputs.

Use this sequence:

• Step 1 — Lock core inputs

  • Principal amounts
  • Payment dates and amounts (if applicable)
  • Interest start date(s)
  • Interest end/as-of date
  • Day-count convention and compounding settings

• Step 2 — Apply the 3-year SOL rule consistently

  • Use the general/default 3-year limitation period under Conn. Gen. Stat. § 52-577a.
  • Apply the filter uniformly across all rows/line items that feed interest calculations.
  • Avoid mixing “filtered rows” with “unfiltered interest formulas.”

• Step 3 — Perform the spreadsheet checks

  • Validate date types and date ordering
  • Confirm inclusion/exclusion rules
  • Confirm sign conventions
  • Confirm compounding settings

• Step 4 — Only then run interest

  • Generate interest totals for each line item
  • Aggregate to the final total
  • Compare outputs to expected magnitude ranges

Best timing for re-checks:

• after any change to start date, end date, or principal/payment timing
• after importing or pasting data (date formats often break during copy/paste)
• after switching compounding frequency or day-count basis

Try the checker

You can use DocketMath’s interest checker for practical sanity checks of spreadsheet inputs—especially the timing parts that commonly go wrong in Connecticut scenarios using the 3-year general/default SOL period under Conn. Gen. Stat. § 52-577a.

1. Open DocketMath’s interest checker: ** /tools/interest
2. Paste or map your spreadsheet fields in the checker input area.
3. Run the checker and review flagged items.

To make this concrete, here’s an “inputs vs. output behavior” checklist you can mirror in your spreadsheet:

Finally, compare the checker’s “clean run” totals to your spreadsheet’s totals:

• If the difference is small (e.g., roughly 1–2 days worth of interest), suspect inclusion/exclusion or day-count.
• If the difference is large (e.g., interest accruing from a much earlier date), suspect date logic or SOL cutoff filtering.

If your current spreadsheet does not explicitly encode the 3-year limitation window from Conn. Gen. Stat. § 52-577a, add a dedicated column such as “IsWithin3YearWindow” and reference it in your interest formula so every line item follows the same rule. This is one of the highest-leverage fixes for interest errors.

Gentle reminder: This is a spreadsheet quality-check approach, not legal advice. If you have a reason to believe a different limitation rule applies than the general/default 3 years, confirm the correct basis before relying on the results.

Related reading

• Interest rule lens: Maine — The rule in plain language and why it matters
• Common interest mistakes in Rhode Island — Common errors and how to avoid them
• Worked example: interest in Maine — Worked example with real statute citations