Get Started
Frequently asked questions on importing data into ClearTax
You can find the answers to the following questions in this section -
Sales Data Import
What are the import options offered by ClearTax to import Sales Data?
GSTR-1 Govt format Excel template
ClearTax Templates
Standard Sales Excel template
Sales Lite Excel template
Sales Simple Excel Template
Tally
Government Excel for GSTR-1
Tally Connector
ClearTax Excel Grid (Manual Entry of data)
GSTR-1 JSON File / Tally JSON
Custom Excel Template - Create your own template
ECommerce format - For Amazon, Flipkart and PayTM
When should you use GSTR-1 Govt Excel Template to import Sales Data?
Use this option if you have data prepared in Govt GSTR-1 Excel template
Available for download with GST Offline tool
Can be directly imported into ClearTax without any modifications
Option to import section-wise data in CSV format as well
When should you use ClearTax Standard Sales Excel Template to import Sales Data?
Use this option to import all your sales data in a single Excel file
You can import all your -
Invoices & Bills of Supply
Credit/Debit Notes
Advances
Supports all types of documents including B2B, B2C, amendments, reverse charge, exports & SEZ
Multiple line items also supported
Most powerful Excel format to help you prepare your data
When should you use ClearTax Lite Sales Excel Template to import Sales Data?
Use this option to import all your ‘Invoices and Credit/Debit Notes’ in a single Excel file with minor details
Does not import 'Advances’
Supports B2B/B2C Invoices and Credit/Debit Notes
Multiple line items also supported
Does not support amendments, reverse charge, exports or SEZ
Quick way to prepare your data with support for HSN summary
When should you use ClearTax Simple Sales Excel Template to import Sales Data?
Use this option to import all your ‘Invoices and Credit/Debit Notes’ in a single Excel file with minimal details
Does not import 'Advances’
Supports B2B/B2C Invoices and Credit/Debit Notes
Multiple line items also supported
Does not support amendments, HSN, reverse charge, exports or SEZ
Simplest and easy to understand template for quick data preparation
When should you use Tally Government Excel Template to import Sales Data?
Use this option if you have data prepared in Tally and exported in Govt GSTR1 Excel template
Can be directly imported into ClearTax without any modifications
Option to import section-wise data in CSV format as well
When should you use ClearTax Tally Connector to import Sales Data?
Seamless import of data from Tally in a single-click .
No requirement of Excel exports from Tally and import again in ClearTax/Government portal.
GST rules validations are applied while importing of data. Vouchers that doesn’t meet GST validations will be excluded and presented in an error report .
When should you enter your Sales Data manually?
Use this option if you have do not have data prepared
Directly type in or copy-paste your data in an Excel-like grid
Supports only B2B/B2C invoices with minimal details
Does not support amendments, HSN, reverse charge, exports or SEZ
Does not support CDNs, Bills of supply or Advances
Does not support multiple line items or more than 200 rows
Best used for quickly creating invoices
When should you use GSTR-1 Json/Tally JSON to import Sales Data?
Use this option if you have data prepared in a JSON format
Can be directly imported into ClearTax without any modifications
Helpful in cases where you receive a JSON file from your client or export from Government in JSON GSTR-1 format
When should you use Custom Excel Template to import Sales Data?
Use this option if you have a custom or non-standard template used by your organisation/client
Create an Excel Template of your choice
One-time activity to create an Excel template and use as many times as you want
You can import all your -
Invoices & Bills of Supply
Credit/Debit Notes
Advances
Supports all types of documents including B2B, B2C, amendments, reverse charge, exports & SEZ depending on columns created in a custom template
Multiple line items also supported
High flexibility and customisation to create your own template and order columns however you want
When should you use ECommerce template to import Sales Data?
Use this option if you are a seller on Amazon, Flipkart or PayTM
Download MTR report from seller portal and upload on ClearTax
Minimal modifications required for importing data
Purchase Data Import
What are the import options offered by ClearTax to import Purchase Data?
GSTR-2 Govt format Excel template
ClearTax Templates
Purchase Standard Excel template
Purchase Lite Excel template
Purchase Simple Excel Template
Tally
Government Excel for GSTR-2
Tally Connector
Custom Excel Template - Create your own template
When should you use GSTR-2 Govt Template to import Purchase Data?
Use this option if you have data prepared in Government GSTR-2 Excel template
Available for download with GST Offline tool
Can be directly imported into ClearTax without any modifications
Option to import section-wise data in CSV format as well
When should you use ClearTax Standard Purchase to import Purchase Data?
Use this option to import all your purchase data in a single Excel file
You can import all your -
Invoices & Bills of Supply
Credit/Debit Notes
Advances
Supports all types of documents including B2B, B2C, amendments, reverse charge, imports & SEZ
Multiple line items also supported
Most powerful Excel format to help prepare your data
When should you use ClearTax Lite Purchase to import Purchase Data?
Use this option to import all your Invoices and Credit/Debit Notes in a single Excel file with minor details
Supports B2B/B2C Invoices and Credit/Debit Notes with reverse charge also
Multiple line items also supported
Does not support amendments, advances, imports or SEZ
Quick way to prepare your data with support for HSN summary
When should you use ClearTax Simple Purchase to import Purchase Data?
Use this option to import all your Invoices and Credit/Debit Notes in a single Excel file with minimal details
Supports B2B/B2C Invoices and Credit/Debit Notes
Multiple line items also supported
Does not support amendments, HSN, reverse charge, advances, imports or SEZ
Simplest and easy to understand template for quick data preparation
When should you use Tally GSTR2 Excel to import Purchase Data?
Use this option if you have data prepared in Tally and exported in Govt GSTR2 Excel template
Can be directly imported into ClearTax without any modifications
Option to import section wise data in CSV format as well
When should you use Custom Excel Template to import Purchase Data?
Use this option if you have a custom or non-standard template used by your organisation/client
Create an Excel Template of your choice
One-time activity to create an Excel template and use as many times as you want
You can import all your -
Invoices & Bills of Supply
Credit/Debit Notes
Advances
Supports all types of documents including B2B, B2C, amendments, reverse charge, exports & SEZ depending on columns created in a custom template
Multiple line items also supported
High flexibility and customisation to create your own template and order columns however you want
Last updated