Support: ask@xltool.in
🟢 WhatsApp / Call: +91 919137734440 🌐 145146.in
✅ 100% Offline Excel Utility • High Security

EXCEL TO FORM 145 & 146 JSON BULK GENERATOR

The fastest, safest, and most user-friendly Excel offline utility for Chartered Accountants. Generate unlimited JSON files instantly with schema-level precision, strong validations, and smart auto-fill capabilities without coding.

Request Live Demo

⚠️ DO NOT UPLOAD CLIENT DATA ONLINE

Form 145 and 146 contain highly sensitive foreign remittance data and PAN details. Why risk uploading it to third-party online portals? Our tool is a 100% Offline Excel Utility. Generate JSON files securely on your own computer. Work anywhere, anytime.

Generate JSON for Every Form Type

Complete automation for the new Income Tax portal formats. Understand exactly which forms our utility supports.

📜

Form 146 (CA Certificate)

Previously known as Form 15CB. This form requires detailed inputs from the Chartered Accountant validating the nature of the foreign remittance. Our utility flawlessly captures CA details, remitter/remittee data, and tax deduction certificates to generate an exact JSON payload for portal upload.

A

Form 145 Part A (Taxable Up to Threshold)

Used by the remitter when the remittance is chargeable to tax under the Income Tax Act, and the aggregate amount does not exceed the specified threshold limit during the financial year. The utility validates the threshold limits and generates precise TDS details in the final JSON.

B

Form 145 Part B (Order Based Remittance)

Used when the remittance is chargeable to tax, and the remitter has obtained a specific order or certificate from the Assessing Officer under section 195(2) / 195(3) / 197 of the Act. The Excel template provides mandatory fields for entering AO Order details to ensure portal acceptance.

C

Form 145 Part C (Taxable with Form 146)

Used for remittances requiring a CA Certificate (Form 146). Exclusive Feature: Our utility includes an Auto-Copy function. Once you fill out Form 146 in our Excel tool, click a button to instantly copy all relevant CA, tax, and remitter data directly into Part C, eliminating double data entry.

D

Form 145 Part D (Not Chargeable to Tax)

Used when the foreign remittance is not chargeable to tax under the provisions of the Income Tax Act. The utility simplifies this by providing built-in, auto-dropdown lists for all approved Purpose Codes, ensuring your declaration and bank details match portal schemas perfectly.

Ultimate Excel Automation Features

We built a powerful software engine directly inside a familiar Excel interface. No manual JSON coding required.

1-Click Bulk Generate & Export

No extra charges per file. EXPORT and create bulk JSON files instantly from Excel with a single click. Process unlimited records.

📥

Intelligent JSON Import

IMPORT previously approved JSON files back into Excel. The utility reads the JSON and auto-fills the Excel sheet, saving massive amounts of re-typing time.

🛡️

Strong Data Validations

Built-in checks for exact format, length, and numerical accuracy. Prevents portal rejections before they happen.

👥

Offline Safe & Multi-User

100% offline data security guarantees client privacy. Plus, robust multi-user support allows your entire firm to collaborate securely and seamlessly.

🔍

Auto Error Correction

The system automatically detects and corrects hidden spaces, invalid special characters, and formatting errors in your data.

📑

Master Sheet Auto-Fill

Keep a Master Sheet. Type a Party Name once, and the utility will auto-fill their Address, PAN, and TAN across all other sheets.

📋

Auto Dropdown Codes

No need to memorize purpose codes or country codes. Select from auto-updating dropdown lists exactly as per Income Tax rules.

🏢

Unlimited Companies

One utility handles all your clients. Supports unlimited companies and unlimited JSON generation. Ideal for large CA firms.

💻

Broad Excel Compatibility

Designed to work seamlessly across older and newer systems, providing robust compatibility from legacy Excel 2007 up to modern Office 365.

Choose Your License Plan

Transparent pricing for CA firms. Pay once, use unlimited.

Features & Particulars Silver Plan Gold Plan 👑
Pricing (INR)
₹ 39,999
₹ 89,999
License Validity 1 Year 1 Year
Data Processing Limit Up to 10 Lac Records UNLIMITED Records
Multi-User Support Standard Support Advanced Multi-User Access
Automated Portal Updates Included Priority Included
Schema Validation Engine Yes Yes
Company Support Unlimited Companies Unlimited Companies
Import / Export JSON Included Included
Support Type Email Support Email & On-Call VIP Support
Buy Silver Plan Buy Gold Plan

