{"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":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[36,8,36,10],[17,3,17,4],[34,2,34,3],[34,6,34,7],[34,4,34,5],[14,1,14,4],[17,7,17,8],[12,5,12,9],[17,11,17,12],[25,3,25,4],[25,7,25,8],[15,2,15,8],[17,15,17,16]],"flags":["formulas_cached_only"]}
[]
[null,"Журнал операций"]
[]
["№","п/п Содержание хоз.операции ","Дт","Кт","Сумма"]
[1,"Приобретены материалы:"]
["а) ","по покупной стоимости ",10,60,300000]
["б) ","на сумму НДС ","19/3",60,54000]
[2,"Приобретено основное средство:"]
["а) ","по покупной стоимости ","08/4","60",200000]
["б) ","на сумму НДС ","19/1","60",36000]
[3,"Введено в эксплуатацию осн.ср-во ","01","08/4",200000]
[4,"Оплачен счет поставщика ","60","51",590000]
[5,"Возмещен НДС из бюджета ","68","19",90000,"возмещен НДС, значит нам поступили деньги, а деньги Юр.Лицу поступают на р/с в банке, значит не сч. 19, а сч. 51. Исправьте."]
[]
[null,"Затем необходимо составить главную книгу. В виде вот таких табличек (это пример):"]
[null,null,"По такому же подобию, как в примере делает самолетики (или Т-счета на все Дт и Кт, которые указаны у вас в Журнале операций. Сделаю несколько примеров, а дальше попробуйте сами:"]
[null,"Дт 10 Кт"]
[null,"______________",null,"Счет 01",null,null,null,"Счет 10",null,null,null,"Счет 08/4",null,null,null,"Счет 19"]
[null,"3001 !",null,"Дт","Кт",null,null,"Дт","Кт",null,null,"Дт","Кт",null,null,"Дт","Кт"]
[null,"1) 400 ! 3) 601","Остаток на начало:",0,null,null,"Остаток на начало:",0,null,null,"Остаток на начало:",0,null,null,"Остаток на начало:",0]
[null,"401 ! 600",{"$nulls":4},"1а)",300000,null,null,"2а)","?",null,null,"1б)",54000]
[null,2801,{"$nulls":12},"2б)","?"]
[null,null,"Остаток на конец:",0,0,null,"Остаток на конец:",300000,0,null,"Остаток на конец:",0,0,null,"Остаток на конец:",54000,0]
[]
[]
[null,null,null,"Счет 60",null,null,null,"Счет 51"]
[null,null,null,"Дт","Кт",null,null,"Дт","Кт"]
[null,null,"Остаток на начало:",null,0,null,"Остаток на начало:",0]
[null,null,"1а)",null,300000]
[null,null,"1б)",null,54000]
[null,null,"Остаток на конец:",0,354000,null,"Остаток на конец:",0,0]
[]
[]
[null,"Баланс- я начала, вы попробуйте продолжить."]
[null,"Счета","Остаток на начало",null,"Обороты",null,"Остаток на конец"]
[null,null,"Дт","Кт","Дт","Кт","Дт","Кт"]
[null,"01 \"Основные средства\"",0,0,200000,null,null,null,"наименования счетов напишите сами"]
[null,"10 \"Материалы\"",0,0]
[null,"08 \" ???\"",0,0,null,200000]
[null,"19\" ???\"",0,0]
[null,"51\" ???\"",0,0]
[null,"60",0,0]
[null,"68",0,0]
[null,"Итого",0,0,200000,200000,0,0]

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