{"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 Modra"]
["IČO:","00304956"]
["DIČ:","2020662193"]
["Mesto:","Modra"]
["Ulica:","Dukelská 941/38"]
["Obdobie:","01/2017 - 12/2017"]
["Typ závierky:","Konsolidovaná riadna"]
["Predložená dňa:","19.06.2018"]
["Zostavená dňa:","14.06.2018"]
["Schválená dňa:",""]
["SA uložená dňa:","02.12.2018"]
["Typ výkazu:","Kons VZaS UJ VS Úč 2-01 - Výkaz ziskov a strát"]
["Tlačová zostava vytvorená:","22.05.2026 12:50:49"]

{"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","2017",null,null,"2016"]
[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",919041.38,468853.0,1387894.38,1309975.04]
["501","Spotreba materiálu","2",658050.67,31356.0,689406.67,605561.76]
["502","Spotreba energie","3",260990.71,437497.0,698487.71,704413.28]
["503","Spotreba ostatných neskladovateľných dodávok","4",0.0,0.0,0.0,0.0]
["504, 507","Predaný tovar, Predaná nehnuteľnosť","5",0.0,0.0,0.0,0.0]
["51","Služby (r. 007 až r. 010)","6",1262883.12,563530.0,1826413.12,1756153.93]
["511","Opravy a udržiavanie","7",205236.84,149942.0,355178.84,339751.39]
["512","Cestovné","8",5500.79,0.0,5500.79,3936.61]
["513","Náklady na reprezentáciu","9",17997.97,769.0,18766.97,19496.28]
["518","Ostatné služby","10",1034147.52,412819.0,1446966.52,1392969.65]
["52","Osobné náklady (r. 012 až r. 016)","11",4296319.88,354743.0,4651062.88,4304181.56]
["521","Mzdové náklady","12",3099332.66,260664.0,3359996.66,3101725.09]
["524","Zákonné sociálne poistenie","13",1064481.3,82043.0,1146524.3,1064828.38]
["525","Ostatné sociálne poistenie","14",14206.27,1550.0,15756.27,15687.1]
["527","Zákonné sociálne náklady","15",118299.65,10486.0,128785.65,121940.99]
["528","Ostatné sociálne náklady","16",0.0,0.0,0.0,0.0]
["53","Dane a poplatky (r. 018 až r. 020)","17",921.32,2212.0,3133.32,4663.27]
["531","Daň z motorových vozidiel","18",0.0,540.0,540.0,644.0]
["532","Daň z nehnuteľnosti","19",0.0,0.0,0.0,0.0]
["538","Ostatné dane a poplatky","20",921.32,1672.0,2593.32,4019.27]
["54","Ostatné náklady na prevádzkovú činnosť (r. 022 až r. 028)","21",29891.52,3695.0,33586.52,106776.54]
["541","Zostatková cena predaného dlhodobého nehmotného majetku a dlhodobého hmotného majetku","22",6849.85,0.0,6849.85,13142.78]
["542","Predaný materiál","23",0.0,0.0,0.0,0.0]
["544","Zmluvné pokuty, penále a úroky z omeškania","24",0.0,69.0,69.0,208.0]
["545","Ostatné pokuty, penále a úroky z omeškania","25",14.15,0.0,14.15,267.95]
["546","Odpis pohľadávky","26",630.77,0.0,630.77,26380.14]
["548","Ostatné náklady na prevádzkovú činnosť","27",22396.75,3626.0,26022.75,66777.67]
["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",1223312.53,46576.0,1269888.53,1189871.75]
["551","Odpisy dlhodobého nehmotného majetku a dlhodobého hmotného majetku","30",1209036.01,46576.0,1255612.01,1183051.52]
["","Rezervy a opravné položky z prevádzkovej činnosti (r. 032 až r. 035)","31",14276.52,0.0,14276.52,6820.23]
["552","Tvorba zákonných rezerv z prevádzkovej činnosti","32",0.0,0.0,0.0,0.0]
["553","Tvorba ostatných rezerv z prevádzkovej činnosti","33",5560.0,0.0,5560.0,4980.0]
["557","Tvorba zákonných opravných položiek z prevádzkovej činnosti","34",532.12,0.0,532.12,0.0]
["558","Tvorba ostatných opravných položiek z prevádzkovej činnosti","35",8184.4,0.0,8184.4,1840.23]
["","Rezervy a opravné položky z finančnej činnosti (r. 037+ r. 038)","36",0.0,0.0,0.0,0.0]
["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",0.0,0.0,0.0,0.0]
["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",83444.13,8235.0,91679.13,82316.56]
["561","Predané cenné papiere a podiely","41",0.0,0.0,0.0,0.0]
["562","Úroky","42",40523.16,3721.0,44244.16,28767.83]
["563","Kurzové straty","43",0.08,0.0,0.08,15.87]
["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",42920.89,4514.0,47434.89,53432.24]
["569","Manká a škody na finančnom majetku","48",0.0,0.0,0.0,100.62]
["","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",143634.0,0.0,143634.0,135600.0]
["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",54010.0,0.0,54010.0,47450.0]
["586","Náklady na transfery z rozpočtu obce alebo z rozpočtu vyššieho územného celku subjektom mimo verejnej správy","61",89624.0,0.0,89624.0,88150.0]
["587","Náklady na ostatné transfery","62",0.0,0.0,0.0,0.0]
["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",7959447.88,1447844.0,9407291.88,8889538.65]

{"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","2017",null,null,"2016"]
[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",837513.68,1397557.26,2235070.94,2167484.69]
["601","Tržby za vlastné výrobky","67",0.0,1069230.26,1069230.26,1196708.59]
["602","Tržby z predaja služieb","68",837513.68,271740.0,1109253.68,912076.1]
["604","Tržby za tovar, Výnosy z nehnuteľnosti na predaj","69",0.0,56587.0,56587.0,58700.0]
["61","Zmena stavu vnútroorganizačných zásob (r. 071 až r. 074)","70",0.0,441.0,441.0,-1341.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,441.0,441.0,-1341.0]
["614","Zmena stavu zvierat","74",0.0,0.0,0.0,0.0]
["62","Aktivácia (r. 076 až r. 079)","75",16913.6,0.0,16913.6,15508.19]
["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",16913.6,0.0,16913.6,15508.19]
["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",4381752.57,0.0,4381752.57,4065613.12]
["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",3738643.25,0.0,3738643.25,3396796.88]
["633","Výnosy z poplatkov","83",643109.32,0.0,643109.32,668816.24]
["64","Ostatné výnosy z prevádzkovej činnosti (r. 085 až r. 090)","84",193735.04,7525.0,201260.04,350199.97]
["641","Tržby z predaja dlhodobého nehmotného majetku a dlhodobého hmotného majetku","85",112313.31,1667.0,113980.31,269228.84]
["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",14926.0,0.0,14926.0,15390.0]
["646","Výnosy z odpísaných pohľadávok","89",0.0,0.0,0.0,0.0]
["648","Ostatné výnosy z prevádzkovej činnosti","90",66495.73,5858.0,72353.73,65581.13]
["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",24634.04,0.0,24634.04,195937.93]
["","Zúčtovanie rezerv a opravných položiek z prevádzkovej činnosti (r. 093 až r. 096)","92",24634.04,0.0,24634.04,195937.93]
["652","Zúčtovanie zákonných rezerv z prevádzkovej činnosti","93",0.0,0.0,0.0,0.0]
["653","Zúčtovanie ostatných rezerv z prevádzkovej činnosti","94",16304.88,0.0,16304.88,160000.0]
["657","Zúčtovanie zákonných opravných položiek z prevádzkovej činnosti","95",0.0,0.0,0.0,0.0]
["658","Zúčtovanie ostatných opravných položiek z prevádzkovej činnosti","96",8329.16,0.0,8329.16,35937.93]
["","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",2105.74,20240.0,22345.74,49556.29]
["661","Tržby z predaja cenných papierov a podielov","102",0.0,0.0,0.0,0.0]
["662","Úroky","103",48.15,12.0,60.15,2661.98]
["663","Kurzové zisky","104",2.22,0.0,2.22,0.09]
["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,24920.99]
["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",2055.15,0.0,2055.15,0.0]
["668","Ostatné finančné výnosy","109",0.22,20228.0,20228.22,21973.23]
["","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",118.0,0.0,118.0,0.01]
["672","Náhrady škôd","112",118.0,0.0,118.0,0.01]
["674","Zúčtovanie rezerv","113",0.0,0.0,0.0,0.0]
["678","Ostatné mimoriadne výnosy","114",0.0,0.0,0.0,0.0]
["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",2168388.97,0.0,2168388.97,2021102.25]
["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",1736564.54,0.0,1736564.54,1529240.21]
["694","Výnosy samosprávy z kapitálových transferov zo štátneho rozpočtu a od iných subjektov verejnej správy","130",367292.85,0.0,367292.85,353758.99]
["695","Výnosy samosprávy z bežných transferov od Európskej únie","131",25000.0,0.0,25000.0,100000.0]
["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",21232.0,0.0,21232.0,25802.42]
["698","Výnosy samosprávy z kapitálových transferov od ostatných subjektov mimo verejnej správy","134",18299.58,0.0,18299.58,12300.63]
["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",7625161.64,1425763.26,9050924.9,8864061.45]
["","Výsledok hospodárenia pred zdanením (r. 136 mínus r. 065) (+/-)","137",-334286.24,-22080.74,-356366.98,-25477.2]
["591","Splatná daň z príjmov","138",8.78,11190.26,11199.04,11309.47]
["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",-334295.02,-33271.0,-367566.02,-36786.67]
["","z toho: pripadajúci na podiely iných účtovných jednotiek","141",0.0,0.0,0.0,0.0]