{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Přehled exportu","Spojené osoby","TaxEdit"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Přehled exportu","index":0,"n_rows":7,"n_cols":40,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,0,1,7],[5,1,5,2],[4,23,4,24],[4,25,4,26],[4,11,4,12],[4,13,4,14],[4,15,4,16],[3,21,3,31],[4,38,4,39],[3,3,3,10],[3,1,3,2],[4,1,4,2],[4,19,4,20],[3,32,3,39],[3,11,3,20],[4,3,4,4],[4,32,4,33],[4,34,4,35],[4,36,4,37],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,21,4,22],[4,17,4,18]]}
[]
["Rekapitulace - přehledy transakcí se spojenými osobami "]
[null,null,null,null,null,null,null,{"$f":"'Spojené osoby'!D3","v":"verze 20250101"}]
[null,null,null,"A Transakce se spojenou osobou",null,null,null,null,null,null,null,"B Transakce se spojenou osobou",null,null,null,null,null,null,null,null,null,"C Transakce se spojenou osobou",null,null,null,null,null,null,null,null,null,null,"D Závazky a pohledávky za spojenou osobou bez úvěrových finančních nástrojů"]
[null,null,null,"1. Dlouhodobý nehmotný majetek",null,"2. Dlouhodobý hmotný majetek",null,"3. Dlouhodobý finanční majetek",null,"4. Zásoby materiálu, výrobků a zboží",null,"1. Služby",null,"2. Licenční poplatek (vč. software)",null,"3. Úroky",null,"4. Nájem",null,"5. Celkový objem ostatních transakcí",null,"1. Úvěrové finanční nástroje",null,"2. Podíly na zisku",null,"3. Ostatní složky vlastního kapitálu",null,"\n\n4. Poskytnutí \na 5. přijetí bezúplatného plnění,\n6. Využití cash-poolingu            \n7. Finanční a bankovní záruky - přijaté a \n8. poskytnuté",null,null,null,null,"1. Dlouhodobé pohledávky",null,"2. Dlouhodobé závazky",null,"3. Krátkodobé pohledávky",null,"4. Krátkodobé závazky"]
["Název spojené osoby","IČ/Kód státu",null,"Výnos\n(prodej)","Pořizovací cena\n(nákup)","Výnos\n(prodej)","Pořizovací cena\n(nákup)","Výnos\n(prodej)","Pořizovací cena\n(nákup)","Výnos\n(prodej)","Pořizovací cena\n(nákup)","Výnos","Náklad","Výnos","Náklad","Výnos","Náklad","Výnos","Náklad","Výnos","Náklad","Přijaté","Vyplacené","Přijaté","Vyplacené","Zvýšení","Snížení",4,5,6,7,8,"Konec\naktuálního\nobdobí","Konec minulého\nobdobé","Konec\naktuálního\nobdobí","Konec minulého\nobdobé","Konec\naktuálního\nobdobí","Konec minulého\nobdobé","Konec\naktuálního\nobdobí","Konec minulého\nobdobé"]
["Prnvi","11112222","CZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE","NE","NE","NE","NE"]

