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

《Excel表格模板：进销存管理系统(带库存预警-盘点报表-应收应付).xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：进销存管理系统(带库存预警-盘点报表-应收应付).xlsx（224页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、基础信息基础信息基础信息基础信息基础信息应收应付盘点查询进销存基础信息基础信息基础信息使用说明商品参数供应商信息客户信息表入库明细表出库明细表库存统计表出库明细表库存统计表盘点报表应收汇总表付款明细表收款明细表应付汇总表进进销销存存管管理理系系统统（带库存预警，应收应付，盘点报表,利润统计）商品查询表利润统计表应收应付应收汇总表付款明细表收款明细表应付汇总表进进销销存存管管理理系系统统商品参数表商品编码商品名称规格型号单位A0001商品1规格1型号1个A0002商品2规格2型号2个A0003商品3规格3型号3个A0004商品4规格4型号4个A0005商品5规格5型号5个返回主页入库明细表序号入

2、库日期商品编码名称规格型号单位入库数量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返回主页00000000000000000000000000000000000000000000000000000000000000000000000000000

3、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

4、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

5、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000出库明细表序号出库日期商品编码名

6、称规格型号单位出库数量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返回主页000000000000000000000000000000000000000000000000000000000000000000000000000

7、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

8、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

9、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存明细表商品编码商品名

10、称规格型号单位期初库存进货统计数 量金额A0001商品1规格1型号1个503950A0002商品2规格2型号2个403560A0003商品3规格3型号3个605940A0004商品4规格4型号4个10010900A0005商品5规格5型号5个00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

11、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

12、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

13、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

14、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

15、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000销售统计库 存安全库存 库存预警数 量金额2931612150报警2327371720报警1418064640安全99197011500报警000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页0000000000000000000000000000

16、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

17、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

18、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

19、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

20、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存盘点表序号商品编码 商品名称规格型号单位账面数量 实盘数量 盈亏数量单价1A0001商品1规格1型号1个2120-1792A0002商品2规格2型号2个1710-7893A0003商品3规格3型号3个46504994A0004商品4规格4型号4个15445431095A0005商

21、品5规格5型号5个001196000700080009000100001100012000130001400015000160001700018000190002000021000220002300024000250002600027000280002900030000310003200033000340003500036000370003800039000400004100042000430004400045000460004700048000490005000051000520005300054000550005600057000580005900060000610006200063000

22、640006500066000670006800069000700007100072000730007400075000760007700078000790008000081000820008300084000850008600087000880008900090000910009200093000940009500096000970009800099000100000101000102000103000104000105000106000107000108000109000110000111000112000113000114000115000116000117000118000119000

23、120000121000122000123000124000125000126000127000128000129000130000131000132000133000134000135000136000137000138000139000140000141000142000143000144000145000146000147000148000149000150000151000152000153000154000155000156000157000158000159000160000161000162000163000164000165000166000167000168000169000

24、170000171000172000173000174000175000176000177000178000179000180000181000182000183000184000185000186000187000188000189000190000191000192000193000194000195000196000197000198000盈亏金额状态备 注-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正常

25、0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常

26、0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常0正常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单位：个入库总金额：39

27、50出库总金额：3161库存预警：报警返回主页请在下方单元格输入查询商品编码付款明细表日期供应商金额付款方式付款人备注5月4日供应商110005月5日供应商230005月6日供应商324005月7日供应商454000返回主页应付统计表供应商进货金额已付金额剩余金额备注供应商1395010002950供应商235603000560供应商3594024003540供应商41090054000-43100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

28、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

29、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页收款明细日期客户名称金额付款人付款方式备注5月5日客户131615月6日客户210005月7日客户39905月8日客户44000返回主页应收统计表客户名称销售金额已付金额应收金额备注客户1316131610客户22737100017

30、37客户31806990816客户4197014000157010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

31、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

32、00000000000000返回主页供应商信息表序号供应商名称地址联系电话联系人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入库表：根据内容输入

33、信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。5商品查询表：只需输入商品名称，其他自动生成。无需手动输入。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，玫红色表示“盘亏”红色表示“盘盈”。7付款明细表和收款明细表依次录入信息。8应付统计表：只需输入供应商名称，其他设有公式，自动生成。9应收统计表：只需输入客户名称，其他设有公式，自动生成。10利润统计：自动生成每月总销售收入，总支出金额，利润。返回主页2入库表：根据内容输入信息，商品编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。3出库表：根据内容输入信息，物料编码下拉列表选择，灰色区域设有公式，自动生成。无需手动输入。4库存统计表：只需输入期初数量和安全库存，灰色区域设有公式，自动生成。无需手动输入。红色表示低于或等于安全库存。6物料盘点表：只需输入实盘数量和单价，其他设有公式，自动生成。自动盘点盈亏，玫红色表示“盘亏”红色表示“盘盈”。