鼎信诺审计32 3000系列 SAP(余额分借贷两列)取数费.xls

1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 期初数是由期初余额借方数和期初余额贷方数计算得到的 期末数是由期末余额借方数和期末余额贷方数计算得到 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 行行号号科科目目编编号号科科目目名名称称科科目目类类别别借借贷贷方方向向期期初初余余额额借借方方数数期期初初余余额额贷贷方方数数期期初初数数 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 借借方方发发生生额额贷贷方方发发生生额额期期末末余余额额借借方方数数期期末末余余额额贷贷方方数数期期末末数数校校对对 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 期初数是由期初余额借方数和期初余额贷方数计算得到的 期末数是由期末余额借方数和期末余额贷方数计算得到 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 科目名称是由科目余额表中科目名称得到的也可以直接粘贴录入 期初数是由期初余额借方数和期初余额贷方数计算得到的 期末数是由期末余额借方数和期末余额贷方数计算得到 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 行行号号会会计计月月科科目目编编号号科科目目名名称称期期初初余余额额借借方方数数期期初初余余额额贷贷方方数数期期初初数数借借方方发发生生额额 贷贷方方发发生生额额期期末末余余额额借借方方数数期期末末余余额额贷贷方方数数期期末末数数校校对对 科科目目 索索引引 1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 科目名称是由科目余额表中科目名称得到的也可以直接粘贴录入 期初数是由期初余额借方数和期初余额贷方数计算得到的 期末数是由期末余额借方数和期末余额贷方数计算得到 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 会计月是由记账时间计算出来的也可以直接粘贴进入 科目名称是由科目余额表中科目名称得到的也可以直接粘贴进入 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 行行号号记记账账时时间间会会计计月月凭凭证证编编号号凭凭证证种种类类业业务务说说明明凭凭证证张张数数科科目目编编号号科科目目名名称称 利润中心 借借方方发发生生额额贷贷方方发发生生额额借借方方数数量量借借方方单单价价贷贷方方数数量量贷贷方方单单价价本本币币金金额额反反核核算算项项目目ID1ID1 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 1 在科目余额表中可以粘贴或输入数据 2 该表中的必填写的内容有由蓝色标题表示 灰色列表示有公式 所做公式只加到第1000行 超过1000行请自行拖拽添加公式 会计月是由记账时间计算出来的也可以直接粘贴进入 科目名称是由科目余额表中科目名称得到的也可以直接粘贴进入 3 第4行是该表的表头 不能修改或删除 否则不能导入该表数据 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00 0 000 00