{"sheet":"Spojené osoby","index":1,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[35,5,36,5],[22,2,22,3],[30,2,30,3],[1,0,1,3],[7,0,7,3],[10,0,10,3],[15,2,15,3],[2,1,2,2],[13,0,13,1],[8,5,11,5]]}
[null,null,null,"Samostatná příloha k položce 12 I. oddílu"]
["Přehled transakcí se spojenými osobami"]
[null,2024,null,"verze 20250101"]
["IČ daňového subjektu, který podává DAP:"]
[]
[]
["01 Název spojené osoby:"]
[]
[null,null,null,null,null,"Stát vyberte výběrem ze seznamu vlevo nebo psaním v barevných polích."]
["02 Identifikační číslo spojené osoby:"]
[]
[null,null,null,null,"Stát vyplňte výběrem z některého ze seznamů"]
["03 Stát, ve kterém má spojená osoba sídlo:",null,null,null,"(liší se jen řazením) nebo zadejte jen dvoupísmenný kód."]
["CZ - Česká republika"]
[]
["A Transakce se spojenou osobou",null,"Vyplní se v tis. Kč"]
["Řádek","Název položky","Výnos\n(prodej)","Pořizovací cena\n(nákup)"]
[1,"Dlouhodobý nehmotný majetek"]
[2,"Dlouhodobý hmotný majetek"]
[3,"Dlouhodobý finanční majetek"]
[4,"Zásoby materiálu, výrobků a zboží"]
[]
["B Transakce se spojenou osobou",null,"Vyplní se v tis. Kč"]
["Řádek","Název položky","Výnos","Náklad"]
[1,"Služby"]
[2,"Licenční poplatek (vč. software)"]
[3,"Úroky"]
[4,"Nájem"]
[5,"Celkový objem ostatních transakcí"]
[]
["C Transakce se spojenou osobou",null,"Vyplní se v tis. Kč"]
["Řádek","Název položky","Přijaté","Vyplacené"]
[1,"Úvěrové finanční nástroje"]
[2,"Podíly na zisku"]
[null,null,"Zvýšení","Snížení"]
[3,"Ostatní složky vlastního kapitálu",null,null,null,"Hodnotu nastavte výběrem ze seznamu:"]
[]
[4,"Poskytnutí bezúplatného plnění *)","ANO","NE",null,"NE"]
[5,"Přijetí bezúplatného plnění *)","ANO","NE",null,"NE"]
[6,"Využití cash-poolingu *)","ANO","NE",null,"NE"]
[7,"Finanční a bankovní záruky - přijaté *)","ANO","NE",null,"NE"]
[8,"Finanční a bankovní záruky - poskytnuté *)","ANO","NE",null,"NE"]
["*) Nehodící se škrtněte"]
["D Závazky a pohledávky za spojenou osobou bez úvěrových finančních nástrojů",null,null,"Vyplní se v tis. Kč"]
["Řádek","Název položky","Stav ke konci aktuálního období","Stav ke konci minulého období"]
[1,"Dlouhodobé pohledávky"]
[2,"Dlouhodobé závazky"]
[3,"Krátkodobé pohledávky"]
[4,"Krátkodobé závazky"]

