{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["оборотка","ШАХМАТКА"],"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":"оборотка","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,1,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]],"flags":["formulas_cached_only"]}
["Таблица 1-Состояние активов и обязательств ООО \"_____\""]
["01.01.200___г. и обороты за январь-ноябрь 200___ г.по счетам синтетического "]
["учета"]
["(выписка из Главной книги)"]
[]
["Наименование счета","Шифр счета","Остаток на 01.01.___",null,"Обороты за январь-ноябрь 200___",null,"Остаток на 01.12.____"]
[null,null,"Д-т","К-т","Д-т","К-т","Д-т","К-т"]
[1,2,3,4,5,6,7,8]
["Основные средства","01",1790910,null,184868,null,1975778]
["Амортизация основных средств","02",null,579563,null,85279,null,664842]
["Нематериальные активы","04",{"$nulls":4},0]
["Амортизация нематериальных активов","05",{"$nulls":5},0]
["Строительство объектов основных средств","08-3",null,null,184868,184868,0,0]
["Приобретение объектов основных средств","08-4",{"$nulls":4},0,0]
["Приобретение нематериальных активов","08-5",{"$nulls":4},0,0]
["Материалы","10",null,null,30000,30000,0]
["НДС по приобретенным основным средствам","19-1",{"$nulls":4},0,0]
["НДС по приобретенным нематериальным активам","19-2",{"$nulls":4},0,0]
["НДС по приобретенным материально-производственным запасам","19-3",{"$nulls":4},0]
["Основное производство в т.ч.","20",null,null,81988,null,81988]
[" изделие \"А\"",{"$nulls":5},0]
["изделие \"Б\"",{"$nulls":5},0]
["Общепроизводственные расходы","25",{"$nulls":4},0,0]
["Общехозяйственные расходы","26",null,null,130845,130845,0,0]
["Готовая продукция","43",{"$nulls":4},0]
["Расходы на продажу","44",null,null,154996,154274,722,0]
["Касса","50",9800,null,225610,225610,9800]
["Расчетный счет","51",3869844,null,9970000,10218091,3621753]
["Расчеты с поставщиками и подрядчиками","60",null,null,9920000,12854868,null,2934868]
["Расчеты по авнсам выданным","60-2",{"$nulls":4},0,0]
["Расчеты с покупателями и заказчиками","62",null,null,12110000,9970000,2140000]
["Расчеты по авансам полученным","62-2",{"$nulls":5},0]
["Расчеты по краткосрочным кредитам и займам","66",{"$nulls":5},0]
["Расчеты по налогам и сборам","68",null,27700,24317,153623,null,157006]
["Расчеты по социальному страхованию и обеспечению","69",null,12620,58085,64169,null,18704]
["расчеты с персоналом по оплате труда","70",null,89000,250346,190271,null,28925]
["Расчеты с подотчетными лицами","71",{"$nulls":4},0]
["Расчеты с персоналом по прочим операциям","73",{"$nulls":4},0]
["Расчеты с разными дебиторами и кредиторами","76"]
["Уставный капитал","80",null,100000,null,null,null,100000]
["Резервный капитал","82",{"$nulls":5},0]
["Добавочный капитал","83",{"$nulls":5},0]
["Нераспределенная прибыль(непокрытый убыток)","84",null,4861671,null,null,null,4861671]
["Продажи в том числе выручка","90         90-1",null,null,null,12110000,null,12110000]
["Себестоимость продаж","90-2",null,null,8811353]
["НДС","90-3"]
["Общехозяйственные расходы","90-5"]
["Коммерческие расходы","90-6"]
["Прибыль(убыток) от продаж","90-9",null,null,3289453]
["Прочие доходы и расходы в т.ч. прочие доходы","91          91-1"]
["Прочие расходы","91-2"]
["Сальдо прочих доходов и расходов","91-9",{"$nulls":4},0]
["Прибыли и убытки","99",null,null,128887,3289453,null,3160566]
["Итого:",null,5670554,5670554,45555616,49661351,7830041,24036582]
["проверка разницы"]
[null,null,0,null,-4105735,null,-16206541]

{"sheet":"ШАХМАТКА","index":1,"n_rows":49,"n_cols":35,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,34,3,34]],"flags":["formulas_cached_only"]}
[]
[null,"Таблица -Шахматная ведомость"]
[null,"С кредита счетов","01","02","08","09","10","19","20-1","20-2","25","26","50","51","60-1","60-2","62-1","66","68","69","70","71","76","84","90-1","90-2","90-3","90-5","90-6","90-9","91-1","91-2","91-9",99,"Итого по дебету счетов"]
[null,"В дебет счетов"]
[]
[null,"01"]
[null,"02"]
[null,"04"]
[null,"05"]
[null,"08"]
[null,"09"]
[null,"10"]
[null,"19"]
[null,"20-1"]
[null,"20-2"]
[null,"25"]
[null,"26"]
[null,"43"]
[null,"50"]
[null,"51"]
[null,"60-1"]
[null,"62-1"]
[null,"62-2"]
[null,"66"]
[null,"66"]
[null,"67"]
[null,"68"]
[null,"69"]
[null,"70"]
[null,"71"]
[null,"73"]
[null,"75"]
[null,"76"]
[null,"80"]
[null,"81"]
[null,"83"]
[null,"84"]
[null,"82"]
[null,"90-1"]
[null,"90-2"]
[null,"90-3"]
[null,"90-5"]
[null,"90-6"]
[null,"90-9"]
[null,"91-1"]
[null,"91-2"]
[null,"91-9"]
[null,"99"]
[null,"Итого по кредиту счетов:"]