1. Understanding the Shift: Section 195 and Rule 37BB

The core objective of Form 145 and Form 146 is to safeguard the national revenue base and prevent tax evasion on international payments. Section 195 of the Income Tax Act mandates that any person responsible for paying a non-resident, or a foreign company, any sum chargeable to tax in India must deduct Tax Deducted at Source (TDS) at the rates in force. Historically, Rule 37BB required the submission of Forms 15CA and 15CB to track these deductions.

The introduction of Form 145 and Form 146 eliminates outdated XML methodologies and paper-based ambiguities. The modernized Income Tax e-Filing portal now relies on a highly sensitive JSON schema. This means that every single data point—from the PAN of the remitter to the specific Double Taxation Avoidance Agreement (DTAA) article applied—must be perfectly structured in machine-readable code before the government server will accept the filing.

2. Defining the Forms: What are Form 145 and Form 146?

Form 145: The Remitter’s Digital Declaration

Form 145 is an event-based, mandatory declaration filed by the remitter—the person or entity sending money outside of India. It requires the remitter to declare the exact nature of the payment, the taxability of the transaction, the TDS deducted, and the specific Reserve Bank of India (RBI) purpose codes. Form 145 ensures that the Income Tax Department has real-time visibility into outbound capital flows, allowing them to track potentially taxable payments overseas before the funds clear international banking channels.

Form 146: The Chartered Accountant (CA) Certificate

Form 146 serves as the sophisticated, modern equivalent of the old Form 15CB. It is a highly specialized legal certificate that can only be issued, digitally signed, and uploaded by a practicing Chartered Accountant holding a valid Certificate of Practice (CoP) in India. The CA is legally obligated to scrutinize the remittance, examine its taxability under Sections 5 and 9 of the Income Tax Act, and validate the application of any beneficial rates under relevant DTAA treaties. Because the Income Tax Department relies heavily on this independent professional verification, issuing an inaccurate Form 146 can result in severe financial penalties for the CA under the latest provisions of the Act.

3. Demystifying Form 145: Which Part Must You File?

Form 145 is intricately divided into four distinct sections to cater to the vast variety of foreign remittances—from small personal maintenance transfers to massive corporate software royalty payouts. Selecting the incorrect part will immediately lead to schema rejections on the portal.

4. The Pre-Requisites: Crucial Documents Required for Preparation

Before launching your offline Excel utility to prepare your bulk data, you must gather all mandatory documentation. The e-Filing portal’s JSON schema is unforgiving; a single missing data field, an incorrect character length, or a misplaced decimal will trigger an immediate upload failure.

• Verified Entity Details: Valid Permanent Account Number (PAN) and Tax Deduction and Collection Account Number (TAN) of the remitter, alongside complete, verified address data.
• Foreign Remittee Data: The foreign entity’s PAN (if available in India) or their Tax Identification Number (TIN) from their home country, along with their principal place of business. Providing the foreign TIN is often crucial when the remittee does not hold an Indian PAN, to avoid higher penal TDS rates under Section 206AA.
• Tax Residency Certificate (TRC): If you are applying a lower tax rate by claiming DTAA benefits, securing a valid TRC issued by the government of the remittee’s home country is legally non-negotiable.
• Form 10F and No PE Declaration: Alongside the TRC, the foreign remittee must provide a digitally signed Form 10F and a formal declaration stating they do not maintain a Permanent Establishment (PE) or business connection in India.

5. Our Automated Workflow: The Form 145 & 146 JSON Export Process

Generating compliant files for cross-border taxation is effortless with our advanced offline Excel utility. To ensure maximum accuracy and seamless bulk processing, we have designed a highly intuitive Excel to JSON export and import process. Here is how you can completely automate your foreign remittance reporting directly from your desktop:

