{"text_format":"1","workbook":"xls","n_sheets":5,"sheets":["丁字账","科目余额表","资产负债表","损益表","现金流量表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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","formulas":"cached_only"}

{"sheet":"丁字账","index":0,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":false,"merged":[[75,0,75,1],[75,3,75,4],[75,6,75,7],[61,0,61,1],[61,3,61,4],[61,6,61,7],[68,0,68,1],[68,3,68,4],[68,6,68,7],[47,0,47,1],[47,3,47,4],[47,6,47,7],[54,0,54,1],[54,3,54,4],[54,6,54,7],[33,0,33,1],[33,3,33,4],[33,6,33,7],[40,0,40,1],[40,3,40,4],[40,6,40,7],[19,0,19,1],[19,3,19,4],[19,6,19,7],[26,0,26,1],[26,3,26,4],[26,6,26,7],[0,0,0,7],[1,0,1,1],[1,3,1,4],[1,6,1,7],[12,0,12,1],[12,3,12,4],[12,6,12,7]],"flags":["formulas_cached_only"]}
["年月丁字账"]
["现金",null,null,"银行存款",null,null,"营业费用"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["其他应付款",null,null,"预付账款",null,null,"应收账款"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["库存商品",null,null,"应交税金",null,null,"主营业务成本"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["主营业务收入",null,null,"财务费用 ",null,null,"本年利润"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["累计折旧",null,null,"其他应收款",null,null,"预提费用"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["管理费用",null,null,"预收账款",null,null,"应付账款"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["应付工资",null,null,"利润分配",null,null,"其他应交款"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["所得税",null,null,"营业外支出",null,null,"固定资产"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["短期借款",null,null,"制造费用",null,null,"应收票据"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["应付票据",null,null,"其他业务收入",null,null,"原材料"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
["生产成本",null,null,"主营业务税金及附加",null,null,"其他货币资金"]
["借方","贷方",null,"借方","贷方",null,"借方","贷方"]
[]
[]
[]
[]
[0,0,null,0,0,null,0,0]
[]
[]
[null,null,null,null,null,null,"借方合计",0]
[null,null,null,null,null,null,"贷方合计",0]
[null,null,null,null,null,null,"自动计算差额数",0]

{"sheet":"科目余额表","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,2,1,3],[1,4,1,6],[1,7,1,8],[40,0,40,1],[1,0,2,0],[1,1,2,1]],"flags":["formulas_cached_only"]}
["年月份科目余额表"]
["科目代码","科目名称","期初余额",null,"本期发生额",null,null,"期末余额"]
[null,null,"借方","贷方 ","借方","贷方","√","借方","贷方 "]
[1001,"现金",null,null,0,0,null,0]
[1002,"银行存款",null,null,0,0,null,0]
[1015,"其他货币资金",null,null,0,0,null,0]
[1121,"应收票据",null,null,0,0,null,0]
[1122,"应收帐款",null,null,null,null,null,0]
[1123,"预付帐款",null,null,0,0,null,0]
[1221,"其他应收款",null,null,0,0,null,0]
[1403,"原材料",null,null,0,0,null,0]
[1405,"库存商品",null,null,0,0,null,0]
[1412,"低值易耗品",null,null,null,null,null,0]
[1601,"固定资产",null,null,0,0,null,0]
[1602,"累计折旧",null,null,null,0,null,null,0]
[2201,"应付票据",null,null,0,0,null,null,0]
[2202,"应付帐款",null,null,0,0,null,null,0]
[2205,"预收账款",null,null,0,0,null,null,0]
[2241,"其他应付款",null,null,0,0,null,null,0]
[2211,"应付职工薪酬",null,null,0,0,null,null,0]
[2001,"短期借款",null,null,0,0,null,null,0]
[2221,"应交税金",null,null,0,0,null,null,0]
[229,"其他应交款",null,null,0,0,null,null,0]
[2401,"预提费用",null,null,0,0,null,null,0]
[4001,"实收资本"]
[4002,"资本公积",null,null,null,null,null,null,0]
[4103,"本年利润",null,null,0,0,null,null,0]
[4104,"利润分配",null,null,0,0,null,null,0]
[5001,"生产成本",null,null,0,0,null,0]
[5101,"制造费用",null,null,0,0,null,0]
[6001,"主营业务收入",null,null,0,0,null,null,0]
[6051,"其他业务收入",null,null,0,0,null,null,0]
[6401,"主营业务成本",null,null,0,0,null,0]
[6405,"主营业务税金及附加",null,null,null,0,null,0]
[6601,"营业费用",null,null,0,0,null,0]
[6801,"所得税",null,null,0,0,null,0]
[6602,"管理费用",null,null,0,0,null,0]
[6603,"财务费用",null,null,0,0,null,0]
[6711,"营业外支出",null,null,0,0,null,0]
[6901,"以前年度损益调整",null,null,null,null,null,0]
["合   计",null,0,0,0,0,null,0,0]
[]
[]
[null,null,"自动计算差额数",0,null,0,null,null,0]

{"sheet":"资产负债表","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["资 产 负 债 表"]
["编制单位:",null,"编制日期：","   年 月 日",null,"单位：人民币元"]
["资      产","年初数","年末数","负债及所有者权益","年初数","年末数"]
["流动资产：",null,null,"流动负债："]
["    货币资金",null,0,"    短期借款",null,0]
["    短期投资",null,null,"    应付票据",null,0]
["    应收票据",null,0,"    应付账款",null,0]
["    应收账款",null,0,"    预收账款",null,0]
["        减：坏账准备",null,null,"    其他应付款",null,0]
["    净应收账款",null,null,"    应付股利"]
["    预付账款",null,0,"    应付工资",null,0]
["    其他应收款",null,0,"    未交税金",null,0]
["    存货",null,0,"    其他应交 款",null,0]
["    待摊费用",null,null,"    预提费用",null,0]
["    待处理流动资产损失",null,null,"    应付福利费"]
["流动资产合计",0,0,"流动负债合计",0,0]
["长期投资："]
["    长期投资",null,null,"长期负债："]
["固定资产：",null,null,"    长期借款"]
["     固定资产原价",null,0,"    应付债券"]
["     减：累计折旧",null,0,"其他长期负债"]
["     固定资产净值",null,0,"长期负债合计",0]
["     固定资产清理"]
["在建工程",null,null,"负债合计",0,0]
["无形资产及递延资产："]
["    递延资产"]
["    无形资产"]
["无形资产及递延资产合计",null,0,"所有者权益："]
["其他长期资产：",null,null,"实收资本",null,0]
["    其他长期资产",null,null,"资本公积 "]
["    递延税项",null,null,"未分配利润",null,0]
["    递延税款借项",null,null,"    所有者权益合计",null,0]
["资产总计",0,0,"负债及所有者权益合计",0,0]
[]
[]
[]
[]
[null,null,"自动计算差额数",0]

{"sheet":"损益表","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["损   益   表"]
["编制单位:"]
["编制日期：        年 月   日",null,"单位：人民币元"]
["项          目 ","本月数","累计数"]
["主营业务收入：",0]
["    其中：出口产品销售收入"]
["减：销售折扣与折让"]
["减：主营业务税金及附加",0]
["减：主营业务成本",0]
["        其中：出口产品销售成本"]
["减：销售费用（经营费用）",0]
["主营业务利润",0,0,"已经设置好公式"]
["加：其他业务利润"]
["减：管理费用",0]
["减：财务费用",0]
["        其中：利息支出（减利息收入）"]
["                    汇兑损失（减汇兑收益）"]
["营业利润",0,0]
["加：投资收益"]
["加：营业外收入"]
["减：营业外支出"]
["加：以前年度损益调整"]
["利润总额",0,0]
["减：所得税"]
["   净利润",0,0]

{"sheet":"现金流量表","index":4,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["现   金   流   量   表"]
["项                         目",null,"金         额"]
["一、 经营活动产生的现金流量"]
["        净利润",null,0]
["加：记提的资产减值准备",null,0]
["         固定资产折旧",null,0]
["        递延、无形资产摊销"]
["       待摊费用减少（减：增加）",null,0]
["        预提费用增加（减：减少）",null,0]
["        固定资产报废损失",null,0]
["       投资损失（减：收益）",null,0]
["       递延税款待项（减：借项）",null,0]
["       存货的减少（减：增加）",null,0]
["       经营性应收项目的减少（减：增加）",null,0]
["       经营性应付项目的增加（减：减少）",null,0]
["       其他"]
["       经营活动产生的现金流量净额",null,0]
[]
["二、投资活动产生的现金流量："]
["       短期投资所收到的现金（减：增加）",null,0]
["       取得投资收益所收到的现金",null,0]
["       其他与投资活动有关的现金"]
["       构建固定资产所支付的现金",null,0]
["　　无形、递延资产所支付的现金",null,0]
["       其他与投资活动有关的现金"]
["       投资活动产生的现金流量净额",null,0]
[]
["三、筹资活动产生的现金流量"]
["        借款所收到的现金",null,0]
["        举债所收到的现金",null,0]
["        其他与筹资活动有关的现金",null,0]
["        分配股利所支付的现金",null,0]
["         筹资活动产生的现金流量净额",null,0]
[]
["四、汇率变动对现金的影响",null,0]
[]
["五、现金及现金等价物净增加额",null,0]
[]
["       年初货币资金",null,0]
[]
["       年末货币资金",null,0]