{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":[[14,1,14,3],[0,0,0,5],[1,0,1,6],[4,1,4,3],[5,1,5,3],[7,1,7,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],[17,1,17,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],[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],[32,1,32,3],[33,1,33,3],[34,1,34,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],[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],[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],[2,24,2,25],[2,26,2,27],[12,9,12,12],[12,14,12,17],[12,19,12,22],[12,24,12,27],[30,9,30,12],[30,14,30,17],[30,19,30,22],[30,24,30,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],[31,14,31,15],[31,16,31,17],[31,19,31,20],[31,21,31,22],[13,24,13,25],[13,26,13,27],[49,19,49,20],[49,21,49,22],[31,24,31,25],[31,26,31,27],[48,9,48,12],[48,14,48,17],[48,19,48,22],[48,24,48,27],[31,9,31,10],[31,11,31,12],[49,24,49,25],[49,26,49,27],[71,9,71,12],[71,14,71,17],[71,19,71,22],[71,24,71,27],[49,9,49,10],[49,11,49,12],[49,14,49,15],[49,16,49,17],[89,9,89,12],[89,14,89,17],[89,19,89,22],[89,24,89,27],[72,9,72,10],[72,11,72,12],[72,14,72,15],[72,16,72,17],[72,19,72,20],[72,21,72,22],[90,14,90,15],[90,16,90,17],[90,19,90,20],[90,21,90,22],[72,24,72,25],[72,26,72,27],[108,19,108,20],[108,21,108,22],[90,24,90,25],[90,26,90,27],[107,9,107,12],[107,14,107,17],[107,19,107,22],[107,24,107,27],[90,9,90,10],[90,11,90,12],[108,24,108,25],[108,26,108,27],[120,9,120,12],[120,14,120,17],[120,19,120,22],[120,24,120,27],[108,9,108,10],[108,11,108,12],[108,14,108,15],[108,16,108,17],[132,9,132,12],[132,14,132,17],[132,19,132,22],[132,24,132,27],[121,9,121,10],[121,11,121,12],[121,14,121,15],[121,16,121,17],[121,19,121,20],[121,21,121,22],[133,16,133,17],[133,19,133,20],[133,21,133,22],[121,24,121,25],[121,26,121,27],[133,24,133,25],[133,26,133,27],[145,9,145,12],[145,14,145,17],[146,9,146,10],[146,11,146,12],[146,14,146,15],[146,16,146,17],[133,9,133,10],[133,11,133,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],[133,14,133,15]],"flags":["formulas_cached_only"]}
["Журная финансово-хозяйственных операций ",{"$nulls":29},"Оборотно-сальдовая ведомость"]
[{"$nulls":9},"Счет 01",{"$nulls":4},"Счет 02",{"$nulls":4},"Счет 04",{"$nulls":4},"Счет 05",{"$nulls":5},"за __________________ 201____ г"]
["№ п/п","Наименование операции",null,null,"Сумма","Дт ","Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Получены деньги с р/счета для выплаты зарплаты",null,null,210000,"Дт 50","Кт 51",null,null,"С-до",4580030,{"$nulls":5},"С-до",2246499,null,"С-до",146500,{"$nulls":4},0,"С-до",26500]
[2,"Выдана из кассы заработная плата ",null,null,205000,"Дт 70","Кт 50",{"$nulls":9},"Дт20",70000,{"$nulls":12},"Счет №","Наименование","С-до на нач.",null,"Обороты за период",null,"С-до на конец"]
[3,"Невыплаченная заработная плата возвращена на р/счет",null,null,5000,"Дт 51","Кт 50",{"$nulls":9},"Дт26",32000,{"$nulls":14},"Дт","Кт","Дт","Кт","Дт","Кт"]
[4,"Депонированная заработная плата",null,null,5000,"Дт 70","Дт 76.4",{"$nulls":23},"Сч 01","Основные средства",4580030,null,null,null,4580030]
[5,"Поступили на склад материалы акцептованные",null,null,120000,"Дт 10","Кт 60",{"$nulls":23},"Сч 02","Амортизация ОС",null,2246499,null,102000,null,2348499]
[null,"НДС 18%",null,null,21600,"Дт 19","Кт 60",null,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",102000,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,null,"Сч 04","Нематериальные активы",146500,null,null,null,146500]
[6,"Оплачено поставщикам за материалы с р/счета",null,null,141600,"Дт 60 ","Кт 51",null,null,"С-до ",4580030,"С-до ",null,null,"С-до ",null,"С-до",2348499,null,"С-до ",146500,"С-до",null,null,"С-до",null,"С-до",26500,null,null,"Сч 05","Амортизация НМА",null,26500,null,null,null,26500]
[7,"Списан (возмещен) НДС по пошученным поставкам",null,null,21600,"Дт 68","Кт 19",{"$nulls":23},"Сч 08","Вложения во внеоб.акт"]
[8,"Отпущены    в    производство    и израсходованы материалы на:\n-изготовление продукции",null,null,115000,"Дт20","Кт10",{"$nulls":23},"Сч 10","Материалы",1747550,null,120000,165000,1702550]
[null,"общехозяйственные нужды",null,null,50000,"Дт26","Кт10",null,null,"Счет 10",{"$nulls":4},"Счет 19",{"$nulls":4},"Счет 20",{"$nulls":4},"Счет 25",{"$nulls":5},"Сч 19","НДС по приобретенным МПЗ",113913,null,27000,27000,113913]
[9,"Поступила на р/с сумма в уплату за ранее отгруженную продукцию",null,null,400000,"Дт51","Кт62",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 20","Основное производство",34640,null,528700,513600,49740]
[10,"Начислена амортизация основных средств",{"$nulls":7},"С-до",1747550,"С-до",null,null,"С-до",113913,"С-до",null,null,"С-до",34640,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 23","Вспомогательное производство"]
[null,"основного производства",null,null,70000,"Дт20","Кт02",null,null,"Кт 60",120000,null,null,null,"Кт 60",21600,"Дт 68",21600,null,"Кт10",115000,"Дт43",513600,{"$nulls":7},"Сч 25","Общепроизводственные расходы"]
[null,"АУП",null,null,32000,"Дт26","Кт02",{"$nulls":4},"Дт20",115000,null,"Кт60",5400,"Дт68",5400,null,"Кт02",70000,{"$nulls":9},"Сч 26","Общехозяйственные расходы",null,null,190900,190900]
[11,"Начислена оплата труда",{"$nulls":9},"Дт26",50000,{"$nulls":6},"Кт70",115000,{"$nulls":9},"Сч 41","Товары на складах"]
[null,"рабочим за изготовление продукции",null,null,115000,"Дт20","Кт70",{"$nulls":12},"Кт69",34500,{"$nulls":9},"Сч 43","Готовая продукция",1191800,null,513600,650000,1055400]
[null,"АУП",null,null,53000,"Дт26","Кт70",{"$nulls":12},"Кт71",3300,{"$nulls":9},"Сч 50","Касс",10508,null,210000,210000,10508]
[12,"Произведены отчисления един.соц.налога от ЗП 30%",{"$nulls":17},"Кт26",190900,{"$nulls":9},"Сч 51","Расчетный счет",380727,null,405000,582600,203127]
[null,"рабочих за изготовление продукции",null,null,34500,"Дт20","Кт69",{"$nulls":23},"Сч 58","Финансовые вложения",140000,null,null,null,140000]
[null,"АУП",null,null,15900,"Дт26","Кт69",{"$nulls":23},"Сч 60","Расчеты с поставщиками и подрядчиками",null,1162586,237000,177000,null,1102586]
[13,"Произведены удержания из ЗП",{"$nulls":28},"Сч 62","Расчеты с покупателями и заказчиками",729470,null,900000,400000,1229470]
[null,"НДФЛ 13%",null,null,20000,"Дт70","Кт68",{"$nulls":23},"Сч 66","Расчеты по кредитам и займам",null,1467370,55000,0,null,1412370]
[null,"по исполнительным документам",null,null,3100,"Дт70","Кт76",{"$nulls":23},"Сч 68","Расчеты по налогам и сборам",null,186800,43000,157288,null,301088]
[14,"Перечислено с Р/с",{"$nulls":7},"Оборот",120000,"Оборот",165000,null,"Оборот",27000,"Оборот",27000,null,"Оборот",528700,"Оборот",513600,null,"Оборот",0,"Оборот",0,null,null,"Сч 69","Расчеты по социальному страхованию ",null,198750,60000,50400,null,189150]
[null,"в оплату за услуги общехоз.назначения",null,null,60000,"Дт26","Кт51",null,null,"С-до",1702550,"С-до",null,null,"С-до",113913,"С-до",null,null,"С-до ",49740,"С-до ",null,null,"С-до ",null,"С-до ",null,null,null,"Сч 70","Расчеты с персоналом по оплате труда",null,381595,233100,168000,null,316495]
[null,"по исполнительным документам",null,null,4600,"Дт76","Кт51",{"$nulls":23},"Сч 71","Расчеты с подотчетными лицами",4300,null,0,3300,1000]
[null,"НДФЛ ",null,null,16000,"Дт68","Кт51",{"$nulls":23},"Сч 73","Расчеты с персоналом по прочим опер",128000]
[null,"ЕСН",null,null,60000,"Дт69","Кт51",null,null,"Счет 26",{"$nulls":4},"Счет 41",{"$nulls":4},"Счет 43",{"$nulls":4},"Счет 44",{"$nulls":5},"Сч 75","Расчеты с учредителями"]
[15,"произведены отчисления в резерв ремонт ОС общехоз.назначения",null,null,40000,"Дт26","Кт96",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,null,"Сч 76","Расчеты с разными дебиторами и кредит.",25050,28726,4600,8100,21550,32226]
[16,"Списаны командировочные расходы",null,null,3300,"Дт20","Кт71",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",1191800,"С-до",null,null,"С-до",null,"С-до",null,null,null,"Сч 80","Уставной капитал",null,1500000,null,null,null,1500000]
[17,"Списаны общехоз. Расходы на себ-ть продукции основ.пр-ва",null,null,250900,"Дт20","Кт26",null,null,"Кт10",50000,"Дт20",190900,{"$nulls":6},"Кт20",513600,"Дт90",650000,null,"Кт60",30000,"Дт90",30000,null,null,"Сч 82","Резервный капитал",null,360000,null,null,null,360000]
[18,"Выпущена из производства и оприходована на склад готовая продукция фактической производственной себестоимости.\n(Затраты в незавершённом на конец месяца составили 15100 рублей!",null,null,513600,"Дт43","Кт20",null,null,"Кт02",32000,{"$nulls":19},"Сч 83","Добавочный капитал",null,1393230,null,null,null,1393230]
[19,"Отгружена ГП покупателям по ценам реализации, включая НДС",null,null,900000,"Дт62","Кт90",null,null,"Кт70",53000,{"$nulls":19},"сч 84","Нераспределенная прибыль (убыток)",null,322032,null,null,null,322032]
[20,"Начислен НДС  18/118",null,null,137288,"Дт90","Кт68",null,null,"Кт69",15900,{"$nulls":19},"Сч 86","Целевое финансирование"]
[21,"Списана себестоимость покупателям продукции",null,null,650000,"Дт90","Кт43",{"$nulls":23},"Сч 90","Продажи",null,null,900000]
[22,"Начислено к оплате транспортной компании за перевозку продукции",null,null,30000,"Дт44","Кт60",null,null,"Кт96",40000,{"$nulls":19},"Сч 96","Резервы предстоящих расходов",null,null,null,40000,null,40000]
[null,"НДС 18%",null,null,5400,"Дт19","Кт60",{"$nulls":23},"Сч 97","Расходы будующих периодов",41600,null,null,null,41600]
[23,"Оплачен счет траспортной организации",null,null,35400,"Дт60","Кт51",{"$nulls":23},"Сч 98","Доходы будущих периодов"]
[24,"Списан(возмещен) НДС по оплаченному счету за услуги",null,null,5400,"Дт68","Кт19",{"$nulls":23},"Сч 99","Прибыли и убытки (финансовый результ)",null,null,null,82712,null,82712]
[25,"Списаны расходы на продажу",null,null,30000,"Дт90","Кт44"]
[26,"Определен и списан фин.результат от продажи продукции",null,null,82712,"Дт90","Кт99",{"$nulls":24},"Итого",9274088,9274088,4427900,3527900,9295388,9426888]
[27,"Перечислено банку в погашение краткосрочного кредита",null,null,55000,"Дт66","Кт51",null,null,"Оборот",190900,"Оборот",190900,null,"Оборот",0,"Оборот",0,null,"Оборот",513600,"Оборот",650000,null,"Оборот",30000,"Оборот",30000]
[{"$nulls":9},"С-до ",0,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",1055400,"С-до ",null,null,"С-до ",0,"С-до "]
[]
[]
[{"$nulls":9},"Счет 50",{"$nulls":4},"Счет 51",{"$nulls":4},"Счет 58",{"$nulls":4},"Счет 60"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",10508,"С-до",null,null,"С-до",380727,"С-до",null,null,"С-до",140000,"С-до",null,null,"С-до",null,"С-до",1162586]
[{"$nulls":9},"Кт 51",210000,"Дт 70",205000,null,"Кт 50",5000,"Дт 50",210000,{"$nulls":6},"Кт 51",141600,"Дт 10",120000]
[{"$nulls":11},"Дт 51",5000,null,"Кт62",400000,"Дт 60",141600,{"$nulls":6},"Кт51",35400,"Дт 19",21600]
[{"$nulls":16},"Дт26",60000,{"$nulls":6},"Кт51",60000,"Дт44",30000]
[{"$nulls":16},"Дт76",4600,{"$nulls":8},"Дт19",5400]
[{"$nulls":16},"Дт68",16000]
[{"$nulls":16},"Дт69",60000]
[{"$nulls":16},"Дт60",35400]
[{"$nulls":16},"Дт66",55000]
{"$rows_empty":8}
[{"$nulls":9},"Оборот",210000,"Оборот",210000,null,"Оборот",405000,"Оборот",582600,null,"Оборот",0,"Оборот",0,null,"Оборот",237000,"Оборот",177000]
[{"$nulls":9},"С-до ",10508,"С-до ",null,null,"С-до ",203127,"С-до ",null,null,"С-до ",140000,"С-до ",null,null,"С-до ",null,"С-до ",1102586]
[]
[]
[{"$nulls":9},"Счет 62",{"$nulls":4},"Счет 66",{"$nulls":4},"Счет 68",{"$nulls":4},"Счет 68 (?)"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",729470,"С-до",null,null,"С-до",null,"С-до",1467370,null,"С-до",null,"С-до",186800,null,"С-до"]
[{"$nulls":9},"Кт90",900000,"Дт51",400000,null,"КТ51",55000,null,null,null,"Кт19",21600,"Дт70",20000]
[{"$nulls":19},"Кт51",16000,"Дт90",137288]
[{"$nulls":19},"Кт19",5400]
{"$rows_empty":8}
[{"$nulls":9},"Оборот",900000,"Оборот",400000,null,"Оборот",55000,"Оборот",0,null,"Оборот",43000,"Оборот",157288,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",1229470,"С-до ",null,null,"С-до ",null,"С-до ",null,null,"С-до ",null,"С-до ",301088,null,"С-до ",null,"С-до "]
[]
[]
[{"$nulls":9},"Счет 69",{"$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,"С-до",198750,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":9},"Кт51",60000,"Дт20",34500]
[{"$nulls":11},"Дт26",15900]
{"$rows_empty":9}
[{"$nulls":9},"Оборот",60000,"Оборот",50400,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до ",null,"С-до ",189150,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,"С-до",381595,null,"С-до",4300,"С-до",null,null,"С-до",128000,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":9},"Кт 50",205000,"Дт20",115000,null,null,null,"Дт20",3300]
[{"$nulls":9},"Кт 76.4",5000,"Дт26",53000]
[{"$nulls":9},"Кт68",20000]
[{"$nulls":9},"Кт76",3100]
[]
[{"$nulls":24},"Оборот",0,"Оборот",0]
[{"$nulls":9},"Оборот",233100,"Оборот",168000,null,"Оборот",0,"Оборот",3300,null,"Оборот",0,"Оборот",0,null,"С-до",null,"С-до"]
[{"$nulls":9},"С-до",null,"С-до",316495,null,"С-до",1000,"С-до",null,null,"С-до",128000,"С-до"]
[]
[]
[{"$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},"С-до",25050,"С-до",28726,null,"С-до",null,"С-до",1500000,null,"С-до",null,"С-до",360000,null,"С-до",null,"С-до",1393230]
[{"$nulls":9},"Кт51",4600,"Дт 70",5000]
[{"$nulls":11},"Дт70",3100]
[]
[]
[]
[{"$nulls":9},"Оборот",4600,"Оборот",8100,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",21550,"С-до",32226,null,"С-до",null,"С-до",1500000,null,"С-до",null,"С-до",360000,null,"С-до",null,"С-до",1393230]
[]
[]
[{"$nulls":9},"Счет 84",{"$nulls":4},"Счет 97",{"$nulls":4},"Счет 90",{"$nulls":4},"Счет 91"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",322032,null,"С-до",41600,"С-до",null,null,"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":19},"Кт68",137288,"Дт62",900000]
[{"$nulls":19},"Кт43",650000]
[{"$nulls":19},"Кт44",30000]
[{"$nulls":19},"Кт99",82712]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",0,null,"Оборот",0,"Оборот",0,null,"Оборот",900000,"Оборот",900000,null,"Оборот",0,"Оборот",0]
[{"$nulls":9},"С-до",null,"С-до",322032,null,"С-до",41600,"С-до",null,null,"С-до",0,"С-до",null,null,"С-до",null,"С-до"]
[]
[]
[{"$nulls":9},"Счет 99",{"$nulls":4},"счет 96"]
[{"$nulls":9},"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до"]
[{"$nulls":11},"Дт90",82712,null,null,null,"Дт26",40000]
[]
[]
[]
[]
[]
[{"$nulls":9},"Оборот",0,"Оборот",82712,null,"Оборот",null,"Оборот",40000]
[{"$nulls":9},"С-до",null,"С-до",null,null,"С-до",null,"С-до",40000]

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