Corelatii in cadrul formularelor din situatiile financiare la 30.06.2011 CAPITALURI PROPRII - TOTAL (rd. 19+23+24+25-26+27-28+29-30+31-32-33) BILANT PRESCURTAT (cod 10) Rd. 04 = rd. 01 la 03 (col. 1 si 2) Rd. 09 = rd. 05 la 08 (col. 1 si 2) Rd. 12 = rd. 09 + 10 - 11 - 19 (col. 1 si 2) Rd. 13 = rd. 04 + 12 (col. 1 si 2) Rd. 16 = rd. 17 + 18 +21 (col. 1 si 2) Rd. 18 = rd. 19 + 20 (col. 1 si 2) Rd. 22 = rd. 23 la 25 (col. 1 si 2) Rd. 37 = rd. 22 + 26 + 27 + 28 - 29 + 30 - 31 + 32 - 33 + 34 - 35 - 36 (col. 1 si 2) Rd. 39 = rd. 37 + 38 (col. 1 si 2) ------ Rd. 39 = rd. 13 - 14 - 15 - 17 - 20 - 21 (F-G-H-I1-I4-I5) (col. 1 si 2) Rd. 22 + 38 >= 0 (col. 1 si 2) -------------------------------------------------------------------------------------- CONTUL DE PROFIT SI PIERDERE (cod 20) Rd. 01 >= 0 (col. 1 si 2) Rd. 01 = rd. 02 + 03 - 04 + 05 + 06 (col. 1 si 2) Rd. 10 >= rd. 11 (col. 1 si 2) Rd. 12 = rd. 01 + 07 - 08 + 09 + 10 (col. 1 si 2) Rd. 18 = rd. 19 + 20 (col. 1 si 2) Rd. 21 = rd. 22 - 23 (col. 1 si 2) Rd. 24 = rd. 25 - 26 (col. 1 si 2) Rd. 27 = rd. 28 la 31 (col. 1 si 2) Rd. 32 = rd. 33 - 34 (col. 1 si 2) Rd. 35 = rd. 13 la 16 - 17 + 18 + 21 + 24 + 27 + 32 (col. 1 si 2) Rd. 36 = rd. 12 - 35, daca rd. 12 - 35 > 0 (col. 1 si 2) Rd. 37 = rd. 35 - 12, daca rd. 12 - 35 <= 0 (col. 1 si 2) Rd. 38 >= rd. 39 (col. 1 si 2) Rd. 40 >= rd. 41 (col. 1 si 2) Rd. 42 >= rd. 43 (col. 1 si 2) Rd. 45 = rd. 38 + 40 + 42 + 44 (col. 1 si 2) Rd. 46 = rd. 47 - 48 (col. 1 si 2) Rd. 49 >= 50 (col. 1 si 2) Rd. 52 = rd. 46 + 49 + 51 (col. 1 si 2) Rd. 53 = rd. 45 - 52, daca rd. 45 - 52 > 0 (col. 1 si 2) Rd. 54 = rd. 52 - 45, daca rd. 45 - 52 <= 0 (col. 1 si 2) Rd. 55 = rd. 12 + 45 - 35 - 52, daca rd. 12 + 45 - 35 - 52 > 0 (col. 1 si 2) Rd. 56 = rd. 35 + 52 - 12 - 45, daca rd. 12 + 45 - 35 - 52 <= 0 (col. 1 si 2) Rd. 59 = rd. 57 - 58, daca rd. 57 - 58 > 0 (col. 1 si 2) Rd. 60 = rd. 58 - 57, daca rd. 57 - 58 <= 0 (col. 1 si 2) Rd. 61 = rd. 12 + 45 + 57 (col. 1 si 2) Rd. 62 = rd. 35 + 52 + 58 (col. 1 si 2) Rd. 63 = rd. 61 - 62, daca rd. 61 - 62 > 0 (col. 1 si 2) Rd. 64 = rd. 62 - 61, daca rd. 61 - 62 <= 0 (col. 1 si 2) Rd. 67 = rd.63 - 64 - 65 - 66 , daca rd.63 - 64 - 65 - 66 > 0 (col. 1 si 2) Rd. 68 = rd.64 + 65 + 66 - 63 , daca rd.63 - 64 - 65 - 66 <= 0 (col. 1 si 2) -------------------------------------------------------------------------------------- DATE INFORMATIVE (cod 30) Rd. 01+02 = "1" (col. 1) Totaluri pe orizontala: Col. 1 = col. 2 + 3 (se repeta de la rd.03 la 22) Totaluri pe verticala: Rd. 03 = rd. 04 + 08 + 14 la 18 + 22 (col. 1, 2 si 3) Rd. 04 = rd. 05 la 07 (col. 1, 2 si 3) Rd. 08 = rd. 09 la 13 (col. 1, 2 si 3) Rd. 18 = rd. 19 la 21 (col. 1, 2 si 3) Rd. 24 >= Rd.25 (col.1) Rd. 26 >= Rd.27 (col.1) Rd. 28 >= Rd.29 (col.1) Rd. 30 >= Rd.31 (col.1) Rd. 32 >= Rd.33 (col.1) Rd. 34 >= Rd.35 (col.1) Rd. 36 >= Rd.37 (col.1) Rd. 39 >= rd. 40 + 41 (col. 1 si 2) Rd. 42 = rd. 43 la 45 (col. 1 si 2) Rd. 46 = rd. 47 + 55 (col. 1 si 2) Rd. 47 = rd. 48 la 54 (col. 1 si 2) Rd. 55 = rd. 56 + 57 (col. 1 si 2) Rd. 58 >= Rd.59 (col.1) Rd. 61 = rd. 62 la 66 (col. 1 si 2) Rd. 68 = rd. 69 la 70 (col. 1 si 2) Rd. 71 >= Rd.72 (col.1) Rd. 73 = rd. 74 la 80 (col. 1 si 2) Rd. 82 = rd. 83 + 84 (col. 1 si 2) Rd. 85 = rd. 86 + 87 (col. 1 si 2) Rd. 88 = rd. 89 + 90 (col. 1 si 2) Rd. 91 = rd. 92 + 95 + 98 + 101 + 104 + 107 + 110 + 113 + (col. 1 si 2) 116 + 119 + 122 + 123 + 126 + 128 + 129 + 134 + 135 + 136 + 141 Rd. 92 = rd. 93 + 94 (col. 1 si 2) Rd. 95 = rd. 96 + 97 (col. 1 si 2) Rd. 98 = rd. 99 + 100 (col. 1 si 2) Rd. 101 = rd. 102 + 103 (col. 1 si 2) Rd. 104 = rd. 105 + 106 (col. 1 si 2) Rd. 107 = rd. 108 + 109 (col. 1 si 2) Rd. 110 = rd. 111 + 112 (col. 1 si 2) Rd. 113 = rd. 114 + 115 (col. 1 si 2) Rd. 116 = rd. 117 + 118 (col. 1 si 2) Rd. 119 = rd. 120 + 121 (col. 1 si 2) Rd. 123 = rd. 124 + 125 (col. 1 si 2) Rd. 126 >= Rd.127 (col.1) Rd. 129 = rd. 130 la 133 (col. 1 si 2) Rd. 136 = rd. 137 la 140 (col. 1 si 2) Rd. 142 = rd. 143 la 146 (col. 1 si 2) -------------------------------------------------------------------------------------- Corelatii intre formularele situatiilor financiare la 30.06.2011 (corelatiile contin membri de forma FF.RR.C unde: FF=cod formular, RR=nr.rand, C=nr.coloana) ----corelatii intre F10 si F20------------- 10.34.1 = 20.67.1 profit 10.35.1 = 20.68.1 pierdere 10.34.2 = 20.67.2 profit 10.35.2 = 20.68.2 pierdere ----corelatii intre F10 si F30------------- 10.34.2 = 30.01.2 10.35.2 = 30.02.2 10.11.2 + 10.14.2 >= 30.03.1 (D+G) Corelatii suplimentare propuse de unitatile fiscale F10_023 col 1 si 2 >=0 (cap.subscris varsat) F10_024 col 1 si 2 >=0 (cap.subscris nevarsat) F10_025 col 1 si 2 >=0 (patrimoniul regiei) F10_026 col 1 si 2 >=0 (prime de capital) F10_028 col 1 si 2 >=0 (rezerve) F10_036 col 1 si 2 >=0 (repartizarea profitului) F20_002 col 1 si 2 >=0 F20_003 col 1 si 2 >=0 F20_004 col 1 si 2 >=0 F20_005 col 1 si 2 >=0 F20_006 col 1 si 2 >=0