{"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":80,"n_cols":45,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,37,0,44],[4,37,5,37],[4,38,5,38],[4,39,4,40],[4,41,4,42],[4,43,4,44],[70,18,70,21],[71,18,71,19],[71,20,71,21],[70,23,70,26],[71,23,71,24],[71,25,71,26],[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],[2,23,2,24],[2,25,2,26],[14,1,14,3],[0,0,0,5],[1,0,1,6],[4,1,4,3],[5,1,5,3],[7,1,7,3],[12,13,12,16],[12,18,12,21],[12,23,12,26],[1,13,1,16],[1,18,1,21],[1,23,1,26],[2,13,2,14],[2,15,2,16],[2,18,2,19],[2,20,2,21],[13,13,13,14],[13,15,13,16],[13,18,13,19],[13,20,13,21],[13,23,13,24],[13,25,13,26],[24,13,24,16],[24,18,24,21],[24,23,24,26],[25,13,25,14],[25,15,25,16],[25,18,25,19],[25,20,25,21],[25,23,25,24],[25,25,25,26],[36,13,36,16],[36,18,36,21],[36,23,36,26],[37,13,37,14],[37,15,37,16],[37,18,37,19],[37,20,37,21],[37,23,37,24],[37,25,37,26],[47,13,47,16],[47,18,47,21],[47,23,47,26],[48,13,48,14],[48,15,48,16],[48,18,48,19],[48,20,48,21],[48,23,48,24],[48,25,48,26],[58,13,58,16],[58,18,58,21],[58,23,58,26],[59,13,59,14],[59,15,59,16],[59,18,59,19],[59,20,59,21],[59,23,59,24],[59,25,59,26],[25,10,25,11],[36,8,36,11],[37,8,37,9],[37,10,37,11],[1,8,1,11],[2,8,2,9],[2,10,2,11],[12,8,12,11],[13,8,13,9],[13,10,13,11],[58,8,58,11],[59,8,59,9],[59,10,59,11],[70,8,70,11],[5,34,5,35],[47,8,47,11],[48,8,48,9],[48,10,48,11],[24,8,24,11],[25,8,25,9],[70,13,70,16],[71,13,71,14],[71,15,71,16],[1,28,1,35],[5,28,6,28],[5,29,6,29],[5,30,5,31],[5,32,5,33]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":36},"Оборотно-сальдовая ведомость"]
[{"$nulls":8},"Счет 01",{"$nulls":4},"Счет 02",{"$nulls":4},"Счет 04",{"$nulls":4},"Счет 05",{"$nulls":4},"Оборотно-сальдовая ведомость"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Акцептован счет поставщика за поступившее оборорудование",null,null,135593,"Дт 08","Кт 60",null,null,45000,"С-до",{"$nulls":4},"С-до",8555,null,"С-до",2750,{"$nulls":4},0,"С-до",415]
[null,"в т.ч. НДС",null,null,24407,"Дт 19","Кт 60",null,"(Кт 08)",140593,"(Дт 91)",36445,null,"(Кт 02)",8555,"(Дт 25)",1200,{"$nulls":20},"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[2,"Начилена амортизация по объектам ОС",{"$nulls":8},"(Дт 02)",8555,null,null,null,"(Дт 23)",520,{"$nulls":11},"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец",{"$nulls":4},"Дт","Кт","Дт","Кт","Дт","Кт"]
[null,"основное производство",null,null,1200,"Дт 25"," Кт 02",{"$nulls":23},"Дт","Кт","Дт","Кт","Дт","Кт",null,"Сч 01","Основные средства",45000,null,135593,45000,135593]
[null,"вспомогательное производство",null,null,520,"Дт 23","Кт 02",{"$nulls":21},"Сч 01","Основные средства",45000,null,140593,45000,140593,null,null,"Сч 02","Амортизация ОС",null,8555,23000,24720,null,10275]
[3,"Начислена зарплата за доставку и монтаж оборудования",null,null,5000,"Дт 08","Кт 70",null,"Оборот",140593,"Оборот",45000,null,"Оборот",8555,"Оборот",1720,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Сч 02","Амортизация ОС",null,8555,8555,1720,null,1720,null,"Сч 04","Нематериальные активы",2750,null,null,null,2750]
[4,"Начислена арендная плата за арендуемое помещение",null,null,31000,"Дт 25","Кт 76",null,"С-до ",149148,"С-до",null,null,"С-до ",null,"С-до",1720,null,"С-до ",2750,"С-до",null,null,"С-до",null,"С-до",415,null,"Сч 04","Нематериальные активы",2750,null,null,null,2750,null,null,"Сч 05","Амортизация НМА",null,415,null,null,null,415]
[null,"в т.ч. НДС",null,null,5580,"Дт 19","Кт 76",{"$nulls":21},"Сч 05","Амортизация НМА",null,415,null,null,null,415,null,"Сч 08","Вложения во внеоб.акт",500,null,135593,135593,500]
[5,"Безвозмездно передано ОС другому предприятию: ",{"$nulls":26},"Сч 08","Вложения во внеоб.акт",500,null,140593,140593,500,null,null,"Сч 10","Материалы",2000,null,null,null,2000]
[null,"первоначальная стоимость ",null,null,22000,"Дт 91","Кт 01",null,"Счет 08",{"$nulls":4},"Счет 10",{"$nulls":4},"Счет 19",{"$nulls":4},"Счет 20",{"$nulls":4},"Сч 10","Материалы",2000,null,null,null,2000,null,null,"Сч 19","НДС по приобретенным МПЗ",null,null,29987,29987,0]
[null,"амортизацию на момент передачи",null,null,23000,"Дт 02","Кт 01",null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Сч 16","Отклонение в стоимости материалов",{"$nulls":7},"Сч 20","Основное производство",4200,null,5000,9200,0]
[6,"Начислена арендная плата за сданные в аренду на условиях",null,null,15340,"Дт 76","Кт 90",null,null,500,null,null,null,"С-до",2000,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",4200,"С-до",null,null,"Сч 19","НДС по приобретенным МПЗ",null,null,29987,29987,null,null,null,"Сч 23","Вспомогательное производство",null,null,520,520,0]
[null,"текущей аренды ОС",{"$nulls":6},"(Кт 60)",135593,"(Дт 01)",140593,{"$nulls":6},"(Кт 60)",24407,"(Дт 68)",29987,null,"(Кт 23)",520,"(Дт 43)",36920,null,"Сч 20","Основное производство",4200,null,32720,36920,null,null,null,"Сч 25","Общепроизводственные расходы",null,null,28000,28000,0]
[null,"НДС",null,null,2340,"Дт90","Кт 68",null,"(Кт 70)",5000,{"$nulls":8},"(Кт 76)",5580,null,null,null,"(Кт 25)",32200,null,null,null,"Сч 23","Вспомогательное производство",null,null,520,520,null,null,null,"Сч 43","Готовая продукция",2350,null,null,null,2350]
[7,"Введено в эксплуатацию оборудование после монтажа",null,null,140593,"Дт 01","Дт 08",{"$nulls":21},"Сч 25","Общепроизводственные расходы",null,null,32200,32200,null,null,null,"Сч 50","Касса",500,null,null,null,500]
[8,"Акцептованный счет оплачен поставщику",null,null,160000,"Дт 60","Кт 51",{"$nulls":21},"Сч 26","Общехозяйственные расходы",{"$nulls":7},"Сч 51","Расчетный счет",19480,null,1800000,473496,1345984]
[9,"Перечислена арендная плата за арендуемое помещение",null,null,36580,"Дт 76","Кт 51",null,"Оборот",140593,"Оборот",140593,{"$nulls":16},"Сч 41","Товары на складах",{"$nulls":7},"Сч 60","Расчеты с поставщиками и подрядчиками",null,7820,160000,160000,null,7820]
[10,"Зачислена предоплата за выполнение работ по договору 1",null,null,1800000,"Дт 51","Кт 62",null,"С-до",500,"С-до",null,null,"Оборот",0,"Оборот",0,null,"Оборот",29987,"Оборот",29987,null,"Оборот",32720,"Оборот",36920,null,"Сч 43","Готовая продукция",2350,null,null,null,2350,null,null,"Сч 62","Расчеты с покупателями и заказчиками",3572,null,null,1800000,null,1796428]
[null,"в т.ч. НДС",null,null,274576,"Дт 76","Кт 68",{"$nulls":6},"С-до",null,"С-до",null,null,"С-до",29987,"С-до",null,null,"С-до ",0,"С-до ",null,null,"Сч 50","Касс",500,null,null,null,500,null,null,"Сч 66","Расчеты по кредитам и займам",null,13000,null,null,null,13000]
[11,"Произведены расчеты с бюджетом по НДС за месяц",null,null,250979,"Дт 68","Кт 51",{"$nulls":21},"Сч 51","Расчетный счет",19480,null,1800000,443509,1375971,null,null,"Сч 68","Расчеты по налогам и сборам",null,4050,276916,276916,null,4050]
[{"$nulls":28},"Сч 58","Финансовые вложения",{"$nulls":7},"Сч 69","Расчеты по социальному страхованию ",null,2530,null,null,null,2530]
[{"$nulls":8},"Счет 23",{"$nulls":4},"Счет 25",{"$nulls":4},"Счет 26",{"$nulls":4},"Счет 43",{"$nulls":4},"Сч 60","Расчеты с поставщиками и подрядчиками",null,7820,160000,160000,null,7820,null,"Сч 70","Расчеты с персоналом по оплате труда",null,7460,null,5000,null,12460]
[{"$nulls":8},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Сч 62","Расчеты с покупателями и заказчиками",{"$nulls":7},"Сч 71","Расчеты с подотчетными лицами",27,null,null,null,27]
[{"$nulls":8},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",2350,"С-до",null,null,"Сч 62.1","Расчеты с покупателями и заказчиками",3572,null,null,null,3572,null,null,"Сч 76","Расчеты с разными дебиторами и кредит.",130,null,326496,36580,290046]
[{"$nulls":8},"(Кт 02)",520,"(Дт 20)",520,null,"(Кт 02)",1200,"(Дт 20)",32200,{"$nulls":6},"(Кт 20)",36920,null,null,null,"Сч 62.2","Расчеты по авансам полученным",null,null,null,1800000,null,1800000,null,"Сч 80","Уставной капитал",null,10000,null,null,null,10000]
[{"$nulls":13},"(Кт 76)",31000,{"$nulls":13},"Сч 66","Расчеты по кредитам и займам",null,13000,null,null,null,13000,null,"Сч 82","Резервный капитал",null,4500,null,null,null,4500]
[{"$nulls":28},"Сч 68","Расчеты по налогам и сборам",null,4050,276916,276916,null,4050,null,"сч 84","Нераспределенная прибыль (убыток)",null,8000,null,null,null,8000]
[{"$nulls":28},"Сч 69","Расчеты по социальному страхованию ",null,2530,null,null,null,2530,null,"Сч 91",null,null,null,24340,15340,9000]
[{"$nulls":28},"Сч 70","Расчеты с персоналом по оплате труда",null,7460,null,5000,null,12460,null,"Сч 99","Прибыли и убытки (финансовый результ)",null,14179,null,null,null,14179]
[{"$nulls":8},"Оборот",520,"Оборот",520,null,"Оборот",32200,"Оборот",32200,null,"Оборот",0,"Оборот",0,null,"Оборот",36920,"Оборот",0,null,"Сч 71","Расчеты с подотчетными лицами",27,null,null,null,27,{"$nulls":9},0]
[{"$nulls":8},"С-до ",0,"С-до ",null,null,"С-до ",0,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"Сч 73","Расчеты с персоналом по прочим опер",{"$nulls":8},"Итого",80509,80509,2945445,3040352,1788750,1883657]
[{"$nulls":28},"Сч 75","Расчеты с учредителями"]
[{"$nulls":28},"Сч 76","Расчеты с разными дебиторами и кредит.",130,null,326496,36580,290046]
[{"$nulls":8},"Счет 50",{"$nulls":4},"Счет 51",{"$nulls":4},"Счет 60",{"$nulls":4},"Счет 62",{"$nulls":4},"Сч 80","Уставной капитал",null,10000,null,null,null,10000]
[{"$nulls":8},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Сч 82","Резервный капитал",null,4500,null,null,null,4500]
[{"$nulls":8},"С-до",500,"С-до",null,null,"С-до",19480,"С-до",null,null,"С-до",null,null,7820,null,"С-до",3572,"С-до",null,null,"Сч 83","Добавочный капитал"]
[{"$nulls":13},"(Кт 62)",1800000,"(Дт 60)",160000,null,"(Кт 51)",160000,"(Дт 08)",135593,null,null,null,"(Дт 51)",1800000,null,"сч 84","Нераспределенная прибыль (убыток)",null,8000,null,null,null,8000]
[{"$nulls":15},"(Дт 76)",36580,null,null,null,"(Дт 19)",24407,{"$nulls":6},"Сч 86","Целевое финансирование"]
[{"$nulls":15},"(Дт68)",246929,{"$nulls":11},"Сч 90","Продажи",null,null,null,15340,null,15340]
[{"$nulls":28},"Сч 90.2","Себестоимость продаж",null,null,36920,null,36920]
[{"$nulls":18},"Оборот",160000,"Оборот",160000,null,"Оборот",0,"Оборот",1800000,null,"Сч 90.3","НДС по приобретенным МПЗ",null,null,2340,null,2340]
[{"$nulls":8},"Оборот",0,"Оборот",0,null,"Оборот",1800000,"Оборот",443509,null,"С-до ",null,"С-до",null,null,"С-до ",null,"С-до ",1796428,null,"Сч.90.9","Прибыль/убыток от продаж",null,null,null,23920,null,23920]
[{"$nulls":8},"С-до ",500,"С-до ",null,null,"С-до ",1375971,"С-до ",{"$nulls":12},"Сч 91","Резервы предстоящих расходов"]
[{"$nulls":28},"Сч.91.2","Прочие расходы",null,null,36445,null,36445]
[{"$nulls":8},"Счет 66",{"$nulls":4},"Счет 68",{"$nulls":4},"Счет 69",{"$nulls":4},"Счет 70",{"$nulls":4},"Сч 97","Расходы будующих периодов"]
[{"$nulls":8},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Сч 98","Доходы будущих периодов"]
[{"$nulls":8},"С-до",null,"С-до",13000,null,"С-до",null,"С-до",4050,null,"С-до",null,"С-до",2530,null,"С-до",null,"С-до",7460,null,"Сч 99","Прибыли и убытки (финансовый результ)",null,14179,36445,12525,9741]
[{"$nulls":13},"(Кт 19)",29987,"(Дт 76)",2340,{"$nulls":8},"(Дт 08)",5000]
[{"$nulls":13},"(Кт 51)",246929,"(Дт 76)",274576,{"$nulls":12},"Итого",80509,80509,3060730,3060730,1903755,1903755]
[]
[]
[{"$nulls":8},"Оборот",0,"Оборот",0,null,"Оборот",276916,"Оборот",276916,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",5000]
[{"$nulls":8},"С-до ",null,"С-до ",13000,null,"С-до ",null,"С-до ",4050,null,"С-до ",null,"С-до ",2530,null,"С-до ",null,"С-до ",12460]
[]
[]
[{"$nulls":8},"Счет 71",{"$nulls":4},"Счет 76",{"$nulls":4},"Счет 80",{"$nulls":4},"Счет 82"]
[{"$nulls":8},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":8},"С-до",27,null,null,null,"С-до",130,"С-до",null,null,"С-до",null,"С-до",10000,null,"С-до",null,"С-до",4500]
[{"$nulls":13},"(Кт 90)",15340,"(Дт 25)",31000]
[{"$nulls":13},"(Кт 51)",36580,"(Дт 19)",5580]
[{"$nulls":13},"(Кт 68)",274576]
[]
[{"$nulls":8},"Оборот",0,"Оборот",0]
[{"$nulls":8},"С-до ",27,"С-до ",null,null,"Оборот",326496,"Оборот",36580,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":13},"С-до ",290046,"С-до ",null,null,"С-до",null,"С-до",4500,null,"С-до",null,"С-до",4500]
[]
[]
[{"$nulls":8},"Счет 84",{"$nulls":4},"Счет 90",{"$nulls":4},"Счет 91",{"$nulls":4},"Счет 99"]
[{"$nulls":8},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":8},"С-до",null,"С-до",8000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",14179]
[{"$nulls":13},"(Кт 68)",2340,"(Дт 76)",15340,null,"(Кт 01)",22000,{"$nulls":5},"(Дт 90)",13000]
[{"$nulls":13},"(Кт 99)",13000]
[]
[]
[]
[{"$nulls":8},"Оборот",0,"Оборот",0,null,"Оборот",15340,"Оборот",15340,null,"Оборот",22000,"Оборот",0,null,"Оборот",0,"Оборот",13000]
[{"$nulls":8},"С-до",0,"С-до",null,null,"С-до",0,"С-до",null,null,"С-до",22000,"С-до",null,null,"С-до",-13000,"С-до"]

{"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"]}