One connected Excel system for TDS, TCS, ESI & EPF reconciliation β built for how Indian tax audits work, including when your client is both deductor and deductee.
Client Name Β· PAN/TAN Β· FY 2024-25
| Month | Category | Books | Return | Diff | Status |
|---|---|---|---|---|---|
| Apr | Sales | 12.4L | 12.1L | 30K | π‘ Minor |
| May | Purchase | 8.2L | 8.2L | 0 | π’ OK |
| Jun | Output GST | 1.8L | 1.5L | 30K | π΄ Major |
| Jul | ITC | 95K | 95K | 0 | π’ OK |
TDS deducted vs deposited vs return-filed β reconciled manually across challans and utilities
PF & ESI due-date compliance tracked by hand with no automatic delay calculation
40(a)(ia) and 36(1)(va) exposure calculated separately β if at all
Deductor and deductee sides rarely covered in one connected workbook
Scattered difference tracking with no single disallowance risk number for Form 3CD
β οΈ Late deposits and missed TDS differences directly impact Form 3CD disallowance clauses β and your client's tax liability.
Six reconciliation schedules, disallowance summary, difference log, and audit notes β one connected system
Total disallowance risk from late PF/ESI deposits and short TDS β one live number.
Deductor and deductee schedules built in β rare in custom spreadsheets.
Delay in days calculated automatically against statutory deposit dates.
All six schedules consolidated β filterable, with hyperlinks to source rows.
Update Client Name and PAN/TAN β ready for the next engagement in minutes.
One-time βΉ299. Lifetime validity for every tax audit season.
Signing Tax Audit reports (Form 3CD) with structured statutory working papers.
Statutory payroll, TDS compliance, and audit support.
Managing TDS/TCS returns and pre-audit checks for multiple clients.
Pre-audit self-checks on TDS, PF, and ESI before the auditor arrives.
Enter Client Name, PAN/TAN, and financial year on the Dashboard
Reconcile deductor and deductee sides β Books vs Challan vs Returns
Work through 12-month schedules with automatic delay calculation
Check Total Disallowance Risk β 40(a)(ia) + 36(1)(va) exposure
Record differences, add audit notes β ready for partner sign-off
| Your Old Spreadsheet | β This Workbook | |
|---|---|---|
| Deductor + Deductee | Rarely both | Built in, both sides |
| PF/ESI due-date compliance | Manual | Automatic delay calc |
| 43B disallowance exposure | Separate calc | One live Dashboard number |
| Setup time per client | 1β2 hours | Under 2 minutes |
| Difference tracking | Scattered tabs | One consolidated log |
Replace scattered challans, utilities, and Excel tabs with one connected reconciliation system β delivered directly to your inbox.