公司企业管理22 -应收账款管理系统(含账龄分析销售图表).xlsx

《公司企业管理22 -应收账款管理系统(含账龄分析销售图表).xlsx》由会员分享，可在线阅读，更多相关《公司企业管理22 -应收账款管理系统(含账龄分析销售图表).xlsx（157页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、应收账款管理系统Accounts receivable management销售明细表一二三四五六七八九十销售查询表销售图表分析（一）销售图表分析（二）产品销售分析应收账款台账收款明细表客户信息表产品信息表使用说明应收账款管理系统Accounts receivable management销售明细表日期销售单号产品名称规格单价数量金额2018/5/20A2017111N1包120020240002018/5/20A2017027N6台270010270002018/5/21A2017111N2包150013195002018/5/21A2017028N7台300017510002018/5/2

2、2A2017111N3包180013234002018/5/22A2017029N8台330019627002018/5/23A2018002N4包210010210002018/5/23A2017030N9套360010360002018/5/24A2018002N5台240020480002018/5/24A2017031N10套390020780002018/5/25A2018002N6台270019513002018/5/25A2017032N11套420020840002018/5/26A2018002N7台300018540002018/5/26A2017033N12套450011

3、495002018/5/27A2018003N8台330016528002018/5/27A2017034N7台300017510002018/5/28A2018003N9套360019684002018/5/28A2017035N5台240012288002018/6/5A2018003N10套390010390002018/6/6A2018003N11套420014588002018/6/7A2018004N12套450016720002018/6/8A2018004N1包120017204002018/6/9A2018004N2包150018270002018/6/10A2017015N

4、3包180012216002018/6/11A2017016N4包210013273002018/6/12A2017017N5台240018432002018/6/13A2017018N6台270016432002018/6/14A2017019N7台300013390002018/6/15A2017020N8台330014462002018/6/16A2017021N9套360014504002018/6/17A2017022N10套390020780002018/6/18A2017023N11套420015630002018/6/19A2017024N12套450018810002018/

5、6/20A2017025N7台300014420002018/6/21A2017026N5台24001843200销售员客户名称地址联系电话张盈张1北京市朝阳区135*3451王磊张6天津市滨海区135*9666张盈张1北京市朝阳区135*3451刘蕊张1北京市朝阳区135*3451张盈张1北京市朝阳区135*3451赵无双张2北京市怀柔区181*6668赵无双张4天津市和平区177*9654郭辰张3北京市丰台区135*9653赵无双张4天津市和平区177*9654张盈张4天津市和平区177*9654赵无双张4天津市和平区177*9654王磊张5天津市滨海区131*9555赵无双张1北京市朝阳

6、区135*3451刘蕊张5天津市滨海区131*9555刘蕊张2北京市怀柔区181*6668赵无双张6天津市滨海区135*9666刘蕊张2北京市怀柔区181*6668郭辰张1北京市朝阳区135*3451刘蕊张2北京市怀柔区181*6668刘蕊张2北京市怀柔区181*6668王磊张6天津市滨海区135*9666王磊张6天津市滨海区135*9666王磊张6天津市滨海区135*9666郭辰张3北京市丰台区135*9653张盈张4天津市和平区177*9654王磊张5天津市滨海区131*9555刘蕊张6天津市滨海区135*9666赵无双张1北京市朝阳区135*3451郭辰张2北京市怀柔区181*6668张

7、盈张3北京市丰台区135*9653王磊张4天津市和平区177*9654刘蕊张5天津市滨海区131*9555赵无双张6天津市滨海区135*9666郭辰张6天津市滨海区135*9666张盈张5天津市滨海区131*9555销售明细查询销售单号产品名称销售员客户名称开始日期2018/6/1结束日期日期销售单号产品名称规格单价数量金额销售员2018/6/5A2018003N10套39001039000刘蕊2018/6/6A2018003N11套42001458800刘蕊2018/6/7A2018004N12套45001672000王磊2018/6/8A2018004N1包12001720400王磊201

8、8/6/9A2018004N2包15001827000王磊2018/6/10A2017015N3包18001221600郭辰2018/6/11A2017016N4包21001327300张盈2018/6/12A2017017N5台24001843200王磊2018/6/13A2017018N6台27001643200刘蕊2018/6/14A2017019N7台30001339000赵无双2018/6/15A2017020N8台33001446200郭辰2018/6/16A2017021N9套36001450400张盈2018/6/17A2017022N10套39002078000王磊2018/

