EXCEL进销存账本

1、ExcelExcel进进销销存存记记账账本本 V2.0V2.0商商品品进进货货销销售售记记录录打打印印单单据据当当前前库库存存销销售售图图表表供供货货商商客客 户户简单易用、轻松管理一次性注册，终身使用。录入数据后，轻松统计客客 户户商商品品编编码码商商品品类类别别商商品品名名称称规规格格型型号号进进货货单单价价进进货货数数量量100000電池諾諾基基亞亞BL-4BBL-4B （紙紙）16.005100001電池諾諾基基亞亞BL-4CBL-4C（紙紙）16.005100002電池諾諾基基亞亞BL-4CTBL-4CT（紙紙）16.005100003電池諾諾基基亞亞BL-4DBL-4D（紙紙）16

2、.005100004電池諾諾基基亞亞BL-4SBL-4S（紙紙）16.005100005電池諾諾基基亞亞BL-4UBL-4U（紙紙）16.005100006電池諾諾基基亞亞BL-5BBL-5B （紙紙）16.005100007電池諾諾基基亞亞BL-5BTBL-5BT（紙紙）16.005100008電池諾諾基基亞亞BL-5CBL-5C （紙紙）16.005100009電池諾諾基基亞亞BL-5CTBL-5CT（紙紙）16.005100010電池諾諾基基亞亞BL-5FBL-5F（紙紙）16.005100011電池諾諾基基亞亞BL-5JBL-5J（紙紙）16.005100012電池諾諾基基亞亞BL-5

3、KBL-5K（紙紙）16.005100013電池諾諾基基亞亞BL-5UBL-5U（紙紙）16.00100014電池諾諾基基亞亞BL-5XBL-5X（紙紙）16.00100015電池諾諾基基亞亞BL-6FBL-6F（紙紙）16.005100016電池諾諾基基亞亞BL-6PBL-6P（紙紙）16.00100017電池諾諾基基亞亞BL-6QBL-6Q（紙紙）16.00100018電池諾諾基基亞亞BLB-2BLB-2（紙紙）16.005100019電池諾諾基基亞亞BLB-3BLB-3（紙紙）16.005100020電池諾諾基基亞亞BLC-2BLC-2 （紙紙）16.005100021電池諾諾基基亞亞B

4、P-4LBP-4L（紙紙）16.005100022電池諾諾基基亞亞BP-5MBP-5M（紙紙）16.005100023電池諾諾基基亞亞BP-6MBP-6M （紙紙）16.005100024電池諾諾基基亞亞BP-6MTBP-6MT（紙紙）16.005100025電池諾諾基基亞亞BP-6XBP-6X（紙紙）16.00100026電池諾諾基基亞亞BL-4JBL-4J（紙紙）16.00100027電池諾諾基基亞亞BL-4BBL-4B （鐵鐵）￥18.0020100028電池諾諾基基亞亞BL-4CBL-4C （鐵鐵）￥18.0020100029電池諾諾基基亞亞BL-4CTBL-4CT（鐵鐵）￥18.00

5、20100030電池諾諾基基亞亞BL-4DBL-4D（鐵鐵）￥18.0020100031電池諾諾基基亞亞BL-4SBL-4S（鐵鐵）￥18.0020100032電池諾諾基基亞亞BL-4UBL-4U（鐵鐵）￥18.0020100033電池諾諾基基亞亞BL-5BBL-5B （鐵鐵）￥18.0020100034電池諾諾基基亞亞BL-5BTBL-5BT（鐵鐵）￥18.0015100035電池諾諾基基亞亞BL-5CBL-5C （鐵鐵）￥18.0030100036電池諾諾基基亞亞BL-5CTBL-5CT（鐵鐵）￥18.0020100037電池諾諾基基亞亞BL-5FBL-5F（鐵鐵）￥18.00201000

6、38電池諾諾基基亞亞BL-5JBL-5J（鐵鐵）￥18.0030100039電池諾諾基基亞亞BL-5KBL-5K（鐵鐵）￥18.0020100040電池諾諾基基亞亞BL-5UBL-5U（鐵鐵）￥18.001100041電池諾諾基基亞亞BL-5XBL-5X（鐵鐵）￥18.0010100042電池諾諾基基亞亞BL-6FBL-6F（鐵鐵）￥18.0020100043電池諾諾基基亞亞BL-6PBL-6P（鐵鐵）￥18.004100044電池諾諾基基亞亞BL-6QBL-6Q（鐵鐵）￥18.002100045電池諾諾基基亞亞BLB-2BLB-2（鐵鐵）￥18.0015100046電池諾諾基基亞亞BLB-3

7、BLB-3（鐵鐵）￥18.0015100047電池諾諾基基亞亞BLC-2BLC-2 （鐵鐵）￥18.0015100048電池諾諾基基亞亞BP-4LBP-4L（鐵鐵）￥18.0020100049電池諾諾基基亞亞BP-5MBP-5M（鐵鐵）￥18.0015100050電池諾諾基基亞亞BP-6MBP-6M （鐵鐵）￥18.0020100051電池諾諾基基亞亞BP-6MTBP-6MT（鐵鐵）￥18.0020100052電池諾諾基基亞亞BP-6XBP-6X（鐵鐵）￥18.002100053電池諾諾基基亞亞BL-4JBL-4J（鐵鐵）￥18.00151000541000551000561000571000

8、581000591000601000611000621000631000641000651000661000671000681000691000701000711000721000731000741000751000761000771000781000791000801000811000821000831000841000851000861000871000881000891000901000911000921000931000941000951000961000971000981000991001001001011001021001031001041001051001061001071001

