MSME Interest Calculator

Calculate interest on delayed payments to MSME vendors, using monthly compounding and the RBI Bank Rate that applied in each period.

Your file stays in your browser tab. The tool reads and processes it there and does not upload it. The page loads the SheetJS library from cdnjs.cloudflare.com, so it needs an internet connection to open. How privacy works

How to use it

1. Upload a .xlsx, .xlsm, .xls or .csv file; choose the source sheet and the row where data starts.
2. Map the columns: Invoice No, Vendor Name, Invoice Amount, GRN Date, Payment Terms (days) and Payment Date. All are required.
3. Review the RBI Bank Rate table. Choose “Yes — edit rates” to add, change or remove rows. Each effective date must be unique.
4. Press Generate MSME Working, review the summary and table, then Download MSME Working Excel.

What the calculation does

• Due date = GRN date + payment terms. Payment terms longer than 45 days are treated as 45.
• MSME rate = RBI Bank Rate × 3 (for example, 6.50% → 19.50%).
• Interest runs for invoices paid after the due date. It is split into periods at each month-end and each rate change, and the interest of each period is added to the principal for the next (monthly compounding). It uses 365 days a year.
• Days are counted from the due date through the payment date, both included.

Rows that produce no output

• Rows with a missing or unreadable GRN date or payment date are skipped — so invoices that are still unpaid are not included.
• Invoices paid on or before the due date have no interest and do not appear.

Summary cards

Rows Processed, Delayed Invoices, Total Interest (₹) and Output Rows.