{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Лист1","index":0,"n_rows":104,"n_cols":22,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,9,0,16],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,9,1,10],[1,12,1,13],[1,15,1,16],[1,18,2,18],[1,20,1,21]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"6 НДФЛ"]
[null,null,"период начисления","Дата выплаты","вид выплаты","Ведомость",null,null,null,"должно быть",null,null,"Раздел 1",null,null,"Раздел 2",null,null,"справочно ИТОГО 140",null,"Оплата НДФЛ"]
[{"$nulls":5},"на руки","НДФЛ","всего",null,"всего","НДФЛ",null,"020","040",null,"130","140",null,"справочно ИТОГО 140",null,"дата","сумма"]
[2019]
[null,null,"12.2019","2020-01-10","ЗП 12",48899,7307,56206,{"$nulls":9},"V"]
[]
[null,null,"12.2019","2020-01-10","Гпх 12",16002,2390,18392,{"$nulls":7},74598,9697,"v",null,null,"2020-01-13",9569.73]
["2020 1 кв",{"$nulls":19},"2020-01-17",127.27]
[null,null,"01.2020","2020-01-30","Гпх 01",17150,2563,19713,{"$nulls":7},19713,2563,"v",null,null,"2020-01-31",2563]
[]
[null,null,"02.2020","2020-02-06","Отп 02",6895.52,1031,7926.52,{"$nulls":7},7926.52,1031,"v"]
[]
[null,null,"01.2020","2020-02-06","Зп 02",64900,9698,74598,{"$nulls":7},74598,9698,"v",null,null,"2020-02-07",10729]
[]
[null,null,"02.2020","2020-03-05","Зп 02",64902,9696,74598,{"$nulls":7},74598,9696,"V"]
[{"$nulls":4},"Гпх 02",12350,1845,14195,{"$nulls":7},14195,1845,"V",null,null,"2020-03-06",15261]
[]
[null,null,"03.2020","2020-03-05","Отп 03",24894.88,3720,28614.88,{"$nulls":7},28614.88,3720,"V",null,null,"2020-03-31",2077]
[]
[null,null,"03.2020","2020-03-30","Гпх 03",13900,2077,15977]
[]
[null,"1 кв 6НДФЛ",{"$nulls":7},310220.4,40327,null,null,40327,"V",294243.4,38250,null,38250,null,null,40327]
[]
[null,null,"03.2020","2020-04-06","Зп 03",64899,9699,74598,{"$nulls":7},74598,9699,"V",null,null,"2020-04-06",9699]
[]
[null,"Свод 1 кв",null,null,null,269891.4,40329,310220.4,"V"]
[]
[{"$nulls":15},15977,2077,"V"]
[]
["2020 2 кв",null,"04.2020","2020-04-30","Гпх 04",11250,1681,12931,{"$nulls":7},12931,1681,"V",null,null,"2020-04-29",1681]
[]
[null,null,"04.2020","2020-05-07","Зп 04",57161.65,8541,65702.65,{"$nulls":7},65702.65,8541,"V",null,null,"2020-05-08",8541]
[]
[null,null,"05.2020","2020-05-28","Гпх 05",14210,2124,16334,{"$nulls":7},16334,2124,"V",null,null,"2020-05-29",2124]
[]
[null,null,"05.2020","2020-06-08","Зп 05",60605.95,9056,69661.95,{"$nulls":7},69661.95,9056,"V",null,null,"2020-06-09",9056]
[]
[null,null,"06.2020","2020-06-29","Увол 06",4026.6,601,4627.6,{"$nulls":9},"V",null,null,"2020-06-30",2818]
[]
[null,null,"06.2020","2020-06-29","Гпх 06",14840,2217,17057,{"$nulls":7},21684.6,2818,"V"]
[]
[null,"2 кв 6 НДФЛ",{"$nulls":7},571132.6,74246,null,null,74246,"V",276889.19999999995,35996,null,35996,null,null,33919]
[{"$nulls":21},74246]
[null,null,"06.2020","2020-07-03","Зп 06",41018.83,6130,47148.83]
[]
[null,"Свод 2 кв",null,null,null,473004.43,70679,543683.4299999999,"V"]
[]
[{"$nulls":15},11773.5,1531]
[{"$nulls":15},35575.33,4599,"V",null,null,"2020-07-07",6130]
[]
["2020 3 кв",null,"07.2020","2020-07-30","Гпх 07",27720,4143,31863]
[]
[null,null,"08.2020","2020-07-30","Отп 08",13454.68,2010,15464.68,{"$nulls":7},47327.68,6153,null,null,null,"2020-07-31",4143]
[]
[null,null,"07.2020","2020-08-06","Зп 07",52401.5,7829,60230.5,{"$nulls":7},60230.5,7829,null,null,null,"2020-08-07",9839]
[]
[null,null,"08.2020","2020-08-27","Гпх 08",29050,4340,33390,{"$nulls":7},33390,4340,null,null,null,"2020-08-28",4340]
[]
[null,null,"08.2020","2020-09-07","Зп 08",57548.82,8599,66147.82,{"$nulls":7},13682.85,1779]
[{"$nulls":15},46547.65,6051]
[{"$nulls":15},5917.32,769,null,null,null,"2020-09-08",8599]
[]
[null,null,"09.2020","2020-09-29","Гпх 09",37660,5628,43288,{"$nulls":7},43228,5628,null,null,null,"2020-09-30",5628]
[]
[null,"3 кв 6НДФЛ"]
[]
[null,null,"09.2020","2020-10-05","Зп 09",64900,9698,74598]
[]
[null,"Свод 3 кв",null,null,null,755739.4299999999,112926,868665.4299999999,"V",null,null,null,868665.43,112926,null,297672.83,38679,null,38679,null,null,38679]
[{"$nulls":7},0,{"$nulls":10},112925,null,null,112925]
[{"$nulls":7},0]
[null,null,"10.2020","2020-10-08","Отп 10",10069.36,1505,11574.36,{"$nulls":7},74598,9698]
[null,null,null,"2020-10-29","Гпх 10",32100,4796,36896,{"$nulls":7},11574.36,1505]
[null,null,null,"2020-11-05","Зп 10",65761.72,9829,75590.72,{"$nulls":7},36896,4796]
[{"$nulls":7},0]
[{"$nulls":7},0]
[null,null,"11.2020","2020-11-30","ГПХ 11",15700,2346,18046,{"$nulls":7},11912.72,1549]
[null,null,null,"2020-12-03","Зп 11",49441.15,7387,56828.15,{"$nulls":7},62685.28,8151]
[{"$nulls":7},0,{"$nulls":7},992.72,129]
[null,null,"12.2020","2020-12-29","Гпх 12",15400,2302,17702]
[{"$nulls":7},0,{"$nulls":7},18046,2346]
[null,"4 кв 6НДФЛ",{"$nulls":5},0,{"$nulls":7},56828.15,7387]
[{"$nulls":7},0,{"$nulls":7},17702,2302]
[null,null,"12.2020","2021-01-11","Зп 12",52401.5,7829,60230.5]
[{"$nulls":7},0]
[null,"Свод 4 кв",null,null,null,996613.1599999999,148920,1145533.16,{"$nulls":4},1145533.16,148920,null,291235.23,37863,null,37863]
[{"$nulls":7},0,{"$nulls":4},0,0,{"$nulls":4},150788,"= 1 раздел 070"]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]