{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Informácie o účtovnej závierke","Strana aktív","Strana pasív"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Informácie o účtovnej závierke","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Informácie o účtovnej závierke:"]
["Názov účtovnej jednotky:","Mesto Michalovce"]
["IČO:","00325490"]
["DIČ:","2020739039"]
["Mesto:","Michalovce"]
["Ulica:","Nám. osloboditeľov 1015/30"]
["Obdobie:","01/2022 - 12/2022"]
["Typ závierky:","Konsolidovaná riadna"]
["Predložená dňa:","20.06.2023"]
["Zostavená dňa:","16.06.2023"]
["Schválená dňa:",""]
["SA uložená dňa:","25.07.2023"]
["Typ výkazu:","Kons S UJ VS Úč 1-01 - Súvaha"]
["Tlačová zostava vytvorená:","13.07.2026 03:31:07"]

{"sheet":"Strana aktív","index":1,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2]]}
["Označenie","STRANA AKTÍV","Číslo riadku","2022","2021"]
[null,null,null,"Netto","Netto"]
["a","b","c","1","2"]
["","SPOLU MAJETOK r. 002 + r. 035 + r. 113 + r. 117","1",1.1188957338E8,1.1203580907E8]
["A.","Neobežný majetok r. 003 + r. 012 + r. 025","2",1.053409393E8,1.0229781191E8]
["A.I.","Dlhodobý nehmotný majetok súčet (r. 004 až 011)","3",89597.68,50833.8]
["A.I.1.","Aktivované náklady na vývoj (012) - (072+091AÚ)","4",0.0,0.0]
["2.","Softvér (013) - (073+091AÚ)","5",89597.68,50833.8]
["3.","Oceniteľné práva (014) - (074+091AÚ)","6",0.0,0.0]
["4.","Goodwill z konsolidácie kapitálu alebo negatívny goodwill z konsolidácie kapitálu (+/-)","7",0.0,0.0]
["5.","Drobný dlhodobý nehmotný majetok (018) - (078+091AÚ)","8",0.0,0.0]
["6.","Ostatný dlhodobý nehmotný majetok (019) - (079+091AÚ)","9",0.0,0.0]
["7.","Obstaranie dlhodobého nehmotného majetku (041) - (093)","10",0.0,0.0]
["8.","Poskytnuté preddavky na dlhodobý nehmotný majetok (051) - (095AÚ)","11",0.0,0.0]
["A.II.","Dlhodobý hmotný majetok súčet (r. 013 až 024)","12",9.397340543E7,9.051614097E7]
["A.II.1.","Pozemky (031) - (092AÚ)","13",2.23808104E7,2.245890053E7]
["2.","Umelecké diela a zbierky (032) - (092AÚ)","14",255303.53,220631.13]
["3.","Predmety z drahých kovov (033) - (092AÚ)","15",0.0,0.0]
["4.","Stavby (021) - (081+092AÚ)","16",6.445211454E7,6.226318292E7]
["5.","Samostatné hnuteľné veci a súbory hnuteľných vecí (022)-(082+092AÚ)","17",454012.63,630477.17]
["6.","Dopravné prostriedky (023) - (083+092AÚ)","18",352824.41,370651.42]
["7.","Pestovateľské celky trvalých porastov (025) - (085+092AÚ)","19",0.0,0.0]
["8.","Základné stádo a ťažné zvieratá (026) - (086+092AÚ)","20",0.0,0.0]
["9.","Drobný dlhodobý hmotný majetok (028) - (088+092AÚ)","21",0.0,0.0]
["10.","Ostatný dlhodobý hmotný majetok (029) - (089+092AÚ)","22",606952.54,618691.48]
["11.","Obstaranie dlhodobého hmotného majetku (042) - (094)","23",5471387.38,3953606.32]
["12.","Poskytnuté preddavky na dlhodobý hmotný majetok (052) - (095AÚ)","24",0.0,0.0]
["A.III.","Dlhodobý finančný majetok súčet (r. 026 + r. 027 + r. 029 až 034)","25",1.127793619E7,1.173083714E7]
["A.III.1.","Podielové cenné papiere a podiely v dcérskej účtovnej jednotke (061) - (096AÚ)","26",0.0,0.0]
["2.","Podielové cenné papiere a podiely v spoločnosti s podstatným vplyvom (062) - (096AÚ)","27",2440360.41,0.0]
["","z toho: goodwill","28",0.0,0.0]
["3.","Realizovateľné cenné papiere a podiely (063) - (096AÚ)","29",7985454.78,9720520.14]
["4.","Dlhové cenné papiere držané do splatnosti (065) - (096AÚ)","30",0.0,0.0]
["5.","Pôžičky účtovnej jednotke v konsolidovanom celku (066) - (096AÚ)","31",0.0,0.0]
["6.","Ostatné pôžičky (067) - (096AÚ)","32",0.0,0.0]
["7.","Ostatný dlhodobý finančný majetok (069) - (096AÚ)","33",0.0,0.0]
["8.","Obstaranie dlhodobého finančného majetku (043) - (096AÚ)","34",852121.0,2010317.0]
["B.","Obežný majetok r. 036 + r. 042 + r. 050 + r. 063 + r. 088+ r. 101 + r. 107","35",6388941.45,9573827.15]
["B.I.","Zásoby súčet (r. 037 až 041)","36",226875.18,238627.08]
["B.I.1.","Materiál (112 + 119) - (191)","37",216650.2,231559.58]
["2.","Nedokončená výroba a polotovary (121 + 122) - (192 + 193)","38",0.0,0.0]
["3.","Výrobky (123) - (194)","39",0.0,0.0]
["4.","Zvieratá (124) - (195)","40",430.0,430.0]
["5.","Tovar (132 + 133 + 139) - (196)","41",9794.98,6637.5]
["B.II.","Zúčtovanie medzi subjektami verejnej správy súčet (r. 043 až r. 049)","42",23058.0,33409.45]
["B.II.1.","Zúčtovanie odvodov príjmov rozpočtových organizácií do rozpočtu zriaďovateľa (351)","43",0.0,0.0]
["2.","Zúčtovanie transferov štátneho rozpočtu (353)","44",0.0,0.0]
["3.","Zúčtovanie transferov rozpočtu obce a vyššieho územného celku (355)","45",0.0,0.0]
["4.","Zúčtovanie transferov zo štátneho rozpočtu v rámci konsolidovaného celku (356)","46",0.0,0.0]
["5.","Ostatné zúčtovanie rozpočtu obce a vyššieho územného celku (357)","47",23058.0,33409.45]
["6.","Zúčtovanie transferov zo štátneho rozpočtu iným subjektom (358)","48",0.0,0.0]
["7.","Zúčtovanie transferov medzi subjektami verejnej správy a iné zúčtovania (359)","49",0.0,0.0]
["B. III","Dlhodobé pohľadávky súčet (r. 051 až 061)","50",200278.83,230461.53]
["B.III.1.","Odberatelia (311AÚ) - (391AÚ)","51",0.0,0.0]
["2.","Zmenky na inkaso (312AÚ) - (391AÚ)","52",0.0,0.0]
["3.","Pohľadávky za eskontované cenné papiere (313AÚ) - (391AÚ)","53",0.0,0.0]
["4.","Ostatné pohľadávky (315AÚ) - (391AÚ)","54",0.0,0.0]
["5.","Pohľadávky voči zamestnancom (335AÚ) - (391AÚ)","55",0.0,0.0]
["6.","Pohľadávky voči združeniu (369AÚ) - (391AÚ)","56",0.0,0.0]
["7.","Pohľadávky a záväzky z pevných termínových operácií (373AÚ) - (391AÚ)","57",0.0,0.0]
["8.","Pohľadávky z nájmu (374AÚ) - (391AÚ)","58",0.0,0.0]
["9.","Pohľadávky z vydaných dlhopisov (375AÚ) - (391AÚ)","59",0.0,0.0]
["10.","Nakúpené opcie (376AÚ) - (391AÚ)","60",0.0,0.0]
["11.","Iné pohľadávky (378AÚ) - (391AÚ)","61",200278.83,230461.53]
["","z toho: odložená daňová pohľadávka","62",0.0,0.0]
["B.IV.","Krátkodobé pohľadávky súčet (r. 064 až 087)","63",929038.7,1010179.37]
["B.IV.1.","Odberatelia (311AÚ) - (391AÚ)","64",160630.68,139523.29]
["2.","Zmenky na inkaso (312AÚ) - (391AÚ)","65",0.0,0.0]
["3.","Pohľadávky za eskontované cenné papiere (313AÚ) - (391AÚ)","66",0.0,0.0]
["4.","Poskytnuté prevádzkové preddavky (314) - (391AÚ)","67",3125.24,3304.24]
["5.","Ostatné pohľadávky (315AÚ) - (391AÚ)","68",234373.99,184531.68]
["6.","Pohľadávky z nedaňových rozpočtových príjmov (316) - (391AÚ)","69",0.0,0.0]
["7.","Pohľadávky z daňových a colných rozpočtových príjmov (317) - (391AÚ)","70",0.0,0.0]
["8.","Pohľadávky z nedaňových príjmov obcí a vyšších územných celkov a rozpočtových organizácií zriadených obcou a vyšším územným celkom (318) - (391AÚ)","71",290468.87,362466.38]
["9.","Pohľadávky z daňových príjmov obcí a vyšších územných celkov (319) - (391AÚ)","72",129224.94,251737.68]
["10.","Pohľadávky voči zamestnancom (335AÚ) - (391AÚ)","73",22013.45,4268.39]
["11.","Zúčtovanie s orgánmi sociálneho poistenia a zdravotného poistenia (336) - (391AÚ)","74",0.0,0.0]
["12.","Daň z príjmov (341) - (391AÚ)","75",0.0,5548.24]
["13.","Ostatné priame dane (342) - (391AÚ)","76",0.0,0.0]
["14.","Daň z pridanej hodnoty (343) - (391AÚ)","77",1425.0,1496.64]
["15.","Ostatné dane a poplatky (345) - (391AÚ)","78",973.0,0.0]
["16.","Pohľadávky voči združeniu (369AÚ) - (391AÚ)","79",0.0,0.0]
["17.","Pohľadávky a záväzky z pevných termínovaných operácií (373AÚ) - (391AÚ)","80",0.0,0.0]
["18.","Pohľadávky z nájmu (374AÚ) - (391AÚ)","81",0.0,0.0]
["19.","Pohľadávky z vydaných dlhopisov (375AÚ) - (391AÚ)","82",0.0,0.0]
["20.","Nakúpené opcie (376AÚ) - (391AÚ)","83",0.0,0.0]
["21.","Iné pohľadávky (378AÚ) - (391AÚ)","84",86803.53,57302.83]
["22.","Spojovací účet pri združení (396AÚ)","85",0.0,0.0]
["23.","Zúčtovanie s Európskou úniou (371AÚ)- (391AÚ)","86",0.0,0.0]
["24.","Transfery a ostatné zúčtovanie so subjektami mimo verejnej správy (372AÚ) - (391AÚ)","87",0.0,0.0]
["B.V.","Finančné účty súčet (r. 089 až 100)","88",5009690.74,8061149.72]
["B.V.1.","Pokladnica (211)","89",13687.98,9914.9]
["2.","Ceniny (213)","90",4118.39,13121.3]
["3.","Bankové účty (221AÚ +/- 261)","91",4991884.37,8038113.52]
["4.","Účty v bankách s dobou viazanosti dlhšou ako jeden rok (221AÚ)","92",0.0,0.0]
["5.","Výdavkový rozpočtový účet (222)","93",0.0,0.0]
["6.","Príjmový rozpočtový účet (223)","94",0.0,0.0]
["7.","Majetkové cenné papiere na obchodovanie (251) - (291AÚ)","95",0.0,0.0]
["8.","Dlhové cenné papiere na obchodovanie (253) - (291AÚ)","96",0.0,0.0]
["9.","Dlhové cenné papiere so splatnosťou do jedného roka držané do splatnosti (256) - (291AÚ)","97",0.0,0.0]
["10.","Ostatné realizovateľné cenné papiere (257) - (291AÚ)","98",0.0,0.0]
["11.","Obstaranie krátkodobého finančného majetku (259) - (291AÚ)","99",0.0,0.0]
["12.","Účty Štátnej pokladnice (účtová skupina 28)","100",0.0,0.0]
["B.VI.","Poskytnuté návratné finančné výpomoci dlhodobé súčet (r. 102 až r. 106)","101",0.0,0.0]
["B.VI.1.","Poskytnuté návratné finančné výpomoci subjektom v rámci konsolidovaného celku (271AÚ) - (291AÚ)","102",0.0,0.0]
["2.","Poskytnuté návratné finančné výpomoci ostatným subjektom verejnej správy (272AÚ) - (291AÚ)","103",0.0,0.0]
["3.","Poskytnuté návratné finančné výpomoci podnikateľským subjektom (274AÚ) - (291AÚ)","104",0.0,0.0]
["4.","Poskytnuté návratné finančné výpomoci ostatným organizáciám (275AÚ) - (291AÚ)","105",0.0,0.0]
["5.","Poskytnuté návratné finančné výpomoci fyzickým osobám (277AÚ) - (291AÚ)","106",0.0,0.0]
["B.VII.","Poskytnuté návratné finančné výpomoci krátkodobé súčet (r. 108 až r. 112)","107",0.0,0.0]
["B.VII.1.","Poskytnuté návratné finančné výpomoci subjektom v rámci konsolidovaného celku (271AÚ) - (291AÚ)","108",0.0,0.0]
["2.","Poskytnuté návratné finančné výpomoci ostatným subjektom verejnej správy (272AÚ) - (291AÚ)","109",0.0,0.0]
["3.","Poskytnuté návratné finančné výpomoci podnikateľským subjektom (274AÚ) - (291AÚ)","110",0.0,0.0]
["4.","Poskytnuté návratné finančné výpomoci ostatným organizáciám (275AÚ) - (291AÚ)","111",0.0,0.0]
["5.","Poskytnuté návratné finančné výpomoci fyzickým osobám (277AÚ) - (291AÚ)","112",0.0,0.0]
["C.","Časové rozlíšenie súčet (r. 114 až r. 116)","113",159692.63,164170.01]
["C. 1.","Náklady budúcich období (381)","114",100977.49,96862.01]
["2.","Komplexné náklady budúcich období (382)","115",0.0,0.0]
["3.","Príjmy budúcich období (385)","116",58715.14,67308.0]
["D.","Vzťahy k účtom klientov Štátnej pokladnice (účtová skupina 20)","117",0.0,0.0]

