Delayed payment interest calculator
SJ Sangath
Milestone-based balances, delayed interest and customer certificates are generated in one system.
THE BUSINESS
Built around a real operation.
A real-estate developer selling flats on milestone-based payment schedules, with delayed-payment calculations spread across Tally and Excel.
THE CHALLENGE
What needed to change
- Interest calculations were manual.
- Balances, delays and formulas required repeated verification.
- Preparing demand notices took hours and risked calculation errors.
THE SOLUTION
What we built
A dedicated calculator combines customer and flat details with milestone schedules to calculate outstanding amounts, delayed days, interest, GST and settlement totals. It produces a customer-ready interest certificate.
How it works
- Enter flat details
- Import milestones
- Calculate outstanding
- Compute delayed interest
- Generate certificate
AFTER THE SYSTEM
What changed for the team
- Statements take minutes instead of an afternoon.
- A configured formula is applied consistently.
- Customers receive a clear, professional calculation certificate.
INSIDE THE IMPLEMENTATION
The working system.
Actual screenshots from the project. Select an image to view it at full size.


