Software@Work I. P. Ltd.

Tax Deducted at Source (TDS) is a deduction made by an individual or a company during a payment. However, as per Finance Bill 2021, TDS has to be deducted even in case of purchase of goods, under provision 194Q. 

You will be eligible for deducting TDS under provision 194Q if you purchase goods worth more than Rs 50 lakhs from a single vendor in the same financial year, and if the annual turnover of your business exceeds Rs 10 crore. So, while making payments to the party or while booking the purchase invoice, whichever is earlier, you have to deduct TDS and pay the remainder of the amount. You have to deduct TDS on the amount over and above the threshold limit of 50 lakhs, and calculate tax at 0.1%, if the seller has a PAN, or at 5%, if the seller does not have a PAN.  

Watch this video to know in detail about the section and compliance in TallyPrime: https://www.youtube.com/watch?v=AysxMFjjlCY&t=465s

Configure Masters

TDS Nature of Payment

1. Gateway of Tally > Create > type or select TDS Nature of Payments.
   Alternatively, press Alt+G (Go To) > Create Master > type or select TDS Nature of Payments.
   The TDS Nature of Payment Creation screen appears.
2. Enter the required fields in the TDS Nature of Payment Creationscreen, as applicable.
   1. For TDS Nature of Payment configured below the Threshold Limit.
      
   2. For TDS Nature of Payment configured above the Threshold Limit.
      
      Since there is no threshold limit for the Nature of Payment configured above the Threshold Limit, you can leave the Threshold/exception limit field blank.
3. Press Y to accept the screen. You can also press Enter to save the master screen.

Purchase Ledger

1. Gateway of Tally > Create (create a Purchase ledger, if not available) or Alter (to open a Purchase ledger if you have created it earlier) > type or select Ledger > select Purchase (if you are altering the existing Purchase ledger) > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master/Alter Master > type or select Ledger > select Purchase (if you are altering the existing Purchase ledger) > and press Enter.
2. Under Statutory Details, set the options:
   • Is TDS applicable to Applicable.
   • Nature of Payment to Any.
     If you do not see the TDS field under Statutory Details, press F12 (Configure) and set Provide TDS details to Yes.
     

     Note: If you want to have a default category for a Purchase ledger, you can create two separate ledgers with respective categories. One Purchase ledger with the Nature of Payment configured below the Threshold Limit and the other Purchase ledger with the Nature of Payment configured above the Threshold Limit. However, it is suggested to maintain a single Purchase ledger and keep the Nature of Payment as Any for the ease of bookkeeping

3. Specify the other relevant details in the Purchase ledger screen, as needed.
4. Press Y to accept the screen. As always, you can press Ctrl+A to save the master.

GST Ledgers

1. Gateway of Tally > Create/Alter > type or select Ledger > select CSGT and SGST or IGST (if you are altering any existing GST ledgers) > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master/Alter Master > type or select Ledger > select CSGT and SGST or IGST (if you are altering any existing GST ledgers) > and press Enter.
2. Under Statutory Details, set the options:
   • Is TDS applicable to Applicable.
   • Nature of Payment to Any.
     If you do not see the TDS field under Statutory Details, press F12 (Configure) and set Provide TDS details to Yes.
     
3. Specify the other relevant details in the CGST and SGST or IGST ledger screen, as needed.
4. Press Y to accept the screen. As always, you can press Ctrl+A to save the master.

Record Purchases Below Threshold Limit (Exempt from TDS)

1. While recording a Purchase voucher, select the common Purchase ledger configured for TDS applicability. The TDS Nature of Payment Details screen appears.
   If you want to know how to record a Purchase voucher, then click here.
2. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature Of Pymt.
3. Once you have entered the stock item details, provide CGST details.
   1. Select CGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature Of Pymt.
4. Provide SGST details.
   1. Select SGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature Of Pymt.
5. Provide the Narration, if needed.
6. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.

Record Purchases Above Threshold Limit (TDS Applicable)

