进销存及应收应付excel管理系统

进销存及应收应付管理系统采购明细表采购查询表销售明细表销售查询表库存统计表销售单付款明细表应付账款表收款明细应收账款表应收账款查询销售员图表分析产品分析表客户信息表供应商信息表产品信息表使用说明采购明细表日期采购单号产品名称规格单价数量金额采购员供应商名称地址联系电话备注43115A2018001N1包9602019200熊猫公司Axxxxxxxx供货周期短43115A2018001N2包12002024000熊猫公司Axxxxxxxx供货周期短43115A2018001N3包14402028800熊猫公司Axxxxxxxx供货周期短43115A2018002N4包16802033600熊猫公司Axxxxxxxx供货周期短43115A2018002N5台19202038400熊猫公司Axxxxxxxx供货周期短43130A2018002N6台21602043200熊猫公司Axxxxxxxx供货周期短43130A2018003N7台24002048000熊猫公司Axxxxxxxx供货周期短43130A2018003N8台26402052800熊猫公司Axxxxxxxx供货周期短43146A2018004N9套28802057600熊猫公司Axxxxxxxx供货周期短43146A2018004N10套31202062400熊猫公司Axxxxxxxx供货周期短43146A2018004N11套33602067200熊猫公司Axxxxxxxx供货周期短43146A2018004N12套36002072000熊猫公司Axxxxxxxx供货周期短返回首页采购明细查询采购单号产品名称采购员供应商名称公司C开始日期结束日期日期采购单号产品名称规格单价数量金额采购员供应商名称地址联系电话备注返回首页销售明细表日期销售单号产品名称规格单价数量金额销售员客户名称地址联系电话0201811A2018001N1包12002024000熊猫张1XXXXxxxx0201812A2018002N2包15001319500熊猫张2XXXXxxxx0201813A2018003N3包18001323400熊猫张3XXXXxxxx0201814A2018004N4包21001021000熊猫张4XXXXxxxx0201815A2018005N5台24002048000熊猫张5XXXXxxxx0201821A2018006N6台27001951300熊猫张6XXXXxxxx0201822A2018007N7台30001854000熊猫张1XXXXxxxx0201823A2018008N8台33001652800熊猫张2XXXXxxxx0201824A2018009N9套36001968400熊猫张3XXXXxxxx0201825A2018010N10套39001039000熊猫张4XXXXxxxx0201831A2018011N11套42001458800熊猫张5XXXXxxxx0201832A2018012N12套45001672000熊猫张6XXXXxxxx0201833A2018013N1包12001720400熊猫张1XXXXxxxx0201834A2018014N2包15001827000熊猫张2XXXXxxxx0201835A2018015N3包18001221600熊猫张3XXXXxxxx0201841A2018016N4包21001327300熊猫张4XXXXxxxx0201842A2018017N5台24001843200熊猫张5XXXXxxxx0201843A2018018N6台27001643200熊猫张6XXXXxxxx0201844A2018019N7台30001339000熊猫张1XXXXxxxx0201845A2018020N8台33001446200熊猫张2XXXXxxxx240201851A2018021N9套36001450400熊猫张3XXXXxxxx251201852A2018022N10套39002078000熊猫张4XXXXxxxx262201853A2018022N11套42001563000熊猫张5XXXXxxxx273201854A2018022N12套45001881000熊猫张6XXXXxxxx284201855A2018022N7台30001442000熊猫张6XXXXxxxx295201861A2018022N5台24001843200熊猫张5XXXXxxxx305201862A2018027N6台27001027000熊猫张6XXXXxxxx315201863A2018028N7台30001751000熊猫张1XXXXxxxx325201864A2018029N8台33001962700熊猫张2XXXXxxxx335201865A2018030N9套36001036000熊猫张3XXXXxxxx345201871A2018031N10套39002078000熊猫张4XXXXxxxx355201872A2018032N11套42002084000熊猫张5XXXXxxxx365201873A2018033N12套45001149500熊猫张5XXXXxxxx375201874A2018034N7台30001751000熊猫张6XXXXxxxx385201875A2018035N5台24001228800熊猫张1XXXXxxxx55555555555555555555555555555555555555555555555555555555555555555555返回首页XXX公司销售单客户名称张4客户地址XXXX订单编号A2018022联系电话xxxx序号产品名称规格单价数量金额1N10套390020780002N11套420015630003N12套450018810004N5台3000184320056合计大写贰拾陆万伍仟贰佰元整合计265200公司名称公司地址联系电话销售员熊猫返回首页销售明细查询销售单号产品名称销售员熊猫客户名称开始日期43221结束日期43311日期销售单号产品名称规格单价数量金额销售员客户名称地址联系电话245"月"1"日"A2018021N9套36001450400熊猫张3XXXXxxxx255"月"2"日"A2018022N10套39002078000熊猫张4XXXXxxxx265"月"3"日"A2018022N11套42001563000熊猫张5XXXXxxxx275"月"4"日"A2018022N12套45001881000熊猫张6XXXXxxxx285"月"5"日"A2018022N7台30001442000熊猫张6XXXXxxxx296"月"1"日"A2018022N5台24001843200熊猫张5XXXXxxxx306"月"2"日"A2018027N6台27001027000熊猫张6XXXXxx

