Live Notice Board

📢 Latest Tax Updates, Circulars & Batch Announcements

Free Accounting, MIS & Automation Hub

Download Ready-to-Use Excel, MIS & AI Templates

Practical worksheets, reconciliation datasets, monthly closing checklists, and safe AI prompt guides curated for Indian accountants, students, and business professionals.

🔒

Member Login Required for Free Downloads

📊 Excel / Power Query ⏳ Work in Progress

GSTR-2B vs. Purchase Register Recon Sheet

Automated Tally/ERP Purchase Register vs. GSTR-2B reconciliation template. (Currently in progress — register below and we will notify you once ready!)

🔔 Notify Me When Ready

📈 Excel & Power BI MIS ⏳ Work in Progress

Debtors & MSME 45-Day Ageing MIS Tracker

Track 0–30, 31–60, 61–90, and 90+ days overdue receivables & MSME Sec 43B(h) alerts. (Currently in progress — we will let you know once done!)

🔔 Notify Me When Ready

📕 Watermarked PDF Guide

Safe AI Prompts for Accountants & Tax Notices

Official watermarked PDF containing Data-Masked AI prompts for Power Query M-code, Power BI DAX measures, and GST Section 73 / DRC-01A notice replies.

🔒 Login to Download PDF (.pdf)

✅ Month-End Checklist

Monthly Accounting & MIS Closing Checklist

A 13-step structured month-end closing checklist covering Bank Recon, GSTR-1/2B/3B, Form 26AS TDS matching, provisions, and Maker-Checker review.

🔒 Login to Download (.csv)

📅 Watermarked PDF Chart

Statutory GST, TDS & Income Tax Due-Date Calendar

Printable 1-page desk reference chart with monthly, quarterly & annual GST, TDS/TCS, Income Tax, PF/ESIC due dates & verified govt portal links.

🔒 Login to Download PDF (.pdf)

Indian Statutory Compliance Tracker

GST, TDS, Income Tax & Accounting Due-Date Calendar

Standard statutory due dates and direct links to official Government of India portals for accountants, tax practitioners, students, and business owners.

Statutory Due Date	Category	Return / Form / Compliance	Applicable To & Description	Governing Act / Authority
7th of Next Month	TDS / TCS	Challan ITNS 281	Monthly deposit of TDS / TCS deducted or collected during the previous month (For March: 30th April).	Income Tax Act (CBDT)
10th of Next Month	GST	GSTR-7 & GSTR-8	Monthly return for GST TDS deductors (GSTR-7) and E-Commerce Operators collecting TCS (GSTR-8).	CGST Act (CBIC)
11th of Next Month	GST	GSTR-1 (Monthly)	Statement of Outward Supplies for taxpayers with turnover > ₹5 Cr or opted out of QRMP scheme.	CGST Act (CBIC)
13th of Next Month	GST	IFF (QRMP) & GSTR-6	Invoice Furnishing Facility (IFF) for QRMP taxpayers (Month 1 & Month 2) and GSTR-6 for Input Service Distributors.	CGST Act (CBIC)
14th of Next Month	GST Recon	GSTR-2B Auto-Generation	Static monthly Input Tax Credit (ITC) statement generated for Purchase Register reconciliation.	CGST Act (CBIC)
15th of Next Month	PF & ESIC	EPF ECR & ESIC Challan	Monthly payment & return of Employee Provident Fund (EPF) and ESIC contributions for previous month payroll.	EPFO & ESIC
20th of Next Month	GST	GSTR-3B (Monthly)	Monthly summary GST return and payment of tax after reconciling Output Tax and eligible GSTR-2B ITC.	CGST Act (CBIC)
22nd / 24th (Quarterly)	GST QRMP	GSTR-3B (QRMP Scheme)	Quarterly GSTR-3B filing (22nd for Maharashtra & Category-1 States; 24th for Category-2 States).	CGST Act (CBIC)
25th of Next Month	GST QRMP	PMT-06 Tax Payment	Monthly tax payment for Month 1 & Month 2 of the quarter for taxpayers opted into the QRMP scheme.	CGST Act (CBIC)
Last Day of Month	Prof. Tax	PTRC Return (Maharashtra)	Monthly Professional Tax (PTRC) return & payment (if annual liability ≥ ₹1,00,000; otherwise 31st March).	State Profession Tax Act
15 Jun / 15 Sep / 15 Dec / 15 Mar	Income Tax	Advance Tax Instalments	Cumulative payment of Advance Tax: 15% (15 Jun), 45% (15 Sep), 75% (15 Dec), and 100% (15 Mar).	Income Tax Act (CBDT)
31 Jul / 31 Oct / 31 Jan / 31 May	TDS Returns	Form 24Q, 26Q & 27Q	Quarterly TDS statements for Q1 (31 Jul), Q2 (31 Oct), Q3 (31 Jan), and Q4 (31 May). (TCS Form 27EQ: 15th of Jul/Oct/Jan/May).	Income Tax Act (CBDT)
31st July (Annual)	Income Tax	ITR Filing (Non-Audit)	Annual Income Tax Return (ITR-1 to ITR-4) for Individuals, HUFs, and Firms not subject to Tax Audit.	Income Tax Act (CBDT)
30th Sep & 31st Oct (Annual)	Tax Audit	Tax Audit (3CD) & Audit ITR	30th September: Tax Audit Report (Form 3CA-3CD / 3CB-3CD u/s 44AB). 31st October: ITR for Audit Cases & Companies.	Income Tax Act (CBDT)
31st December (Annual)	GST Annual	GSTR-9 & GSTR-9C	Annual GST Return (GSTR-9) and Self-Certified Reconciliation Statement (GSTR-9C) for the preceding Financial Year.	CGST Act (CBIC)
Within 15 / 45 Days	MSME 43B(h)	MSME Supplier Payment Rule	Mandatory payment to Udyam-registered Micro & Small Enterprises within 15 days (no agreement) or max 45 days (written agreement) u/s 43B(h).	Income Tax Sec 43B(h) & MSMED Act

