Find Solutions to Common Issues Related to taxation - tds tcs data feeding and report
If you want to deduct TDS on purchase after cross the gross purchase limit, you can follow the below steps:
1.Enable TDS Feature:
Step 1: Go to the Administration menu and click on Configuration.
Step 2: Select the Feature and Option tab and click on TDS/TCS feature.
Step 3: Check...
You can send TCS report to your CA by email direct from BUSY and export in above format PDF, Excel, Html, csv.
To export file and email or direct email by BUSY Kindly follow the following Steps.
Step 1: To generate TCS Report Go to Display Menu click on TDS / TCS Reports.
Step 2: Click on TCS Collection Details option
Step 3: Select All Category - All References option
Step 4: Select Stating date, Ending date and Report Status as on date.
Step 5: click on OK you will get TCS Details report.
Step 6: If you want to export as you required format in PDF, Excel and want to send by manual email.
Step 7: Export TCS report on desktop or any other local drive and attach to email and send by gmail.com or outlook
Step 8: You can send direct TCS Report from BUSY for that need to do email configuration in BUSY.
Step 9: After configuration of email you can send direct TCS report to your CA or anyone.
Step 10: In TCS Details report click on email option or use ALT + M will popup email window enter details and click on send.
TDS 194Q is not showing for deduct while doing purchase entry because of in account master not specified for party.
Account Master Not Specified for the Party: In order to deduct TDS under section 194Q, you must have specified the correct account master for the party in your BUSY.
Step 1: Go to Administration and click on Masters.
Step 2: Under Master click on Account and click on modify option.
Step 3: Select party which is not showing for TDS 194Q for deduct while doing purchase entry.
Step 4: After modify to party account enter on Group you will get popup of TDS/TCS info for acc. window.
Step 5: Check have you enable or not to TDS on Expense booking and TDS on pymnt./purc.u/s 194Q option.
Step 6: if not than you need to enable TDS on Expense booking option and select under TDS on pymnt./purc.u/s 194Q option Applicable from start or Applicable after limit.
Step 7: Select payee Category as Domestic Company or as per the party's details. and click on OK.
Step 8: click on save. After saving, recheck the purchase voucher to confirm that TDS 194Q is now deducting for the specified party.
If you want to check your TDS data in different ways like JSON, Excel, and more in BUSY, here's how you can do it:
In BUSY software, you can view your TDS data in Excel and PDF formats.
You can also convert it into plain text.
However, please note that BUSY doesn't support viewing TDS data in JSON format.
To export your TDS quarterly returns in Excel and PDF format in BUSY, follow these simple steps:
Step 1: Go to the Display section.
Step 2: Under TDS/TCS reports, choose the reports or forms you need to export in Excel or PDF.
To export your TDS quarterly returns in text format in BUSY, follow these simple steps:
Step 1: Go to the Print/Email/SMS section.
Step 2: Under TDS/TCS Reports, select eTDS Return (Non-Salary). You'll see a file name and a default file location, like C:\BUSYWin\Form26Q.txt. You can leave it as is or change it to your preferred location. Also, choose the file creation date and the relevant quarter.
Step 3: Click Print to create the file. The file will be saved in the folder you selected, and it will have a name like Form26Q.txt.
To rectifying TDS Mismatches , Need to check TDS deducted correctly in BUSY, you can generate TDS reports in the software. These reports will show the details of TDS deductions made for different parties and transactions. You can compare the deducted amounts with the actual TDS rates and verify if they match. Additionally, you can cross-check the TDS entries in the vouchers to ensure they are recorded accurately.
To Generate a TDS Report In BUSY you can follow these steps:
Step 1: Go To Display Menu.
Step 2: Click on TDS/TCS Reports.
Step 3: Enter on TDS Deduction Details (Non - Salary ) option.
Step 4: Choose option: All TDS Category Or Selected Category.
Step 5: Choose TDS References option: All Or pending References
Step 6: Choose TDS Deductee: All Deductee Or One Deductee.
Step 7: Select option for generate TDS reports Starting date,Ending date,status as on. and click on OK.
Step 8: Report will be displayed on the screen. Users can then choose to either export the report to save it in a digital format or print it out as a hard copy for their records or further use.
To set up TCS calculation on bills above a certain amount in BUSY, you can follow these steps:
Step 1: Go to Administration and then click on Configuration .
Step 2: Now click on Features and Options and click on TDS and TCS option.
Step 3: Now Tick on Enable TCS Reporting Option and specify Warning only in option of Warning for TCS in sale under section 206c 1H and same for recipt in the option and save the configuration.
Step 4: Now Go to Administration and then click on Master and select Account.
Step 5: Now create Account by click on Add option if created then click on modify after enter on account group TDS and TCS Info window will come.
Step 6: Now specify the applicability of TCS for the party for 206C Section and save the configuration.
Step 7: Now enter sale voucher and during sale voucher it will select TCS in bill sundry automaticatlly and create reference for TCS In TSC Reference.
Step 8: Now go to Display and click on TCS reports and you can check TSC Report as per your requirement.
To verify if TDS has been deducted correctly in BUSY, you can generate TDS reports in the software. These reports will show the details of TDS deductions made for different parties and transactions. You can compare the deducted amounts with the actual TDS rates and verify if they match. Additionally, you can cross-check the TDS entries in the vouchers to ensure they are recorded accurately.
To Generate a TDS Report In BUSY you can follow these steps:
Step 1: Go To Display Menu.
Step 2: Click on TDS/TCS Reports.
Step 3: Enter on TDS Deduction Details (Non - Salary ) option.
Step 4: Choose option: All TDS Category Or Selected Category.
Step 5: Choose TDS References option: All Or pending References
Step 6: Choose TDS Deductee: All Deductee Or One Deductee.
Step 7: Select option for generate TDS reports Starting date,Ending date,status as on. and click on OK.
Step 8: Report will be displayed on the screen. Users can then choose to either export the report to save it in a digital format or print it out as a hard copy for their records or further use.
The TDS may not be coming in the right ledger account due to incorrect configuration or tagging of the TDS ledger in BUSY. Please ensure that the TDS ledger is properly created and tagged to the relevant transactions for accurate accounting.
Step 1: Go to Administration and click on Masters. Step 2: Under Master click on Account and click on modify option. Step 3: Select party which is not showing for TDS for deduct while doing purchase entry. Step 4: After modify to party account enter on Group you will get popup of TDS/TCS info for acc. window. Step 5: Check have you enable or not to TDS on Expense booking and TDS on pymnt./purc.u/s 194Q option.
Step 6: if not than you need to enable TDS on Expense booking option and select under TDS on pymnt./purc.u/s 194Q option Applicable from start or Applicable after limit.
Step 7: Select payee Category as Domestic Company or as per the party's details. and click on OK.
Step 8: click on save. After saving, recheck the purchase voucher to confirm that TDS 194Q is now deducting for the specified party.
In BUSY, you cannot import tds category through excel. You can import it through Xml process when the configuration will get match with the our company.
Pls follow the below steps for importing through XML :
Step 1: Click on Administration from source company
Step 2: Then Data export import
Step 3: Then export data
Step 4: Then masters, Untick the all option and tick the only tds category
Step 5: Specify the folder path for the export
Step 6: Open the target company
Step 7: Click on Administration
Step 8: Then import data
Step 9: Then mention the folder path which you have exported from the source company
Step 10: Then import it with match configuration.
If there are only few TDS category then you can add it manually in the company.
Pls follow the below steps for creating the TDS Category :
Step 1: Click on administration
Step 2: Then Masters
Step 3: Then TDS Category
Step 4: Then Add the TDS Category, then tax rate for the payee category in the tds with PAN and TDS without PAN column and save it.
To fix the issue related to TDS rates, please follow these steps:
Step 1: Go to the Administration Menu and select Masters, then choose Account and select Modify Mode.
Step 2: Select the respective account from the dropdown menu where you are facing TDS rate issues.
Step 3: While in Modify mode, when you press Enter on the account group, a TDS/TCS information window will appear.
Step 4: Take note of the Payee Category tag under the TDS/TCS information.
Step 5: Similarly, you need to open the respective expense master and note down its TDS category master.
Step 6: Now, go to the Administration Menu and select Masters, then choose "TDS Category" Master and select Modify mode.
Step 7: Select the TDS category for the expense from the dropdown list and open it in Modify mode.
Step 8: Choose the noted Payee category and correct/update the TDS rate, specifying whether it's With PAN or Without PAN.
By following these steps, you will rectify and update the TDS rates for the respective expense, and when you post a voucher, it will deduct the correct TDS percentage.