{"id":9317,"date":"2014-11-27T14:34:34","date_gmt":"2014-11-27T14:34:34","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=9317"},"modified":"2014-11-27T14:34:34","modified_gmt":"2014-11-27T14:34:34","slug":"reconcile-tds-with-expense-and-balance-sheet-accounts","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/","title":{"rendered":"Reconcile TDS with Expense and Balance sheet accounts"},"content":{"rendered":"<p style=\"text-align: justify\">When we say TDS, we usually deal with the Vendors, Documents like Invoices, Credit\/Debit Notes, Pre-payment, Nature of deductions and TDS sections. Basically these are the major constraints that are a part of the deduction and remittance process for TDS. Even when we file the TDS returns the above points are part of the required files and forms which we generate and submit to the government authorities.<\/p>\n<p style=\"text-align: justify\">There can be scenarios where an auditor might ask you to reconcile the TDS with the general ledger accounts.\u00a0 This will be the accounts that are used in the respective transactions where TDS is being deducted, also this account can be used to calculate balance sheet or income statement.<\/p>\n<p style=\"text-align: justify\"><strong style=\"color: #000000\"><em><span style=\"color: #993366\">New Stuff: \u00a0<\/span><\/em><\/strong><span style=\"color: #0000ff\"><a title=\"Migrating Open Purchase Orders from Sage PRO ERP to Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/migrating-open-purchase-orders-from-sage-pro-erp-to-sage-300-erp\/\" target=\"_blank\"><span style=\"color: #0000ff\"><em><span style=\"color: #993366\">Migrating Open Purchase Orders from Sage PRO ERP to Sage 300 ERP<\/span><\/em><\/span><\/a><\/span><\/p>\n<p style=\"text-align: justify\">Going further the TDS Module of Sage 300 ERP helps us to generate such kind of report that can help us reconcile the TDS amounts with the corresponding general ledger accounts. The purpose of this report is to display the general ledger accounts and the TDS amounts deducted in front of each of them. Just to simplify the report can have the below columns:<\/p>\n<ul style=\"text-align: justify\">\n<li>General Ledger Account and Description.<\/li>\n<li>Document Number.<\/li>\n<li>Debit\/Credit amounts.<\/li>\n<li>Vendor Code<\/li>\n<li>Vendor Name.<\/li>\n<li>TDS Percentage.<\/li>\n<li>TDS Amount.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">From control point of view, we can always ensure that our TDS return values are matching with this report before filling the return. This will help the user to track whether proper sections are being used along with proper general ledger accounts to book the TDS. For example, the total of Rent section in the TDS return should match with the rent accounts total shown in the mentioned report and so on.<\/p>\n<p style=\"text-align: justify\">Thus this report can turn out to be critical when it comes to reconciling the TDS returns before you file it.<\/p>\n<p>Also Read:<br \/>\n1. \u00a0<a title=\"Taxes in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/27\/taxes-in-sage-300-erp\/\" target=\"_blank\">Taxes in Sage 300 ERP<\/a><br \/>\n2.\u00a0<a title=\"Multicurrency in Greytrix TDS\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/30\/multicurrency-in-greytrix-tds\/\" target=\"_blank\">Multicurrency in Greytrix TDS<\/a><br \/>\n3.\u00a0<a title=\"Configuring Greytrix TDS in Sage 300 ERP \u2013 III\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/18\/configuring-greytrix-tds-in-sage-300-erp-iii\/\" target=\"_blank\">Configuring Greytrix TDS in Sage 300 ERP \u2013 III<\/a><br \/>\n4.\u00a0<a title=\"Greytrix TDS \u2013 Quarterly E-TDS Return September Update\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/11\/greytrix-tds-quarterly-e-tds-return-september-update\/\" target=\"_blank\">Greytrix TDS \u2013 Quarterly E-TDS Return September Update<\/a><br \/>\n5.\u00a0<a title=\"Greytrix TDS with PJC Integration\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/31\/greytrix-tds-with-pjc-integration\/\" target=\"_blank\">Greytrix TDS with PJC Integration<\/a><\/p>\n<p style=\"text-align: justify\">\n","protected":false},"excerpt":{"rendered":"<p>When we say TDS, we usually deal with the Vendors, Documents like Invoices, Credit\/Debit Notes, Pre-payment, Nature of deductions and TDS sections. Basically these are the major constraints that are a part of the deduction and remittance process for TDS. Even when we file the TDS returns the above points are part of the required\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\">Read More &raquo;<\/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],"tags":[1146,2185,2187,2515],"class_list":["post-9317","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-greytrix-tds","tag-reconcile-tds-with-general-ledger-accounts","tag-reconciliation-of-tds","tag-sage-tds"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reconcile TDS with Expense and Balance sheet accounts - 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\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconcile TDS with Expense and Balance sheet accounts - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"When we say TDS, we usually deal with the Vendors, Documents like Invoices, Credit\/Debit Notes, Pre-payment, Nature of deductions and TDS sections. Basically these are the major constraints that are a part of the deduction and remittance process for TDS. Even when we file the TDS returns the above points are part of the required\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-27T14:34:34+00:00\" \/>\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=\"2 minutes\" \/>\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\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\",\"name\":\"Reconcile TDS with Expense and Balance sheet accounts - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"datePublished\":\"2014-11-27T14:34:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reconcile TDS with Expense and Balance sheet accounts\"}]},{\"@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":"Reconcile TDS with Expense and Balance sheet accounts - 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\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/","og_locale":"en_US","og_type":"article","og_title":"Reconcile TDS with Expense and Balance sheet accounts - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"When we say TDS, we usually deal with the Vendors, Documents like Invoices, Credit\/Debit Notes, Pre-payment, Nature of deductions and TDS sections. Basically these are the major constraints that are a part of the deduction and remittance process for TDS. Even when we file the TDS returns the above points are part of the required\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-11-27T14:34:34+00:00","author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/","name":"Reconcile TDS with Expense and Balance sheet accounts - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"datePublished":"2014-11-27T14:34:34+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/27\/reconcile-tds-with-expense-and-balance-sheet-accounts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Reconcile TDS with Expense and Balance sheet accounts"}]},{"@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\/9317","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=9317"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9317\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=9317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=9317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=9317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}