2025EXECL做的库存明细账
2025年库存明细账-Sheet1 Unnamed: 0 Unnamed: 1 库存明细账单位名称：日期合计Unnamed: 2 摘 要Unnamed: 3 产 品 名 称Unnamed: 4 上期库存数量0Unnamed: 5 单价Unnamed: 6 金额0Unnamed: 7 本期购进数量0Unnamed: 8 单价Unnamed: 9 所属期间：金额0Unnamed: 10 本期销售数量0Unnamed: 11 单价Unnamed: 12 金额0Unnamed: 13 期末结存数量0Unnamed: 14 单价Unnamed: 15 金额0Unnamed: 16 备注0
2025年产成品库存明细账自动计算-Sheet1 产成品库存明细账 类别品名规格2020月7777777777777777777777结余大写金额合计Unnamed: 1 01日225781215171920212324242526282828293031Unnamed: 2 某某某设备记账凭证字0010020030040050060070080090100110120130140150160......
库存明细账excel模板-Sheet1 库存商品明细账 2013年Unnamed: 1 黑灰蓝黑灰蓝黑灰蓝黑灰蓝Unnamed: 2 进货LUnnamed: 3 XLUnnamed: 4 XXLUnnamed: 5 XXXLUnnamed: 6 销售LUnnamed: 7 XLUnnamed: 8 XXLUnnamed: 9 XXXLUnnamed: 10 结存LUnnamed: 11 XLUnnamed: 12 XXLUnnamed: 13 XXXLSheet2 Sheet3
2025年销售库存明细账-可查询-Sheet1 Unnamed: 0 Unnamed: 1 销售库存明细账查询时间2020-11-01 00:00:002020-11-02 00:00:002020-11-03 00:00:002020-11-04 00:00:002020-11-05 00:00:002020-11-06 00:00:002020-11-07 00:00:00Unnamed: 2 开始时间货物名称货物1货物2货物3货物4货物5货物6货物7Unnamed: 3 2020-11-01 00:00:00采购数量20132835402635Unnamed: 4 至单位个台张个个个个Unnamed: 5 2020-11-05 00:00:00单价（元）50568074238952Unnamed: 6 库存数量销售数量1522030
2025年供货商往来对账明细-Sheet1 Unnamed: 0 Unnamed: 1 供货商查询共计金额日期2020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-01 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-02 00:00:002020-12-03 00:00:002020-12-04 00:00:002020-12-05 00:00:002020-12-06 00:00:002020-12-07 00:00:002020-12-08 00:00:002020-12-09 00:00:002020-12-10 0
2025年财务收支明细账-多账户汇总、对账、查询-首页 账户明细账 Unnamed: 0 5-9-账户明细账 日期4276742767427684276842769427694277042770Unnamed: 2 凭证号001002003004005006007008Unnamed: 3 账户尾号66011001100211226601100110021122Unnamed: 4 账户类别建行邮政微信支付宝建行邮政微信支付宝Unnamed: 5 收入金额30002000800060003000 Unnamed: 6 支出金额4000500010000Unnamed: 7 摘要购买打印机银行利息劳务收入购买原料销售收入销售收入
2025年财务收支日记账（明细表）-Sheet1 Unnamed: 0 财务收支记账表 日期2019.11.12019.11.22019.11.32019.11.42019.11.52019.11.62019.11.72019.11.82019.11.92019.11.102019.11.112019.11.12Unnamed: 2 项目名称A1A2A3A4A5A6A7A8A9A10A11A12Unnamed: 3 收入金额100010011002100310041005100610071008100910101011Unnamed: 4 支出金额500501502503504505506507508509510511Unnamed: 5 剩余金额500500500
2025年库存明细表-进销存账单-Sheet1 进销存明细表 序号Unnamed: 1 品名Unnamed: 2 规格Unnamed: 3 单位Unnamed: 4 货架号Unnamed: 5 原始库单价Unnamed: 6 数量Unnamed: 7 合计金额00000000000000000000000000000000000000000000000000000000000
2025年财务管理收支账明细查询表-Sheet1 收支账明细查询表 序号123456789101112131415Unnamed: 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:00Unnamed: 2 收入金额36000236501900018000170009000980006230033300120007000027060900002300035000Unname......
2025年现金收支日记账明细表-收支明细表 Unnamed: 0 Unnamed: 1 现金收支日记账明细表查 询账户查询日期4334443345433464334743348433494335043351433524335343354合计Unnamed: 2 账户名称银行卡支付宝微信凭证 类别现付现付银付现收现收Unnamed: 3 收入368004480030600科目现金结存工资租金工资租金工资租金工资租金工资租金工资Unnamed: 4 支出200020001500账户银行卡支付宝微信银行卡支付宝微信银行卡支付宝微信银行卡支付宝Unnamed: 5 开始日期结束......
2025年物品存货明细账-记账表格 物品存货明细账 商品类别商品名称20 年月Unnamed: 1 日Unnamed: 2 凭证号Unnamed: 3 摘要Unnamed: 4 商品编号库存余量入库数量Unnamed: 5 0单价Unnamed: 6 金额000000000000000000000Unnamed: 7 最高库存最低库存出库数量Unnamed: 8 00均价Unnamed: 9 金额Unnamed: 10 出库总量入库总量结存数量00000000000000
2025年智能收支明细账管理-Sheet1 Unnamed: 0 Unnamed: 1 月份收入支出日期2020-01-01 00:00:002020-02-02 00:00:002020-03-03 00:00:002020-08-01 00:00:002020-02-02 00:00:002020-03-03 00:00:002020-04-01 00:00:002020-05-02 00:00:002020-06-03 00:00:002020-07-01 00:00:002020-02-02 00:00:002020-03-03 00:00:00Unnamed: 2 1月份50002500收入项目收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款收到XXXX项目款Unnamed: 3 2月份34002000Unn
2025年财务收支日记账明细表-Sheet1 Unnamed: 0 2020 2020日2020-07-26 00:00:002020-08-02 00:00:002020-08-09 00:00:002020-08-16 00:00:002020-08-23 00:00:002020-08-30 00:00:00本月收入本月支出本月结余收入支出结余开始日期结束日期收入金额支出金额8 一2020-07-27 00:00:002020-08-03 00:00:002020-08-10 00:00:002020-08-17 00:00:002020-08-24 00:00:002020-08-31 00:00:0029200199009300Unnamed: 3 二2020-07-28 00:00:002020-08-04 00:00:002020-08-11 00:00:002020-08-18 00:00:002020-08-25 00:00:002020-09-01 00:00:00Unnamed: 4 8三2020-07-29 00:00
2025年财务收支日记账明细表（自动管理综合视图）-Sheet1 Unnamed: 0 财务收支日记账明细表 日期2019.7.1Unnamed: 2 项目名称Unnamed: 3 收入明细微信200201202203204205Unnamed: 4 支付宝200201202203204205Unnamed: 5 现金200201202203204205Unnamed: 6 银行卡200201202203204205Unnamed: 7 支出明细微信100101102103104105Unnamed: 8 支付宝505152535455Unnamed: 9 现金808182838485Unnamed: 10 银行卡
2025年财务收支日记账明细表（饼形图）-Sheet1 Unnamed: 0 财务收支日记账明细表 日期2019.12.12019.12.22019.12.32019.12.42019.12.52019.12.6Unnamed: 2 项目名称Unnamed: 3 收入明细微信200201202203204205Unnamed: 4 支付宝200201202203204205Unnamed: 5 现金200201202203204205Unnamed: 6 银行卡200201202203204205Unnamed: 7 支出明细微信100101102103104105Unnamed: 8 支付宝505152535455Unnamed: 9 现金80
2025年财务收支日记账明细表-Sheet1 Unnamed: 0 Unnamed: 1 序号1234567891011121314财务收支日记账明细表 日期2020.3.302020.3.312020.3.322020.3.332020.3.342020.3.352020.3.362020.3.372020.3.382020.3.392020.3.402020.3.412020.3.422020.3.43Unnamed: 3 收入明细微信200201202203204205206207208209210211212213Unnamed: 4 支付宝200201202203204205206207208209210211
2025年工资发放明细账-自动计算-新进员工人事档案 Unnamed: 0 2019年新进员工信息 工号110011110012110013110014110015110016110017110018110019110020110021110022110023110024110025110026110027110028110029110030110031Unnamed: 2 姓名Unnamed: 3 性别女女男女女女男女男女男男男男男女女男男女男Unnamed: 4 身份证号Unnamed: 5 出生日期Unnamed: 6 入职日期2019.1.12019.1.22019.1.32019.1.42019.1.52019.1.62019.1.72019.1.8......
2025年财务金额明细账-Sheet1 Unnamed: 0 财务金额明细账 编号年月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 十
2025年资金出入明细账-Sheet1 Unnamed: 0 Unnamed: 1 资金出入明细账账户名称：中国银行账户基本信息日期441364413644136441374413744138Unnamed: 2 凭证字号记-001记-002记-003记-004记-005Unnamed: 3 内容摘要期初余额支付差旅费支付员工培训费购入研发材料收到货款支付供应商货款Unnamed: 4 借方合计会计科目一级科目管理费用管理费用管理费用应收账款应付账款Unnamed: 5 6565二科科目差旅费福利费材料耗用Unnamed: 6 三级科目培训费Unnamed: 7 贷方合计分类核算部门分类采购部行政部研发部Unnamed: 8 1000项目分类项目1Unnamed: 9 客户分类客户1Unnamed: 10
2025年快递登记明细账-Sheet1 Unnamed: 0 快递运费登记表 序号1234567891011121314Unnamed: 2 明细日期44134441374413644138Unnamed: 3 寄件部门销售部销售部销售部生产部Unnamed: 4 寄件人小刘小张小米小王Unnamed: 5 快递公司快递1快递2快递1快递3Unnamed: 6 快递单号X12356X12357X12358X12359Unnamed: 7 收件公司客户1客户2客户3客户1Unnamed: 8 收件人杨小姐刘先生罗先生王工Unnamed: 9 寄件理由货物样品文件样品Unnamed: 10 运费支付寄付月结√√Unnamed: 11 到付运费√Unnamed: 12 寄件金额8988Unnamed: 13 Unnamed: 14 寄件金额统计(快递公司)快递公司快递1
2025年材料入库明细账-Sheet1 材料入库明细账 自助查询序号1234567891011121314本月合计数Unnamed: 1 日期7-177-177-18Unnamed: 2 物料编码A.0001单据编号200100120010022001003Unnamed: 3 物料编码A.0001A.0002A.0002Unnamed: 4 物料名称梳子物料名称梳子牙膏牙膏Unnamed: 5 型号规格1*2型号规格1*21*31*3Unnamed: 6 入库数量180入库数量20018015001880Unnamed: 7 入库单价0.555555555555556入库单价52.32.5Unnamed: 8
2025年财务收支日记账明细表-财务收支日记账明细表 期初预算 期末结余日期2020-10-01 00:00:002020-10-02 00:00:002020-10-03 00:00:002020-10-04 00:00:002020-10-05 00:00:002020-10-06 00:00:002020-10-07 00:00:002020-10-08 00:00:002020-10-09 00:00:002020-10-10 00:00:002020-10-11 00:00:002020-10-12 00:00:00500000 553212凭证号100110021003100410051006100710081009101010111012收入金额 支出金额收支摘要391197 337985类目财务收支日记账明细表 收入374064996128230602374580554015274865605931998Unnamed: 5 支出305564472943664......
2025年管理费用明细账（组数公式计算）-管理费用明细账 Unnamed: 0 Unnamed: 1 管理费用明细账笔数2222322222223222330003300000000000000000000000000000000000000000000000000000......
2025年固定资产明细账-Sheet1 Unnamed: 0 固定资产明细账 名称：台式电脑序号1234567891011121314151617181920212223242526272829303132Unnamed: 2 日期2020-10-01 00:00:002020-10-27 00:00:002020-11-25 00:00:002020-12-25 00:00:00Unnamed: 3 资产编号：KID158凭证号1526Unnamed: 4 摘要期初余额购入固定资产折旧折旧Unnamed: 5 使用部门：销售部Unnamed: 6 单价5210Unnamed: 7 使用年限：6年购进或调入数量1Unnamed: 8 金额5210000000000000000000000000000000Unnamed: 9 预计残值：521元报废或折旧转出 数量Unnamed: 10 金额0000000000000000000000000000000Un
2025年财务管理明细账-Sheet1 Unnamed: 0 Unnamed: 1 收入金额序号12Unnamed: 2 日期2019-01-02 00:00:002019-01-06 00:00:00Unnamed: 3 2000收入明细投资收益Unnamed: 4 支出金额收入金额2000Unnamed: 5 账户支付宝Unnamed: 6 200支出明细学习费用Unnamed: 7 余额支出金额200Unnamed: 8 账户现金Unnamed: 9 1800备注Unnamed: 10 Unnamed: 11 月份统计表月份一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份十一月份十二月份Unnamed: 12 收入20000000000000......
2025年财务收支日记账明细表-财务收支日记账明细表 财务收支日记账明细表 查询开始日期：查询结束日期：日期年202020202020202020202020202020202020Unnamed: 1 月111111111111111111Unnamed: 2 日2020-11-22 00:00:002020-11-23 00:00:002020-11-24 00:00:002020-11-25 00:00:002020-11-26 00:00:002020-11-27 00:00:002020-11-28 00:00:002020-11-29 00:00:002020-11-30 00:00:00Unnamed: 3 2020-11-22 00:00:002020-11-24 00:00:00凭证号202011222020112320201124202011252020112620201127202011282020112920201130Unnamed: 4 收入金额支出金额费用项目费用1费用2费
2025年收入支出明细账-（可查询）-Sheet1 Unnamed: 0 收入支出明细账 本期数额：查询选项：编号N001N002N003N004N005N006N007N008N009N010N011N012N013N014N015N016N017N018N019N020N021N022Unnamed: 2 2019年月5555555555Unnamed: 3 项目查询：日27282930313131313131Unnamed: 4 期初金额：项目名称项目1项目2项目1项目1项目2项目3项目4项目5项目6项目7Unnamed: 5 150000
2025年收入支出明细账-Sheet1 收入支出明细账 公司名称：编号Unnamed: 1 2019年月Unnamed: 2 日Unnamed: 3 项目名称Unnamed: 4 单价Unnamed: 5 收入数量Unnamed: 6 单位Unnamed: 7 合计----------------------Unnamed: 8 支出数量Unnamed: 9 单位Unnamed: 10 合计----------------------Unnamed: 11 出纳：
2025年银行流水明细账-Sheet1 Unnamed: 0 Unnamed: 1 银行流水明细账日期2020-08-02 00:00:002020-08-03 00:00:002020-08-04 00:00:002020-08-05 00:00:002020-08-06 00:00:002020-08-07 00:00:002020-08-08 00:00:002020-08-09 00:00:002020-08-10 00:00:00Unnamed: 2 摘要摘要1摘要2摘要3摘要4摘要5摘要6摘要7摘要8摘要9Unnamed: 3 对方科目材料费主营业务收入其他业务收入财务费用财务费用主营业务收入销售费用薪酬管理福利费Unnamed: 4 期初余额期末金额借方金额（收入）450028003200Unnamed: 5 25008600贷方金额（支出）12005007001000600400Unnamed: 6 借方金
2025年固定资产明细账单表格-原载入格式 固定资产明细分类账 购入日期：规格型号：2016年年200720082009201020112012Unnamed: 1 月121212121212Unnamed: 2 凭证号Unnamed: 3 2017-06-01 00:00:00摘要购入计提折旧计提折旧计提折旧计提折旧计提折旧累计折旧Unnamed: 4 单价2600Unnamed: 5 使用年限：年折旧率(额):借方数 量1Unnamed: 6 5年500购入或拨入 金额2600Unnamed: 7 借方数 量Unnamed: 8 预计残值：计量单位：报废或转出 金额Unnamed: 9 0台计提折旧1005005005005005002600U......
2025年管理费用明细账-Sheet1 Unnamed: 0 Unnamed: 1 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 备注
2025年商品出入库台账明细表-自动计算-Sheet1 商品出入库台账明细表 序号123456789101112131415161718192021合计Unnamed: 1 日期2020-06-01 00:00:002020-06-02 00:00:002020-06-03 00:00:002020-06-04 00:00:002020-06-05 00:00:002020-06-06 00:00:002020-06-07 00:00:002020-06-08 00:00:002020-06-09 00:00:002020-06-10 00:00:002020-06-11 00:00:002020-06-12 00:00:002020-06-13 00:00:002020-06-14 00:00:002020-06-15 00:00:002020-06-16 00:00:002020-06-17 00:00:002020-06-18 00:00:002020-06-19 00:00:002020-06-20 00:00:002020-06-21 00:00:00Unnamed......
2025年财务收支明细账目-Sheet1 Unnamed: 0 Unnamed: 1 收支明细表上期余额序号123456789101112131415161718192021222324收入合计Unnamed: 2 日期Unnamed: 3 收入Unnamed: 4 123456789.00.0Unnamed: 5 Unnamed: 6 备注Unnamed: 7 Unnamed: 8 本期余额序号123456789101112131415161718192021222324支出合计Unnamed: 9
2025年财务收支明细账（自动计算）-Sheet1 财务收支明细账 项目：20XX年月MTH1111出纳员：Unnamed: 1 日DATE1234Unnamed: 2 凭证单数量VOUCHER/NO183Unnamed: 3 摘 要DESCRIPTION上月结存年会场地租金购年会礼品提取现金Unnamed: 4 借（收入）方 DEBIT50000Unnamed: 5 贷（支出）方CREDIT600016000Unnamed: 6 单号：借或贷借借财务：Unnamed: 7 结 存 BALANCE856420850420834420884420884420884420884420884420884420884420884420884420884420884420884420884420884420
2025年会计科目明细账-(函数自动生成)-目录 Unnamed: 0 会计明细账模板-(函数自动汇总) Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5 产品编号：财务管理008说明 使用说明 Unnamed: 1 1. 数据有效性问题，在开发这款模板时候，采用了公式中的“定义名称”简单的说就是把复杂选项进行打包（可在 公式/名称管理器，查看）2. 会计凭证录入表中的总账科目严禁修改（修改后破坏了表的结构）摘要，明细科目可以修改，修改方法如下：比如新增主营业务成本中的明细科目，只需要在期初余额及会计科目设置表中第Am列第4行开始向下修改。修改摘要只需在BZ列第4行开始向下修改。以此类推。3.明细账及分类账
2025年财务收支明细账单-自动统计-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 财务收支明细表查询日期上期余额序号123456789101112131415161718192021222324收入合计Unnamed: 3 日期2020.4.12020.x.22020.x.32020.x.42020.x.52020.x.62020.x.72020.x.82020.x.92020.x.102020.x.112020.x.122020.x.132020.x.142020.x.152020.x.162020.x.172020.x.18Unnamed: 4 2020.4.1收入项目利润利润利润利润利润利润利润利润......
2025年财务收支明细账单（自动查询）-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 收入支出日记账编号Unnamed: 3 2019年月12121212121212121212121212121212121212121212Unnamed: 4 本期单项查询：日12345678910111213141516171819202122Unnamed: 5 项目名称项目1项目2项目1项目1项目2项目3项目4项目5项目6项目7项目8项目9项目10项目11
2025年固定资产明细账-封面 Unnamed: 0 Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4 迈特鞋业2013年固 定 资 产 明 细 分 类 账1 Unnamed: 0 Unnamed: 1 日 期年17Unnamed: 2 月1123456789101112Unnamed: 3 日1312831303130313130313031Unnamed: 4 凭证号 5-11 5-15 5-17 5-26 5-23 5-26 5-28 5-20 5-17 5-18 5-12 5-19只需填制红色部分，其它自动生成Unnamed: 5 固 定 资 产 明 细 分 类 账摘 要上年结转计提折旧计提折旧
2025年进销存明细账(仓库)-X月份 进销存明细表 统计月份：2018年6月序号1234567891011121314151617Unnamed: 1 所属部门Unnamed: 2 名称Unnamed: 3 规格Unnamed: 4 月初库存Unnamed: 5 单位Unnamed: 6 进出日期进出进出进出进出进出进出进出进出进出进出进出进出进出进出进出进出进出Unnamed: 7 月份进出数量记录1Unnamed: 8 2.0Unnamed: 9
