Tally MSME Outstanding Bills Report: Complete Configuration Guide

With the introduction of strict tax disallowance rules under Section 43B(h) of the Income Tax Act, tracking outstanding payments due to registered Micro and Small Enterprises is critical. Finance teams must identify these transactions to avoid tax additions and statutory interest penalties.

TallyPrime includes dedicated MSME tracking and reporting features. By enabling MSME parameters and classifying your sundry creditors, you can generate compliance-ready outstanding reports with 15-day and 45-day aging breakdowns. This guide covers the complete setup, ledger mapping, and report generation workflow.

1. Step 1: Enabling MSME Features in TallyPrime

Before you can record MSME details for individual vendors, you must activate the global MSME configuration switch:

1. From the Gateway of Tally, press F11 (Features).
2. In the Features screen, scroll down to the Taxation section.
3. Set the option Enable MSME Details to Yes.
4. Press Ctrl + A to save and apply the settings. This activates the MSME data entry fields across all ledger alteration screens.

2. Step 2: Classifying Vendor Ledgers as MSME

With the feature activated, map the registration details for each of your Micro and Small suppliers:

1. Go to Gateway of Tally > Alter > Ledger and select your supplier ledger.
2. Ensure the ledger is grouped under Sundry Creditors.
3. Under the party details panel, locate the option Is MSME Registered? and set it to Yes.
4. In the MSME details sub-screen:
   • Select the Enterprise Type as Micro or Small.
   • Enter the vendor's 19-character Udyam Registration Number (e.g. UDYAM-KR-00-1234567).
   • Specify the Default Credit Period. Set this to 45 days (or 15 days if there is no written payment agreement).
5. Press Ctrl + A to save and exit the ledger master.

3. Step 3: Generating the MSME Outstanding Report

Once your ledgers are classified, TallyPrime compiles outstanding bills into a dedicated statutory report:

1. Go to Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Bills Payable.
2. To filter for MSME bills specifically, press F8 (MSME Bills) or select it from the right menu pane.
3. TallyPrime filters the payable list, showing only invoices due to registered Micro and Small suppliers.
4. The report displays:
   • The Invoice Date and Reference Number.
   • The Vendor Name and their Udyam Registration Number.
   • The Pending Amount and Due Date.
   • The Days Delayed column, calculated from the invoice date.

4. Configuring Aging Intervals (15 and 45 Days)

To comply with Section 43B(h) audits, you must age your payables into specific compliance categories:

1. From the MSME Bills Payable report, press Alt + B (Aging Method).
2. Select the aging method: Aging by Bill Date (recommended for tax audit checks).
3. Define the aging intervals in the table:
   • Interval 1: 0 to 15 Days (invoices within the default statutory window).
   • Interval 2: 15 to 45 Days (invoices within the maximum agreement limit).
   • Interval 3: 45 to 90 Days (flagged invoices subject to tax disallowance).
   • Interval 4: Above 90 Days.
4. Press Enter. TallyPrime reorganizes the report, placing each pending invoice under the correct aging column. Any balance appearing in the 45-90 or Above 90 columns is subject to tax add-backs if outstanding on March 31st.

5. Best Practices for Year-End Audits

To prepare a clean MSME outstanding bills report for your statutory auditor:

• Check for Missing Udyam Numbers: Run the Verify MSME Details utility. Go to Display > Statements of Accounts > Data Analysis > Verify MSME Details. This utility lists all creditors marked as MSME that are missing registration numbers or enterprise categories.
• Cross-Check with the MSME Portal: Verify Udyam registration certificates manually on the official government MSME portal before entering them in Tally.
• Clean Up Unadjusted Advances: Ensure all advance payments to MSME suppliers are adjusted against their respective purchase invoices. Unadjusted advances can result in incorrect aging calculations.

6. Setting Up Automatic Bill Allocations

To maintain accurate aging data, enable bill-wise details for all MSME ledgers. Navigate to the ledger configuration screen, select Maintain Bill-by-Bill Details, and set it to Yes. When recording purchase vouchers or payments, always adjust the amounts against the specific invoice reference (Against Ref) rather than using On Account allocations.

7. Audit Trail Compliance and Edit Logs for MSME

Under statutory corporate rules, any modifications to invoice credit periods or Udyam registration details must be recorded in your audit logs. If an operator alters a vendor's credit limit to bypass aging warnings, the change is tracked. Enforce strict security settings (via Alt+K > User Roles) to restrict permissions for modifying MSME ledger parameters to the chief accountant or database administrator.

8. Setting Credit Limits for MSME Vendors

Inside TallyPrime, you can set default credit terms to enforce the 15-day or 45-day limits automatically. Select the ledger alteration screen and specify the maximum credit period. Tally will warn operators during voucher entry if they attempt to pass purchases with terms exceeding the statutory caps.

9. Verifying the Ageing Method in Excel Exports

When exporting your MSME outstandings report to Excel, ensure you select 'Show Details' to audit specific invoice dates. This allows your tax auditor to trace calculations back to source vouchers, ensuring complete transparency during audit sign-offs.

10. Standard Audit Disclosures for MSME Liabilities

Under the MSMED Act rules, companies must disclose outstanding MSME interest liabilities and payment delays in their annual financial notes to accounts. Your statutory auditor will inspect the aging reports generated from TallyPrime to verify these disclosures. Having a clean, bill-by-bill report with Udyam numbers ensures that your company meets corporate and income tax audit standards without discrepancies. This includes providing the exact total balance due to Micro and Small enterprises as of the balance sheet date, along with the interest accrued and remaining unpaid. Ensuring these reconciliations are finalized monthly guarantees an audit-ready accounting database. It is recommended to run these reports on the last day of each calendar month.