Help on Enable Macro (Enable Validate button):

FOR EXCEL 2010 :-To "Enable Macro" please follow steps below.

1234

FOR EXCEL 2007 :To "Enable Macro" please follow steps below.

1234

FOR OTHER EXCEL VERSIONS :To "Enable Macro" please follow steps below.

1234

Change your regional date option from "Control Panel --> Region and Language" to "English(Unites States)"Please click on "validate" button to check errors in excel sheet. If there is no error in excel sheet then upload file gets generated.Numeric fields in the whole sheet will accept numbers of length maximum 15 digits. In case if data is of length more than 15 digits, system shall accept '0' for digits after 15 charactersNote : While opening excle template in a MS Excel 2003, excel macro will not work properly. To avoid this problem, upgrade yourMS Excel 2003 version with Service Pack 3.While opening excle template in a MS Excel 2007, excel macro will not work properly. To avoid this problem, upgrade yourMS Excel 2007 version with Service Pack 2.While opening MS Excel 2003 template in a MS Excel 2007/2010 version for the first time, Due to security features of MS Excel macro will remain disable by default, you need to first enable macro in MS Excel 2007/2010 and reopen the template.

Help on Enable Macro (Enable Validate button):

To "Enable Macro" please follow steps below.

Click Trust Center, click Trust Center Settings, and then click Macro Settings.Select "Enable all macros". Click on 'OK'.Open the file again.

To "Enable Macro" please follow steps below.

Click Trust Center, click Trust Center Settings, and then click Macro Settings.Select "Enable all macros". Click on 'OK'.Open the file again.

FOR OTHER EXCEL VERSIONS :To "Enable Macro" please follow steps below.

Open the file again.

Fields marked in white color is enabled and data can be entered in that field.Fields marked in Grey color is Disabled.

Change your regional date option from "Control Panel --> Region and Language" to "English(Unites States)"

Click the File Menu (Office BackStage), and then select Options from the left sidebar.

Click the Microsoft Office Button , and then click Excel Options.

Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the security level to Low by clicking the Low radio button.Close the file and any other instances of the application currently running on the computer (close all excel applications that also use the application you are currently running).

Click the Enable button to allow the macro to run.

Please click on "validate" button to check errors in excel sheet. If there is no error in excel sheet then upload file gets

Numeric fields in the whole sheet will accept numbers of length maximum 15 digits. In case if data is of length more than 15 digits, system shall accept '0' for digits after 15 characters

While opening excle template in a MS Excel 2003, excel macro will not work properly. To avoid this problem, upgrade yourMS Excel 2003 version with Service Pack 3.While opening excle template in a MS Excel 2007, excel macro will not work properly. To avoid this problem, upgrade yourMS Excel 2007 version with Service Pack 2.While opening MS Excel 2003 template in a MS Excel 2007/2010 version for the first time, Due to security features of MS Excel macro will remain disable by default, you need to first enable macro in MS Excel 2007/2010 and reopen the template.

Section Name Field Error DescriptionSr. No.

Reference Cell

Resident Individual Income Tax Return

Section A Part 1 : Return InformationA006595629HOriginal

01/01/201431/12/2014

NoNoNo

NoNo

NoNoNo

No

NoNo

Section A Part 2 : Bank Details Description Details

Section A Part 3 : Details of AuditorDescription Details (Self)

PIN of AuditorName of Auditor

Personal Identification Number *Type of Return *Return Period From *Return Period To *Do you have any income other than employment income? *Do you have partnership income? *Do you have estate trust income? *Has your employer provided you with a car? *Do you have a mortgage? *Do you have a Home Ownership Savings Plan? *Do you have a life insurance policy? *Do you have a commercial vehicle? *Do you earn any income from a foreign country? *Have you been issued the Exemption Certificate for disablity? *Do you want to declare Wife's Income? *Wife's PIN *Does your wife have any income other than employment income? *Does your wife have been issued the Exemption Certificate for disablity? *

Bank Name *Branch Name *City *Account Holder's Name *Account Number *

Date of Audit CertificateSection A Part 4 : Landlord Details (Self)

PIN of Landlord (If Available) Name of Landlord

Total

Section A Part 4 : Landlord Details (Wife)

PIN of Landlord (If Available) Name of Landlord

Total

Section A Part 5 : Tenant Details (Self)

PIN of Tenant (If Available) Name of Tenant

Total

Section A Part 5 : Tenant Details (Wife)

PIN of Tenant (If Available) Name of Tenant

Total

