Home › TDS Working File
TDS Working File · for Businesses & CAs

Run your monthly TDS without the Excel mess.

One place to record every deduction, reconcile challans and generate filing-ready 24Q, 26Q and 27Q statements — plus Form 16 and 16A — with section, rate and TDS computed for you. The working file your firm keeps in Excel, finally productised.

30-day free trial No card required Built for 24Q · 26Q · 27Q + Form 16/16A
app.tdsguru.in/dashboard
Demo Traders Pvt Ltd
TAN HYDD12345E · FY 26-27
Working file
Dashboard
Setup
👥Vendor Master
TDS Register
🧾Challan Master
Reports
📑Reports

Dashboard

FY 2026-27 · Q1 status across 24Q, 26Q & 27Q

TDS deducted
₹2,44,880
Deposited
₹2,42,880
Unmapped
₹2,000
Form 16/16A
9
StatementNatureDeducteesTDSStatus
24QSalary (192)31,45,000In progress
26QNon-salary519,880Ready
27QNRI / 195180,000In progress
!
1 deduction not mapped to a challan — Metro Steel Co (194Q, ₹2,000). Q1 statements due 31 Jul 2026.
Sound familiar?

Everything the Excel sheet makes painful — fixed

The monthly TDS grind is full of small jobs that go wrong. The working file handles each one, so nothing is missed and nothing is calculated by hand.

×Missed or late TDS payments
No more missed payments. The dashboard flags exactly what's deducted, deposited and still due — before the 7th.
×Hunting for a vendor's PAN every time
No more PAN searches. Saved once in the vendor master with its default section, rate and code.
×Compiling quarterly data for the return
No more manual compiling. Each quarter is built for you in the correct 24Q, 26Q or 27Q layout, validated and ready for the FVU.
×Guessing which payment covers which deductee
Payments matched to deductees. Every challan is mapped to the exact entries it covers.
×Issuing Form 16 & 16A by hand
Certificates in a click. Form 16 for salary and Form 16A for non-salary & NRI, generated in bulk from TRACES data.
×Working out interest & penalty by hand
Interest & penalty auto-calculated. Section 201(1A) interest on late deduction or payment, computed for you.
Why it's different

It owns the layer where the real work happens

Return-filing software files what you've already organised. Accounting software needs the client to run it. The working file — the monthly layer in between — has only ever been a fragile Excel sheet. This app productises exactly that layer.

👥

Deductee & employee master

Add a payee once with PAN and default section. The register then auto-fills section, rate and payment code every time — for vendors (26Q), employees (24Q) and non-residents (27Q).

Auto TDS register

Enter an invoice or pay run, pick the payee — section, rate and TDS are computed instantly: salary slabs (192), the 194Q ₹50L threshold, no-PAN higher rate, and 195 NRI rates with surcharge & cess.

🧾

Challan reconciliation

Every challan tracks how much is utilised and what's still to map. Unmapped deductions are flagged and each challan ties back to OLTAS / 26AS, so nothing slips through before filing.

📑

24Q · 26Q · 27Q statements

Each quarter is built in the correct structure and validated through the NSDL FVU, with the Form 27A control sheet — salary, non-salary and non-resident, all from one file.

📄

Form 16 & 16A

Import Part A from TRACES, merge Part B for salary, and generate Form 16 and 16A as password-protected PDFs — in bulk, ready to issue to every deductee.

🏢

CA multi-company console

Consultants switch between every client from one login; each company sees only its own data, with role-based access and a clean audit trail. Built for a practice, not just a single business.

The TDS register

Type the invoice. The TDS is already done.

Pick a payee and enter the amount — section, rate, payment code and TDS appear instantly, across salary (24Q), non-salary (26Q) and non-resident (27Q) payments. The tricky rules are handled for you, so juniors can do the entry and seniors just review.

  • 194Q charged only on value above the ₹50 lakh threshold
  • Salary slabs (192) and 195 NRI rates with surcharge & cess, built in
  • Higher rate auto-applied when PAN is missing or inoperative
  • Each row maps to a challan, so reconciliation is built in
app.tdsguru.in/register

TDS Register — 26Q (non-salary)

Demo Traders Pvt Ltd · FY 2026-27 · 24Q salary & 27Q NRI have their own registers

DateInvoiceVendorSecRateAmountTDSChallan
12 AprINV-101Sharma Contractors194C1%48,000480CH-1
20 AprAS-77Ace Software LLP194J2%1,20,0002,400CH-1
05 MayRA-12Rao & Associates194J10%60,0006,000CH-2
18 MayGE-09Galaxy Estates194I10%90,0009,000CH-2
02 JunMS-440Metro Steel Co194Q0.1%70,00,0002,000Unmapped

194Q TDS on ₹20,00,000 (above the ₹50,00,000 threshold) · 5 entries

Monthly payment summary

Pay the whole month in one go — interest included

At month-end you get a section-wise total of exactly what to deposit, so a single challan can clear the month. Miss the 7th? Interest under section 201(1A) is computed automatically — no manual penalty maths.

  • Section-wise payable, ready to deposit by the due date
  • Interest u/s 201(1A) auto-calculated when a payment runs late
  • One figure to pay, fully reconciled back to each entry
