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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FBGqjXIE5BfKEwCV1CvkX%2F0.png?alt=media\&token=44e92a6b-5dff-41b3-ad5d-71e03d0ffe2b)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FUeGEj1XCGwRkRjpbh1cm%2F1.png?alt=media\&token=e068f8a7-7c4e-415a-8eeb-fd46f18c6e17)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FdOlr34HNpCezeq67Sbuu%2F2.png?alt=media\&token=7d5bf68b-1d6b-4b72-a215-84bbdfa020a7)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FZ8yg6lYnyiEI4te45Hma%2F3.png?alt=media\&token=0ac8283a-9370-46c3-a827-c94446fc99f4)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FZcNuAAxlRmv745RBfnq8%2F4.png?alt=media\&token=ee7f9d19-8147-4fda-ae5f-7139080dd835)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FPoK85tIYQY8eys7WQItX%2F5.png?alt=media\&token=07ecedae-8bdc-44e5-b2de-0fe0e3d4ee19)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FYqOYPonBLlmsEcQucru0%2F6.png?alt=media\&token=ca101557-37f7-44c1-af62-aedf8410dcf2)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FF2Wdl09ekCr1GpDRRjF5%2F7.png?alt=media\&token=8dc96b9f-acd9-404a-b9a0-9754ed763a54)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F4AtLrtkd1rLQU3APn9wU%2F8.png?alt=media\&token=bf8d63c0-3e58-495f-a742-e35fd7d11914)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FwjwUDkZxMbShQODChBld%2F9.png?alt=media\&token=88c5f2e7-f28a-4d45-a83f-b31914c7b8e9)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FuecjNwG1qUvestildkxo%2F10.png?alt=media\&token=5e4b26e2-cfbd-4709-856a-85bc0ffc0c54)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FQsOLI2vFoySuFGya5oF8%2F11.png?alt=media\&token=80b6006d-8b84-4c0f-b71c-7fb2c9cdca08)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F0bmnUTiwuzzh4MOtCCFG%2F12.png?alt=media\&token=28da3b98-1954-4238-8248-743e249c738d)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FKuOaC4cWEzQGihXo7fGV%2F13.png?alt=media\&token=e491ac17-4cbc-4ac7-a17c-062447631d26)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FGENjT78r2jjhuMpDCV4G%2F14.png?alt=media\&token=571c18ad-1150-42a4-86be-56876ba75de4)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FyVFct3vLzIn6aYiK1BPR%2F15.png?alt=media\&token=1e7eb10c-269b-47d2-b227-2e9d466c7a59)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2Fb7Qfok6mZ7GL2vuNsx9E%2F16.png?alt=media\&token=05d87c55-bdf0-45a9-baf0-97905e990185)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FRqXZwuugWg7OppWAmZJz%2F17.png?alt=media\&token=0bb794d0-0d0f-4288-bef9-b1b33f6a2996)
{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F20lH5mdn8HE82LO2JnAA%2F18.png?alt=media\&token=a6f326f0-395a-4002-955f-51933e05dc72)

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FI17SE0JNAqegobtNuH3D%2F19.png?alt=media\&token=77b6dde0-ddee-4e7b-9d05-9f17318efa43)

{% endstep %}

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

![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2Fxby52tvhGH3e60dj2PQT%2F20.png?alt=media\&token=9fd898c2-a939-466b-8139-3a8f05ae7e4d)
{% 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>