Section A Part 6 : Details of Exemption Certificate for disablity (Self)Exemption Certificate Number Date From

Section A Part 6 : Details of Exemption Certificate for disablity (Wife)Exemption Certificate Number Date From

Resident Individual Income Tax Return

Version 8.0.02013 2012

ORIGINAL 01/01/201301/01/2014 201431/12/2014

N

30/06/2015 01/01/2015 31

12

2014

Section A Part 3 : Details of AuditorDetails (Wife)

N N

Section A Part 4 : Landlord Details (Self)Physical Full Address

L.R.Number Building Street/Road

Total

Section A Part 4 : Landlord Details (Wife)Physical Full Address

L.R.Number Building Street/Road

Total

Section A Part 5 : Tenant Details (Self)Physical Full Address

L.R.Number Building Street/Road

Total

Section A Part 5 : Tenant Details (Wife)Physical Full Address

L.R.Number Building Street/Road

Total

Section A Part 6 : Details of Exemption Certificate for disablity (Self)Date To spouseCode

Section A Part 6 : Details of Exemption Certificate for disablity (Wife)Date To spouseCode

2011 2010

st

December

Physical Full AddressCity/Town County District

Total

Physical Full AddressCity/Town County District

Total

Physical Full AddressCity/Town County District

Total

Physical Full AddressCity/Town County District

Total

SpouseCode

0

0

8.0.0 2

XLS EXCEL 1997-20032 9

Physical Full Address Postal AddressTax Area / Locality Descriptive Address P.O.Box

Total

Physical Full Address Postal AddressTax Area / Locality Descriptive Address P.O.Box

Total

Physical Full Address Postal AddressTax Area / Locality Descriptive Address P.O.Box

Total

Physical Full Address Postal AddressTax Area / Locality Descriptive Address P.O.Box

Total

Postal Address Period of Occupancy During the YearPost Office Name Postal Code Date From

Total

Postal Address Period of Occupancy During the YearPost Office Name Postal Code Date From

Total

Postal Address Period of Occupancy During the YearPost Office Name Postal Code Date From

Total

Postal Address Period of Occupancy During the YearPost Office Name Postal Code Date From

Total

Period of Occupancy During the YearDate To

strSpouseCode

Total 0.00

Period of Occupancy During the YearDate To

strSpouseCode

Total 0.00

Period of Occupancy During the YearDate To

strSpouseCode

Total 0.00

Period of Occupancy During the YearDate To

strSpouseCode

Amount of Gross Rent Paid or Payable (Ksh)

Amount of Gross Rent Paid or Payable (Ksh)

Amount of Gross Rental Income (Ksh)

Amount of Gross Rental Income (Ksh)

Total 0.00

Rent Code

Rent Code

Rent Code

Rent Code

Section F : Details of Employment Income(Self)PIN of Employer Name of Employer

P000598593S 628,925.00

Total

Section F : Details of Employment Income(Wife)PIN of Employer Name of Employer

Total

Gross Pay (Ksh)(A)

AGA KHAN UNIVERSITY HOSPITAL NAIROBI

Gross Pay (Ksh)(A)

Section F : Details of Employment Income(Self)

0.00 0.00 0.00

Total

Section F : Details of Employment Income(Wife)

Total

Allowances and Benefits from

Employment (Other than Car and

Housing) (Ksh) (B)

Value of Car Benefit (Total of "Value of Car Benefit" from I_Computation_

of_Car_Benefit)(Ksh) (C)

Net Value of Housing (Ksh)

(D)

Allowances and Benefits from

Employment (Other than Car and

Housing) (Ksh) (B)

Value of Car Benefit (Total of "Value of Car Benefit" from I_Computation_

of_Car_Benefit)(Ksh) (C)

Net Value of Housing (Ksh)

(D)

0.00 628,925.00 H

Total 628,925.00

Total 0.00

Pension if in excess of 300,000 (Ksh)

(E)

Total Employment Income

(Ksh) (F) = (A+B+C+D+E)

Pension if in excess of 300,000 (Ksh)

(E)

Total Employment Income

(Ksh) (F) = (A+B+C+D+E)

Section M : Details of PAYE Deducted at Source from Salary (Self)PIN of Employer Name of Employer Taxable Salary (Ksh)

P000598593S 598,325.00

Total

Section M : Details of PAYE Deducted at Source from Salary (Wife)PIN of Employer Name of Employer Taxable Salary (Ksh)

Total

AGA KHAN UNIVERSITY HOSPITAL NAIROBI

