Excel表格模板：进销存管理系统(简单实用).xlsx

商品参数表商品盘点表库存统计表销售出库表进货入库表进销存管理系统（简单实用）商品查询表使用说明商品盘点表进销存管理系统（简单实用）商品参数表商品编码商品名称规格型号单位A0001商品1规格1型号1个A0002商品2规格2型号2个A0003商品3规格3型号3个A0004商品4规格4型号4个A0005商品5规格5型号5个返回主页入库明细表商品编码名称规格型号单位入库数量单价金额A0001商品1规格1型号1个50793950A0002商品2规格2型号2个40893560A0003商品3规格3型号3个60995940A0004商品4规格4型号4个10001091090000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000入库日期入库人2018/1/1张三2018/1/2张三2018/1/3张三2018/1/4张三返回主页出库明细表商品编码名称规格型号单位出库数量单价金额A0001商品1规格1型号1个291093161A0002商品2规格2型号2个231192737A0003商品3规格3型号3个141291806A0004商品4规格4型号4个4561396338400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A0001商品1规格1型号1个00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000出库日期出库人2018/1/4李四2018/1/5李四2018/1/6李四2018/1/7李四返回主页库存明细表商品编码商品名称规格型号单位期初库存进货统计数 量金额A0001商品1规格1型号1个503950A0002商品2规格2型号2个403560A0003商品3规格3型号3个605940A0004商品4规格4型号4个1000109000A0005商品5规格5型号5个00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000销售统计库 存安全库存 库存预警数 量金额2931612150是2327371720是1418064640否45663384544500否000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存盘点表序号商品编码 商品名称规格型号单位账面数量 实盘数量 盈亏数量单价1A0001商品1规格1型号1个2120-1792A0002商品2规格2型号2个1710-7893A0003商品3规格3型号3个46504994A0004商品4规格4型号4个54454401095A0005商品5规格5型号5个001196000700080009000100001100012000130001400015000160001700018000190002000021000220002300024000250002600027000280002900030000310003200033000340003500036000370003800039000400004100042000430004400045000460004700048000490005000051000520005300054000550005600057000580005900060000610006200063000640006500066000670006800069000700007100072000730007400075000760007700078000790008000081000820008300084000850008600087000880008900090000910009200093000940009500096000970009800099000100000101000102000103000104000105000106000107000108000109000110000111000112000113000114000115000116000117000118000119000120000121000122000123000124000125000126000127000128000129000130000131000132000133000134000135000136000137000138000139000140000141000142000143000144000145000146000147000148000149000150000151000152000153000154000155000156000157000158000159000160000161000162000163000164000165000166000167000168000169000170000171000172000173000174000175000176000177000178000179000180000181000182000183000184000185000186000187000188000189000190000191000192000193000194000195000196000197000198000盈亏金额状态备 注-79盘亏-623盘亏396盘盈0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常返回主页0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常请在下方单元格输入查询商品商品1规格：规格1单位：型号1查询结果如下：入库总数量：50入库平均单价：79出库总数量：29出库平均单价：109商品剩余数量：21商品盈利/亏损情况：789单位：个入库总金额：3950出库总金额：3161库存预警：是返回主页使用说明1物料参数：依次录入商品的编码，名称，规格，单位。2入库表：根据内容输入信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。5商品查询表：只需输入商品名称，其他自动生成。无需手动输入。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，蓝色表示“盘亏”红色表示“盘盈”。返回主页2入库表：根据内容输入信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，蓝色表示“盘亏”红色表示“盘盈”。