Excel Import Process in Form 10BB

Zen IT || Excel Import Process in Form 10BB


To efficiently import bulk data into Form 10BB using Excel, follow these steps:

      


Step 1: Locate the Import Option
  1. On the left side of the form, find the "Particulars Annexures" section.
  2. Click on the option to Import Bulk Data using Excel.

Step 2: Prepare the Excel Template
  1. Navigate to Tools → Excel Template → Select Template 10BB Annexures.
      
  1. Enter the required data in the template.
      
  1. Save the Excel file to your local system (in any location).

Step 3: Upload the File
  1. Upload the prepared Excel file containing the necessary data.
  2. Ensure the file adheres to the correct format and structure for successful import.
In Excel, the Annexure Details for Form 10BB can include the following sections:
  1. Details 9(A): Enter the required information for the first section as per the department's specifications.
  2. Details 9(B): Include relevant data for the second section of Annexure 9.
  3. Specified Person: Provide details about the specified person involved (e.g., trustees, founders, etc.).
  4. Schedule 40A(3): Input any payments exceeding the limit of ₹10,000 in cash as per Section 40A(3).
  5. Schedule 40A(3A): Include details about cash payments that do not comply with provisions under Section 40A(3A).
  6. Schedule TDS/TCS: Provide information on Tax Deducted at Source (TDS) and Tax Collected at Source (TCS).
  7. Schedule Statement of TDS and TCS: Fill in the details of TDS/TCS transactions and amounts.
  8. Schedule Interest on TDS/TCS: Specify the interest amounts related to TDS/TCS under the relevant section.
Once all the data is entered in the Excel file, import it into Form 10BB under the corresponding annexures for the details to populate automatically.

    • Related Articles

    • Zen IT || Process to File Form 10BB Audit Report

      What is Form 10BB ? Form 10BB is a statement required to be furnished by charitable or religious trusts, educational institutions, or hospitals to claim exemption under Sections 10(23C)(iv), (v), (vi), or (via) of the Income Tax Act, 1961. It is ...

    • Zen IT || AIS Import Process

      What is the Annual Information Statement (AIS) ? The Annual Information Statement (AIS) serves as a comprehensive snapshot of a taxpayer's information as displayed in Form 26AS. Taxpayers are afforded the opportunity to furnish feedback regarding the ...

    • Zen IT || Process to File Form 10B Audit Report

      What is Form 10B? Form 10B is an audit report required under Section 12A(b) of the Income Tax Act, 1961, for charitable trusts and religious institutions to claim tax exemption. This report is certified by a Chartered Accountant (CA) and includes ...

    • TDS || Excel export and Import Procedure

      To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...

    • Income Tax || Form 10B/Form 10BB → JSON Import Process

      To successfully import a 10B/10BB JSON file, please ensure that the master data for the specific client, classified as [Association of Persons (Trust)] status, is already present in the software. If the client does not yet exist, you will need to ...