File: /www/exchange0old/exchange/cache/%%87^87A^87A2E423%%management_accounts_xslx.html.php
<?php /* Smarty version 2.6.19, created on 2024-06-15 03:31:20
compiled from /www/exchange2/exchange/admin/templates/reports/accounts_journal/v2/management_accounts_xslx.html */ ?>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Balance Sheet v5.0</td><td></td><td></td><td>Profit & Loss v5.0</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Assets</td><td>=TEXT(System!O6,"YYYY")&" - W"&WEEKNUM(System!O6,2)</td><td></td><td>Trade Income</td><td>=TEXT(System!O6,"YYYY")&" - W"&WEEKNUM(System!O6,2)</td><td>√</td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Current Assets</td><td></td><td></td><td>2001 - Arrangement Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1001 - Quistclose Investor EUR</td><td>=VLOOKUP(System!O6-1,Bank!A:B,2,)</td><td></td><td>2002 - Access Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1002 - Quistclose Investor GBP</td><td>=VLOOKUP(System!O6-1,Bank!A:D,4,)*System!O9</td><td></td><td>2003 - Administration Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1003 - Quistclose Investor USD</td><td>=VLOOKUP(System!O6-1,Bank!A:F,6,)*System!O10</td><td></td><td>2005 - Assessment Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1101 - Clearing EUR</td><td>=VLOOKUP(System!O6-1,Bank!A:H,8,)</td><td></td><td>2006 - Asset Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1102 - Clearing GBP</td><td>=VLOOKUP(System!O6-1,Bank!A:I,9,)*System!O9</td><td></td><td>2007 - Application Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1103 - Clearing USD</td><td>=VLOOKUP(System!O6-1,Bank!A:J,10,)*System!O10</td><td></td><td>2011 - Management Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1104 - DDA Clearing EUR</td><td>=0</td><td></td><td>2012 - Collections Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1105 - DDA Security EUR</td><td>=0</td><td></td><td>2052 - Exceptions Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1201 - LDC</td><td>=VLOOKUP(System!O6-1,Bank!A:K,11,)</td><td></td><td>2053 - Exceptions Legal Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1212 - Fx GBP</td><td>=0</td><td></td><td>2061 - Terminals Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1213 - Fx USD</td><td>=0</td><td></td><td>2062 - Processing Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1301 - Investor GBP Control</td><td>=0</td><td></td><td>2101 - Traded a-ETR</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1302 - Investor USD Control</td><td>=0</td><td></td><td>2102 - Traded b-ETR</td><td>=SUMIFS('b-ETR & c-ETR'!U:U,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1321 - LDC GBP Control</td><td>=0</td><td></td><td>2103 - Traded c-ETR</td><td>=SUMIFS('b-ETR & c-ETR'!U:U,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>Cash Reserves</td><td></td><td>1322 - LDC USD Control</td><td>=0</td><td></td><td>2104 - Traded d-ETR</td><td>=SUMIFS('d-ETR'!V:V,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=H21</td><td></td><td>1343 - Exchange USD Control</td><td>=0</td><td></td><td>2121 - Trade Commission</td><td>=SUMIFS('d-ETR'!AI:AI,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('d-ETR'!AI:AI,'d-ETR'!AE:AE,">="&System!O5,'d-ETR'!AE:AE,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AN:AN,'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AN:AN,'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H59</td><td></td><td>1401 - Exchange EUR</td><td>=VLOOKUP(System!O6-1,Bank!A:M,13,)</td><td></td><td>2122 - Processing Commission</td><td>=SUMIFS(Commissions!A:A,Commissions!F:F,">="&System!O5,Commissions!F:F,"<="&System!O6)+SUMIFS(Commissions!B:B,Commissions!F:F,">="&System!O5,Commissions!F:F,"<="&System!O6)+SUMIFS(Commissions!C:C,Commissions!F:F,">="&System!O5,Commissions!F:F,"<="&System!O6)+SUMIFS(Commissions!D:D,Commissions!F:F,">="&System!O5,Commissions!F:F,"<="&System!O6)+SUMIFS(Commissions!E:E,Commissions!F:F,">="&System!O5,Commissions!F:F,"<="&System!O6)+SUMIFS('DRP Commissions'!A:A,'DRP Commissions'!F:F,">="&System!O5,'DRP Commissions'!F:F,"<="&System!O6)+SUMIFS('DRP Commissions'!B:B,'DRP Commissions'!F:F,">="&System!O5,'DRP Commissions'!F:F,"<="&System!O6)+SUMIFS('DRP Commissions'!C:C,'DRP Commissions'!F:F,">="&System!O5,'DRP Commissions'!F:F,"<="&System!O6)+SUMIFS('DRP Commissions'!D:D,'DRP Commissions'!F:F,">="&System!O5,'DRP Commissions'!F:F,"<="&System!O6)+SUMIFS('DRP Commissions'!E:E,'DRP Commissions'!F:F,">="&System!O5,'DRP Commissions'!F:F,"<="&System!O6)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H68</td><td></td><td>1402 - Exchange GBP</td><td>=VLOOKUP(System!O6-1,Bank!A:N,14,)*System!O9</td><td></td><td>2123 - Exchange Commission</td><td>=SUMIFS('d-ETR'!AK:AK,'d-ETR'!AB:AB,">="&System!O5,'d-ETR'!AB:AB,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=SUM(E20:E22)</td><td></td><td>1403 - Credebt Money EUR</td><td>=0</td><td></td><td>2124 - Discount Commission</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1410 - Credit Account</td><td>=0</td><td></td><td>2125 - Fx Trade Commission</td><td>=SUMIFS('d-ETR'!AV:AV,'d-ETR'!AB:AB,">="&System!O5,'d-ETR'!AB:AB,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('d-ETR'!AW:AW,'d-ETR'!AB:AB,">0",'d-ETR'!AE:AE,">="&System!O5,'d-ETR'!AE:AE,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AJ:AJ,'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6)+SUMIFS('Credit Notes'!R:R,'Credit Notes'!L:L,">="&System!O5,'Credit Notes'!L:L,"<="&System!O6)+SUMIFS('Credit Notes'!S:S,'Credit Notes'!N:N,">="&System!O5,'Credit Notes'!N:N,"<="&System!O6)+SUMIFS('Specific Deductions'!R:R,'Specific Deductions'!L:L,">="&System!O5,'Specific Deductions'!L:L,"<="&System!O6)+SUMIFS('Specific Deductions'!S:S,'Specific Deductions'!N:N,">="&System!O5,'Specific Deductions'!N:N,"<="&System!O6)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>Discretionary Reserves</td><td></td><td>1600 - Settled Trades</td><td>=SUMIFS('Unallocated Payments'!L:L,'Unallocated Payments'!F:F,"<="&System!O6,'Unallocated Payments'!J:J,"<>a")</td><td></td><td>2127 - Settled Commission</td><td>=SUMIFS('d-ETR'!AP:AP,'d-ETR'!AB:AB,">="&System!O5,'d-ETR'!AB:AB,"<="&System!O6,'d-ETR'!BA:BA,"d")+N("Settled Commission")+SUMIFS('d-ETR'!AU:AU,'d-ETR'!AB:AB,">="&System!O5,'d-ETR'!AB:AB,"<="&System!O6,'d-ETR'!BA:BA,"d")+N("180-Day rule commission")+SUMIFS('b-ETR & c-ETR'!AO:AO,'b-ETR & c-ETR'!W:W,">0",'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+N("Settled Commission+ on b-ETR")+SUMIFS('b-ETR & c-ETR'!AO:AO,'b-ETR & c-ETR'!W:W,">0",'b-ETR & c-ETR'!W:W,">="&System!O5,'b-ETR & c-ETR'!W:W,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")+N("Settled Commission+ on c-ETR")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H26</td><td></td><td>1700 - d-ETR Discounts</td><td>=SUMIFS('Credit Notes'!K:K,'Credit Notes'!L:L,"<="&System!O6,'Credit Notes'!L:L,">0",'Credit Notes'!N:N,"")+N("Credit Notes that are not yet Settled")+SUMIFS('Credit Notes'!K:K,'Credit Notes'!L:L,"<="&System!O6,'Credit Notes'!L:L,"",'Credit Notes'!N:N,"")+N("Credit Notes that are not yet Closed")+SUMIFS('Specific Deductions'!K:K,'Specific Deductions'!G:G,"<="&System!O6,'Specific Deductions'!N:N,"")+N("Specific Deductions that are not yet Settled")+SUMIFS('Specific Deductions'!K:K,'Specific Deductions'!G:G,"<="&System!O6,'Specific Deductions'!L:L,"",'Specific Deductions'!N:N,"")+N("Specific Deductions that are not yet Closed")</td><td></td><td>2301 - Interest</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H59</td><td></td><td>1701 - LDC Accruals</td><td>=SUMIFS('d-ETR'!AU:AU,'d-ETR'!AE:AE,"",'d-ETR'!BA:BA,"d")+N("180-Day rule on outstanding d-ETR")-SUMIFS('d-ETR'!AS:AS,'d-ETR'!AE:AE,"",'d-ETR'!K:K,"&lt;="&System!O6,'d-ETR'!BA:BA,"d")-N("Margin calls not yet Settled")</td><td></td><td>2502 - Other Income</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H70</td><td></td><td>1901 - a-ETR</td><td>=0</td><td></td><td>2601 - Translation Fx</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H80</td><td></td><td>1902 - b-ETR</td><td>=SUMIFS('b-ETR & c-ETR'!T:T,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!AH:AH,"b",'b-ETR & c-ETR'!K:K,"<="&System!O6)+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")-SUMIFS('Unallocated Payments'!L:L,'Unallocated Payments'!J:J,"b",'Unallocated Payments'!I:I,"<>DEPOSIT")</td><td></td><td>Total Income</td><td>=SUM(K4:K28)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-H90</td><td></td><td>1903 - c-ETR</td><td>=SUMIFS('b-ETR & c-ETR'!T:T,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!AH:AH,"c",'b-ETR & c-ETR'!K:K,"<="&System!O6)+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")-SUMIFS('Unallocated Payments'!L:L,'Unallocated Payments'!J:J,"c",'Unallocated Payments'!I:I,"<>DEPOSIT")</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td>=-SUM(E26:E30)</td><td></td><td>1904 - d-ETR</td><td>=SUMIFS('d-ETR'!V:V,'d-ETR'!AB:AB,"",'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td>Trade Costs</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>1961 - Exceptions</td><td>=0</td><td></td><td>3002 - Access</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>610 - Accounts Receivable</td><td>=0</td><td></td><td>3006 - Asset</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>6310 - Prepayments</td><td>=0</td><td></td><td>3012 - Collections</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>6400 - Authorisation Required</td><td>=0</td><td></td><td>3053 - Exceptions Legal</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Current Assets</td><td>=SUM(H5:H35)</td><td></td><td>3054 - Exceptions Enforcement</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>3061 - Terminals</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Fixed Assets</td><td></td><td></td><td>3062 - Processing</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7001 - Inventory Assets</td><td>=0</td><td></td><td>3100 - Deferred Yield</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7010 - Tangible Assets</td><td>=0</td><td></td><td>3111 - Commissions</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7011 - Accumulated Depreciation</td><td>=0</td><td></td><td>3119 - Agents Commissions</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7030 - Intangible Assets</td><td>=0</td><td></td><td>3120 - Reserves</td><td>=SUMIFS('d-ETR'!AN:AN,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7031 - IP Accumulated Depreciation</td><td>=0</td><td></td><td>3132 - LDC Reserve</td><td>=SUMIFS('d-ETR'!AL:AL,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7050 - a-ETR Assets</td><td>=0</td><td></td><td>3133 - b-ETR Purchase Price</td><td>=SUMIFS('b-ETR & c-ETR'!T:T,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>7051 - a-ETR Depreciations</td><td>=0</td><td></td><td>3134 - c-ETR Purchase Price</td><td>=SUMIFS('b-ETR & c-ETR'!T:T,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Fixed Assets</td><td>=SUM(H39:H45)</td><td></td><td>3135 - d-ETR Purchase Price</td><td>=SUMIFS('d-ETR'!AJ:AJ,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")-SUMIFS('d-ETR'!AM:AM,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>3136 - d-ETR Discount</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Assets</td><td>=H36+H46</td><td></td><td>3137 - LDC Premium</td><td>=SUMIFS('d-ETR'!AM:AM,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>3150 - Deferred Commission</td><td>=SUMIFS('d-ETR'!AK:AK,'d-ETR'!K:K,">="&System!O5,'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!K:K,">="&System!O5,'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Liabilities</td><td></td><td></td><td>3301 - a-ETR Services</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Current Liabilities</td><td></td><td></td><td>3302 - a-ETR Depreciation</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>5000 - Investabill® ETR Funds</td><td>=VLOOKUP(System!O6-1,Bank!A:S,19,)</td><td></td><td>3303 - a-ETR Purchases</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>5001 - Leasabill® ETR Funds</td><td>=VLOOKUP(System!O6-1,Bank!A:T,20,)</td><td></td><td>3351 - Rating Agency</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8000 - Accounts Payable</td><td>=0</td><td></td><td>3361 - CDP</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8100 - Accruals</td><td>=0</td><td></td><td>3401 - Originator Marketing</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8110 - Deferred Yields</td><td>=VLOOKUP(System!O6-1,Bank!A:U,21,)</td><td></td><td>3403 - Agent Marketing</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8111 - Crystallised Yields</td><td>=VLOOKUP(System!O6-1,Bank!A:V,22,)</td><td></td><td>3411 - Investor Marketing</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8120 - Commission Accruals</td><td>=0</td><td></td><td>3421 - Travel</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8130 - Deferred Income</td><td>=SUMIFS('d-ETR'!AK:AK,'d-ETR'!AB:AB,"",'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AM:AM,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td>Total Cost of Sales</td><td>=SUM(K32:K58)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8150 - Originator Accruals</td><td>=0</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8161 - Branch</td><td>=0</td><td></td><td>Trade Commission</td><td>=(K29)-(K59)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8162 - Broker</td><td>=0</td><td></td><td>Gross Margin</td><td>=(K29-K59)/K29</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8163 - Agent</td><td>=0</td><td></td><td>Check:</td><td>=SUM(K17:K19)-SUM(K42:K48)-K49</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8201 - Salary Accruals</td><td>=0</td><td></td><td>Operating Expenses</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8202 - Holiday Pay Accrual</td><td>=0</td><td></td><td>4055 - Recruitment & Training</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8220 - VAT</td><td>=0</td><td></td><td>4060 - Salaries</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8240 - PAYE/PRSI</td><td>=0</td><td></td><td>4070 - Employer's PRSI</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8310 - Reserves Due</td><td>=SUMIFS('d-ETR'!AQ:AQ,'d-ETR'!AB:AB,">0",'d-ETR'!AE:AE,"",'d-ETR'!AB:AB,"<="&System!O6,'d-ETR'!BA:BA,"d")+N("-'Reserves Analysis'!J287-'Reserves Analysis'!J288")</td><td></td><td>4071 - Holiday Pay</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8320 - Reserves Outstanding</td><td>=SUMIFS('d-ETR'!AQ:AQ,'d-ETR'!AB:AB,"",'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")</td><td></td><td>4090 - Service Contract Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8330 - LDC Reserves</td><td>=SUMIFS('d-ETR'!AM:AM,'d-ETR'!AB:AB,"",'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('d-ETR'!AP:AP,'d-ETR'!AB:AB,"",'d-ETR'!K:K,"<="&System!O6,'d-ETR'!BA:BA,"d")+SUMIFS('b-ETR & c-ETR'!AO:AO,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"b")+SUMIFS('b-ETR & c-ETR'!AO:AO,'b-ETR & c-ETR'!W:W,"",'b-ETR & c-ETR'!K:K,"<="&System!O6,'b-ETR & c-ETR'!AH:AH,"c")</td><td></td><td>4100 - Consultancy Costs</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8370 - Trade Reserves</td><td>=0</td><td></td><td>4120 - Back Office</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8401 - a-ETR Reserves</td><td>=0</td><td></td><td>4130 - Legal Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8402 - b-ETR Reserves</td><td>=SUMIFS('Unallocated Payments'!L:L,'Unallocated Payments'!J:J,"b",'Unallocated Payments'!I:I,"DEPOSIT")</td><td></td><td>4140 - Audit Fee</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8403 - c-ETR Reserves</td><td>=SUMIFS('Unallocated Payments'!L:L,'Unallocated Payments'!J:J,"c",'Unallocated Payments'!I:I,"DEPOSIT")</td><td></td><td>4160 - Tax & Finance Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8404 - d-ETR Creditors</td><td>=0</td><td></td><td>4190 - IP Expenses<</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Current Liabilities</td><td>=SUM(H52:H75)</td><td></td><td>4200 - Insurance</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>4330 - ICT</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Non-Current Liabilities</td><td></td><td></td><td>4335 - ICT Development</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>9000 - Shareholder's Loan</td><td>=0</td><td></td><td>4450 - Rent & Rates</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>9010 - Director's Loan</td><td>=0</td><td></td><td>4451 - Office Expenses</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Non-Current Liabilities</td><td>=SUM(H79:H80)</td><td></td><td>4490 - Board & Management</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>4500 - Depreciation</td><td>=0</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Liabilities</td><td>=H81+H76</td><td></td><td>4910 - Bank Transaction Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>4911 - Bank Express Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Net Assets</td><td>=H48-H83</td><td></td><td>4912 - Bank Management Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=H83+H85-H48</td><td></td><td>4913 - Bank Fx Fees</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Equity</td><td></td><td></td><td>499 - Realised Currency Losses</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>9600 - Retained Earnings</td><td>=0</td><td></td><td>498 - Unrealised Currency Gains</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>9700 - Share Capital</td><td>=0</td><td></td><td>Total Operating Expenses</td><td>=SUM(K65:K88)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Current Year Earnings</td><td>=K91</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Equity</td><td>=SUM(H88:H90)</td><td></td><td>Net Profit</td><td>=K61-K89</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=H91-H85</td><td></td><td>Operating Margin</td><td>=K91/K29</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=K91/WEEKNUM(System!O6,2)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>=COUNT('d-ETR'!L:L)</td><td>=(SUM('d-ETR'!AL:AL)+SUM('d-ETR'!AN:AN)-SUM('d-ETR'!AQ:AQ))/(SUM('d-ETR'!AL:AL)+SUM('d-ETR'!AN:AN))</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>TaR Reserves</td><td>=H70+H69*H94+H59+H81+H91</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Assets</td><td>=SUM(H5:H35)+H59</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Third-party liabilities</td><td>=H52+H53+H54+H56+H57+H58+H60+H64+H69+H68-H72-H75</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=H97-H98</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td>TaR Reserves</td><td></td><td></td><td></td><td>Statement of Financial Position v5.0</td><td></td><td></td><td>Income Statement v5.0</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td>1700 - Reserves</td><td></td><td>=H107</td><td></td><td>Assets</td><td>=TEXT(System!O6,"YYYY")&" - W"&WEEKNUM(System!O6,2)</td><td></td><td>Trade Income</td><td>=TEXT(System!O6,"YYYY")&" - W"&WEEKNUM(System!O6,2)</td><td></td><td></td></tr>
<tr><td></td><td></td><td>8130 - Deferred Income</td><td></td><td>=H124</td><td></td><td>Current Assets</td><td></td><td></td><td> - Fees</td><td>=SUM(K4:K15)</td><td></td><td></td></tr>
<tr><td></td><td></td><td>8362 - LDC Reserves</td><td></td><td>=H129</td><td></td><td> - Bank</td><td>=SUM(H5:H24)-H13</td><td></td><td>2100 - Traded ETR</td><td>=SUM(K16:K19)</td><td></td><td></td></tr>
<tr><td></td><td></td><td>Total TaR Reserves</td><td></td><td>=SUM(E103:E105)</td><td></td><td>1201 - LDC</td><td>=H13</td><td></td><td> - Commissions</td><td>=SUM(K20:K25)</td><td></td><td></td></tr>
<tr><td></td><td></td><td>Reserves/Trades</td><td></td><td>=E106/SUM(H26:H30)</td><td></td><td>1700 - Reserves</td><td>=H26</td><td></td><td>2601 - Translation Fx</td><td>=K27</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td> - ETR</td><td>=SUM(H28:H31)</td><td></td><td> - Interest & Other Income</td><td>=K26+K28</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td> - Settled Trades</td><td>=H25</td><td></td><td>Total Income</td><td>=SUM(K104:K108)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td> - Operations</td><td>=SUM(H27:H35)</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Current Assets</td><td>=SUM(H105:H110)</td><td></td><td>Trade Costs</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>3100 - Investor Yield</td><td>=K39</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Fixed Assets</td><td>=SUM(H39:H43)</td><td></td><td>3111 - Intermediary Commissions</td><td>=K40</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>a-ETR Assets</td><td>=SUM(H44:H45)</td><td></td><td> - ETR Purchase Prices</td><td>=SUM(K44:K46)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Fixed Assets</td><td>=SUM(H113:H114)</td><td></td><td>3120 - Reserves</td><td>=K42</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>3132 - LDC</td><td>=K43</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Assets</td><td>=H111+H115</td><td></td><td>3136 - d-ETR Discount</td><td>=K47</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td> - a-ETR</td><td>=K50+K51+K52</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Liabilities</td><td></td><td></td><td>3150 - Deferred Commission</td><td>=K49</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Current Liabilities</td><td></td><td></td><td> - Trading Costs</td><td>=SUM(K32:K38)+K53+K54</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>5000 - Investor Funds</td><td>=H52+H53</td><td></td><td>3180 - Foreign Exchange</td><td>=0</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8110 - Deferred Yield</td><td>=H56+H57</td><td></td><td> - Marketing</td><td>=SUM(K55:K58)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8120 - Commission Accruals</td><td>=H58</td><td></td><td>Total Cost of Sales</td><td>=SUM(K112:K122)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8130 - Deferred Income</td><td>=H59</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>- Accruals</td><td>=H54+H55+SUM(H60:H65)</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>- PAYE/PRSI & VAT</td><td>=H66+H67</td><td></td><td>Trade Commission</td><td>=(K109)-(K123)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>- Reserves</td><td>=H68+H69+H71</td><td></td><td>Gross Margin</td><td>=(K109-K123)/K109</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>- ETR Reserves</td><td>=H72+H73</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>8360 - LDC Reserves</td><td>=H70+H75</td><td></td><td>Operating Expenses</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Current Liabilities</td><td>=SUM(H121:H129)</td><td></td><td>4055 - Recruitment & Training</td><td>=K65</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td> - Salaries & Board</td><td>=K66+K67+K68+K81</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Non-Current Liabilities</td><td></td><td></td><td> - Service & Consultancy</td><td>=SUM(K69:K70)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Non-Current Liabilities</td><td>=H81</td><td></td><td> - Legal, Tax & Audit Fees</td><td>=SUM(K71:K74)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td> - ICT</td><td>=K75+K77+K78</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Liabilities</td><td>=H133+H130</td><td></td><td> - Office, Insurance & Expenses</td><td>=K76+K79+K80</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>4500 - Depreciation</td><td>=K82</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Net Assets</td><td>=H117-H135</td><td></td><td> - Bank</td><td>=K83+K85</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>Foreign Currency Gains and Losses</td><td>=K87+K88</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>9600 - Retained Earnings</td><td>=H88+H89</td><td></td><td>Total Operating Expenses</td><td>=SUM(K130:K138)</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Current Year Earnings</td><td>=K141</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total Equity</td><td>=SUM(H139:H140)</td><td></td><td>Net Profit</td><td>=K126-K139</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Note:- Reserves / ETR Outstanding :</td><td>=SUM(H68:H75)/SUM(H28:H31)</td><td></td><td>Operating Margin</td><td>=K141/K109</td><td></td><td></td></tr>