xx316"月"3"日"A2018028N7台30001751000熊猫张1XXXXxxxx326"月"4"日"A2018029N8台33001962700熊猫张2XXXXxxxx336"月"5"日"A2018030N9套36001036000熊猫张3XXXXxxxx347"月"1"日"A2018031N10套39002078000熊猫张4XXXXxxxx357"月"2"日"A2018032N11套42002084000熊猫张5XXXXxxxx367"月"3"日"A2018033N12套45001149500熊猫张5XXXXxxxx377"月"4"日"A2018034N7台30001751000熊猫张6XXXXxxxx387"月"5"日"A2018035N5台24001228800熊猫张1XXXXxxxx0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回首页库存统计表库存金额合计816240产品名称规格上期库存入库数量入库价格入库金额出库数量出库价格出库金额库存库存金额安全下线库存上线N1包5020960192003712004440033316801045N2包50201200240003115004650039468001045N3包50201440288002518004500045648001045N4包50201680336002321004830047789601045N5台5020192038400682400163200238401045N6台602021604320045270012150035756001045N7台6020240048000793000237000124001045N8台602026405280049330016170031818401045N9套6020288057600433600154800371065601045N10套602031206240050390019500030936001045N11套6020336067200494200205800311041601045N12套602036007200045450020250035126000104500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回首页付款明细表日期供应商名称地址联系电话金额付款人收款人43174公司Axxxxxxxx40000熊猫小熊猫43175公

