{"id":75839,"date":"2025-08-04T19:21:18","date_gmt":"2025-08-04T13:51:18","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=75839"},"modified":"2025-08-04T19:21:22","modified_gmt":"2025-08-04T13:51:22","slug":"gstr-6-excel-format","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/gstr-6-excel-format\/","title":{"rendered":"GSTR 6 Excel Format: Structure &amp; How to File?"},"content":{"rendered":"\n<div class=\"wp-block-group has-background\" style=\"background-color:#f2f5f9\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><strong>Key Takeaways<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GSTR-6 is a mandatory monthly return for Input Service Distributors (ISDs) detailing ITC received and distributed.<\/li>\n\n\n\n<li>The GSTR-6 Excel-based offline tool enables bulk offline data entry and subsequent upload to the GST portal.<\/li>\n\n\n\n<li>It includes 11 key sections such as ISD details, credit distribution, debit\/credit notes, and ISD ledger balances.<\/li>\n\n\n\n<li>The due date for filing GSTR-6 is the 13th of the following month, with a late fee of \u20b950\/day for delays\u2014even for NIL returns.<\/li>\n\n\n\n<li>Failure to file GSTR-6 for over 6 months can lead to cancellation of GST registration, affecting legal and ITC compliance.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>A GSTR 6 is a monthly return statement that an Input Service Distributor files. There are a total of 11 sections in this return. It contains details of ITC received by an input service distributor along with the details of the distribution of ITC. <\/p>\n\n\n\n<p>In this blog, we will walk you through the GSTR-6 Excel format, while highlighting all the associated details that you need to know.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>GSTR 6 Excel &amp; Downloaded Format<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"599\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Excel-Downloaded-Format.jpg\" alt=\"GSTR 6 Excel &amp; Downloaded Format\" class=\"wp-image-76019\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Excel-Downloaded-Format.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Excel-Downloaded-Format-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Excel-Downloaded-Format-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Excel-Downloaded-Format-768x511.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>The official GSTR-6 offline tool (Excel format) helps Input Service Distributors develop their return filings all at once while they are offline and upload them later in bulk at once. Here is a list of some important items in the GSTR-6 Excel format.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-5aa97ea0-2d8f-4bb6-a0b0-5debf464279b\" href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Form.xlsx\">GSTR-6-Form<\/a><a href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/GSTR-6-Form.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-5aa97ea0-2d8f-4bb6-a0b0-5debf464279b\">Download<\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Return for&nbsp; ISD or Input Service Distributor<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This part contains sections such as GSTIN, the name of the registered person, the financial year and the period of return.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcZVgEkVxxbJSYJSMDj6HKCAUdTsaMnHJuvGv-h6SDFTZMcVYG1t72UXbGaB_qVbQssiQfZZxqxAB8eeWLzG13JDQYfWh8VGrmgADrsC3peUefQ7B6AX5Ucjgx1O_LxGdzk5gvgEw?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>From Registered Taxable Persons<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This part has to be auto-populated from the counter-party GSTR-1 and GSTR-5. It has sections that need filling up. Some of them are Invoice, IGST, SGST, CGST, POS and more.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeI-HTSrmVqoa1ZZhkrIa00GhmKvoQRZ5ah2ZYCYzGfXTm-7z7woAPQ8NcmoecjY9OE23Uqp6yTylxyCTnwmWaZCBDQPoOnm2OFIeYIzj6ZtanKXaWci9yU7qZZ01WqmRnMWWQUWA?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Amendments to ISD Received in Earlier Tax Periods<\/strong><\/li>\n<\/ul>\n\n\n\n<p>The &#8216;6A &#8211;&nbsp; Amendments to ISD Credit&#8217; section helps to record the distribution of credit that were made earlier. Some of its important sub-sections include the original and revised recipient\u2019s GSTINs, revised invoice details and amended tax amounts.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcS6hRjnE8uiDhiU4TBfMbD2uWzGqLwrPQodoiXZsOqHP07Fj8UCTX1ZIoP4iDxSrOLugeA31yf_AtRQXlg5W5ID2AQDzPy4lEMEW0TCkasIhVbixFSWcjoQJrqpmykrRT_4o19OA?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Details of &nbsp;Debit \/ Credit Note<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This part contains important details like specifying the type of note, GSTIN, Original Invoice, differential tax return, etc. This helps you to keep track of your debit\/credit note details.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdgIGh2_RSSWfKBnvGFndik9UI1CYqbRvTykIKP_CqNJPge--dXzklrrHkIzxRanRj3LeWgJVfjCrB_bIGR-TS5AgfKiwgMzRo_pqr5Jqtt0z9usrojWAvxZdZle7tCD9jtsfAB0Q?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Amendments of Details Of Credit Debit Notes:&nbsp;<\/strong><\/li>\n<\/ul>\n\n\n\n<p>The &#8216;Amendment of Details of Credit\/Debit Notes&#8217; section helps to keep track of details that come from earlier tax periods. This part consists of some important sections like GSTIN, all three types of GST, total tax available as ITCs and ITC available this month.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfpNVlsUZ5S2Zuy8X83U6HOZmWZEQXS_z8zSut6lRCieyBzKtoFvCJF9zF0FCX0NHeDd3KbNvea-oxiwPphwMb9mBjcELQzRAwmEtcm1XsJYzgO4ZmChREZj1bysdDQ4OygtsuC?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Input Service Distribution<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This part of the GSTR-6 return acts as a summary ITC that is distributed among each unit. It is automatically generated from sheet 5 and contains important details like the GSTIN of the supplier, SAC, GSTIN of the receiver, invoice number etc.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXccPhXks2h9Bgb9hrmhl2xrIT_TwKs8vOaWc-LIW7N2mzFCZRsIeAatW2ihfZk-B-dHb99O3ZOn0U3dzXfQUJ9fUB7Rd44tQBZtmhHcWnpY1EoOs0axM0M8kd13exsIrPFiz5Lp?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>ISD Ledger<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This section contains the basic information about the description, where there is the opening balance and closing balance information of the Input Tax Credit, the various types of GST value and the total section.<\/p>\n\n\n\n<p>You also have to write down a declaration that the information you provide is true and that you have the legal authority to submit this return. Under this section, there is also a part where you need to get the signature of an authorised person.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf1kp21FR_wWieV4kaCkB34oU0W99zoMowKzLEBLM6oD6tlpQLGmj6LkADUjo_f7f8cXRbqVb9sAH-G_QAWlhtzeGWCPfyMqF8dpgfMOjKO6SKtwgzNXdx_nGjfd3xmUajfLxHgXw?key=l2RZviKBpkown3nddXuarQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to File GSTR 6?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"600\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/How-to-File-GSTR-6.jpg\" alt=\"How to File GSTR 6?\" class=\"wp-image-76020\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/How-to-File-GSTR-6.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/How-to-File-GSTR-6-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/How-to-File-GSTR-6-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/How-to-File-GSTR-6-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Here is a step-by-step process you need to follow in order to file this monthly GST return:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to the GST unified portal and log in using your credentials.<\/li>\n\n\n\n<li>Click on the \u201cServices\u201d tab and then click on \u201cReturns\u201d.<\/li>\n\n\n\n<li>Select your financial year and return filing period of the GSTR-6 return in the &#8216;Returns Dashboard&#8217;.<\/li>\n\n\n\n<li>Once you have clicked on GSTR-6, click on \u201cPrepare Online\u201d and enter the required information that includes information on ITC received, amendments in the information provided in the earlier returns and other important information.<\/li>\n\n\n\n<li>Once this part is done, click on the \u201cProceed to file\u201d button.<\/li>\n\n\n\n<li>Review your file\u2019s consolidated summary and complete your submission with a Digital Signature Certificate (DSC) or Electronic Verification Code (EVC).<\/li>\n\n\n\n<li>If there are any kind of late fees applicable, look into the details.<\/li>\n\n\n\n<li>Once you verify all your late fee details, make the payment and submit the form.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Is the Due Date of GSTR-6?<\/strong><\/h2>\n\n\n\n<p>The due date to file a GSTR-6 according to the GST Act is the 13th of month following your relevant tax period. In case of delay, a late fee of \u20b950 per day is applicable. However, it Is important to note that no concession is available for filing NIL returns. The late fees apply even in such cases.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Is the Penalty for Non-Filing of GSTR-6?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"600\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/What-Is-the-Penalty-for-Non-Filing-of-GSTR-6.jpg\" alt=\"What Is the Penalty for Non-Filing of GSTR-6?\" class=\"wp-image-76021\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/What-Is-the-Penalty-for-Non-Filing-of-GSTR-6.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/What-Is-the-Penalty-for-Non-Filing-of-GSTR-6-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/What-Is-the-Penalty-for-Non-Filing-of-GSTR-6-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/What-Is-the-Penalty-for-Non-Filing-of-GSTR-6-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Under the GST Act, late filing of GSTR-6 returns by Input Service Distributors, whether it&#8217;s a NIL return or a normal return, attracts a penalty. If these penalties remain unpaid, they are carried forward and will block future GSTR-6 filings until cleared. <\/p>\n\n\n\n<p>Continued non-payment of previous returns for over 6 months can lead to serious consequences, such as cancellation of GST registration. Losing your GST registration can significantly impact your business operations, especially your ability to claim Input Tax Credit and operate legally.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Who Should File GSTR 6?<\/strong><\/h2>\n\n\n\n<p>All Input Service Distributors have to file a GSTR-6 return. An Input Service Distributor is a special type of taxpayer that gets invoice details for the services consumed by its branches. All of these branches have the same PAN number as the Input Service Distributor.<\/p>\n\n\n\n<p>Filing a GST is mandatory for all ISDs to facilitate the correct way of the ITC distribution process as stated against input services. This monthly return statement helps to make sure that the recipient\u2019s ITC is consistent at regular intervals. Submitting a filed GSTR-6 return is also important to ensure that the credit notes are organised correctly according to the GST laws.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>It is very crucial for input service distributors to file their GSTR-6 within the due date. It helps them to remain compliant with the GST rules and regulations. If you face a penalty for late payments, repay it as soon as possible for tax compliance, as long-term non-compliance might revoke your GST registration. The due date is on the 13th of every month.<\/p>\n\n\n\n<p>Filing GSTR files is a time-consuming activity, and there are repercussions for not filing on time. Hence, most people take help from tax professionals to navigate their tax burden and file their GSTR-6 and other GSTR filings.<\/p>\n\n\n\n<p>\ud83d\udca1If you want to streamline your payment and make GST payments via credit card, consider using\u00a0<a href=\"https:\/\/piceapp.com\/\">the PICE App<\/a>. Explore the PICE App today and take your business to new heights.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>FAQs<\/strong><\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1753944114357\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Who is required to file GSTR-6?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-6 must be filed by every Input Service Distributor (ISD) registered under GST. An ISD is a taxpayer that receives invoices for input services and distributes the Input Tax Credit (ITC) to its branches with the same PAN. Filing GSTR-6 ensures accurate tracking and credit distribution. It is a mandatory monthly return, even if there\u2019s no activity (NIL return).<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944204788\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What is the due date for filing GSTR-6 and what are the late fees?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The due date for filing GSTR-6 is the 13th of the month following the relevant tax period. If you miss the deadline, a late fee of \u20b950 per day is applicable (\u20b925 each for CGST and SGST). This penalty applies even for NIL returns. Delays also affect ITC reconciliation and can lead to further compliance issues.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944212308\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What is the purpose of the GSTR-6 Excel offline tool?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The GSTR-6 offline tool is an Excel-based utility that allows ISDs to prepare their return offline, making it easier to manage bulk data without constant internet access. It includes structured worksheets for entering invoice details, amendments, credit distribution, and summary views. Once filled, a JSON file is generated and uploaded to the GST portal for final submission.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944219389\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What happens if GSTR-6 is not filed for several months?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>If GSTR-6 is not filed for more than 6 consecutive months, the GST authorities may initiate cancellation of the ISD\u2019s GST registration. This affects your ability to claim or distribute ITC and can disrupt operations across all your registered branches. Unpaid late fees also block future filings until cleared. Timely filing is essential for compliance and business continuity.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944227389\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What information is captured in the GSTR-6 return?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-6 captures information such as GSTIN, invoice-wise ITC received, debit\/credit notes, amendments to earlier returns, and distribution of ITC to branches. It also includes an ISD ledger showing opening and closing ITC balances. All these details ensure transparency and accurate credit flow under GST, aligning with compliance norms set by the government.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways A GSTR 6 is a monthly return statement that an Input Service Distributor files. There are a total of 11 sections in this return. It contains details of ITC received by an input service distributor along with the details of the distribution of ITC. In this blog, we will walk you through the [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":76018,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-75839","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gst"],"_links":{"self":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=75839"}],"version-history":[{"count":3,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75839\/revisions"}],"predecessor-version":[{"id":76023,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75839\/revisions\/76023"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/76018"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=75839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=75839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=75839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}