Tax and compliance

TDS Deduction ফরম্যাট

TDS Deduction Format

TDS Deduction ফরম্যাট - Tax and compliance কাজের জন্য তৈরি Excel format. Sample rows, পরিষ্কার columns এবং no-login XLSX download আছে.

ফ্রি XLSX ডাউনলোডFormats দেখুন

Login দরকার নেই. XLSX download-এ WorkbookWise About sheet আছে.

Workbook preview

TDS Deduction ফরম্যাট

11 কলাম in the XLSX download.

ফ্রি XLSX
Deductee NamePANTDS SectionNature of PaymentTaxable AmountTDS RateTDS Amount
Aarav ConsultingABCDE1234F194JProfessional fees5000010%5000
Metro ContractorsPQRSX5678K194CContract payment1200001%1200
City RentalsLMNOP4321Q194IRent8000010%8000
Screenshot-style preview of sample rows. 4 more columns are listed below.

কার জন্য

  • accountants and Indian SMB finance teams preparing deductee details, section, taxable amount, TDS and challan review
  • Teams that want a no-login Excel starting point before a paid workflow
  • Owners who need clean rows that can later move into WorkbookWise apps, forms or documents

ভারত সম্পর্কিত নোট

  • Check the correct TDS section and threshold before deduction.
  • PAN availability can affect TDS treatment and reporting.
  • Keep challan and deposit references separate from invoice remarks.

Workbook কলাম

A clean structure before formulas or workflow.

These fields are visible in the free download and in the page HTML so users, Google and answer engines can inspect what the format contains.

Deductee NameAarav Consulting
PANABCDE1234F
TDS Section194J
Nature of PaymentProfessional fees
Taxable Amount50000
TDS Rate10%
TDS Amount5000
Deduction Date05/10/2026
Deposit Date07/11/2026
Challan RefCH-1024
StatusTo deposit

Ready to use this workbook structure?

Download the XLSX now, then return to the notes below only if you need review guidance.

ফ্রি XLSX ডাউনলোড

What the TDS deduction format in Excel is for

This format is a TDS working register. It keeps deductee identity, PAN, section, taxable amount, TDS rate, deducted amount and challan details visible for review before return preparation or accountant handoff. The page is meant for users who search for a usable format, not a generic article. That is why the preview, columns, sample rows and download button are visible before the longer guidance. The downloaded workbook is intentionally simple: it gives a clean structure that can be opened, inspected and adapted in Excel before moving into custom generation, forms, apps or document output.

  • accountants and Indian SMB finance teams preparing deductee details, section, taxable amount, TDS and challan review
  • Teams that want a no-login Excel starting point before a paid workflow
  • Owners who need clean rows that can later move into WorkbookWise apps, forms or documents

Columns included in the free workbook

The free XLSX includes these practical columns: Deductee Name, PAN, TDS Section, Nature of Payment, Taxable Amount, TDS Rate, TDS Amount, Deduction Date, Deposit Date, Challan Ref, Status. The columns are separated so users can filter, sort, add formulas and review the workbook with an accountant, owner or operations lead. Avoid putting multiple business facts into one notes column; clear columns make the file easier to import into WorkbookWise later if the team wants Use My Data, Apps, Forms or Rows to Documents.

  • Deductee Name: example value Aarav Consulting
  • PAN: example value ABCDE1234F
  • TDS Section: example value 194J
  • Nature of Payment: example value Professional fees
  • Taxable Amount: example value 50000
  • TDS Rate: example value 10%

India-specific notes before using the format

Check the correct TDS section and threshold before deduction. PAN availability can affect TDS treatment and reporting. Keep challan and deposit references separate from invoice remarks. WorkbookWise keeps these notes on the landing page because Indian business Excel files often become operating records, not just rough drafts. A free format is useful when it makes the daily workflow cleaner, but tax, payroll, rent, school, stock and customer records may still need human review before they are treated as final business evidence.

  • Check the correct TDS section and threshold before deduction.
  • PAN availability can affect TDS treatment and reporting.
  • Keep challan and deposit references separate from invoice remarks.

How to use the download

Keep one deduction event per row. Use separate columns for PAN, section, nature of payment, taxable amount, TDS rate, deducted amount, deduction date, deposit date and challan reference. Download the workbook, keep the sample rows until the structure is clear, then replace them with real rows. Add only the extra columns your team will actually maintain. If an old Excel or CSV file already exists, clean the headers first and then copy rows into this format so formulas, filters and future imports have predictable column names.

  • Open the XLSX in Excel and inspect the sample rows.
  • Replace sample rows with real business data after checking column meaning.
  • Keep one business record per row so filters and summaries work.
  • Use WorkbookWise paid workflows later only when the free format is no longer enough.

Review before sharing or filing

TDS section, threshold, rate and due-date rules change by payment type and law. Confirm with an accountant before filing returns, issuing certificates or treating this workbook as final evidence. The workbook includes WorkbookWise source details and a UTM-marked page link in the About sheet so teams can trace where the file came from. Before sharing, remove sample rows, check personal or customer information, confirm formulas you add yourself, and keep a dated copy of the final version if it supports payroll, GST, stock, rent or collection decisions.

  • Remove sample rows before sending to staff, clients or accountants.
  • Check sensitive personal, salary, tenant, student or customer data.
  • Confirm any formulas or compliance assumptions added after download.

FAQ

Questions before downloading.

Is this TDS deduction format in Excel free?

Yes. The XLSX file can be downloaded without login and includes a WorkbookWise About sheet with the source page link.

Who should use this TDS deduction format in Excel?

It is designed for accountants and Indian SMB finance teams that need a practical Excel structure for deductee details, section, taxable amount, TDS and challan review.

Can I open the file in Google Sheets?

The download is an Excel XLSX file. Basic rows and columns usually open in Google Sheets, but Excel remains the primary supported format.

Does this replace accountant or compliance review?

No. It is an editable workbook starting point. Review tax, payroll, legal, medical, school, rent or business assumptions with the right person before final use.

Can WorkbookWise turn this into an app or document flow later?

Yes. Once the columns are useful, the same row structure can support custom workbooks, Apps, Forms, Share Data or Rows to Documents workflows.

সম্পর্কিত পেজ

Related formats and guides.

Free Excel formats

Browse the full no-login format library.

Open

Format field study

See what practical Indian business formats have in common.

Open

Create custom workbook

Build a custom workbook when the free format is not enough.

Open

GST Invoice ফরম্যাট

GST Invoice ফরম্যাট - GST and invoices কাজের জন্য তৈরি Excel format. Sample rows, পরিষ্কার columns এবং no-login XLSX download আছে.

Open

Salary Slip ফরম্যাট

Salary Slip ফরম্যাট - HR and payroll কাজের জন্য তৈরি Excel format. Sample rows, পরিষ্কার columns এবং no-login XLSX download আছে.

Open

Stock Register ফরম্যাট

Stock Register ফরম্যাট - Inventory and stock কাজের জন্য তৈরি Excel format. Sample rows, পরিষ্কার columns এবং no-login XLSX download আছে.

Open

Download the free Excel format.

Start with the XLSX file, then use WorkbookWise custom workflows only when this simple format is no longer enough.

ফ্রি XLSX ডাউনলোড