💳 Step 1: Make Payment

Use Razorpay above, or view our
Direct Bank Details for NEFT/RTGS.

📝 Step 2: Fill License Form

After payment, fill out the license generation form to activate your offline utility.

Submit License Form

Why Use an Offline Excel Utility for Form 145 and Form 146?

The Transition from Form 15CA & 15CB

The Income Tax Department has revolutionized the foreign remittance filing process by replacing the legacy Form 15CA and Form 15CB with the new, highly structured Form 145 and Form 146. This change requires professionals to submit data in a strict JSON format. While the government provides online utilities, manual data entry on web portals is slow, prone to session timeouts, and introduces data privacy risks. This is where EXCEL TO FORM 145 & 146 JSON BULK GENERATOR becomes an indispensable tool for modern accounting firms.

Data Security: Why Offline is Better

When dealing with international remittances, you are handling highly sensitive PAN details, bank account numbers, and large financial transaction records. Uploading this data to a third-party, cloud-based web application poses a massive security vulnerability. Our utility is a macro-enabled Excel workbook that runs 100% locally on your computer. No data is transmitted to our servers. You generate the JSON offline, review it, and upload it directly to the official Income Tax portal yourself.

The Power of Bulk JSON Generation

  • No Manual Coding: You do not need to understand JSON arrays or syntax. You paste your data into familiar Excel columns, and our VBA engine writes the complex JSON code perfectly in the background.
  • Time Efficiency: What previously took hours of manual entry can now be completed in seconds with our 1-Click Export feature.
  • Reverse Engineering (Import Feature): A unique feature of our tool is the ability to IMPORT an already approved JSON file. If you have recurring remittance data, import the old JSON, let the tool fill the Excel sheet, update the dates/amounts, and export the new JSON instantly.

Schema-Level Validation Prevents Errors

Portal rejections are frustrating and time-consuming. Our offline Excel utility has the official Income Tax schema validations built directly into the cells. It restricts character lengths, enforces correct date formats, checks threshold limits for Part A, and removes invisible spaces that often cause JSON parsing errors on the government portal.

Trusted by CAs Nationwide

Join 19,833+ professionals who trust XLTOOL offline utilities for secure filing.

★★★★★

"The JSON IMPORT feature is a lifesaver. We fetch old JSONs and edit them instead of typing everything again. Brilliant utility!"

— Ramesh CA

★★★★★

"I refuse to upload client PAN and remittance data to random websites. This 100% offline Excel tool is exactly what our firm needed."

— Priya Sharma

★★★★★

"Auto-copying Form 146 data to 145 Part C happens instantly. Saves us hours of effort and eliminates typing errors."

— Amit Desai & Co.

★★★★★

"The Master Sheet feature for Party Name and PAN auto-fill works flawlessly. Very well structured Excel template."

— S.K. Financials

★★★★★

"Unlimited companies and unlimited JSON generation without any per-file charges. The Gold plan is highly cost-effective."

— Global Tax Partners

★★★★★

"The JSON IMPORT feature is a lifesaver. We fetch old JSONs and edit them instead of typing everything again. Brilliant utility!"

— Ramesh CA

★★★★★

"I refuse to upload client PAN and remittance data to random websites. This 100% offline Excel tool is exactly what our firm needed."

— Priya Sharma

★★★★★

"Auto-copying Form 146 data to 145 Part C happens instantly. Saves us hours of effort and eliminates typing errors."

— Amit Desai & Co.

★★★★★

"The Master Sheet feature for Party Name and PAN auto-fill works flawlessly. Very well structured Excel template."

— S.K. Financials

★★★★★

"Unlimited companies and unlimited JSON generation without any per-file charges. The Gold plan is highly cost-effective."

— Global Tax Partners

★★★★★

"The JSON IMPORT feature is a lifesaver. We fetch old JSONs and edit them instead of typing everything again. Brilliant utility!"

— Ramesh CA

★★★★★

"I refuse to upload client PAN and remittance data to random websites. This 100% offline Excel tool is exactly what our firm needed."

— Priya Sharma

★★★★★

"Auto-copying Form 146 data to 145 Part C happens instantly. Saves us hours of effort and eliminates typing errors."

— Amit Desai & Co.

★★★★★

"The Master Sheet feature for Party Name and PAN auto-fill works flawlessly. Very well structured Excel template."

— S.K. Financials

★★★★★

"Unlimited companies and unlimited JSON generation without any per-file charges. The Gold plan is highly cost-effective."

— Global Tax Partners