Excel sheet clause 44 3cd gst expenses

1671 views 1 replies
Excel sheet format tax audit person clause 44 3cd report for gst expenses .
Replies (1)

Dear Kollipara Sundaraiah,

Clause 44 of Form 3CD under Tax Audit (as per Income Tax Act) requires reporting of GST-wise breakup of total expenses incurred during the year. This includes bifurcation of expenses between:

  • Registered under GST

  • Composition dealers

  • Unregistered parties

  • Exempt/NIL/Non-GST supply


Clause 44 – Requirements:

For each expense head, provide:

  • Total amount

  • Amount relating to entities registered under GST

  • Amount relating to entities not registered under GST

  • Break-up for entities under Composition scheme, Exempted/Nil/Non-GST, etc.


Excel Sheet Format for Clause 44 Reporting:

Here’s a ready-to-use Excel format structure you can recreate:

S.No Nature of Expense Total Amount Registered GST (B2B) Composition Dealer Exempt/Nil/Non-GST Unregistered Party GSTIN of Registered Vendor
1 Purchases (Raw Material) ₹10,00,000 ₹8,00,000 ₹50,000 ₹0 ₹1,50,000 22AAAAA0000A1Z5
2 Transportation Charges ₹2,00,000 ₹50,000 ₹0 ₹50,000 ₹1,00,000 -
3 Professional Fees ₹3,00,000 ₹2,00,000 ₹0 ₹0 ₹1,00,000 27BBBBB1111B2Z6
Total   ₹XX,XX,XXX ₹XX,XX,XXX ₹XX,XXX ₹XX,XXX ₹XX,XXX  

⚠️ Notes:

  • This report is only disclosure – no impact on tax computation.

  • Collect GSTINs of vendors wherever applicable.

  • Tally total amount with P&L expense totals.

  • You may group expenses (e.g., Purchases, Rent, Professional Fees, etc.)


If you’d like, I can create a downloadable Excel file version of this for you. Let me know!

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
24 June 2026
Senior Account (VA Client Operations)

Karbon Business

Bengaluru

CA Inter

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details