> For the complete documentation index, see [llms.txt](https://docs.cleartax.in/product-help-and-support/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](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).

# 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>
