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?

When should you use GSTR-1 Govt Excel Template to import Sales Data?

When should you use ClearTax Standard Sales Excel Template to import Sales Data?

When should you use ClearTax Lite Sales Excel Template to import Sales Data?

When should you use ClearTax Simple Sales Excel Template to import Sales Data?

When should you use Tally Government Excel Template to import Sales Data?

When should you use ClearTax Tally Connector to import Sales Data?

When should you enter your Sales Data manually?

When should you use GSTR-1 Json/Tally JSON to import Sales Data?

When should you use Custom Excel Template to import Sales Data?

When should you use ECommerce template to import Sales Data?

Purchase Data Import

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