{"text_format":"1","workbook":"xlsx","n_sheets":3,"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,"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":"科目明细表","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,3,12,5],[19,6,19,8],[32,3,32,5],[0,0,0,8],[2,0,2,2],[2,3,2,5],[2,6,2,8],[5,6,5,8],[11,6,11,8]]}
["科目明细表"]
["序号","编号","会计科目名称","序号","编号","会计科目名称","序号","编号","会计科目名称"]
["一、资产类",null,null,"一、资产类（续）",null,null,"三、共同类（续）"]
[1,1001,"库存现金",35,1605,"工程物质",67,3201,"套期工具（新增）"]
[2,1002,"银行存款",36,1606,"固定资产清理",68,3202,"被套期项目（新增）"]
[3,1012,"其他货币资金",37,1701,"无形资产","四、所有者权益类"]
[4,1101,"交易性金融资产",38,1702,"累计摊销",69,4002,"资本公积"]
[5,1121,"应收票据",39,1703,"无形资产减值准备",70,4010,"盈余公积"]
[6,1122,"应收账款",40,1711,"商誉",71,4103,"本年利润"]
[7,1123,"预付账款",41,1801,"长期待摊费用",72,4104,"利润分配"]
[8,1131,"应收股利",42,1811,"递延所得税资产",73,4201,"库存股"]
[9,1132,"应收利息",43,1901,"待处理财产损益","五、成本类"]
[10,1221,"其他应收款","二、负债类",null,null,74,5001,"生产成本"]
[11,1231,"坏账准备",44,2001,"短期借款",75,5101,"制造费用"]
[12,1321,"代理业务资产",45,2102,"交易性金融负债",76,5201,"劳务成本"]
[13,1401,"材料采购",46,2201,"应付票据",77,5301,"研发支出"]
[14,1402,"在途物质",47,2202,"应付账款",78,5401,"工程施工"]
[15,1403,"原材料",48,2203,"预收账款",79,5402,"工程结算"]
[16,1404,"材料成本差异",49,2211,"应付职工薪酬",80,5403,"机械作业"]
[17,1405,"库存商品",50,2221,"应交税费","六、损益类"]
[18,1406,"发出商品",51,2231,"应交利息",81,6001,"主营业务收入"]
[19,1407,"商品进销差价",52,2232,"应付股利",82,6011,"利息收入"]
[20,1408,"委托加工物资",53,2241,"其他应付款",83,6021,"手续费及佣金收入"]
[21,1411,"周转材料",54,2314,"代理业务负债",84,6051,"其他业务收入"]
[22,1471,"存货跌价准备",55,2401,"递延收益",85,6051,"公允价值变动损益"]
[23,1501,"持有至到期投资",56,2501,"长期借款",86,6111,"投资收益"]
[24,1502,"持有至到期投资减值准备",57,2502,"应付债券（筹企业长期资金）",87,6301,"营业外收入"]
[25,1503,"可供出售金额资产",58,2701,"长期应对款",88,6401,"主营业务成本"]
[26,1511,"长期股权投资",59,2701,"未确认融资费用",89,6402,"其他业务成本"]
[27,1512,"长期股权投资减值准备",60,2711,"专项应付款",90,6403,"营业税及附加"]
[28,1521,"投资性房地产",61,2801,"预计负债",91,6601,"销售费用"]
[29,1531,"长期应收款",62,2901,"递延所得税负债",92,6602,"管理费用"]
[30,1532,"未实现融资收益","三、共同类",null,null,93,6603,"财务费用"]
[31,1601,"固定资产",63,3001,"清算资金往来",94,6701,"资产减值损失"]
[32,1602,"累计折旧",64,3002,"货币兑换",95,6711,"营业外支出"]
[33,1603,"固定资产减值准备",65,3101,"衍生工具（可计套期工具）",96,6801,"所得税费用"]
[34,1604,"在建工程",66,4001,"实收资本",97,6901,"以前年度收益调整"]

{"sheet":"流水台帐录入表","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["流水台帐录入表"]
["序号","日   期","凭证号码","摘      要","科 目 编 码","会 计 科 目","明 细 科 目","余额方向","借 方 金 额","贷 方 金 额"]
[1,"2018-08-29","2032309023133","存款",1002,"银行存款","基本存款账户","借方",10000]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]

{"sheet":"总账查询打印","index":2,"n_rows":6,"n_cols":43,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,30,4,41],[4,42,5,42],[0,0,0,42],[2,4,3,4],[3,5,3,16],[3,17,3,28],[3,30,3,41],[4,2,4,3],[4,4,5,4],[4,5,4,16],[4,17,4,28],[4,29,5,29]]}
["总  分  类  账"]
[]
["会计科目及编号："]
["ACCOUNT  NO："]
[null,"年","凭证",null,"摘        要","借   方 ",null,null,null,null,null,null,null,null,null,null,null,"贷   方 ",null,null,null,null,null,null,null,null,null,null,null,"借或贷","余    额  ",null,null,null,null,null,null,null,null,null,null,null,"√"]
["月","日","字","号",null,"十亿","亿","千万","百万","十万","万","千","百","十","元","角","分","十亿","亿","千万","百万","十万","万","千","百","十","元","角","分",null,"十亿","亿","千万","百万","十万","万","千","百","十","元","角","分"]