# MSME Vendor Payment Due Date Tracker (45 Day Rule)

> Source: https://netray.co/tools/msme-vendor-payment-due-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record micro and small supplier invoices with agreed days and days outstanding to see overdue amounts before year end.

## Category

regional

## Region

India

## Audience

- Accountant
- Finance controller
- Purchase manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Udyam category

**Key:** udyam

**Type:** select

**Options:**

- Micro
- Small
- Medium
- Not registered

#### Invoice no

**Key:** invoice

**Type:** text

#### Acceptance date

**Key:** accept_date

**Type:** date

#### Invoice amount

**Key:** amount

**Type:** number

**Format:** currency

#### Agreed credit days

**Key:** agreed

**Type:** number

**Unit:** days

**Help:** Maximum 45 for micro and small

#### Days since acceptance

**Key:** elapsed

**Type:** number

**Unit:** days

#### Days beyond limit

**Key:** days_over

**Type:** number

**Expr:** max(0, elapsed - min(agreed, 45))

#### Overdue amount

**Key:** overdue_amt

**Type:** number

**Expr:** if(gt(days_over, 0), amount, 0)

**Format:** currency

**Rows:**

**Vendor:** Sri Lakshmi Castings

**Udyam:** Small

**Invoice:** SLC/412

**Accept date:** 2026-08-20

**Amount:** 630000

**Agreed:** 45

**Elapsed:** 60

**Vendor:** Pooja Packaging

**Udyam:** Micro

**Invoice:** PP/118

**Accept date:** 2026-09-25

**Amount:** 84000

**Agreed:** 30

**Elapsed:** 24

**Vendor:** Vijay Tool Crib

**Udyam:** Micro

**Invoice:** VT/77

**Accept date:** 2026-08-05

**Amount:** 152000

**Agreed:** 60

**Elapsed:** 75

**Vendor:** Orion Tubes

**Udyam:** Medium

**Invoice:** OT/903

**Accept date:** 2026-09-10

**Amount:** 410000

**Agreed:** 60

**Elapsed:** 39

**Totals:**

#### Total outstanding invoices

**Key:** amount

**Agg:** sum

**Format:** currency

#### Total overdue amount

**Key:** overdue_amt

**Agg:** sum

**Format:** currency

#### Longest delay (days)

**Key:** days_over

**Agg:** max

**Format:** integer

**Summary:**

#### Overdue share of outstanding

**Key:** overdue_share

**Expr:** if(gt(sum_amount,0), sum_overdue_amt / sum_amount * 100, 0)

**Format:** percent

**Notes:** The sheet caps the agreed period at 45 days for every row, so for a medium vendor treat the overdue column as informational only. In the sample, the Vijay Tool Crib row shows that an agreed 60 days is treated as 45. Not legal or tax advice.

## Content

**Intro:** Since the Section 43B(h) rule applies, payments to micro and small suppliers that cross the legal period can cost you a tax deduction. This tracker puts every micro and small vendor invoice next to its agreed credit days and shows what is already overdue.

**Sections:**

#### How to use the tracker

**Body:** List open payables to vendors with their Udyam category. Enter acceptance date, invoice amount, agreed credit days and days since acceptance. The sheet limits the usable period to 45 days and shows the days beyond limit and the overdue amount. Sort by the biggest overdue amount, plan payments, and export the file for your auditor. Update days since acceptance at each review date, such as month end or March 31.

**Bullets:**

- Collect Udyam certificates and record category on the vendor master
- Count from the day of acceptance or deemed acceptance
- Without a written agreement, the limit is 15 days

#### What the rules say

**Body:** Section 15 of the MSMED Act 2006 requires a buyer to pay a micro or small supplier by the agreed date, not beyond 45 days from acceptance, and within 15 days where nothing is agreed. Section 16 provides compound interest with monthly rests at three times the bank rate notified by the Reserve Bank of India on overdue amounts. Under Section 43B(h) of the Income-tax Act, amounts owed beyond those limits are deductible only in the year actually paid. Buyers also report outstanding dues in the half-yearly MSME Form 1.

#### Common mistakes

**Body:** Teams count from invoice date rather than acceptance date, treat medium vendors as covered, or forget that a written agreement for more than 45 days is not honoured for this purpose. Another error is missing vendors whose Udyam status changed during the year. Reconcile the tracker with vendor ageing in your accounting package and review it a month before the financial year closes, when there is still time to pay.

**Cta:** If vendor categories and due dates live outside your ERP, we can explore putting the MSME flag and due date on every payable automatically.

**Faq:**

#### Does this apply to medium suppliers?

**Answer:** No. The 45 day rule and Section 43B(h) apply to micro and small enterprises registered under the MSMED Act, not to medium ones. Keep the category column accurate and ignore medium rows for compliance.

#### What is the deemed acceptance date?

**Answer:** If the buyer neither accepts nor objects in writing within 15 days of delivery, the goods are treated as accepted on the day of delivery. Confirm the exact wording in the Act with your adviser.

#### How is interest calculated?

**Answer:** Section 16 provides compound interest with monthly rests at three times the bank rate notified by the RBI. This worksheet does not compute it, so use it to identify the amounts first.

#### Can I filter by vendor?

**Answer:** Use the Excel export and apply filters there. In the browser you can edit rows, add vendors and read the totals. Keep one master list and refresh the elapsed days at each review.

## Search terms

msme payment 45 days tracker, section 43b(h) msme payment sheet, msme vendor payment excel, msme overdue payment report, msme outstanding invoices format, msme form 1 half yearly return, msmed act payment due calculator, micro small enterprise payable ageing

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json