app.tdsguru.in/summary

Monthly Payment Summary

May 2026 · deposit due 07 Jun 2026

SectionNatureDeducteesTDS payable
194JProfessional fees16,000
194IRent — land/building19,000
Total to deposit₹15,000
Interest u/s 201(1A): on time → ₹0. If paid in Jul (1 month late) → +₹225 @ 1.5%/month.
Reports that match the work

Filing-ready output, not raw data dumps

The reports follow the actual TDS cycle — pay this month, file this quarter, close the year. The quarterly statement already lists challans against the deductees mapped to them, validated through the NSDL FVU with the Form 27A control sheet — for 24Q, 26Q and 27Q alike.

  • Month-end: section-wise payment report to deposit on time
  • Quarter-end: challans + mapped deductees, ready for the return
  • Year-end: party-wise & nature-wise summaries for audit
app.tdsguru.in/reports

Q1 Filing Report — 26Q

Apr–Jun 2026 · FVU + Form 27A ready

ChallanBSRDateAmountUtilisedBalance
CH-1051030807 May 263,3602,880480
CH-2051030807 Jun 2615,00015,0000
DeducteePANSecTDSChallan
Sharma ContractorsAAAPS1234C194C480CH-1
Ace Software LLPAABCA9876F194J2,400CH-1
Rao & AssociatesAAFPR2345K194J6,000CH-2
Galaxy EstatesAAACG7654L194I9,000CH-2
Form 16 & 16A

Issue every certificate without leaving the file

Import Part A from TRACES, and the file generates Form 16 for salaried employees and Form 16A for non-salary and non-resident deductees — in bulk, as password-protected PDFs, ready to send.

  • Form 16 (Part A + Part B) for salary; Form 16A for 26Q & 27Q
  • TRACES request and download mapped to each deductee
  • Bulk PDF generation — one click for the whole quarter
app.tdsguru.in/forms

Form 16A & Form 16

Demo Traders Pvt Ltd · from TRACES · bulk generate

FormRecipientPANTDSPeriodStatus
16ASharma ContractorsAAAPS1234C480Q1Generated
16ARao & AssociatesAAFPR2345K6,000Q1Generated
16AGalaxy EstatesAAACG7654L9,000Q1Generated
16Ramesh Kumar (Salary)ABCPK1234F48,000FY 25-26Generated
16AOrion Global Pte (NRI)AAJCO1122Q80,000Q1Pending

Password-protected PDFs · Part A + Part B merged for Form 16 · one click for the quarter

Deductee & payee master & CA console

Set a payee up once. Reuse it all year.

Each deductee — vendor, employee or non-resident — carries its PAN and default section, so every entry inherits the right rate and payment code automatically. For consultants, the same login switches across every client company — one workflow for the whole practice.

  • PAN + default section stored per payee (192 / 194 / 195)
  • Rate and payment code pulled in automatically
  • CA edition: many companies, one console, isolated data
app.tdsguru.in/vendors

Payee (Deductee) Master

Demo Traders Pvt Ltd · 7 payees · vendors, employees & non-residents

PayeePANDefault sectionRateCode
Ramesh Kumar (Salary)ABCPK1234F192 Salary — employeeSlab92B
Sharma ContractorsAAAPS1234C194C Contractor (Ind/HUF)1%94C
Ace Software LLPAABCA9876F194J Technical / Software2%94J
Rao & AssociatesAAFPR2345K194J Professional fees10%94J
Galaxy EstatesAAACG7654L194I Rent — land/building10%94I
Metro Steel CoAAACM3456P194Q Purchase of goods0.1%94Q
Orion Global Pte (NRI)AAJCO1122Q195 Non-resident — fees20%+195
Year-end audit reports

Close the year — party-wise and expense-wise

When the audit comes, the whole year is already reconciled. Pull a party-wise summary of TDS by deductee and a nature-wise summary by expense head, both tying back to the same register — no last-minute Excel scramble.

  • Party-wise: total TDS deducted against each deductee
  • Expense / nature-wise: TDS grouped by section and head
  • Both reconcile to the year's deducted total
app.tdsguru.in/reports/annual

Annual Summary — FY 2026-27

Demo Traders Pvt Ltd · for audit

Party-wise

DeducteeTDS
Sharma Contractors480
Ace Software LLP2,400
Rao & Associates6,000
Galaxy Estates9,000
Metro Steel Co2,000
Total19,880

Expense / nature-wise

SectionHeadTDS
194CContractor480
194JProfessional8,400
194IRent9,000
194QGoods2,000
Total19,880
How it works

From invoice to filed return in four steps

Add your vendors

Enter each deductee once with PAN and default section.

Record deductions

Log each invoice; section, rate and TDS compute automatically.

Map challans

Deposit and reconcile — unmapped amounts are flagged.

File & issue

FVU-ready 24Q / 26Q / 27Q statements, plus Form 16 & 16A for every deductee.

Replace the TDS Excel sheet for good

Start free, add your first company, and run a clean monthly TDS cycle today. Covers 24Q salary, 26Q non-salary and 27Q non-resident statements — with Form 16 and 16A generation built in.

30-day free trial Business & CA editions Or email info@tdsguru.in