• Go To – Appropriate Form Sheet Template: Launch the utility and navigate directly to your required Form 145 (Part A, B, C, D) or Form 146 worksheet.
• Use F1 Key for Export / Import Menu: Press the F1 key to instantly open the master control panel for rapid file management.
• Use Right-Click for Instant Switch: Rapidly navigate your workspace by using the right-click function to go to specific columns and sheets without endless scrolling.
• Fillup the Data As Per Excel Columns Header Format: Enter your corporate financial data seamlessly, matching the exact portal-compliant column structure.
• Select Value from Cell DropDown: For any column HEADER marked as LIST, always use our smart dropdown menus to select the correct purpose codes and country data to ensure schema compliance.
• Click VALIDATE DATA Button: Run our built-in pre-check to validate the schema & codes, catching any hidden formatting errors before file creation.
• Click GENERATE JSONs & EXPORT button: Trigger the automated Excel to JSON engine. The JSON file generated process will be started immediately in the background, converting massive datasets in seconds.
• Saved JSON Files as you selected Style: The utility safely outputs your validated data exactly as required by the official Income Tax servers.
• Select JSONs SAVED PATH Folder OR Create ZIP of Files: Route the final files to your designated folder or instantly create a bulk ZIP archive ready for portal upload.

The Drawback of the Official Income Tax Offline Process

Tax professionals often attempt to use the government’s official Income Tax offline utility, only to immediately encounter a massive operational drawback: it only supports single records export at a time. Because the official tool lacks a true bulk processing feature, finance teams are forced to manually type, validate, and export every single transaction one file after another. This single-record export limitation creates a frustrating bottleneck, causing portal timeouts, massive data entry duplication, and wasted billable hours. By utilizing our Form 145 and 146 JSON bulk generator, you completely bypass these limitations—processing thousands of records simultaneously and generating compliant bulk ZIP files without the repetitive manual labor.

6. Why Professionals Demand the XLTOOL Excel to JSON Bulk Generator

While the government has provided an online e-Filing utility, it is practically designed for taxpayers generating single, occasional forms. For Chartered Accountants, tax consultants, and corporate finance teams managing high-volume, recurring remittances, relying on a live web browser introduces severe operational risks. These include unexpected session timeouts, server lag during peak tax seasons, and the potential loss of hours of manual data entry.

Deploying a specialized, professional desktop tool like the XLTOOL Income Tax Excel Form 145 and 146 Bulk Generator—which you can download free directly from our website—provides massive strategic advantages:

• Absolute Data Sovereignty (100% Offline): Form 145 and 146 contain highly sensitive corporate financial data, PANs, and global bank account details. The XLTOOL offline Excel utility ensures your confidential client data remains strictly on your local computer during preparation. No internet connection is required until the final JSON payload is ready for portal upload.
• Blazing Fast Bulk Processing: Instantly convert thousands of rows of Excel data into clean, compliant JSON files with a single click. This completely bypasses the tedious, error-prone manual online entry workflow and saves days of repetitive labor.
• Zero-Error Automated Schema Validation: XLTOOL eliminates portal rejection panics by hardcoding the department’s official JSON schema checks. The utility instantly catches invalid PAN structures, TDS calculation disparities, or missing mandatory nodes right inside Excel before file generation.
• Smart Dropdowns & Automated Mapping: Standardized dropdown menus for country codes, currency values, and RBI purpose codes eliminate invalid character entries. XLTOOL automatically synchronizes CA certification data between Form 146 and Form 145 Part C, guaranteeing consistent, rejection-proof filing every time.

7. Crucial Technical Step: How to Prepare JSON and Create the ZIP Archive

When dealing with bulk foreign remittances, the Income Tax e-Filing portal allows you to upload multiple records at once to save time. However, the technical packaging of these files is where 90% of users fail. The portal’s backend servers require a very specific ZIP file structure to read your bulk JSON data correctly.

Once your offline Excel utility generates the individual `.json` files for your various remittances, you must bundle them into a single ZIP archive for bulk upload. CRITICAL RULE: You must ZIP the actual JSON files directly. Do NOT place the JSON files inside a master folder and ZIP the folder.

The Correct Packaging Method for Bulk Uploads:

1. Open the directory on your computer where your newly generated `.json` files are saved.
2. Select/Highlight all the raw `.json` files you wish to upload (Press Ctrl + A to select all files). Do not highlight the folder containing them.
3. Right-click directly on one of the highlighted files.
4. Select “Send to” > “Compressed (zipped) folder” (on Windows) or “Compress Items” (on Mac).
5. This ensures that when the Income Tax portal unzips your file, it immediately sees the `.json` files at the root level. If you put the files into a folder named “My_Uploads” and zip the folder itself, the portal’s extraction script will fail, returning an “Invalid File Format” or “Schema Error.”