{"sheet":"Strana pasív","index":2,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Označenie","STRANA PASÍV","Číslo riadku","2022","2021"]
["a","b","c","3","4"]
["","VLASTNÉ IMANIE A ZÁVÄZKY r. 119 + r. 130 + r. 185 + r. 188","118",1.1188957338E8,1.1203580907E8]
["A.","Vlastné imanie r. 120 + r. 123 + r. 126 + r. 129","119",7.232049476E7,7.339235531E7]
["A.I.","Oceňovacie rozdiely súčet (r. 121 + r. 122)","120",0.0,0.0]
["A.I.1.","Oceňovacie rozdiely z precenenia majetku a záväzkov (+/– 414)","121",0.0,0.0]
["2.","Oceňovacie rozdiely z kapitálových účastín (+/– 415)","122",0.0,0.0]
["A.II.","Fondy súčet (r. 124 + r. 125)","123",0.0,0.0]
["A.II.1.","Zákonný rezervný fond (421)","124",0.0,0.0]
["2.","Ostatné fondy (427)","125",0.0,0.0]
["A.III.","Výsledok hospodárenia (+/-) súčet (r. 127 až 128)","126",7.232049476E7,7.339235531E7]
["A.III.1.","Nevysporiadaný výsledok hospodárenia minulých rokov (+/– 428)","127",7.339193431E7,7.255570014E7]
["2.","Výsledok hospodárenia za účtovné obdobie (+/–) r. 001 - (r.120 + r. 123 + r.127 + r.129 + r. 130 + r. 185 + r. 188)","128",-1071439.55,836655.17]
["A.IV.","Podiely iných učtovných jednotiek","129",0.0,0.0]
["B.","Záväzky súčet r. 131 + r. 136 + r. 144 + r. 156 + r. 178","130",1.893913911E7,2.040747534E7]
["B.I.","Rezervy súčet (r. 132 až 135)","131",1025968.31,1070707.48]
["B.I.1.","Rezervy zákonné dlhodobé (451AÚ)","132",200278.83,230461.53]
["2.","Ostatné rezervy (459AÚ)","133",722890.0,726511.08]
["3.","Rezervy zákonné krátkodobé (323AÚ, 451AÚ)","134",31941.0,28349.0]
["4.","Ostatné krátkodobé rezervy (323AÚ, 459AÚ)","135",70858.48,85385.87]
["B.II.","Zúčtovanie medzi subjektami verejnej správy súčet (r. 137 až r. 143)","136",89637.73,2048914.25]
["B.II.1.","Zúčtovanie odvodov príjmov rozpočtových organizácií do rozpočtu zriaďovateľa (351)","137",0.0,0.0]
["2.","Zúčtovanie transferov štátneho rozpočtu (353)","138",0.0,0.0]
["3.","Zúčtovanie transferov rozpočtu obce a vyššieho územného celku (355)","139",0.0,0.0]
["4.","Zúčtovanie transferov zo štátneho rozpočtu v rámci konsolidovaného celku (356)","140",0.0,0.0]
["5.","Ostatné zúčtovanie rozpočtu obce a vyššieho územného celku (357)","141",89637.73,2048914.25]
["6.","Zúčtovanie transferov zo štátneho rozpočtu iným subjektom (358)","142",0.0,0.0]
["7.","Zúčtovanie transferov medzi subjektami verejnej správy a iné zúčtovania (359)","143",0.0,0.0]
["B.III.","Dlhodobé záväzky súčet (r. 145 až 153 + r. 155)","144",2984880.48,3148414.75]
["B.III.1.","Ostatné dlhodobé záväzky (479AÚ)","145",2793305.24,2968594.25]
["2.","Dlhodobé prijaté preddavky (475AÚ)","146",0.0,0.0]
["3.","Dlhodobé zmenky na úhradu (478AÚ)","147",0.0,0.0]
["4.","Záväzky zo sociálneho fondu (472)","148",68272.2,96200.15]
["5.","Záväzky z nájmu (474AÚ)","149",123286.72,83555.07]
["6.","Dlhodobé nevyfakturované dodávky (476AÚ)","150",0.0,0.0]
["7.","Pohľadávky a záväzky z pevných termínových operácií (373AÚ)","151",0.0,0.0]
["8.","Predané opcie (377AÚ)","152",0.0,0.0]
["9.","Iné záväzky (379AÚ)","153",16.32,65.28]
["","z toho: odložený daňový záväzok","154",0.0,0.0]
["10.","Vydané dlhopisy dlhodobé (473AÚ) - (255AÚ)","155",0.0,0.0]
["B.IV.","Krátkodobé záväzky súčet (r. 157 až 177)","156",3966842.64,4754167.49]
["B.IV.1.","Dodávatelia (321)","157",476847.21,474593.38]
["2.","Zmenky na úhradu (322, 478AÚ)","158",0.0,0.0]
["3.","Prijaté preddavky (324, 475AÚ)","159",200046.64,201761.21]
["4.","Ostatné záväzky (325, 479AÚ)","160",176650.61,174170.94]
["5.","Nevyfakturované dodávky (326, 476AÚ)","161",28295.2,2093.0]
["6.","Záväzky z nájmu (474AÚ)","162",57260.48,45875.22]
["7.","Pohľadávky a záväzky z pevných termínových operácií (373AÚ)","163",0.0,0.0]
["8.","Predané opcie (377AÚ)","164",0.0,0.0]
["9.","Iné záväzky (379AÚ)","165",181520.4,199891.55]
["10.","Záväzky z upísaných nesplatených cenných papierov a vkladov (367)","166",852121.0,1421773.0]
["11.","Záväzky voči združeniu (368)","167",0.0,0.0]
["12.","Zamestnanci (331)","168",1047794.27,1141192.68]
["13.","Ostatné záväzky voči zamestnancom (333)","169",501.0,524.65]
["14.","Zúčtovanie s orgánmi sociálneho poistenia a zdravotného poistenia (336)","170",753537.78,844381.65]
["15.","Daň z príjmov (341)","171",8292.45,1994.24]
["16.","Ostatné priame dane (342)","172",151708.21,198809.29]
["17.","Daň z pridanej hodnoty (343)","173",20237.01,12508.0]
["18.","Ostatné dane a poplatky (345)","174",734.0,1028.42]
["19.","Spojovací účet pri združení (396AÚ)","175",0.0,0.0]
["20.","Zúčtovanie s Európskou úniou (371AÚ)","176",6093.36,32447.88]
["21.","Transfery a ostatné zúčtovanie so subjektami mimo verejnej správy (372AÚ)","177",5203.02,1122.38]
["B.V.","Bankové úvery a výpomoci súčet (r. 179 až 184)","178",1.087180995E7,9385271.37]
["B.V.1.","Bankové úvery dlhodobé (461AÚ)","179",7097591.11,5631223.17]
["2.","Bežné bankové úvery (461AÚ, 221AÚ, 231, 232)","180",2923944.84,2903774.2]
["3.","Vydané dlhopisy krátkodobé (473AÚ, 241) - (255AÚ)","181",0.0,0.0]
["4.","Ostatné krátkodobé finančné výpomoci (249)","182",0.0,0.0]
["5.","Prijaté návratné finančné výpomoci od subjektov verejnej správy dlhodobé (273AÚ)","183",850274.0,850274.0]
["6.","Prijaté návratné finančné výpomoci od subjektov verejnej správy krátkodobé (273AÚ)","184",0.0,0.0]
["C.","Časové rozlíšenie súčet (r. 186 + r. 187)","185",2.062993951E7,1.823597842E7]
["C.1.","Výdavky budúcich období (383)","186",107070.76,125884.07]
["2.","Výnosy budúcich období (384)","187",2.052286875E7,1.811009435E7]
["D.","Vzťahy k účtom klientov Štátnej pokladnice (účtová skupina 20)","188",0.0,0.0]