Product
Litigation
- Early Case Assessment
- Evidence Analysis
- Web Search
- Document Review
- Production Setup
- Connectors (Upcoming)
- Legal Research (Upcoming)
Transactional
- Contract Review
- Contract Intelligence
- Word Add-In
- Web Search (Upcoming)
- Connectors (Upcoming)
- Legal Research (Upcoming)
Solutions
Litigation
- Early Case Assessment
- Investigations & Subpoenas
- Trial Preparation
- Enterprise eDiscovery
- Cloud eDiscovery
Transactional
Who it’s for
Resources
Learn
Customers
Events & CLE
Map each claimed amount to the operative contractual provision, transaction evidence, and a reproducible calculation through a fixed cutoff date. Separate principal, ordinary interest, default interest, premiums, expenses, and credits rather than accepting a demand as a single balance. The resulting loan claim calculation tracker should distinguish reconciled amounts, conditional calculations, and unsupported items. Counsel can then explain the difference between the asserted balance and the tested position without confusing accurate arithmetic with a legal entitlement to recover.
When to use this workflow
Use this workflow when preparing or testing a demand, complaint, settlement position, or damages submission. It serves lender counsel, borrower counsel, and in-house teams who need to connect a claimed loan balance to particular documents and account movements.
The scope is a US commercial loan dispute. Establish the governing law, forum, loan type, and intended use before evaluating recoverability. Federal procedural and evidence rules discussed below have their own applicability limits; do not substitute them for state or arbitral requirements. Consumer lending, bankruptcy, and foreclosure require separate analysis. This is an organizational workflow, not a determination of enforcement rights.
What you need
Collect materials that establish both calculation authority and account movements:
- Executed notes, credit agreements, schedules, amendments, waivers, forbearances, and relevant guarantees, assignments, security documents, and intercreditor agreements.
- Native ledgers, opening-balance support, draw records, remittances, bank confirmations, reversals, suspense records, and servicing-transfer reconciliations.
- Rate histories, reset records, interest worksheets, fee schedules, expense invoices, and premium calculations.
- Default and acceleration notices, delivery evidence, cure communications, collateral-sale records, and proceeds distributions.
- The demand or pleaded calculation being tested, its cutoff date, and earlier balance statements.
Preserve source versions and native formulas. Assign stable document IDs and ledger references. For a guarantor claim, include the provisions defining covered obligations, any cap, and the asserted basis for applying payments or recoveries against that exposure; do not simply copy the borrower’s total.
Use the template
The companion template is Loan Enforcement Disputes — Loan claim calculation tracker. You can copy this table into your working document or spreadsheet. Use one row per component and calculation period; split rows whenever the principal base, rate, operative clause, or trigger changes.
| ID / component | Claimed amount | Clause / version | Evidence pinpoint | Period / trigger | Formula / credits | Tested amount | Status / action / owner |
|---|---|---|---|---|---|---|---|
“Claimed amount” preserves the position being tested. “Tested amount” records your reconstruction, not necessarily a recoverable amount. Cite document IDs, sections, pages, ledger rows, and calculation cells rather than filenames alone.
Identify the clause version effective during each period. Retain formulas in a supporting sheet and reference their cells. Use statuses such as reconciled, conditional, or unsupported, with an owner and next action. Missing evidence is not a zero balance. Keep component subtotals and a bridge from demand to tested total beneath the table; exclude mutually exclusive alternatives from the same sum.
Step by step
1. Freeze the claim and calculation boundary
Identify the demand, pleading, or worksheet being tested. Record its version, claimant, obligor, facility, currency, and cutoff date. Preserve original component labels and explain reclassifications separately.
Distinguish a historical balance from continuing per-diem accrual. State whether the cutoff includes that day and how later receipts will be disclosed. Maintain separate schedules for different facilities and obligors before preparing a combined figure.
Template output: Enter claimed components unchanged, cite the source demand, and record the calculation boundary in the relevant period fields.
2. Identify the operative clauses and conditions
For each component, locate both payment authority and calculation terms. Interest inputs may include the rate definition, margin, floor, reset period, day-count basis, and payment dates. Premiums require their own triggering language. Read amendments and forbearances against their effective dates, distinguishing executed documents from drafts and comparisons.
Do not assume identical consequences for every nonpayment. As a contract-wording example, the SEC-filed Shift4 agreement distinguishes principal nonpayment when due from specified other nonpayment continuing for five Business Days. Its Annex I contains amendment markup; this is neither a universal cure period nor evidence of a market standard. See Annex I, §7.01(a). (sec.gov)
Template output: Cite operative provisions and list each condition requiring factual or legal confirmation, including any missing amendment or schedule.
3. Reconstruct principal and credits first
Start from a supported opening balance. Reconcile advances, repayments, reversals, capitalized items, and adjustments transaction by transaction. Compare lender postings with remittance evidence. Distinguish receipt, effective, and posting dates, and document why the calculation uses a particular date.
Trace suspense balances and servicing-transfer differences. Keep collateral recoveries separate from ordinary payments until you identify the applicable allocation provisions.
For example, Shift4’s §2.18(b) addresses specified collateral proceeds received while an Event of Default exists and loans have been accelerated, subject to applicable intercreditor agreements. It is not a general allocation rule for every receipt. See Annex I, §2.18(b). (sec.gov)
Template output: Record the opening-balance source, transaction bridge, credits, and unresolved allocations before using principal as an interest input.
4. Recalculate interest in discrete periods
Break accrual whenever principal, rate, or contractual treatment changes. Record the rate source, margin, day-count convention, included dates, rounding method, and formula. Do not infer compounding or capitalization from the ledger’s presentation.
Determine whether default interest replaces ordinary interest or adds an increment. Map its asserted start and end dates to contractual conditions and supporting events. Where a trigger is disputed, calculate labeled alternatives rather than resolving the issue through an unexplained spreadsheet input.
Independently recompute a sample period. Check formulas for omitted days, duplicate days, and incorrect references after rate resets or payments.
Template output: Enter period-specific formulas and identify disputed inputs. Mark alternative totals as alternatives, not additional charges.
5. Test premiums, fees, expenses, and duplication
Give each non-interest charge its own authority and evidence trail. Match expenses to invoices, service periods, descriptions, payment evidence where relevant, and reimbursement language. A posted charge is not a substitute for this analysis.
Check whether collection expenses were deducted from collateral proceeds and then added again to the demand. Compare late fees, default charges, and interest adjustments for overlapping treatment. For premiums, identify the asserted repayment event and calculation base; leave disputed contractual interpretation or legal limitations to counsel rather than treating a formula as dispositive.
Template output: Separate arithmetic support from disputed recoverability, with invoice or transaction pinpoints and a documented duplication check.
6. Establish the evidence path and assign gaps
Identify who can explain ledger creation, payment allocation, rate inputs, and servicing migrations. Preserve native records and describe transformations used to produce the calculation.
Under applicable federal evidence rules, Rule 901 concerns authentication. Rule 803(6) addresses business-record conditions, including trustworthiness; Rule 902(11) supplies a certification route with notice and inspection safeguards. Authentication alone does not resolve hearsay, and a lender’s business-record label does not establish admissibility. See Federal Rules of Evidence, Rules 901, 803(6), and 902(11). (uscourts.gov)
Turn gaps into targeted requests for records or explanations. In federal district-court litigation, discovery must concern nonprivileged information relevant to claims or defenses and proportional to the case; discoverability does not require admissibility. See Federal Rule of Civil Procedure 26(b)(1). (uscourts.gov)
Template output: Assign each gap to an owner and specify the missing record, witness explanation, or foundation work.
7. Reconcile the total and document the position
Bridge the demand to the tested amount by component. Explain credits, excluded periods, duplicates, and unsupported charges. Compare earlier notices without assuming their balances are correct.
Produce the tested calculation, conditional alternatives, and unresolved-items list. Have another reviewer reproduce material calculations from the cited sources. Preserve the reviewed version so later transactions do not silently change a historical claim.
For a proposed federal evidentiary summary, assess Rule 1006 separately: it addresses voluminous admissible materials that cannot conveniently be examined in court and requires access to underlying originals or duplicates. An internal tracker does not automatically qualify. See Federal Rule of Evidence 1006. (uscourts.gov)
Template output: Record the reconciliation and distinguish calculation review from outstanding legal and evidentiary decisions.
Worked example
Entirely fictional scenario: all parties, documents, clauses, and amounts below are invented. Alder Quay Finance demands a June 30 balance from Brookmere Fabrication. Agreement LA-01 provides for 8% simple ordinary interest, actual/365, plus an additional 2% during a qualifying default. Demand DM-01 claims $1,000,000 principal, $6,575.34 ordinary interest, and $1,643.84 incremental default interest for June 1–30.
Advance confirmation AC-01 and the reconciled ledger establish $1,000,000 principal before May 31. Borrower confirmation BR-04 and lender receipt LR-08 establish a $100,000 payment received May 31. Ledger LG-02 places it in suspense. Fictional §4.2 applies this payment to principal on receipt; the supplied record contains no competing allocation provision or later principal movement. Notice NT-03 asserts default interest from June 1, but evidence establishing the qualifying trigger is missing.
| ID / component | Claimed amount | Clause / version | Evidence pinpoint | Period / trigger | Formula / credits | Tested amount | Status / action / owner |
|---|---|---|---|---|---|---|---|
| P-01 Principal | $1,000,000 | LA-01 §4.2, executed | AC-01 p.1; BR-04 p.1; LR-08 p.2; LG-02 row 118 | Credit May 31 | $1,000,000 − $100,000 | $900,000 | Reconciled on supplied records; analyst: explain suspense posting, not an additional credit |
| I-01 Ordinary interest | $6,575.34 | LA-01 §3.1, executed | LG-02 row 130; CALC-01 B12 | June 1–30; 30 days | $900,000 × 8% × 30/365 | $5,917.81 | Recomputed; reviewer: confirm receipt-date treatment and formula; reduced base explains adjustment |
| D-01 Default increment | $1,643.84 | LA-01 §3.4, executed | NT-03 p.1; CALC-01 B18 | June 1 asserted; trigger missing | $900,000 × 2% × 30/365 | $1,479.45 conditional | Conditional; counsel: obtain trigger evidence; notice alone leaves start date unproven |
The demand totals $1,008,219.18. After the principal credit and related interest adjustments, the tested total is $907,397.26 if all 30 days of default interest are supported. Principal plus ordinary interest is $905,917.81, before the unresolved increment. Components are rounded to cents before summing.
The tracker identifies a supported $100,000 principal correction and $821.92 in associated interest-base adjustments. It does not establish that the remaining default increment is recoverable. Counsel can negotiate from the corrected base while requesting trigger evidence, rather than conceding the whole demand or treating every disputed dollar as unsupported principal.
Common mistakes
- Using the latest agreement throughout. Map effective dates and split accrual periods affected by amendments.
- Treating the demand total as principal. Separate accrued interest, fees, and expenses before rebuilding the base.
- Ignoring suspense or reversals. Trace both sides of movements and distinguish receipt from posting.
- Adding a full default rate to ordinary interest. Determine whether the clause replaces the rate or adds an increment.
- Netting collateral proceeds without explanation. Show gross receipts, deductions, allocation authority, and credits.
- Calling an unsupported item disallowed. Distinguish missing proof from a legal conclusion and assign the next action.
Final quality check
- Every component has an operative clause citation or explicit authority gap.
- Document IDs, pages, ledger rows, and calculation cells resolve to preserved sources.
- Principal reconciles through the cutoff, including suspense, reversals, and recoveries.
- Rates, dates, day counts, rounding, and formula ranges are verified.
- Premiums, fees, and expenses have separate support and duplication checks.
- Conditional alternatives cannot enter the main total accidentally.
- Another reviewer has reproduced material calculations; open issues are resolved or assigned.
- Intended evidentiary use and forum requirements have been assessed separately from arithmetic.
Complete the workflow with DecoverAI
DecoverAI is the Legal Intelligence Platform for litigation and transactions. Document review, evidence analysis, and chronology work can support review of loan terms, notices, payments, and disputed trigger dates. Tabular review supports work across multiple documents; the tracker and calculations remain counsel’s work products. To discuss this loan-claim evidence workflow, book a demo. Counsel retains responsibility for verification, calculations, and legal judgment.
Frequently asked questions
Should the tracker start with the ledger or demand?
Start with the demand to preserve the position being tested. Reconstruct it from documents and transactions; a ledger-only review may miss added charges or a different cutoff.
What if default interest depends on disputed acceleration?
Read the actual trigger first. Calculate labeled date alternatives and assign the trigger question to counsel. Do not assume every default-interest clause depends on acceleration.
Can invoices alone support the expense claim?
Use invoices as factual support, then map each charge to reimbursement language and identify legal limitations requiring review. Distinguish invoiced, posted, paid, and claimed amounts.
Can the completed tracker be submitted as evidence?
Not automatically. Assess the applicable evidentiary route, source materials, foundation, and procedural requirements, including Rule 1006 where relevant. Keep internal analysis distinct from a proposed evidentiary summary.
Sources
- Federal Rules of Civil Procedure, Rule 26(b)(1).
- Federal Rules of Evidence, Rules 803(6), 901, 902(11), and 1006.
- Shift4 Payments, LLC, Amendment No. 4, Annex I, §§2.18(b) and 7.01(a); amendment markup and contract-wording examples only.
This guide is general information about legal workflows, not legal advice for any matter. It was drafted and reviewed with AI assistance. The worked example is fictional. Contract rights and procedure depend on the governing law, the actual wording, and the facts, so check the cited sources and the rules that apply in your jurisdiction before relying on it.
