《【进销存】进销存出入库管理表模板.xlsx》由会员分享,可在线阅读,更多相关《【进销存】进销存出入库管理表模板.xlsx(1634页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、进销存出入库管理表公司名称:XXXX有限公司期初日期:2021/2/1序号产品编码产品名称期初数量入库数量入库金额出库数量1120101产品1125400.0062120102产品2104200.0083120103产品375300.0064120104产品498240.0035120105产品5124160.0046120106产品6158400.0057120107产品7104120.0038120108产品8127280.0049120109产品9104240.00610120110产品1077350.00811120111产品1194160.00612120112产品12125100.
2、00313120113产品13158240.00414120114产品14104160.00515120115产品15128160.003产品数量:15单位:个出库金额库存数量安全库存库存提醒备注产品编码600.001110120101560.00610库存不足产品名称480.00610库存不足产品1150.001410期初数量240.00121012350.001810入库数量150.0011105240.001510入库金额480.00810库存不足¥400.00560.00610库存不足出库数量360.00710库存不足6120.001410出库金额200.001910¥600.0030
3、0.00910库存不足库存数量120.00171011安全库存10库存提醒进销存出入库管理表入库明细表日期产品编码产品名称入库数量入库单价入库金额备注2021/2/1120101产品1580.00400.002021/2/2120102产品2450.00200.002021/2/3120103产品3560.00300.002021/2/4120104产品4830.00240.002021/2/5120105产品5440.00160.002021/2/6120106产品6850.00400.002021/2/7120107产品7430.00120.002021/2/8120108产品8740.0
4、0280.002021/2/9120109产品9460.00240.002021/2/10120110产品10750.00350.002021/2/11120111产品11440.00160.002021/2/12120112产品12520.00100.002021/2/13120113产品13830.00240.002021/2/14120114产品14440.00160.002021/2/15120115产品15820.00160.00-出库明细表日期产品编码产品名称出库数量出库单价出库金额备注2021/2/1120101产品16100.00600.002021/2/2120102产品28
5、70.00560.002021/2/3120103产品3680.00480.002021/2/4120104产品4350.00150.002021/2/5120105产品5460.00240.002021/2/6120106产品6570.00350.002021/2/7120107产品7350.00150.002021/2/8120108产品8460.00240.002021/2/9120109产品9680.00480.002021/2/10120110产品10870.00560.002021/2/11120111产品11660.00360.002021/2/12120112产品12340.00120.002021/2/13120113产品13450.00200.002021/2/14120114产品14560.00300.002021/2/15120115产品15340.00120.00-