{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["JPK-Nagłówek","JPK-Wyciąg","Parametry","techniczne"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":53,"comments":4,"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":"JPK-Nagłówek","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,3,16,7],[3,8,3,15],[10,8,10,11],[13,8,13,9],[14,8,14,9],[7,8,7,11],[11,8,11,11],[12,8,12,11]]}
[null,null,null,null,null,"JPK_WB"]
[null,null,null,{"$f":"DataWytworzenia()","v":"2025-03-31T11:25:56"}]
[]
[null,null,"Cel złożenia:",1,null,null,null,"Pełna nazwa podmiotu:","Pełna nazwa przedsiębiorstwa"]
[null,null,null,null,null,null,null,"NIP:","1111111111"]
[null,null,"Data od:","2016-06-04",null,null,null,"REGON:","000000000"]
[null,null,"Data do:","2016-06-30"]
[null,null,null,null,null,null,null,"Ulica:","Specjalna"]
[null,null,"Domyślny kod waluty:","PLN",null,null,null,"Nr domu:","1","Nr lokalu:",""]
[null,null,null,null,null,null,null,"Kod pocztowy:","00-201"]
[null,null,"Kod urzędu skarbowego:","2411",null,null,null,"Miejscowość:","Warszawa"]
[null,null,null,null,null,null,null,"Poczta:","Warszawa"]
[null,null,null,null,null,null,null,"Gmina:","Warszawa"]
[null,null,null,null,null,null,null,"Powiat:","Warszawa"]
[null,null,null,null,null,null,null,"Województwo:","Mazowieckie"]
[]
[null,null,"Numer rachunku (IBAN):","PL74105015201000009105236526"]
[]
[null,"Pola obowiązkowe:"]
[null,"Pola opcjonalne:"]

{"sheet":"JPK-Wyciąg","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4]]}
[null,null,"Wyciąg z transakcji od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2016-06-04"},null,{"$f":"IF(F9=\"\",\"\",SUBTOTAL(5,F9:F1048576))","v":"2016-06-16"},null,"Liczba wierszy:",{"$f":"D6","v":3}]
[null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2016-06-30"},null,{"$f":"IF(F9=\"\",\"\",SUBTOTAL(4,F9:F1048576))","v":"2016-07-04"},null,"Suma obciążeń:",{"$f":"-SumujWidoczne(I9:I1048576,FALSE)","v":87.69}]
[null,null,"Saldo początkowe: ",123.74,null,null,null,"Suma uznań:",{"$f":"SumujWidoczne(I9:I1048576,TRUE)","v":145.57999999999998}]
[null,null,"Saldo końcowe:",{"$f":"SaldoPoczatkowe+I6","v":181.63}]
[]
[null,null,null,{"$f":"SUBTOTAL(3,D9:D1048576)","v":3},null,null,null,null,{"$f":"SUBTOTAL(9,I9:I1048576)","v":57.89}]
[]
[null,null,null,"Lp. ","Błąd","Data operacji","Nazwa podmiotu","Opis transakcji","Kwota","Saldo operacji"]
[null,null,null,1,null,"2016-06-16","AMAZON\n410 Terry Avenue North\nWA, 98109 Seattle","Payment.: 38035301",97.39,221.13]
[null,null,null,2,null,"2016-07-01","Polkomtel Sp. z o.o.\nKonstruktorska 4,\n02-673 Warszawa","F-ra: 1606240521172\nOpłata za usługi\ntelekomunikacyjne",-87.69,133.44]
[null,null,null,3,null,"2016-07-04","Apple\n8 rue Heinrich Heine\nL-1720 Luxembourg","CCI : 0076896366,ITUNES\nKK,APPLE PT\nY LTD",48.19,181.63]

{"sheet":"Parametry","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rozszerzenie pliku importu:"]
[]
[]
[null,"Arkusz","Komponent obsługujący import"]
[null,"JPK-Wyciąg","brak"]
[]
[]
[null,"Modyfikuj pola sumaryczne",1]

{"sheet":"techniczne","index":3,"n_rows":92,"n_cols":20,"rows_kept":92,"cut":false,"hidden":true,"merged":[[85,14,85,15],[85,16,85,17],[86,14,86,15],[86,16,86,17],[87,14,87,15],[87,16,87,17],[91,14,91,15],[91,16,91,17],[88,14,88,15],[88,16,88,17],[89,14,89,15],[89,16,89,17],[90,14,90,15],[90,16,90,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elementy list","Numery automat:","Nr obowiązkowej kolumny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WyciagWiersz","NumerWiersza",3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XED","#4574"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSD:","http://www.mf.gov.pl/documents/764034/5134536/Schemat_JPK_WB%281%29_v1-0.xsd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namespace:","http://jpk.mf.gov.pl/wzor/2016/03/09/03092/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroToEmpty",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroFollowsFields:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dodatkowe testy merytoryczne podczas Importu i dopisywania (Append):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprawdź podczas importu","Sprawdź podczas dołączania","Wykonać przed walidacją XSD?","Węzeł z porównywaną wartością (wyrażenie Xpath) (uruchamiane dla DocumentNode)","Oczekiwana wartość","Komunikat o ewentualnym błędzie (Wpisz {Val} tam, gdzie ma być podstawiona wartość z importowanego dokumentu)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},"jpk:Naglowek/jpk:KodFormularza","JPK_WB",{"$f":"\"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być '\" & S15 & \"'\"","v":"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_WB'"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,false,"jpk:NumerRachunku",{"$f":"NumerRachunku","v":"PL74105015201000009105236526"},{"$f":"\"Plik dotyczy rachunku o innym numerze ({Val}) niż dotychczas wczytane dane (dla: \" &S16 & \")\"","v":"Plik dotyczy rachunku o innym numerze ({Val}) niż dotychczas wczytane dane (dla: PL74105015201000009105236526)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Podmiot1/jpk:IdentyfikatorPodmiotu/etd:NIP",{"$f":"NIP","v":"1111111111"},{"$f":"\"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: \" &S17 & \")\"","v":"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: 1111111111)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataOd",{"$f":"TEXT(DataOd,\"rrrr-MM-dd\")","v":"2016-06-04"},{"$f":"\"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (\" & S18 & \")\"","v":"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (2016-06-04)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataDo",{"$f":"TEXT(DataDo,\"rrrr-MM-dd\")","v":"2016-06-30"},{"$f":"\"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (\" & S19 & \")\"","v":"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (2016-06-30)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa skoroszytu:",null,"JPK_WB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer seryjny:",null,"DEMO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer edycji:",null,1.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wygenerowano:",null,"2025-03-31T11:25:56"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komunikaty w oknach dialogowych",null,"00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schematy, używane gdy nie można użyć wersji online z Ministerstwa Finansów:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa ramki",null,"Przestrzeń nazw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyCechyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2013/05/23/eD/KodyCECHKRAJOW/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UrzedySkarbowe",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ElementarneTypyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StrukturyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JPK",null,{"$f":"JPK_Namespace","v":"http://jpk.mf.gov.pl/wzor/2016/03/09/03092/"}]