{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Informácie o účtovnej závierke","Náklady","Výnosy"],"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 VZaS UJ VS Úč 2-01 - Výkaz ziskov a strát"]
["Tlačová zostava vytvorená:","21.05.2026 03:11:31"]

{"sheet":"Náklady","index":1,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,5],[0,6,1,6]]}
["Číslo účtu alebo skupiny","Náklady","Číslo riadku","2022",null,null,"2021"]
[null,null,null,"Hlavná činnosť","Podnikateľská činnosť","Spolu"]
["a","b","c","1","2","3","4"]
["50","Spotrebované nákupy (r. 002 až r. 005)","1",5326169.89,587973.97,5914143.86,4700974.0]
["501","Spotreba materiálu","2",2809548.05,188823.25,2998371.3,2791568.87]
["502","Spotreba energie","3",2054834.08,85224.12,2140058.2,1364308.67]
["503","Spotreba ostatných neskladovateľných dodávok","4",461756.68,247304.44,709061.12,487390.2]
["504, 507","Predaný tovar, Predaná nehnuteľnosť","5",31.08,66622.16,66653.24,57706.26]
["51","Služby (r. 007 až r. 010)","6",3213245.27,151276.04,3364521.31,2871945.8]
["511","Opravy a udržiavanie","7",426090.42,9687.64,435778.06,551949.09]
["512","Cestovné","8",47418.97,205.4,47624.37,6015.14]
["513","Náklady na reprezentáciu","9",20186.47,805.91,20992.38,9090.19]
["518","Ostatné služby","10",2719549.41,140577.09,2860126.5,2304891.38]
["52","Osobné náklady (r. 012 až r. 016)","11",2.541479765E7,726179.88,2.614097753E7,2.42754288E7]
["521","Mzdové náklady","12",1.792738553E7,506422.86,1.843380839E7,1.72570201E7]
["524","Zákonné sociálne poistenie","13",6246414.11,174890.4,6421304.51,6006375.79]
["525","Ostatné sociálne poistenie","14",245413.97,5170.33,250584.3,237312.9]
["527","Zákonné sociálne náklady","15",995584.04,39696.29,1035280.33,774623.21]
["528","Ostatné sociálne náklady","16",0.0,0.0,0.0,96.8]
["53","Dane a poplatky (r. 018 až r. 020)","17",9359.98,6766.27,16126.25,17865.52]
["531","Daň z motorových vozidiel","18",421.94,4346.26,4768.2,5637.67]
["532","Daň z nehnuteľnosti","19",4.4,0.0,4.4,4.4]
["538","Ostatné dane a poplatky","20",8933.64,2420.01,11353.65,12223.45]
["54","Ostatné náklady na prevádzkovú činnosť (r. 022 až r. 028)","21",1009399.59,5744.98,1015144.57,1258939.45]
["541","Zostatková cena predaného dlhodobého nehmotného majetku a dlhodobého hmotného majetku","22",101339.3,0.0,101339.3,128107.06]
["542","Predaný materiál","23",0.0,0.0,0.0,0.0]
["544","Zmluvné pokuty, penále a úroky z omeškania","24",5.17,1.83,7.0,84.21]
["545","Ostatné pokuty, penále a úroky z omeškania","25",230.26,0.0,230.26,472.76]
["546","Odpis pohľadávky","26",208005.21,3144.71,211149.92,280068.14]
["548","Ostatné náklady na prevádzkovú činnosť","27",699819.65,2598.44,702418.09,850207.28]
["549","Manká a škody","28",0.0,0.0,0.0,0.0]
["55","Odpisy, rezervy a opravné položky z prevádzkovej činnosti a finančnej činnosti a zúčtovanie časového rozlíšenia (r. 030 + r. 031 + r. 036 + r. 039)","29",5067972.61,6444.62,5074417.23,5104955.18]
["551","Odpisy dlhodobého nehmotného majetku a dlhodobého hmotného majetku","30",4290920.73,6156.98,4297077.71,4321009.69]
["","Rezervy a opravné položky z prevádzkovej činnosti (r. 032 až r. 035)","31",415334.72,287.64,415622.36,511076.17]
["552","Tvorba zákonných rezerv z prevádzkovej činnosti","32",0.0,0.0,0.0,2720.98]
["553","Tvorba ostatných rezerv z prevádzkovej činnosti","33",220145.95,0.0,220145.95,316920.63]
["557","Tvorba zákonných opravných položiek z prevádzkovej činnosti","34",0.0,287.64,287.64,256.24]
["558","Tvorba ostatných opravných položiek z prevádzkovej činnosti","35",195188.77,0.0,195188.77,191178.32]
["","Rezervy a opravné položky z finančnej činnosti (r. 037+ r. 038)","36",361717.16,0.0,361717.16,272869.32]
["554","Tvorba rezerv z finančnej činnosti","37",0.0,0.0,0.0,0.0]
["559","Tvorba opravných položiek z finančnej činnosti","38",361717.16,0.0,361717.16,272869.32]
["555","Zúčtovanie komplexných nákladov budúcich období","39",0.0,0.0,0.0,0.0]
["56","Finančné náklady (r. 041 až r. 049)","40",229912.81,5366.95,235279.76,137863.13]
["561","Predané cenné papiere a podiely","41",0.0,0.0,0.0,0.0]
["562","Úroky","42",53006.34,419.55,53425.89,53364.57]
["563","Kurzové straty","43",0.0,0.0,0.0,0.0]
["564","Náklady na precenenie cenných papierov","44",0.0,0.0,0.0,0.0]
["566","Náklady na krátkodobý finančný majetok","45",0.0,0.0,0.0,0.0]
["567","Náklady na derivátové operácie","46",0.0,0.0,0.0,0.0]
["568","Ostatné finančné náklady","47",176906.47,4947.4,181853.87,84498.56]
["569","Manká a škody na finančnom majetku","48",0.0,0.0,0.0,0.0]
["","Podiel konsolidujúcej účtovnej jednotky na výsledku hospodárenia pridružených účtovných jednotiek verejnej správy","49",0.0,0.0,0.0,0.0]
["57","Mimoriadne náklady (r. 051 až r. 054)","50",0.0,0.0,0.0,0.0]
["572","Škody","51",0.0,0.0,0.0,0.0]
["574","Tvorba rezerv","52",0.0,0.0,0.0,0.0]
["578","Ostatné mimoriadne náklady","53",0.0,0.0,0.0,0.0]
["1579","Tvorba opravných položiek","54",0.0,0.0,0.0,0.0]
["58","Náklady na transfery a náklady z odvodu príjmov (r. 056 až r. 064)","55",2983555.45,0.0,2983555.45,3029899.92]
["581","Náklady na transfery zo štátneho rozpočtu do štátnych rozpočtových organizácií a príspevkových organizácií","56",0.0,0.0,0.0,0.0]
["582","Náklady na transfery zo štátneho rozpočtu ostatným subjektom verejnej správy","57",0.0,0.0,0.0,0.0]
["583","Náklady na transfery zo štátneho rozpočtu subjektom mimo verejnej správy","58",0.0,0.0,0.0,0.0]
["584","Náklady na transfery z rozpočtu obce alebo z rozpočtu vyššieho územného celku do rozpočtových organizácií a príspevkových organizácií zriadených obcou alebo vyšším územným celkom","59",0.0,0.0,0.0,0.0]
["585","Náklady na transfery z rozpočtu obce alebo z rozpočtu vyššieho územného celku ostatným subjektom verejnej správy","60",115892.42,0.0,115892.42,56294.57]
["586","Náklady na transfery z rozpočtu obce alebo z rozpočtu vyššieho územného celku subjektom mimo verejnej správy","61",2742373.44,0.0,2742373.44,2766020.99]
["587","Náklady na ostatné transfery","62",125289.59,0.0,125289.59,207584.36]
["588","Náklady z odvodu príjmov","63",0.0,0.0,0.0,0.0]
["589","Náklady z budúceho odvodu príjmov","64",0.0,0.0,0.0,0.0]
["","Účtové skupiny 50 - 58 súčet (r. 001 + r. 006 + r. 011 + r. 017 + r. 021 + r. 029 + r. 040 + r. 050 + r. 055)","65",4.325441325E7,1489752.71,4.474416596E7,4.13978718E7]