*Note: Statutory due dates are provided for educational reference only and are subject to official CBIC / CBDT circulars and extensions.

Articles & Practical Guides

Latest Insights on Accounting Automation, MIS & Power BI

Practical articles by Girish Shelar on simplifying monthly compliance, reporting, and spreadsheet workflows.

Excel & Power Query · By Girish Shelar

Why VLOOKUP Fails on Monthly GSTR-2B Reconciliations (And How Power Query Solves It in 1 Click)

Every month around the 14th, accountants and GST executives spend hours matching the Purchase Register exported from Tally Prime or Busy against the GSTR-2B Excel sheet downloaded from the GST portal. When you rely on manual VLOOKUP or XLOOKUP, two common problems break your sheet:

1. Invoice Number Formatting Differences: Your supplier uploads INV-2026-0045 on the portal, while your accounts assistant entered INV/2026/45 in Tally. VLOOKUP immediately returns #N/A even though the GSTIN and amount match.
2. Multi-rate Invoices: A single invoice with both 12% and 18% items appears as multiple rows in GSTR-2B, causing duplicate lookup errors.

💡 The Automation Fix: Using Excel Power Query, you can group invoices by Supplier GSTIN + Cleaned Invoice Number (automatically stripping slashes, hyphens, and leading zeros) and merge both tables in 3 seconds. Next month, you simply drop the new file into a folder and click Refresh All.

MIS Reporting & Power BI · By Girish Shelar

Building a 1-Page Executive MIS & MSME 45-Day Ageing Dashboard in Power BI

Business owners and CFOs rarely have time to read a 15-tab Excel workbook. When presenting monthly MIS (Management Information System) reports—or pitching your freelance accounting services to SME founders—clarity wins over complexity.

Especially after the introduction of Income Tax Section 43B(h) (which disallows deductions for payments to Micro and Small Enterprises delayed beyond 15/45 days), tracking creditor and debtor ageing buckets (0–30, 31–45, 46–90, and 90+ days) has become a boardroom priority.

💡 The MIS Upgrade: Connect your Tally/Excel sales and purchase registers directly to Power BI Desktop to create a visual 1-page Executive Dashboard showing Cash Flow, Gross Margin Trends, and an instant red-flag list of MSME invoices approaching the 45-day mark.

AI & Data Privacy · By Girish Shelar

How CAs, Tax Practitioners & Students Can Use AI Safely Without Exposing Client PAN/GSTIN

AI tools like ChatGPT and Claude can write complex Excel formulas, generate Power Query M-code, and draft structured replies to GST scrutiny notices in seconds. However, pasting real client names, PANs, GSTINs, or bank statements into public AI chats violates client confidentiality and India’s Digital Personal Data Protection (DPDP) Act principles.

💡 The Data-Masking Rule: Always describe the structure of your columns (e.g., “Column A has 15-digit GSTIN, Column B has Invoice Date, Column C has Taxable Value”) and use placeholders like [TAXPAYER_A] and [AMOUNT_X] when drafting tax notice replies. You get 100% of the AI productivity benefit with 0% client data risk.