Enter each loss item with its date, amount and any amount recovered, then set an interest rate and an interest-to date. The tool shows gross loss, loss after recoveries, simple interest on the unrecovered amount and a schedule you can adapt for your report.
Dates can be yyyy-mm-dd or dd/mm/yyyy. Recovered is the amount returned or recovered from insurance, the person or others, and can be left blank.
The rate and the date are your inputs. Whether interest, costs and which rate can be claimed depends on the contract, the law and the forum. Take legal advice before putting a figure in a claim. Interest here is simple, not compounded.
| Date | Description | Amount | Recovered | Net | Days | Interest | Check |
|---|---|---|---|---|---|---|---|
| 2024-04-10 | Fictitious vendor payment | 4,50,000 | 0 | 4,50,000 | 720 | 79,890 | OK |
| 2024-07-22 | Inflated reimbursement claims | 1,85,000 | 60,000 | 1,25,000 | 617 | 19,017 | OK |
| 2024-11-05 | Cash withdrawn without support | 3,20,000 | 0 | 3,20,000 | 511 | 40,320 | OK |
| 2025-02-18 | Stock diverted and sold | 6,10,000 | 2,50,000 | 3,60,000 | 406 | 36,039 | OK |
Interest on each item runs from its own date to the interest-to date on the unrecovered amount. Recoveries are treated as received on the item date. If recoveries came later, adjust the dates or split the line.
A loss figure is challenged on three fronts: whether every item belongs, whether recoveries have been credited, and how interest was worked out. Keeping each as its own column and stating the rate and the date used lets a reader reproduce your number.
Net loss for each item is the amount less the amount recovered. Items with a bad date, a missing amount or a recovery above the amount are flagged and left out of the totals.
Simple interest is net loss times your annual rate times the days from the item date to the interest-to date, divided by the days in the year you choose.
The summary adds the totals and any costs you enter. Nothing is compounded.
An item of ₹4,50,000 dated 10 April 2024 with nothing recovered, interest at 9% simple to 31 March 2026 on a 365-day year.
