Corelatii bilant (raportare contabila) la 30.06.2011 – info util

Va prezentam in continuare corelatiile din cadrul formularelor din situatiile financiare la 30.06.2011, din considerentul ca in cazul unor erori la generarea acestuia va puteti verifica usor cu ajutorul acestui articol.

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) --------------------------------------------------------------------------------------

Program pentru generarea bilantului la 30.06.2011 (PDF) – click aici

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