This document shows the detailed procedure for importing withholding tax code and tax type for Money Market, Term Loan and Inter-company transactions between each pair of accounting centre and counterparty/inter-company.
WHY IS THIS IMPORTANT?
The maintenance of this withholding tax set up is required exclusively only for certain accounting treatment that has special withholding tax provision journal entries.
1. From the Main Menu, select Set Up > Static > Withholding Tax.
2. Click on Action and select New.
3. Click Import. Import Withholding Tax screen displays.
4. Click Template to download CS Lucas template for importing withholding tax.
5. Save the file and open. An Excel sheet will be opened.
6. Fill out the fields on the Excel file. Those with asterisks (*) are mandatory. For more information on each field, see Withholding Tax Maintenance.
7. Go back to the Import Withholding Tax screen, tick on Read File checkbox.
8. Click Choose File. Browse for the file saved in the computer.
9. Click Read File. The values inputted in the Excel file will displays.
10. If there is an error, the user will be prompted with the rows to be corrected. To make corrections, go to the Excel file to make the necessary corrections and click Read File again.
11. If there is no error, click Load.
12. A popup appears to confirm, click Yes.
13. A message showing that it was loaded successfully will be displayed.
14. Approve the withholding set up by ticking on the checkbox of the newly created withholding tax set up and click Action and Approve.
FREQUENTLY ASKED QUESTIONS