TDS Audit Report

By | October 30, 2020

As we all know that Tax deducted at Source (TDS) is an Addon module for collecting income tax and it is one of the most important add-on developed for Sage 300 ERP. TDS module calculates TDS amount on the required documents and deducts the TDS automatically when the posting of the Invoices and Payments is done.

In some situations, it might happen that the user misses out some of the documents from deduction, and as the posting completes it becomes difficult for the user to find out such entries whose TDS is not deducted or adjustment not created. There could be entries where user cannot identify properly hence to find out such entries we have developed TDS Audit report.

New Stuff:- Bank Master Export Utility

In this blog we will discuss about the TDS Not Deducted Report which is very useful for the users to analyze the TDS Not Deducted Entries. This Report gives the details of such entries. There are 2 criteria that we have checked while generating the report. The criteria are as mentioned below:

  1. Remitted but Adjustment not Created: Entries where both adjustment and Remittance is not created.
  2. Both not Created: Entries where Remittance is created but Adjustment is not created.

To print this report Go to, Tax deducted at Source Module–> D/T Transaction Report–>  TDS Not Deducted Report. The UI is as shown below and has the above mentioned criteria.

Tax Audit Report - User interface
Tax Audit Report-User interface
Non Deducted TDS Batches
Non Deducted TDS Batches

This Report shows detail data like Batch Number, Entry Number, Invoice Number, Vendor Code, Invoice date, Posting date, TDS Amount, TDS Applied or not and late months. This also helps in tracking the Documents easily and verifying if required. Please refer the above screen shot.

Hence this report is very useful when user to wants to know TDS Not Deducted entries and can avoid further complexity. With help of report user will be able to find-out which entries need to be posted through our Manual TDS Posting Utility in TDS Module.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.