Spreadsheet: 76672d1277205330-pivot-table-calculated-item-calculated-items
Sheet: Pivot

Sum of Base Amt |  |  |  |  | Branch Code | Oper Unit
 |  |  |  |  | GEN | JG | KB | MO | Grand Total
Sun Account | Sun Desc | Account | Cost Centre | Dept ID | 800 | 101 | 103 | 100
4000 | Local Staff Salaries | 611101 | 20M03 | 1834 | 2562.03 | 25071.48 | 4761.5 |  | 32395.01
 |  |  | 20T08 | 1832 | 1620.86 | 18127.65 | 2104.5 |  | 21853.01
4004 | Local Staff Performance Bonus | 611701 | 20M03 | 1834 |  | 6848 | 542 |  | 7390
 |  |  | 20T08 | 1832 |  | 6067 | 408 |  | 6475
40060 | Local Staff Allowance Housing | 611401 | 20M03 | 1834 |  | 3957 | 647 |  | 4604
 |  |  | 20T08 | 1832 |  | 2987 | 380 |  | 3367
40069 | Local Staff Allowance - Others | 611402 | 20M03 | 1834 |  | 10182.87 |  |  | 10182.87
40091 | RSS | 611709 | 20M03 | 1834 |  | 498 |  |  | 498
4010 | Local Staff Social Security | 612001 | 20M03 | 1834 | 2562.03 |  |  |  | 2562.03
 |  |  | 20T08 | 1832 | 1620.86 |  |  |  | 1620.86
40300 | Internal Training-Conferences | 613001 | 20M03 | 1834 | 300 | 176.4 | 19.35 |  | 495.75
 |  |  | 20T08 | 1832 |  | 137.14 | 19.35 |  | 156.49
4040 | Medical Expenses | 615101 | 20M03 | 1834 |  | 209.5 | 15.3 |  | 224.8
 |  |  | 20T08 | 1832 |  | 345.45 | 15.3 |  | 360.75
4041 | Staff Uniform Costs | 615109 | 20T08 | 1832 |  | 100 | 100 |  | 200
4042 | Recruitment Expenses | 615104 | 20M03 | 1834 |  | 41.67 |  |  | 41.67
4043 | Temporary Staff Costs | 615116 | 20M03 | 1834 |  |  | 41.67 |  | 41.67
4047 | STAFF COST - SHARE SAVE | 615124 | 20M03 | 1834 |  | 518 |  |  | 518
 |  |  | 20T08 | 1832 | 79 |  |  |  | 79
4049 | Other Staff Costs | 615105 | 20M03 | 1834 |  | 335.06 | 42.61 |  | 377.67
 |  |  | 20T08 | 1832 | 12 | 567.07 | 36.41 |  | 615.48
4100 | Rents - Bank Premises | 631002 | 20M03 | 1834 |  | 7297.99 | 1914.94 |  | 9212.93
 |  |  | 20T08 | 1832 |  | 46.49 | 6.56 | 1763.42 | 1816.47
4110 | Renwl & Maint-Bank Premises | 631501 | 20M03 | 1834 |  | 3830.3 | 1.36 |  | 3831.66
 |  |  | 20T08 | 1832 |  | 142.32 | 20.31 |  | 162.63
4123 | Premises Utilities | 632104 | 20M03 | 1834 |  | 256.37 | 12.25 |  | 268.62
 |  |  | 20T08 | 1832 |  | 181.32 | 12.25 |  | 193.57
4129 | Premises Other Costs | 615172 | 20T08 | 1832 |  |  |  | 290.53 | 290.53
4141 | Depreciation-Office Equipment | 634002 | 20M03 | 1834 |  | 125.83 |  | 125.82 | 251.65
4142 | Depreciation-Furn & Fittings | 634003 | 20M03 | 1834 |  |  | 119.5 |  | 119.5
4167 | Renwl & Maint - Commun Network | 654501 | 20M03 | 1834 | 0 | 383.52 | 613.02 |  | 996.54
 |  |  | 20T08 | 1832 |  | 155.79 | 9.99 |  | 165.78
4260 | Postage & Telegrams | 654504 | 20M03 | 1834 |  | 568.1 |  |  | 568.1
 |  |  | 20T08 | 1832 |  | 100 |  |  | 100
4290 | Travel-Business Local | 656002 | 20M03 | 1834 |  | 154.8 | 103.2 |  | 258
42A | Entertainment | 657001 | 20M03 | 1834 | 2000 | 31.31 | 31.23 |  | 2062.54
 |  |  | 20T08 | 1832 | 27 | 935.6 | 0.23 |  | 962.83
42B0 | Office Stationery | 657252 | 20M03 | 1834 |  | 16 | 20.4 |  | 36.4
 |  |  | 20T08 | 1832 |  | 113 |  |  | 113
42B1 | Preprinted Forms | 657202 | 20M03 | 1834 |  | 440 | 210 | 90 | 740
42D0 | Advertising | 657603 | 20M03 | 1834 |  | 2676 |  |  | 2676
 |  |  | 20M36 | 1836 | 7250 | 6400 |  |  | 13650
42F | Insurance-Non Prem & Equip | 659001 | 20M03 | 1834 |  | 321.37 | 35.25 |  | 356.62
 |  |  | 20T08 | 1832 |  | 249.84 | 35.25 |  | 285.09
42H0 | Subscriptions-Newspaper | 661001 | 20M03 | 1834 |  | 66 | 52 | 51.6 | 169.6
 |  |  | 20T08 | 1832 |  | 42 |  | 52.4 | 94.4
42H9 | Subscriptions-Other | 661003 | 20M03 | 1834 |  | 54.95 |  |  | 54.95
 |  |  | 20T08 | 1832 |  | 166.02 |  |  | 166.02
42J11 | RECHG TO GRP - DCR UTILITY-1 | 665096 | 20M03 | 1834 |  | 460.98 |  |  | 460.98
 |  |  | 20T08 | 1832 |  | 205.33 | 65.65 |  | 270.98
42J19 | RECHARGE FR OTHER GR BR/CO | 665029 | 20M03 | 1834 | 6343.3 |  |  |  | 6343.3
42J5 | ARCHIVING COSTS | 665002 | 20M03 | 1834 |  | 159.6 |  |  | 159.6
 |  |  | 20T08 | 1832 |  | 0 |  |  | 0
42J9 | Other Operating Costs | 665049 | 20M03 | 1834 |  | 305.21 |  |  | 305.21
 |  |  | 20M36 | 1836 |  | 782 |  |  | 782
 |  |  | 20T08 | 1832 |  | 71.59 |  |  | 71.59
42D8 | Postage and courier-Marketing | 654551 | 20M36 | 1836 |  |  |  | 765.05 | 765.05
Grand Total |  |  |  |  | 24377.08 | 102908.92 | 12396.38 | 3138.82 | 142821.2