财务收入支出管理查询Excel表

财务收入支出管理查询系统 <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> 使用说明 财务收入支出记录 项目查询 <br> <br> 使用说明 <br> 1 "点击""首页""对于的图标可以链接到指定的表" <br> 2 在财务收入支出记录表中，F列为公式自动生成，输入收入支出即可 <br> 3 在“项目查询”表中，按项目名称查询只需要输入记录表中要查的名称即可，结余自动统计 <br> 4 在“项目查询”表中，按日期查询只需要输入记录表中要查的日期即可，结余自动统计 <br> 5 在“项目查询”表中，按项目名称+日期查询需要输入记录表中要查的项目名称+日期两个查询条件，结余自动统计 <br> 6 单击“返回首页”按钮可以链接回“首页”导航 <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> 财务收入支出记录 <br> 编号 项目 日期 收入金额 支出入金额 结余 经手人 备注说明 结余总计 <br> 1 项目A 5/28/2016 ¥56,890.00 ¥40,000.00 ¥16,890.00 张琳 ¥135,890.00 <br> 2 项目B 5/28/2016 ¥20,000.00 ¥5,000.00 ¥15,000.00 张琳 <br> 3 项目A 6/9/2016 ¥80,000.00 ¥0.00 ¥80,000.00 张琳 <br> 4 项目B 6/9/2016 ¥30,000.00 ¥6,000.00 ¥24,000.00 张琳 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ¥0.00 <br> ...