Spreadsheet checks before running interest in New York

Running interest on a messy spreadsheet in New York is an easy way to get the right legal rule and the wrong number.

This post walks through how to sanity‑check your spreadsheet before you run interest using DocketMath’s interest calculator for New York (US‑NY). The goal is simple: catch structural problems early so you don’t have to redo a long calculation, explain weird totals, or reconcile numbers under deadline pressure.

What the checker catches

Before you even think about New York’s statutory rates, you want to know whether your spreadsheet is structurally sound. A good “checker” pass focuses on four things:

1. Date integrity
2. Principal and payment structure
3. Rate and jurisdiction alignment
4. Totaling and rounding behavior

Below is a practical checklist you can copy into your own workflow.

1. Date integrity

Interest is time‑based. If the dates are wrong, everything downstream is wrong.

Core checks:

• All date cells are actual dates (not text that looks like dates).
• No dates are in the future (relative to your “as of” date).
• No negative or zero‑length periods (end date before start date).
• All rows that should have a date actually have one.
• Date format is unambiguous (e.g., 2024‑01‑02 vs 01/02/24).

How it affects outputs (New York‑specific examples):

• Pre‑judgment vs post‑judgment interest
  If you’re splitting pre‑judgment and post‑judgment interest, one misplaced judgment date can:

  • Overstate pre‑judgment interest (judgment date entered too late).
  • Understate it (judgment date entered too early).
• Multiple partial payments over time
  If a payment date is mis‑entered (e.g., 2014 instead of 2024), the calculator may:

  • Treat a payment as happening much earlier → less interest.
  • Or much later → more interest than you can justify.

Quick test:
Sort your transaction table by date ascending. If anything looks out of chronological order (e.g., a 1900 or 2099 date, or a block of payments separated from the main timeline), fix that before running interest.

2. Principal and payment structure

Next, confirm that the money amounts are structured the way you intend.

Core checks:

• Positive vs negative values are consistent (e.g., all advances positive, all payments negative).
• No “double sign” errors (e.g., both labeling something as a payment and using a negative sign).
• Principal, fees, and costs are separated if you need different interest treatment.
• Zero amounts are intentional (e.g., placeholder rows).

How it affects outputs:

• Overstated principal balance
  If a payment is entered as positive instead of negative, the balance never drops. Interest accrues on too high a base.
• Mis‑allocation between principal and non‑interest items
  In New York, whether a specific charge earns interest can depend on character (e.g., taxable costs vs non‑taxable). If you lump everything into one column, you lose the ability to:

  • Turn interest on/off for specific categories.
  • Explain why some amounts didn’t accrue interest.

Consider a simple structure:

If you later decide not to run interest on costs, you can simply exclude or toggle the Costs column in DocketMath rather than rebuilding the dataset.

3. Rate and jurisdiction alignment

Once your raw data is stable, confirm that your spreadsheet is “New York‑aware.”

You don’t need to encode New York’s entire interest regime in the sheet—that’s what a tool like DocketMath’s interest calculator is for. But the sheet should make it obvious which rules apply where.

Core checks:

• The jurisdiction (New York / US‑NY) is clearly noted on the sheet.
• Judgment date (if any) is clearly marked and unique.
• Any contractual interest rate is clearly labeled and dated.
• You know whether the matter is pre‑judgment, post‑judgment, or a mix.

How it affects outputs:

• Switching rates mid‑timeline
  In New York, the applicable rate can change when:

  • You move from pre‑judgment to post‑judgment interest.
  • A contract rate applies before judgment and statutory rate after.
• Mis‑tagged judgment date
  If the judgment date is off, DocketMath will apply the wrong rate for part of the timeline. A one‑day shift may not matter; a one‑year shift often does.

4. Totals, rounding, and sanity checks

Finally, confirm that the totals your spreadsheet shows line up with what you’d expect to see once interest is applied.

Core checks:

• Sum of advances minus payments equals your expected principal balance.
• Any “running balance” column actually reconciles to the totals.
• Rounding is consistent (e.g., two decimal places for currency).
• No hidden rows or filters exclude relevant transactions.

How it affects outputs:

• Mismatch between “book” balance and interest input
  If your spreadsheet thinks the principal is $9,847.32 but your matter management system says $10,000.00, DocketMath will faithfully compute interest on the number you feed it—even if that number is wrong.
• Rounding drift
  Small rounding differences per row can add up over a multi‑year timeline. Decide in advance:

  • Whether you’re rounding each line item or only at the end.
  • Whether you’re rounding to cents or leaving more precision internally.

Quick balancing test:

1. Filter or select all principal advances and sum them.
2. Filter or select all principal payments and sum them.
3. Compute: Total advances – Total payments.
   That should match the principal balance you plan to feed into DocketMath. If it doesn’t, resolve the gap before you run interest.

When to run it

You don’t need a full forensic audit for every file. But there are a few moments in a New York matter when running this checker is especially valuable.

Run the checker before importing a spreadsheet into the Interest workflow. It is especially helpful when you have multiple entries or when a teammate provided the inputs.

1. Before your first New York interest run

If this is the first time you’re calculating interest in a case:

• Confirm the start date for interest (e.g., breach date, demand date, or other legally relevant trigger).
• Confirm whether you’re in a pre‑judgment or post‑judgment posture.
• Make sure all transactions up to that date are in the sheet and structurally sound.

This gives you a clean baseline for your initial DocketMath run.

2. After major events (judgment, settlement talks, appeal)

Run the checker again when:

• A judgment is entered and you now need to:

  • Stop pre‑judgment interest at the judgment date, and
  • Start post‑judgment interest after that date.
• You’re entering settlement negotiations and need a defensible payoff number.
• An appeal or motion raises questions about how interest was computed.

At these points, even small spreadsheet errors can have outsized strategic impact.

3. Before sharing numbers externally

Any time you are about to send interest numbers to:

• Opposing counsel
• The court
• A client
• An expert

…run the checker. It’s much easier to correct a spreadsheet in‑house than to walk back a number you’ve already put on the record.

Try the checker

You can use the checklist above manually, or you can build it into a repeatable workflow alongside DocketMath.

A simple pattern that works well:

1. Prepare your sheet

   • Clean dates, amounts, and labels as described above.
   • Clearly mark:

     • Jurisdiction: New York (US‑NY)
     • Interest start date(s)
     • Judgment date (if applicable)
2. Spot‑check with simple scenarios

   • Pick:

     • One clean principal amount
     • A short date range
   • Use DocketMath’s interest calculator to compute interest for just that subset.
   • Confirm your spreadsheet plus DocketMath give a result that “feels right” (e.g., order of magnitude, directionally consistent).
3. Run the full calculation

   • Once the subset behaves as expected, scale up:

     • Include all transactions
     • Set your as‑of date
     • Specify New York as the jurisdiction
4. Document what you did

   • Note in the workbook:

     • Which version of the data you used
     • The DocketMath settings (jurisdiction, date range, rate options)
     • Any assumptions (e.g., which categories did or did not accrue interest)

Related reading

• Worked example: deadlines in New York

• Interest rule lens: Maine

• Spreadsheet checks before running deadlines in California

• Why we started the DocketMath blog