MSME Supplier Ageing + Section 43B(h) Excel – FY 2025-26
The complete MSME payables working file: supplier master with automatic 43B(h) applicability, invoice register with section 15 due dates and ageing, a compound-interest ledger that applies the RBI bank rate actually in force each month (16.50% currently – not the stale 19.5% most templates use), ready Clause 22 figures for Form 3CD, and an MCA MSME-1 extract.
⬇️ Download Excel – FreeNo signup. No email required. Direct download.
What you get
43B(h) decided automatically
Enter the Udyam number, activity and category of each supplier – the file works out who is covered (micro/small, non-trader) and flags every invoice accordingly.
Section 15 due dates
Deemed acceptance, objection dates, written agreements capped at 45 days, the 15-day default – due dates compute themselves.
Correct interest engine
Month-by-month compound ledger at 3x the RBI bank rate in force in each month, with the full dated rate table built in – five rate changes since 2023 handled.
Clause 22 ready
The exact three-part Form 3CD clause 22 figures – total payable u/s 15, paid within limit, and the 43B(h) disallowance – plus the s.23 interest number.
MSME-1 extract
Supplier-wise dues beyond 45 days for the MCA half-yearly return, with the filing windows noted.
Ageing buckets
Not overdue / 1-30 / 31-90 / 91-180 / 180+ days as on any date you set – year-end or today.
Sheet-by-sheet overview
Workbook contents (6 sheets)
- Supplier Master – 15 suppliers with Udyam details, activity and category dropdowns – 43B(h) applicability computes automatically
- Invoice Register – 40 invoices with part payments; due date, outstanding, days overdue, ageing bucket, paid-within-limit split and 43B(h) status all auto
- Interest Ledger – month-end compound balances per invoice at the correct 3x rate for each month; total section 16 interest per invoice
- Clause 22 Summary – Form 3CD clause 22(i)/(ii)/(iii) figures + the section 22 MSMED disclosure amounts – all auto
- MSME Form 1 Extract – supplier-wise dues beyond 45 days for the MCA half-yearly return
- Bank Rate Table – the dated RBI bank-rate history the ledger reads – update after each RBI policy review
How to use
1. List your micro/small suppliers on the Supplier Master with details from their Udyam certificates. 2. Enter invoices and any part payments on the Invoice Register, and set the as-on date (31 March for year-end workings, today for a live ageing). 3. Everything else computes – due dates, ageing, the interest ledger, clause 22 figures and the MSME-1 extract. 4. At audit time, paste the Clause 22 Summary numbers straight into the Form 3CD utility – they pair with the annexure in our Form 3CD checklist workbook.
For a court-ready, day-level interest computation on a specific claim (MSEFC / Samadhaan), use the online MSME interest calculator (see also the clause 22 reporting guide) – it produces a month-by-month ledger you can annex.
Frequently asked questions
Which suppliers does section 43B(h) cover?
Micro and small enterprises registered on Udyam – medium enterprises are outside it, and per the MSME Ministry office memorandum, suppliers registered only as traders are generally outside too. The Supplier Master applies these tests automatically from what you enter.
What interest rate does the ledger use?
Three times the RBI bank rate in force in each month, compounded monthly – currently 16.50% (bank rate 5.50% from 5 December 2025). The dated rate table is a sheet in the workbook; most templates still hardcode 19.5% or 20.25%, which ended in early 2025.
Does paying before the ITR due date save the deduction?
No – unlike the rest of section 43B, clause (h) has no return-due-date relief. Amounts not paid within the section 15 limit (15 days, or up to 45 by written agreement) are deductible only in the year of actual payment.
Is the section 16 interest deductible for the buyer?
Never – section 23 of the MSMED Act disallows it permanently. The Clause 22 Summary reports it separately for that reason.
Are the sheets locked?
Sheets are protected only to keep the formulas safe. Every yellow input cell – suppliers, invoices, payments, dates – is open.
Will the file be updated when the RBI changes rates?
Yes – leave your email in the optional popup when you download, and every new version (rate changes, law changes) is mailed to you automatically.