While recording a purchase transaction, TallyPrime will notify you once the Threshold Limit is crossed for a particular party. Alternatively, you can track the threshold limit for a party by going to Form 26Q and checking the transactions Under Exemption Limit section. Accordingly, you can deduct TDS in the relevant transaction by selecting the Nature of Payment configured above the Threshold Limit.

Don’t worry if you have already passed the transaction without deducting the TDS amount. You can always alter the transaction, select the relevant Nature of Payment, and apply TDS.

Tip: To easily identify the party that has crossed the threshold limit, you can alter the name of the party. For instance, if the name of the party is ‘Kumar & Sons’, then you can modify the name to ‘Kumar & Sons (TDS applicable)’ or ‘Kumar & Sons*’. For future transactions with the same party, you only have to select the Nature of Payment configured above the Threshold Limit.

As per your business needs, you can record TDS purchases with or without inventory.

1. While recording a Purchase voucher, select the common Purchase ledger configured for TDS applicability. The TDS Nature of Payment Details screen appears.
   If you want to know how to record a Purchase voucher, then click here.
2. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature Of Pymt as you did previously while recording purchase transactions for the party.
3. Once you have entered the stock item details, provide CGST details.
   1. Select CGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature Of Pymt.
4. Provide SGST details.
   1. Select SGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment configured below the Threshold Limit from the List of TDS Nature of Pymt.
      The Purchase voucher appears as shown below:
      
5. Provide the Narration, if needed.
6. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.
   Once you have accepted the voucher, you will see an information message on the screen indicating that you have already crossed the party Threshold Limit.

7. Select No to go back to the transaction, select the appropriate Nature of Payment from the ledgers, and apply TDS.

8. Modify the Nature of Payment in Purchaseledger.
   1. Select the common Purchase ledger. The TDS Nature of Payment Details screen appears.
   2. Select the Nature of Payment configured above the Threshold Limit from the List of TDS Nature Of Pymt.
9. Modify the Nature of Payment in CGSTledger.
   1. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   2. Select the Nature of Payment configured above the Threshold Limit from the List of TDS Nature Of Pymt.
10. Modify the Nature of Payment in SGSTledger.
    1. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
    2. Select the Nature of Payment configured above the Threshold Limit from the List of TDS Nature of Pymt.
11. Select TDS from the List of Ledger Accounts. It will deduct the TDS amount automatically since the party has already crossed the Threshold Limit.
    The Purchase voucher with TDS appears as shown below:
    For future transactions with the same party, you will always select the Nature of Payment configured above the Threshold Limit.
    Similarly, you can also record TDS purchase without inventory by selecting the Nature of Payment configured above the Threshold Limit.
    The Purchase voucher without inventory as shown below:
    

Advance TDS Payment

The latest budget changes also apply to advance payments. Accordingly, you have to keep a track of the threshold limit for a party across payment transactions, and apply TDS accordingly.

The best way to identify such payments is by adding a suitable comment in the Narration of the transaction. For example, you can add ‘Advance TDS Payment’ in the Narration of all such transactions. This will also help you differentiate advance TDS payments from other payments made to the same party, which might include non-trading payments such as hand loans.

Subsequently, you will be able to track the Threshold Limit from the Ledger Voucher report, using the Range (Alt+F12) feature. You only have to enter the keyword used in the Narration to view the relevant payment entries. The Current Total value will give you an idea of the Threshold Limit. You can plan your TDS deductions accordingly by drilling down from the relevant transaction.

Tip: To easily identify the party that has crossed the threshold limit, you can alter the name of the party. For instance, if the name of the party is ‘JK Traders’, then you can modify the name to ‘JK Traders (TDS applicable)’ or ‘JK Traders*’. For future transactions with the same party, you only have to select the Nature of Payment configured above the Threshold Limit.

1. While recording a Payment voucher, enter the Amount to be paid as an advance to your party. The Bill-wise Details for: Party screen appears.
   If you want to know how to record a Payment voucher, then click here.
2. Enter the details in the Bill-wise Details for: Partyscreen.
   1. Select Advance under Type of Ref.
   2. Enter Name for the advance payment.
      For example, you can enter Name as Adv-1, Adv1, etc. as per your reference. The Amount will be prefilled from the Payment voucher screen.
      
