Spreadsheet: 83147d1283196555-pivot-table-totals-monetary-template-2
Sheet: Sheet9

Sum of Period FX in USD
Company Type | Currency | Cat Code | Current Month Bal | Prior Month Bal | Current to Prior Period Incr / Decr | Total
Non USD Co's | AUD | Cash | 448898.46 | 733796.97 | -284898.51 | 6024.698378
 |  | Inter-Company | -26221301.1 | -20410979.24 | -5810321.860000003 | 0
 |  |  | -10381866.67 | -8849260.08 | -1532606.59 | 0
 |  |  | -2101774.81 | -1762614.23 | -339160.58 | 0
 |  |  | -325.92 | 0 | -325.92 | 0
 |  | Other Assets | -47141.64 | -43132.98 | -4008.66 | 0
 |  |  | 11573.49 | 61913.25 | -50339.76 | 0
 |  | Other Liabilities | -2683608.26 | -2348268.78 | -335339.48 | 0
 |  |  | -628468.57 | -565540.49 | -62928.08 | 0
 | AUD Sum |  |  |  |  | 6024.698378
 | BRL | Inter-Company | -2688899.04 | -2118430.8 | -570468.24 | 0
 |  |  | -280184.94 | -189073.72 | -91111.22 | 0
 |  |  | 19467977.9 | 30503756.08 | -11035778.18 | 0
 |  | Other Liabilities | -20823185.12 | -20315435.84 | -507749.2800000012 | 0
 | BRL Sum |  |  |  |  | 0
 | CAD | Inter-Company | 77707.18 | 77707.18 | 0 | 355.60456272
 |  | Other Liabilities | 0 | -28.25 | 28.25 | -0.15302
 | CAD Sum |  |  |  |  | 355.45154272
 | CHF | Cash | -60.9 | -665.4 | 604.5 | 7.797027
 |  |  | 347501.11 | 694557.4 | -347056.29 | -10725.828477
 |  | Inter-Company | 18410 | 18410 | 0 | 117.579566192
 |  | Other Liabilities | -23006.92 | -26967.9 | 3960.98 | 0
 | CHF Sum |  |  |  |  | -10600.451883808
 | CNY | Other Liabilities | -110400 | -54000 | -56400 | 0
 | CNY Sum |  |  |  |  | 0
 | DKK | Inter-Company | 5200 | 5200 | 0 | -12.346048
 | DKK Sum |  |  |  |  | -12.346048
 | EUR | Cash | 35551461.47 | 34211661.13 | 1339800.34 | 0
 |  | Inter-Company | 94255.78 | 94255.78 | 0 | 4365.965966735999
 |  | Other Assets | -140170.61 | -136378.6 | -3792.00999999998 | 0
 |  |  | -12494.5 | -15290.5 | 2796 | 0
 |  |  | -2006.1 | -2006.1 | 0 | 33.977263
 |  |  | 1839.51 | 1548.72 | 290.79 | 0
 |  | Other Liabilities | -991894.91 | -951520.8 | -40374.11 | 0
 |  |  | -481972.33 | -368062.57 | -113909.76 | 0
 | [NAME] |  |  |  |  | 4399.943229735999
 | GBP | Inter-Company | -837.63 | 0 | -837.63 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0.08 | 0.08 | 0 | -0.003192
 |  |  | 4500 | 3900 | 600 | 130.591818
 |  |  | 40157.56 | 40157.56 | 0 | 1265.157488848
 |  | Other Liabilities | -3457974.88 | -3201680.31 | -256294.57 | 0
 |  |  | -2000 | -2000 | 0 | 47.88322
 |  |  | 0 | 0 | 0 | 0
 | GBP Sum |  |  |  |  | 1443.629334848
 | NOK | Inter-Company | -729226.06 | -491201.19 | -238024.87 | 684.764541
 |  |  | 342533.28 | 342533.28 | 0 | 2173.743821744
 | NOK Sum |  |  |  |  | 2858.508362744
 | NZD | Inter-Company | 240000 | 120000 | 120000 | -6806.19454
 |  | Other Liabilities | -7627 | -19693.23 | 12066.23 | 0
 | NZD Sum |  |  |  |  | -6806.19454
 | SEK | Inter-Company | 146794.6 | 146794.6 | 0 | 968.0629059199999
 |  |  | 1244875.19 | 724475.21 | 520399.98 | 0
 |  | Other Assets | -32508.58 | -32738.14 | 229.5599999999977 | 0
 | SEK Sum |  |  |  |  | 968.0629059199999
 | SGD | Inter-Company | -1940628.05 | -1855856.21 | -84771.84000000008 | 0
 |  |  | -1515759.54 | -1317703.8 | -198055.74 | 0
 |  | Other Liabilities | -14920.24 | -11833.88 | -3086.36 | 0
 | SGD Sum |  |  |  |  | 0
 | USD | Cash | 92.18 | -199820.1 | 199912.28 | -3310.783128
 |  |  | 1891.6 | 1939.89 | -48.29000000000019 | -115.114756
 |  |  | 352456.18 | 345416.62 | 7039.56 | -25540.54588
 |  | Inter-Company | -697381.26 | -1627225.26 | 929844 | 28728.23814
 |  |  | -436992.17 | -430354.95 | -6637.219999999972 | 31743.11542
 |  |  | -24904.55 | -22596.06 | -2308.49 | 1558.163509
 |  |  | -17409.32 | -15798.3 | -1611.02 | 1067.232474
 |  |  | -8611.78 | -9161.98 | 550.1999999999989 | 654.5138800000001
 |  |  | -2000 | -2000 | 0 | 118.678614
 |  |  | 2000 | 2000 | 0 | -146.44162
 |  |  | 12155.5 | 11715.5 | 440 | -867.903
 |  |  | 20867.89 | 9730.31 | 11137.58 | -421.4742172959999
 |  |  | 10465102.68 | 10477715.91 | -12613.23000000045 | -294754.285482976
 |  | Other Assets | 0 | 0 | 0 | 0
 |  |  | 11483.93 | 8429.11 | 3054.82 | -687.36864
 |  |  | 39006.27 | 39006.27 | 0 | -2544.98034
 |  | Other Liabilities | -179085.92 | -209523.67 | 30437.75 | 5620.75962
 |  |  | -33428.07 | -31034.29 | -2393.78 | 926.0697999519999
 |  |  | -4780.67 | -53.31 | -4727.36 | 117.07252
 |  |  | -23.88 | -23.88 | 0 | 1.74722
 |  |  | 0 | -0.83 | 0.83 | 0
 |  |  |  | 0 | 0 | 0
 |  |  | 28716 | 28716 | 0 | -3747.156434
 | USD Sum |  |  |  |  | -261600.46230132