9、6/18A2017023N11套42001563000刘蕊2018/6/19A2017024N12套45001881000赵无双2018/6/20A2017025N7台30001442000郭辰2018/6/21A2017026N5台24001843200张盈2018/6/30客户名称地址联系电话张2北京市怀柔区181*6668张2北京市怀柔区181*6668张6天津市滨海区135*9666张6天津市滨海区135*9666张6天津市滨海区135*9666张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张1北京市朝阳

10、区135*3451张2北京市怀柔区181*6668张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666张6天津市滨海区135*9666张5天津市滨海区131*9555月份销售员张盈王磊刘蕊赵无双郭辰合计1月0000002月0000003月0000004月0000005月144900111000221700288000648008304006月1209002406002040001200001098007953007月0000008月0000009月00000010月00000011月00000012月000000全年2

11、65800351600425700408000174600张盈17%王磊13%刘蕊27%赵无双35%郭辰8%销售员销售对比全年销售量对比图1月2月3月4月5月6月7月8月9月10月11月12月张盈王磊刘蕊赵无双郭辰0000111000240600000000销售员月销量对比1月2月3月4月5月6月7月8月9月 10月 11月 12月0500001000001500002000002500003000005月王磊全年销售量对比图1月2月3月4月5月6月7月8月9月10月11月12月张盈王磊刘蕊赵无双郭辰0000111000240600000000销售员月销量对比1月2月3月4月5月6月7月8月9

12、月 10月 11月 12月050000100000150000200000250000300000今日日期9月2日近一周销量分析表销售员日期 8月28日 8月29日 8月30日 8月31日9月1日9月2日9月3日张盈0000000王磊0000000刘蕊0000000赵无双0000000郭辰0000000000000000000000000000合计00000000%55%45%0%0%0%0%0%0%0%0%0%0%0%0%0%29%16%16%14%25%0%0%0%0%0%0%0%0%0%0%0%周周销销量量对对比比图图张盈王磊刘蕊赵无双郭辰合计今日是第#周第#周销量分析销售员上周销量本周

13、销量增长百分比张盈0777000.00%王磊11940043200-63.82%刘蕊9780043200-55.83%赵无双0390000.00%郭辰0678000.00%000.00%000.00%000.00%合计21720027090024.72%0%55%45%0%0%0%0%0%0%0%0%0%0%0%0%0%29%16%16%14%25%0%0%0%0%0%0%0%0%0%0%0%周周销销量量对对比比图图张盈王磊刘蕊赵无双郭辰产品月份统计表产品名称1月2月3月4月5月6月7月8月9月#合计00008E+05 8E+05000N1000024000204000006N20000195

14、0027000000N300002340021600000N400002100027300000N500007680086400000N600007830043200000N700002E+0581000000N800001E+0546200000N900001E+0550400000N100000780001E+05000N110000840001E+05000000078000117000000000产品销售分析表1月2月3月4月5月6月7月8月9月10月11月12月第33周24%第34周25%第35周25%第36周26%近四周销售占比图N10产品周分析10月11月12月产品名称周数第33

15、周第34周第35周第36周000合计0000000N10000000N20000000N30000000N40000000N50000000N60000000N70000000N80000000N90000000N100000000N1100000000近四周销量走势表第33周第34周第35周第36周00.10.20.30.40.50.60.70.80.91N5第33周24%第34周25%第35周25%第36周26%近四周销售占比图应收账款管理台账订单编号客户名称地址联系电话订单日期账龄(天)A2017111张1北京市朝阳区 135*3451 2018/5/221199A2018002张4天津

16、市和平区 177*9654 2018/5/26A2018003张2北京市怀柔区 181*66682018/6/61184A2018004张6天津市滨海区 135*96662018/6/91181A2017015张3北京市丰台区 135*9653 2018/6/101180A2017016张4天津市和平区 177*9654 2018/6/111179A2017017张5天津市滨海区 131*9555 2018/6/121178A2017018张6天津市滨海区 135*9666 2018/6/131177A2017019张1北京市朝阳区 135*3451 2018/6/141176A2017020

