{"id":18645,"date":"2024-09-05T15:25:16","date_gmt":"2024-09-05T09:55:16","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=18645"},"modified":"2024-09-05T15:25:16","modified_gmt":"2024-09-05T09:55:16","slug":"gstr-9c-format-in-excel","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/gstr-9c-format-in-excel\/","title":{"rendered":"GSTR-9C Excel Format: How to View GSTR-9 Draft in Excel Format on GST Portal"},"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\">Key Takeaways<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mandatory Filing:<\/strong> GSTR-9C is required annually for businesses with turnover above \u20b92 Crore to comply with GST.<\/li>\n\n\n\n<li><strong>Reconciliation Tool:<\/strong> It reconciles the taxpayer&#8217;s GSTR-9 with audited financial statements.<\/li>\n\n\n\n<li><strong>Utility Features:<\/strong> The Excel format includes tools for JSON generation, error checking, and data validation.<\/li>\n\n\n\n<li><strong>Easy Download:<\/strong> The GSTR-9C tool can be downloaded from the GST portal in ZIP format.<\/li>\n\n\n\n<li><strong>Detailed Sections:<\/strong> The form covers turnover, tax paid, ITC reconciliation, and any additional liabilities.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p><strong>GSTR 9C format in Excel <\/strong>helps taxpayers or entities view and download the form for annual return filing purposes. Entities with high turnover during a financial year need to file this return to align with the tax norms in India. Learn the process to view and download this form here for seamless annual return filing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Is GSTR-9C?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Is-GSTR-9C-1-1024x576.png\" alt=\"What Is GSTR-9C??\" class=\"wp-image-19087\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Is-GSTR-9C-1-1024x576.png 1024w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Is-GSTR-9C-1-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Is-GSTR-9C-1-768x432.png 768w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Is-GSTR-9C-1.png 900w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>GSTR 9C is an annual audit form under the Goods and Services Tax (GST) regime which needs to be filed annually. It applies to businesses with turnover exceeding \u20b92 Crore annually. In other words, it is a reconciliation statement that helps reconcile values of annual GSTR-9 and audited<a href=\"https:\/\/www.investopedia.com\/terms\/f\/financial-statements.asp\" target=\"_blank\" rel=\"noopener\"> financial statements<\/a> of a taxpayer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Multiple Features in the GSTR 9C Offline Utility<\/strong><\/h2>\n\n\n\n<p>Here are the features of <strong>the GSTR-9C format in Excel<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can find the GSTR-9C JSON file after downloading it from the GST portal.<\/li>\n\n\n\n<li>The GSTR-9C error file is further available after you download it from the GST portal.<\/li>\n\n\n\n<li>You can generate the GSTR-9C JSON file for upload on the GSTIN portal.<\/li>\n\n\n\n<li>As a taxpayer, you can preview the draft GSTR-9C form by generating a PDF.<\/li>\n\n\n\n<li>The data entered, validates the data in the sheet.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to Download GSTR 9C Offline Utility in Excel<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How To File GSTR9C Annual Return  2022-23 | filing of GSTR9C for fy 2022-23 | GSTR9C filing\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/s4NAOb2bMV8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Here are the steps to download <strong>GSTR-9C format in Excel:<\/strong><\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Visit the official unified GST portal and click on the &#8216;Download&#8217; option on the main menu.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Select \u2018Offline Tools\u2019 and click on \u2018GSTR-9C Offline Tool\u2019.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>You will be redirected to a new page containing the download link. Click on the link to download the ZIP format of the document.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Are the Sections to Be Filled in Form GSTR-9C?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C-1024x576.png\" alt=\"What Are the Sections to Be Filled in Form GSTR-9C?\" class=\"wp-image-19090\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C-1024x576.png 1024w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C-768x432.png 768w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C-1536x864.png 1536w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/09\/What-Are-the-Sections-to-Be-Filled-in-Form-GSTR-9C.png 900w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>GSTR-9C has the following parts that need to be filled in:<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/11PU04ML_CDbonz-WtuFERAWf6kVr80C4\/edit?usp=drive_link&amp;ouid=107101448778203751569&amp;rtpof=true&amp;sd=true\" target=\"_blank\" rel=\"noopener\"><strong>Download GSTR-9C in Excel Format: <\/strong><\/a><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Part A: Reconciliation Statement<\/strong><\/h3>\n\n\n\n<p>The reconciliation statement has 5 parts as mentioned below:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Part I: Basic details<\/strong><\/h4>\n\n\n\n<p>This part consists of the financial year, GSTIN, legal and trade name. In this part, the taxpayer needs to declare if he\/she is under audit under any law.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Part II: Reconciliation of Turnover Declared in Audited Financial Statements and the One Declared in <a href=\"https:\/\/www.investopedia.com\/terms\/a\/annual-return.asp\" target=\"_blank\" rel=\"noopener\">Annual Return<\/a><\/strong><\/h4>\n\n\n\n<p>This part mandates a declaration of gross and net taxable turnover in the annual return, similar to the audited financial statements.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Part III: Reconciliation of Tax Paid<\/strong><\/h4>\n\n\n\n<p>This section mandates reporting of tax liability in the order of GST rate in accordance with GSTR-9. Additionally, taxpayers need to mention other liabilities due to unreconciled differences identified during reconciliation in the tables of this part.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Part IV: Reconciliation of ITC (input tax credit)<\/strong><\/h4>\n\n\n\n<p>This part mandates reconciliation of ITC that<a href=\"https:\/\/www.merriam-webster.com\/dictionary\/taxpayer#:~:text=Legal%20Definition-,taxpayer,is%20liable%20for%20a%20tax\" target=\"_blank\" rel=\"noopener\"> taxpayers<\/a> avail or utilise, in accordance with GSTR-9 and the Audited Financial Statement.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Part V: Additional Liability Due to Non-reconciliation<\/strong><\/h4>\n\n\n\n<p>This section requires declaring additional liabilities from turnover or ITC discrepancies, any amounts not covered in the annual return but paid for supplies, incorrect refund claims, and outstanding demands that need to be settled.<\/p>\n\n\n\n<p>Filling in all the parts helps taxpayers complete the GSTR-9C filing process, thereby aligning with the tax norms during an assessment year.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p><strong>GSTR 9C format in Excel <\/strong>can be viewed seamlessly on the official unified GST portal. As a taxpayer, you can further download the form in ZIP format to view it. Viewing the form will help you understand whether the details entered in the form are correct thereby proceeding to file annual returns.<\/p>\n\n\n\n<p class=\"has-ast-global-color-4-background-color has-background\">\ud83d\udca1If you want to pay your GST with Credit Card, then download\u00a0<a href=\"https:\/\/play.google.com\/store\/apps\/details?id=one.pice.pice_business_loan&amp;_branch_match_id=1260478299341712556&amp;utm_source=website&amp;utm_campaign=homepage&amp;utm_medium=website&amp;_branch_referrer=H4sIAAAAAAAAA8soKSkottLXz8wryyxJ1SvITE5NLCjQS87P1S9PTcrIz00FAMR0ueciAAAA\" target=\"_blank\" rel=\"noreferrer noopener\">Pice Business Payment App<\/a>. Pice is the one stop app for paying all your business expenses.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">FAQs<\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1725264483320\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What is GSTR-9C, and who needs to file it?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-9C is an annual audit form required for businesses with an annual turnover exceeding \u20b92 Crore. It reconciles the figures reported in GSTR-9 with the audited financial statements. Filing GSTR-9C ensures that the taxpayer&#8217;s financials align with GST returns, making it mandatory for larger businesses to comply with GST laws.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1725264484433\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>How can I download the GSTR-9C format in Excel?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>You can download the GSTR-9C format by visiting the official GST portal. Navigate to &#8216;Downloads&#8217; &gt; &#8216;Offline Tools&#8217; &gt; &#8216;GSTR-9C Offline Tool&#8217; and download the ZIP file. Extract the file to access the Excel utility, which allows you to prepare and validate the GSTR-9C form offline.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1725264491816\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What are the main parts of the GSTR-9C form?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-9C consists of two primary sections: Part A, the Reconciliation Statement, and Part B, the Certification. Part A includes details like turnover reconciliation, tax paid, and ITC reconciliation, while Part B is the certification section, signed by the auditor to confirm the accuracy of the reconciliation.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1725264499368\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What is the purpose of the reconciliation statement in GSTR-9C?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The reconciliation statement in GSTR-9C compares the turnover, tax paid, and input tax credit (ITC) as per the GSTR-9 with those reported in the audited financial statements. Its purpose is to identify and explain any discrepancies, ensuring accurate reporting and compliance with GST regulations.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1725264504864\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>Can I preview the GSTR-9C form before filing?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Yes, you can preview the GSTR-9C form by generating a draft PDF using the offline Excel utility. This feature allows you to review the entered data for accuracy and completeness before uploading the final JSON file to the GST portal, ensuring a smooth filing process.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways GSTR 9C format in Excel helps taxpayers or entities view and download the form for annual return filing purposes. Entities with high turnover during a financial year need to file this return to align with the tax norms in India. Learn the process to view and download this form here for seamless annual [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":19086,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-18645","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\/18645","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=18645"}],"version-history":[{"count":0,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/18645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/19086"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=18645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=18645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=18645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}