{"sheet":"TaxEdit","index":2,"n_rows":248,"n_cols":3,"rows_kept":248,"cut":false,"hidden":true,"merged":[]}
[]
["Kódy zemí (Číselník Státy světa TXVER_3005)"]
["AF","Afghánistán - AF","AF - Afghánistán"]
["DZ","Alžírsko - DZ","DZ - Alžírsko"]
["AL","Albánie - AL","AL - Albánie"]
["AS","Americká Samoa - AS","AS - Americká Samoa"]
["VI","Americké Panenské ostrovy - VI","VI - Americké Panenské ostrovy"]
["AD","Andorra - AD","AD - Andorra"]
["AO","Angola - AO","AO - Angola"]
["AI","Anguilla - AI","AI - Anguilla"]
["AQ","Antarktida - AQ","AQ - Antarktida"]
["AG","Antigua a Barbuda - AG","AG - Antigua a Barbuda"]
["AR","Argentina - AR","AR - Argentina"]
["AM","Arménie - AM","AM - Arménie"]
["AW","Aruba - AW","AW - Aruba"]
["AU","Austrálie - AU","AU - Austrálie"]
["AZ","Azerdbájdžán - AZ","AZ - Azerdbájdžán"]
["BS","Bahamy - BS","BS - Bahamy"]
["BH","Bahrajn - BH","BH - Bahrajn"]
["BD","Bangladéš - BD","BD - Bangladéš"]
["BB","Barbados - BB","BB - Barbados"]
["BE","Belgie - BE","BE - Belgie"]
["BZ","Belize - BZ","BZ - Belize"]
["BJ","Benin - BJ","BJ - Benin"]
["BM","Bermudy - BM","BM - Bermudy"]
["BT","Bhútán - BT","BT - Bhútán"]
["BO","Bolívie - BO","BO - Bolívie"]
["BA","Bosna a Hercegovina - BA","BA - Bosna a Hercegovina"]
["BW","Botswana - BW","BW - Botswana"]
["BF","Bourkina Fasso - BF","BF - Bourkina Fasso"]
["BV","Bouvetuv ostrov - BV","BV - Bouvetuv ostrov"]
["BR","Brazílie - BR","BR - Brazílie"]
["GB","Británie - GB","GB - Británie"]
["IO","Britské indickooceánské teritorium - IO","IO - Britské indickooceánské teritorium"]
["VG","Britské Panenské ostrovy - VG","VG - Britské Panenské ostrovy"]
["BN","Brunej Darussalam - BN","BN - Brunej Darussalam"]
["BY","Bělorusko - BY","BY - Bělorusko"]
["BG","Bulharsko - BG","BG - Bulharsko"]
["BI","Burundi - BI","BI - Burundi"]
["CK","Cookovy ostrovy - CK","CK - Cookovy ostrovy"]
["TD","Čad - TD","TD - Čad"]
["CN","Čína - CN","CN - Čína"]
["ME","Černá Hora - ME","ME - Černá Hora"]
["CZ","Česká republika - CZ","CZ - Česká republika"]
["DJ","Džibutsko - DJ","DJ - Džibutsko"]
["DK","Dánsko - DK","DK - Dánsko"]
["CD","Demokratická republika Kongo - CD","CD - Demokratická republika Kongo"]
["DO","Dominikánská republika - DO","DO - Dominikánská republika"]
["DM","Dominika - DM","DM - Dominika"]
["EG","Egypt - EG","EG - Egypt"]
["EC","Ekvádor - EC","EC - Ekvádor"]
["ER","Eritrea - ER","ER - Eritrea"]
["EE","Estonsko - EE","EE - Estonsko"]
["ET","Etiopie - ET","ET - Etiopie"]
["EU","Evropská unie - EU","EU - Evropská unie"]
["FO","Faerské ostrovy - FO","FO - Faerské ostrovy"]
["FK","Falklandy-Malvíny - FK","FK - Falklandy-Malvíny"]
["FJ","Fidži - FJ","FJ - Fidži"]
["PH","Filipíny - PH","PH - Filipíny"]
["FI","Finsko - FI","FI - Finsko"]
["FR","Francie - FR","FR - Francie"]
["PF","Francouzská Polynésie - PF","PF - Francouzská Polynésie"]
["GF","Francouzská Guayana - GF","GF - Francouzská Guayana"]
["TF","Francouzská jižní území - TF","TF - Francouzská jižní území"]
["GA","Gabon - GA","GA - Gabon"]
["GM","Gambie - GM","GM - Gambie"]
["GH","Ghana - GH","GH - Ghana"]
["GI","Gibraltar - GI","GI - Gibraltar"]
["GL","Grónsko - GL","GL - Grónsko"]
["GD","Grenada - GD","GD - Grenada"]
["GE","Gruzie - GE","GE - Gruzie"]
["GP","Guadeloupe - GP","GP - Guadeloupe"]
["GU","Guam - GU","GU - Guam"]
["GT","Guatemala - GT","GT - Guatemala"]
["GY","Guayana - GY","GY - Guayana"]
["GG","Guernsey, C.I. - GG","GG - Guernsey, C.I."]
["GN","Guinea - GN","GN - Guinea"]
["GW","Guinea-Bissau - GW","GW - Guinea-Bissau"]
["HT","Haiti - HT","HT - Haiti"]
["HM","Hearduv ostrov a McDonaldovy ostrovy - HM","HM - Hearduv ostrov a McDonaldovy ostrovy"]
["HN","Honduras - HN","HN - Honduras"]
["HK","Hongkong - HK","HK - Hongkong"]
["CL","Chile - CL","CL - Chile"]
["HR","Chorvatsko - HR","HR - Chorvatsko"]
["IN","Indie - IN","IN - Indie"]
["ID","Indonésie - ID","ID - Indonésie"]
["IR","Irán - IR","IR - Irán"]
["IQ","Irák - IQ","IQ - Irák"]
["IE","Irsko - IE","IE - Irsko"]
["IS","Island - IS","IS - Island"]
["IT","Itálie - IT","IT - Itálie"]
["IL","Izrael - IL","IL - Izrael"]
["JM","Jamajka - JM","JM - Jamajka"]
["JP","Japonsko - JP","JP - Japonsko"]
["YE","Jemen - YE","YE - Jemen"]
["JE","Jersey, C.I. - JE","JE - Jersey, C.I."]
["ZA","Jižní Afrika - ZA","ZA - Jižní Afrika"]
["GS","Jižní Georgia a Jižní Sandwichovy ostrovy - GS","GS - Jižní Georgia a Jižní Sandwichovy ostrovy"]
["JO","Jordánsko - JO","JO - Jordánsko"]
["KY","Kajmanské ostrovy - KY","KY - Kajmanské ostrovy"]
["KH","Kambodža - KH","KH - Kambodža"]
["CM","Kamerun - CM","CM - Kamerun"]
["CA","Kanada - CA","CA - Kanada"]
["CV","Kapverdy - CV","CV - Kapverdy"]
["QA","Katar - QA","QA - Katar"]
["KZ","Kazachstán - KZ","KZ - Kazachstán"]
["KE","Kena - KE","KE - Kena"]
["KG","Kirgizstán - KG","KG - Kirgizstán"]
["KI","Kiribati - KI","KI - Kiribati"]
["CC","Kokosové ostrovy - CC","CC - Kokosové ostrovy"]
["CO","Kolumbie - CO","CO - Kolumbie"]
["KM","Komory - KM","KM - Komory"]
["CG","Kongo - CG","CG - Kongo"]
["KP","Korejská lidově demokratická republika - KP","KP - Korejská lidově demokratická republika"]
["KR","Korejská republika - KR","KR - Korejská republika"]
["XK","Kosovo - XK","XK - Kosovo"]
["CR","Kostarika - CR","CR - Kostarika"]
["CU","Kuba - CU","CU - Kuba"]
["KW","Kuvajt - KW","KW - Kuvajt"]
["CY","Kypr - CY","CY - Kypr"]
["LA","Laos - LA","LA - Laos"]
["LS","Lesotho - LS","LS - Lesotho"]
["LB","Libanon - LB","LB - Libanon"]
["LY","Libye - LY","LY - Libye"]
["LR","Libérie - LR","LR - Libérie"]
["LI","Lichtenštejnsko - LI","LI - Lichtenštejnsko"]
["LT","Litva - LT","LT - Litva"]
["LV","Lotyšsko - LV","LV - Lotyšsko"]
["LU","Lucembursko - LU","LU - Lucembursko"]
["MO","Macao - MO","MO - Macao"]
["MG","Madagaskar - MG","MG - Madagaskar"]
["HU","Maďarsko - HU","HU - Maďarsko"]
["MK","Makedonie - MK","MK - Makedonie"]
["MY","Malajsie - MY","MY - Malajsie"]
["MW","Malawi - MW","MW - Malawi"]
["MV","Maledivy - MV","MV - Maledivy"]
["ML","Mali - ML","ML - Mali"]
["MT","Malta - MT","MT - Malta"]
["MA","Maroko - MA","MA - Maroko"]
["MH","Marshallovy ostrovy - MH","MH - Marshallovy ostrovy"]
["MQ","Martinik - MQ","MQ - Martinik"]
["MR","Mauretánie - MR","MR - Mauretánie"]
["MU","Mauritius - MU","MU - Mauritius"]
["YT","Mayotte - YT","YT - Mayotte"]
["UM","Menší odlehlé ostrovy USA - UM","UM - Menší odlehlé ostrovy USA"]
["MX","Mexiko - MX","MX - Mexiko"]
["FM","Mikronésie - FM","FM - Mikronésie"]
["MD","Moldávie - MD","MD - Moldávie"]
["MC","Monako - MC","MC - Monako"]
["MN","Mongolsko - MN","MN - Mongolsko"]
["MS","Montserrat - MS","MS - Montserrat"]
["MZ","Mosambik - MZ","MZ - Mosambik"]
["MM","Myanmar - MM","MM - Myanmar"]
["NA","Namibie - NA","NA - Namibie"]
["NR","Nauru - NR","NR - Nauru"]
["NP","Nepál - NP","NP - Nepál"]
["NE","Niger - NE","NE - Niger"]
["NG","Nigérie - NG","NG - Nigérie"]
["NI","Nikaragua - NI","NI - Nikaragua"]
["NU","Niue - NU","NU - Niue"]
["NL","Nizozemí - NL","NL - Nizozemí"]
["AN","Nizozemské Antily - AN","AN - Nizozemské Antily"]
["NF","Norfolk - NF","NF - Norfolk"]
["NO","Norsko - NO","NO - Norsko"]
["NC","Nová Kaledonie - NC","NC - Nová Kaledonie"]
["NZ","Nový Zéland - NZ","NZ - Nový Zéland"]
["OM","Omán - OM","OM - Omán"]
["IM","Ostrov Man - IM","IM - Ostrov Man"]
["MI","Ostrovy Midway - MI","MI - Ostrovy Midway"]
["PK","Pákistán - PK","PK - Pákistán"]
["PW","Palau - PW","PW - Palau"]
["XA","Palestina - XA","XA - Palestina"]
["PA","Panama - PA","PA - Panama"]
["PG","Papua - Nová Guinea - PG","PG - Papua - Nová Guinea"]
["PY","Paraguay - PY","PY - Paraguay"]
["PE","Peru - PE","PE - Peru"]
["PN","Pitcairn - PN","PN - Pitcairn"]
["CI","Pobreží slonoviny - CI","CI - Pobreží slonoviny"]
["PL","Polsko - PL","PL - Polsko"]
["PR","Portoriko - PR","PR - Portoriko"]
["PT","Portugalsko - PT","PT - Portugalsko"]
["AT","Rakousko - AT","AT - Rakousko"]
["GQ","Rovníková Guinea - GQ","GQ - Rovníková Guinea"]
["RO","Rumunsko - RO","RO - Rumunsko"]
["RU","Rusko - RU","RU - Rusko"]
["RW","Rwanda - RW","RW - Rwanda"]
["RE","Réunion - RE","RE - Réunion"]
["GR","Řecko - GR","GR - Řecko"]
["PM","Saint Pierre a Miquelon - PM","PM - Saint Pierre a Miquelon"]
["SV","Salvador - SV","SV - Salvador"]
["SA","Saúdská Arábie - SA","SA - Saúdská Arábie"]
["SM","San Marino - SM","SM - San Marino"]
["SN","Senegal - SN","SN - Senegal"]
["MP","Severní Mariany - MP","MP - Severní Mariany"]
["SC","Seychelly - SC","SC - Seychelly"]
["SY","Sýrie - SY","SY - Sýrie"]
["SL","Sierra Leone - SL","SL - Sierra Leone"]
["SG","Singapur - SG","SG - Singapur"]
["SK","Slovensko - SK","SK - Slovensko"]
["SI","Slovinsko - SI","SI - Slovinsko"]
["SD","Sudán - SD","SD - Sudán"]
["SO","Somálsko - SO","SO - Somálsko"]
["AE","Spojené arabské emiráty - AE","AE - Spojené arabské emiráty"]
["US","Spojené státy americké - US","US - Spojené státy americké"]
["DE","Spolková republika Německo - DE","DE - Spolková republika Německo"]
["RS","Srbsko - RS","RS - Srbsko"]
["LK","Srí Lanka - LK","LK - Srí Lanka"]
["SR","Surinam - SR","SR - Surinam"]
["SH","Svatá Helena - SH","SH - Svatá Helena"]
["LC","Svatá Lucie - LC","LC - Svatá Lucie"]
["KN","Svatý Kryštof - KN","KN - Svatý Kryštof"]
["ST","Svatý Tomáš - ST","ST - Svatý Tomáš"]
["VC","Svatý Vincenc a Grenadiny - VC","VC - Svatý Vincenc a Grenadiny"]
["SZ","Svazijsko - SZ","SZ - Svazijsko"]
["CF","Středoafrická republika - CF","CF - Středoafrická republika"]
["SB","Šalamounovy ostrovy - SB","SB - Šalamounovy ostrovy"]
["ES","Španělsko - ES","ES - Španělsko"]
["SJ","Špicberky a Jan Mayen - SJ","SJ - Špicberky a Jan Mayen"]
["CH","Švýcarsko - CH","CH - Švýcarsko"]
["SE","Švédsko - SE","SE - Švédsko"]
["TJ","Tadžikistán - TJ","TJ - Tadžikistán"]
["TZ","Tanzánie - TZ","TZ - Tanzánie"]
["TH","Thajsko - TH","TH - Thajsko"]
["TW","Tchajwan - TW","TW - Tchajwan"]
["TG","Togo - TG","TG - Togo"]
["TK","Tokelau - TK","TK - Tokelau"]
["TO","Tonga - TO","TO - Tonga"]
["TT","Trinidad a Tobago - TT","TT - Trinidad a Tobago"]
["TN","Tunisko - TN","TN - Tunisko"]
["TR","Turecko - TR","TR - Turecko"]
["TM","Turkmenistán - TM","TM - Turkmenistán"]
["TC","Turks a Caicos - TC","TC - Turks a Caicos"]
["TV","Tuvalu - TV","TV - Tuvalu"]
["UG","Uganda - UG","UG - Uganda"]
["UA","Ukrajina - UA","UA - Ukrajina"]
["UY","Uruguay - UY","UY - Uruguay"]
["UZ","Uzbekistán - UZ","UZ - Uzbekistán"]
["CX","Vánoční ostrov - CX","CX - Vánoční ostrov"]
["VU","Vanuatu - VU","VU - Vanuatu"]
["VA","Vatikán - VA","VA - Vatikán"]
["VE","Venezuela - VE","VE - Venezuela"]
["TP","Východní Timor - TP","TP - Východní Timor"]
["VN","Vietnam - VN","VN - Vietnam"]
["WF","Wallisovy ostrovy - WF","WF - Wallisovy ostrovy"]
["EH","Západní Sahara - EH","EH - Západní Sahara"]
["WS","Samoa - WS","WS - Samoa"]
["ZM","Zambie - ZM","ZM - Zambie"]
["ZW","Zimbabwe - ZW","ZW - Zimbabwe"]