{"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":57,"n_cols":38,"rows_kept":57,"cut":false,"hidden":false,"merged":[[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],[47,24,47,25],[47,26,47,27],[47,9,47,10],[47,11,47,12],[47,14,47,15],[47,16,47,17],[47,19,47,20],[47,21,47,22],[46,9,46,12],[46,14,46,17],[46,19,46,22],[46,24,46,27],[30,24,30,25],[30,26,30,27],[30,9,30,10],[30,11,30,12],[30,14,30,15],[30,16,30,17],[30,19,30,20],[30,21,30,22],[29,9,29,12],[29,14,29,17],[29,19,29,22],[29,24,29,27],[15,24,15,25],[15,26,15,27],[15,9,15,10],[15,11,15,12],[15,14,15,15],[15,16,15,17],[15,19,15,20],[15,21,15,22],[2,24,2,25],[2,26,2,27],[14,9,14,12],[14,14,14,17],[14,19,14,22],[14,24,14,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],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[2,1,2,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[16,1,16,3],[3,1,3,3],[6,1,6,3],[8,1,8,3],[9,1,9,3],[17,1,17,3],[12,1,12,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[15,1,15,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},"Счет 10",{"$nulls":4},"Счет 20",{"$nulls":4},"Счет 43",{"$nulls":5},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Приняты на склад материалы",null,null,16920,"Дт 10","Кт 60",1,null,"С-до",168000,null,null,null,"С-до",29880,"С-до",null,null,"С-до",3600,"С-до",null,null,"С-до",9600,"С-до"]
[2,"Принят к оплате счет за поставку материалов на фабрику",null,null,1632,"Дт 10","Кт 60",2,{"$nulls":6},"1.(Кт 60)",16920,"5.(Дт 20)",36000,null,"5.(Кт 10)",36000,"9.(Дт 43)",58440,null,"9.(Кт 20)",58440,"10.(Дт 45)",37980,null,null,"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[3,"Перечислено поставщику за материалы",null,null,16920,"Дт 60 ","Кт 51",3,{"$nulls":6},"2.(Кт 60)",1632,null,null,null,"6.(Кт 70)",18000,{"$nulls":11},"Дт","Кт","Дт","Кт","Дт","Кт"]
[4,"Авансовый отчет Петрова погрузка материалов",null,null,600,"Дт 10","Кт 71",4,{"$nulls":6},"4.(Кт 71)",600,null,null,null,"7.(Кт 69)",4680,{"$nulls":9},"Сч 01","Основные средства",168000,null,null,null,168000]
[5,"Отпущены в производство материалы по факт себестоимости",null,null,36000,"Дт 20","Кт 10",5,{"$nulls":11},"8.(Кт 60)",960,{"$nulls":9},"Сч 02","Амортизация ОС"]
[6,"Начислена заработная плата производственным рабочим",null,null,18000,"Дт 20","Кт 70",6,{"$nulls":22},"Сч 04","Нематериальные активы"]
[7,"Расчет отчислений в соцстрах",null,null,4680,"Дт 20","Кт 69",7,{"$nulls":22},"Сч 05","Амортизация НМА"]
[8,"Энергосбыт",null,null,960,"Дт 20","Кт 60",8,null,"Оборот",0,"Оборот",0,null,"Оборот",19152,"Оборот",36000,null,"Оборот",59640,"Оборот",58440,null,"Оборот",58440,"Оборот",37980,null,null,"Сч 08","Вложения во внеоб.акт"]
[9,"Принята на склад продукция карамель ",null,null,58440,"Дт 43","Кт 20",9,null,"С-до ",168000,"С-до ",null,null,"С-до",13032,"С-до",null,null,"С-до ",4800,"С-до ",null,null,"С-до ",30060,"С-до ",null,null,null,"Сч 10","Материалы",29880,null,19152,36000,13032]
[10,"Отгружена продукция по факт себестоимости",null,null,37980,"Дт 45","Кт 43",10,{"$nulls":22},"Сч 19","НДС по приобретенным МПЗ"]
[11,"Поступило на р/счет от покупателей за реализ. продукцию",null,null,45000,"Дт 51","Кт 62",11,{"$nulls":22},"Сч 20","Основное производство",3600,null,59640,58440,4800]
[{"$nulls":4},45000,"Дт 62","Кт 90.01",11,null,"Счет 44",{"$nulls":4},"Счет 45",{"$nulls":4},"Счет 50",{"$nulls":4},"Счет 51",{"$nulls":5},"Сч 23","Вспомогательное производство"]
[12,"Приняты документы за перевозку продукции ",null,null,1008,"Дт 44","Кт 60",12,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 25","Общепроизводственные расходы"]
[13,"Списаны коммерческие расходы",null,null,1008,"Дт 90","Кт 44",13,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",120,"С-до",null,null,"С-до",28560,"С-до",null,null,null,"Сч 26","Общехозяйственные расходы"]
[14,"Списана фактическая себестоимость реализованной продук",null,null,37980,"Дт 90","Кт 45",14,null,"12. (Кт 60)",1008,"13.(Дт 90)",1008,null,"10. (Кт 43)",37980,"14. (Дт 90)",37980,{"$nulls":6},"11. (Кт 62)",45000,"3.(Дт 60)",16920,null,null,"Сч 41","Товары на складах"]
[15,"Списан результат от реализации продукции",null,null,6012,"Дт 90","Кт 99",15,{"$nulls":22},"Сч 43","Готовая продукция",9600,null,58440,37980,30060]
[{"$nulls":30},"Сч 44",null,null,null,1008,1008]
[{"$nulls":30},"Сч 45","Отгруженная продукция",null,null,37980,37980]
[{"$nulls":30},"Сч 50","Касс",120,null,null,null,120]
[{"$nulls":30},"Сч 51","Расчетный счет",28560,null,45000,16920,56640]
[{"$nulls":9},"Оборот",1008,"Оборот",1008,null,"Оборот",37980,"Оборот",37980,null,"Оборот",0,"Оборот",0,null,"Оборот",45000,"Оборот",16920,null,null,"Сч 58","Финансовые вложения"]
[{"$nulls":9},"С-до ",0,"С-до ",0,null,"С-до ",0,"С-до ",0,null,"С-до ",120,"С-до ",null,null,"С-до ",56640,"С-до ",null,null,null,"Сч 60","Расчеты с поставщиками и подрядчиками",null,600,16920,20520,null,4200]
[{"$nulls":30},"Сч 62","Расчеты с покупателями и заказчиками",null,null,45000,45000]
[{"$nulls":30},"Сч 66","Расчеты по кредитам и займам"]
[{"$nulls":30},"Сч 68","Расчеты по налогам и сборам"]
[{"$nulls":30},"Сч 69","Расчеты по социальному страхованию ",null,null,null,4680,null,4680]
[{"$nulls":9},"Счет 60",{"$nulls":4},"Счет 62",{"$nulls":4},"Счет 69.1",{"$nulls":4},"Счет 70",{"$nulls":5},"Сч 70","Расчеты с персоналом по оплате труда",null,null,null,18000,null,18000]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 71","Расчеты с подотчетными лицами",840,null,null,600,240]
[{"$nulls":9},"С-до",null,"С-до",600,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 73","Расчеты с персоналом по прочим опер"]
[{"$nulls":9},"3.(Кт 51)",16920,"1. (Дт 10)",16920,null,"11.(Кт 90.1)",45000,"11. (Дт 51)",45000,null,null,null,"7.(Дт 20)",4680,null,null,null,"6.(Дт 20)",18000,null,null,"Сч 75","Расчеты с учредителями"]
[{"$nulls":11},"2.(Дт 10)",1632,{"$nulls":17},"Сч 76","Расчеты с разными дебиторами и кредит."]
[{"$nulls":11},"8.(Дт 20)",960,{"$nulls":17},"Сч 80","Уставной капитал",null,234000,null,null,null,234000]
[{"$nulls":11},"12.(Дт 44)",1008,{"$nulls":17},"Сч 82","Резервный капитал"]
[{"$nulls":30},"Сч 83","Добавочный капитал"]
[{"$nulls":30},"сч 84","Нераспределенная прибыль (убыток)"]
[{"$nulls":9},"Оборот",16920,"Оборот",20520,null,"Оборот",45000,"Оборот",45000,null,"Оборот",0,"Оборот",4680,null,"Оборот",0,"Оборот",18000,null,null,"Сч 86","Целевое финансирование"]
[{"$nulls":9},"С-до ",null,"С-до ",4200,null,"С-до ",0,"С-до ",0,null,"С-до ",null,"С-до ",4680,null,"С-до",null,"С-до",18000,null,null,"Сч 90","Продажи",null,null,45000,45000]
[{"$nulls":30},"Сч 96","Резервы предстоящих расходов"]
[{"$nulls":30},"Сч 97","Расходы будующих периодов"]
[{"$nulls":30},"Сч 98","Доходы будущих периодов"]
[{"$nulls":30},"Сч 99","Прибыли и убытки (финансовый результ)",null,6000,null,6012,null,12012]
[]
[{"$nulls":31},"Итого",240600,240600,328140,328140,272892,272892]
[{"$nulls":9},"Счет 71",{"$nulls":4},"Счет 90",{"$nulls":4},"Счет 99"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",840,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",6000]
[{"$nulls":11},"4.(Дт 10)",600,null,"13.(Кт 44)",1008,"11.(Дт 62)",45000,null,null,null,"15. (Дт 90)",6012]
[{"$nulls":14},"14. (Кт 45)",37980]
[{"$nulls":14},"15.(Дт 99)",6012]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",600,null,"Оборот",45000,"Оборот",45000,null,"Оборот",0,"Оборот",6012]
[{"$nulls":9},"С-до",null,"С-до",240,null,"С-до",0,"С-до",0,null,"С-до",null,"С-до",12012]

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