# Importing & Reconciling Sales Data for GSTR 1 Filing

This guide will help you import a sales template, resolve errors, and reconcile invoices with the sales register. By the end, you'll know how to efficiently manage your sales data.

{% embed url="<https://youtu.be/65EBuhjizYI?si=m6Ku2Z8-gQrsby9K>" %}

{% stepper %}
{% step %}
Fill in your sales template and click **Import** to begin.

![](/files/JC2bhNTSBVGze8qUxolU)
{% endstep %}

{% step %}
Click **Select a file**, choose the sales register to import, and click **Open**.

![](/files/fhIOEqGiaioVmloFF57S)
{% endstep %}

{% step %}
Click **Business** to select your GSTIN or PAN.

![](/files/YVTE8QZr4sMpC601TA0d)
{% endstep %}

{% step %}
If you have multiple GSTINs, select them. Otherwise, select the required GST number.

![](/files/9HTck99Om6EopCDuBtVQ)

![](/files/BcVsCujoYFKVdMkNYXsR)
{% endstep %}

{% step %}
Choose a return period, select your sales template, and click **Check file for errors**.

![](/files/4SbTILs9PJuMGe6iCBZS)

![](/files/RLxqTmbzwn74kuU0E810)
{% endstep %}

{% step %}
If validation errors appear, download the error file or click **Review and fix error** for minor issues.

![](/files/HUNX8Re4sT7Aw6zgrgmj)
{% endstep %}

{% step %}
Scroll through the errors or click **Errors** to view them.

![](/files/qXUVTovuysuNxtw041lP)

![](/files/POAq5X38KD4Sd7CS8Lq4)
{% endstep %}

{% step %}
If the first error is an invalid HSN or SAC code, change the goods to services to fix it.

![](/files/3b5hhJDiUpE5hnTVOea9)

![](/files/Guhk54d8L4AQh5IaoLF4)

![](/files/oj8iozjemowe8A3qNJfs)

![](/files/eKrRsPcsqxKNiPsjzC1d)
{% endstep %}

{% step %}
For duplicate GST supplier errors, treat the invoice as B2C and delete the SA.

![](/files/fryupw25OgjCJCVbD8lS)

![](/files/bORh6zdcCJOhbiYNGF9Q)

![](/files/7ldOVzhjSuWIM0nDmFOI)

![](/files/Z7wsz8AN0S4LbmsGCub6)
{% endstep %}

{% step %}
Resolve all errors. A green tick will confirm success.

![](/files/NoogbYf1HqiS1yl1GZsK)

![](/files/B1lros4vzC1vPXHtdmWo)

{% endstep %}

{% step %}
Click **Proceed**. If successful, no errors will remain.

![](/files/KfrfIWRMA48SrYyWRSfD)
{% endstep %}