Section M : Details of PAYE Deducted at Source from Salary (Self)

120,618.00 106,674.00 13,944.00

Total 106,674.00

Section M : Details of PAYE Deducted at Source from Salary (Wife)

Total 0.00

Tax Payable on Taxable Salary (Ksh)

(A)

Amount of Tax Deducted(PAYE)

(Ksh)(B)

Amount of Tax Payable or

Refundable (PAYE) (Ksh)(C) = (A-B)

Tax Payable on Taxable Salary (Ksh)

(A)

Amount of Tax Deducted

(PAYE) (Ksh)(B)

Amount of Tax Payable or

Refundable (PAYE) (Ksh)(C) = (A-B)

spouse code

H

spouse code

Section Q : Details of Income Tax Paid in Advance (Self)Section Q1 : Advance Payment

Date of Deposit

Total 0.00

Section Q2 : Self Assessment TaxDate of Deposit

Total 0.00Total (Section Q1 Total + Section Q2 Total) 0.00

Section Q : Details of Income Tax Paid in Advance (Wife)Section Q1 : Advance Payment

Date of Deposit

Total 0.00

Section Q2 : Self Assessment TaxDate of Deposit

Payment Registration Number

Amount of Income Tax Paid (Ksh)

schedule code

Payment Registration Number

Amount of Income Tax Paid (Ksh)

schedule code

Payment Registration Number

Amount of Income Tax Paid (Ksh)

schedule code

Payment Registration Number

Amount of Income Tax Paid (Ksh)

schedule code

Total 0.00Total (Section Q1 Total + Section Q2 Total) 0.00

spouse

code

spouse

code

spouse

code

spouse

code

Section T : Tax ComputationSr. No. Description

11 Total Deduction (11.1+ Higher value of 11.2 or 11.3)

11.1 Defined / Pension Contribution

11.2

11.3

12

12.1

12.212.3 Allowable Tax Exemption in case of Person with Disablility12.412.5 Tax on Taxable Income (12.4 *applicable rates)12.6 Personal Relief

12.7

13 Tax Credits (13.1+13.2+13.3+13.4+13.5+13.6+13.7)

13.1

13.2

13.3

13.4

13.5

13.613.7 Credits u/s 41 (Total of "Amount of Tax Relief" from R_DTAA_Credits)

14

Mortgage Interest (Total of "Amount of Interest Paid" from J_Computation_of_Mortgage but subject to Maximum 1,50,000 Ksh)Deposit in Home Ownership Saving Plan (Total of "Total Deposit for the Year" from K_Home_Ownership_Saving_Plan but subject to Maximum 48,000 Ksh)Total of Tax Payable Less Reliefs and Exemptions (12.5 - 12.6 - 12.7)

Employment Income ("Total Taxable Employment Income" from F_Employement_Income)Taxable Income from Estate(s)/Trust(s)/Settlement (Total of "Amount of Share of Income (Ksh)" from H_Estate_Trust_Income)Net Taxable Income (12.1+ 12.2+Line Number 9 (Consolidated) - 11-12.3)

Insurance Relief (Total of "Amount of Insurance Relief " from L_Computation_of_Insu_Relief but subject to Maximum 60,000 Ksh)

PAYE Deducted from Salary (Total of "Amount of Tax Deducted (PAYE)" from M_Details_of_PAYE_Deducted)Allowable Tax in case of Estate(s)/Trust(s)/Settlement ((Total of "Amount of Share of Income from H_Estate_Trust_Income) * 30%)Total Installment Tax Paid (Total of "Amount of Installment Tax Paid" from N_Installment_Tax_Credits)Withholding Tax (Total of "Withholding Tax Amount" from O_WHT_Credits)Credits u/s 12A - Advance Tax on Commercial Vehicle (Total of "Amount of Advance Tax Paid" from P_Advance_Tax_Credits)Income Tax Paid in Advance (Total of "Amount of Income Tax Paid" from Q_IT_Payment_Credits)

Tax Due / (Refund Due) ((12 (Self) + 12 (Wife) - 13(Self) - 13 (Wife))

Section T : Tax ComputationSelf (Ksh) Wife (Ksh)

0.00 0.00

0.00 0.00

0.00 0.00

#VALUE! #VALUE!

628,925.00 0.00

0.00 0.000.00 0.00

628,925.00 0.00#VALUE! #VALUE!

0.00 0.00

106,674.00 0.00

106,674.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.000.00 0.00

#VALUE! 0.00

Interest

Tax

Keep