3. Provide the Narration, if needed.
   For example, you can add ‘Advance TDS Payment’ in the Narration field to track the advances paid to the party.
   
4. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.

To track the Threshold limit for any particular party using the Range (Alt+F12) feature:

1. Alt+G (Go To) > type or select Ledger Vouchers > select the Ledger > and press Enter.
   Alternatively, Gateway of Tally > Display More Reports > Account Books > Ledger > select the Ledger > and press Enter.
2. Use the Range feature to filter the list of the party in terms of Narration.
   1. Press Alt+F12 (Range) in the Ledger Vouchers screen. The Range of Information in Report screen appears.
   2. Enter the keywords used in the Narration to view the relevant payment entries.
      
   3. Press End of List to go back to the Ledger Vouchers screen. The Ledger Vouchers report will filter the list of the party whose Narration is provided as ‘Advance TDS Payment’.
3. Press Enter to drill down from the relevant transaction to apply TDS.
4. Provide TDS details.
   1. Select TDS from the List of Ledger Accounts. The TDS Nature of Payment Details screen appears.
   2. Select the Nature of Payment configured above the Threshold Limit from the List of TDS Nature Of Pymt to deduct the TDS from the advance payment.
      
5. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.

Note: If the TDS amount is not calculated when the transaction is altered, then you can either enter the TDS amount directly in the field, or delete this transaction and record a fresh one by entering the same values.

Adjust TDS in Purchase As Per Advance Payment

If you are raising a purchase invoice that is higher or lower in value than the original advance amount, then you can adjust the TDS amount in the transaction accordingly.

When Purchase Value Is Higher Than the Advance

If the purchase invoice is higher in value than the original advance amount, then you can deduct the advance from the purchase invoice amount, and enter this balance as the Assessable Value. 

For example, let us say that you had paid an advance of Rs 2 lakhs to Suma & Company and deducted TDS of Rs 200. Now you want to record a purchase invoice of Rs 5 lakhs. Accordingly, you have to enter Rs 3 lakhs as the Assessable Value, by deducting the value of the advance paid. TDS will be calculated accordingly as Rs 300.

Below are the steps to record a Purchase voucher against an advance paid to your party in the Accounting Invoice mode. Similarly, you can also record a Purchase against an advance in Item Invoice mode. With TallyPrime, you can switch between the modes interchangeably by pressing Ctrl+H (Change mode) for recording purchase, based on your requirement.

1. While recording a Purchase voucher, enter the invoice amount. The TDS Nature of Payment Details screen appears.
   If you want to know how to record a Purchase voucher, then click here.
2. Enter details in TDS Nature of Payment Details
   1. Select Nature of Payment configured above the Threshold Limit from the List of TDS Nature Of Pymt as the party has already crossed the threshold limit.
      
   2. Change the Assessable Value manually. The assessable value will be prefilled from the Purchase voucher screen.
      If you do not see the Assessable Value field, then go back to the Purchase voucher screen, press F12 (Configure), and set Modify Tax details for TDS to Yes. Later, on the TDS Nature of Payment Details screen, press F12 (Configure) and set Allow modification of assessable amount to Yes.
3. Provide TDS details.
   1. Select TDS from the List of Ledger Accounts. The TDS Against Advance Payment screen appears.
      
   2. Set Adjust against advance TDS payment to Yes.
   3. Provide the details in TDS Nature of Payment Detailsscreen to settle the bills.
      1. For the Advance paid to the party:
         • Select Asgt Ref under Type of Ref.
         • Select the advance bill paid from Advance Tax Bills screen under Name field. The Nature of Payment and Assessable Amount appears automatically.
      2. For the balance amount entered in the Assessable Value:
         • Select New Ref under Type of Ref.
         • Enter the Name.
         • Select the Nature of Payment from the List of Nature of Pymt(s). The Assessable Amount and TDS will be calculated automatically.
4. Provide the Narration, if needed.
   
