{"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":156,"n_cols":38,"rows_kept":156,"cut":false,"hidden":false,"merged":[[53,1,53,3],[0,14,0,27],[0,0,0,5],[1,0,1,6],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[35,1,35,3],[34,1,34,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],[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],[1,9,1,12],[2,14,2,17],[2,19,2,22],[2,24,2,27],[2,9,2,10],[2,11,2,12],[3,14,3,15],[3,16,3,17],[3,19,3,20],[3,21,3,22],[3,24,3,25],[3,26,3,27],[12,9,12,12],[13,14,13,17],[13,19,13,22],[13,24,13,27],[30,9,30,12],[31,14,31,17],[31,19,31,22],[31,24,31,27],[13,9,13,10],[13,11,13,12],[14,14,14,15],[14,16,14,17],[14,19,14,20],[14,21,14,22],[32,14,32,15],[32,16,32,17],[32,19,32,20],[32,21,32,22],[31,9,31,10],[31,11,31,12],[14,24,14,25],[14,26,14,27],[51,19,51,20],[51,21,51,22],[32,24,32,25],[32,26,32,27],[51,24,51,25],[51,26,51,27],[74,14,74,17],[74,19,74,22],[74,24,74,27],[50,9,50,10],[50,11,50,12],[51,14,51,15],[51,16,51,17],[50,14,50,17],[50,19,50,22],[50,24,50,27],[3,1,3,3],[88,9,88,12],[89,14,89,17],[89,19,89,22],[89,24,89,27],[74,9,74,10],[74,11,74,12],[75,14,75,15],[75,16,75,17],[75,19,75,20],[90,14,90,15],[90,16,90,17],[90,19,90,20],[90,21,90,22],[75,24,75,25],[75,26,75,27],[75,21,75,22],[107,11,107,12],[108,19,108,20],[108,21,108,22],[90,24,90,25],[90,26,90,27],[106,9,106,12],[107,14,107,17],[107,19,107,22],[107,24,107,27],[108,14,108,15],[108,24,108,25],[108,26,108,27],[119,9,119,12],[120,14,120,17],[120,19,120,22],[120,24,120,27],[108,16,108,17],[133,26,133,27],[4,1,4,3],[5,1,5,3],[131,9,131,12],[132,14,132,17],[132,19,132,22],[132,24,132,27],[120,9,120,10],[120,11,120,12],[121,14,121,15],[14,1,14,3],[7,1,7,3],[133,16,133,17],[133,19,133,20],[133,21,133,22],[121,24,121,25],[133,24,133,25],[121,16,121,17],[121,19,121,20],[121,21,121,22],[6,1,6,3],[8,1,8,3],[9,1,9,3],[12,1,12,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[144,9,144,12],[145,14,145,17],[145,9,145,10],[145,11,145,12],[146,14,146,15],[146,16,146,17],[132,11,132,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],[121,26,121,27],[89,11,89,12],[23,1,23,3],[24,1,24,3],[25,1,25,3],[17,1,17,3],[16,1,16,3],[132,9,132,10],[89,9,89,10],[107,9,107,10],[73,9,73,12],[49,9,49,12],[133,14,133,15],[18,1,18,3],[15,1,15,3],[19,1,19,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[20,1,20,3],[21,1,21,3],[22,1,22,3]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":13},"Самолетики ",{"$nulls":15},"Оборотно-сальдовая ведомость"]
[{"$nulls":9},"Счет 01",{"$nulls":20},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,null,"Дт",null,"Кт",null,null,"Счет 02",{"$nulls":4},"Счет 08",{"$nulls":4},"Счет 05"]
[1,"Предприятие выставило накладную на реализацию",{"$nulls":7},"С-до",{"$nulls":4},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[null,"материалов покупателю в сумме 200 000",null,null,200000,62,"91.01",{"$nulls":9},"С-до",null,null,"С-до",{"$nulls":5},0,"С-до",null,null,null,"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[null,"в т.ч. НДС 18%",null,null,30508.47,"91.02","68.02",{"$nulls":25},"Дт","Кт","Дт","Кт","Дт","Кт"]
[null,"себестоимость",null,null,80000,"91.02",10,{"$nulls":23},"Сч 01","Основные средства"]
[2,"От покупателей на р/счет поступили денежные средства",null,null,180000,51,62,{"$nulls":23},"Сч 02","Амортизация ОС"]
[null,"180 000, в т.ч. НДС ",{"$nulls":7},"Оборот",0,"Оборот",0,{"$nulls":17},"Сч 04","Нематериальные активы"]
[3,"Предприятие выставило акт на монтаж оборудования 60 000",null,null,60000,62,"90.01",null,null,"С-до ",null,"С-до ",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,null,"Сч 05","Амортизация НМА"]
[null,"в т.ч. НДС 18%",null,null,9152.54,"90.03","68.02",{"$nulls":7},"С-до ",null,"С-до",null,null,"С-до ",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 08","Вложения во внеоб.акт"]
[4,"Предприятие перечислило поставщику за материалы 120 000",null,null,120000,60,51,{"$nulls":23},"Сч 10","Материалы",null,null,93220.34,90000,3220.34]
[null,"в т.ч. НДС",{"$nulls":7},"Счет 10",{"$nulls":20},"Сч 19","НДС по приобретенным МПЗ",null,null,21355.93,21355.93]
[5,"Поступили материалы по накладной  в сумме 110 000 руб",null,null,93220.34,10,60,null,null,"Дт",null,"Кт",null,null,"Счет 19",{"$nulls":4},"Счет 20",{"$nulls":4},"Счет 25",{"$nulls":5},"Сч 20","Основное производство",null,null,25423.73,25423.73]
[null,"в т.ч. НДС 18%",null,null,16779.66,19,60,null,null,"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 23","Вспомогательное производство"]
[null,"НДС принят к вычету",null,null,16779.66,68.02,19,null,null,"КТ 60",93220.34,"ДТ 91.02",80000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[6,"Арендодатель выставил акт и с/ф  за месяц  на сумму 30 000 ",null,null,25423.73,20,76,{"$nulls":4},"ДТ 94",10000,null,"КТ60",16779.66,"ДТ 68.02",16779.66,null,"КТ 76",25423.73,"ДТ 90.02",25423.73,{"$nulls":7},"Сч 25","Общепроизводственные расходы"]
[null,"в т.ч. НДС 18%",null,null,4576.27,19,76,{"$nulls":7},"КТ 76",4576.27,"ДТ 68.02",4576.27,{"$nulls":12},"Сч 26","Общехозяйственные расходы"]
[null,"НДС принят к вычету",null,null,4576.27,"68.02",19,{"$nulls":23},"Сч 41","Товары на складах"]
[null,"списывается на себестоимость арендная плата",null,null,25423.73,"90.02",20,{"$nulls":23},"Сч 43","Готовая продукция"]
[7,"В течение месяца банк снимал с р/с услуги банка 3 000 руб",null,null,3000,"91.02",51,{"$nulls":23},"Сч 45","Товары отгруженные"]
[8,"Предприятие начислило транспортный налог 1 000 руб",null,null,1000,"91.02","68.07",{"$nulls":23},"Сч 50","Касс"]
[9,"В ходе инвентаризации была выявлена недостача  10 000 руб",null,null,10000,94,10,{"$nulls":23},"Сч 51","Расчетный счет",null,null,180000,123000,57000]
[null,"материалов (НДС ?)",null,null,10000,"91.02",94,{"$nulls":23},"Сч 58","Финансовые вложения"]
[{"$nulls":30},"Сч 60","Расчеты с поставщиками и подрядчиками",null,null,120000,110000,10000]
[10,"Финансовый результат",null,null,100915.26,"90.09",99,{"$nulls":23},"Сч 62","Расчеты с покупателями и заказчиками",null,null,260000,180000,80000]
[null,"Внереализационные доходы",{"$nulls":7},"Оборот",93220.34,"Оборот",90000,{"$nulls":17},"Сч 66","Расчеты по кредитам и займам"]
[null,"Внереализационные расходы",{"$nulls":7},"С-до",null,"С-до",null,null,"Оборот",21355.93,"Оборот",21355.93,null,"Оборот",25423.73,"Оборот",25423.73,null,"Оборот",0,"Оборот",0,null,null,"Сч 67","Долгосрочные кредиты и займы"]
[null,"Налог на прибыль",{"$nulls":12},"С-до",null,"С-до",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч 68","Расчеты по налогам и сборам"]
[{"$nulls":30},"Сч.68.02","НДС",null,null,21355.93,39661.01,null,18305.08]
[{"$nulls":9},"Счет 26",{"$nulls":20},"Сч.68.4","Налог на прибыль"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 41",{"$nulls":4},"Счет 43",{"$nulls":4},"Счет 44",{"$nulls":5},"Сч.68.07","Транспортный налог",null,null,null,1000,null,1000]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 69","Расчеты по социальному страхованию "]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 70","Расчеты с персоналом по оплате труда"]
[{"$nulls":30},"Сч 71","Расчеты с подотчетными лицами"]
[{"$nulls":30},"Сч 73","Расчеты с персоналом по прочим опер"]
[{"$nulls":30},"Сч 75","Расчеты с учредителями"]
[{"$nulls":30},"Сч 76","Расчеты с разными дебиторами и кредит.",null,null,null,30000,null,30000]
[{"$nulls":30},"Сч 80","Уставной капитал"]
[{"$nulls":30},"Сч 81","Прочий капитал"]
[{"$nulls":30},"Сч 82","Резервный капитал"]
[{"$nulls":30},"Сч 83","Добавочный капитал"]
[{"$nulls":30},"сч 84","Нераспределенная прибыль (убыток)"]
[{"$nulls":30},"Сч 84.1","Прибыль подлежащая распределению"]
[{"$nulls":30},"Сч 84.3","Использование прибыли"]
[{"$nulls":9},"Оборот",0,"Оборот",0,{"$nulls":17},"Сч 86","Целевое финансирование"]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,null,"Сч 90","Продажи"]
[{"$nulls":14},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч.90.01","Выручка ",null,null,null,60000,null,60000]
[{"$nulls":30},"Сч.90.02","Себестоимость продаж",null,0,25423.73,null,25423.73]
[{"$nulls":9},"Счет 50",{"$nulls":20},"Сч.90.03","НДС",null,0,9152.54,null,9152.54]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 51",{"$nulls":4},"Счет 52",{"$nulls":4},"Счет 60",{"$nulls":5},"Сч.90.09","Прибыль до налогообложения",null,0,100915.26,null,100915.26]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч.91.01","Прочие доходы",null,0,null,200000,null,200000]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч.91.02","Прочие расходы",null,0,124508.47,null,124508.47]
[{"$nulls":14},"КТ 62",180000,"ДТ 60",120000,{"$nulls":6},"КТ 51",120000,"ДТ 10",93220.34,null,null,"Сч.91.09","Сальдо прочих доходов и расходов",null,0]
[{"$nulls":16},"ДТ 91.02",3000,{"$nulls":8},"ДТ 19",16779.66,null,null,"Сч 94","Недостачи без виновных лиц",null,0,10000,10000]
[{"$nulls":30},"Сч 97","Доходы будущих периодов",null,0]
[{"$nulls":30},"Сч.99","Прибыли и убытки",null,0,null,100915.26,null,100915.26]
[{"$nulls":33},0,991355.93,991355.93,410220.33999999997,410220.34]
{"$rows_empty":11}
[{"$nulls":9},"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"Оборот",180000,"Оборот",123000,null,"Оборот",0,"Оборот",0,null,"Оборот",120000,"Оборот",110000]
[{"$nulls":14},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до "]
[]
[{"$nulls":9},"Счет 62"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 66",{"$nulls":4},"Счет 68.1",{"$nulls":4},"Счет 68.02"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"КТ 91.01",200000,"ДТ 51",180000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до"]
[{"$nulls":9},"КТ 90.01",60000,{"$nulls":13},"КТ19",16779.66,"ДТ 91.02",30508.47]
[{"$nulls":24},"КТ 19",4576.27,"ДТ 90,3",9152.54]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",260000,"Оборот",180000]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",21355.93,"Оборот",39661.01]
[{"$nulls":14},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до "]
[]
[{"$nulls":9},"Счет 68.07"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 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":11},"ДТ 91.02",1000,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
{"$rows_empty":10}
[{"$nulls":9},"Оборот",0,"Оборот",1000]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":14},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до "]
[]
[{"$nulls":9},"Счет 70"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 71",{"$nulls":4},"Счет 73",{"$nulls":4},"Счет 90.01"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":26},"ДТ 62",60000]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,{"$nulls":11},"Оборот",0,"Оборот",60000]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"С-до",null,"С-до"]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[]
[{"$nulls":9},"Счет 76"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 80",{"$nulls":4},"Счет 90.9",{"$nulls":4},"Счёт91.01"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":11},"ДТ 20",25423.73,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":11},"ДТ 19",4576.27,{"$nulls":6},"КТ 99",100915.26,{"$nulls":5},"ДТ 62",200000]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",30000]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Оборот",0,"Оборот",0,null,"Оборот",100915.26,"Оборот",0,null,"Оборот",0,"Оборот",200000]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[]
[{"$nulls":9},"Счет 84"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 94",{"$nulls":4},"Счет 90.03",{"$nulls":4},"Счет 91.02"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":14},"КТ 10",10000,"ДТ 91.02",10000,null,"КТ 68.02",9152.54,null,null,null,"КТ 68.02",30508.47]
[{"$nulls":24},"КТ 10",80000]
[{"$nulls":24},"КТ 51",3000]
[{"$nulls":24},"КТ 68.07",1000]
[{"$nulls":24},"КТ 94",10000]
[{"$nulls":9},"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Оборот",10000,"Оборот",10000,null,"Оборот",9152.54,"Оборот",0,null,"Оборот",124508.47,"Оборот",0]
[{"$nulls":14},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[]
[{"$nulls":9},"Счет 99"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Счет 90.02"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Дт",null,"Кт"]
[{"$nulls":11},"ДТ 90.09",100915.26,null,"С-до",null,"С-до"]
[{"$nulls":14},"КТ 20",25423.73]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",100915.26]
[{"$nulls":9},"С-до",null,"С-до",null,null,"Оборот",25423.73,"Обоот"]
[{"$nulls":14},"С-до",null,"С-до"]

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