Spreadsheet checks before running interest in California

What the checker catches

Run this scenario in DocketMath using the Interest calculator.

Before you run interest calculations in California, a surprising number of errors come from spreadsheets—not the math engine. DocketMath’s interest tool works from the inputs you give it, so the best results start with a spreadsheet sanity-check.

Here’s what a spreadsheet checker should catch in a California workflow:

• **Wrong start date (or wrong “event” date)

  • Common mistakes include using the invoice date when your workflow should use a judgment date, settlement date, or demand date.
  • Even a small 1–7 day shift can noticeably change interest totals.

• Incorrect end date

  • If your sheet uses “today” but it isn’t generated in the same way (timezone/format) as your calculation cell, totals can drift.
  • Another recurring issue: using a payoff date in the interest tool while your spreadsheet still accrues through a later “statement date.”

• String dates and mixed date types

  • Excel/Sheets sometimes store dates as text (e.g., 01/02/2024 saved as a string).
  • Your checker should flag cells that look like dates but won’t behave like dates when used in interest formulas.

• **Sign errors (negative principal or negative payments)

  • Some templates represent payments as positive numbers; others use negatives to subtract from principal.
  • A mismatch can double-count or effectively reverse how payments reduce principal.

• Payments entered in the wrong columns or wrong direction

  • If payments are meant to reduce principal, your spreadsheet’s structure has to match what the tool expects.
  • A checker can validate that payment rows exist and that net principal changes in the correct direction after payments.

• Partial-period mistakes

  • Spreadsheets often prorate interest incorrectly for partial months/weeks, or they prorate twice (once in a formula and again inside the tool).
  • A checker can help you confirm whether proration is handled where you think it is, so you don’t “stack” proration logic.

• Over-optimistic statute-of-limitations assumptions

  • In California, the general/default limitations period is 2 years under CCP §335.1.
  • No claim-type-specific sub-rule was found for this brief, so treat the 2-year period as the general rule for this workflow.
  • The checker can’t replace legal analysis, but it can flag whether your sheet’s timeline appears to conflict with the default 2-year window.

Pitfall: A spreadsheet can be arithmetically perfect while still producing an interest figure based on the wrong limitations window. The checker should surface date-window inconsistencies before you run interest.

Quick “input integrity” checklist

Use this checklist before you send dates and amounts into DocketMath:

When to run it

Run the checker at three points in your workflow so issues are caught early and don’t “spread” across the spreadsheet:

1. Before you build the interest input table

   • Validate raw fields first: principal, payment dates, payment amounts, and the interest start/end dates.
   • Fixing misformatted dates later is harder and more error-prone.

2. After you import or paste data

   • Copy/paste from emails, PDFs, or accounting exports is where date formatting breaks most often.
   • Your checker should immediately confirm that pasted values behave like dates and that numeric columns didn’t import as text.

3. Right before you click through DocketMath’s interest tool

   • This final pass is about reconciliation:

     • Does the spreadsheet’s net principal remaining match what you’ll feed into the tool?
     • Do payment dates align with the timeline the tool will apply?

California timing note (default rule):
If your spreadsheet includes a limitations filter, anchor it to California’s general/default 2-year rule:

• General SOL period: 2 years
• General statute: CCP §335.1
• Source context: California legal guides commonly summarize this general limitations period (CCP §335.1), including references like the AllLaw/Nolo overview: https://www.alllaw.com/articles/nolo/personal-injury/laws-california.html

Operational takeaway: treat the 2-year period as the default unless your analysis explicitly identifies a different, claim-specific rule. For this brief, no claim-type-specific sub-rule was found, so defaulting to 2 years is the safe workflow assumption.

Try the checker

Here’s a practical way to sanity-check your spreadsheet for a California interest run using DocketMath’s interest workflow (via /tools/interest).

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

Step 1: Create a minimal “interest input table”

Even if your spreadsheet is complex, extract the values that matter into a clean table with these columns:

If you don’t already have a payments table, build one. The checker can’t fix inconsistent structure—it can only detect it.

Step 2: Run date consistency checks

In Excel or Google Sheets, use simple rules to confirm:

• Each date cell passes a “is-date” check (for example, Sheets-style logic vs. Excel date serial behavior)
• Ordering checks:

  • Interest start date < first Payments date (when payments exist)
  • payments are sorted ascending
  • Payments date ≤ Interest end date

Step 3: Reconcile principal impact

Before DocketMath runs anything, confirm your spreadsheet’s net effect matches your intent:

• **Net principal = Principal + sum(payments amounts)

Sanity-check expectations:

• If payments reduce principal, net principal should move down, not up.
• If you have no payments, net principal should equal principal.

Step 4: Apply a “default SOL window” flag (workflow aid)

Because the general/default limitations period is 2 years under CCP §335.1, add a simple flag to your sheet:

• Flag when (end date − start-of-claim/timeline date) > 2 years

Reminder: this is a workflow check, not legal advice or a substitute for claim-specific analysis.

If your situation involves a different limitations rule than the default, adjust the workflow accordingly—don’t hide the assumption.

Step 5: Run DocketMath interest and compare totals

Once inputs are clean:

1. Open DocketMath’s interest tool: /tools/interest
2. Enter the same start/end dates and payment schedule you validated
3. Compare plausibility:

   • Does increasing the end date increase interest (directionally)?
   • Do tiny date tweaks (e.g., shifting a payment date by 1 day) produce changes that feel reasonable?

Then archive the checked sheet version so you can reproduce the run later.

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