2025出纳excel日记账统计系统
2025年现金日记账（自动统计）-Sheet1 Unnamed: 0 现 金 日 记 账 序号123Unnamed: 2 收入金额日期2019-02-01 00:00:002019-02-02 00:00:002019-02-05 00:00:00Unnamed: 3 80400摘要Unnamed: 4 Unnamed: 5 支出金额收入金额50000280002400Unnamed: 6 4700经办人李四李四李四Unnamed: 7 摘要Unnamed: 8 余额Unnamed: 9 75700支出金额120023001200Unnamed: 10 经办人詹三詹三詹三Unnamed: 11 备注Unnamed: 12 2.02.02.0
2025年现金日记账（自动统计，自动计算）-Sheet2 Unnamed: 0 商品出入库汇总表 物料编码A-001A-002A-003A-004A-005A-006Unnamed: 2 物料名称物料1物料2物料3物料4物料5物料6Unnamed: 3 期初库存111023131612Unnamed: 4 期初金额120014001600130012001900Unnamed: 5 入库数量Unnamed: 6 入库金额Unnamed: 7 出库数量Unnamed: 8 出库金额Unnamed: 9 库存数量Unnamed: 10 库存金额Unnamed: 11 备注Sheet1 Unnamed: 0 出库入库Unnamed: 1 Unnamed: 2 现金日记账 查询日期查询账户日期2018-01-01 00:00:002018-01-02 00:00:002018-01-0......
2025年现金日记账-分类统计计算-Sheet1 Unnamed: 0 Unnamed: 1 现 金 日 记 账日期4373843740437414374243743437444374543746437474374843749437504375143752Unnamed: 2 Unnamed: 3 项目结转项目1项目2项目3项目4项目1项目6项目7项目8项目1项目10项目11项目12项目13Unnamed: 4 摘要Unnamed: 5 总合计账户微信支付包农行建行微信支付包农行建行微信支付包农行建行微信Unnamed: 6 122000收入1000012000100000Unnamed: 7 98390支出1200638073......
2025年财务日记账（自动统计）-Sheet1 Unnamed: 0 财务日记帐 日期2021/3/12021/3/22021/3/32021/3/4Unnamed: 2 会计科目材料采购应收账款工程结算Unnamed: 3 摘要上月结转Unnamed: 4 现金借方金额11111Unnamed: 5 现金期初金额收入支出结余贷方金额2000Unnamed: 6 500011111200014111余额5000500016111141111411114111141111411114111141111411114111141111411114111141111411114111141111411114111Unnamed: 7 Unnamed: 8 银行卡期初金额收入支出结余银行卡借方金额Unnamed: 9 10000020008000贷方金额2000Unnamed: 10 余额1000080008000800080008000800080008000800080
2025年现金日记账（自动统计）-Sheet1 Unnamed: 0 Unnamed: 1 现金日记账2019年月11Unnamed: 2 收入合计支出合计日35Unnamed: 3 3200120凭证号现-001银-001Unnamed: 4 摘要购买办公用品提取现金Unnamed: 5 科目管理费用银行存款Unnamed: 6 期初余额期末余额借方3200Unnamed: 7 5003580贷方120Unnamed: 8 余额-1203080
2025年现金收支日记账（半年统计）-收支表 Unnamed: 0 Unnamed: 1 现金日记账-收支表日期合计2020-01-01 00:00:002020-01-02 00:00:002020-01-03 00:00:002020-01-04 00:00:002020-01-05 00:00:002020-01-06 00:00:002020-01-07 00:00:002020-01-08 00:00:002020-01-09 00:00:002020-01-10 00:00:002020-01-11 00:00:002020-01-12 00:00:002020-01-13 00:00:002020-01-14 00:00:002020-01-15 00:00:002020-01-16 00:00:002020-01-17 00:00:002020-01-18 00:00:002020-01-19 00:00:002020-01-20 00:00:00Unnamed: 2 类别收入支出收入支出收入支出收入支出收入支出收入支出收
2025年财务管理-现金日记账-自动统计-Sheet1 Unnamed: 0 现 金 日 记 账 币种：RMB 月份1212121212Unnamed: 2 日期2019-12-01 00:00:002019-12-02 00:00:002019-12-03 00:00:002019-12-04 00:00:002019-12-05 00:00:00Unnamed: 3 字Unnamed: 4 号Unnamed: 5 经办人张三张三张三张三张三Unnamed: 6 摘要Unnamed: 7 借方金额50001000Unnamed: 8 贷方金额300999888Unnamed: 9 开始日期结束日期借或贷Unnamed: 10 2019-12-01 00:00:002019-12-20 00:00:00余额50004700370128133813381..
2025年现金日记账-日收支表-Sheet1 Unnamed: 0 Unnamed: 1 2019年9月现金日记账收入表日期4370943710437114371243713437144371543716437174371843719437204372143722437234372443725437264372743728Unnamed: 2 内容摘要123摘要124摘要125摘要126摘要127摘要128摘要129摘要130摘要131摘要132摘要133摘要134摘要135摘要136摘要137摘要138摘要139摘要140摘要141摘要142Unnamed: 3 收入12006380736800006302169656036055859895613569578
2025年收入日记账月度统计表-Sheet1 收入日记账月度统计表 日期2021-02-01 00:00:002021-02-02 00:00:002021-02-03 00:00:002021-02-04 00:00:002021-02-05 00:00:002021-02-06 00:00:002021-02-07 00:00:002021-02-08 00:00:002021-02-09 00:00:002021-02-10 00:00:002021-02-11 00:00:002021-02-12 00:00:002021-02-13 00:00:002021-02-14 00:00:002021-02-15 00:00:002021-02-16 00:00:002021-02-17 00:00:002021-02-18 00:00:002021-02-19 00:00:002021-02-20 00:00:002021-02-21 00:00:002021-02-22 00:00:002021-02-23 00:00:002021-02-24 00:00:002021-02-25 0
2025年现金日记账 (自动统计)免费下载-Sheet1 Unnamed: 0 Unnamed: 1 收入金额支出金额结余Unnamed: 2 Unnamed: 3 91000.07800.089900.0Unnamed: 4 现 金 日 记 账 序号上期留底123Unnamed: 6 日期2018-09-02 00:00:002018-09-03 00:00:002018-09-03 00:00:00Unnamed: 7 摘要废品收入投资收益分红Unnamed: 8 收入金额5000600080000Unnamed: 9 经办人李四李四李四Unnamed: 10 摘要房租支出工资支出福利费Unnamed: 11 支出金额5003007000Unnamed: 12 经办人詹三詹三詹三Unnamed: 13 备注6700
2025年现金收支日记账（图表统计）-收支表 Unnamed: 0 Unnamed: 1 现金日记账-收支表日期合计2020.1.12020.1.22020.1.32020.1.42020.1.52020.1.62020.1.72020.1.82020.1.92020.1.102020.1.112020.1.122020.1.132020.1.142020.1.152020.1.162020.1.172020.1.182020.1.19Unnamed: 2 类别收入支出收入支出收入支出收入支出收入支出收入支出收入支出收入支出支出支出支出Unnamed: 3 明细明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1明细1
2025年财务日记账（日记账单）-现金收支月报表 Unnamed: 0 财务日记账 单位名称：日 期2019.7.12019.7.22019.7.32019.7.42019.7.52019.7.62019.7.72019.7.82019.7.92019.7.102019.7.112019.7.122019.7.132019.7.14Unnamed: 2 项目名称Unnamed: 3 初期金额500501502503504505506507508509510511512513Unnamed: 4 收 入明 细现金100101102103104105106107108109110111112113Unnamed: 5 微信1001011021031041051061......
2025年收支日记账-日期查询-收支记账本 Unnamed: 0 Unnamed: 1 收 支 日 记 账阶段查询序号12345Unnamed: 2 日期2019-03-01 00:00:002019-03-02 00:00:002019-03-03 00:00:002019-03-04 00:00:002019-03-05 00:00:00Unnamed: 3 起始日期结束日期凭证字据Unnamed: 4 2019-03-01 00:00:002019-03-04 00:00:00对方科目科目1科目2科目1科目4科目5Unnamed: 5 收入支出摘要摘要1摘要2摘要3摘要4摘要5Unnamed: 6 40001300支付方式Unnamed: 7 收入金额200020001000Unnamed: 8 总收入总支出支出金额3001000Unnamed: 9 50001300结......
2025年现金日记账 （自动统计）-Sheet1 Unnamed: 0 Unnamed: 1 支出收入结余Unnamed: 2 Unnamed: 3 2400.05400.09700.0Unnamed: 4 现 金 日 记 账 序号上期留底123Unnamed: 6 日期2019-02-01 00:00:002019-02-02 00:00:002019-02-03 00:00:00Unnamed: 7 收支收入收入支出Unnamed: 8 摘要废品收入投资收益分红Unnamed: 9 金额200034002400Unnamed: 10 经办人李四李四李四Unnamed: 11 备注6700
2025年现金日记账(查询统计）-流水账 Unnamed: 0 Unnamed: 1 现金日记账序号12Unnamed: 2 开始日期收入日期2018-10-01 00:00:0043375Unnamed: 3 2018-10-01 00:00:00100项目项目1项目2Unnamed: 4 支出摘要摘要1摘要2Unnamed: 5 收入累计结束日期50账号账号1账号2Unnamed: 6 1002018-10-11 00:00:00结余账户账户2账户3Unnamed: 7 支出累计50收入100Unnamed: 8 50支出50Unnamed: 9 备注
2025年支出记账日历统计表-Sheet1 2019年 12月月总支出汇总10178金额：元Unnamed: 1 1 49783481549022284293942 14994401627523278304453 347103521717624186313264 364.011.0365.018.0374.025.0273.05 353.012.0338.019.0286.026.0249.06 338.013.0261.020.0278.027.0390.07 414.014.0245.021.0318.028.0345.0
2025年现金日记账-日统计-Sheet1 Unnamed: 0 Unnamed: 1 现金日记账账号初期金额收入金额支出金额余额日期2019-11-01 00:00:002019-11-02 00:00:002019-11-03 00:00:002019-11-04 00:00:00Unnamed: 2 微信10000010009000项目服饰工资水电费通讯费Unnamed: 3 支付宝5000010004000摘要Unnamed: 4 农行1000500006000账户微信农行支付宝工行Unnamed: 5 工行200002001800支出金额10001000200Unnamed: 6 建行1000001000收入金额5000Unnamed: 7 兴业2000
2025年现金日记账（自动统计）-Sheet1 Unnamed: 0 现金日记账 序号12345678Unnamed: 2 日期2018-08-02 00:00:002018-08-03 00:00:002018-08-04 00:00:002018-08-05 00:00:002018-08-06 00:00:00Unnamed: 3 凭证号PZ-01PZ-02PZ-03Unnamed: 4 摘要期初余额Unnamed: 5 收入35628962400Unnamed: 6 支出200Unnamed: 7 余额35615630525452Unnamed: 8 备注Sheet2 Sheet3
2025年财务收支日记账-按日统计-Sheet1 财务收支日记账 序号123456Unnamed: 1 按日查询：日期2019-04-24 00:00:002019-04-24 00:00:002019-04-24 00:00:002019-04-25 00:00:002019-04-26 00:00:002019-04-27 00:00:00Unnamed: 2 2019-04-24 00:00:00收入项目Unnamed: 3 数量Unnamed: 4 收入金额：金额2000100Unnamed: 5 2100支出项目Unnamed: 6 数量Unnamed: 7 支出金额：金额2001200300Unnamed: 8 1400余额Unnamed: 9 余额：明细Unnamed: 10 700备注Sheet2 Sheet3
2025年现金日记账（小格统计）-Sheet1 Unnamed: 0 现金日记账 2019月Unnamed: 2 日Unnamed: 3 凭证号字Unnamed: 4 号Unnamed: 5 摘要Unnamed: 6 借方金额（收入）仟Unnamed: 7 佰Unnamed: 8 十Unnamed: 9 万Unnamed: 10 仟Unnamed: 11 佰Unnamed: 12 十Unnamed: 13 元Unnamed: 14 角Unnamed: 15 分Unnamed: 16 贷方金额（支出）仟Unnamed: 17 佰Unnamed: 18 十Unnamed: 19 万Unnamed: 20 仟Unnamed: 21 佰Unnamed: 22 十Unnamed: 23 元Unnamed: 24 角Unnamed: 25 分Unnamed: 26 余额仟Unnamed: 27 制表人：......
收支表-财务收支日记账-日记账-说明 Unnamed: 0 ▌ User Guide 说明 Unnamed: 2 ´ 使用方法先设置参数再记账下图红色区域为填写区域，其他地方不用填写内只需填月份数字，可不填“月”复制工作表可以用作其他月份´ 操作指导怎么撤销工作表保护？点开相应工作表（如：《记账》），点击菜单栏 审阅---撤销工作表保护怎么增加行数？撤销工作表保护后，选择表格最后一行白色区域，向下拖拽即可。修改完后再将工作表保护起来建议正常使用时保持工作表保护输入当前日期快捷键：Ctrl + ;´ 作者申明设计师【琪一】（ID：208634701）开发作品，授权Docer独家首发，版权保护，侵权必究欢迎保存网址了解模
2025年财务会计日记账费用统计表-Sheet1 财务会计日记账费用统计表 年2019Unnamed: 1 月12Unnamed: 2 日1Unnamed: 3 科目编号7898701Unnamed: 4 会计类型收入Unnamed: 5 费用摘要商品销售收入Unnamed: 6 发生金额35000Unnamed: 7 记账人李霞Unnamed: 8 备注说明当天到账
2025年财务收支日记账-图表统计-Sheet2 Unnamed: 0 财务收支日记账 日期：公司名称昨日代收款现金余额昨日现金余额本日收入收入小计：本日支出支出小计：本日代收款现金余额本日现金余额填表人: Unnamed: 2 代收款寄件收入充值预存款到付款项目1项目2项目3项目4项目5Unnamed: 3 现金收入微信收入系统扣款现金微信费用支出费用支出费用支出费用支出费用支出Unnamed: 4 圆通3004000100100Unnamed: 5 中通2002010101101Unnamed: 6 申通1501510102102Unnamed: 7 韵达3203210103103审核人:Unnamed: 8 ......
2025年现金日记账（自动统计）-Sheet1 Unnamed: 0 Unnamed: 1 序号1234Unnamed: 2 现金存款日记账Unnamed: 3 日期2019-01-03 00:00:002019-02-01 00:00:002019-02-06 00:00:002019-02-09 00:00:00Unnamed: 4 凭证号现收1-58#银付2-54#银收2-90#银付2-101#Unnamed: 5 摘要收租金付材料费收投资收益款付办公费Unnamed: 6 收入金额30002000Unnamed: 7 收入总额支出总额支出金额300300Unnamed: 8 5000600余额3000270047004400Unnamed: 9 备注
2025年现金日记账(自动统计）-Sheet1 Unnamed: 0 Unnamed: 1 现 金 日 记 账2021年月133333333333333333Unnamed: 2 日1112566Unnamed: 3 凭证编号Unnamed: 4 类别营业收入采购营业收入应付账款营业收入采购Unnamed: 5 对方科目Unnamed: 6 摘要期初余额营业款采购营业款借款营业款采购本月累计Unnamed: 7 公司/部门Unnamed: 8 账户工商农业农业农业工商工商Unnamed: 9 借 方999912000200000Unnamed: 10 贷 方180050004000Unnamed: 11 余 额1000019999181993019925199225199221199221199Unnamed: 12 √Unnamed: 13 Unnamed: 14 类别营业收入采购应收账款应付账款Unnam
2025年现金日记账-日期查询-Sheet1 Unnamed: 0 Unnamed: 1 现金日记账-日期查询序号123456789101112Unnamed: 2 日期2020-09-01 00:00:002020-09-02 00:00:002020-09-03 00:00:002020-09-04 00:00:002020-09-05 00:00:002020-09-06 00:00:002020-09-07 00:00:002020-09-08 00:00:002020-09-09 00:00:002020-09-10 00:00:002020-09-11 00:00:002020-09-12 00:00:00Unnamed: 3 银行名称/现金银行存款库存现金库存现金库存现金库存现金银行存款银行存款银行存款银行存款库存现金库存现金库存现金Unnamed: 4 会计科目管理费用管理费用其他应付款管理费用管理费用管理费用
2025年现金流水日记账（季度统计）图表分析-1 Unnamed: 0 Unnamed: 1 现金流水日记账序号12345678Unnamed: 2 总收入总支出结余日 期2018-01-03 00:00:002018-02-04 00:00:002018-03-05 00:00:002018-03-06 00:00:002018-01-03 00:00:002018-02-04 00:00:002018-03-05 00:00:002018-03-06 00:00:00Unnamed: 3 345214841968类 别收入开支Unnamed: 4 科 目Unnamed: 5 摘 要Unnamed: 6 收 入300760500896600396Unnamed: 7 支 出396396100196396Unnamed: 8 月份统计查询月份查询1月2月3月结 余
2025年现金日记账（自动统计，可查询明细）-Sheet1 Unnamed: 0 6.09.0Unnamed: 1 现金日记账 累计收入日期2018-06-01 00:00:002018-06-11 00:00:002018-06-13 00:00:002018-06-24 00:00:002018-07-03 00:00:00Unnamed: 3 30000凭证号现付0001现收0001现付0002现付0003Unnamed: 4 累计支出摘要期初余额购买10台打印机销售A产品支付运输费用差旅费Unnamed: 5 20100对方科目管理费用主营业务收入材料采购管理费用Unnamed: 6 收入30000Unnamed: 7 当前余额支出1650012002400Unnamed: 8 59900余额5000033500635006230059900Unnamed: 9 Unnamed: 10 Unnamed: 11 Unnamed: 12 Unna......
2025年现金日记账日常记录明细-收支表 Unnamed: 0 Unnamed: 1 现金日记账日常纪录明细表日期合计2020-01-01 00:00:002020-02-01 00:00:002020-03-01 00:00:002020-04-01 00:00:002020-06-01 00:00:002020-07-01 00:00:002020-08-01 00:00:002020-09-01 00:00:002020-10-01 00:00:002020-11-01 00:00:002020-12-01 00:00:002020-02-01 00:00:002020-03-01 00:00:002020-04-01 00:00:002020-05-01 00:00:002020-06-01 00:00:002020-07-01 00:00:002020-05-01 00:00:00Unnamed: 2 类别收入支出收入支出收入支出收入支出收入支出收入支出收入支出收入支出支出支出支出Unname
2025年现金日记账(日历表)-1 Unnamed: 0 Unnamed: 1 现金日记账(日历表)序号上期结存Unnamed: 2 日 期Unnamed: 3 大类2020-01-03 00:23:45星期日2020-01-05 00:00:002020-01-12 00:00:002020-01-19 00:00:002020-01-26 00:00:00Unnamed: 4 科 目星期一2020-01-06 00:00:002020-01-13 00:00:002020-01-20 00:00:002020-01-27 00:00:00Unnamed: 5 摘 要星期二2020-01-07 00:00:002020-01-14 00:00:002020-01-21 00:00:002020-01-28 00:00:00Unnamed: 6 收 入219225日历表星期三2020-01-01 00:00:002020-01-08 00:00:002020-01-15 00:00:002020-01-22 00:00:002
2025年现金日记账日常记录明细-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 现金日记账序号123456789101112131415161718结余金额统计（元）Unnamed: 3 日期2020-04-08 00:00:002020-04-09 00:00:00Unnamed: 4 摘要华科公司产品结算工程设计Unnamed: 5 收支支出收入Unnamed: 6 账户现金支付宝Unnamed: 7 金额-360052001600Unnamed: 8 经手人王丽李文建Unnamed: 9 备注
2025年财务日记账（智能统计）-日记账 Unnamed: 0 财务日记账 2019年10总收入总支出结余Unnamed: 2 17999.011199.06800.0Unnamed: 3 Unnamed: 4 单据编号111213141516Unnamed: 5 日期2019-10-11 00:00:002019-10-12 00:00:002019-10-13 00:00:002019-10-14 00:00:002019-10-15 00:00:002019-10-16 00:00:00Unnamed: 6 月份101010101010Unnamed: 7 摘要汇入汇入汇入汇出汇出汇出Unnamed: 8 科目应收账款应收账款应收账款应付票据应付票据应付票据Unnamed: 9 银行账户工行工行工行工行工行工行U......
2025年现金日记账自动统计-现金日记账 Unnamed: 0 现金日记账制表人：2019年月4444444444444444444444444444444Unnamed: 1 日12345678910111213141516171819202122232425262728293031Unnamed: 2 凭证编号Unnamed: 3 类别营业款费用报销Unnamed......
2025年财务管理-现金日记账-月份统计-Sheet1 Unnamed: 0 现金日记账 单位：2019年月12121212Unnamed: 2 日17181920Unnamed: 3 凭证号数1234Unnamed: 4 摘 要销售采购水电费采购Unnamed: 5 账号：Unnamed: 6 票据号码Unnamed: 7 借 方10000Unnamed: 8 贷 方20005005000Unnamed: 9 方 向Unnamed: 10 余 额10000800075002500250025002500250025002500250025002500250025002500250025002500250025002500
2025年现金日记账（自动统计）-Sheet1 Unnamed: 0 Unnamed: 1 收入金额支出金额结余Unnamed: 2 Unnamed: 3 8100.04700.010100.0Unnamed: 4 现 金 日 记 账 序号上期留底123Unnamed: 6 日期2018-01-02 00:00:002018-01-03 00:00:002018-01-03 00:00:00Unnamed: 7 摘要废品收入投资收益分红Unnamed: 8 收入金额230034002400Unnamed: 9 经办人李四李四李四Unnamed: 10 摘要房租支出工资支出福利费Unnamed: 11 支出金额120023001200Unnamed: 12 经办人詹三詹三詹三Unnamed: 13 备注6700
2025年收支日记账-日期查询-Sheet1 Unnamed: 0 Unnamed: 1 日期2019-07-01 00:00:002019-07-02 00:00:002019-07-03 00:00:002019-07-04 00:00:002019-07-05 00:00:002019-07-06 00:00:002019-07-07 00:00:002019-07-08 00:00:002019-07-09 00:00:00Unnamed: 2 起始日期收入总额支出总额结存类型收入支出收入支出收入支出收入支出收入Unnamed: 3 2019-07-01 00:00:00收入34531345345313454320Unnamed: 4 截止日期1391642309686支出354032050320Unnamed: 5 2019-07-31 00:00:00内容明细货款杂费货款杂费货款杂费货款杂费......
2025年财务日记账-日报表-Sheet1 Unnamed: 0 Unnamed: 1 财 务 日 记 账 Financial Journal日 期Unnamed: 2 字 号Unnamed: 3 凭证号码Unnamed: 4 摘 要Unnamed: 5 收 入100600500200Unnamed: 6 收入累计支出累计结存累计支 出30020080Unnamed: 7 1400580820结 存100300300-80200000000000000000000000000000000000000
