《进销存系统及应收账款管理excel系统含销售分析图表.xlsx》由会员分享，可在线阅读，更多相关《进销存系统及应收账款管理excel系统含销售分析图表.xlsx（1374页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、进销存系统及应收账款管理（含销售分析图表）采购明细表销售明细表采购查询表销售查询表库存表收款明细表应收账款销售图表分析客户信息表供应商信息表使用说明产品信息表进销存系统及应收账款管理（含销售分析图表）供应商信息表采购明细表日期采购单号产品名称规格单价数量金额采购员供应商名称1月15日A2017001N1包9602019200张伟公司A1月15日A2017001N2包12002024000张伟公司A1月15日A2017001N3包14402028800张伟公司A1月15日A2017002N4包16802033600张伟公司B1月15日A2017002N5台19202038400张伟公司B1月30
2、日A2017002N6台21602043200张伟公司B1月30日A2017003N7台24002048000张伟公司C1月30日A2017003N8台26402052800张伟公司C2月15日A2017003N9套28802057600张伟公司C2月15日A2017003N10套31202062400张伟公司C2月15日A2017003N11套33602067200张伟公司C2月15日A2017003N12套36002072000张伟公司C地址联系电话备注北京市房山区181*6915供货周期短北京市房山区181*6915供货周期短北京市房山区181*6915供货周期短郑州市金水区177*65
3、19可压尾款郑州市金水区177*6519可压尾款郑州市金水区177*6519可压尾款天津市滨海新区135*95470天津市滨海新区135*95470天津市滨海新区135*95470天津市滨海新区135*95470天津市滨海新区135*95470天津市滨海新区135*95470采购查询采购单号A2017002产品名称采购员供应商名称开始日期结束日期日期采购单号产品名称规格单价数量金额采购员 供应商名称1月15日A2017002N4包16802033600张伟公司B1月15日A2017002N5台19202038400张伟公司B1月30日A2017002N6台21602043200张伟公司B地址联
4、系电话备注郑州市金水区177*6519可压尾款郑州市金水区177*6519可压尾款郑州市金水区177*6519可压尾款销售明细表日期销售单号产品名称规格单价数量金额销售员1月1日A2017001N1包12002024000张盈1月2日A2017002N2包15001319500王磊1月3日A2017003N3包18001323400刘蕊1月4日A2017004N4包21001021000赵无双1月5日A2017005N5台24002048000郭辰2月1日A2017006N6台27001951300张盈2月2日A2017007N7台30001854000王磊2月3日A2017008N8台330
5、01652800刘蕊2月4日A2017009N9套36001968400赵无双2月5日A2017010N10套39001039000郭辰3月1日A2017011N11套42001458800张盈3月2日A2017012N12套45001672000王磊3月3日A2017013N1包12001720400刘蕊3月4日A2017014N2包15001827000赵无双3月5日A2017015N3包18001221600郭辰4月1日A2017016N4包21001327300张盈4月2日A2017017N5台24001843200王磊4月3日A2017018N6台27001643200刘蕊4月4日A
6、2017019N7台30001339000赵无双4月5日A2017020N8台33001446200郭辰5月1日A2017021N9套36001450400张盈5月2日A2017022N10套39002078000王磊5月3日A2017023N11套42001563000刘蕊5月4日A2017024N12套45001881000赵无双5月5日A2017025N7台30001442000郭辰6月1日A2017026N5台24001843200张盈6月2日A2017027N6台27001027000王磊6月3日A2017028N7台30001751000刘蕊6月4日A2017029N8台33001
7、962700赵无双6月5日A2017030N9套36001036000郭辰7月1日A2017031N10套39002078000张盈7月2日A2017032N11套42002084000王磊7月3日A2017033N12套45001149500刘蕊7月4日A2017034N7台30001751000赵无双7月5日A2017035N5台24001228800郭辰客户名称地址联系电话张1北京市朝阳区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张1北京市朝阳区135*3
8、451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张1北京市朝阳区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张1北京市朝阳区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张6天津市滨海区135*9666张5天津市滨海区1
9、31*9555张6天津市滨海区135*9666张1北京市朝阳区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张5天津市滨海区131*9555张6天津市滨海区135*9666张1北京市朝阳区135*3451销售查询表销售单号产品名称销售员张盈客户名称开始日期结束日期日期销售单号 产品名称 规格 单价数量金额销售员客户名称 地址1月1日A2017001N1包120020#张盈张1北京市朝阳区2月1日A2017006N6台270019#张盈张6天津市滨海区3月1日A2017011N11套420014#张
10、盈张5天津市滨海区4月1日A2017016N4包210013#张盈张4天津市和平区5月1日A2017021N9套360014#张盈张3北京市丰台区6月1日A2017026N5台240018#张盈张5天津市滨海区7月1日A2017031N10套390020#张盈张4天津市和平区联系电话135*3451135*9666131*9555177*9654135*9653131*9555177*9654库存统计表产品名称规格上期库存 入库数量 入库价格 入库金额 出库数量 出库价格 出库金额N1包50209601920037120044400N2包502012002400031150046500N3包5
11、02014402880025180045000N4包502016803360023210048300N5台5020192038400682400163200N6台6020216043200452700121500N7台6020240048000793000237000N8台6020264052800493300161700N9套6020288057600433600154800N10套6020312062400503900195000N11套6020336067200494200205800N12套602036007200045450020250000000000000000000000000
12、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
13、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
14、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
15、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
16、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
17、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
18、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
19、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
20、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
21、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
22、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
23、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000库存金额合计816240库存库存金额 安全库存333168030394680030456480030477896030238403035756003012400303181840303710656030309360030311041603035126000300000000000000000000000000000
24、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
25、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
26、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
27、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000收款明细表日期客户名称地址联系电话金额交款人收款人6月5日张1北京市朝阳区 135*345150000张含李静6月6日张2北京市怀柔区 181*6
28、66855000张2李静6月7日张3北京市丰台区 135*965360000张3李静6月8日张4天津市和平区 177*965465000张4李静6月9日张5天津市滨海区 131*955570000王磊李静6月10日张6天津市滨海区 135*966675000张6李静8月11日张1北京市朝阳区 135*345180000张含李静8月12日张2北京市怀柔区 181*666885000张2李静8月13日张3北京市丰台区 135*965390000张3李静8月14日张4天津市和平区 177*965495000张4李静8月15日张5天津市滨海区 131*9555 150000王磊李静8月16日张6天津市
29、滨海区 135*9666 220000张6李静应收账款客户名称地址联系电话上期结转应收 销售金额 已收金额 应收金额张1北京市朝阳区 135*345125000217200130000112200张2北京市怀柔区 181*666820820014000068200张3北京市丰台区 135*96533000019980015000079800张4天津市和平区 177*965424330016000083300张5天津市滨海区 131*9555389700220000169700张6天津市滨海区 135*96663675002950007250000000000000000000000000000
30、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
31、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
32、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
33、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
34、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000应收占百分比排名19.16%211.64%613.62%414.22%328.97%112.38%50.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
35、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
36、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
37、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
38、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
39、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
40、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.0
41、0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%月份销售员张盈王
42、磊刘蕊赵无双郭辰合计1月24000195002340021000480001359002月51300540005280068400390002655003月58800720002040027000216001998004月27300432004320039000462001989005月50400780006300081000420003144006月43200270005100062700360002199007月78000840004950051000288002913008月0000009月00000010月00000011月00000012月000000全年33300037770030
43、3300350100261600张盈20%王磊23%刘蕊19%赵无双22%郭辰16%销售员销售对比全年销售量对比图1月2月3月4月5月6月7月8月9月10月11月12月张盈王磊刘蕊赵无双郭辰2400051300588002730050400432007800000000销售员月销量对比1月2月3月4月5月6月7月8月9月10月11月12月0100002000030000400005000060000700008000090000全年张盈全年销售量对比图1月2月3月4月5月6月7月8月9月10月11月12月张盈王磊刘蕊赵无双郭辰2400051300588002730050400432007800
44、000000销售员月销量对比1月2月3月4月5月6月7月8月9月10月11月12月0100002000030000400005000060000700008000090000客户信息表客户名称地址联系电话张1北京市朝阳区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666产品信息表产品名称规格销售单价 采购单价N1包1200960N2包15001200N3包18001440N4包21001680N5台24001920N6台27002160N7台30002400N8台330
45、02640N9套36002880N10套39003120N11套42003360N12套45003600供应商信息表供应商地址联系电话备注公司A北京市房山区181*6915供货周期短公司B郑州市金水区177*6519可压尾款公司C天津市滨海新区 135*9547使用说明1、【客户信息表】【产品信息表】【客户信息表】为基础信息表，启用本系统前填写2、【销售明细表】为日常记录表，逐项填写（其中规格、单价、地址、联系电话自动生成无需录入）【采购明细表】为日常记录表，逐项填写（其中规格、单价、金额、地址、联系电话、备注自动生成无需录入）3、【销售查询表】【采购查询】为查询表，根据需求多条件组合查询（未录入的条件默认为不做需求）4、【销售图表分析】为统计分析类表格，首次使用填写输入销售员的姓名即可，本系统采用高级图表分析，图表有下拉选择，可以选择分析某个销售员进行逐月分析，也可以所有销售员逐月分析，同时可以分析每个各个销售员或者所有销售员的销售情况5、【收款明细表】为日常记录表，逐项填写（其中地址、联系电话自动生成无需录入）6、【应收账款】为统计分析类表格,首次使用填写客户名称和上期应收结转(无上期结转的可以不录入)7、【库存表】为统计类表格首次使用只需输入库存名称（如果有上期库存需要输入）其他内容自动生成