Excel表格模板：进销存管理系统(带库存预警-盘点报表-应收应付).xlsx

基础信息基础信息基础信息基础信息基础信息应收应付盘点查询进销存基础信息基础信息基础信息使用说明商品参数供应商信息客户信息表入库明细表出库明细表库存统计表出库明细表库存统计表盘点报表应收汇总表付款明细表收款明细表应付汇总表进进销销存存管管理理系系统统（带库存预警，应收应付，盘点报表,利润统计）商品查询表利润统计表应收应付应收汇总表付款明细表收款明细表应付汇总表进进销销存存管管理理系系统统商品参数表商品编码商品名称规格型号单位A0001商品1规格1型号1个A0002商品2规格2型号2个A0003商品3规格3型号3个A0004商品4规格4型号4个A0005商品5规格5型号5个返回主页入库明细表序号入库日期商品编码名称规格型号单位入库数量12018/5/1A0001商品1规格1型号1个5022018/5/2A0002商品2规格2型号2个4032018/5/3A0003商品3规格3型号3个6042018/5/4A0004商品4规格4型号4个100单价金额供应商名称入库人793950供应商1张三893560供应商2张三995940供应商3张三10910900供应商4张三000000000000000000000000000000000返回主页0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000出库明细表序号出库日期商品编码名称规格型号单位出库数量12018/5/2A0001商品1规格1型号1个2922018/5/3A0002商品2规格2型号2个2332018/5/4A0003商品3规格3型号3个1442018/5/5A0004商品4规格4型号4个99A0001商品1规格1型号1个单价金额客户名称出库人1093161客户1李四1192737客户2李四1291806客户3李四19919701客户4李四0000000000000000000000000000000返回主页000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存明细表商品编码商品名称规格型号单位期初库存进货统计数 量金额A0001商品1规格1型号1个503950A0002商品2规格2型号2个403560A0003商品3规格3型号3个605940A0004商品4规格4型号4个10010900A0005商品5规格5型号5个00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000销售统计库 存安全库存 库存预警数 量金额2931612150报警2327371720报警1418064640安全99197011500报警000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存盘点表序号商品编码 商品名称规格型号单位账面数量 实盘数量 盈亏数量单价1A0001商品1规格1型号1个2120-1792A0002商品2规格2型号2个1710-7893A0003商品3规格3型号3个46504994A0004商品4规格4型号4个15445431095A0005商品5规格5型号5个001196000700080009000100001100012000130001400015000160001700018000190002000021000220002300024000250002600027000280002900030000310003200033000340003500036000370003800039000400004100042000430004400045000460004700048000490005000051000520005300054000550005600057000580005900060000610006200063000640006500066000670006800069000700007100072000730007400075000760007700078000790008000081000820008300084000850008600087000880008900090000910009200093000940009500096000970009800099000100000101000102000103000104000105000106000107000108000109000110000111000112000113000114000115000116000117000118000119000120000121000122000123000124000125000126000127000128000129000130000131000132000133000134000135000136000137000138000139000140000141000142000143000144000145000146000147000148000149000150000151000152000153000154000155000156000157000158000159000160000161000162000163000164000165000166000167000168000169000170000171000172000173000174000175000176000177000178000179000180000181000182000183000184000185000186000187000188000189000190000191000192000193000194000195000196000197000198000盈亏金额状态备 注-79盘亏-623盘亏396盘盈59187盘盈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正常请在下方单元格输入查询商品编码A0001规格：规格1单位：型号1查询结果如下：入库总数量：50入库平均单价：79出库总数量：29出库平均单价：109商品剩余数量：21商品盈利/亏损情况：789单位：个入库总金额：3950出库总金额：3161库存预警：报警返回主页请在下方单元格输入查询商品编码付款明细表日期供应商金额付款方式付款人备注5月4日供应商110005月5日供应商230005月6日供应商324005月7日供应商454000返回主页应付统计表供应商进货金额已付金额剩余金额备注供应商1395010002950供应商235603000560供应商3594024003540供应商41090054000-43100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页收款明细日期客户名称金额付款人付款方式备注5月5日客户131615月6日客户210005月7日客户39905月8日客户44000返回主页应收统计表客户名称销售金额已付金额应收金额备注客户1316131610客户2273710001737客户31806990816客户419701400015701000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页供应商信息表序号供应商名称地址联系电话联系人1供应商1珠海11112供应商2珠海11123供应商3珠海11134供应商4珠海1114返回主页客户信息表序号客户名称地址联系电话联系人1客户1珠海1112客户2珠海1123客户3珠海1134客户4珠海114返回主页利润统计月份收入支出利润销售收入进货支出1月0002月0003月0004月0005月274052435030556月0007月0008月0009月00010月00011月00012月000合计27405243503055返回主页使用说明1商品参数，供应商信息，客户信息表中录入信息。2入库表：根据内容输入信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。5商品查询表：只需输入商品名称，其他自动生成。无需手动输入。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，玫红色表示“盘亏”红色表示“盘盈”。7付款明细表和收款明细表依次录入信息。8应付统计表：只需输入供应商名称，其他设有公式，自动生成。9应收统计表：只需输入客户名称，其他设有公式，自动生成。10利润统计：自动生成每月总销售收入，总支出金额，利润。返回主页2入库表：根据内容输入信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，玫红色表示“盘亏”红色表示“盘盈”。