{"id":9166,"date":"2014-10-31T06:25:01","date_gmt":"2014-10-31T06:25:01","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=9166"},"modified":"2022-06-01T13:09:42","modified_gmt":"2022-06-01T13:09:42","slug":"form-26q-file-generated-in-tds-part-1","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/","title":{"rendered":"Form 26Q file generated in TDS-Part 1"},"content":{"rendered":"

In our blog Greytrix TDS \u2013 Quarterly E-TDS return we have discuss about E-filling process through Greytrix TDS module. In E-TDS, the generation of Form 26Q txt file is the main step where Challan details are actually captured in the text file for a selected quarter and then it is validated through the file validation utility. In this blog we will discuss about content of the txt (form26Q) file generated from the TDS module for E-TDS process.
\nThe TXT file generated from Form 26Q\/27Q Report UI mainly consist of four parts as follows:
\n1. File header.
\n2. Batch header.
\n3. Challan details.
\n4. Deductee details.
\nNew Stuff<\/strong><\/span>: New Feature in Statutory form<\/a>
\nWe will discuss about each section of the TXT file one by one.
\n1. File header:<\/strong>
\nWe will discuss about each section of the TXT file one by one.<\/p>\n

File header record contains the fields like the TAN of the deductor, Utility name, file sequence number etc. Please refer below table for all the file records
\nExample:<\/p>\n

1^FH^NS1^R^13102014^1^D^PNEP10061C^1^GreytrixTDSUtility^^^^^^^^<\/strong><\/p>\n

To separate the each field we use \u201c^\u201d<\/strong> this character.<\/p>\n

\"header<\/a><\/p>\n

\"header<\/a><\/p>\n

2. Batch header:<\/strong>
\nBatch header record mainly contains company\/ personal\/ government level details. Basically it contains following fields to be mention given in tabular format below.
\n\"batch<\/a>
\n\"batch<\/a>
\n\u2022 This field\u2019s display is in txt file as follows:
\n2^BH^1^0^26Q^^^^^^^^TAN0765457^^^201516^201415^Q2^Sample Company Inc.^^123 Sample Company Plaza^^^^^19^12345^aahan@Greytriindia.com^999^6954528^N^A^Mr. Smith^Project Co-ordinator^Greytrix, Block No 402^Mahinder Chembers,^W T Patil Road^Chembur^^19^346465^smith@greytrix.com^^555^555555555555^N^.00^^^^N^^^^PAOCDNOTAVBL^DDOCDNOTAVBL^^^^^^^^^^^^^<\/strong>
\nIn our next blog we will discuss about the challan details section and deductee details section.<\/p>\n","protected":false},"excerpt":{"rendered":"

In our blog Greytrix TDS \u2013 Quarterly E-TDS return we have discuss about E-filling process through Greytrix TDS module. In E-TDS, the generation of Form 26Q txt file is the main step where Challan details are actually captured in the text file for a selected quarter and then it is validated through the file validation\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,4],"tags":[1012,1146,2142,2357],"class_list":["post-9166","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","category-tds","tag-form26q","tag-greytrix-tds","tag-quaterly-etds-returns","tag-sage-300-erp"],"yoast_head":"\nForm 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Form 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our blog Greytrix TDS \u2013 Quarterly E-TDS return we have discuss about E-filling process through Greytrix TDS module. In E-TDS, the generation of Form 26Q txt file is the main step where Challan details are actually captured in the text file for a selected quarter and then it is validated through the file validation\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-31T06:25:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-01T13:09:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/\",\"name\":\"Form 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png\",\"datePublished\":\"2014-10-31T06:25:01+00:00\",\"dateModified\":\"2022-06-01T13:09:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Form 26Q file generated in TDS-Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Form 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/","og_locale":"en_US","og_type":"article","og_title":"Form 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our blog Greytrix TDS \u2013 Quarterly E-TDS return we have discuss about E-filling process through Greytrix TDS module. In E-TDS, the generation of Form 26Q txt file is the main step where Challan details are actually captured in the text file for a selected quarter and then it is validated through the file validation\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-10-31T06:25:01+00:00","article_modified_time":"2022-06-01T13:09:42+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/","name":"Form 26Q file generated in TDS-Part 1 - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png","datePublished":"2014-10-31T06:25:01+00:00","dateModified":"2022-06-01T13:09:42+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/10\/header-field1-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/form-26q-file-generated-in-tds-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Form 26Q file generated in TDS-Part 1"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=9166"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9166\/revisions"}],"predecessor-version":[{"id":31411,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9166\/revisions\/31411"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=9166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=9166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=9166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}