{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["JPK-Nagłówek","JPK-Sprzedaż","JPK-Zakup","VAT-7","JPK - uzgodnienie z VAT-7","Parametry","techniczne"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":246,"comments":7,"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":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,10,9,13],[10,10,10,13],[5,10,5,17]]}
[null,null,null,null,null,null,null,"JPK_V7M (2)",null,null,null,"wersja obowiązująca od 1 stycznia 2022"]
[null,null,null,{"$f":"DataWytworzenia()","v":"2024-08-19T12:03:33"}]
[]
[null,null,"Cel złożenia:",1,null,null,null,null,null,"NIP:","7011174664",2]
[]
[null,null,"Rok/Miesiąc:",2024,"/",7,null,null,null,"Pełna nazwa podmiotu:","Rhenus Digital Workforce Sp. zo.o."]
[null,null,"Cel złożenia:",{"$f":"IF(RodzajDokumentu=1,1,2)","v":1}]
[null,null,"Kwartał:",{"$f":"Quarter(Miesiac)","v":3},null,null,null,null,null,"Nazwisko:",null,null,"Imię:",null,null,null,"Data urodzenia:"]
[]
[null,null,null,null,null,null,null,null,null,"Email:","monika.czerwonka@rhenus.com"]
[null,null,"Kod urzędu skarbowego:","1433",null,null,null,null,null,"Telefon:",""]
[]
[]
[]
[null,"Pola obowiązkowe:"]
[null,"Pola opcjonalne:"]

{"sheet":"JPK-Sprzedaż","index":1,"n_rows":75,"n_cols":67,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(OR(Rok = \"\", Miesiac = \"\"),\"\",DATE(Rok,Miesiac,1))","v":"2024-07-01"},null,"Liczba wierszy:",{"$f":"C4 + 0.00000000001","v":69.000000000010004},{"$f":"IF(J7=\"\",\"\",SUBTOTAL(5,J7:J1048576))","v":"2024-07-03"}]
[null,null,null,null,"do dnia:",{"$f":"IF(OR(Rok = \"\", Miesiac = \"\"),\"\",DATE(Rok,Miesiac+1,1)-1)","v":"2024-07-31"},null,"Podatek należny:",{"$f":"SUM(S_16,S_18,S_20,S_24,S_26,S_28,S_30,S_32,S_33,S_34) - SUM(S_35,S_36)+0.00000000001","v":182813.94999999998},{"$f":"IF(J7=\"\",\"\",SUBTOTAL(4,J7:J1048576))","v":"2024-07-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,"kolumny znaczników: wpisz w komórkę \"1\", aby zaznaczyć (Excel wyświetli w takim miejscu słowo \"tak\"), w przeciwnym razie pozostaw puste"]
[null,null,null,null,null,null,null,{"$f":"IF(RodzajDokumentu = 4,\"--------- SEKCJA POMINIĘTA W TEJ KOREKCIE ---------\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"znaczniki dotyczące dostawy i świadczenia usług",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"znaczniki dotyczące procedur",null,null,null,"inne"]
[null,null,{"$f":"SUBTOTAL(3,C7:C1048576)","v":69},null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,L7:L1048575)","v":0},213136.34999999998,182223.76,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,U7:U1048575)","v":696232.47},{"$f":"SUBTOTAL(9,V7:V1048575)","v":160133.47999999998},0,0,0,0,0,0,1214.71,279.39999999999998,97395.85,22401.07,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L$7:L$1048576) - SUMIF($H7:$H$1048576,\"FP\",L$7:L$1048576)","v":0},{"$f":"SUM(M$7:M$1048576) - SUMIF($H7:$H$1048576,\"FP\",M$7:M$1048576)","v":213136.34999999998},{"$f":"SUM(N$7:N$1048576) - SUMIF($H7:$H$1048576,\"FP\",N$7:N$1048576)","v":182223.76},{"$f":"SUM(O$7:O$1048576) - SUMIF($H7:$H$1048576,\"FP\",O$7:O$1048576)","v":0},{"$f":"SUM(P$7:P$1048576) - SUMIF($H7:$H$1048576,\"FP\",P$7:P$1048576)","v":0},{"$f":"SUM(Q$7:Q$1048576) - SUMIF($H7:$H$1048576,\"FP\",Q$7:Q$1048576)","v":0},{"$f":"SUM(R$7:R$1048576) - SUMIF($H7:$H$1048576,\"FP\",R$7:R$1048576)","v":0},{"$f":"SUM(S$7:S$1048576) - SUMIF($H7:$H$1048576,\"FP\",S$7:S$1048576)","v":0},{"$f":"SUM(T$7:T$1048576) - SUMIF($H7:$H$1048576,\"FP\",T$7:T$1048576)","v":0},{"$f":"SUM(U$7:U$1048576) - SUMIF($H7:$H$1048576,\"FP\",U$7:U$1048576)","v":696232.47},{"$f":"SUM(V$7:V$1048576) - SUMIF($H7:$H$1048576,\"FP\",V$7:V$1048576)","v":160133.47999999998},{"$f":"SUM(W$7:W$1048576) - SUMIF($H7:$H$1048576,\"FP\",W$7:W$1048576)","v":0},{"$f":"SUM(X$7:X$1048576) - SUMIF($H7:$H$1048576,\"FP\",X$7:X$1048576)","v":0},{"$f":"SUM(Y$7:Y$1048576) - SUMIF($H7:$H$1048576,\"FP\",Y$7:Y$1048576)","v":0},{"$f":"SUM(Z$7:Z$1048576) - SUMIF($H7:$H$1048576,\"FP\",Z$7:Z$1048576)","v":0},{"$f":"SUM(AA$7:AA$1048576) - SUMIF($H7:$H$1048576,\"FP\",AA$7:AA$1048576)","v":0},{"$f":"SUM(AB$7:AB$1048576) - SUMIF($H7:$H$1048576,\"FP\",AB$7:AB$1048576)","v":0},{"$f":"SUM(AC$7:AC$1048576) - SUMIF($H7:$H$1048576,\"FP\",AC$7:AC$1048576)","v":1214.71},{"$f":"SUM(AD$7:AD$1048576) - SUMIF($H7:$H$1048576,\"FP\",AD$7:AD$1048576)","v":279.39999999999998},{"$f":"SUM(AE$7:AE$1048576) - SUMIF($H7:$H$1048576,\"FP\",AE$7:AE$1048576)","v":97395.85},{"$f":"SUM(AF$7:AF$1048576) - SUMIF($H7:$H$1048576,\"FP\",AF$7:AF$1048576)","v":22401.07},{"$f":"SUM(AG$7:AG$1048576) - SUMIF($H7:$H$1048576,\"FP\",AG$7:AG$1048576)","v":0},{"$f":"SUM(AH$7:AH$1048576) - SUMIF($H7:$H$1048576,\"FP\",AH$7:AH$1048576)","v":0},{"$f":"SUM(AI$7:AI$1048576) - SUMIF($H7:$H$1048576,\"FP\",AI$7:AI$1048576)","v":0},{"$f":"SUM(AJ$7:AJ$1048576) - SUMIF($H7:$H$1048576,\"FP\",AJ$7:AJ$1048576)","v":0},{"$f":"SUM(AK$7:AK$1048576) - SUMIF($H7:$H$1048576,\"FP\",AK$7:AK$1048576)","v":0},{"$f":"SUM(AL$7:AL$1048576) - SUMIF($H7:$H$1048576,\"FP\",AL$7:AL$1048576)","v":0},{"$f":"SUM(AM$7:AM$1048576) - SUMIF($H7:$H$1048576,\"FP\",AM$7:AM$1048576)","v":0}]
[null,null,"Lp. ","Błąd","Kod kraju","NIP kontrahenta","Nazwa kontrahenta","Typ dokumentu","Dowód sprzedaży","Data wystawienia","Data sprzedaży","K 10","K 11","K 12","K 13","K 14","K 15","K 16","K 17","K 18","K 19","K 20","K 21","K 22","K 23","K 24","K 25","K 26","K 27","K 28","K 29","K 30","K 31","K 32","K 33","K 34","K 35","K 36","Sprzedaż VAT Marża","GTU 01","GTU 02","GTU 03","GTU 04","GTU 05","GTU 06","GTU 07","GTU 08","GTU 09","GTU 10","GTU 11","GTU 12","GTU 13","WSTO EE","IED","TP","TT WNT","TT D","MR T","MR UZ","I 42","I 63","B SPV","B SPV Dostawa","B MPV Prowizja","Korekta podstawy opodatkowania","Termin płatności","Data zapłaty"]
[null,null,1,null,"CH","E110310075","Contargo AG",null,"K5","2024-07-12","2024-07-12",0,16373.67,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,2,null,"CH","E110310075","Contargo AG",null,"K6","2024-07-15","2024-07-15",0,5132.47,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,3,null,"DE","813870828","Contargo GmbH & Co. KG",null,"3/07/2024","2024-07-12","2024-07-12",0,-16373.67,-16373.67,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,4,null,"DE","813870828","Contargo GmbH & Co. KG",null,"4/07/2024","2024-07-15","2024-07-15",0,-6426.37,-6426.37,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,5,null,"AU","brak","Atlassian Pty Ltd",null,"IN-EU-000-671-63","2024-07-03","2024-07-04",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,356.11,81.92,0,0,0,0,0,0,0,0,0]
[null,null,6,null,"IE","3336483DH","Slack Technologies Limited",null,"SBIE-6492279","2024-07-14","2024-07-16",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,251.66,57.89,0,0,0,0,0,0,0]
[null,null,7,null,"IL","brak","Monday.com Ltd",null,"IB240100744003","2024-07-21","2024-07-23",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,858.6,197.48,0,0,0,0,0,0,0,0,0]
[null,null,8,null,"DE","233196983","Rhenus Assets & Services",null,"9200252270","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,871.3,200.39,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,9,null,"DE","233196983","Rhenus Assets & Services",null,"9200252752","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2820.44,648.72,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,10,null,"RO","34737997","UiPath SRL",null,"UIP-RO-80745","2024-07-15","2024-07-31",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,36741.25,8450.49,0,0,0,0,0,0,0]
[null,null,11,null,"RO","34737997","UiPath SRL",null,"UIP-RO-80699","2024-07-12","2024-07-31",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56711.199999999997,13043.58,0,0,0,0,0,0,0]
[null,null,12,null,"PL","5270103824","Schenker SP. Z O.O.",null,"K4","2024-07-08","2024-07-08",0,0,0,0,0,0,0,0,0,-1967.7,-452.57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,13,null,"DE","813870828","Contargo GmbH & Co. KG",null,"55/07/2024","2024-07-31","2024-07-31",0,3033.43,3033.43,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,14,null,"PL","5741781080","Zakład Produkcji Spożywczej Jamar",null,"54/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,8252.64,1898.12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,15,null,"PL","5260009816","Akademia Finansów i Biznesu Vistula",null,"53/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,8269.1,1901.89,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,16,null,"PL","2220791536","GELDBACH POLSKA SP. Z O.O.",null,"52/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1722.37,396.14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,17,null,"GB","brak","Rhenus Logistics Ltd.",null,"51/07/2024","2024-07-31","2024-07-31",0,1296.06,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,18,null,"GB","brak","Rhenus Logistics Ltd.",null,"50/07/2024","2024-07-31","2024-07-31",0,3338.91,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,19,null,"ES","B28542751","Saria Bio-Industries España SL",null,"49/07/2024","2024-07-31","2024-07-31",0,3320.5,3320.5,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,20,null,"PL","7740006061","SARIA POLSKA Sp. z o.o.",null,"48/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2142.25,492.72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,21,null,"CA","brak","Rhenus Logistics Canada Limited",null,"47/07/2024","2024-07-31","2024-07-31",0,5078.63,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,22,null,"PL","5130268790","BAYWA R.E. SOLAR SYSTEMS",null,"46/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2356.48,541.99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,23,null,"PL","5262262838","Unum Życie TUiR S.A.",null,"45/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,8005.59,1841.31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,24,null,"DE","814993204","TSR Recycling GmbH & Co. KG",null,"44/07/2024","2024-07-31","2024-07-31",0,2592.13,2592.13,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,25,null,"PL","9721258673","NU DELTA SP. Z O.O.",null,"43/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2400,552,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,26,null,"PL","9591530986","TELBRIDGE Sp. z o.o. Sp. K.",null,"42/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1071.1300000000001,246.36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,27,null,"PL","9591530986","TELBRIDGE Sp. z o.o. Sp. K.",null,"41/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,60439.49,13901.08,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,28,null,"PL","5220014461","ROCHE POLSKA SP. Z O.O.",null,"40/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2816,647.67999999999995,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,29,null,"PL","8520404334","Rhenus Port Logistics Sp.z o.o.",null,"39/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1413.89,325.19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,30,null,"LT","201455113","Rhenus Logistics UAB",null,"38/07/2024","2024-07-31","2024-07-31",0,1178.24,1178.24,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,31,null,"FR","81481212561","Rhenus Logistics France S.A.S.",null,"37/07/2024","2024-07-31","2024-07-31",0,5527.44,5527.44,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,32,null,"FR","04728202730","Rhenus Logistics Alsace S.A.S.",null,"36/07/2024","2024-07-31","2024-07-31",0,1296.06,1296.06,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,33,null,"NL","804989989B01","Rhenus Warehousing Solutions",null,"35/07/2024","2024-07-31","2024-07-31",0,11833.27,11833.27,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,34,null,"NL","818344349B02","Rhenus Assets & Services B.V.",null,"34/07/2024","2024-07-31","2024-07-31",0,8930.57,8930.57,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,35,null,"CH","E116326560","Rhenus Logistics AG",null,"33/07/2024","2024-07-31","2024-07-31",0,2592.13,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,36,null,"DE","244833407","REMONDIS Trade and Sales GmbH",null,"32/07/2024","2024-07-31","2024-07-31",0,2739.43,2739.43,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,37,null,"PL","6262478042","REMONDIS MEDISON",null,"31/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2799.88,643.97,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,38,null,"PL","1070027625","PFR TOWARZYSTWO FUNDUSZY",null,"30/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,4975.8500000000004,1144.43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,39,null,"PL","5213614786","eTravel Spółka Akcyjna",null,"29/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,4000,920,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,40,null,"PL","5260204110","DPD POLSKA SP. Z O.O.",null,"28/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,19184,4412.32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,41,null,"DE","813983342","Contargo Rhein-Neckar GmbH",null,"27/07/2024","2024-07-31","2024-07-31",0,771.21,771.21,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,42,null,"DE","813534781","DIT Duisburg Intermodal",null,"26/07/2024","2024-07-31","2024-07-31",0,13600.64,13600.64,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,43,null,"CH","E106829262","Cargologic AG",null,"25/07/2024","2024-07-31","2024-07-31",0,11635.12,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,44,null,"DE","340305967","IU Group N.V.",null,"24/07/2024","2024-07-31","2024-07-31",0,12467.9,12467.9,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]
[null,null,45,null,"PL","5210415750","AGRANA FRUIT POLSKA SP. Z O.O.",null,"23/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,5904.6,1358.06,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,46,null,"PL","5270103824","Schenker SP. Z O.O.",null,"22/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,64326.34,14795.06,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,47,null,"PL","9730421440","UNIMOT ENERGIA I GAZ SP. Z O.O.",null,"21/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1532.92,352.58,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,48,null,"PL","1132818376","PEPSICO CONSULTING POLSKA",null,"20/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1000,230,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,49,null,"PL","9691582008","HL DISTRIBUTION CENTER EUROPE",null,"19/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,957.42,220.21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,50,null,"NL","807598574B01","HL DISPLAY NEDERLAND B.V.",null,"18/07/2024","2024-07-31","2024-07-31",0,244.35,244.35,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]
[null,null,51,null,"PL","9691581569","HL DISPLAY GLIWICE SP.Z O.O.",null,"17/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,1537.2,353.56,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,52,null,"FR","40377988704","SAS H L DISPLAY FRANCE",null,"16/07/2024","2024-07-31","2024-07-31",0,622.37,622.37,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]
[null,null,53,null,"PL","5222908659","FUNDACJA DKMS",null,"15/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,42037.72,9668.67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,54,null,"DE","146887306","DKMS Group GmbH",null,"14/07/2024","2024-07-31","2024-07-31",0,2025.93,2025.93,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]
[null,null,55,null,"PL","5242930691","DIGIFLOW DANKA SP. Z O.O.",null,"13/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,389.74,89.64,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,56,null,"CH","E110310075","Contargo AG",null,"12/07/2024","2024-07-31","2024-07-31",0,5808.07,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,57,null,"CH","E106829262","Cargologic AG",null,"11/07/2024","2024-07-31","2024-07-31",0,1163.67,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,58,null,"DE","340305967","IU Group N.V.",null,"10/07/2024","2024-07-31","2024-07-31",0,170.09,170.09,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]
[null,null,59,null,"PL","5262685697","BOLIX S.A.",null,"9/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,2555.25,587.71,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,60,null,"PL","5251661440","Acciona Nieruchomości Sp. z o.o.",null,"8/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,8863.43,2038.59,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,61,null,"PL","5213114842","Rhenus Office Systems Poland",null,"7/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,229067.88,52685.599999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,62,null,"PL","6342834728","POLSKA GRUPA GÓRNICZA S.A.",null,"6/07/2024","2024-07-31","2024-07-31",0,0,0,0,0,0,0,0,0,107579,24743.17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,63,null,"CH","E110310075","Contargo AG",null,"K6","2024-07-15","2024-07-15",0,-5132.47,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,64,null,"PL","5213114842","Rhenus Office Systems Poland",null,"5/07/2024","2024-07-15","2024-07-15",0,0,0,0,0,0,0,0,0,102600,23598,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,65,null,"DE","813870828","Contargo GmbH & Co. KG",null,"4/07/2024","2024-07-15","2024-07-15",0,6426.37,6426.37,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,66,null,"CH","E110310075","Contargo AG",null,"K5","2024-07-12","2024-07-12",0,-16373.67,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,67,null,"DE","813870828","Contargo GmbH & Co. KG",null,"3/07/2024","2024-07-12","2024-07-12",0,16373.67,16373.67,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,68,null,"DE","813983342","Contargo Rhein-Neckar GmbH",null,"2/07/2024","2024-07-12","2024-07-12",0,46844.6,46844.6,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,69,null,"NL","809405313B01","Connexxion Nederland NV",null,"1/07/2024","2024-07-09","2024-07-09",0,65025.599999999999,65025.599999999999,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]

{"sheet":"JPK-Zakup","index":2,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,20,1,20]]}
[null,null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(OR(Rok = \"\", Miesiac = \"\"),\"\",DATE(Rok,Miesiac,1))","v":"2024-07-01"},null,"Liczba wierszy:",{"$f":"C4+0.00000000001","v":63.000000000009997},null,{"$f":"IF(K7=\"\",\"\",SUBTOTAL(5,K7:K1048576))","v":"2024-07-01"},null,null,null,null,null,null,null,null,null,"znaczniki"]
[null,null,null,null,"do dnia:",{"$f":"IF(OR(Rok = \"\", Miesiac = \"\"),\"\",DATE(Rok,Miesiac+1,1)-1)","v":"2024-07-31"},null,"Podatek naliczony:",{"$f":"SUM(Z_41,Z_43,Z_44,Z_45,Z_46,Z_47) +0.00000000001","v":109012.29000000002},null,{"$f":"IF(K7=\"\",\"\",SUBTOTAL(4,K7:K1048576))","v":"2024-07-31"}]
[null,null,null,null,null,null,null,{"$f":"IF(RodzajDokumentu = 4,\"--------- SEKCJA POMINIĘTA W TEJ KOREKCIE ---------\",\"\")","v":""}]
[null,null,{"$f":"SUBTOTAL(3,C7:C1048576)","v":63},null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,L7:L1048575)","v":0},{"$f":"SUBTOTAL(9,M7:M1048575)","v":0},479216.24,109012.29000000001,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L1048576)","v":0},{"$f":"SUM(M7:M1048576)","v":0},479216.24,109012.29000000001,0,0,0,0]
[null,null,"Lp. ","Błąd","Kod kraju","NIP dostawcy","Nazwa dostawcy","Typ dokumentu","Dowód zakupu","Data zakupu","Data wpływu","K_40","K_41","K_42","K_43","K_44","K_45","K_46","K_47","Zakup VAT Marża","IMP"]
[null,null,1,null,"PL","5242930691","DigiFlow Danka Spółka",null,"17/06/2024","2024-06-30","2024-07-01",0,0,5500,1265,0,0,0,0,0]
[null,null,2,null,"PL","5242930691","DigiFlow Danka Spółka",null,"18/06/2024","2024-06-30","2024-07-01",0,0,6041.75,1389.6,0,0,0,0,0]
[null,null,3,null,"PL","5242930691","DigiFlow Danka Spółka",null,"19/06/2024","2024-06-30","2024-07-01",0,0,6534.13,1502.85,0,0,0,0,0]
[null,null,4,null,"PL","5242930691","DigiFlow Danka Spółka",null,"20/06/2024","2024-06-30","2024-07-01",0,0,5446,1252.58,0,0,0,0,0]
[null,null,5,null,"PL","5242930691","DigiFlow Danka Spółka",null,"21/06/2024","2024-06-30","2024-07-01",0,0,1874,431.02,0,0,0,0,0]
[null,null,6,null,"PL","5242930691","DigiFlow Danka Spółka",null,"22/06/2024","2024-06-30","2024-07-01",0,0,1309.96,301.29000000000002,0,0,0,0,0]
[null,null,7,null,"PL","5242930691","DigiFlow Danka Spółka",null,"23/06/2024","2024-06-30","2024-07-01",0,0,2177.5,500.83,0,0,0,0,0]
[null,null,8,null,"PL","5242148163","KT Solutions Marcin Kreczko",null,"2/06/2024","2024-06-30","2024-07-01",0,0,11000,2530,0,0,0,0,0]
[null,null,9,null,"PL","5242902826","Virtual Vortex Solutions",null,"00002/06/2024","2024-06-30","2024-07-01",0,0,10004.799999999999,2301.1,0,0,0,0,0]
[null,null,10,null,"PL","1182048176","SYNTHESIT SP.Z O.O.",null,"08/06/2024","2024-06-30","2024-07-01",0,0,7990,1837.7,0,0,0,0,0]
[null,null,11,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2422562","2024-06-30","2024-07-01",0,0,7477.7,1719.87,0,0,0,0,0]
[null,null,12,null,"PL","9721258673","Nu Delta sp. z o.o.",null,"1/07/2024","2024-07-01","2024-07-02",0,0,43030.36,9896.98,0,0,0,0,0]
[null,null,13,null,"PL","5342621191","TCG PROCESS SP. Z O.O.",null,"01/06/2024","2024-07-01","2024-07-01",0,0,7425,1707.75,0,0,0,0,0]
[null,null,14,null,"PL","7822187407","CONTMAN SP. z o o.",null,"149/2024/FVS","2024-06-28","2024-07-01",0,0,3471.72,798.5,0,0,0,0,0]
[null,null,15,null,"PL","5342444180","IT-REALITY MICHAŁ ADAMSKI",null,"6/2024","2024-06-30","2024-07-02",0,0,11000,2530,0,0,0,0,0]
[null,null,16,null,"PL","5221004200","UPS POLSKA SP. Z O.O.",null,"202400317482","2024-07-03","2024-07-04",0,0,46.92,10.79,0,0,0,0,0]
[null,null,17,null,"AU","brak","Atlassian Pty Ltd",null,"IN-EU-000-671-63","2024-07-03","2024-07-04",0,0,356.11,81.92,0,0,0,0,0]
[null,null,18,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423409","2024-06-30","2024-07-04",0,0,1649.22,379.32,0,0,0,0,0]
[null,null,19,null,"PL","1181368542","M.Mazurek i Partnerzy Radcowie",null,"57/06/2024","2024-06-28","2024-07-05",0,0,9180,2111.4,0,0,0,0,0]
[null,null,20,null,"PL","5272395073","SKANSERWIS BIS SP. Z O.O.",null,"0202A/24/FVS","2024-07-05","2024-07-05",0,0,3141.45,722.53,0,0,0,0,0]
[null,null,21,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423444","2024-06-30","2024-07-05",0,0,750,172.5,0,0,0,0,0]
[null,null,22,null,"PL","6171111301","IXELL HURTOWNIA MATERIAŁÓW",null,"117/07/2024","2024-07-05","2024-07-08",0,0,81.3,18.7,0,0,0,0,0]
[null,null,23,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423463","2024-07-08","2024-07-09",0,0,539.28,43.14,0,0,0,0,0]
[null,null,24,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423461","2024-07-08","2024-07-09",0,0,-1876.77,-431.66,0,0,0,0,0]
[null,null,25,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423461","2024-07-08","2024-07-09",0,0,1876.77,431.66,0,0,0,0,0]
[null,null,26,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423464","2024-07-08","2024-07-09",0,0,789.34,63.15,0,0,0,0,0]
[null,null,27,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2421928","2024-06-28","2024-07-09",0,0,1958.48,450.45,0,0,0,0,0]
[null,null,28,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423462","2024-07-08","2024-07-09",0,0,-1958.48,-450.45,0,0,0,0,0]
[null,null,29,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2423465","2024-07-08","2024-07-09",0,0,664.2,53.14,0,0,0,0,0]
[null,null,30,null,"PL","6751598656","G1ANT SP. Z O.O.",null,"FV 19/2024","2024-06-28","2024-07-09",0,0,25287.53,5816.13,0,0,0,0,0]
[null,null,31,null,"PL","1181368542","M.Mazurek i Partnerzy Radcowie",null,"12/07/2024","2024-07-10","2024-07-10",0,0,450,103.5,0,0,0,0,0]
[null,null,32,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2424318","2024-07-12","2024-07-12",0,0,23872.12,5490.59,0,0,0,0,0]
[null,null,33,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2424319","2024-07-12","2024-07-12",0,0,3692.35,485.61,0,0,0,0,0]
[null,null,34,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2424337","2024-07-12","2024-07-15",0,0,1697.83,195.25,0,0,0,0,0]
[null,null,35,null,"PL","5221004200","UPS POLSKA SP. Z O.O.",null,"202400322641","2024-07-10","2024-07-16",0,0,297.08999999999997,68.33,0,0,0,0,0]
[null,null,36,null,"PL","7781445202","Security Expert Sp. z o.o.",null,"149/7/2024/FVS","2024-07-12","2024-07-16",0,0,9514,2188.2199999999998,0,0,0,0,0]
[null,null,37,null,"IE","3336483DH","Slack Technologies Limited",null,"SBIE-6492279","2024-07-14","2024-07-16",0,0,251.66,57.89,0,0,0,0,0]
[null,null,38,null,"PL","6272778780","PIER LUIGI SP. Z O.O.",null,"81/S/07/24/FV","2024-07-16","2024-07-17",0,0,176,40.479999999999997,0,0,0,0,0]
[null,null,39,null,"PL","1180091073","Rhenus Warehousing Solutions Polska",null,"9999918772024","2024-07-17","2024-07-17",0,0,500,115,0,0,0,0,0]
[null,null,40,null,"IL","brak","Monday.com Ltd",null,"IB240100744003","2024-07-21","2024-07-23",0,0,858.6,197.48,0,0,0,0,0]
[null,null,41,null,"PL","5221004200","UPS POLSKA SP. Z O.O.",null,"202400333539","2024-07-24","2024-07-29",0,0,43.99,10.119999999999999,0,0,0,0,0]
[null,null,42,null,"PL","1230716949","HEXON II JAROSLAW PIELAK-TRALEWICZ",null,"3430/2024","2024-07-25","2024-07-29",0,0,952.21,219.01,0,0,0,0,0]
[null,null,43,null,"PL","5252246542","MINIT POLSKA SP.Z O.O.",null,"W108100","2024-07-25","2024-07-29",0,0,40.65,4.67,0,0,0,0,0]
[null,null,44,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2425502","2024-07-29","2024-07-29",0,0,3798.45,873.64,0,0,0,0,0]
[null,null,45,null,"PL","8561164306","AZ.pl Sp. z o.o.",null,"2024/0022238","2024-07-26","2024-07-29",0,0,136,31.28,0,0,0,0,0]
[null,null,46,null,"PL","8561164306","AZ.pl Sp. z o.o.",null,"2024/0022237","2024-07-26","2024-07-29",0,0,511,117.53,0,0,0,0,0]
[null,null,47,null,"PL","8561164306","AZ.pl Sp. z o.o.",null,"2024/0022236","2024-07-26","2024-07-29",0,0,41,9.43,0,0,0,0,0]
[null,null,48,null,"PL","6762474254","LUXURY GOODS.PL S.C.",null,"10330/MAG/07/202","2024-07-24","2024-07-30",0,0,138.19999999999999,31.79,0,0,0,0,0]
[null,null,49,null,"PL","9521490371","Interstrefa Grzegorz Zdzieborski",null,"1/07/2024","2024-07-31","2024-07-31",0,0,12600,2898,0,0,0,0,0]
[null,null,50,null,"PL","6751377004","KINGDOM CONSULTING",null,"7/2024","2024-06-30","2024-07-31",0,0,7155.15,1645.68,0,0,0,0,0]
[null,null,51,null,"PL","8392473400","ITBCG BARTOSZ MAREK KOCHANOWSKI",null,"1/07/2024","2024-07-31","2024-07-31",0,0,3000,345,0,0,0,0,0]
[null,null,52,null,"PL","5242902826","Virtual Vortex Solutions",null,"00002/07/2024","2024-07-31","2024-07-31",0,0,10004.799999999999,2301.1,0,0,0,0,0]
[null,null,53,null,"PL","5242148163","KT Solutions Marcin Kreczko",null,"4/07/2024","2024-07-31","2024-07-31",0,0,11000,2530,0,0,0,0,0]
[null,null,54,null,"DE","233196983","Rhenus Assets & Services",null,"9200252270","2024-07-31","2024-07-31",0,0,871.3,200.39,0,0,0,0,0]
[null,null,55,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2426197","2024-07-31","2024-07-31",0,0,1772.68,407.72,0,0,0,0,0]
[null,null,56,null,"DE","233196983","Rhenus Assets & Services",null,"9200252752","2024-07-31","2024-07-31",0,0,2820.44,648.72,0,0,0,0,0]
[null,null,57,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2425890","2024-07-31","2024-07-31",0,0,663.98,53.12,0,0,0,0,0]
[null,null,58,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2425890","2024-07-31","2024-07-31",0,0,-663.98,-53.12,0,0,0,0,0]
[null,null,59,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2425889","2024-07-31","2024-07-31",0,0,57200,13156,0,0,0,0,0]
[null,null,60,null,"PL","5213114842","Rhenus Office Systems Poland",null,"FV2415889","2024-07-31","2024-07-31",0,0,57200,13156,0,0,0,0,0]
[null,null,61,null,"RO","34737997","UiPath SRL",null,"UIP-RO-80745","2024-07-15","2024-07-31",0,0,36741.25,8450.49,0,0,0,0,0]
[null,null,62,null,"RO","34737997","UiPath SRL",null,"UIP-RO-80699","2024-07-12","2024-07-31",0,0,56711.199999999997,13043.58,0,0,0,0,0]
[null,null,63,null,"PL","9512358749","Kancelaria Notarialna",null,"11/04/24","2024-04-05","2024-07-10",0,0,2400,552,0,0,0,0,0]

{"sheet":"VAT-7","index":3,"n_rows":178,"n_cols":21,"rows_kept":178,"cut":false,"hidden":false,"merged":[[107,2,107,13],[108,2,108,13],[85,14,85,18],[135,1,135,16],[137,12,138,15],[137,16,138,18],[105,2,106,13],[109,2,109,13],[110,2,110,13],[111,2,111,13],[114,2,114,13],[114,14,114,18],[115,2,115,13],[108,14,108,18],[105,14,105,18],[107,14,107,18],[113,2,113,13],[128,9,128,13],[125,5,125,18],[126,14,126,18],[127,14,127,18],[128,14,128,18],[128,4,129,8],[88,10,88,13],[88,14,88,18],[177,16,178,17],[106,14,106,18],[137,9,138,11],[142,1,142,18],[143,1,143,18],[137,2,137,5],[138,2,138,5],[136,2,136,5],[132,3,133,13],[119,4,122,4],[137,6,138,8],[117,3,117,13],[121,5,122,6],[144,2,145,13],[144,14,144,18],[145,14,145,18],[146,2,147,13],[146,14,146,18],[147,14,147,18],[149,2,149,18],[151,1,151,4],[151,7,151,18],[177,18,178,18],[152,1,152,18],[109,20,110,20],[109,14,109,18],[118,14,118,18],[131,14,131,18],[132,14,133,18],[113,14,113,18],[110,14,111,18],[115,14,116,18],[116,2,116,13],[120,5,120,13],[129,9,129,18],[100,14,100,18],[93,2,94,13],[95,2,96,13],[97,2,98,13],[99,2,100,13],[103,16,103,18],[90,2,91,9],[89,10,89,13],[97,14,97,18],[99,14,99,18],[92,1,92,18],[93,14,93,18],[95,14,95,18],[94,14,94,18],[89,14,89,18],[89,2,89,9],[90,14,90,18],[90,10,90,13],[91,10,91,13],[91,14,91,18],[96,14,96,18],[98,14,98,18],[74,14,75,18],[75,3,75,9],[82,1,82,18],[83,1,83,13],[83,14,83,18],[71,3,71,13],[71,14,71,18],[72,3,72,13],[72,14,72,18],[73,3,73,9],[73,10,73,13],[73,14,73,18],[74,3,74,9],[64,3,64,9],[64,10,64,13],[64,14,64,18],[63,3,63,9],[63,14,63,18],[60,3,60,9],[60,10,60,13],[60,14,60,18],[61,3,61,9],[61,14,61,18],[62,3,62,9],[62,10,62,13],[62,14,62,18],[57,3,57,9],[57,14,57,18],[58,3,58,9],[58,10,58,13],[58,14,58,18],[59,3,59,9],[59,14,59,18],[51,3,52,9],[52,10,52,13],[53,3,54,9],[54,10,54,13],[55,3,56,9],[55,14,55,18],[56,10,56,13],[56,14,56,18],[2,1,2,18],[3,1,3,8],[4,1,4,3],[4,4,4,8],[12,1,12,18],[5,5,5,14],[6,6,7,6],[6,8,6,10],[7,8,7,10],[4,11,4,18],[50,14,50,18],[45,3,45,9],[45,14,45,18],[46,3,46,9],[9,1,10,18],[35,3,35,9],[36,3,36,9],[36,10,36,13],[30,3,30,9],[30,10,30,11],[30,12,30,18],[32,1,34,9],[33,10,34,13],[33,14,34,18],[25,15,25,18],[16,1,16,18],[17,1,17,18],[18,3,18,18],[20,3,20,18],[46,10,46,13],[46,14,46,18],[47,3,47,9],[47,14,47,18],[43,4,43,9],[43,14,43,18],[37,3,37,9],[38,3,38,9],[38,10,38,13],[44,4,44,9],[44,10,44,13],[44,14,44,18],[39,4,39,9],[39,14,39,18],[23,3,23,14],[23,15,23,18],[24,3,24,14],[24,15,24,18],[25,3,25,9],[25,10,25,14],[42,3,42,9],[42,10,42,13],[42,14,42,18],[22,3,22,18],[68,3,68,13],[68,14,68,18],[69,3,69,13],[69,14,69,18],[26,3,26,9],[26,10,26,14],[26,15,26,18],[28,3,28,6],[28,7,28,15],[28,17,28,18],[67,14,67,18],[40,4,40,9],[40,10,40,13],[40,14,40,18],[41,3,41,9],[41,14,41,18],[48,3,48,9],[48,10,48,13],[48,14,48,18],[49,3,49,9],[49,14,49,18],[50,3,50,9],[50,10,50,13],[155,1,156,18],[70,14,70,18],[65,3,65,13],[65,14,65,18],[66,3,66,13],[66,14,66,18],[67,3,67,13],[70,3,70,13],[79,1,79,18],[76,1,78,15],[77,16,78,17],[77,18,78,18],[104,1,104,18],[101,14,101,18],[102,14,102,18],[101,2,102,13],[86,1,86,18],[88,2,88,9],[87,14,87,18],[87,10,87,13],[84,3,84,13],[84,14,84,18],[85,3,85,13],[74,10,75,13]]}
[]
[null,null,null,null,null,null,null,{"$f":"\"Niniejsza deklaracja stanowi część pliku \" & 'JPK-Nagłówek'!H1","v":"Niniejsza deklaracja stanowi część pliku JPK_V7M (2)"}]
[]
[null," 1. Identyfikator podatkowy NIP podatnika",null,null,null,null,null,null,null,null,null,"Miejsce na wpisanie numeru UPO (opcjonalne, tylko dla wydruku):"]
[null,null,null,null,{"$f":"IF(NIP=\"\",\"\",NIP*1)","v":7011174664}]
[null,"VAT-7",null,null,null,"DEKLARACJA DLA PODATKU OD TOWARÓW I USŁUG"]
[null,null,null,null,null,null,"za"," 4. Miesiąc"," 5. Rok"]
[null,null,null,null,null,null,null,{"$f":"IF(Miesiac=\"\",\"\",Miesiac)","v":7},{"$f":"IF(Rok=\"\",\"\",Rok)","v":2024},null,null,{"$f":"IF(RodzajDokumentu = 3,\"        ---- DEKLARACJA JEST POMINIĘTA W TEJ KOREKCIE -----\",\"\")","v":""}]
[]
[null,"Uwaga: przedstawiony poniżej podział na sekcje A..G jest oparty na ostatnim opublikowanym przez MF formularzu VAT-7 (20). Jest to podział wyłącznie poglądowy, gdyż w strukturze pliku JPK ta deklaracja nie jest dzielona na jakiekolwiek sekcje. Zawartość sekcji A i B jest odzwierciedleniem danych wprowadzonych w arkuszu \"JPK-Nagłówek\". Zawartość sekcji C to podsumowanie danych z arkusza \"JPK-Sprzedaż\", a sekcji D - arkusza \"JPK-Zakup\"."]
[]
[]
[null," A. MIEJSCE I CEL SKŁADANIA DEKLARACJI"]
[null,null,null," 6. Kod urzędu skarbowego, do którego adresowana jest deklaracja:",null,null,null,null,null,null,null," 7. Cel złożenia deklaracji:"]
[null,null,null,null,{"$f":"KodUrzedu","v":"1433"},null,null,null,null,null,null,null,"1. złożenie deklaracji",null,null,null,"2. korekta deklaracji"]
[null,null,null,null,null,null,null,null,null,{"$f":"(TypPodatnika = 2)","v":true},{"$f":"(TypPodatnika = 1)","v":false},null,{"$f":"(CelZlozenia=1)","v":true},null,null,null,{"$f":"(CelZlozenia<>1)","v":false}]
[null," B. DANE IDENTYFIKACYJNE PODATNIKA"]
[]
[null,null,null," 8. Rodzaj podatnika:"]
[null,null,null,null,null,null,"1. podatnik niebędący osobą fizyczną",null,null,null,null,null,null,"2. osoba fizyczna"]
[null,null,null,{"$f":"\" 9. \" & IF(TypPodatnika = 2, \"Nazwa pełna\",\"Nazwisko, pierwsze imię, data urodzenia\") & \":\"","v":" 9. Nazwa pełna:"}]
[]
[null,null,null,{"$f":" IF(TypPodatnika = 2, IF(PelnaNazwa = \"\", \"\", PelnaNazwa), IF(Nazwisko = \"\",\"\",Nazwisko & \", \" & ImiePierwsze & \", \" & TEXT(DataUrodzenia,\"rrrr-MM-dd\")))","v":"Rhenus Digital Workforce Sp. zo.o."}]
[null,null,null," 9. Nazwa pełna",null,null,null,null,null,null,null,null,null,null,null,"REGON"]
[]
[null,null,null," 9. Nazwisko",null,null,null,null,null,null,"Pierwsze imię",null,null,null,null,"Data urodzenia (ddmmrrrr)"]
[]
[]
[]
[]
[]
[]
[null," C. ROZLICZENIE PODATKU NALEŻNEGO     "]
[null,null,null,null,null,null,null,null,null,null,"Podstawa opodatkowania w zł",null,null,null,"Podatek należny w zł"]
[]
[null,null,null," 1. Dostawa towarów oraz świadczenie usług na terytorium kraju,",null,null,null,null,null,null," 10."]
[null,null,null," zwolnione od podatku",null,null,null,null,null,null,{"$f":"+ROUND(S_10,)","v":0}]
[null,null,null," 2. Dostawa towarów oraz świadczenie usług poza terytorium",null,null,null,null,null,null," 11."]
[null,null,null," kraju",null,null,null,null,null,null,{"$f":"+ROUND(S_11,)","v":213136}]
[null,null,null,null," 2a. w tym świadczenie usług, o których mowa w art. 100",null,null,null,null,null," 12."]
[null,null,null,null,"  ust. 1 pkt 4 ustawy",null,null,null,null,null,{"$f":"+ROUND(S_12,)","v":182224}]
[null,null,null," 3. Dostawa towarów oraz świadczenie usług na terytorium kraju,",null,null,null,null,null,null," 13."]
[null,null,null," opodatkowane stawką 0%",null,null,null,null,null,null,{"$f":"+ROUND(S_13,)","v":0}]
[null,null,null,null," 3a. w tym dostawa towarów, o której mowa w art. 129",null,null,null,null,null," 14."]
[null,null,null,null,"  ustawy",null,null,null,null,null,{"$f":"+ROUND(S_14,)","v":0}]
[null,null,null," 4. Dostawa towarów oraz świadczenie usług na terytorium kraju,",null,null,null,null,null,null," 15.",null,null,null," 16."]
[null,null,null,"opodatkowane stawką 5%, oraz korekty dokonanej zgodnie z art. 89a ust. 1 i 4 ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_15,)","v":0},null,null,null,{"$f":"+ROUND(S_16,)","v":0}]
[null,null,null," 5. Dostawa towarów oraz świadczenie usług na terytorium kraju,",null,null,null,null,null,null," 17.",null,null,null," 18."]
[null,null,null,"opodatkowane stawką 7% albo 8%, oraz korekty dokonanej zgodnie z art. 89a ust. 1 i 4 ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_17,)","v":0},null,null,null,{"$f":"+ROUND(S_18,)","v":0}]
[null,null,null," 6. Dostawa towarów oraz świadczenie usług na terytorium kraju,",null,null,null,null,null,null," 19.",null,null,null," 20."]
[null,null,null,"opodatkowane stawką 22% albo 23%, oraz korekty dokonanej zgodnie z art. 89a ust. 1 i 4 ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_19,)","v":696232},null,null,null,{"$f":"+ROUND(S_20,)","v":160133}]
[null,null,null," 7. Wewnątrzwspólnotowa dostawa towarów",null,null,null,null,null,null," 21."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_21,)","v":0}]
[null,null,null," 8. Eksport towarów",null,null,null,null,null,null," 22."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_22,)","v":0}]
[null,null,null," 9. Wewnątrzwspólnotowe nabycie towarów",null,null,null,null,null,null," 23.",null,null,null," 24."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_23,)","v":0},null,null,null,{"$f":"+ROUND(S_24,)","v":0}]
[null,null,null," 10. Import towarów podlegający rozliczeniu zgodnie z art. 33a",null,null,null,null,null,null," 25.",null,null,null," 26."]
[null,null,null," ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_25,)","v":0},null,null,null,{"$f":"+ROUND(S_26,)","v":0}]
[null,null,null," 11. Import usług z wyłączeniem usług nabywanych od",null,null,null,null,null,null," 27.",null,null,null," 28."]
[null,null,null,"  podatników podatku od wartości dodanej, do których stosuje\n  się art. 28b ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_27,)","v":1215},null,null,null,{"$f":"+ROUND(S_28,)","v":279}]
[null,null,null," 12. Import usług nabywanych od podatników podatku od",null,null,null,null,null,null," 29.",null,null,null," 30."]
[null,null,null,"   wartości dodanej, do których stosuje się art. 28b ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_29,)","v":97396},null,null,null,{"$f":"+ROUND(S_30,)","v":22401}]
[null,null,null," 13. Dostawa towarów, dla których podatnikiem jest nabywca",null,null,null,null,null,null," 31.",null,null,null," 32."]
[null,null,null,"   zgodnie z art. 17 ust. 1 pkt 5 ustawy",null,null,null,null,null,null,{"$f":"+ROUND(S_31,)","v":0},null,null,null,{"$f":"+ROUND(S_32,)","v":0}]
[null,null,null," 14. Kwota podatku należnego od towarów i usług objętych spisem z natury, o którym mowa w art. 14 ust. 5",null,null,null,null,null,null,null,null,null,null," 33."]
[null,null,null,"  ustawy",null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_33,)","v":0}]
[null,null,null," 15. Zwrot odliczonej lub zwróconej kwoty wydatkowanej na zakup kas rejestrujących, o którym mowa w art. 111",null,null,null,null,null,null,null,null,null,null," 34."]
[null,null,null,"  ust. 6 ustawy",null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_34,)","v":0}]
[null,null,null," 16. Kwota podatku należnego od wewnątrzwspólnotowego nabycia środków transportu, wykazanego w poz. 24,",null,null,null,null,null,null,null,null,null,null," 35."]
[null,null,null,"  podlegająca wpłacie w terminie, o którym mowa w art. 103 ust. 3, w związku z ust. 4 ustawy ",null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_35,)","v":0}]
[null,null,null," 17. Wysokość podatku od wewnątrzwspólnotowego nabycia towarów, o których mowa w art. 103 ust. 5aa,",null,null,null,null,null,null,null,null,null,null," 36."]
[null,null,null," podlegająca wpłacie w terminach,  o których mowa w art. 103 ust. 5a i 5b ustawy",null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(S_36,)","v":0}]
[null,null,null,"  Razem: (Poz. 37 = suma kwot z poz. 10, 11, 13, 15, 17, 19, 21, 22, 23, ",null,null,null,null,null,null,37,null,null,null," 38."]
[null,null,null," 25, 27, 29 i 31. Poz. 38 = suma kwot z poz. 16, 18, 20, 24, 26, 28, 30,",null,null,null,null,null,null,{"$f":"SUM(P_10, P_11, P_13, P_15, P_17, P_19, P_21, P_22, P_23, P_25, P_27, P_29, P_31)","v":1007979},null,null,null,{"$f":"SUM(P_16, P_18, P_20, P_24, P_26, P_28, P_30, P_32, P_33, P_34) - (P_35 + P_36)+0.000000000001","v":182813}]
[null,null,null," 32, 33 i 34, pomniejszona o kwoty z poz. 35 i 36)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT-7(22)",null,"1/3"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"$H$2","v":"Niniejsza deklaracja stanowi część pliku JPK_V7M (2)"}]
[]
[null," D. ROZLICZENIE PODATKU NALICZONEGO"]
[null," D.1. PRZENIESIENIA",null,null,null,null,null,null,null,null,null,null,null,null,"Podatek do odliczenia w zł"]
[null,null,null," Kwota nadwyżki z poprzedniej deklaracji",null,null,null,null,null,null,null,null,null,null," 39."]
[null,null,null," Kwota z poz. „Kwota do przeniesienia na następny okres rozliczeniowy” z poprzedniej deklaracji lub wynikająca z decyzji.",null,null,null,null,null,null,null,null,null,null,0]
[null," D.2. NABYCIE TOWARÓW I USŁUG ORAZ PODATEK NALICZONY Z UWZGLĘDNIENIEM KOREKT"]
[null,null,null,null,null,null,null,null,null,null,"Wartość netto w zł",null,null,null,"Podatek naliczony w zł"]
[null,null," Nabycie towarów i usług zaliczanych u podatnika do środków",null,null,null,null,null,null,null,"40.",null,null,null,"41."]
[null,null," trwałych",null,null,null,null,null,null,null,{"$f":"+ROUND(Z_40,)","v":0},null,null,null,{"$f":"+ROUND(Z_41,)","v":0}]
[null,null," Nabycie towarów i usług pozostałych",null,null,null,null,null,null,null,"42.",null,null,null,"43."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(Z_42,)","v":479216},null,null,null,{"$f":"+ROUND(Z_43,)","v":109012}]
[null," D.3. PODATEK NALICZONY – DO ODLICZENIA (w zł)"]
[null,null," Korekta podatku naliczonego od nabycia środków trwałych",null,null,null,null,null,null,null,null,null,null,null,"44."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(Z_44,)","v":0}]
[null,null," Korekta podatku naliczonego od pozostałych nabyć",null,null,null,null,null,null,null,null,null,null,null,"45."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(Z_45,)","v":0}]
[null,null," Korekta podatku naliczonego, o której mowa w art. 89b ust. 1 ustawy\n (kwota ujemna)",null,null,null,null,null,null,null,null,null,null,null,"46."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(Z_46,)","v":0}]
[null,null," Korekta podatku naliczonego, o której mowa w art. 89b ust. 4 ustawy",null,null,null,null,null,null,null,null,null,null,null,"47."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(Z_47,)","v":0}]
[null,null," Razem kwota podatku naliczonego do odliczenia.\n (Suma kwot z pozycji 39, 41, 43, 44, 45, 46 i 47)",null,null,null,null,null,null,null,null,null,null,null,"48."]
[null,null," Należy wpisać sumę kwot z poz. 42, 44, 46, 47, 48, 49 i 50.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P_39, P_41, P_43, P_44, P_45, P_46, P_47)","v":109012}]
[]
[null," E. OBLICZENIE WYSOKOŚCI ZOBOWIĄZANIA PODATKOWEGO LUB KWOTY ZWROTU (w zł)"]
[null,null," Kwota wydana na zakup kas rejestrujących, do odliczenia w danym okresie rozliczeniowym\n Kwota ta nie może być wyższa od różnicy kwot z  pozycji 38 i 48. Jeżeli różnica kwot pomiędzy  poz. 38 i poz. 48 jest mniejsza lub równa 0, wówczas należy wykazać 0.",null,null,null,null,null,null,null,null,null,null,null,"49."]
[null,null," Kwota wykazana w poz. 52 nie może być wyższa od różnicy kwot z poz. 41 i 51.\n Jeżeli różnica kwot pomiędzy poz. 41 i 51 jest mniejsza lub równa 0, wówczas należy wpisać 0.",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,-1]
[null,null," Kwota podatku objęta zaniechaniem poboru",null,null,null,null,null,null,null,null,null,null,null,"50."]
[null,null,"Nie może być wyższa niż różnica pomiędzy kwotą z  pozycji 38 a sumą kwot z  pozycji 48 i 49. Jeżeli różnica kwot pomiędzy  poz. 38 i poz. 48, pomniejszona o kwotę z poz. 49 jest mniejsza od 0, wówczas należy wykazać 0.",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,-1]
[null,null," Kwota podatku podlegającego wpłacie do urzędu skarbowego",null,null,null,null,null,null,null,null,null,null,null,"51.",null,null,null,null,null,0]
[null,null," Jeżeli różnica kwot pomiędzy poz. 38 i poz. 48 jest większa od 0, wówczas poz. 51 = poz. 38 - poz. 48 - poz. 49 - poz. 50, ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P_38>P_48,P_38-P_48-P_49-P_50,0.0000000001)","v":73801}]
[null,null,"  w przeciwnym wypadku należy wpisać 0."]
[null,null," Kwota wydana na zakup kas rejestrujących, do odliczenia w danym okresie rozliczeniowym",null,null,null,null,null,null,null,null,null,null,null,"52."]
[null,null,"przysługująca do zwrotu w danym okresie rozliczeniowym lub powiększająca wysokość podatku naliczonego do przeniesienia na następny okres rozliczeniowy",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null," Wysokość nadwyżki podatku naliczonego nad należnym",null,null,null,null,null,null,null,null,null,null,null,"53."]
[null,null," Jeżeli P_51 > 0 to P_53 = 0 w przeciwnym wypadku jeżeli (P_48 + P_49 + P_50  + P_52) – P_38 >  0",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P_51>0.000001,0,IF((P_48 + P_49 + P_50 + P_52 - P_38) > 0,P_48-P_38+P_49+P_50+P_52,0))","v":0}]
[null,null," to P_53 = P_48 - P_38 + P_49 + P_50  + P_52 w pozostałych przypadkach P_53 = 0."]
[null,null,null," Wysokość nadwyżki podatku naliczonego nad należnym do zwrotu na rachunek wskazany przez podatnika",null,null,null,null,null,null,null,null,null,null,"54."]
[]
[null,null,null,null,"Zaznacz jeden z podanych kwadratów:"," 55. "]
[]
[null,null,null,null,null,"na rachunek rozliczeniowy, w terminie:",null," 540.",null," 56.",null,null," 560.",null," 57. ",null,null," 58. "]
[]
[]
[null,null,null,null," 59. Zaliczenie zwrotu podatku na poczet przyszłych zobowiązań podatkowych"]
[null,null,null,null,null,"Podatnik wnosi o zaliczenie zwrotu podatku na poczet przyszłych zobowiązań podatkowych, zgodnie z art. 76 § 1 i art. 76b § 1 ustawy z dnia 29 sierpnia 1997 r. - Ordynacja podatkowa (Dz. U. z 2021 r. poz. 1540, z późn. zm.), wraz z podaniem wysokości zaliczenia oraz rodzaju zobowiązania podatkowego:"]
[null,null,null,null," Wysokość zwrotu do zaliczenia na poczet przyszłych zobowiązań podatkowych:",null,null,null,null,null,null,null,null,null," 60."]
[]
[null,null,null,null," Rodzaj przyszłego zobowiązania podatkowego:",null,null,null,null," 61."]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null," Kwota do przeniesienia na następny okres rozliczeniowy",null,null,null,null,null,null,null,null,null,null," 62."]
[null,null,null," Od kwoty z poz. 53 należy odjąć kwotę z poz. 54.",null,null,null,null,null,null,null,null,null,null,{"$f":"P_53 - P_54","v":0}]
[]
[null,null,null,null,null,null,null,null,false,null,null,false,null,null,false]
[null," F. INFORMACJE DODATKOWE"]
[null,null," Podatnik wykonywał w okresie",null,null,null,"63.",null,null,"64.",null,null,"65.",null,null,null,"66."]
[null,null," rozliczeniowym czynności, o których"]
[null,null," mowa w (zaznaczyć właściwe kwadraty):"]
[null,null,"660.",null,null,null,null,null,null,null,null,"67."]
[]
[]
[null," G. INFORMACJA O KOREKCIE DEKLARACJI"]
[]
[null,null," Wysokość korekty podstawy opodatkowania, o której mowa w art. 89a ust. 1 ustawy\n",null,null,null,null,null,null,null,null,null,null,null,"68."]
[null,null," Kwota wykazana w poz. 52 nie może być wyższa od różnicy kwot z poz. 41 i 51.\n Jeżeli różnica kwot pomiędzy poz. 41 i 51 jest mniejsza lub równa 0, wówczas należy wpisać 0.",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,-1]
[null,null," Wysokość korekty podatku należnego, o której mowa w art. 89a ust. 1 ustawy",null,null,null,null,null,null,null,null,null,null,null,"69."]
[null,null," Kwota ta nie może być wyższa niż różnica pomiędzy kwotą z poz. 41 a sumą kwot z poz. 51 i 52.\n Jeżeli różnica kwot pomiędzy poz. 41 i 51, pomniejszona o kwotę z poz. 52 jest mniejsza od 0, wówczas należy wpisać 0.\n ",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,-1]
[null,null," 70. Uzasadnienie przyczyn złożenia korekty:"]
[null,null,""]
[]
[null,"VAT-7(22)",null,null,null,"2/3"]
[]
[null,null,null,null,null,null,null,{"$f":"$H$2","v":"Niniejsza deklaracja stanowi część pliku JPK_V7M (2)"}]
[null,"POUCZENIA:",null,null,null,1]
[null,"W przypadku niewpłacenia w obowiązującym terminie podatku podlegającego wpłacie do urzędu skarbowego lub wpłacenia go w niepełnej wysokości niniejsza deklaracja stanowi podstawę do wystawienia tytułu wykonawczego zgodnie z przepisami o postępowaniu egzekucyjnym w administracji.\n\nZa podanie nieprawdy lub zatajenie prawdy i przez to narażenie podatku na uszczuplenie grozi odpowiedzialność przewidziana w przepisach Kodeksu karnego skarbowego."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT-7(22)",null,"3/3"]

{"sheet":"JPK - uzgodnienie z VAT-7","index":4,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["ROZLICZENIE PODATKU NALEŻNEGO"]
[null,"Podstawa opodatkowania w zł","Podatek należny w zł"]
["1. Dostawa towarów oraz świadczenie usług, na terotyrium kraju, zwolnione od podatku",{"$f":"+ROUND('JPK-Sprzedaż'!L5,)","v":0}]
["2. Dostawa towarów oraz świadczenie usług poza terytorium kraju",{"$f":"+ROUND('JPK-Sprzedaż'!M5,)","v":213136}]
["    2a. w tym świadczenie usług, o których mowa w art. 100 ust. 1 pkt. 4",{"$f":"+ROUND('JPK-Sprzedaż'!N5,)","v":182224}]
["3. Dostawa towarów oraz świadczenie usług, na terytorium kraju, opodatkowane stawką 0%",{"$f":"+ROUND('JPK-Sprzedaż'!O5,)","v":0}]
["    3a. w tym dostawa towarów, o której mowa w art. 129 ustawy",{"$f":"+ROUND('JPK-Sprzedaż'!P5,)","v":0}]
["4. Dostawa towarów oraz świadczenie usług, na terytorium kraju, opodatkowane stawką 5%",{"$f":"+ROUND('JPK-Sprzedaż'!Q5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!R5,)","v":0}]
["5. Dostawa towarów oraz świadczenie usług, na terytorium kraju, opodatkowane stawką 7% albo 8%",{"$f":"+ROUND('JPK-Sprzedaż'!S5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!T5,)","v":0}]
["6. Dostawa towarów oraz świadczenie usług, na terytorium kraju, opodatkowane stawką 22% albo 23%",{"$f":"+ROUND('JPK-Sprzedaż'!U5,)","v":696232},{"$f":"+ROUND('JPK-Sprzedaż'!V5,0)","v":160133}]
["7. Wewnątrzwspólnotowa dostawa towarów",{"$f":"+ROUND('JPK-Sprzedaż'!W5,)","v":0}]
["8. Eksport towarów",{"$f":"+ROUND('JPK-Sprzedaż'!X5,)","v":0}]
["9. Wewnątrzwspólnotowe nabycie towarów",{"$f":"+ROUND('JPK-Sprzedaż'!Y5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!Z5,)","v":0}]
["10. Import towarów podlegający rozliczeniu zgodnie z art. 33a ustawy",{"$f":"+ROUND('JPK-Sprzedaż'!AA5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!AB5,)","v":0}]
["11. Import usług z wyłączeniem usług nabywanych od podatników podatku od wartości dodanej, do których stosuje się art.. 28b",{"$f":"+ROUND('JPK-Sprzedaż'!AC5,)","v":1215},{"$f":"+ROUND('JPK-Sprzedaż'!AD5,)","v":279}]
["12. Import usług nabywanych od podatników podatku od wartości dodanej, do których stosuje się art. 28b",{"$f":"+ROUND('JPK-Sprzedaż'!AE5,)","v":97396},{"$f":"+ROUND('JPK-Sprzedaż'!AF5,)","v":22401}]
["13. Dostawa towarów oraz świadczenie usług, dla których podatnkikiem jest nabywca zgodnie z art. 17 ust. 1 pkt 7 lub 8 (wypełnia dostawca)",{"$f":"+ROUND('JPK-Sprzedaż'!AG5,)","v":0}]
["14. Dostawa towarów, dla których podatnikiem jest nabywca zgodnie z art. 17 ust. 1 pkt 5 (wypełnia nabywca)",{"$f":"+ROUND('JPK-Sprzedaż'!AH5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!AI5,)","v":0}]
["15. Dostawa towarów oraz świadczenie usług, dla których podatnikiem jest nabywca zgodnie z art. 17 ust. 1 pkt 7 lub 8 (wypełnia nabywca)",{"$f":"+ROUND('JPK-Sprzedaż'!AJ5,)","v":0},{"$f":"+ROUND('JPK-Sprzedaż'!AK5,)","v":0}]
["16. Kwota podatku należnego od towarów i usług objętych spisem z natury, o których mowa w art. 14 ust. 5",null,{"$f":"+ROUND('JPK-Sprzedaż'!AL5,)","v":0}]
["17. Zwrot odliczonej lub zwróconej kwoty wydatkowanej na zakup kas rejestrujących, o których mowa w art.. 111 ust. 6",null,{"$f":"+ROUND('JPK-Sprzedaż'!#REF!,)","v":{"$error":"#REF!"}}]
["18. Kwota podatku należnego od wewnątrzwspólnotowego nabycia środków transportu, wykazanego w poz. 24, podlegająca wpłacie w terminie, o którym mowa w art. 103 ust. 3, w związku z ust. 4",null,{"$f":"+ROUND('JPK-Sprzedaż'!#REF!,)","v":{"$error":"#REF!"}}]
["19. Kwota podatku od wewnątrzwspólnotowego nabycia paliw silnikowych, podlegająca wpłacie w terminach, o których mowa w art. 103 ust. 5a i 5b",null,{"$f":"+ROUND('JPK-Sprzedaż'!AM5,)","v":0}]
[]
[]
[null,{"$f":"+B3+B4+B6+B8+B9+B10+B11+B12+B13+B14+B15+B16+B17+B18+B19","v":1007979},{"$f":"+C8+C9+C10+C13+C14+C15+C16+C18+C19+C20-C21-C22-C23","v":{"$error":"#REF!"}}]
[]
[]
["ROZLICZENIE PODATKU NALICZONEGO"]
[]
["1. PRZENIESIENIA",null,"Podatek do odliczenia w zł"]
["Kwota nadwyżki z poprzedniej deklaracji"]
[]
[]
["2. NABYCIE TOWARÓW I USŁUG ORAZ PODATEK NALICZONY Z UWZGLĘDNIENIEM KOREKT"]
[]
[null,"Wartość netto w zł","Podatek naliczony w zł"]
["Nabycie towarów i usług zaliczanych u podatnika do środków trwałych",{"$f":"+ROUND('JPK-Zakup'!L5,)","v":0},{"$f":"+ROUND('JPK-Zakup'!M5,)","v":0}]
["Nabycie towarów i usług pozostałych",{"$f":"+ROUND('JPK-Zakup'!N5,)","v":479216},{"$f":"+ROUND('JPK-Zakup'!O5,)","v":109012}]
[]
["3. PODATEK NALICZONY - DO ODLICZENIA W ZŁ"]
["Korekta podatku naliczonego od nabycia środków trwałych",null,{"$f":"+ROUND('JPK-Zakup'!P5,)","v":0}]
["Korekta podatku naliczonego od pozostałych nabyć",null,{"$f":"+ROUND('JPK-Zakup'!Q5,)","v":0}]
["Korekta podatku naliczonego, o której mowa w art. 89b ust. 1 ustawy",null,{"$f":"+ROUND('JPK-Zakup'!R5,)","v":0}]
["Razem kwota podatku naliczonego do odliczenia",null,{"$f":"+C32+C38+C39+C42+C43+C44","v":109012}]
[]
[]
["OBLICZENIE WYSOKOŚCI ZOBOWIĄZANIA PODATKOWEGO LUB KWOTY DO ZWROTU (w zł)"]
["Kwota wydatkowana na zakup kas rejestrujących"]
["Kwota podatku objęta zaniechaniem poboru"]
["Kwota podatku podlegającego wpłacie do Urzędu Skarbowego",null,{"$f":"IF(C26>C45,C26-C45-C49-C50,0)","v":{"$error":"#REF!"}}]
["Kwota wydatkowana na zakup kas rejestrujących, przysługująca do zwrotu w danym okresie rozliczeniowym"]
["Nadwyżka podatku naliczonego nad należnym",null,{"$f":"IF(C45-C26>=0,C45-C26+C52,0)","v":{"$error":"#REF!"}}]

{"sheet":"Parametry","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rozszerzenie pliku importu:"]
[]
[]
[null,"Arkusz","Komponent obsługujący import"]
[null,"JPK-Sprzedaż","brak"]
[null,"JPK-Zakup","brak"]
[]
[]
[null,"Sprawdzanie merytoryczne","tak"]

{"sheet":"techniczne","index":6,"n_rows":117,"n_cols":20,"rows_kept":117,"cut":false,"hidden":true,"merged":[[84,2,84,5],[86,0,86,1],[89,0,89,1],[107,14,107,15],[108,14,108,15],[96,14,96,15],[101,14,101,15],[96,16,96,17],[97,14,97,15],[97,16,97,17],[105,14,105,15],[106,14,106,15],[101,16,101,17],[99,14,99,15],[99,16,99,17],[98,14,98,15],[98,16,98,17],[100,14,100,15],[100,16,100,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,"SprzedazWiersz","LpSprzedazy",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZakupWiersz","LpZakupu",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XED","#4538"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSD:","http://crd.gov.pl/wzor/2021/12/27/11148/schemat.xsd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namespace:","http://crd.gov.pl/wzor/2021/12/27/11148/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AlternateImports","http://crd.gov.pl/wzor/2021/07/08/07081/;http://crd.gov.pl/wzor/2020/05/08/9393/;http://crd.gov.pl/wzor/2020/03/06/9196/;http://jpk.mf.gov.pl/wzor/2019/11/06/11061/;http://crd.gov.pl/wzor/2020/02/25/9142/;http://jpk.mf.gov.pl/wzor/2016/10/26/10261/;http://jpk.mf.gov.pl/wzor/2017/11/13/1113/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroToEmpty",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroFollowsFields:","K_16,K_18,K_20,K_24,K_26,K_28,K_30,K_33,K_35,K_41,K_43,P_16,P_18,P_20,P_24,P_26,P_28,P_30,P_32,P_34,P_36,P_38,P_41,P_43,P_54"]
[]
[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_VAT",{"$f":"\"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_V7M'. Może próbujesz wczytać starszą wersję pliku JPK_VAT? Ten stary format zawiera inne pola, i taka operacja jest niemożliwa\"","v":"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_V7M'. Może próbujesz wczytać starszą wersję pliku JPK_VAT? Ten stary format zawiera inne pola, i taka operacja jest niemożliwa"}]
[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:Rok",{"$f":"Rok","v":2024},{"$f":"\"Plik dotyczy innego roku ({Val}) niż aktualnie wczytane dane (\" &S17 & \")\"","v":"Plik dotyczy innego roku ({Val}) niż aktualnie wczytane dane (2024)"}]
[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:Miesiac",{"$f":"Miesiac","v":7},{"$f":"\"Plik dotyczy innego miesiąca ({Val}) niż aktualnie wczytane dane (\" &S18 & \")\"","v":"Plik dotyczy innego miesiąca ({Val}) niż aktualnie wczytane dane (7)"}]
[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},"//*[local-name()='NIP']",{"$f":"NIP","v":"7011174664"},{"$f":"\"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: \" &S19 & \")\"","v":"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: 7011174664)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"//jpk:ZakupCtrl","exists","Wskazany plik najprawdopodobniej zawiera korektę samej deklaracji.\nNiestety, z powodu ograniczeń technicznych ten skoroszyt nie wyświetli poprawnie zawartości takiej cząstkowej korekty. \nDlatego jako podstawę do tworzenia kolejnych korekt samych deklaracji sugerujemy wykorzystywać kompletne pliki JPK_V7, zawierające także część ewidencyjną. (Może to być np. pierwsza wersja JPK_V7 za ten miesiąc)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa skoroszytu:",null,"JPK_V7M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer seryjny:",null,"dw.rhenus.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer edycji:",null,1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wygenerowano:",null,"2024-04-11T19:43:23"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komunikaty w oknach dialogowych",null,"00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pola list wybieralnych:"]
[null,null,1,"Osoba fizyczna"]
[null,null,2,"Podatnik niebędący osobą fizyczną"]
[]
[null,null,1,"złożenie po raz pierwszy"]
[null,null,2,"korekta ewidencji i deklaracji"]
[null,null,3,"korekta samej ewidencji"]
[null,null,4,"korekta samej deklaracji"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Arkusze transformacji:"]
[]
["XsltInput:",null,"(tworzy pasujące do list pola <TypDokumentu> i <TypKontrahenta>)"]
[null,null,"<xsl:stylesheet version=\"1.0\"\n  xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"\n    xmlns:jpk=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"\n    xmlns:vat3=\"http://jpk.mf.gov.pl/wzor/2017/11/13/1113/\"\n>\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n    <!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n    <!-- Zamiana \"CelZozenia\" na precyzyjniejszy \"TypDokumentu\" i dodatkowy \"TypPodatnika\" (spoza schematu, dla list wuboru z Excela) : -->\n\t<xsl:template match=\"jpk:CelZlozenia\">\n\t\t<RodzajDokumentu>\n\t\t\t<xsl:choose>\n\t\t\t\t<xsl:when test=\"//jpk:CelZlozenia = 1\">1</xsl:when> <!--  złożenie po raz pierwszy -->\n\t\t\t\t<xsl:otherwise>\n\t\t\t\t\t<xsl:choose>\n\t\t\t\t\t\t<xsl:when test=\"not (//jpk:Deklaracja)\">3</xsl:when> <!-- korekta samej ewidencji  -->\n\t\t\t\t\t\t<xsl:when test=\"not (//jpk:SprzedazWiersz or //ZakupWiersz)\">4</xsl:when> <!-- korekta samej deklaracji  -->\n\t\t\t\t\t\t<xsl:otherwise>2</xsl:otherwise> <!-- korekta ewidencji i deklaracji -->\n\t\t\t\t\t</xsl:choose>\n\t\t\t\t</xsl:otherwise>\n\t\t\t</xsl:choose>\t\t\n\t\t</RodzajDokumentu>\n\t\t<TypPodatnika>\n\t\t\t<xsl:choose>\n\t\t\t\t<xsl:when test=\"//jpk:OsobaFizyczna\">1</xsl:when>\n\t\t\t\t<xsl:otherwise>2</xsl:otherwise>\n\t\t\t</xsl:choose>\n\t\t</TypPodatnika>\n\t</xsl:template>\n\t<!-- przesunięcie kolumn pomiędzy JPK_VAT i JPK_V7 -->\n\t<xsl:template match=\"vat3:DataOd\">\n\t\t<Rok><xsl:value-of select=\"substring(.,1,4)\"></xsl:value-of></Rok>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:DataDo\">\n\t\t<Miesiac><xsl:value-of select=\"substring(.,6,2)\"></xsl:value-of></Miesiac>\n\t</xsl:template>\t\t\t\n\t<xsl:template match=\"vat3:K_31\"/>\t\n\t<xsl:template match=\"vat3:K_32\">\n\t\t<K_31><xsl:value-of select=\".\"></xsl:value-of></K_31>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_33\">\n\t\t<K_32><xsl:value-of select=\".\"></xsl:value-of></K_32>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_34\"/>\t\n\t<xsl:template match=\"vat3:K_35\"/>\t\n\t<xsl:template match=\"vat3:K_36\">\n\t\t<K_33><xsl:value-of select=\".\"></xsl:value-of></K_33>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_37\">\n\t\t<K_34><xsl:value-of select=\".\"></xsl:value-of></K_34>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_38\">\n\t\t<K_35><xsl:value-of select=\".\"></xsl:value-of></K_35>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_39\">\n\t\t<K_36><xsl:value-of select=\".\"></xsl:value-of></K_36>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_43\">\n\t\t<K_40><xsl:value-of select=\".\"></xsl:value-of></K_40>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_44\">\n\t\t<K_41><xsl:value-of select=\".\"></xsl:value-of></K_41>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_45\">\n\t\t<K_42><xsl:value-of select=\".\"></xsl:value-of></K_42>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_46\">\n\t\t<K_43><xsl:value-of select=\".\"></xsl:value-of></K_43>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_47\">\n\t\t<K_44><xsl:value-of select=\".\"></xsl:value-of></K_44>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_48\">\n\t\t<K_45><xsl:value-of select=\".\"></xsl:value-of></K_45>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_49\">\n\t\t<K_46><xsl:value-of select=\".\"></xsl:value-of></K_46>\n\t</xsl:template>\t\n\t<xsl:template match=\"vat3:K_50\">\n\t\t<K_47><xsl:value-of select=\".\"></xsl:value-of></K_47>\n\t</xsl:template>\t\n</xsl:stylesheet>"]
[]
["XsltOutput:",null,"(usuwa w korektach część deklaracyjną lub ewidencyjną, gdy jest to potrzebne)"]
[null,null,{"$f":"IF(RodzajDokumentu<3,\"\",IF(RodzajDokumentu=3,D92,D93))","v":""}]
[null,null,"p. 3:","<xsl:stylesheet version=\"1.0\"\n    xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"\n    xmlns:jpk=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"  >\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n<!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n<!-- Usuwamy część deklaracyjną: -->\n\t<xsl:template match=\"jpk:Deklaracja\"/>\n</xsl:stylesheet>"]
[null,null,"p. 4:","<xsl:stylesheet version=\"1.0\"\n    xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"\n    xmlns:jpk=\"http://crd.gov.pl/wzor/2021/12/27/11148/\"  >\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n<!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n<!-- Usuwamy część ewidencyjną: -->\n\t<xsl:template match=\"jpk:Ewidencja\"/> \n</xsl:stylesheet>"]
[]
[]
[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,"UrzedySkarbowe",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2021/06/08/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyKrajow",null,{"$f":"Q98","v":"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2021/06/08/eD/DefinicjeTypy/"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ElementarneTypyDanych",null,{"$f":"Q99","v":"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2021/06/08/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/2021/06/08/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JPK",null,{"$f":"JPK_Namespace","v":"http://crd.gov.pl/wzor/2021/12/27/11148/"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weryfikacja merytoryczna niektórych pól:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwy pól (kolumn)",null,"Typ testu","Pytanie, czy wyświetlić znalezione nieprawidłowości",null,"Wyjaśnienie, towarzyszące wyświetleniu nieprawidłowości"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NrKontrahenta",null,"NIP","Sprawdzanie nr NIP klientów: znaleziono {Count} nieprawidłowości. Czy chcesz je teraz przejrzeć?\n\n(Jeżeli chcesz je zignorować i kontynuować zapis do pliku JPK, wybierz [Nie])\n",null,"Wiersze, które mogą zawierać błędny NIP zostały wyróżnione znakiem \"X\" w kolumnie \"Błąd\" (możesz je szybko wybrać za pomoca funkcji Filtruj). \n\nSprawdź te numery NIP (zwróć uwagę, że mogą się powtarzać dla kolejnych faktur tego samego kontrahenta). \nNumery NIP polskich przedsiębiorstw muszą się składać z 10 cyfr (np. 5251469286), BEZ  spacji czy kresek. Dla polskich NIP dopuszczalny jest przedrostek \"PL\"\nW przypadku detalistów/pracowników należy wpisywać w to pole słowo \"brak\".\n\nGdy skończysz je przeglądać/poprawiać, kliknij powtórnie w przycisk [Zapisz jako plik JPK]."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K_16,K_18,K_20,K_24,K_26,K_28,K_30,K_32,K_33,K_35,K_36",null,"Zaokrąglenia","W jednej z kolumn znaleziono {Count} pól z ułamkami groszy. Te ułamki zmieniły kwotę podatku. Czy chcesz je teraz poprawić?\n\n(Jeżeli chcesz zignorować tę nieprawidłowość i kontynuować zapis do pliku JPK, wybierz [Nie])\n",null,"Wiersze, których pola zawierają ułamki groszy zostały wyróżnione znakiem \"X\" w kolumnie \"Błąd\" (możesz je szybko wybrać za pomoca funkcji Filtruj). \nKwoty w tych polach są wyświetlane z dokładnością co do grosza, ale gdy zjarzysz do ich formuł, przekonasz się że zawierają więcej miejsc po przecinku.\n \nWpisanie drobnego ułamka (0.0001) jest czasami przydatne do odnotowania w pliku JPK zerowych kwot VAT. Jednak w tym przypadku te ułamki sumują się w kwotę większą od 0.5 grosza, i powodują nieprawidłowe naliczenie sumy kontrolnej w pliku JPK. \nDlatego lepiej teraz popraw te liczby, zaokrąglając je odpowiednio do pełnych groszy.\n\nGdy skończysz nanosić te poprawki, kliknij powtórnie w przycisk [Zapisz jako plik JPK]."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NrDostawcy",null,"NIP","Sprawdzanie nr NIP dostawców: znaleziono {Count} nieprawidłowości. Czy chcesz je teraz przejrzeć?\n\n(Jeżeli chcesz je zignorować i kontynuować zapis do pliku JPK, wybierz [Nie])\n",null,"Wiersze, które mogą zawierać błędny NIP zostały wyróżnione znakiem \"X\" w kolumnie \"Błąd\" (możesz je szybko wybrać za pomoca funkcji Filtruj). \n\nSprawdź te numery NIP (zwróć uwagę, że mogą się powtarzać dla kolejnych faktur tego samego kontrahenta). \nNumery NIP polskich przedsiębiorstw muszą się składać z 10 cyfr (np. 5251469286), BEZ przedrostka \"PL\" i kresek.\nW przypadku gdy kontrahent nie ma żadnego numeru (np. dla specjalnych zapisów technicznych) należy wpisywać w to pole słowo \"brak\".\n\nGdy skończysz je przeglądać/poprawiać, kliknij powtórnie w przycisk [Zapisz jako plik JPK]."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K_41,K_43,K_44,K_45,K_46,K_47",null,"Zaokrąglenia","W jednej z kolumn znaleziono {Count} pól z ułamkami groszy. Te ułamki zmieniły kwotę podatku. Czy chcesz je teraz poprawić?\n\n(Jeżeli chcesz zignorować tę nieprawidłowość i kontynuować zapis do pliku JPK, wybierz [Nie])\n",null,"Wiersze, których pola zawierają ułamki groszy zostały wyróżnione znakiem \"X\" w kolumnie \"Błąd\" (możesz je szybko wybrać za pomoca funkcji Filtruj). \nKwoty w tych polach są wyświetlane z dokładnością co do grosza, ale gdy zjarzysz do ich formuł, przekonasz się że zawierają więcej miejsc po przecinku.\n \nWpisanie drobnego ułamka (0.0001) jest czasami przydatne do odnotowania w pliku JPK zerowych kwot VAT. Jednak w tym przypadku te ułamki sumują się w kwotę większą od 0.5 grosza, i powodują nieprawidłowe naliczenie sumy kontrolnej w pliku JPK. \nDlatego lepiej teraz popraw te liczby, zaokrąglając je odpowiednio do pełnych groszy.\n\nGdy skończysz nanosić te poprawki, kliknij powtórnie w przycisk [Zapisz jako plik JPK]."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pola do podmiamy we wzorcu dokumentu:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OsobaFizyczna:","\t\t<OsobaFizyczna>\n\t\t\t<etd:NIP></etd:NIP>\n\t\t\t<etd:ImiePierwsze></etd:ImiePierwsze>\n\t\t\t<etd:Nazwisko></etd:Nazwisko>\n\t\t\t<etd:DataUrodzenia></etd:DataUrodzenia>\n\t\t\t<Email></Email>\n\t\t\t<Telefon></Telefon>\n\t\t\t<PelnaNazwa/>\n\t\t</OsobaFizyczna>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OsobaFizyczna:","\t\t<OsobaNiefizyczna>\n\t\t\t<NIP></NIP>\n\t\t\t<PelnaNazwa></PelnaNazwa>\n\t\t\t<Email></Email>\n\t\t\t<Telefon></Telefon>\n\t\t\t<etd:ImiePierwsze/>\n\t\t\t<etd:Nazwisko/>\n\t\t\t<etd:DataUrodzenia/>\n\t\t</OsobaNiefizyczna>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DanePodatnika:",{"$f":"IF(TypPodatnika=1,techniczne!R115,techniczne!R116)","v":"\t\t<OsobaNiefizyczna>\n\t\t\t<NIP></NIP>\n\t\t\t<PelnaNazwa></PelnaNazwa>\n\t\t\t<Email></Email>\n\t\t\t<Telefon></Telefon>\n\t\t\t<etd:ImiePierwsze/>\n\t\t\t<etd:Nazwisko/>\n\t\t\t<etd:DataUrodzenia/>\n\t\t</OsobaNiefizyczna>"}]