GoM

HAM Delayed Interest Calculator

Hybrid Annuity Model — Government of Maharashtra  •  Day-wise interest with quarterly compounding
Clause 41.4: Interest for the period of delay = Bank Rate + 4%, accruing on a daily outstanding basis, compounded on quarterly rests. Grace period 30 days unless otherwise specified.

⚙️ Calculation Settings

📤 Bulk Upload (Excel / CSV)

Prepare invoice and payment data in the template and upload it to populate the calculator. Use one row per payment: put the invoice details (Ref, Date, Amount, Grace) on the first row of each invoice, then for further payments of the same invoice leave the invoice columns blank (or repeat the same Invoice Ref) and fill only Payment Date and Payment Amount. An invoice with no payment yet: fill invoice columns, leave payment columns blank.

Invoice RefInvoice DateInvoice AmountGrace DaysPayment DatePayment Amount
RA-0510-01-20251,50,00,0003015-05-202560,00,000
20-09-202560,00,000
RA-0601-03-202580,00,0003031-07-202580,00,000
RA-0715-02-202550,00,00030(unpaid)
Dates as DD-MM-YYYY (YYYY-MM-DD and DD/MM/YYYY also accepted). Amounts may include commas. Accepts .xlsx, .xls and .csv. Calculation settings (margin, day-count, rests) come from the page, not the file.

🧾 Invoices & Payments