5. Press O (Override (accept without conflicts)).
   This will ensure that the transaction does not appear as an uncertain transaction in the Form 26Q.
   However, if you press Y (Accept (accept with conflicts and resolve later)), then the transaction will be accepted with conflicts and will appear under Uncertain Transactions section in the Form 26Q.
   You can press N (Back (go back to the voucher)), if you wish to make changes to the transaction before overriding without conflicts or accepting with conflicts.

When Purchase Value Is Lower Than the Advance

On the other hand, if the purchase invoice is lower in value than the original advance, then TDS will not be applicable, as it was already paid during the original advance. You have to select the Nature of Payment as Not Applicable in the TDS Nature of Payment Details sub-screen.

1. While recording a Purchase voucher, enter the invoice amount. The TDS Nature of Payment Details screen appears.
   If you want to know how to record a Purchase voucher, then click here.
2. Select Not Applicable from the List of TDS Nature Of Pymt, as your entire purchase value is covered under the previous advance.
   The Assessable Value will be prefilled from the Purchase voucher screen.
   
   If you do not see the Assessable Value field, then go back to the Purchase voucher screen, press F12 (Configure), and set Modify Tax details for TDS to Yes. Later, on the TDS Nature of Payment Details screen, press F12 (Configure) and set Allow modification of assessable amount to Yes.
3. In the Bill-wise Details for: Party screen, select the bill against which the advance to the party is recorded.
4. Provide the Narration, if needed.
   
5. Press Y to accept the screen. As always, press Ctrl+A to save the voucher.

Note: TDS will not be deducted for the party whose purchase value is less the advance amount unless the advance amount is completely exhausted.

Purchase Return/Cancellation

If you want to record a return or cancellation against a previous purchase, then you can record this using a debit note and capture the TDS details as per the threshold limit. Ensure that you select the same Nature of Payment that was selected in the original TDS purchase transaction.

For example, if the original purchase had crossed the threshold limit, and you had selected the Nature of Payment configured above the Threshold Limit, then you have to select the same Nature of Payment while recording the return or cancellation.

Below are the steps to record a Debit Note for the return or cancellation against the previous purchase in the Accounting Invoice mode. Similarly, you can also record a Debit Note in Item Invoice mode. With TallyPrime, you can switch between the modes interchangeably by pressing Ctrl+H (Change mode) for recording Debit Note, based on your requirement.

1. While recording a Debit Note, enter the Amount for the return or cancellation against the previous purchase. The TDS Nature of Payment Details screen appears.
   If you want to know how to record a Debit Note for Purchase return or cancellation, then click here.
2. Select the Nature of Payment that was selected in the original TDS purchase transaction. The Assessable Value will be prefilled from the Purchase voucher screen.
3. Provide CSGT details.
   1. Select CGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment that was selected in the original TDS purchase transaction. The Assessable Value will be prefilled from the Purchase voucher screen.
4. Provide SGST details.
   1. Select SGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter in the Amount field. The TDS Nature of Payment Details screen appears.
   3. Select the Nature of Payment that was selected in the original TDS purchase transaction. The Assessable Value will be prefilled from the Purchase voucher screen.
      

      Note: When recording a Debit Note, you may provide the GST details as well. You can provide details such as Supplier’s Debit/Credit No., reason for issuing the note, and Date.

5. Press Enter on the total Amount. The TDS Nature of Payment Details screen appears.
6. Provide the details in TDS Nature of Payment Details screen.
   1. Select Agst Ref under Type of Ref.
   2.  Select the purchase transaction against which you are passing the Debit Note from the Tax Details screen under Name field. The Nature of Payment, and Assessable Amount will appear automatically.
      
   3. Select End of List. The Bill-wise Details for: Party screen appears.
7. In the Bill-wise Details for: Party screen, select the purchase bill against which you are issuing the Debit Note.
   The Debit Note appears as shown below:
   
8. Provide the Narration, if needed.
9. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.

Note: If you want to see the party transaction details in the Form 26Q report, come down to Deduction at Normal Rate section under Deduction Details field. You can drill down further to get the detailed information on the original TDS purchase transaction along with the Debit Note against the purchase recorded for your party.

