2025excel多表关联统计考勤

2025年工资表-自动统计 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表序号123456789101112131415161718合计 制表： 财务经理： 人事经理： 总经理： Unnamed: 2 姓 名Unnamed: 3 部门Unnamed: 4 基础 工资5000600080001000029000Unnamed: 5 加班小时52411Unnamed: 6 加班工资5002004001100Unnamed: 7 其他30010002001500Unnamed: 8 合计5800620

2025年工资表（自动统计） - Sheet1 Unnamed: 0 工资表（自动统计） 员工 编号001Unnamed: 2 姓 名张三Unnamed: 3 部门办公室合计Unnamed: 4 基本 工资50005000Unnamed: 5 岗位 工资400400Unnamed: 6 工龄 工资200200Unnamed: 7 住房 补贴800800Unnamed: 8 伙食 补贴100100Unnamed: 9 交通 补贴100100Unnamed: 10 奖金500500Unnamed: 11 应发 合计71007100Unnamed: 12 住房公积金240240Unnamed: 13 养老 保险0Unnamed: 14 医疗 保险0Unnamed: 15 失业 保险0Unnamed: 16 个人所得税0Unnamed: 17 应扣合计24000000000000000000000240Unnamed: 18 实发合计68606

2025年工资表自动统计 - 工资表 工资表 序号123456789101112131415161718192021222324252627282930313233Unnamed: 1 姓 名Unnamed: 2 部门Unnamed: 3 基本工资岗位 工资Unnamed: 4 全勤奖Unnamed: 5 补 助Unnamed: 6 合计（元）000000000000000000000000000000000Unnamed: 7 绩效工资绩效 标准业务量（元）Unnamed: 8 比例%Unnamed: 9 合计元000000000000000000000000000000000Unnamed: 10 加班平时加班工时(h)Unnamed: 11 金额(元)Unnamed: 12 假日加班工时(h)Unnamed: 13 金额(元)Unnamed: 14 合计(元)000000000000

2025年收支表-自动统计 - 收支表 Unnamed: 0 Unnamed: 1 收 支 表商贸股份有限公司行次1234Unnamed: 2 2020年月1112Unnamed: 3 日24103Unnamed: 4 凭证字现收现付银收银付Unnamed: 5 号gg60001gg60002gg60003gg60004Unnamed: 6 记账科目管理费用Unnamed: 7 摘要xxUnnamed: 8 收入RMB/元10001000Unnamed: 9 支出RMB/元500500Unnamed: 10 结存RMB/元100050015001000Unnamed: 11 经办人高原高原高原高原Unnamed: 12

2025年财务表-月度统计 - Sheet1 Unnamed: 0 财务表-月度统计 日 期434664349743525435564358643617436474367843709437394377043800合 计Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5 收入0Unnamed: 6 提取备用金0Unnamed: 7 支出固定支出0Unnamed: 8 餐费0Unnamed: 9 办公日常用品0Unnamed: 10 其他支出0Unnamed: 11 报销费用0Unnamed: 12 借款明细0Unnamed: 13 共支出0000000000000Unnamed: 14 备用金余额0Unnamed: 15 结余

2025年收支表（收支统计） - Sheet1 Unnamed: 0 Unnamed: 1 收支表序号12345678910111213141516171819合计：Unnamed: 2 日期Unnamed: 3 收入明细Unnamed: 4 金额0Unnamed: 5 支出明细0Unnamed: 6 金额Unnamed: 7 备注

