Spreadsheet checks before running interest in United Kingdom

Running interest on a messy spreadsheet is a fast way to get bad numbers that still “look” precise. Before you plug anything into DocketMath’s interest calculator for the United Kingdom, it’s worth spending a few minutes sanity‑checking your sheet.

Run this scenario in DocketMath using the Interest calculator.

This guide walks through what our spreadsheet checker is designed to catch, when to use it, and how it affects the interest you ultimately calculate.

What the checker catches

DocketMath’s spreadsheet checker is built to answer one question:

“If I ran interest on this exact data for a UK matter, what could go wrong?”

Here’s what it focuses on.

• Date ordering problems (end date before start date).
• Rates entered as whole numbers instead of percentages.
• Missing caps or discounts in the spreadsheet.
• Inconsistent rounding or day-count conventions.

1. Date problems

Interest calculations in the UK are extremely sensitive to dates. A single mistyped date can shift interest by months or years.

The checker looks for:

• Invalid dates

  • Text like 32/01/2024, 2024-13-01, TBC, or —.
  • Cells formatted as text that “look like” dates but won’t be recognised (for example, 01-02-23 in a text column).
• Inconsistent date formats

  • Mixed DD/MM/YYYY, MM/DD/YYYY, and YYYY-MM-DD in the same column.
• Out-of-range dates

  • Dates far in the past or future (for example, 01/01/1900, 01/01/2100) that are unlikely for your case.
• Reversed dates

  • Entries like 03/07/2024 that could mean 3 July or 7 March.
  • The checker flags ambiguous patterns so you can confirm what you intended.

Why it matters for interest:

• Interest period length is calculated from your dates.
• A single row with a 10‑year shift can materially change total interest, especially at statutory or contractual rates.

2. Amount and currency issues

Even if your jurisdiction is set to United Kingdom, your spreadsheet might mix currencies or contain non‑numeric values.

The checker scans for:

• Non-numeric amounts

  • Cells containing TBA, ?, approx, or combined text and numbers like £10k.
• Inconsistent currency formatting

  • A mix of £1,000.00, 1,000.00, and 1000,00.
  • Amounts with trailing or leading text (GBP 1,000, 1,000 GBP).
• Suspicious magnitude

  • Values that are orders of magnitude out of line with the rest (for example, 100000000 in a column of 1,000–10,000).

How that changes your interest output:

• Excluded rows (because they’re non‑numeric) will silently reduce your principal if not caught.
• Mis-parsed amounts (for example, 1,000,00 becoming 100000) can inflate interest dramatically.

3. Missing or partial rows

The checker highlights:

• Rows missing either a date or amount
• Blank lines inside a data block (which often indicate a copy/paste gap)
• Duplicated rows (same date and amount appearing multiple times)

Impact on interest:

• Missing rows reduce total principal and understate interest.
• Duplicated rows double‑count principal and overstate interest.

4. Structure mismatches

DocketMath’s interest tools expect a consistent structure:

• One row per event (for example, invoice, payment, charge).
• Clear direction (for example, debit vs credit / principal vs payment).
• Dates and amounts in stable, labelled columns.

The checker flags:

• Multiple header rows
• Merged cells that break column alignment
• Columns with mixed content (dates and text in the same column, or amounts and notes together)

When to run it

You don’t need the checker for every spreadsheet. It’s most useful in a few recurring scenarios.

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 calculation on a matter

If you’ve just:

• Exported transactions from an accounts package
• Combined multiple schedules from different colleagues
• Inherited a historic spreadsheet from another team

run the checker once before doing anything else.

This catches structural problems early, so you don’t build arguments or reports on top of flawed numbers.

2. After heavy editing or reformatting

Run the checker again if you’ve:

• Inserted new columns for comments or status
• Split or combined rows (for example, grouping small invoices into one line)
• Applied filters, sorts, or manual clean‑up

These changes can easily:

• Break date formats
• Turn numbers into text
• Misalign columns

The checker will highlight anything that now fails basic validation.

3. When switching interest assumptions

Interest in UK matters often changes when you:

• Move from a simple “headline” rate to a precise statutory or contractual rate
• Change start/stop dates (for example, to reflect a judgment date or agreed cut‑off)
• Swap between simple and compound interest scenarios

While the checker doesn’t choose your assumptions, it keeps the input stable so that, when you change parameters in the interest calculator, you can be confident that any difference in output is due to your settings—not hidden spreadsheet issues.

4. Before sharing numbers externally

If you’re:

• Sending a schedule to the other side
• Including interest figures in a letter before action
• Preparing a draft schedule for counsel or the court

it’s worth a final pass.

A clean checker report doesn’t make the figures “right” in a legal sense, but it does reduce the risk of avoidable mechanical errors undermining your credibility.

Try the checker

Here’s a practical workflow using DocketMath for a UK interest calculation.

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

When rules change, rerun the calculation with updated inputs and store the revision in the matter record.

1. Prepare your spreadsheet

Aim for a simple, consistent layout:

• One sheet with:

  • Column A – Date (for example, 15/03/2021)
  • Column B – Amount (positive numbers)
  • Optional:

    • Column C – Type (invoice, payment, fee)
    • Column D – Notes

Quick pre‑flight checks (use these as mental checks or adapt them to your own checklist):

• All dates use a consistent format (for example, DD/MM/YYYY).
• Amounts are plain numbers your software recognises as numeric.
• No totals or subtotals are mixed into the transaction list.
• There are no blank lines inside the data block.

2. Upload and run the checker

From the DocketMath interest tool for the UK:

1. Go to /tools/interest.
2. Select the jurisdiction as United Kingdom (UK) if it isn’t pre‑selected.
3. Upload your spreadsheet.
4. Run the checker before you configure interest settings.

You’ll see:

• A summary (for example, “3 date issues, 2 amount issues”)
• A row‑by‑row breakdown of what needs attention
• Suggestions for how to clean each issue (for example, “Convert text to date”, “Remove non‑numeric characters”)

Fix the flagged cells in your original spreadsheet, then re‑upload until the checker is clean or the remaining warnings are fully understood.

3. Understand how fixes change your interest

Once your sheet passes basic checks, configure your UK interest calculation:

• Rate type

  • Statutory (for example, 8% under the Judgments Act for certain judgments)
  • Contractual (custom rate you enter)
  • Bank or base‑rate‑linked (where you specify the rate series)

• Interest method

  • Simple interest
  • Compound interest (with your chosen compounding frequency)

• Period

  • Start: usually an event date (for example, due date, breach date)
  • End: a cut‑off date (for example, today, issue date, judgment date)

As you adjust:

• Rates – interest scales roughly linearly with the rate (doubling the rate roughly doubles the interest, all else equal).
• Start date – moving the start earlier increases the number of days and therefore the interest.
• End date – extending the end date increases interest; shortening it decreases interest.
• Method (simple vs compound) – compound interest grows faster over long periods, especially at higher rates.

Because the checker has already stabilised your inputs, any change in output should now be traceable to these explicit choices, not hidden spreadsheet quirks.

If you want to see the exact day‑by‑day or period‑by‑period maths behind the final figure, you can pair this with DocketMath’s Explain++ breakdowns, which give a step‑by‑step explanation of each calculation. For more on that, see our breakdown feature or jump straight into the calculator at /tools/interest.

Related reading

• Introducing Explain++: step-by-step calculation breakdowns

• A practical workflow for jurisdiction-aware legal calculations (and how to document them)

• Why we started the DocketMath blog