Navigation to Form 26Q Report:
Alt+G (Go To) > type Form 26Q > and press Enter.
Alternatively, Gateway of Tally > Display More Reports > Statutory Reports > TDS Reports > Form 26Q > and press Enter.

TDS Exemption for Government-Listed Seller

Government-listed sellers are exempt from TDS deduction. This includes entities like State government, Central government, embassies, High Commissions, and so on. If you have any government-listed sellers, then you can easily configure the Deductee Type in the party masters, and set it as exempt. This will ensure that the tax component is calculated appropriately in the transactions with such parties.

Configure Government-Listed Seller

1. Gateway of Tally > Create (create a Government Party ledger, if not available) or Alter (to open a Government Party ledger if you have created it earlier) > type or select Ledger > select Government Party (if you are altering the existing Government Party ledger) > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master/Alter Master > type or select Ledger > select Government Party (if you are altering the existing Government Party ledger) > and press Enter.
2. Under Statutory Details, set the options:
   1. Is TDS Deductable to Yes.
   2. Deductee type to Government.
      If you do not see the Statutory Details field, then press F12 (Configure) and set Provide TDS details to Yes.
   3. Deduct TDS in Same Voucher to Yes.The Deduct TDS in Same Voucher screen appears.
      If you do not see the Deduct TDS in Same Voucher screen, then press F12 (Configure) and set Allow advance entries in TDS master to Yes.
      • Select All Items from the List of Nature of Payments.
   4. Use Advanced TDS Entries to Yes.
      If you do not see this field under Statutory Details, the press F12 (Configure) and set Allow advance entries in TDS master to Yes.
      The Advanced TDS Entriesscreen appears.
      1. Set/Alter Zero/Lower Deduction to Yes. The Zero/Lower Deduction Details screen appears.
      2. Provide the details in Zero/Lower Deduction Detailsscreen:
         • Select Nature of Payment configured above the Threshold Limit from the List of Nature of Payments.
         • Select 197A from the List of Provisions.
           
         • Enter dummy certificate number, for example, 0000 under Certificate No./Date.
         • Enter Applicable From date.
         • Enter Applicable To date.
           The TDS value will be prefilled with 0% as we have selected zero rated.
         • Select End of List twice to return to the Ledger screen.
3. Set the other configurations in the Ledger Creation/Alteration screen, as needed.
4. Press Y to accept the screen. As always, you can press Ctrl+A to save the master.

Record TDS Purchase with Government-Listed Seller

1. While recording a Purchase voucher, select the Party as Government-listed sellers.
   If you want to know how to record a Purchase voucher, then click here.
2. Enter the Amount. The TDS Nature of Payment Details screen appears.
3. Enter the details in TDS Nature of Payment Details screen.
   1. Select the appropriate Nature of Payment from the List of TDS Nature Of Pymt. The Assessable Value will be prefilled from the Purchase voucher screen.
4. Provide CGST details.
   1. Select the CGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter on the Amount. The TDS Nature of Payment Details screen appears.
   3. Select the appropriate Nature of Payment from the List of TDS Nature Of Pymt. The Assessable Value will be prefilled from the Purchase voucher screen.
5. Provide SGST details.
   1. Select SGST from the List of Ledger Accounts. It will calculate the amount automatically.
   2. Press Enter on the Amount. The TDS Nature of Payment Details screen appears.
   3. Select the appropriate Nature of Payment from the List of TDS Nature Of Pymt.
      The Assessable Value will be prefilled from the Purchase voucher screen.
      The Purchase voucher with the party as Government-listed sellers as shown below:
      
      

      Note: Even after CGST and SGST deductions, the TDS will not be deducted because we have already set the party master as exempt from any TDS deductions.

6. Provide the Narration, if needed.
7. Press Y to accept the screen. As always, you can press Ctrl+A to save the voucher.

Note: Before filing quarterly returns, you have to alter the text file and update the details, such as Certificate No. and Remark Code, as per the latest FVU format