Rounding Withholding Tax amount to the nearest rupee and TDS need to calculate on modified amount)

Rounding Withholding Tax amount to the nearest rupee (If less than 10 rupees 50 paise means it should take 10 rupees and if is equal to 50 paise or more than 50 paise means it should take 11 rupees and the base amount of TDS should be on modified gross amount; Below Example (client Requirement) for your kind reference:

Invoice Value (Gross Amount) : 6674.10

Add: CGST amount : 600.67

Add: SGST amount : 600.67

Net Invoice Amount : 7875.44

Calculation of base amount for TDS:

Rounded off Invoice Net Amount : 7875

Less: CGST amount : 600.67

Less: SGST amount : 600.67

Modified Base Invoice Gross amount for TDS calculation: 6673.66

TDS 2% calculated on base amount 6673.66 : 133.47

Final Rounded off TDS amount to be paid: : 133

Dear all, Kindly consider this as an urgent requirement as we are in critical situation; kindly help