司Bxxxxxxxx80000熊猫小熊猫43176公司Cxxxxxxxx200000熊猫小熊猫返回首页应付账款供应商地址联系电话上期结存采购金额已付金额应付金额公司Axxxxxxx54720040000507200公司Bxxxxxxx080000-80000公司Cxxxxxxx0200000-200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回首页收款明细表日期销售单号客户名称地址联系电话金额交款人收款人43256A2018001张1xxxxxxxx10000熊猫小熊猫43257A2018002张2xxxxxxxx10500熊猫小熊猫43258A2018003张3xxxxxxxx11000熊猫小熊猫43259A2018004张4xxxxxxxx11500熊猫小熊猫43260A2018005张5xxxxxxxx12000熊猫小熊猫43261A2018006张6xxxxxxxx12500熊猫小熊猫43323A2018013张1xxxxxxxx13000熊猫小熊猫43324A2018014张2xxxxxxxx13500熊猫小熊猫43325A2018015张3xxxxxxxx14000熊猫小熊猫43326A2018016张4xxxxxxxx14500熊猫小熊猫43327A2018017张5xxxxxxxx15000熊猫小熊猫43328A2018018张6xxxxxxxx15500熊猫小熊猫返回首页应收账款订单号订单日期客户名称地址联系电话销售金额已收金额应收金额应收占百分比排名A2018002201812张2xxxxxxx1950010500900006228A2018003201813张3xxxxxxx23400110001240008526A2018004201814张4xxxxxxx2100011500950006527A2018005201815张5xxxxxxx48000120003600024718A2018006201821张6xxxxxxx5130012500388002661710A2018007201822张1xxxxxxx540000540003708A2018008201823张2xxxxxxx528000528003629A2018009201824张3xxxxxxx684000684004695A2018010201825张4xxxxxxx3900003900026715A2018011201831张5xxxxxxx588000588004037A2018012201832张6xxxxxxx720000720004944A2018013201833张1xxxxxxx2040013000740005130A2018014201834张2xxxxxxx27000135001350009324A2018015201835张3xxxxxxx2160014000760005229A2018016201841张4xxxxxxx27300145001280008825A2018017201842张5xxxxxxx43200150002820019321A2018018201843张6xxxxxxx4320015500277001902222A2018019201844张1xxxxxxx3900003900026715A2018020201845张2xxxxxxx4620004620031714A2018021201851张3xxxxxxx5040005040034612A2018022201852张4xxxxxxx307200030720021061A2018027201862张6xxxxxxx270000270001852327A2018028201863张1xxxxxxx5100005100035010A2018029201864张2xxxxxxx627000627004306A2018030201865张3xxxxxxx3600003600024718A2018031201871张4xxxxxxx780000780005353A2018032201872张5xxxxxxx840000840005762A2018033201873张5xxxxxxx4950004950033913A2018034201874张6xxxxxxx510000510003501034A2018035201875张1xxxxxxx2880002880019720xxxxxxx000000xxxxxxx000000xxxxxxx000000xxxxxxx000000xxxxxxx000000xxxxxxx000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回首页应收账款查询订单日期排名前20客户名称张1订单号订单日期客户名称地址联系电话销售金额已收金额应收金额应收占百分比排名10A20180072"月"2"日"张1xxxxxxx54000054000370822A20180194"月"4"日"张1xxxxxxx390000390002671527A20180286"月"3"日"张1xxxxxxx510000510003501034A20180357"月"5"日"张1xxxxxxx2880002880019720返回首页月份销售员张盈王磊刘蕊赵无双郭辰合计张盈10000000王磊20000000刘蕊30000000赵无双40000000郭辰50000000合计60000000700000008000000090000000100000000110000000120000000全年0000071返回首页13月份产品102030405060708090100110120合计1月合计1359002655001998001989003144002199002913000000016257002月N124000020400000000000444003月N219500027000000000000465004月N323400021600000000000450005月N421000002730000000000483006月N548000004320004320028800000001632007月N60513000432000270000000001215008月N7054000039000420005100051000000002370009月N805280004620006270000000016170010月N906840000504003600000000015480011月N1003900000780000780000000019500012月N11005880006300008400000000205800合计N1200720000810000495000000020250012000000000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回首页客户信息表客户名称地址联系电话张1xxxxx张2xxxxx张3xxxxx张4xxxxx张5xxxxx张6xxxxx返回首页产品信息表产品名称规格销售单价采购单价N1包1200960N2包15001200N3包18001440N4包21001680N5台24001920N6台27002160N7台30002400N8台33002640N9套36002880N10套39003120N11套42003360N12套45003600返回首页供应商信息表供应商地址联系电话备注公司Axxxxxxx供货周期短公司Bxxxxxxx可压尾款公司Cxxxxxxx返回首页使用说明1客户信息表产品信息表客户信息表账龄分类标准为基础信息表启用本系统前填写2销售明细表为日常记录表逐项填写其中规格单价地址联系电话自动生成无需录入采购明细表为日常记录表逐项填写其中规格单价金额地址联系电话备注自动生成无需录入3销售查询表采购查询为查询表根据需求多条件组合查询未录入的条件默认为不做需求4销售单首次使用填写公司名称地址和电话以后再次使用只需填写销售单号其他 内容 财务内部控制制度的内容财务内部控制制度的内容人员招聘与配置的内容项目成本控制的内容消防安全演练内容 自动生成5销售员图表分析为统计分析类表格首次使用填写输入销售员的姓名即可本系统可以自动标记每个月最低和最高的销售员同时采用高级图表分析图表有下拉选择可以选择分析某个销售员进行逐月分析也可以所有销售员逐月分析同时可以分析每个各个销售员或者所有销售员的销售情况6产品分析表为统计分析类表格无需任何录入本表格采用高级图表分析下拉精确分析每个月销售占比或者每种商品销售走势7收款明细表付款明细表为日常记录表逐项填写其中地址联系电话自动生成无需录入8应收账款为统计分析类表格首次使用填写客户名称和上期应收结转无上期结转的可以不录入应收账款为统计分析类表格首次使用填写供应商名称和上期结存其他内容自动生成9应收账款查询表根据应收账款的查询条件多维组合查询需要查询的信息既可以查询一个公司不同订单的查询情况也可查询查询应收金额较多的应收信息基本上满足了应收账款的一些查询类型10库存表为统计类表格首次使用只需输入库存名称如果有上期库存需要输入其他内容自动生成该系统可以设置最低最高库存并标记不同颜色既可以避免因库存不足造成的缺货紧张又能避免库存过高带来的资金积压问题返回首页