Non USD Co's Sum |  |  |  |  |  | -262969.16101916
USD Co's | AUD | Deferred Revenue | -1428037.68 | -1492665.04 | 64627.3600000001 | 0
 |  |  | -70 | 0 | -70 | -96391.36
 |  | Inter-Company | 10381866.67 | 8849260.08 | 1532606.59 | 617628.06
 |  | Other Liabilities | -806.3 | -694.9 | -111.4 | -59.4
 |  |  | 0.01 | 0.01 | 0 | 0
 | AUD Sum |  |  |  |  | 521177.3
 | BRL | Deferred Revenue | -267919.64 | -364600.13 | 96680.49 | -5352.47
 |  | Inter-Company | 2688899.04 | 2118430.8 | 570468.24 | 35070.98
 |  | Other Liabilities | 0 | 0 | 0 | 0
 | BRL Sum |  |  |  |  | 29718.51
 | CAD | Deferred Revenue | -2698655.21 | -2685431.29 | -13223.91999999993 | -90355.98
 |  | Other Liabilities | -21352.8 | -155205.1 | 133852.3 | -1476.42
 |  |  | -4404.3 | -3612.4 | -791.9 | -139.96
 |  |  | 0 | 0 | 0 | 0
 | CAD Sum |  |  |  |  | -91972.36
 | CHF | Deferred Revenue | -192362.68 | -192072.99 | -289.6900000000023 | 0
 |  |  | -105486.25 | -105486.25 | 0 | -1538.69
 |  |  | -18715.86 | -58234.26 | 39518.4 | -26387.63
 |  |  | 67058.95 | 64546.5 | 2512.45 | 0
 |  | Inter-Company | 1947101.69 | 1656067.66 | 291034.03 | 59383.09
 |  | Other Liabilities | 0 | 0 | 0 | 0
 | CHF Sum |  |  |  |  | 31456.77
 | DEM | Deferred Revenue | 0 | 0 | 0 | 0
 | DEM Sum |  |  |  |  | 0
 | DKK | Deferred Revenue | -15449407.73 | -8126830.21 | -7322577.52 | 0
 |  |  | -380517.25 | -303320.32 | -77196.93 | -239862.89
 |  |  | -80543.44 | 0.01 | -80543.45 | -2797.24
 |  |  | 664939.66 | 819551.89 | -154612.23 | 0
 |  |  | 772200.1 | -608709.27 | 1380909.37 | 0
 |  | Inter-Company | 232 | 232 | 0 | 2.5
 |  | Other Liabilities | -558 | 0 | -558 | -2.63
 | DKK Sum |  |  |  |  | -242660.26
 | EUR | Cash | -29275.5 | -29275.5 | 0 | 0.02
 |  |  | 0 | 0 | 0 | 0
 |  |  | 29331.16 | 29351.58 | -20.42000000000189 | 2389.22
 |  | Deferred Revenue | -9848963.4 | -7296215.94 | -2552747.46 | 0
 |  |  | -7543843.36 | -7328358.5 | -215484.86 | 0
 |  |  | -3722141.87 | -4327680.39 | 605538.52 | -479758.31
 |  |  | -3034822.52 | -1009424.99 | -2025397.53 | 0
 |  |  | -2803256.7 | -2631750.94 | -171505.76 | 0
 |  |  | -1586318.51 | -1586318.51 | 0 | -1861183.04
 |  |  | -1135367.96 | -989987.03 | -145380.93 | 0
 |  |  | -1024382.56 | -639727.4 | -384655.16 | 0
 |  |  | -899283.9 | -563100.86 | -336183.04 | 0
 |  |  | -419951.63 | -419951.63 | 0 | -124011.62
 |  |  | -379877.76 | -409603.58 | 29725.82 | 0
 |  |  | -47418.67 | -9829.59 | -37589.08 | 0
 |  |  | -19123.18 | 395279.78 | -414402.96 | 0
 |  |  | -9994.6 | -16299.5 | 6304.9 | 0
 |  |  | 6928.42 | 67844.78 | -60916.36 | 0
 |  |  | 19551.6 | 19040.88 | 510.7199999999975 | 0
 |  |  | 132081.89 | -134427.29 | 266509.18 | 0
 |  |  | 275122.67 | 301716.42 | -26593.75 | 0
 |  |  | 2046613.16 | 1759359.21 | 287253.95 | 0
 |  | EUR Debt Strategy | -1000000000 | -1000000000 | 0 | -81400000
 |  |  | -819706855.69 | -816516880.05 | -3189975.640000105 | -66544046.16
 |  |  | -427041809.67 | -426974563.43 | -67246.24000000954 | -34757403.89
 |  |  | -139500455 | -139500455 | 0 | -11355337.04
 |  |  | -13285758 | -13285758 | 0 | -1081460.7
 |  |  | -1319416.32 | -897747.32 | -421669 | -73076.63
 |  |  | -336712.17 | -179964.3 | -156747.87 | -17954.34
 |  |  | -49699.3 | -49699.3 | 0 | -4045.53
 |  |  | 78350.17 | 78350.17 | 0 | 6377.7
 |  |  | 6844333 | 6844333 | 0 | 557128.7
 |  |  | 15232018.7 | 15232018.7 | 0 | 1239886.32
 |  |  | 97178105.87 | 97178105.87 | 0 | 7910297.82
 |  |  | 229592711.73 | 229549864.73 | 42847 | 18686425.87
 |  |  | 427041809.67 | 426974563.43 | 67246.24000000954 | 34757403.89
 |  | Inter-Company | 92043.8 | 92043.8 | 0 | 7492.37
 |  |  | 1336180.43 | 1026855.69 | 309324.74 | 94686.12
 |  |  | 3402087.11 | 2083443.58 | 1318643.53 | 225545.94
 |  |  | 4414989.61 | 4141366.45 | 273623.16 | 351433.05
 |  | Other | -365 | -365 | 0 | -29.71
 |  |  | 0 | 0 | 0 | 0
 |  |  | 409.33 | 2443.98 | -2034.65 | 148.29
 |  |  | 438.88 | 44.38 | 394.5 | 40.66
 |  |  | 24337.75 | 11503.38 | 12834.37 | 1017
 |  | Other Assets | 1222.97 | 681.65 | 541.32 | 84.27
 |  |  | 36151.17 | 50009.38 | -13858.21 | 3268.24
 |  | Other Liabilities | -187102 | -71494.71 | -115607.29 | 18756.21
 |  |  | -138132 | -104481 | -33651 | -9342.66
 |  |  | -7477.66 | -9662.83 | 2185.17 | -608.68
 |  |  | -671.27 | -887.19 | 215.92 | -83.37
 |  |  | -525.05 | -525.05 | 0 | -42.74
 |  |  | -203.2 | -362.45 | 159.25 | -23.9
 |  |  | -126.9 | -29 | -97.9 | -10.53
 |  |  | -3.63 | -674.67 | 671.04 | -31.3
 |  |  | 0 | -11988.8 | 11988.8 | -677.37
 |  |  |  | 0 | 0 | 0
 |  |  | 576 | 576 | 0 | 0
 | [NAME] |  |  |  |  | -133846745.83
 | GBP | Cash | -4029.99 | -4029.99 | 0 | 96726.84
 |  |  | 6317.59 | 9181.12 | -2863.53 | 1701.96
 |  |  | 65558.25 | 35210.83 | 30347.42 | 0
 |  | Deferred Revenue | -32013180.55 | -36850715.25 | 4837534.7 | 0
 |  |  | -12718354.1 | -8757021.92 | -3961332.18 | 0
 |  |  | -6627103.36 | -6627103.36 | 0 | -275647.52
 |  |  | -2260414.72 | -1947783.17 | -312631.55 | -4036493.45
 |  |  | -196385.79 | -198672.44 | 2286.649999999994 | -1729774.88
 |  |  | -48222.95 | -7141.07 | -41081.88 | 0
 |  |  | 2571298.89 | 2938400.87 | -367101.98 | 0
 |  | Inter-Company | -0.36 | -0.36 | 0 | -0.02
 |  |  | -0.01 | -0.01 | 0 | -0.01
 |  |  | 45358532.57 | 35547101.27 | 9811431.299999997 | 3026223.91
 |  | Other | -98956.56 | -97936.74 | -1019.819999999992 | -7327.84
 |  |  | -530 | -530 | 0 | -39.43
 |  |  | -301 | 0 | -301 | -8.73
 |  |  | 2300 | 2300 | 0 | 74.4
 |  |  | 7456.68 | 7130.56 | 326.12 | 594.85
 |  |  | 7575.74 | 0 | 7575.74 | 537.59
 |  |  | 55905.54 | 113192.67 | -57287.13 | 6760.2
 |  | Other Assets | -123.36 | -123.36 | 0 | -9.18
 |  |  | 0 | 0 | 0 | 0
 |  | Other Liabilities | -1249935.18 | -1176923.95 | -73011.23 | -78745.44
 |  |  | -690812.38 | -3302178.48 | 2611366.1 | -36214.37
 |  |  | -288270.36 | -392705.3 | 104434.94 | -26188.62
 |  |  | -81919 | -70659 | -11260 | -2375.64
 |  |  | -49980.64 | -99314.82 | 49334.18 | -4248.21
 |  |  | -34640 | -33036 | -1604 | -0.01
 |  |  | -25952.89 | -24502.25 | -1450.64 | -1709.33
 |  |  | -6489.9 | -6570.2 | 80.30000000000018 | -506.32
 |  |  | -5972.04 | -5331.88 | -640.16 | -242.07
 |  |  | -4898.14 | -4258.29 | -639.85 | -193.33
 |  |  | 45.77 | 45.77 | 0 | 3.41
 | GBP Sum |  |  |  |  | -3067101.24
 | HTG | Cash | 20544.1 | -303112.6 | 323656.7 | 0
 |  |  | 35000 | 35000 | 0 | 0
 |  |  | 1297125.58 | 375872.48 | 921253.1 | 0
 | HTG Sum |  |  |  |  | 0
 | ITL | Deferred Revenue | 0 | 0 | 0 | 0
 | ITL Sum |  |  |  |  | 0
 | JMD | Cash | 32150 | 32150 | 0 | 0
 |  |  | 148186.13 | -805840.33 | 954026.46 | 103.22
 |  |  | 1007055.68 | 28966.29 | 978089.39 | 111.9
 | [NAME] |  |  |  |  | 215.12
 | [NAME] | Inter-Company | -4159500 | -4159500 | 0 | -7487.1
 |  | Other | 102429.79 | 102429.79 | 0 | 184.38
 | [NAME] |  |  |  |  | -7302.72
 | NOK | Deferred Revenue | -28266008.08 | -28266008.08 | 0 | -520113.36
 |  |  | -4007870 | -34808151.55 | 30800281.55 | 0
 |  |  | -1577469.23 | -1496629.72 | -80839.51 | 0
 |  |  | -90.35 | -151928.08 | 151837.73 | 0
 |  |  | 1339548.76 | 516458.46 | 823090.3 | -33415.42
 |  | Inter-Company | 1158 | 1158 | 0 | 12.39
 |  | Other Assets | 0 | 0 | 0 | 0
 |  |  | 12829 | 12829 | 0 | 137.27
 |  | Other Liabilities | -1062 | -702 | -360 | -8.61
 | NOK Sum |  |  |  |  | -553387.73
 | NZD | Other Liabilities | 0 | 0 | 0 | 0
 | NZD Sum |  |  |  |  | 0
 | SEK | Deferred Revenue | -1978622.51 | -1196286.15 | -782336.36 | -357538.76
 |  |  | -100.04 | -350.04 | 250 | 0
 |  |  | 915411.23 | -13717019.92 | 14632431.15 | 0
 |  |  | 1798240.73 | 4173854.18 | -2375613.45 | -28296.82
 |  | Inter-Company | 1550 | 1550 | 0 | 16.13
 |  |  | 375658.53 | 309065.73 | 66592.8 | 3765.69
 |  | Other Liabilities | -254 | -254 | 0 | -2.64
 |  |  | 0 | 0 | 0 | 0
 | SEK Sum |  |  |  |  | -382056.4
 | SGD | Deferred Revenue | -365088.34 | -343663.47 | -21424.87000000005 | 0
 |  |  | 0 | -985.92 | 985.92 | -8733.91
 |  |  | 541.2 | -3109.84 | 3651.04 | 0
 |  |  | 592048.85 | 717730.02 | -125681.17 | -22069.07
 |  | Inter-Company | 1515759.54 | 1317703.8 | 198055.74 | 29234.23
 | SGD Sum |  |  |  |  | -1568.75
 | USD | Deferred Revenue | -176756860.8 | -168763907.11 | -7992953.689999998 | 0
 |  |  | -92350327.75 | -82722878.65 | -9627449.099999994 | 0
 |  |  | -14614580.9 | -11354116.17 | -3260464.73 | 0
 |  |  | -7133604.18 | -7075143.13 | -58461.04999999981 | 0
 |  |  | -3460445.52 | -1410697.4 | -2049748.12 | 0
 |  |  | -2773924.98 | -2637763.68 | -136161.3 | 0
 |  |  | -2640035.04 | 3656717.09 | -6296752.13 | 0
 |  |  | -293398.55 | -205483.69 | -87914.86 | 0
 |  |  | -172124.83 | -128901.34 | -43223.49 | 0
 |  |  | -132321.2 | -62693.74 | -69627.46 | 0
 |  |  | -87070.26 | 312066.13 | -399136.39 | 0
 |  |  | -55725.79 | -31918.13 | -23807.66 | 0
 |  |  | -54268.36 | -36616.13 | -17652.23 | 0
 |  |  | -13680.55 | -8129.42 | -5551.13 | 0
 |  |  | -226.8 | 15089.19 | -15315.99 | 0
 |  |  | 0 | 179587.65 | -179587.65 | 0
 |  | Inter-Company | -20867.89 | -9730.31 | -11137.58 | 0
 |  |  | 8611.78 | 9161.98 | -550.1999999999989 | 0
 |  |  | 34357.92 | -2705 | 37062.92 | 0
 |  |  | 84534.71 | 58904.05 | 25630.66 | 0
 |  |  | 403269.32 | 332720.2 | 70549.12 | 0
 |  | Other | -443439.68 | -407622.91 | -35816.77 | 0
 |  |  | -426603.47 | -401771.33 | -24832.14 | 0
 |  | Other Assets | -1013405.19 | -1084130.3 | 70725.1100000001 | 0
 |  |  | -858742.9 | -812774.3 | -45968.6 | 0
 |  | Other Liabilities | -5369487.06 | -5252459.06 | -117028 | 0
 |  |  | -136604.34 | -132191.92 | -4412.419999999984 | 0
 | USD Sum |  |  |  |  | 0
USD Co's Sum |  |  |  |  |  | -137610227.59
(blank) | (blank) | (blank) | (blank) | (blank) | (blank) | -137873196.7510191
 | (blank) Sum |  |  |  |  | -137873196.7510191
(blank) Sum |  |  |  |  |  | -137873196.7510191
Grand Total |  |  |  |  |  | -275746393.5020382