2025年收支表-自动统计-图表分析 - Sheet2 Unnamed: 0 Unnamed: 1 收支表序号1234Unnamed: 2 总收入总支出结余日期2019-10-25 00:00:002019-10-26 00:00:002019-10-27 00:00:002019-10-28 00:00:00Unnamed: 3 52222383348389项目项目1项目2项目3项目1Unnamed: 4 账户名称项目名称明细明细1明细2明细3明细4Unnamed: 5 工商项目1收支？收入支出收入支出Unnamed: 6 总收入总收入账户名称工商农业工商农业Unnamed: 7 5222250000金额5000050022223333Unnamed: 8 总支出总支出收支金额(自动）......

2025年财务表-自动统计 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 日期2019-10-01 00:00:002019-10-12 00:00:002019-10-23 00:00:002019-10-24 00:00:002019-10-25 00:00:002019-10-26 00:00:00Unnamed: 3 摘要Unnamed: 4 收入金额200030001000Unnamed: 5 账户支付宝建行工行Unnamed: 6 支出金额100035002500Unnamed: 7 账户建行工行支付宝Unnamed: 8 经手人张三李四张三李四张三李四Unnamed: 9 收入账户建行工行支付宝支出账户建行工行支付宝起始日期2019-10-10 00:00:00收入金额4000Unnamed: 10 收入总金额3000100020002025excel多表关联统计考勤

2025年收入表-每日统计 - Sheet1 Unnamed: 0 Unnamed: 1 收支明细表日期2020-04-01 00:00:002020-04-02 00:00:002020-04-03 00:00:002020-04-04 00:00:002020-04-05 00:00:002020-04-06 00:00:002020-04-07 00:00:002020-04-08 00:00:002020-04-09 00:00:002020-04-10 00:00:002020-04-11 00:00:00Unnamed: 2 详细内容奖金燃气费聚会工资购物宽带奖金燃气费聚会工资购物Unnamed: 3 交易方式支付宝建行微信农行微信支付宝光大工商光大工商光大Unnamed: 4 收入2000500300032040005000Unnamed: 5 备注Unnamed: 6 Unnamed: 7 每日收入日期......

2025年收支表（按月统计管理） - Sheet1 Unnamed: 0 Unnamed: 1 月份收入支出收 支 明 细 表日期2019-01-01 00:00:002019-01-01 00:00:002019-01-09 00:00:002019-02-01 00:00:002019-02-06 00:00:002019-02-12 00:00:002019-03-12 00:00:002019-03-15 00:00:002019-04-13 00:00:002019-04-18 00:00:002019-05-16 00:00:002019-05-16 00:00:002019-06-14 00:00:002019-06-19 00:00:002019-07-14 00:00:002019-07-16 00:00:002019-08-16 00:00:002019-08-17 00:00:002019-09-18 00:00:002019-09-15 00:00:002019-10-19 00:00:002019-10-20 00:00:002019-11-06 00:00:002019

2025年收支表（自动统计，图表显示） - Sheet1 Unnamed: 0 Unnamed: 1 收支登记表序号123456Unnamed: 2 查询月份当月总收入当月总支出日期2019-01-20 00:00:002019-01-21 00:00:002019-01-22 00:00:002019-01-23 00:00:002019-01-24 00:00:002019-01-25 00:00:00Unnamed: 3 16500035000月份111111Unnamed: 4 凭证号Unnamed: 5 Statement of income and expenditure摘要Unnamed: 6 收入金额50000500010000Unnamed: 7 支出金额10000500020000Unnamed: 8 全年总收入全年总收入结余经办人李四李四李四李四李四李四......

2025年收支表-自动统计 - 1 Unnamed: 0 Unnamed: 1 收 支 表 - 自 动 统 计序号123456789101112审核：Unnamed: 2 日期2020-04-22 00:00:002020-04-23 00:00:002020-04-24 00:00:002020-04-25 00:00:002020-04-26 00:00:002020-04-27 00:00:002020-04-28 00:00:002020-04-29 00:00:002020-04-30 00:00:002020-05-01 00:00:002020-05-02 00:00:002020-05-03 00:00:00Unnamed: 3 收入金额（元）1500160017001800190020002100220023002400250022000Unnamed: 4 明细Unnamed: 5 支出金额（元）200021002200

2025年收支表-项目统计 - Sheet1 Unnamed: 0 收支表-项目统计 日期2020-01-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-08-01 00:00:00Unnamed: 2 项目11212122Unnamed: 3 收入收入支出收入支出收入支出支出Unnamed: 4 项目名称项目1项目2项目3项目1项目1项目4项目5项目6Unnamed: 5 付款内容内容1内容2内容3内容4内容5内容6内容7内容8Unnamed: 6 收支金额20010058036052017802340648

2025年收支表-自动统计企业必备 - 1 Unnamed: 0 收支表-自动统计 序号审核： Unnamed: 2 日期0Unnamed: 3 收入金额（元）0Unnamed: 4 明细Unnamed: 5 支出金额（元）0Unnamed: 6 明细出纳：Unnamed: 7 经手人Unnamed: 8 备注

2025年收支表（自动统计，月份查询，自动图表） - fz 1 23456789101112131415161718192021222324252627282930311.1 2.03.04.05.06.07.08.09.010.011.012.0收入表 Unnamed: 0 Unnamed: 1 Unnamed: 2 收入记录表2019月12345678Unnamed: 3 日11111111Unnamed: 4 Income record chart收入金额200300......

2025年收支表(月份统计，图表显示) - Sheet1 Unnamed: 0 Unnamed: 1 月份 项目收入支出盈余2018-05-23 00:00:00 收支明细表日期2018-01-05 00:00:002018-01-04 00:00:002018-02-25 00:00:002018-02-28 00:00:002018-03-01 00:00:002018-03-10 00:00:002018-04-03 00:00:002018-04-10 00:00:002018-05-10 00:00:002018-05-21 00:00:00Unnamed: 3 115000500010000金额5000150001200500250001600030008000800012900Unnamed: 4 21200500700收支类型支出收入收入支出收入支出支出收入支出收入Unnamed: 5 3250002025excel多表关联统计考勤

2025年收支表-项目统计 - Sheet1 Unnamed: 0 Unnamed: 1 收支表-项目统计收入表明细日期2020-09-01 00:00:002020-09-01 00:00:002020-09-01 00:00:002020-09-01 00:00:002020-09-01 00:00:002020-10-02 00:00:002020-10-02 00:00:002020-10-02 00:00:002020-10-02 00:00:002020-10-02 00:00:002020-10-02 00:00:00Unnamed: 2 摘要学费1学费2学费3学费4学费5其他费用其他费用其他费用其他费用其他费用其他费用Unnamed: 3 专业会计一班会计一班会计二班会计二班会计二班会计二班会计一班会计一班会计二班会计二班会计二班Unnamed: 4 姓名陶莉莉小米丽丽花花乐乐乐乐

2025年收支表（自动统计明细） - Sheet2 Sheet1 Unnamed: 0 收支表（自动统计明细） 序号1234567891011121314151617181920212223242526Unnamed: 2 日期2017-04-28 00:00:002017-04-29 00:00:002017-04-30 00:00:002017-05-01 00:00:002017-05-02 00:00:002017-05-03 00:00:002017-05-04 00:00:002017-05-05 00:00:002017-05-06 00:00:002017-05-07 00:00:002017-05-08 00:00:002017-05-09 00:00:002017-05-10 00:00:002017-05-11 00:00:002017-05-12 00:00:002017-05-13 00:00:002017-05-14 00:00:002017-05-15 00:00:002017-05-1......

2025年收支表（自动统计） - Sheet1 Unnamed: 0 Unnamed: 1 编号1Unnamed: 2 收支表日期2018-03-01 00:00:00Unnamed: 3 收入项目租金Unnamed: 4 金额10000Unnamed: 5 备注Unnamed: 6 Unnamed: 7 编号1Unnamed: 8 总收入总支出结余日期2018-03-01 00:00:00Unnamed: 9 1000020008000支出项目采购Unnamed: 10 金额2000Unnamed: 11 备注Sheet2

2025年收支表（按月统计，图表结合） - Sheet1 Unnamed: 0 Unnamed: 1 收入明细表日期2019-01-01 00:00:002019-01-01 00:00:002019-01-09 00:00:002019-02-01 00:00:002019-02-06 00:00:002019-02-12 00:00:002019-03-12 00:00:002019-04-13 00:00:002019-05-16 00:00:002019-06-14 00:00:002019-07-14 00:00:002019-08-16 00:00:002019-09-15 00:00:002019-10-19 00:00:002019-11-06 00:00:002019-12-17 00:00:00Unnamed: 2 Unnamed: 3 Unnamed: 4 摘要Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8 金额2002002003004001004003005006007008009001000600400Unnamed: 9 Unnamed: