{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["RbN","Listy","RBNN1","RBNN2","RBNB","Makro1"],"not_rendered":{"external_links":1,"defined_names":5,"comments":2},"unopened":[{"sheet":"Makro1","index":5,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RbN","index":0,"n_rows":86,"n_cols":34,"rows_kept":86,"merged":[[2,0,2,1],[3,2,3,12],[3,13,7,16],[4,2,4,12],[5,0,5,1],[5,2,5,12],[7,0,7,1],[8,2,8,4],[9,2,9,4],[10,2,10,4],[16,0,16,1],[38,0,38,1],[39,0,39,1],[43,6,43,11],[45,0,45,4],[49,0,49,4],[50,0,50,4],[51,0,51,4],[52,0,52,4],[53,0,53,4]],"flags":["formulas_cached_only"]}
["",{"$nulls":5},"Wybierz z listy rodzaj jednostki:",{"$nulls":10},"ver. 2021-03-31a"]
["Nazwa jednostki sprawozdawczej ",{"$nulls":4},"Rb-N   KWARTALNE SPRAWOZDANIE O STANIE NALEŻNOŚCI ORAZ WYBRANYCH AKTYWÓW FINANSOWYCH"]
["Kwileckie Centrum Kultury i Edukacji im. Floriana Mazurkiewicza oraz Biblioteka Publiczna",{"$nulls":12},"Adresat"]
[null,null,"samorządowej instytucji kultury",{"$nulls":10},"Wójt Gminy Kwilcz"]
["Adres jednostki sprawozdawczej",null,"sprawozdanie jednostkowe",{"$nulls":17},1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["ul. Kardynała Stefana Wyszyńskiego 19  64-420 Kwilcz",null,"",{"$nulls":17},2,4,8,5,0,9,7,3,6,1,2,4,8]
["Numer identyfikacyjny REGON",null,"liczba identyfik.jedn.",{"$nulls":4},"",null,null,"",{"$nulls":9},8,9,2,3,4,5,6,7]
["382189406",{"$nulls":4},"wg stanu na koniec",null,4,"kwartału","  roku",2024,{"$nulls":7},true,null,3,8,2,1,8,9,4,0,6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Nazwa województwa",null,"wielkopolskie",{"$nulls":4},"SYMBOLE"]
["Nazwa powiatu / związku",null,"międzychodzki",null,null,"WOJ.","POWIAT","GMINA","TYP GM.","ZWIĄZEK JST","TYP ZW.","GRUPA","CZĘŚĆ BUDŻ."]
["Nazwa gminy / związku",null,"kwilcz",null,null,30,14,2,2,null,null,42]
[]
[" A. Należności oraz wybrane aktywa finansowe"]
[]
[{"$nulls":7},"d ł u ż n i c y   k r a j o w i",{"$nulls":7},"             d ł u ż n i c y   z a g r a n i c z n i "]
[null,null,"kwota"]
["Wyszczególnienie",null,"należności",null,"sektor",{"$nulls":9},"instytucje"]
[null,null,"ogółem","ogółem","finansów","grupa I","grupa II","grupa III","grupa IV","bank","banki","pozostałe","przedsiębiorstwa ","gospodarstwa","niekomercyjne",null,"podmioty","pozostałe"]
[null,null,"(kol. 3+15)","(kol 4+9+10+11+","publicznych",{"$nulls":4},"centralny",null,"krajowe","niefinansowe","domowe","działające ","ogółem","należące ","podmioty"]
[{"$nulls":3},"12+13+14)","ogółem",{"$nulls":6},"instytucje",null,null,"na rzecz",null,"do strefy","zagraniczne"]
[{"$nulls":4},"(kol 5+6+7+8)",{"$nulls":6},"finansowe",null,null,"gospodarstw","(kol. 16+17)","euro"]
[{"$nulls":14},"domowych"]
[1,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["N1. papiery wartościowe (N1.1+N1.2)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["      N1.1. krótkoterminowe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["      N1.2. długoterminowe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["N2. kredyty i pożyczki (N2.1+N2.2)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["      N2.1. krótkoterminowe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["      N2.2. długoterminowe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["N3. gotówka i depozyty (N3.1+N3.2+N3.3)",null,{"v":22991.36,"d":"22,991.36"},{"v":22991.36,"d":"22,991.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":22991.36,"d":"22,991.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["      N3.1. gotówka",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"}]
["      N3.2. depozyty na żądanie",null,{"v":22991.36,"d":"22,991.36"},{"v":22991.36,"d":"22,991.36"},{"v":0,"d":"0.00"},{"$nulls":5},{"v":22991.36,"d":"22,991.36"},{"$nulls":4},{"v":0,"d":"0.00"}]
["      N3.3. depozyty terminowe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["N4.należności wymagalne (N4.1+N4.2)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["      N4.1 z tytułu dostaw towarów i usług",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["      N4.2 pozostałe",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["N5. pozostałe należności (N5.1+N5.2+N5.3)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["      N5.1. z tytułu dostaw towarów i usług",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["      N5.2. z tytułu podatków i składek \n      na ubezpieczenie społeczne",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
["      N5.3. z tytułów innych niż wymienione\n      wyżej",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":10},{"v":0,"d":"0.00"}]
[]
[" B. Należności z tytułu udzielonych poręczeń  i gwarancji"]
[]
[{"$nulls":6},"d ł u ż n i c y"]
[{"$nulls":5},"Kwota ","podmioty"]
["Wyszczególnienie",{"$nulls":4},"należności","sektora","grupa  I","grupa II","grupa III","grupa IV","pozostałe "]
[{"$nulls":5},"ogółem","finansów",{"$nulls":4},"podmioty"]
[{"$nulls":5},"(kol. 3+8)","publicznych"]
[{"$nulls":6},"(kol.4+5+6+7)"]
[1,{"$nulls":4},2,3,4,5,6,7,8]
["B1. należność główna z tytułu udzielonych poręczeń i gwarancji",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["B2. odsetki ustawowe od należności głównej z tytułu udzielonych poręczeń i gwarancji ",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["B3. wartość spłat dokonanych w okresie sprawozdawczym za dłużników z tytułu udzielonych poręczeń i gwarancji (wydatki)",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["B4. kwota odzyskanych wierzytelności w okresie sprawozdawczym od dłużników z tytułu udzielonych poręczeń i gwarancji (dochody)",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
[]
[]
[]
[]
["Sylwia Gaszek",{"$nulls":4},"2025-01-28",null,null,"Magdalena Jabłońska"]
["…………………",null,null,"………………",null,"………………",null,null,"…………………"]
["Główny Księgowy* / Skarbnik",null,null,"telefon",null,"rok m-c dzień",null,null,"Kierownik jednostki (jednostki obsługującej)/ Przewodniczący Zarządu"]
["* Nie dotyczy sprawozdań zbiorczych sporządzanych przez RIO. W przypadku braku głównego księgowego podpisuje tylko kierownik jednostki."]
[]
[{"$nulls":5},"Weryfikacja wybranych podstawowych kwot ujętych w Rb-N oraz weryfikacja formalna:"]
[{"$nulls":5},"(jeśli sprawozdanie jest poprawne - poniższe wiersze arkusza pozostaną puste)"]
[{"$nulls":4},"Reguła:"]
[{"$nulls":4},"N3.1. (gotówka)",""]
[{"$nulls":4},"N3.2 (depozyty na żądanie)",""]
[{"$nulls":4},"N3.3 (depozyty terminowe)",""]
[{"$nulls":4},"Wybór okresu sprawozdawczego",""]
[{"$nulls":4},"Wybór rodzaju jednostki",""]
[{"$nulls":4},"REGON jednostki sprawozdawczej ",""]
[{"$nulls":5},"Uwaga: Powyższa tabela nie wyczerpuje wszystkich reguł kontroli formalno-rachunkowej. "]
["Podstawa prawna:"]
["Rozporządzenie Ministra Finansów, Funduszy i Polityki Regionalnej w sprawie sprawozdań jednostek sektora finansów publicznych w zakresie operacji finansowych z dnia 17 grudnia 2020 r. (Dz.U. z 2020 r. poz. 2396)"]
[]
["Wyciąg przepisów:"]
["§ 10 rozp. "]
["[…]"]
["6. Jednostki będące odbiorcami sprawozdań sprawdzają prawidłowość otrzymywanych sprawozdań pod względem formalno-rachunkowym. "]
["Jednostki te mogą również kontrolować merytoryczną prawidłowość złożonych sprawozdań i żądać w tym zakresie odpowiednich dokumentów."]
["7. Kierownicy jednostek sporządzających sprawozdania, w których stwierdzono nieprawidłowości w toku sprawdzania, o którym mowa w ust. 6, dokonują ich korekty przed włączeniem zawartych w nich danych do sprawozdań łącznych lub zbiorczych."]
["[…]"]
["10. Szczegółowe informacje dotyczące sporządzania sprawozdań określa instrukcja sporządzania sprawozdań stanowiąca załącznik nr 8 do rozporządzenia. "]

{"sheet":"Listy","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true,"flags":["formulas_cached_only"]}
[null,1]
[]
["[42] samorządowa instytucja kultury","samorządowej instytucji kultury",42,42]
["[62] samodzielny publiczny zakład opieki zdrowotnej nadzorowany przez jednostkę samorządu terytorialnego","samodzielnego publicznego zakładu opieki zdrowotnej nadzorowanego przez jednostkę samorządu terytorialnego",62,62]
["[82] samorządowa osoba prawna utworzona na podstawie odrębnych ustaw w celu wykonywania zadań publicznych","samorządowej osoby prawnej",82,82]
["WYBIERZ RODZAJ JEDNOSTKI SPRAWOZDAWCZEJ","WYBIERZ RODZAJ JEDNOSTKI SPRAWOZDAWCZEJ","Wybierz z listy",99]

{"sheet":"RBNN1","index":2,"n_rows":23,"n_cols":171,"rows_kept":23,"hidden":true,"flags":["formulas_cached_only"]}
["REGON","WK","PK","GK","GT","PT","ROK","KWARTAL","CZ_BU","DAT_SKW","UWAGI","N1002","N1003","N1004","N1005","N1006","N1007","N1008","N1009","N1010","N1011","N1012","N1013","N1014","N1015","N1016","N1017","N1102","N1103","N1104","N1105","N1106","N1107","N1108","N1109","N1110","N1111","N1112","N1113","N1114","N1115","N1116","N1117","N1202","N1203","N1204","N1205","N1206","N1207","N1208","N1209","N1210","N1211","N1212","N1213","N1214","N1215","N1216","N1217","N2002","N2003","N2004","N2005","N2006","N2007","N2008","N2009","N2010","N2011","N2012","N2013","N2014","N2015","N2016","N2017","N2102","N2103","N2104","N2105","N2106","N2107","N2108","N2109","N2110","N2111","N2112","N2113","N2114","N2115","N2116","N2117","N2202","N2203","N2204","N2205","N2206","N2207","N2208","N2209","N2210","N2211","N2212","N2213","N2214","N2215","N2216","N2217","N3002","N3003","N3004","N3005","N3006","N3007","N3008","N3009","N3010","N3011","N3012","N3013","N3014","N3015","N3016","N3017","N3102","N3103","N3104","N3105","N3106","N3107","N3108","N3109","N3110","N3111","N3112","N3113","N3114","N3115","N3116","N3117","N3202","N3203","N3204","N3205","N3206","N3207","N3208","N3209","N3210","N3211","N3212","N3213","N3214","N3215","N3216","N3217","N3302","N3303","N3304","N3305","N3306","N3307","N3308","N3309","N3310","N3311","N3312","N3313","N3314","N3315","N3316","N3317"]
["382189406",{"$nulls":4},42,2024,4,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"v":22991.36,"d":"22991"},{"v":22991.36,"d":"22991"},0,0,0,0,0,0,{"v":22991.36,"d":"22991"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"v":22991.36,"d":"22991"},{"v":22991.36,"d":"22991"},0,0,0,0,0,0,{"v":22991.36,"d":"22991"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":16}
["Uwaga dla jednostek nadrzędnych!"]
["Aby przenieść dane do arkusza agregującego dane z jednostek podległych"]
["należy zaznaczyć obszar z danymi do skopiowania a następnie wkleić go we właściwe miejsce"]
["wybierając z menu Edycja opcję Wklej specjalnie / Wartości."]
["Dzieki temu unikniemy przeniesienia formuł, które znajdują się w komórkach obszaru danych do przeniesienia."]

{"sheet":"RBNN2","index":3,"n_rows":23,"n_cols":123,"rows_kept":23,"hidden":true,"flags":["formulas_cached_only"]}
["REGON","WK","PK","GK","GT","PT","ROK","KWARTAL","CZ_BU","DAT_SKW","UWAGI","N4002","N4003","N4004","N4005","N4006","N4007","N4008","N4009","N4010","N4011","N4012","N4013","N4014","N4015","N4016","N4017","N4102","N4103","N4104","N4105","N4106","N4107","N4108","N4109","N4110","N4111","N4112","N4113","N4114","N4115","N4116","N4117","N4202","N4203","N4204","N4205","N4206","N4207","N4208","N4209","N4210","N4211","N4212","N4213","N4214","N4215","N4216","N4217","N5002","N5003","N5004","N5005","N5006","N5007","N5008","N5009","N5010","N5011","N5012","N5013","N5014","N5015","N5016","N5017","N5102","N5103","N5104","N5105","N5106","N5107","N5108","N5109","N5110","N5111","N5112","N5113","N5114","N5115","N5116","N5117","N5202","N5203","N5204","N5205","N5206","N5207","N5208","N5209","N5210","N5211","N5212","N5213","N5214","N5215","N5216","N5217","N5302","N5303","N5304","N5305","N5306","N5307","N5308","N5309","N5310","N5311","N5312","N5313","N5314","N5315","N5316","N5317"]
["382189406",{"$nulls":4},42,2024,4,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":16}
["Uwaga dla jednostek nadrzędnych!"]
["Aby przenieść dane do arkusza agregującego dane z jednostek podległych"]
["należy zaznaczyć obszar z danymi do skopiowania a następnie wkleić go we właściwe miejsce"]
["wybierając z menu Edycja opcję Wklej specjalnie / Wartości."]
["Dzieki temu unikniemy przeniesienia formuł, które znajdują się w komórkach obszaru danych do przeniesienia."]

{"sheet":"RBNB","index":4,"n_rows":23,"n_cols":39,"rows_kept":23,"hidden":true,"flags":["formulas_cached_only"]}
["REGON","WK","PK","GK","GT","PT","ROK","KWARTAL","CZ_BU","DAT_SKW","UWAGI","B1002","B1003","B1004","B1005","B1006","B1007","B1008","B2002","B2003","B2004","B2005","B2006","B2007","B2008","B3002","B3003","B3004","B3005","B3006","B3007","B3008","B4002","B4003","B4004","B4005","B4006","B4007","B4008"]
["382189406",{"$nulls":4},42,2024,4,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":16}
["Uwaga dla jednostek nadrzędnych!"]
["Aby przenieść dane do arkusza agregującego dane z jednostek podległych"]
["należy zaznaczyć obszar z danymi do skopiowania a następnie wkleić go we właściwe miejsce"]
["wybierając z menu Edycja opcję Wklej specjalnie / Wartości."]
["Dzieki temu unikniemy przeniesienia formuł, które znajdują się w komórkach obszaru danych do przeniesienia."]