17、张2北京市怀柔区 181*6668 2018/6/151175A2017021张3北京市丰台区 135*9653 2018/6/16A2017022张4天津市和平区 177*9654 2018/6/171173A2017023张5天津市滨海区 131*9555 2018/6/181172A2017024张6天津市滨海区 135*9666 2018/6/191171A2017025张6天津市滨海区 135*9666 2018/6/201170A2017026张5天津市滨海区 131*9555 2018/6/211169A2017027张6天津市滨海区 135*9666 2018/5/201201

18、A2017028张1北京市朝阳区 135*3451 2018/5/211200A2017029张2北京市怀柔区 181*6668 2018/5/221199A2017030张3北京市丰台区 135*9653 2018/5/231198A2017031张4天津市和平区 177*9654 2018/5/241197A2017032张5天津市滨海区 131*9555 2018/5/251196A2017033张5天津市滨海区 131*9555 2018/5/261195A2017034张6天津市滨海区 135*9666 2018/5/271194A2017035张1北京市朝阳区 135*3451 2

19、018/5/281193订单金额已收金额应收金额收款比例669000669000.00%1743001743000100.00%21900059542130462.72%11940001194000.00%2160018049355183.56%2730059162138421.67%432002822403786.53%432004305614499.67%3900029089991174.59%4620083683783218.11%50400504000100.00%78000398143818651.04%63000256973730340.79%81000450243597655.5

20、9%4200033767823380.40%43200156242757636.17%2700023430357086.78%510000510000.00%62700264603624042.20%3600028434756678.98%78000141766382418.17%84000297285427235.39%4950039589991179.98%5100051964580410.19%28800161191268155.97%00000000000000000000000000000000000000000000000000000000000000000000000000000

21、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

22、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

23、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

24、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

25、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

26、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

27、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

28、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

29、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

30、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

31、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

32、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

33、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

34、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000收款明细表日期订单号客户姓名金额收款人2018

35、/6/1A2018002张4174300李岩2018/6/2A2018003张25954李岩2018/6/3A2017015张318049李岩2018/6/4A2017016张45916李岩2018/6/5A2017017张52822李岩2018/6/6A2017018张643056李岩2018/6/7A2017019张129089李岩2018/6/8A2017020张28368李岩2018/6/9A2017022张439814李岩2018/6/10A2017023张525697李岩2018/6/11A2017024张645024李岩2018/6/12A2017025张633767李岩2018

36、/6/13A2017026张515624李岩2018/6/14A2017027张623430李岩2018/6/15A2017029张226460李岩2018/6/16A2017030张328434李岩2018/6/17A2017031张414176李岩2018/6/18A2017032张529728李岩2018/6/19A2017033张539589李岩2018/6/20A2017034张65196李岩2018/6/21A2017035张116119李岩2018/6/22A2017021张350400李岩客户信息表客户名称地址联系电话张1北京市朝阳区135*3451张2北京市怀柔区181*66

37、68张3北京市丰台区135*9653张4天津市和平区177*9654张5天津市滨海区131*9555张6天津市滨海区135*9666产品信息表产品名称规格单价N1包1200N2包1500N3包1800N4包2100N5台2400N6台2700N7台3000N8台3300N9套3600N10套3900N11套4200N12套4500使用说明1、【客户信息表】【产品信息表】为基础信息表，启用本系统前填写2、【销售明细表】为日常记录表，逐项填写（其中规格、单价、地址、联系电话自动提取无需录入）3、【销售查询表】为查询表，根据需求多条件组合查询（未录入的条件默认为不做需求）4、【销售分析一】为长期销售图表分析类表格，首次使用填写输入销售员的姓名即可，本系统采用高级图表分析，图表有下拉选择，可以选择分析某个销售员进行逐月分析，也可以所有销售员逐月分析，同时可以分析每个各个销售员或者所有销售员的销售情况5、【销售分析二】为短期销售图表分析类表格，主要分析近一周的销售情况,及相近周的销售对比,销售量上升和下降分别标记不同颜色,一目了然6、【产品销量分析】从产品的角度出发分析，该表既可以分析出不同产品的旺、淡季，也可以统计分析出近期产品的销售构成及走势7、【收款明细表】逐项填写收款信息8、【应收账款台账】需输入订单编号其他内容自动生成