{"sheet":"Výnosy","index":2,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,5],[0,6,1,6]]}
["Číslo účtu alebo skupiny","Výnosy, daň z príjmov a výsledok hospodárenia","Číslo riadku","2022",null,null,"2021"]
[null,null,null,"Hlavná činnosť","Podnikateľská činnosť","Spolu"]
["a","b","c","1","2","3","4"]
["60","Tržby za vlastné výkony a tovar (r. 067 až r. 069)","66",2793684.08,1386354.16,4180038.24,3131904.76]
["601","Tržby za vlastné výrobky","67",0.0,0.0,0.0,0.0]
["602","Tržby z predaja služieb","68",2793684.08,1287292.55,4080976.63,3035341.07]
["604","Tržby za tovar, Výnosy z nehnuteľnosti na predaj","69",0.0,99061.61,99061.61,96563.69]
["61","Zmena stavu vnútroorganizačných zásob (r. 071 až r. 074)","70",0.0,0.0,0.0,0.0]
["611","Zmena stavu nedokončenej výroby","71",0.0,0.0,0.0,0.0]
["612","Zmena stavu polotovarov","72",0.0,0.0,0.0,0.0]
["613","Zmena stavu výrobkov","73",0.0,0.0,0.0,0.0]
["614","Zmena stavu zvierat","74",0.0,0.0,0.0,0.0]
["62","Aktivácia (r. 076 až r. 079)","75",10520.64,15944.0,26464.64,23500.28]
["621","Aktivácia materiálu a tovaru","76",0.0,0.0,0.0,0.0]
["622","Aktivácia vnútroorganizačných služieb","77",10520.64,15944.0,26464.64,23500.28]
["623","Aktivácia dlhodobého nehmotného majetku","78",0.0,0.0,0.0,0.0]
["624","Aktivácia dlhodobého hmotného majetku","79",0.0,0.0,0.0,0.0]
["63","Daňové a colné výnosy a výnosy z poplatkov (r. 081 až r. 083)","80",2.172486061E7,0.0,2.172486061E7,2.023147679E7]
["631","Daňové a colné výnosy štátu","81",0.0,0.0,0.0,0.0]
["632","Daňové výnosy samosprávy","82",1.997215167E7,0.0,1.997215167E7,1.848678925E7]
["633","Výnosy z poplatkov","83",1752708.94,0.0,1752708.94,1744687.54]
["64","Ostatné výnosy z prevádzkovej činnosti (r. 085 až r. 090)","84",2364320.96,52922.17,2417243.13,3138996.24]
["641","Tržby z predaja dlhodobého nehmotného majetku a dlhodobého hmotného majetku","85",185578.03,0.0,185578.03,1172271.41]
["642","Tržby z predaja materiálu","86",0.0,0.0,0.0,0.0]
["644","Zmluvné pokuty, penále a úroky z omeškania","87",0.0,0.0,0.0,0.0]
["645","Ostatné pokuty, penále a úroky z omeškania","88",37724.53,0.0,37724.53,18643.54]
["646","Výnosy z odpísaných pohľadávok","89",0.0,0.0,0.0,146.0]
["648","Ostatné výnosy z prevádzkovej činnosti","90",2141018.4,52922.17,2193940.57,1947935.29]
["65","Zúčtovanie rezerv a opravných položiek z prevádzkovej činnosti a finančnej činnosti a zúčtovanie časového rozlíšenia (r. 092 + r. 097 + r. 100)","91",462678.42,7373.63,470052.05,1286664.49]
["","Zúčtovanie rezerv a opravných položiek z prevádzkovej činnosti (r. 093 až r. 096)","92",462678.42,7373.63,470052.05,1286664.49]
["652","Zúčtovanie zákonných rezerv z prevádzkovej činnosti","93",0.0,7373.63,7373.63,0.0]
["653","Zúčtovanie ostatných rezerv z prevádzkovej činnosti","94",272393.49,0.0,272393.49,1052484.82]
["657","Zúčtovanie zákonných opravných položiek z prevádzkovej činnosti","95",0.0,0.0,0.0,14658.18]
["658","Zúčtovanie ostatných opravných položiek z prevádzkovej činnosti","96",190284.93,0.0,190284.93,219521.49]
["","Zúčtovanie rezerv a opravných položiek z finančnej činnosti (r. 098 + r. 099)","97",0.0,0.0,0.0,0.0]
["654","Zúčtovanie rezerv z finančnej činnosti","98",0.0,0.0,0.0,0.0]
["659","Zúčtovanie opravných položiek z finančnej činnosti","99",0.0,0.0,0.0,0.0]
["655","Zúčtovanie komplexných nákladov budúcich období","100",0.0,0.0,0.0,0.0]
["66","Finančné výnosy (r. 102 až r. 110)","101",49.32,69.0,118.32,276.45]
["661","Tržby z predaja cenných papierov a podielov","102",0.0,0.0,0.0,0.0]
["662","Úroky","103",35.45,0.0,35.45,118.25]
["663","Kurzové zisky","104",0.0,0.0,0.0,0.0]
["664","Výnosy z precenenia cenných papierov","105",0.0,0.0,0.0,0.0]
["665","Výnosy z dlhodobého finančného majetku","106",0.0,0.0,0.0,0.0]
["666","Výnosy z krátkodobého finančného majetku","107",0.0,0.0,0.0,0.0]
["667","Výnosy z derivátových operácií","108",0.0,0.0,0.0,0.0]
["668","Ostatné finančné výnosy","109",13.87,69.0,82.87,158.2]
["","Podiel konsolidujúcej účtovnej jednotky na výsledku hospodárenia pridružených účtovných jednotiek verejnej správy","110",0.0,0.0,0.0,0.0]
["67","Mimoriadne výnosy (r. 112 až r. 115)","111",368.33,0.0,368.33,92.88]
["672","Náhrady škôd","112",0.0,0.0,0.0,0.0]
["674","Zúčtovanie rezerv","113",0.0,0.0,0.0,0.0]
["678","Ostatné mimoriadne výnosy","114",368.33,0.0,368.33,92.88]
["679","Zúčtovanie opravných položiek","115",0.0,0.0,0.0,0.0]
["68","Výnosy z transferov a rozpočtových príjmov v štátnych rozpočtových organizáciách a príspevkových organizáciách (r. 117 až r. 125)","116",0.0,0.0,0.0,0.0]
["681","Výnosy z bežných transferov zo štátneho rozpočtu","117",0.0,0.0,0.0,0.0]
["682","Výnosy z kapitálových transferov zo štátneho rozpočtu","118",0.0,0.0,0.0,0.0]
["683","Výnosy z bežných transferov od ostatných subjektov verejnej správy","119",0.0,0.0,0.0,0.0]
["684","Výnosy z kapitálových transferov od ostatných subjektov verejnej správy","120",0.0,0.0,0.0,0.0]
["685","Výnosy z bežných transferov od Európskej únie","121",0.0,0.0,0.0,0.0]
["686","Výnosy z kapitálových transferov od Európskej únie","122",0.0,0.0,0.0,0.0]
["687","Výnosy z bežných transferov od ostatných subjektov mimo verejnej správy","123",0.0,0.0,0.0,0.0]
["688","Výnosy z kapitálových transferov od ostatných subjektov mimo verejnej správy","124",0.0,0.0,0.0,0.0]
["689","Výnosy z odvodu rozpočtových príjmov","125",0.0,0.0,0.0,0.0]
["69","Výnosy z transferov a rozpočtových príjmov v obciach, vyšších územných celkoch a v rozpočtových organizáciách a príspevkových organizáciách zriadených obcou alebo vyšším územným celkom (r. 127 až r. 135)","126",1.486457914E7,0.0,1.486457914E7,1.442589078E7]
["691","Výnosy z bežných transferov z rozpočtu obce alebo z rozpočtu vyššieho územného celku v rozpočtových organizáciách a príspevkových organizáciách zriadených obcou alebo vyšším územným celkom","127",0.0,0.0,0.0,0.0]
["692","Výnosy z kapitálových transferov z rozpočtu obce alebo z rozpočtu vyššieho územného celku v rozpočtových organizáciách a príspevkových organizáciách zriadených obcou alebo vyšším územným celkom","128",0.0,0.0,0.0,0.0]
["693","Výnosy samosprávy z bežných transferov zo štátneho rozpočtu a od iných subjektov verejnej správy","129",1.397899103E7,0.0,1.397899103E7,1.362129152E7]
["694","Výnosy samosprávy z kapitálových transferov zo štátneho rozpočtu a od iných subjektov verejnej správy","130",838843.37,0.0,838843.37,766963.72]
["695","Výnosy samosprávy z bežných transferov od Európskej únie","131",26354.52,0.0,26354.52,6359.12]
["696","Výnosy samosprávy z kapitálových transferov od Európskej únie","132",0.0,0.0,0.0,0.0]
["697","Výnosy samosprávy z bežných transferov od ostatných subjektov mimo verejnej správy","133",17182.63,0.0,17182.63,28586.42]
["698","Výnosy samosprávy z kapitálových transferov od ostatných subjektov mimo verejnej správy","134",3207.59,0.0,3207.59,2690.0]
["699","Výnosy samosprávy z odvodu rozpočtových príjmov","135",0.0,0.0,0.0,0.0]
["","Účtová trieda 6 súčet (r. 066 + r. 070 + r. 075 + r. 080 + r. 084 + r. 091 + r. 101 + r. 111 + r. 116 + r. 126)","136",4.22210615E7,1462662.96,4.368372446E7,4.223880267E7]
["","Výsledok hospodárenia pred zdanením (r. 136 mínus r. 065) (+/-)","137",-1033351.75,-27089.75,-1060441.5,840930.87]
["591","Splatná daň z príjmov","138",7134.1,3863.95,10998.05,4275.7]
["595","Dodatočne platená daň z príjmov","139",0.0,0.0,0.0,0.0]
["","Výsledok hospodárenia po zdanení r. 137 mínus (r. 138, r. 139) (+/-)","140",-1040485.85,-30953.7,-1071439.55,836655.17]
["","z toho: pripadajúci na podiely iných účtovných jednotiek","141"]