{"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":126,"n_cols":38,"rows_kept":126,"cut":false,"hidden":false,"merged":[[22,0,23,0],[22,1,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[18,1,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,0,19,0],[20,4,21,4],[20,6,21,6],[20,5,21,5],[20,0,21,0],[14,1,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,0,15,0],[16,4,17,4],[16,5,17,5],[16,6,17,6],[16,1,17,3],[16,0,17,0],[10,0,11,0],[10,1,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[12,0,13,0],[12,1,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[6,4,7,4],[6,1,7,3],[6,0,7,0],[6,5,7,5],[6,6,7,6],[8,1,9,3],[8,5,9,5],[8,4,9,4],[8,6,9,6],[8,0,9,0],[103,9,103,10],[103,11,103,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],[103,14,103,15],[115,9,115,12],[116,9,116,10],[116,11,116,12],[103,16,103,17],[103,19,103,20],[103,21,103,22],[91,24,91,25],[91,26,91,27],[103,24,103,25],[103,26,103,27],[102,9,102,12],[102,14,102,17],[102,19,102,22],[102,24,102,27],[91,9,91,10],[91,11,91,12],[91,14,91,15],[91,16,91,17],[91,19,91,20],[91,21,91,22],[78,24,78,25],[78,26,78,27],[90,9,90,12],[90,14,90,17],[90,19,90,22],[90,24,90,27],[78,9,78,10],[78,11,78,12],[78,14,78,15],[78,16,78,17],[78,19,78,20],[78,21,78,22],[65,24,65,25],[65,26,65,27],[77,9,77,12],[77,14,77,17],[77,19,77,22],[77,24,77,27],[65,9,65,10],[65,11,65,12],[65,14,65,15],[65,16,65,17],[65,19,65,20],[65,21,65,22],[52,24,52,25],[52,26,52,27],[64,9,64,12],[64,14,64,17],[64,19,64,22],[64,24,64,27],[52,9,52,10],[52,11,52,12],[52,14,52,15],[52,16,52,17],[52,19,52,20],[52,21,52,22],[40,24,40,25],[40,26,40,27],[51,9,51,12],[51,14,51,17],[51,19,51,22],[51,24,51,27],[40,9,40,10],[40,11,40,12],[40,14,40,15],[40,16,40,17],[40,19,40,20],[40,21,40,22],[27,24,27,25],[27,26,27,27],[39,9,39,12],[39,14,39,17],[39,19,39,22],[39,24,39,27],[27,9,27,10],[27,11,27,12],[27,14,27,15],[27,16,27,17],[27,19,27,20],[27,21,27,22],[13,24,13,25],[13,26,13,27],[26,9,26,12],[26,14,26,17],[26,19,26,22],[26,24,26,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],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[20,1,21,3],[0,0,0,5],[1,0,1,6],[5,1,5,3],[3,1,4,3],[3,0,4,0],[3,4,4,4],[3,5,4,5],[3,6,4,6]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":29},"Оборотно-сальдовая ведомость"]
[{"$nulls":9},"Счет 50 Касса",{"$nulls":4},"Счет 51 Расчетный счет ",{"$nulls":4},"Счет 71 Расчеты с подотчетными лицами ",{"$nulls":4},"Счет 70 Расчеты по оплате труда",{"$nulls":5},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Дебет ","Кредит","Сумма",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"получены наличные средства с расчетного счета для выдачи зарабоной платы ",null,null,"Дт 50","Кт 51",500,null,null,"С-до",40,null,null,null,"с-до",900,"С-до",null,null,"С-до",30,{"$nulls":4},0,"С-до",500]
[{"$nulls":7},1,null,"1. (Кт 51)",500,"2. (Дт 70)",500,null,"6.(Кт 62)",200,"1.(Дт 50)",500,null,"4.(Кт 50)",20,"3. (Дт 50)",3,null,"2. (Дт 50)",500,"10.(Дт 20)",480,null,null,"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[2,"выдана заработная плата работникам производства ",null,null,"Дт 70","Кт 50",500,2,null,"3. (Кт 71)",3,"4.(Дт 71)",20,null,"9.(Кт 67)",600,"7.(Дт 60)",280,{"$nulls":6},"11.(Кт 68)",65,{"$nulls":6},"Дт","Кт","Дт","Кт","Дт","Кт"]
[3,"в кассу возвращены подотчетные суммы ",null,null,"Дт 50","Кт 71",3,{"$nulls":23},"Сч 01","Основные средства"]
[{"$nulls":7},3,{"$nulls":22},"Сч 02","Амортизация ОС"]
[4,"выдано в подотчет на приобретение канцелярских товаров ",null,null,"Дт 71","Кт 50",20,null,null,"Оборот",503,"Оборот",520,null,"Оборот",800,"Оборот",780,null,"Оборот",20,"Оборот",3,null,"Оборот",565,"Оборот",480,null,null,"Сч 04","Нематериальные активы"]
[{"$nulls":7},4,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до",null,null,"С-до ",null,"С-до",null,null,"С-до",{"$nulls":5},"Сч 05","Амортизация НМА"]
[5,"на предприятие поступили товары от поставщиков ",null,null,"Дт 41","Кт 60",380,{"$nulls":23},"Сч 08","Вложения во внеоб.акт"]
[{"$nulls":7},5,{"$nulls":22},"Сч 10","Материалы",1480,null,null,200,1280]
[6,"на расчетный счет поступили деньги от реализации материалов ",null,null,"Дт 51","Кт 62",200,null,null,"Счет 10 Материалы",{"$nulls":4},"Счет 20 Производство ",{"$nulls":4},"Счет 60 Расчеты с поставщиками ",{"$nulls":4},"Счет 62 Расчеты покупателей ",{"$nulls":5},"Сч 19","НДС по приобретенным МПЗ"]
[{"$nulls":7},6,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 20","Основное производство",80,null,480,null,560]
[7,"частично оплачен счет за товары,перечислено поставщикам ",null,null,"Дт 60","Кт 51",280,null,null,"С-до",1480,"С-до",null,null,"С-до",80,"С-до",null,null,"С-до",null,"С-до",200,null,"С-до",null,"С-до",710,null,null,"Сч 23","Вспомогательное производство"]
[{"$nulls":7},7,{"$nulls":6},"10. (Кт 70)",480,null,null,null,"7.(Кт 51)",280,"5. (Дт 41)",380,null,null,null,"6.(Дт 51)",200,null,null,"Сч 25","Общепроизводственные расходы"]
[8,"учредители решили увеличить уставной капитал ",null,null,"Дт 75","Кт 80",500,{"$nulls":23},"Сч 26","Общехозяйственные расходы"]
[{"$nulls":7},8,{"$nulls":22},"Сч 41","Товары на складах"]
[9,"был взят долгосрочный кредит банка ",null,null,"Дт 51","Кт 67",600,{"$nulls":23},"Сч 43","Готовая продукция"]
[{"$nulls":7},9,{"$nulls":22},"Сч 50","Касс",40,null,503,520,23]
[10,"начислена заработная плата работникам ",null,null,"Дт 20","Кт 70",480,{"$nulls":23},"Сч 51","Расчетный счет",900,null,800,845,855]
[{"$nulls":7},10,{"$nulls":22},"Сч 58","Финансовые вложения"]
[11,"удержан подоходный налог с заработной платы работников ",null,null,"Дт 70","Кт 68",65,null,null,"Оборот",0,"Оборот",0,null,"Оборот",480,"Оборот",0,null,"Оборот",280,"Оборот",380,null,"Оборот",0,"Оборот",200,null,null,"Сч 60","Расчеты с поставщиками и подрядчиками",null,200,280,380,null,300]
[{"$nulls":7},11,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч 62","Расчеты с покупателями и заказчиками"]
[{"$nulls":30},"Сч 66","Расчеты по кредитам и займам краткосроч",null,710,null,600,null,1310]
[{"$nulls":30},"Сч 67","Расчеты по кредитам и займам долгосроч"]
[{"$nulls":9},"Счет 68 Расчеты с бюджетом ",{"$nulls":4},"Счет 80 Уставный капитал ",{"$nulls":4},"Счет 41 Товары",{"$nulls":4},"Счет 44",{"$nulls":5},"Сч 68","Расчеты по налогам и сборам"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 69","Расчеты по социальному страхованию "]
[{"$nulls":9},"С-до",null,"С-до",0,null,"С-до",null,"С-до",800,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 70","Расчеты с персоналом по оплате труда",null,500,565,480,null,415]
[{"$nulls":11},"11.(Дт 70)",65,null,null,null,"8. (Дт 75)",500,null,"5. (Кт 60)",380,{"$nulls":9},"Сч 71","Расчеты с подотчетными лицами",30,null,20,3,47]
[{"$nulls":30},"Сч 73","Расчеты с персоналом по прочим опер"]
[{"$nulls":30},"Сч 75","Расчеты с учредителями"]
[{"$nulls":30},"Сч 76","Расчеты с разными дебиторами и кредит."]
[{"$nulls":30},"Сч 80","Уставной капитал",null,800,null,null,null,800]
[{"$nulls":30},"Сч 82","Резервный капитал",null,137,null,null,null,137]
[{"$nulls":9},"Оборот",0,"Оборот",65,null,"Оборот",0,"Оборот",500,null,"Оборот",380,"Оборот",0,null,"Оборот",0,"Оборот",0,null,null,"Сч 83","Добавочный капитал"]
[{"$nulls":9},"С-до ",null,"С-до ",0,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"сч 84","Нераспределенная прибыль (убыток)"]
[{"$nulls":30},"Сч 86","Целевое финансирование"]
[{"$nulls":30},"Сч 90","Продажи"]
[{"$nulls":9},"Счет 50",{"$nulls":4},"Счет 51",{"$nulls":4},"Счет 52",{"$nulls":4},"Счет 60",{"$nulls":5},"Сч 96","Резервы предстоящих расходов"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 97","Расходы будующих периодов"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 98","Доходы будущих периодов"]
[{"$nulls":30},"Сч 99","Прибыли и убытки (финансовый результ)",null,183,null,null,null,183]
[{"$nulls":31},"Кредит "]
[{"$nulls":31},"Итого",2530,2530,2648,3028,2765,3145]
[]
[]
[{"$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},"Счет 62",{"$nulls":4},"Счет 67 Кредиты",{"$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,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до"]
[{"$nulls":16},"9. (Дт 51)",600]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",600,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",null,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,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":24},"8.( Кт 80)",500]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",500,"Оборот",0]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,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,"С-до",null,null,"С-до",null,"С-до",137,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},"Счет 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":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},"Счет 99"]
[{"$nulls":9},"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",183]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",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"]}