{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":129,"n_cols":38,"rows_kept":129,"cut":false,"hidden":false,"merged":[[106,9,106,10],[106,11,106,12],[0,30,0,37],[4,30,5,30],[4,31,5,31],[4,32,4,33],[4,34,4,35],[4,36,4,37],[1,30,1,37],[118,9,118,12],[118,14,118,17],[119,9,119,10],[119,11,119,12],[119,14,119,15],[119,16,119,17],[106,14,106,15],[106,16,106,17],[106,19,106,20],[106,21,106,22],[94,24,94,25],[94,26,94,27],[106,24,106,25],[106,26,106,27],[105,9,105,12],[105,14,105,17],[105,19,105,22],[105,24,105,27],[94,9,94,10],[94,11,94,12],[94,14,94,15],[94,16,94,17],[94,19,94,20],[94,21,94,22],[81,24,81,25],[81,26,81,27],[93,9,93,12],[93,14,93,17],[93,19,93,22],[93,24,93,27],[81,9,81,10],[81,11,81,12],[81,14,81,15],[81,16,81,17],[81,19,81,20],[81,21,81,22],[68,24,68,25],[68,26,68,27],[80,9,80,12],[80,14,80,17],[80,19,80,22],[80,24,80,27],[68,9,68,10],[68,11,68,12],[68,14,68,15],[68,16,68,17],[68,19,68,20],[68,21,68,22],[55,24,55,25],[55,26,55,27],[67,9,67,12],[67,14,67,17],[67,19,67,22],[67,24,67,27],[55,9,55,10],[55,11,55,12],[55,14,55,15],[55,16,55,17],[55,19,55,20],[55,21,55,22],[41,24,41,25],[41,26,41,27],[54,9,54,12],[54,14,54,17],[54,19,54,22],[54,24,54,27],[41,9,41,10],[41,11,41,12],[41,14,41,15],[41,16,41,17],[41,19,41,20],[41,21,41,22],[28,24,28,25],[28,26,28,27],[40,9,40,12],[40,14,40,17],[40,19,40,22],[40,24,40,27],[28,9,28,10],[28,11,28,12],[28,14,28,15],[28,16,28,17],[28,19,28,20],[28,21,28,22],[13,24,13,25],[13,26,13,27],[27,9,27,12],[27,14,27,17],[27,19,27,22],[27,24,27,27],[13,9,13,10],[13,11,13,12],[13,14,13,15],[13,16,13,17],[13,19,13,20],[13,21,13,22],[2,24,2,25],[2,26,2,27],[12,9,12,12],[12,14,12,17],[12,19,12,22],[12,24,12,27],[1,9,1,12],[1,14,1,17],[1,19,1,22],[1,24,1,27],[2,9,2,10],[2,11,2,12],[2,14,2,15],[2,16,2,17],[2,19,2,20],[2,21,2,22],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[2,1,2,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[15,1,15,3],[3,1,3,3],[6,1,6,3],[8,1,8,3],[9,1,9,3],[16,1,16,3],[12,1,12,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[14,1,14,3],[0,0,0,5],[1,0,1,6],[4,1,4,3],[5,1,5,3],[7,1,7,3]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":29},"Оборотно-сальдовая ведомость"]
[{"$nulls":9},"Счет 01",{"$nulls":4},"Счет 02",{"$nulls":4},"Счет 08",{"$nulls":4},"Счет 05",{"$nulls":5},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Получены материалы от поставщика",null,null,10000,"Дт 10","Кт 60",null,null,"С-до",100000,{"$nulls":5},"С-до",30000,null,"С-до",{"$nulls":5},0,"С-до"]
[2,"Получены денежные средства для выплаты зарплаты",null,null,40000,"Дт 50","Кт 51",{"$nulls":23},"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[3,"Выдана заработная плата",null,null,40000,"Дт 70","Кт 50",{"$nulls":25},"Дт","Кт","Дт","Кт","Дт","Кт"]
[4,"Переданы материалы в производство",null,null,8000,"Дт 20","Кт 10",{"$nulls":23},"Сч 01","Основные средства",100000,null,null,null,100000]
[5,"Начислена заработная плата работникам предприятия",null,null,50000,"Дт 20","Кт 70",{"$nulls":23},"Сч 02","Амортизация ОС",null,30000,null,null,null,30000]
[6,"Удержан подоходний налог",null,null,10000,"Дт 70 ","Кт 68",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,null,"Сч 04","Нематериальные активы"]
[7,"Перечислено с расчетного счета погашение задолж постав",null,null,14000,"Дт 60","Кт 51",null,null,"С-до ",100000,"С-до ",null,null,"С-до ",null,"С-до",30000,null,"С-до ",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 05","Амортизация НМА"]
[8,"Передана на склад готовая продукция",null,null,6000,"Дт 43","Кт 20",{"$nulls":23},"Сч 08","Вложения во внеоб.акт"]
[9,"Списана на реализацию факт себестоимость продукции",null,null,24000,"Дт 90","Кт 43",{"$nulls":23},"Сч 10","Материалы",20000,null,26000,8000,38000]
[10,"Принят к оплате счет поставщика за материалы",null,null,16000,"Дт 10","Кт 60",null,null,"Счет 10",{"$nulls":4},"Счет 19",{"$nulls":4},"Счет 20",{"$nulls":4},"Счет 25",{"$nulls":5},"Сч 19","НДС по приобретенным МПЗ"]
[11,"Возвращен краткосрочный кредит банка",null,null,20000,"Дт 66","Кт 51",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 20","Основное производство",12000,null,58000,6000,64000]
[12,"Реализована продукция",null,null,35000,"Дт 62","Кт 90",null,null,"С-до",20000,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",12000,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 23","Вспомогательное производство"]
[13,"Начислен НДС",null,null,7000,"Дт 90","Кт 68",null,null,"Кт 60",10000,"Дт 20",8000,{"$nulls":6},"Кт 10",8000,"Дт 43",6000,{"$nulls":7},"Сч 25","Общепроизводственные расходы"]
[14,"Определен фин результат",null,null,4000,"Дт 90","Кт 99",null,null,"Кт 60",16000,{"$nulls":8},"Кт 70",50000,{"$nulls":9},"Сч 26","Общехозяйственные расходы"]
[{"$nulls":30},"Сч 41","Товары на складах"]
[{"$nulls":30},"Сч 43","Готовая продукция",28000,null,6000,24000,10000]
[{"$nulls":30},"Сч 50","Касс",2000,null,40000,40000,2000]
[{"$nulls":30},"Сч 51","Расчетный счет",80000,null,null,74000,6000]
[{"$nulls":30},"Сч 58","Финансовые вложения"]
[{"$nulls":30},"Сч 60","Расчеты с поставщиками и подрядчиками",null,34000,14000,26000,null,46000]
[{"$nulls":9},"Оборот",26000,"Оборот",8000,null,"Оборот",0,"Оборот",0,null,"Оборот",58000,"Оборот",6000,null,"Оборот",0,"Оборот",0,null,null,"Сч 62","Расчеты с покупателями и заказчиками",null,null,35000,null,35000]
[{"$nulls":9},"С-до",38000,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до ",64000,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч 66","Расчеты по кредитам и займам",null,20000,20000]
[{"$nulls":30},"Сч 68","Расчеты по налогам и сборам",null,null,null,17000,null,17000]
[{"$nulls":30},"Сч 69","Расчеты по социальному страхованию "]
[{"$nulls":9},"Счет 26",{"$nulls":4},"Счет 41",{"$nulls":4},"Счет 43",{"$nulls":4},"Счет 44",{"$nulls":5},"Сч 70","Расчеты с персоналом по оплате труда",null,40000,50000,50000,null,40000]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 71","Расчеты с подотчетными лицами"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",28000,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 73","Расчеты с персоналом по прочим опер"]
[{"$nulls":19},"Кт 20",6000,"Дт 90",24000,{"$nulls":7},"Сч 75","Расчеты с учредителями"]
[{"$nulls":30},"Сч 76","Расчеты с разными дебиторами и кредит."]
[{"$nulls":30},"Сч 80","Уставной капитал",null,60000,null,null,null,60000]
[{"$nulls":30},"Сч 82","Резервный капитал",null,58000,null,null,null,58000]
[{"$nulls":30},"Сч 83","Добавочный капитал"]
[{"$nulls":30},"сч 84","Нераспределенная прибыль (убыток)"]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",6000,"Оборот",24000,null,"Оборот",0,"Оборот",0,null,null,"Сч 86","Целевое финансирование"]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",10000,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч 90","Продажи",null,null,35000,35000]
[{"$nulls":30},"Сч 96","Резервы предстоящих расходов"]
[{"$nulls":30},"Сч 97","Расходы будующих периодов"]
[{"$nulls":9},"Счет 50",{"$nulls":4},"Счет 51",{"$nulls":4},"Счет 52",{"$nulls":4},"Счет 60",{"$nulls":5},"Сч 98","Доходы будущих периодов"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 99","Прибыли и убытки (финансовый результ)",null,null,null,4000,null,4000]
[{"$nulls":9},"С-до",2000,"С-до",null,null,"С-до",80000,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",34000]
[{"$nulls":9},"Кт 51",40000,"Дт 70",40000,null,null,null,"Дт 50",40000,{"$nulls":6},"Кт 51",14000,"Дт 10",10000,null,null,null,"Итого",242000,242000,284000,284000,255000,255000]
[{"$nulls":16},"Дт 60",14000,{"$nulls":8},"Дт 10",16000]
[{"$nulls":16},"Дт 66",20000]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",40000,"Оборот",40000,null,"Оборот",0,"Оборот",74000,null,"Оборот",0,"Оборот",0,null,"Оборот",14000,"Оборот",26000]
[{"$nulls":9},"С-до ",2000,"С-до ",null,null,"С-до ",6000,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",46000]
[]
[]
[{"$nulls":9},"Счет 62",{"$nulls":4},"Счет 66",{"$nulls":4},"Счет 68.1",{"$nulls":4},"Счет 68.10"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",20000,null,"С-до",null,"С-до",null,null,"С-до"]
[{"$nulls":9},"Кт 90",35000,null,null,null,"Кт 51",20000,{"$nulls":5},"Дт 70",10000]
[{"$nulls":21},"Дт 90",7000]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",35000,"Оборот",0,null,"Оборот",20000,"Оборот",0,null,"Оборот",0,"Оборот",17000,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",35000,"С-до ",null,null,"С-до ",0,"С-до ",0,null,"С-до ",null,"С-до ",17000,null,"С-до ",null,"С-до "]
[]
[]
[{"$nulls":9},"Счет 69.1",{"$nulls":4},"Счет 69.1.1",{"$nulls":4},"Счет 69.2.2",{"$nulls":4},"Счет 69.1"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до "]
[]
[]
[{"$nulls":9},"Счет 70",{"$nulls":4},"Счет 71",{"$nulls":4},"Счет 73",{"$nulls":4},"Счет 75"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",40000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":9},"Кт 50",40000,"Дт 20",50000]
[{"$nulls":9},"Кт 68",10000]
[]
[]
[]
[{"$nulls":24},"Оборот",0,"Оборот",0]
[{"$nulls":9},"Оборот",50000,"Оборот",50000,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"С-до",null,"С-до"]
[{"$nulls":9},"С-до",0,"С-до",40000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[]
[]
[{"$nulls":9},"Счет 76",{"$nulls":4},"Счет 80",{"$nulls":4},"Счет 82",{"$nulls":4},"Счет 83"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",60000,null,"С-до",null,"С-до",58000,null,"С-до",null,"С-до"]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",60000,null,"С-до",null,"С-до",58000,null,"С-до",null,"С-до"]
[]
[]
[{"$nulls":9},"Счет 84",{"$nulls":4},"Счет 86",{"$nulls":4},"Счет 90",{"$nulls":4},"Счет 91"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":19},"Кт 68",7000,"Дт 62",35000]
[{"$nulls":19},"Кт 43",24000]
[{"$nulls":19},"Кт 99",4000]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",35000,"Оборот",35000,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",0,"С-до",0,null,"С-до",null,"С-до"]
[]
[]
[{"$nulls":9},"Счет 99"]
[{"$nulls":9},"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до"]
[{"$nulls":11},"Дт 90",4000]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",4000]
[{"$nulls":9},"С-до",null,"С-до",4000]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}