{"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":82,"n_cols":33,"rows_kept":82,"cut":false,"hidden":false,"merged":[[56,1,56,3],[0,14,0,23],[14,1,14,3],[0,0,0,5],[1,0,1,6],[4,1,4,3],[5,1,5,3],[7,1,7,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],[20,1,20,3],[21,1,21,3],[22,1,22,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],[29,1,29,3],[30,1,30,3],[31,1,31,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[38,1,38,3],[37,1,37,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[2,1,2,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[2,9,2,12],[2,14,2,17],[2,19,2,22],[3,9,3,10],[3,11,3,12],[51,1,51,3],[50,1,50,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[16,9,16,12],[16,14,16,17],[16,19,16,22],[17,19,17,20],[17,21,17,22],[3,14,3,15],[3,16,3,17],[3,19,3,20],[3,21,3,22],[28,9,28,12],[28,14,28,17],[28,19,28,22],[17,9,17,10],[17,11,17,12],[17,14,17,15],[17,16,17,17],[29,9,29,10],[29,11,29,12],[29,14,29,15],[29,16,29,17],[29,19,29,20],[29,21,29,22],[44,19,44,20],[44,21,44,22],[69,19,69,22],[70,19,70,20],[70,21,70,22],[43,9,43,12],[43,14,43,17],[43,19,43,22],[56,14,56,17],[57,9,57,10],[57,11,57,12],[57,14,57,15],[57,16,57,17],[44,16,44,17],[0,25,0,32],[4,25,5,25],[4,26,5,26],[4,27,4,28],[4,29,4,30],[4,31,4,32],[1,25,1,32],[44,14,44,15],[18,1,18,3],[15,1,15,3],[56,19,56,22],[57,19,57,20],[57,21,57,22],[19,1,19,3],[44,9,44,10],[44,11,44,12],[56,9,56,12],[69,9,69,12],[70,9,70,10],[70,11,70,12],[69,14,69,17],[70,14,70,15],[70,16,70,17]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":13},"Самолетики ",{"$nulls":10},"Оборотно-сальдовая ведомость"]
[{"$nulls":25},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,null,"Счет 10",{"$nulls":4},"Счет 19",{"$nulls":4},"Счет 20"]
[1,"Предприятие выставило накладную на реализацию",{"$nulls":7},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[null,"материалов покупателю в сумме 200 000",null,null,200000,62,91.01,null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[null,"в т.ч. НДС 18%",null,null,30508.47,91.02,68.02,null,null,"Кт 60",93220.34,"Дт 91.02",80000,null,"Кт 60",16779.66,"Дт 68.02",16779.66,null,"Кт 76",25423.73,"Дт 90.02",25423.73,{"$nulls":4},"Дт","Кт","Дт","Кт","Дт","Кт"]
[null,"себестоимость",null,null,80000,91.02,10,{"$nulls":4},"Дт 94",10000,null,"Кт 76",4576.27,"Дт 68.02",4576.27,{"$nulls":7},"Сч 01","Основные средства"]
[2,"От покупателей на р/счет поступили денежные средства",null,null,180000,51,62,{"$nulls":18},"Сч 02","Амортизация ОС"]
[null,"180 000, в т.ч. НДС ",{"$nulls":23},"Сч 04","Нематериальные активы"]
[3,"Предприятие выставило акт на монтаж оборудования 60 000",null,null,60000,62,90.01,{"$nulls":18},"Сч 05","Амортизация НМА"]
[null,"в т.ч. НДС 18%",null,null,9152.54,90.03,68.02,null,null,"Оборот",93220.34,"Оборот",90000,null,"Оборот",21355.93,"Оборот",21355.93,null,"Оборот",25423.73,"Оборот",25423.73,null,null,"Сч 08","Вложения во внеоб.акт"]
[4,"Предприятие перечислило поставщику за материалы 120 000",null,null,120000,60,51,null,null,"С-до",3220.34,"С-до",null,null,"С-до",0,"С-до",0,null,"С-до ",0,"С-до ",0,null,null,"Сч 10","Материалы",null,null,93220.34,90000,3220.34]
[null,"в т.ч. НДС",{"$nulls":23},"Сч 19","НДС по приобретенным МПЗ",null,null,21355.93,21355.93]
[5,"Поступили материалы по накладной  в сумме 110 000 руб",null,null,93220.34,10,60,{"$nulls":18},"Сч 20","Основное производство",null,null,25423.73,25423.73]
[null,"в т.ч. НДС 18%",null,null,16779.66,19,60,{"$nulls":18},"Сч 23","Вспомогательное производство"]
[null,"НДС принят к вычету",null,null,16779.66,68.2,19]
[6,"Арендодатель выставил акт и с/ф  за месяц  на сумму 30 000 ",null,null,25423.73,20,76,null,null,"Счет 51",{"$nulls":4},"Счет 60",{"$nulls":4},"Счет 62",{"$nulls":5},"Сч 25","Общепроизводственные расходы"]
[null,"в т.ч. НДС 18%",null,null,4576.27,19,76,null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 26","Общехозяйственные расходы"]
[null,"НДС принят к вычету",null,null,4576.27,68.2,19,null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 41","Товары на складах"]
[{"$nulls":9},"Кт 62",180000,"Дт 91.02",3000,null,"Кт 51",120000,"Дт 10",93220.34,null,"Кт 91.01",200000,"Дт 51",180000,null,null,"Сч 43","Готовая продукция"]
[7,"В течение месяца банк снимал с р/с услуги банка 3 000 руб",null,null,3000,91.2,51,{"$nulls":4},"Дт 60",120000,null,null,null,"Дт 19",16779.66,null,"Кт 90.01",60000,{"$nulls":4},"Сч 45","Товары отгруженные"]
[8,"Предприятие начислило транспортный налог 1 000 руб",null,null,1000,91.2,68.07,{"$nulls":18},"Сч 50","Касс"]
[9,"В ходе инвентаризации была выявлена недостача  10 000 руб",null,null,10000,94,10,{"$nulls":18},"Сч 51","Расчетный счет",null,null,180000,123000,57000]
[null,"материалов ?",null,null,10000,91.2,94,{"$nulls":18},"Сч 58","Финансовые вложения"]
[{"$nulls":9},"Оборот",180000,"Оборот",123000,null,"Оборот",120000,"Оборот",110000,null,"Оборот",260000,"Оборот",null,null,null,"Сч 60","Расчеты с поставщиками и подрядчиками",null,null,120000,110000,10000]
[10,"Финансовый результат",null,null,26787.46,99,90.09,null,null,"С-до ",57000,"С-до ",null,null,"С-до ",10000,"С-до ",null,null,"С-до ",80000,"С-до ",null,null,null,"Сч 62","Расчеты с покупателями и заказчиками",null,null,260000,180000,80000]
[null,"Внереализационные доходы",null,null,200000,91.1,99,{"$nulls":18},"Сч 66","Расчеты по кредитам и займам"]
[null,"Внереализационные расходы",null,null,124508.47,99,91.2,{"$nulls":18},"Сч 67","Долгосрочные кредиты и займы"]
[null,"Налог на прибыль",null,null,9740.81,99,68.03,null,null,"Счет 68.02 (НДС)",{"$nulls":4},"Счет 68.07 (Транспортный налог)",{"$nulls":4},"Счет 68.4 (налог на прибыль)",{"$nulls":5},"Сч 68","Расчеты по налогам и сборам"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч.68.2","НДС",null,null,21355.93,39661.01,null,18305.08]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч.68.4","Налог на прибыль",null,null,null,20183.05,null,20183.05]
[{"$nulls":9}," Кт 19",16779.66,"Дт 91.02",30508.47,null,null,null,"Дт 91.2",1000,null,null,null,"Дт 99",9740.82,null,null,"Сч.68.7","Транспортный налог",null,null,null,1000,null,1000]
[{"$nulls":9},"Кт 19",4576.27,"Дт 90.03",9152.54,{"$nulls":12},"Сч 69","Расчеты по социальному страхованию "]
[{"$nulls":25},"Сч 70","Расчеты с персоналом по оплате труда"]
[{"$nulls":25},"Сч 71","Расчеты с подотчетными лицами"]
[{"$nulls":25},"Сч 73","Расчеты с персоналом по прочим опер"]
[{"$nulls":25},"Сч 75","Расчеты с учредителями"]
[{"$nulls":25},"Сч 76","Расчеты с разными дебиторами и кредит.",null,null,null,30000,null,30000]
[{"$nulls":9},"Оборот",21355.93,"Оборот",39661.01,null,"Оборот",0,"Оборот",1000,null,"Оборот",0,"Оборот",9740.82,null,null,"Сч 80","Уставной капитал"]
[{"$nulls":9},"С-до ",null,"С-до ",18305.08,null,"С-до ",null,"С-до ",1000,null,"С-до ",null,"С-до ",9740.82,null,null,"Сч 81","Прочий капитал"]
[{"$nulls":25},"Сч 82","Резервный капитал"]
[{"$nulls":25},"Сч 83","Добавочный капитал"]
[{"$nulls":25},"сч 84","Нераспределенная прибыль (убыток)"]
[{"$nulls":9},"Счет 76",{"$nulls":4},"Счет 90.01",{"$nulls":4},"Счет 90.02",{"$nulls":5},"Сч 84.1","Прибыль подлежащая распределению"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 84.3","Использование прибыли"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 86","Целевое финансирование"]
[{"$nulls":11},"Дт 20",24060,null,"Кт 99",60000,"Дт 62",60000,null,"Кт 20",25423.73,"Дт 90.09",25423.73,null,null,"Сч 90","Продажи"]
[{"$nulls":11},"Дт 19",5940,{"$nulls":12},"Сч.90.01","Выручка ",null,null,null,60000,null,60000]
[{"$nulls":25},"Сч.90.02","Себестоимость продаж",null,null,25423.73,null,25423.73]
[{"$nulls":25},"Сч.90.03","НДС",null,null,9152.54,null,9152.54]
[{"$nulls":25},"Сч.90.09","Прибыль до налогообложения",null,null,25423.73,null,25423.73]
[{"$nulls":25},"Сч.91.01","Прочие доходы",null,null,null,200000,null,200000]
[{"$nulls":9},"Оборот",0,"Оборот",30000,null,"Оборот",60000,"Оборот",60000,null,"Оборот",25423.73,"Оборот",25423.73,null,null,"Сч.91.02","Прочие расходы",null,null,124508.47,null,124508.47]
[{"$nulls":9},"С-до",null,"С-до",30000,null,"С-до",0,"С-до",0,null,"С-до",0,"С-до",0,null,null,"Сч.91.09","Сальдо прочих доходов и расходов",null,null,75491.53,null,75491.53]
[{"$nulls":25},"Сч 94","Недостачи без виновных лиц",null,null,10000,10000]
[{"$nulls":25},"Сч 97","Доходы будущих периодов"]
[{"$nulls":9},"Счет 90.03",{"$nulls":4},"Счет 91.01",{"$nulls":4},"Счет 91.02",{"$nulls":5},"Сч.99","Прибыли и убытки",null,null,20183.05,100915.26,null,80732.21]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":9},"Кт 68.02",9152.54,"Дт 90.09",9152.54,null,"Кт 99",20000,"Дт 62",200000,null,"Кт 68.03",30508.47,"Дт 99",124508.47,null,null,null,"Итого",0,0,1011538.9800000001,1011538.9800000001,410220.3400000001,410220.34]
[{"$nulls":19},"Кт 10",80000]
[{"$nulls":19},"Кт 51",3000]
[{"$nulls":19},"Кт 68.07",1000]
[{"$nulls":19},"Кт 94",10000]
[]
[{"$nulls":9},"Оборот",9152.54,"Оборот",9152.54,null,"Оборот",20000,"Оборот",200000,null,"Оборот",124508.47,"Оборот",124508.47]
[{"$nulls":9},"С-до",0,"С-до",0,null,"С-до",0,"С-до",0,null,"С-до",0,"С-до",0]
[]
[]
[{"$nulls":9},"Счет 94",{"$nulls":4},"Счет 90.09",{"$nulls":4},"Счет 99"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":9},"Кт 10",10000,"Дт 91.02",10000,null,"Кт 90.02",25423.73,null,null,null,"Кт 91.02",124508.47,"Дт 91.01",200000]
[{"$nulls":14},"Кт 90.03",9152.54,null,null,null,"Кт 90.09",26787.46,"Дт 90.01",60000]
[{"$nulls":14},"Кт 99",25423.73,null,null,null,"Кт 68.03",9740.82]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",10000,"Оборот",10000,null,"Оборот",60000,"Оборот",0,null,"Оборот",161036.75,"Оборот",260000]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",38963.25]

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