Withholding Tax (TDS/TCS) End to End Process (Configuration, Transaction, Settlement, Authority Payment with Challan details and Report) in Microsoft Dynamics 365 Finance and Operations: Part-1

Hello and welcome to the next blog. In this blog I will be writing about complete end to end process cycle of withholding tax in D365.

Most of us, post transactions in D365 but payments and settlements perform outside system which ends up in posting manual rentiers for TDS payable and Payments.

No worries, after this post, you will suggest the complete withholding process within system to customer.

Pre-requisite: Enable TDS calculation in General ledger parameters > Sale Tax

So, lets do with the use case.

Scenario: Here are the three steps for end to end process:

  1. All TDS payable transactions in system with following expected entry:

Vendor Debit to TDS Payable Credit

  1. Once process withholding payments process/settlements:

Vendor (Withholding authority) Credit to TDS Payable Debit

  1. Payment Process with challan details:

Vendor (Withholding authority) Debut to Bank Credit

  1. Configuration

Step-1: Create Withholding authority

Navigate, Tax > Indirect Tax > Withholding tax > Withholding tax authority

Step-2: Create Withholding settlement period

Navigate, Tax > Indirect Tax > Withholding tax > Withholding settlement period

Step-3: Create Withholding component group and component code (TDS/TCS)

In this setup, we can specify the section codes e.g. 194 C, 194 J in Indian taxation, perform same steps for both TDS and TCS

Navigate, Tax > Setup > Withholding Tax > Withholding Tax component group/code

Step-4: Create Withholding tax code and “Rate”

Navigate, Tax > Indirect Tax > Withholding tax > Withholding tax code

Step-5: Create Withholding tax group and Map to designer

Navigate, Tax > Indirect Tax > Withholding tax > Withholding tax group

Step-6: Map TAN number for all the addresses which will be used in Transaction posting

This must be done in legal entity addresses and site/warehouse address > Tax information

Step-7: Enable Vendor/Customer master for withholding Tax calculation

Navigate, All vendor/Customer > Edit > Invoice tab

Note: This is mandatory step

  1. Transactions

Step-1: Create Invoice for TDS, Validate TDS amount, Post

Vendor Debit to TDS Payable Credit

Step-2: View withholding tax transactions

Navigate, Tax > Inquiries and Reports > Withholding Tax transactions

  1. Withholding tax Payment and Settlement

Step-1: Process Withholding tax payment process

This step is to process in month end based on settlement frequency defined in setup, this must be run for each TAN number

Navigate, Tax > Withholding tax > Declaration > Withholding Tax Payment

Step-2: View Open transactions in Tax Authority Vendor

Navigate, Vendor > Open > Transactions

TDS Payable Debit to Vendor Credit

Step-3: Payment of Settlements, Create and post Payment journal

Vendor (Tax Authority) Debit to Bank Credit

Step-4: Enter Challan Details

  1. View of final withholding tax payments and settled transactions

Navigate to, Tax > Indirect Tax > Withholding Settlement Period

That is it for this blog, hope this will help you in better process design for customer next time.

Thank you for reading keep sharing in your network. I will be back with next part with some more scenarios.

10 comments

  1. Hi Saurabh!
    Thanks for this nice explanation!
    After filling the challan details in the posted voucher, that challan details are not updated in the Withholding Tax Transactions (from Tax Settlement period page). I made the payment from General Journals. Is it make any difference?
    Please share your experience if you have faced such issues while configuring.
    Thanks & Regards

    Like

  2. Hi Saurabh,
    Nice article, really useful to us.

    One question: How would this process work if we have multiple legal entities but with the same TAN (branches of the same company) ?

    Thanks,

    Pankaj

    Like

  3. Hi there would you mind stating which blog platform you’re using? I’m looking to start my own blog in the near future but I’m having a tough time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S My apologies for being off-topic but I had to ask!

    Like

  4. Hi Saurabh,

    Very useful information.
    Can you please let me know where should we enter the token numbers and how do we genrate the TDS and TCS statemet by using TDS and TCS report.

    Thanks

    Like

  5. We have an option to enter Token Number and how to enter it?
    This will need to download Form 26 Q or Form 26 AS which need to be issues to respective Vendors or customers.

    Like

  6. We have recently migrated from the legacy system to d365. We have brought only Open balances of the vendor to the D365. However, there are some TDS code which is applicable only if the purchase crossed 50 Lakh. But since we have only brought opening balances which is very less than 50 L, the system is not calculating TDS on it. how this scenario will be handled. Users are expecting the system to calculate TDS becoz they already did the transaction more than 50 L in the previous system.

    Like

  7. Hello, How to manage Concessional rate against concession certificate by Vendor for Withholding Tax. Eg. Vendor X has issue certificate to deduct TDS at 1% instead of normal rate of 10%

    Like

Leave a comment