Kenya has been going digital in various government departments and Kenya Revenue Authority (KRA) has been at the fore-front in digitizing it's information management. Over the last 5 years KRA has implemented an on-line system for making various tax returns with the aim of eliminating paper based records for tax returns. The system that was introduced 5 years ago is ITMS that is now being replaced by iTax. The greatest value add in iTax system is that, the tax payer is able to view his/her ledger that shows ALL transactions done with KRA. This will make it easy for tax payers to discuss their tax matters with KRA without having conflicting details regarding the tax payers records at KRA.
The purpose of this blog is not to give you all the details regarding the iTax system, but is to highlight to Kenyan tax payers the need to enhance their Excel skills if they are to be able to use the system well. The iTax system does not allow users to work on-line when inputting details in their tax returns forms. iTax has been designed to only accept data that has been inputted off-line in a standard Excel template that has macros to generate the zipped upload file. To fill in some of the data into the Excel template, the user can import csv files into the Excel template so as to reduce time taken typing data into the template. The template does not allow users to copy or paste data within it, and therefore it has given options for users to import data from csv files.
This therefore means that corporate tax payers will have to design their own templates that link to their operational systems and extracts data for tax returns and then creates csv files to be used when importing data into the iTax template. This will mean that initially corporate organizations need to develop various templates with macros that ensure the process of loading data into the iTax templates is as efficient and error free as possible. Excel experts are going to be of great assistance in this process. Sunesis consulting is already working on templates with macros that can be used for this purpose and is ready to work with organizations to implement their templates.
The purpose of this blog is not to give you all the details regarding the iTax system, but is to highlight to Kenyan tax payers the need to enhance their Excel skills if they are to be able to use the system well. The iTax system does not allow users to work on-line when inputting details in their tax returns forms. iTax has been designed to only accept data that has been inputted off-line in a standard Excel template that has macros to generate the zipped upload file. To fill in some of the data into the Excel template, the user can import csv files into the Excel template so as to reduce time taken typing data into the template. The template does not allow users to copy or paste data within it, and therefore it has given options for users to import data from csv files.
This therefore means that corporate tax payers will have to design their own templates that link to their operational systems and extracts data for tax returns and then creates csv files to be used when importing data into the iTax template. This will mean that initially corporate organizations need to develop various templates with macros that ensure the process of loading data into the iTax templates is as efficient and error free as possible. Excel experts are going to be of great assistance in this process. Sunesis consulting is already working on templates with macros that can be used for this purpose and is ready to work with organizations to implement their templates.