{% step %}
Click Import and Proceed again, then select your GST and return period.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdMEvz9pnI0o6Y5kc823rA7HrAUiFql7JzofrDNxzzLGTD2jeuLTXraNSZjgiCDna1OP-4S3NyKjRuInS3Zet--m4MGslKWwdUF4t08mx0xJWx1HkweNHj9LvpeydUNKqFqfs7D?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXe03Hl0Zi0LAGoVBrDMRM6NV4HmBrieeCZditeIZEHFO5cYapIbX7FsoZuBdukIr5Ce4OpEVbL8f8v4MoIioJTrilCsxKIkFJojUzdBiFDTR44Zq8uVDiqsPaoLbJLYoWnYHdtJxw?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcbtbPPN3F3L05TsTzW0WcOvnNelo4K343hefsxGjoDgbnupNJJedUFk-GiOPI3xi2ZY1ExBaugMbQtFpqecg1Syi6MgeHAvilZW-dm3jf87AyTo-2rWH4zuFNGLLWuqMaQITgBNQ?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Once the invoice is ingested, click on it to view all data.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcSyW0Za7Lx1Y93tKODmV6ZFrxmity6FRYVAj_th_DimUjJhT5-u82FL6tpM5OWjE83emyZpJ8p6Uj7-lkHTwBCueuIVFXlkgaiSE2ySZ7SKO-LgJflMZCHDJ7S7ILAKaAnvD2g1g?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
To add more details, click Edit to add a new line item or modify details.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcBPkEy_PCrEHFgGjc0G522jaKo7ZQApwdfWvojbFxIrkp6FAAr1CL3tT1EFzMeIN1Y5RVcktfY_ANYKxn5QDUHfpNejLiKDyRFOZmfZkvlLHdtSsxvRqHRVUdNpKpkpEQDO4-NvQ?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdab5vO1qezikOdSgHWbzGeKhLwPfeHJUoQ-EfsRshTjFLb2Drp_Xw7W0Br21q_MYoA25fGcb6m29CYz_t9A6wTB2PiMWh_hVM72l3kombG1pRqMmD39quqJwXsdyKwgapceQZZ5Q?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
If it's an export, select that option.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfOcEsUgLSRprP0bgIlAQB6FzN47HOdjqMadmEHMDcmDkZyQFkBoEhTblzht630Yo2HXnq8qidndnTr_577gSrd6XxC-ZhmgjpEY7mU6O-1TdWiTT6FMX2WIL9O-IaWx718yDbO?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
For amendment details, make changes and click Save.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXf8zDQAahsttE_ZymV6p05tBHqg8M6qknyhu5xNgRysIv9yH9JXwjNokhxZif9s1Pvf--PKPXepLJ1ceBOQ4_2amSk0PsqRGhlSflpQExUyt-9rRd_pcnhYm_ZJoX_3S76cFZx4Gg?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
After ingestion, verify the total document value, taxable amount, total tax, and the IGST, CGST, SGST breakup.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXe-ii6jmG9jlVmfBxpA2WsRdGwioYQWYLyUmaTAsVZcP-2ez9sdTyfMmXlVpwvWyYyq502QmJv84dlsdbU4WGZTRFIOfv7zFsIgGCV8CHLJZZmAffN08ENqyF_lPg_c774ztupB5Q?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
reconcile invoices with the sales register, click Filing, select GSTIN, Business, Return Period, and then Continue.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdE-uY-U1dThIFeCKd6HtDWvSaoXAhDzgBl7aBkLrMDwGI1Y9AOwlnAwe_jqUdJq7latz5dvdXrSa3jLQW-O3-sCPOmhujhOCsZVHvjUkFaxmcXV_bWBk-C1MvFExjDdXjFY1qg?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcDxFSkZQIpJj50pvVegFBob2hj3dMq74AX42_hSgaltxdAVWvB1Up0-REpk4taGcsZYuekoZ8e6_vKV6GTYJl0iDCwxfEheZRCeDiOd6eJo-IS-e3fIZCl4dSnB-IHmuP7mYLzFg?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXe5lcBHnF4g-PEHobr_Lh1vTSyQ8orjPMV9TVCC04XOV3UhWgQTxL-WRTnPnT5j2SgFNhUhpAOFcA2TL9nVPFHJKvo-fL1CyJxaQdAv8vBsqqqmnla3fU5DaBbkDe88ciQWxUSJ6w?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeVHlIzwEOH2JXYDptxd6R7vCV2Mj258zkQzJqt7Ge3aEF1T-W21qi1GkXz62dnyc-6rnBPdGUL73Usoizdqb9yR8S-U3hNW4WsxJTAetX8Vl2BObRdZc8DSLO7TEelEojzXSMoEA?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdJaZ7Ar9ezRdlgkqb2IUdFjI6HovluVqaw-_cnSSkYgdBTWgTVd0jJ1UVt9nJJ0vWZZiW9i2vfC1vWTs6CN0wER-W5hhXlyt1QWH3W6dIZnnJuFuxJRYDqrN4Pq6-Mx2eszMVS1Q?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Click Invoice vs Register Reconciliation.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXe9H8DoMbcum8W6ujMT0HxeYFQoFoffaiD6UAR8_ESiFm7XzEI9O4B3HbrSb9uwfa0iWmAZZUIlU04nE7SU5SsnpLt9k0iFAhuNQZmPT0aEwMEZT25NwI2-msOc-Du0a6o8hLLK1A?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXc1a-h3AoVy90zmSuZ72hNeA80XAdVy1wBEUJ3QQFjK1Ba4w6Rk_QIWIQskpogbuitqQFhhj4Da15h8fDlHmoTb7xW3L-UzvxLVHYWTwSUI3TQWmlQwkPlcykTAXWdGWNjEt_cUOw?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Alternatively, click Reconciliations for options like Invoice GSTR1 vs Sales Register Reconciliation.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfiYcir6GVRCge_f2Na7zCjhLV-U1pZ3nS4YJCxMEGWwjni61Y5MYwaDdde6Tb2A7UpG2dQ5cV6aaFSBxZFxQUQ2yEwH-mO0s2uDH1VZnIlOZ_psIYbekXLDRoe_psH1JA_0TVtPg?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeIaOffdMHmE3pZJpPHeFvDq2TtMvb5eZAv0xfxJjRyobcOJV8z4zL204MCo_KdVKkNnGRWb0gqXz-RK0nPD8XghVtFBwEGVjnw-HPF5yJqW0FHGNRnYRVLO9_UnXC8cXXZvSLc8g?key=VoWICFJXXizhSkIOxRaC6A" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cleartax.in/product-help-and-support/for-large-businesses/gst-compliance/gstr-1/importing-and-reconciling-sales-data-for-gstr-1-filing.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.