Limitation on rules in power query

aam1932

Board Regular
Joined
Jun 2, 2010
Messages
182
Hai,

Can i know that how many number of rules maximum in power query? I have some rules in power query as below, the problem the query not functioning if i add few more query to this.
Really need your help and how to increase numbers rules or any other alternative.

Thank you in advance

[TABLE="width: 562"]
<colgroup><col></colgroup><tbody>[TR]
[TD]if[/TD]
[/TR]
[TR]
[TD][Account Code]="10100"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10101"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10200"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10210"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10300"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10400"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10550"then"04. BS - Investment fund size|07. Properties||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10551"then"04. BS - Investment fund size|07. Properties||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10555"then"01. BS - Fixed Asset Land & Building|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="10560"then"01. BS - Fixed Asset Land & Building|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11100"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11101"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11150"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11200"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11201"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11250"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11260"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11300"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11350"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11400"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11450"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11500"then"04. BS - Investment fund size|07. Properties||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11505"then"01. BS - Fixed Asset Land & Building|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11550"then"04. BS - Investment fund size|07. Properties||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11560"then"01. BS - Fixed Asset Land & Building|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11600"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11650"then"03. BS - Fixed Asset - Investment Property|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="11660"then"03. BS - Fixed Asset - Accum Dep|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12020"then"01. BS - Fixed Asset - Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12030"then"03. BS - Fixed Asset - Investment Property|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12200"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12201"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12210"then"04. BS - Investment fund size|05. Quoted Share||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12211"then"04. BS - Investment fund size|05. Quoted Share||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12212"then"04. BS - Investment fund size|05. Quoted Share||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12300"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12301"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12302"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12351"then"04. BS - Investment fund size|01. Low Risk Assets||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12352"then"04. BS - Investment fund size|01. Low Risk Assets||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12353"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12354"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12355"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12356"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12357"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12358"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12360"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12361"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12362"then"04. BS - Investment fund size|01. Low Risk Assets||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12365"then"04. BS - Investment fund size|02. Secured / Unsecured Credit Facilities||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12400"then"04. BS - Investment fund size|03. Deposits (MYR)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12410"then"05. BS - Investment Assets - MAS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12420"then"04. BS - Investment fund size|08. Unit Trusts Schemes||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12471"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12472"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12473"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12474"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12475"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12476"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12477"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12478"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12479"then"04. BS - Investment fund size|04. Deposits (Foreign)||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12500"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12502"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12504"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12505"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12506"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12510"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12520"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12530"then"BS - Forex unrealised movement|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12540"then"04. BS - Investment (Labuan Re Valuation and Unrealised forex)|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12551"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12552"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12553"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12554"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12555"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12556"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12557"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12560"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12561"then"06. BS - Investment Account - Provision for Impairment|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12562"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12565"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12571"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12610"then"04. BS - Investment fund size|06. Unquoted||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12611"then"04. BS - Investment fund size|06. Unquoted||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12612"then"04. BS - Investment fund size|06. Unquoted||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12614"then"04. BS - Investment fund size|06. Unquoted||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12615"then"04. BS - Investment fund size|06. Unquoted||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12616"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12617"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12618"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12619"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12620"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12651"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12652"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12653"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12654"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12655"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12656"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12657"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12660"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12661"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12662"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12665"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12671"then"06. BS - Investment Account - Accumulated|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12710"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12714"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12715"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12716"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12724"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12810"then"07. BS - Investment Account - Fair Value & AFS Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12820"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12821"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12830"then"04. BS - Investment (Labuan Re Valuation and Unrealised forex)|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12840"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12850"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12860"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12951"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12952"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12953"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12954"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12955"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12956"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12957"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12958"then"06. BS - Investment Account - FVOCI Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12962"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12965"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12966"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="12967"then"07. BS - Investment Account - FVTPL Fair Value|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13100"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13200"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13210"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13300"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13400"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13550"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13555"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="13560"then"02. BS - Fixed Asset - Cost WIP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="18010"and[Account Code]<="18093"then"BS - Bank|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18500"then"BS - Petty Cash|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18550"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18600"then"BS - Interfund|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18650"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18660"then"BS - Interco MRE/MRRD|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18670"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18700"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18701"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18720"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18730"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18750"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18800"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="18900"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19000"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19020"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19050"then"BS - Creditors - Staff LOAN|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19060"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19070"then"BS - Creditors - Staff LOAN|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19080"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19085"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19301"then"08. BS - Investment Account - Dividend Receivable|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19302"then"08. BS - Investment Account - Dividend Receivable|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="19350"and[Account Code]<="19379"then"09. BS - Investment Account - Interest Receivable|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19650"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19651"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19652"then"UW - BS - REINSTATEMENT PREMIUM|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19653"then"UW - BS - PROV FOR LARGE LOSSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19654"then"UW - BS - PROV OS CLAIMS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19655"then"UW - BS - PROV FOR LARGE LOSSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19656"then"UW - BS - PROV OS CLAIMS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19657"then"UW - BS - IBNR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19658"then"UW - BS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19659"then"UW - BS - PRAD|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19670"then"UW - BS - UPR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19671"then"UW - BS - UPR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19672"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19700"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19710"then"BS - Underwriting Deposit|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19711"then"BS - Underwriting Deposit|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19800"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19810"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19811"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19812"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19813"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19814"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19815"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19816"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19817"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19818"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19820"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="19821"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20110"then"UW - BS - PROV OS CLAIMS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20111"then"UW - BS - PROV OS CLAIMS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20112"then"UW - BS - IBNR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20113"then"UW - BS - PROV FOR LARGE LOSSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20114"then"UW - BS - PRAD|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20131"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20140"then"UW - BS - UPR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20141"then"UW - BS - UPR|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20151"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20152"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20153"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20154"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20155"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="20160"and[Account Code]<="20190"then"BS - GST Provision Account|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20191"then"BS - SST PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20300"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20310"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20320"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20330"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20400"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20401"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20410"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20450"then"BS - UW - Provision for Impairment Insurance Receivables|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20500"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20600"then"BS - Underwriting|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="20700"then"BS - Amount Due|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21001"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21002"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21003"then"BS - KIV|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21004"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21005"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21006"then"BS - I&E - Properties|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21007"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21008"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21009"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="21100"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22003"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22005"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22006"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22007"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22009"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22010"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22012"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22017"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22018"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22019"then"BS - Monthly Provision - ME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22020"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22151"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="22155"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="23000"then"04. BS - Investment Others|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="24000"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="25101"then"BS - LOAN|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="25106"then"BS - LOAN|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="25107"then"BS - LOAN|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="25110"then"BS - LOAN INTREST PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="25112"then"BS - LOAN INTREST PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="26001"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="26002"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30011"then"PL - UW - GP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30012"then"PL - UW - GP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30013"then"PL - UW - GP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30014"then"PL - UW - GP|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30050"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30100"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30201"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30202"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30203"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30204"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30205"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30210"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30301"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30302"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30303"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30304"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30351"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30352"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30401"then"PL - UW - COMMISSION|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30402"then"PL - UW - PROFIT COMM|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30410"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30497"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30498"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30499"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30500"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="30602"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="32010"and[Account Code]<="32279"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32501"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32506"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32810"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32820"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32821"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32822"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32830"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32862"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32865"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32866"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="32867"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="34002"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="34003"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37600"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37601"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37602"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37603"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37604"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37650"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37651"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37652"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37653"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37654"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37655"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37656"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37657"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37658"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37660"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37661"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37662"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37665"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37671"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37712"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37713"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37714"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37715"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37810"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37811"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37812"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37813"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37814"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37815"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37816"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37817"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37818"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37819"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37820"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37823"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37825"then"PL - GSSU|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37826"then"PL - IN - INTERCO|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37827"then"PL - IN - INTERCO|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37828"then"PL - MGMT FEES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37830"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37832"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37835"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="37840"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="39101"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="39502"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="39605"then"PL - Other Income|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40010"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40011"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40012"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40013"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40100"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40101"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40102"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40103"then"PL - UW - REINSURANCE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40201"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40202"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40203"then"PL - UW - CLAIMS PAID|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40204"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40205"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40300"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40301"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40302"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40303"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40304"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40305"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40306"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40351"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40352"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40401"then"PL - UW - COMMISSION|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40402"then"PL - UW - PROFIT COMM|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40403"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40410"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40501"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40502"then"PL - UW - EXPENSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40503"then"PL - UW - EXPENSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40504"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40505"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40507"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40508"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40509"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40511"then"PL - UW - EXPENSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40515"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40516"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40600"then"PL - UW - EXPENSES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40700"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40701"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40702"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40797"then"PL - UW - WAKALAH FEES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40798"then"PL - UW - WAKALAH FEES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40799"then"PL - UW - WAKALAH FEES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40800"then"PL - UW - WAKALAH FEES|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40801"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40803"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40804"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40805"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40806"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40807"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40808"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40809"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40810"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="40811"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41000"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41001"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41002"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41003"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41004"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41005"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41007"then"PL - UW - WAKALAH INCOME|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41010"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41011"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41012"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41013"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41015"then"PL - M.E - IVS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41051"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41052"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41053"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41054"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41055"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41056"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41057"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41058"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41060"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41061"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41062"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41065"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41071"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41501"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41502"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41503"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41504"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41505"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41506"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41810"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41820"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41860"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="41861"then"PL - INV INC|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="42001"and[Account Code]<="45508"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="45509"then"PL - GST|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="45510"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="45511"then"PL - UW|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="46001"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="46501"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="46502"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="46503"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="47501"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="47712"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="47714"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="47715"then"PL - SND|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="47830"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48501"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48502"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48503"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48504"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48505"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48506"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48508"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48509"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48510"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48512"then"|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48601"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48602"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48603"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48604"then"PL - I&E - Properties|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48605"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48606"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="48705"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="49101"and[Account Code]<="49601"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49602"then"PL - M.E - OTHERS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49603"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49604"then"PL - Forex Gain/Loss|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49605"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49606"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49608"then"PL - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49609"then"PL - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49610"then"PL - Finance Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49611"then"PL - Finance Cost|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49613"then"|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49614"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49615"then"PL - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49616"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49700"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="49710"then"PL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="50005"then"BS - UW CLIENT - OTHERS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="50006"then"BS - UW CLIENT - OTHERS|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="55001"then"BS - Underwriting Control Account|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60005"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="61001"and[Account Code]<="61200"then"BS - DEBTOR LSR TSD - Acc 61001 to 61200|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="65010"and[Account Code]<="65030"then"08. BS - Investment Account - Broker|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="65700"then"08. BS - Investment Account - Control Account|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="66001"and[Account Code]<="66118"then"BS - Debtors Properties|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="7E004"then"11. BS - Creditors - Supplier - Acc 7A001 to 7Z999|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70004"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70005"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70006"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70008"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70009"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70010"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70011"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70055"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70057"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="70701"and[Account Code]<="71007"then"BS - MAS - SALARY RELATED PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="71021"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="71101"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="71106"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="71402"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="73012"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="74001"then"BS - KIV|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85010"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85020"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85021"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85030"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85040"then"BS - SHARE CAPITAL|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85050"then"07. BS - Investment Account - Fair Value & AFS Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85055"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85060"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85061"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85062"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85063"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85064"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85065"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85066"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85067"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85068"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85069"then"BS - UW CLIENT - CREDIT CONTROL - Acc 50Axx to 50Zxx|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85070"then"06. BS - Investment Account - FVOCI Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85075"then"BS - TAX|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85082"then"07. BS - Investment Account - FVTPL Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85085"then"07. BS - Investment Account - FVTPL Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85086"then"07. BS - Investment Account - FVTPL Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="85087"then"07. BS - Investment Account - FVTPL Reserves|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="99999"then"BS - MAS - PAYABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="501II"and[Account Code]<="50ZZZ"then"BS - UW CLIENT - CREDIT CONTROL - Acc 50Axx to 50Zxx|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="551II"then"BS - UW CLIENT|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="55A52"and[Account Code]<="55ZZZ"then"BS - UW CLIENT - RESERVE - Acc 55Axx to 55Zxx|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60CAB"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60CCM"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60HLD"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60ILH"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60LAB"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MBB"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MID"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MIP"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MRC"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MRD"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MRDC"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MRE"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MRT"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MSB"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60MTD"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60PIA"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60PNB"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60RMC"then"BS - MAS - RECEIVEABLE|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60SCS"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60SHM"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60SSB"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60TFA"then"BS - Amount Due - other|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60TIB"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="60TIG"then"BS - Interco|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="621II"then"BS - UW CLIENT|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="62A52"and[Account Code]<="62ZZZ"then"BS - UW CLIENT - Acc 62Axx to 62Zxx|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="70005D"then"BS - MAS - PAYABLE - Other Debt/Cred|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="72AD1"and[Account Code]<="72LW5"then"BS - UW CLIENT - Acc 72Axx to 72Zxx|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="73A01"and[Account Code]<="73Z99then"10. BS - Creditors - Staff - Acc 73A01 TO 73Z99|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="7A001"and[Account Code]<="7Z999"then"11. BS - Creditors - Supplier - Acc 7A001 to 7Z999|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]="99999Z"then"|||"else if[/TD]
[/TR]
[TR]
[TD][Account Code]>="R1010"and[Account Code]<="7Z999"then"PL - M.E|||"else if[/TD]
[/TR]
[TR]
[TD]"to check"[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
thank for your consent,

actually this all my account code (general ledger), for reporting purposes, any to grouping the account code as per requirement. Example account code 10100 to 10500 should group under Fixed Asset. i also have situation that if that account negative figure should under different group and positive different group.

Hope you understand what i want to do

thank you
 
Upvote 0
If you are trying to build a P&L, you should use a different approach. You need a chart of accounts that has all the account codes in a column, then extra columns for the roll ups. You also ideally would have a header table to help with the sign of the value (negative or positive). Take a look at this video showing how it is done using Power Pivot.


https://www.youtube.com/watch?v=ojHZkWkEY7Q/
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,195
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top