《Excel表格模板：产成品进销存系统及应收账款管理.xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：产成品进销存系统及应收账款管理.xlsx（69页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、产成品进销存系统及应收账款管理入库明细销售明细产成品库存库存查询表收款记录应收账款统计参数表使用说明库存查询表使用说明产产成成品品入入库库记记录录表表日日期期产产品品编编码码 产产品品名名称称 规规格格型型号号数数量量入入库库人人备备注注2016/1/1P001产品120*545张三2016/1/2P002产品231*5410张三2016/1/3P003产品331*8460张三2016/1/4P004产品462*7590张三2016/1/5P005产品546*4547张三2016/1/6P006产品696*1249张三首页首页产产成成品品销销售售记记录录表表日日期期物物料料编编码码 物物料料名
2、名称称 规规格格型型号号 数数量量单单价价金金额额客客户户名名称称2015/2/8P001产品120*54110001000客户A2015/2/9P002产品231*5462001200客户B2015/2/10P003产品331*84251002500客户C2015/2/11P004产品462*752500010000客户D2015/2/12P005产品546*45203406800客户A2015/2/13P006产品696*123061218360客户C0000000000000000000000000000000000000000000000000000000000000000000000
3、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
4、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
5、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
6、0000000000000000000000备备注注首页产产成成品品库库存存统统计计表表物物料料编编码码 物物料料名名称称规规格格型型号号期期初初库库存存入入库库数数量量销销售售数数量量库库存存数数量量P001产品120*542516P002产品231*5401064P003产品331*844602539P004产品462*75090288P005产品546*4510472037P006产品696*121493020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
7、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
8、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
9、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
10、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
11、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000备备注注首页库库存存查查询询表表请请输输入入要要查查询询的的产产品品编编码码P001P001产产品品名名称称产产品品1 1规规格格型型号号20*5420*54入入库库数数量量5 5销销售售数数量量1 1库库存存数数量量6 6首页
12、收收款款记记录录表表日日期期客客户户名名称称金金额额备备注注3月1日客户A70003月2日客户B12003月3日客户C100004月3日客户D100005月10日客户C10000首页首页应应收收账账款款统统计计供供应应商商总总应应收收金金额额已已收收金金额额剩剩余余应应收收金金额额客户A78007000800客户B120012000客户C2086020000860客户D10000100000000000000000000000000000000000000000000000首页产品编码产品名称规格型号P001产品120*54P002产品231*54P003产品331*84P004产品462*75P005产品546*45P006产品696*12首页使使用用说说明明1、在入库明细及销售明细中按照所列内容进行录入即可，若需要增加记录的项目，在入库及销售明细表后面自行添加即可2、产成品库存表中，需填入期初库存，入库数量、销售数量及库存数量中的公式下拉即可3、库存查询表，输入所要查询的编码即可查询入库、销售数量即库存4、收款记录表，客户的收款记录在该表中输入5、应收账款统计表，需先列出所有的客户名称，即可自动统计每个客户总应收金额、已收金额、剩余应收金额6、如果未涉及与客户的账务往来，收款记录，应收账款统计表不用记录即可7、所有的公式均拉了一定数量的行数，若不够自行下拉即可首页