9、081001091001101001111001121001131001141001151001161001171001181001191001201001211001221001231001241001251001261001271001281001291001301001311001321001331001341001351001361001371001381001391001401001411001421001431001441001451001461001471001481001491001501001511001521001531001541001551001561001571001

10、581001591001601001611001621001631001641001651001661001671001681001691001701001711001721001731001741001751001761001771001781001791001801001811001821001831001841001851001861001871001881001891001901001911001921001931001941001951001961001971001981001991002001002011002021002031002041002051002061002071002

11、081002091002101002111002121002131002141002151002161002171002181002191002201002211002221002231002241002251002261002271002281002291002301002311002321002331002341002351002361002371002381002391002401002411002421002431002441002451002461002471002481002491002501002511002521002531002541002551002561002571002

12、581002591002601002611002621002631002641002651002661002671002681002691002701002711002721002731002741002751002761002771002781002791002801002811002821002831002841002851002861002871002881002891002901002911002921002931002941002951002961002971002981002991003001003011003021003031003041003051003061003071003

13、081003091003101003111003121003131003141003151003161003171003181003191003201003211003221003231003241003251003261003271003281003291003301003311003321003331003341003351003361003371003381003391003401003411003421003431003441003451003461003471003481003491003501003511003521003531003541003551003561003571003

14、581003591003601003611003621003631003641003651003661003671003681003691003701003711003721003731003741003751003761003771003781003791003801003811003821003831003841003851003861003871003881003891003901003911003921003931003941003951003961003971003981003991004001004011004021004031004041004051004061004071004

15、08100409100410100411100412100413100414100415100416返回主界面 单单位位合合计计进进货货日日期期进进货货人人供供货货商商备备注注顆￥80.002010/8/25顆￥80.002010/8/26顆￥80.002010/9/1顆￥80.002010/9/1顆￥80.002010/9/2顆￥80.002010/9/2顆￥80.002010/9/2顆￥80.002010/9/3顆￥80.002010/9/3￥80.00￥80.00￥80.00￥80.00￥0.00￥0.00￥80.00￥0.00￥0.00￥80.00￥80.00￥80.00￥80.00￥

16、80.00￥80.00￥80.00￥0.00￥0.00￥360.00￥360.00￥360.00￥360.00￥360.00￥360.00￥360.00￥270.00￥540.00￥360.00￥360.00￥540.00￥360.00￥18.00￥180.00￥360.00￥72.00￥36.00￥270.00￥270.00￥270.00返回主界面 商商品品编编码码商商品品类类别别商商品品名名称称规规格格型型号号销销售售单单价价销销售售数数量量单单位位合合计计日日期期欠欠款款金金额额供供货货商商净净利利润润返回主界面 销销售售出出货货单单客户： 日期：序序号号商商品品名名称称数数量量单单位位

17、单单价价金金额额备备注注123456合计金额(大 写)￥0制单：核对：签收：返回主界面 商商品品编编码码商商品品类类别别商商品品名名称称规规格格型型号号进进货货统统计计销销售售统统计计库库 存存净净利利润润数数 量量单单价价合合 计计数数 量量合合 计计1000005￥16.00￥80.000￥0.005￥0.001000015￥16.00￥80.000￥0.005￥0.001000025￥16.00￥80.000￥0.005￥0.001000035￥16.00￥80.000￥0.005￥0.001000045￥16.00￥80.000￥0.005￥0.001000055￥16.00￥80.0

18、00￥0.005￥0.001000065￥16.00￥80.000￥0.005￥0.001000075￥80.000￥0.005￥0.001000085￥80.000￥0.005￥0.001000095￥80.000￥0.005￥0.001000105￥80.000￥0.005￥0.001000115￥80.000￥0.005￥0.001000125￥80.000￥0.005￥0.001000130￥0.000￥0.0001000140￥0.000￥0.0001000155￥80.000￥0.005￥0.001000160￥0.000￥0.0001000170￥0.000￥0.00010001

19、85￥80.000￥0.005￥0.001000195￥80.000￥0.005￥0.001000205￥80.000￥0.005￥0.001000215￥80.000￥0.005￥0.001000225￥80.000￥0.005￥0.001000235￥80.000￥0.005￥0.001000245￥80.000￥0.005￥0.00返回主界面 年年销销售售报报表表月月份份总总销销量量净净利利润润1￥0.00￥0.002￥0.00￥0.003￥0.00￥0.004￥0.00￥0.005￥0.00￥0.006￥0.00￥0.007￥0.00￥0.008￥0.00￥0.009￥0.00￥0.0

20、010￥0.00￥0.0011￥0.00￥0.0012￥0.00￥0.00合合计计￥0.00￥0.00月月销销售售报报表表日日期期总总销销量量净净利利润润2008/8/1￥0.00￥0.002008/8/2￥0.00￥0.002008/8/3￥0.00￥0.002008/8/4￥0.00￥0.002008/8/5￥0.00￥0.002008/8/6￥0.00￥0.002008/8/7￥0.00￥0.002008/8/8￥0.00￥0.002008/8/9￥0.00￥0.002008/8/10￥0.00￥0.002008/8/11￥0.00￥0.002008/8/12￥0.00￥0.002008/8/13￥0.00￥0.002008/8/14￥0.00￥0.002008/8/15￥0.00￥0.002008/8/16￥0.00￥0.002008/8/17￥0.00￥0.002008/8/18￥0.00￥0.002008/8/19￥0.00￥0.002008/8/20￥0.