ABCDE
3ASSIGNMENT:0ALLOC_NMBRAADOJun-2018
4
5Sum of AMOUNT_DC:0BALANCEPeriod
6GL_ACCOUNT:0GL_ACCOUNTTRAD_PART:0PCOMPANYDec-17Jun-18variance
72090000AA11(8,577,429.19)(8,878,897.30)(301,468.11)
82090000AA120.00
92090000AA130.00
102090000AA160.00
112090000AA33(472,397.68)(293,905.64)178,492.04
122090000AA380.00
132090000AA400.00
142090000AACI(2,836.36)(2,836.36)
152090000AADC(37,149.80)(21,495.04)15,654.76
162090000AAIB(54,788,390.57)(54,089,414.34)698,976.23
172090000AATN4,408.32 (4,408.32)
182090000AATR0.00
192090000DACH0.00
202090000 Total(63,870,958.92)(63,286,548.68)584,410.24
216510000AA111,887,034.42 1,953,357.44 66,323.02
226510000AA120.00
236510000AA130.00
246510000AA160.00
256510000AA33163,449.59 101,691.35 (61,758.24)
266510000AA380.00
276510000AA400.00
286510000AACI468.00 468.00
296510000AADC13,002.43 4,513.96 (8,488.47)
306510000AAIB602,672.38 594,983.46 (7,688.92)
316510000AATN(1,102.08)1,102.08
326510000AATR0.00
336510000DACH0.00
346510000 Total2,665,056.74 2,655,014.21 (10,042.53)
358500990AA118,577,429.19 8,878,897.30 301,468.11
368500990AA120.00
378500990AA130.00
388500990AA160.00
398500990AA33472,397.68 293,905.64 (178,492.04)
408500990AA380.00
418500990AA400.00
428500990AACI2,836.36 2,836.36
438500990AADC37,149.80 21,495.04 (15,654.76)
448500990AAIB54,788,390.57 54,089,414.34 (698,976.23)
458500990AATN(4,408.32)4,408.32
468500990AATR0.00
478500990DACH0.00
488500990 Total63,870,958.92 63,286,548.68 (584,410.24)
499900100AA11(1,887,034.42)(1,953,357.44)(66,323.02)
509900100AA120.00
519900100AA130.00
529900100AA160.00
539900100AA33(163,449.59)(101,691.35)61,758.24
549900100AA380.00
559900100AA400.00
569900100AACI(468.00)(468.00)
579900100AADC(13,002.43)(4,513.96)8,488.47
589900100AAIB(602,672.38)(594,983.46)7,688.92
599900100AATN1,102.08 (1,102.08)
609900100AATR0.00
619900100DACH0.00
629900100 Total(2,665,056.74)(2,655,014.21)10,042.53
63Grand Total0.00 0.00 0.00

pivot AADC



Worksheet Formulas
CellFormula
C3=IF(D6<>"Dec",EOMONTH(DATE(VALUE(MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1),1)+4,4)),VALUE(MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1),1)+1,2)),1),0),EOMONTH(DATE(VALUE(MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1),1)+4,4)+1),VALUE(MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1),1)+1,2)),1),0))