{"text_format":"2","workbook":"xlsx","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"}

{"sheet":"Лист1","index":0,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[77,6,77,9],[78,6,78,7],[78,8,78,9],[64,6,64,9],[65,6,65,7],[65,8,65,9],[64,11,64,14],[65,11,65,12],[65,13,65,14],[52,6,52,9],[53,6,53,7],[53,8,53,9],[52,11,52,14],[53,11,53,12],[53,13,53,14],[40,11,40,14],[41,11,41,12],[41,13,41,14],[28,11,28,14],[29,11,29,12],[29,13,29,14],[40,6,40,9],[41,6,41,7],[41,8,41,9],[25,0,29,0],[25,2,26,2],[25,3,26,3],[25,4,26,4],[28,1,29,1],[2,0,3,0],[2,3,3,3],[15,0,16,0],[15,1,16,1],[15,3,15,4],[15,6,15,9],[16,6,16,7],[16,8,16,9],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,6,28,9],[29,6,29,7],[29,8,29,9],[15,11,15,14],[16,11,16,12],[16,13,16,14],[2,13,2,16],[3,13,3,14],[3,15,3,16],[2,8,2,11],[3,8,3,9],[3,10,3,11]]}
["1)       На основании баланса на 1 июля открыть синтетические счета (схематично)."]
["Баланс  АО «Победа» на 1 июля (руб.):"]
["№ п/п","Наименование статей","Сумма","№ п/п","Наименование статей","Сумма",null,null,"Счет 01",{"$nulls":4},"Счет 10,3"]
[null,"(Актив)","(руб.)",null,"(Пассив)","(руб.)",null,null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Основные средства        (01)",400940,1,"Уставный капитал   (80)",540869,null,null,"С-до",400940,"С-до","-",null,"С-до",4230,"С-до","-"]
[2,"Материалы (топливо)   (10,3)",4230,2,"Амортизация основных средств   (20)",48000,{"$nulls":7},"счет 60",10000]
[3,"Материалы (сырье)     (10,1)",10619,3,"Расчеты с персоналом  по оплате труда     (70)",13270]
[4,"Основное производство   (20)",148750,4,"Расчеты с поставщиками  и подрядчиками (60)",7000]
[5,"Расчетный счет   (51)",43600]
[6,"Касса     (50)",1000]
[null,"Итого",609139,null,"Итого",609139]
[{"$nulls":8},"Оборот",{"$f":"SUM(J6:J8)","v":0},"Оборот",{"$f":"SUM(L6:L11)","v":0},null,"Оборот",{"$f":"SUM(O6:O8)","v":10000},"Оборот",{"$f":"SUM(Q6:Q11)","v":0}]
["2)       Составить корреспонденцию счетов по следующим хозяйственным операциям.",{"$nulls":7},"С-до ",400940,"С-до",null,null,"С-до ",14230,"С-до"]
["Хозяйственные операции АО “Победа” за июль:"]
[]
["№ п/п","Содержание операции","Сумма","Корр.счетов",null,null,"Счет 10,1",{"$nulls":4},"Счет 20"]
[null,null,"(руб.)","дебет","кредит",null,"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[1,"Акцептован счет нефтебазы за поступившее топливо",10000,10.3,60,null,"С-до",10619,"С-до","-",null,"С-до",148750,"С-до","-"]
[2,"Перечислено с расчетного счета нефтебазе за топливо","???Я думаю,что 10000",60,51,null,null,null,"счет 20",1360,null,"счет10,1",1360]
[3,"Списано на производство сырье",1360,20,10.1,{"$nulls":6},"счет 70",15000,"счет43",33100]
[4,"Начислена заработная плата рабочим основного производства",15000,20,70,{"$nulls":6},"счет 69,1",600]
[5,"Удержан из заработной платы налог на доходы физических лиц",2500,70,68,{"$nulls":6},"Счет 69,2",4200]
[6,"Получены наличные деньги в кассу с расчетного счета для выдачи заработной платы",12500,50,51,{"$nulls":6},"Счет 69,3",540]
[7,"Выдана из кассы заработная плата работникам",12500,70,50,{"$nulls":6},"счет 02",2300]
[8,"Перечислен с расчетного счета  в бюджет налог на доходы физических лиц",2500,68,51,null,"Оборот",{"$f":"SUM(H19:H21)","v":0},"Оборот",{"$f":"SUM(J19:J24)","v":1360},null,"Оборот",24000,"Оборот",{"$f":"SUM(O19:O24)","v":33100}]
[9,"Начислен ЕСН:",600,20,null,null,"С-до ",9259,"С-до",null,null,"С-до ",139650,"С-до"]
[null,"-          в фонд социального страхования  (4 %)"]
[null,"-          в пенсионный фонд (28 %)",4200,20,69.2]
[null,"-          в фонд обязательного медицинского страхования (3,6%)",540,20,69.3,null,"Счет 51",{"$nulls":4},"Счет 50"]
[{"$nulls":6},"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[10,"Перечислен ЕСН",5340,69,"20     51",null,"С-до",43600,"С-до","-",null,"С-до",1000,"С-до","-"]
[11,"Начислена амортизация по основным производственным фондам",2300,20,2,null,null,null,"счет60",10000,null,"счет51",12500,"счет 70",12500]
[12,"Выпущена готовая продукция из производства",33100,43,20,null,null,null,"счет 50",12500]
[{"$nulls":8},"счет 68",2500]
["3)       Записать хозяйственные операции на синтетические счета (запись схематическая).",{"$nulls":7},"счет 69",5340]
["4)      Подсчитать по  синтетическим счетам обороты, вывести сальдо по счетам на 1 августа."]
[]
[{"$nulls":6},"Оборот",{"$f":"SUM(H32:H34)","v":0},"Оборот",{"$f":"SUM(J32:J37)","v":30340},null,"Оборот",{"$f":"SUM(M32:M34)","v":12500},"Оборот",{"$f":"SUM(O32:O37)","v":12500}]
[{"$nulls":6},"С-до ",13260,"С-до",null,null,"С-до ",1000,"С-до"]
[]
[{"$nulls":6},"Счет 80",{"$nulls":4},"Счет 02"]
[{"$nulls":6},"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":6},"С-до",null,"С-до",540869,null,"С-до",null,"С-до",48000]
[{"$nulls":13},"счет20",2300]
[]
[]
[]
[]
[]
[{"$nulls":6},"Оборот",{"$f":"SUM(H44:H46)","v":0},"Оборот",{"$f":"SUM(J44:J49)","v":0},null,"Оборот",{"$f":"SUM(M44:M46)","v":0},"Оборот",{"$f":"SUM(O44:O49)","v":2300}]
[{"$nulls":6},"С-до ",null,"С-до",540869,null,"С-до ",null,"С-до",50300]
[]
[{"$nulls":6},"Счет 70",{"$nulls":4},"Счет 60"]
[{"$nulls":6},"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":6},"С-до",null,"С-до",13270,null,"С-до",null,"С-до",7000]
[{"$nulls":6},"счет 68",2500,"счет 20",15000,null,"счет 51",10000,"счет 10,3",10000]
[{"$nulls":6},"счет 50",12500]
[]
[]
[]
[]
[{"$nulls":6},"Оборот",{"$f":"SUM(H56:H58)","v":15000},"Оборот",{"$f":"SUM(J56:J61)","v":15000},null,"Оборот",{"$f":"SUM(M56:M58)","v":10000},"Оборот",{"$f":"SUM(O56:O61)","v":10000}]
[{"$nulls":6},"С-до ",null,"С-до",13270,null,"С-до ",null,"С-до",7000]
[]
[{"$nulls":6},"Счет 68",{"$nulls":4},"Счет 69"]
[{"$nulls":6},"Дт",null,"Кт",null,null,"Дт",null,"Кт"]
[{"$nulls":6},"С-до",null,"С-до","-",null,"С-до",null,"С-до","-"]
[{"$nulls":6},"счет 51",2500,"счет 70",2500,null,null,null,"счет 20",600]
[{"$nulls":12},5340,"счет 20",4200]
[{"$nulls":13},"счет 20",540]
[]
[]
[]
[{"$nulls":6},"Оборот",{"$f":"SUM(H68:H70)","v":2500},"Оборот",{"$f":"SUM(J68:J73)","v":2500},null,"Оборот",{"$f":"SUM(M68:M70)","v":5340},"Оборот",{"$f":"SUM(O68:O73)","v":5340}]
[{"$nulls":6},"С-до ",0,"С-до",0,null,"С-до ",null,"С-до"]
[]
[]
[{"$nulls":6},"Счет 43"]
[{"$nulls":6},"Дт",null,"Кт"]
[{"$nulls":6},"С-до",null,"С-до","-"]
[{"$nulls":6},"счет20",33100]
[]
[]
[]
[]
[]
[{"$nulls":6},"Оборот",{"$f":"SUM(H81:H83)","v":33100},"Оборот",{"$f":"SUM(J81:J86)","v":0}]
[{"$nulls":6},"С-до ",33100,"С-до"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}