ESI Due Date Compliance Analyzer for Tax Audit
Problem
During tax audit, reporting under Clause 20(b) requires auditors to verify whether employees’ ESI contributions were deposited within the statutory due date (15th of the succeeding month). Manual verification from numerous PDF challans is time-consuming and prone to error. This prompt automates extraction of payment information from ESI Challan Paid PDFs, compares them with statutory due dates, and identifies any delayed payments that may attract reporting or disallowance consequences.
Prompt Input
You are an expert in payroll compliance and tax audit under the Income-tax Act and ESIC Act. Analyse all the ESI Challan Paid PDFs uploaded and produce a challan-wise statutory timeliness report. Tasks to Perform For every challan PDF uploaded: Extract the following fields: Challan Period (Month–Year format, e.g., Apr-2024) Challan Submitted Date (date of payment) Amount Paid Derive statutory compliance details: Compute the ESI statutory due date as the 15th of the succeeding month Compare Submitted Date vs Due Date If the payment is delayed, classify it as late and mark the entire amount as “Amount Disallowed” If paid on or before the due date, mark Amount Disallowed = 0 Generate a structured result table with the following columns: | File Name | Challan Period | Due Date | Challan Submitted Date | Amount Paid | Amount Disallowed | Sort the records by Financial Year order (Apr–Mar). Provide statistical insights: Total Amount Paid Total Amount Disallowed due to late payments Number of late payments vs on-time payments
Prompt Output
Below is the challan-wise statutory timeliness report based on the three ESI challans uploaded. Assumptions Statutory due date for ESI: 15th of the succeeding month for each contribution period. If Challan Submitted Date > Due Date → entire amount treated as “Amount Disallowed”. If Challan Submitted Date ≤ Due Date → Amount Disallowed = 0. Challan-wise Timeliness Report (FY 2024–25) File Name Challan Period Due Date Challan Submitted Date Amount Paid (₹) Amount Disallowed (₹) ESIC - APR 2024.pdf Apr-2024 15-05-2024 08-05-2024 978.00 0.00 ESIC - MAY 2024.pdf May-2024 15-06-2024 13-06-2024 852.00 0.00 ESIC - JUNE 2024.pdf Jun-2024 15-07-2024 10-07-2024 864.00 0.00 Compliance Summary All three challans (Apr-2024, May-2024, Jun-2024) have been paid before the statutory due date for ESI (15th of the succeeding month). Accordingly, no amount is disallowed for tax audit purposes in respect of these three months under the ESI payment timeliness criteria.