8. Step-by-Step e-Filing Guide for Form 146 (The CA Certificate)

For taxable transactions requiring Part C, the Chartered Accountant must complete their compliance workflow on the portal before the remitter can even begin.

1. Assign CA on the Portal: The remitter logs into their e-Filing portal account, navigates to “Authorized Partners” > “My Chartered Accountants,” enters the CA’s membership number, and officially assigns Form 146 to them.
2. Prepare Data Offline: The CA opens the offline Excel template, meticulously enters the remittance details, taxability analysis, and DTAA rates, validates the data, and clicks “Generate JSON”.
3. Upload the JSON: The CA logs into their own e-Filing account. They navigate to e-File > Income Tax Forms > File Income Tax Forms, select Form 146, choose the “Offline” filing mode, and attach the root-level JSON file.
4. UDIN Integration & e-Verification: The CA enters the Unique Document Identification Number (UDIN) generated from the ICAI portal, attaches their Digital Signature Certificate (DSC) using emSigner, and submits the form.
5. Generate Acknowledgement Number: Upon successful submission, a 15-digit Acknowledgement Reference Number (ARN) is generated. The CA must provide this ARN to the remitter to unlock Part C.

9. Step-by-Step e-Filing Guide for Form 145 (The Remitter)

Once the CA has secured the ARN for Form 146 (or if the remittance falls under Parts A, B, or D), the remitter can complete the final filing.

1. Prepare Form 145 Offline: The remitter populates their offline Excel utility. If filing Part C, the software can auto-copy the CA’s certified data. Validate the entries and click “Generate JSON” (or create a root-level ZIP file for bulk uploads as detailed in Section 7).
2. Login to the e-Filing Portal: The remitter logs in using their PAN or TAN credentials.
3. Navigate to Form 145: Go to e-File > Income Tax Forms > File Income Tax Forms and initiate Form 145.
4. Select the Relevant Part & Link the ARN: Choose Part A, B, C, or D. If Part C is selected, the portal will prompt you to enter the 15-digit Acknowledgement Number of the Form 146 submitted by your CA. The portal will cross-reference and fetch the CA’s certified data automatically.
5. Upload JSON & Submit: Select the “Offline” upload method. Attach your validated `.json` file (or your properly formatted `.zip` file for bulk records). E-verify the submission using a DSC (mandatory for TAN users) or an Electronic Verification Code (EVC) via Aadhaar OTP, and click submit.

10. Common Compliance Errors and Schema Validation Failures to Avoid

Navigating foreign remittance taxation is complex, and the e-Filing portal’s automated backend analytics will flag inconsistencies instantly. Avoid these common pitfalls to ensure a 100% success rate:

• Invalid ZIP Packaging: As emphasized, uploading a ZIP file that contains a nested folder instead of direct JSON files is the leading cause of technical upload rejections. Always highlight the files, not the folder.
• Misunderstanding the Exemption Threshold: The specified monetary threshold (e.g., ₹5 Lakhs) determines whether you file Part A or Part C. It does not imply that income below this threshold is automatically exempt from TDS. You must still evaluate the taxability of the transaction under the Income Tax Act.
• Mathematical TDS Mismatches: The portal’s schema will calculate the TDS based on the remittance amount and the rate you entered. If you manually type a TDS amount that does not perfectly match the calculated percentage (due to rounding errors or manual typos), the JSON will fail validation. A robust offline utility handles these calculations automatically.
• Incorrect Purpose Codes in Part D: Form 145 Part D relies entirely on declaring that the remittance is non-taxable. Selecting a vague or incorrect RBI purpose code that conflicts with the actual nature of the transaction can trigger an immediate scrutiny notice from the Assessing Officer.

By leveraging a professional Excel to JSON bulk generator, adhering strictly to ZIP packaging rules, and thoroughly verifying DTAA documentation offline, tax professionals can transform Form 145 and 146 compliance from a highly stressful manual chore into a secure, streamlined, and heavily automated workflow.