• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to sum date wise when date is not an order for 194q calculation

Need some more details. Which tab to total? Which column to Total? Total by Month? By Day? Come on now, help us to help you. We are not mind readers.
 
Total by Party wise with invoice wise and finally by date already i have mentioned in column y related to Sarat medical Agencies what i need.
 
suppose Inv dt 31-07-2021 of Sarat medical agencies is on the last row of statement that total Taxable will be added to 31-07-2021
 
Your explanation is gibberish. Suppose you use a smaller sample and mock up the solution you want to see. We only need to see 8-10 records not thousands to understand the issue.
 
Is it important to know what "194q" means in your thread title? And if so are we supposed to guess what it means?
 
Section 194Q was inserted by the Finance Act 2021, which is applicable from 1st July 2021. Section 194Q applies to a buyer who has a:

  • Turnover of more than Rs.10 crore in the previous financial year.
  • He purchases goods exceeding Rs.50 lakh of value in a year.

Such a buyer has to deduct TDS at the rate of 0.1% on the amounts exceeding Rs.50 lakh. This section is exactly the opposite of section 206C(1H), where TCS must be collected.
 
Back
Top