进销存管理表.xlsx

《进销存管理表.xlsx》由会员分享，可在线阅读，更多相关《进销存管理表.xlsx（42页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、 进销存明细表 商品及库存信息 采购销售明细表商品编码品名规格初始库存现库存日期进/销LY00001A_1品名*26262021/01/02采购LY00002A_2品名*35392021/01/03采购LY00003A_3品名*46452021/01/04采购LY00004A_4品名*1182021/01/05采购LY00005A_5品名*11202021/02/06采购LY00006A_6品名*41362021/02/07采购LY00007A_7品名*50582021/02/08采购LY00008A_8品名*32342021/02/09采购LY00009A_9品名*24172021/03/1

2、0采购LY00010A_10品名*36352021/03/11采购LY00011A_11品名*35392021/03/12采购LY00012A_12品名*11122021/04/13采购LY00013A_13品名*21222021/04/14采购LY00014A_14品名*29292021/04/15采购LY00015A_15品名*15132021/05/16采购LY00016A_16品名*36332021/05/17采购LY00017A_17品名*29292021/05/18采购LY00018A_18品名*20272021/06/19采购LY00019A_19品名*28242021/06/2

3、0采购LY00020A_20品名*50512021/06/21采购3.2万元4.7万元2.4万元0.9万元2.6万元2.4万元1.7万元2.5万元2.9万元2.1万元3.6万元3.8万元8.7万元3.9万元3.8万元4.7万元6.5万元3.6万元6.0万元2.4万元2.5万元3.7万元2.4万元6.2万元1月2月3月4月5月6月7月8月9月10月11月12月采购销售LY00021A_21品名*20112021/07/22采购LY00022A_22品名*46482021/07/23采购LY00023A_23品名*16202021/07/24采购LY00024A_24品名*27322021/08/

4、25采购LY00025A_25品名*15162021/08/26采购LY00026A_26品名*33402021/08/27采购LY00027A_27品名*13202021/08/28采购LY00028A_28品名*39392021/01/02销售LY00029A_29品名*50502021/01/03销售LY00030A_30品名*40402021/01/04销售LY00031A_31品名*12122021/01/05销售LY00032A_32品名*12122021/02/06销售LY00033A_33品名*19192021/02/07销售LY00034A_34品名*17172021/02/

5、08销售LY00035A_35品名*33332021/02/09销售LY00036A_36品名*12122021/03/10销售LY00037A_37品名*39392021/03/11销售LY00038A_38品名*40402021/03/12销售LY00039A_39品名*28282021/04/13销售LY00040A_40品名*11112021/04/14销售LY00041A_41品名*22222021/04/15销售LY00042A_42品名*44442021/05/16销售LY00043A_43品名*33332021/05/17销售LY00044A_44品名*48482021/05/

6、18销售LY00045A_45品名*29292021/06/19销售LY00046A_46品名*1542021/06/20销售LY00047A_47品名*28232021/06/21销售LY00048A_48品名*20172021/07/22销售LY00049A_49品名*40322021/07/23销售LY00050A_50品名*49412021/07/24销售LY00051A_51品名*1232021/08/25销售LY00052A_52品名*45392021/08/26销售LY00053A_53品名*18152021/08/27销售LY00054A_54品名*36322021/08/28

7、销售LY00055A_55品名*49362021/09/18销售LY00056A_56品名*36292021/09/19销售LY00057A_57品名*34252021/09/20销售LY00058A_58品名*28402021/10/21销售LY00059A_59品名*31392021/10/22销售LY00060A_60品名*37502021/10/23销售LY00061A_61品名*12252021/11/24销售LY00062A_62品名*33412021/11/04销售LY00063A_63品名*35482021/11/05销售LY00064A_64品名*22312021/12/06

8、销售LY00065A_65品名*50582021/12/07销售LY00066A_66品名*47592021/12/08销售LY00067A_67品名*22312021/09/18采购LY00068A_68品名*11172021/09/19采购LY00069A_69品名*41532021/09/20采购LY00070A_70品名*35352021/10/21采购LY00071A_71品名*31312021/10/22采购LY00072A_72品名*40402021/10/23采购LY00073A_73品名*26262021/11/24采购LY00074A_74品名*43432021/11/04

9、采购LY00075A_75品名*50502021/11/05采购LY00076A_76品名*39392021/12/06采购LY00077A_77品名*34342021/12/07采购LY00078A_78品名*33332021/12/08采购LY00079A_79品名*1818LY00080A_80品名*4444LY00081A_81品名*1919LY00082A_82品名*2525LY00083A_83品名*1111LY00084A_84品名*1515LY00085A_85品名*1313LY00086A_86品名*4343LY00087A_87品名*2222LY00088A_88品名*27

10、27LY00089A_89品名*2727LY00090A_90品名*1818LY00091A_91品名*4242LY00092A_92品名*2626LY00093A_93品名*4545LY00094A_94品名*3131LY00095A_95品名*2222LY00096A_96品名*2424LY00097A_97品名*2828LY00098A_98品名*2626商品编码品名规格数量单价金额备注LY00001A_1品名*111,673.0018,403.00LY00002A_2品名*13919.0011,947.00LY00003A_3品名*1071.00710.00LY00004A_4品名*1

11、0127.001,270.00LY00005A_5品名*13296.003,848.00LY00006A_6品名*8889.007,112.00LY00007A_7品名*131,427.0018,551.00LY00008A_8品名*121,427.0017,124.00LY00009A_9品名*414.0056.00LY00010A_10品名*101,098.0010,980.00LY00011A_11品名*91,427.0012,843.00LY00012A_12品名*11226.002,486.00LY00013A_13品名*7502.003,514.00LY00014A_14品名*38

12、46.002,538.00LY00015A_15品名*111,349.0014,839.00LY00016A_16品名*6507.003,042.00LY00017A_17品名*13615.007,995.00LY00018A_18品名*10848.008,480.00LY00019A_19品名*51,550.007,750.00LY00020A_20品名*81,024.008,192.00采购32.7万元38%销售54.3万元62% 进销存明细表3.2万元4.7万元2.4万元0.9万元2.6万元2.4万元1.7万元2.5万元2.9万元2.1万元3.6万元3.8万元8.7万元3.9万元3.8万

13、元4.7万元6.5万元3.6万元6.0万元2.4万元2.5万元3.7万元2.4万元6.2万元1月2月3月4月5月6月7月8月9月10月11月12月采购销售LY00021A_21品名*316.0048.00LY00022A_22品名*993.00837.00LY00023A_23品名*101,617.0016,170.00LY00024A_24品名*12184.002,208.00LY00025A_25品名*7895.006,265.00LY00026A_26品名*111,391.0015,301.00LY00027A_27品名*10116.001,160.00LY00001A_1品名*112,

14、374.0026,114.00LY00002A_2品名*91,279.0011,511.00LY00003A_3品名*112,434.0026,774.00LY00004A_4品名*131,702.0022,126.00LY00005A_5品名*42,088.008,352.00LY00006A_6品名*13389.005,057.00LY00007A_7品名*51,677.008,385.00LY00008A_8品名*101,677.0016,770.00LY00009A_9品名*11716.007,876.00LY00010A_10品名*112,029.0022,319.00LY00011

15、A_11品名*51,637.008,185.00LY00012A_12品名*102,477.0024,770.00LY00013A_13品名*62,963.0017,778.00LY00014A_14品名*31,505.004,515.00LY00015A_15品名*132,141.0027,833.00LY00016A_16品名*9765.006,885.00LY00017A_17品名*132,302.0029,926.00LY00018A_18品名*31,152.003,456.00LY00019A_19品名*92,140.0019,260.00LY00020A_20品名*71,933.0

16、013,531.00LY00021A_21品名*122,926.0035,112.00LY00022A_22品名*71,224.008,568.00LY00023A_23品名*62,706.0016,236.00LY00024A_24品名*71,568.0010,976.00LY00025A_25品名*61,561.009,366.00LY00026A_26品名*4418.001,672.00LY00027A_27品名*3523.001,569.00LY00046A_46品名*11768.008,448.00LY00047A_47品名*52,508.0012,540.00LY00048A_48

17、品名*31,312.003,936.00LY00049A_49品名*8704.005,632.00LY00050A_50品名*82,237.0017,896.00LY00051A_51品名*91,544.0013,896.00LY00052A_52品名*62,898.0017,388.00LY00053A_53品名*3745.002,235.00LY00054A_54品名*41,092.004,368.00LY00055A_55品名*132,573.0033,449.00LY00056A_56品名*72,877.0020,139.00LY00057A_57品名*9909.008,181.00L

18、Y00058A_58品名*12555.006,660.00LY00059A_59品名*8593.004,744.00LY00060A_60品名*131,341.0017,433.00LY00061A_61品名*131,301.0016,913.00LY00062A_62品名*884.00672.00LY00063A_63品名*13259.003,367.00LY00064A_64品名*91,691.0015,219.00LY00065A_65品名*8724.005,792.00LY00066A_66品名*121,219.0014,628.00LY00067A_67品名*91,680.0015,

19、120.00LY00068A_68品名*6875.005,250.00LY00069A_69品名*121,443.0017,316.001,674.000.001,357.000.00764.000.001,505.000.00962.000.00225.000.001,240.000.00652.000.001,366.000.00204.000.00566.000.00101.000.00600.000.001,650.000.001,152.000.00645.000.001,055.000.00875.000.001,219.000.00645.000.001,118.000.0059

20、.000.0074.000.001,070.000.001,017.000.001,214.000.00672.000.00926.000.00379.000.001,253.000.00620.000.00945.000.001,170.000.00264.000.00722.000.001,074.000.001,273.000.001,194.000.001,209.000.001,577.000.00816.000.00909.000.001,192.000.0084.000.00252.000.00410.000.00992.000.00688.000.001,338.000.009

21、20.000.001,198.000.00985.000.001,450.000.00190.000.00202.000.00354.000.00844.000.001,483.000.00762.000.001,400.000.00829.000.001,240.000.001,204.000.00993.000.001,614.000.001,554.000.00997.000.001,121.000.00454.000.001,518.000.001,098.000.001,575.000.001,242.000.00117.000.001,339.000.001,582.000.003

22、41.000.001,270.000.00971.000.00895.000.001,533.000.0093.000.0067.000.001,291.000.001,380.000.00596.000.001,279.000.00370.000.00730.000.001,473.000.001,226.000.001,229.000.001,619.000.00242.000.001,380.000.00228.000.00394.000.001,282.000.00170.000.00865.000.00622.000.00383.000.0040.000.001,617.000.00

23、1,525.000.00471.000.00263.000.001,602.000.00880.000.00237.000.001,589.000.00119.000.00413.000.00191.000.00527.000.00322.000.0012.000.00651.000.00886.000.00482.000.001,333.000.00521.000.00847.000.00360.000.00486.000.00989.000.001,018.000.001,101.000.00371.000.00612.000.001,336.000.001,441.000.00424.0

24、00.0089.000.001,251.000.00716.000.001,157.000.0020.000.00935.000.00294.000.001,404.000.0079.000.001,492.000.00415.000.00309.000.001,343.000.001,393.000.001,524.000.00401.000.001,159.000.00914.000.00643.000.001,667.000.001,696.000.00861.000.00380.000.00197.000.00680.000.001,109.000.001,231.000.00893.

25、000.00144.000.00910.000.00389.000.001,563.000.00393.000.001,126.000.00520.000.001,050.000.00774.000.001,086.000.001,349.000.00603.000.00390.000.001,677.000.00418.000.00108.000.00257.000.001,229.000.001,686.000.001,272.000.001,180.000.001,342.000.00245.000.00813.000.001,308.000.001,524.000.00615.000.

26、00207.000.001,693.000.00317.000.00563.000.00510.000.00229.000.0088.000.001,528.000.00725.000.001,527.000.00581.000.00812.000.001,620.000.001,347.000.00417.000.00748.000.00984.000.00921.000.00206.000.00368.000.001,073.000.00263.000.001,697.000.001,123.000.00120.000.001,548.000.00381.000.00350.000.007

27、78.000.00136.000.00557.000.00554.000.001,376.000.00151.000.00672.000.00908.000.001,445.000.001,634.000.001,291.000.001,109.000.001,206.000.00419.000.00338.000.00535.000.001,356.000.00951.000.001,266.000.001,564.000.00262.000.00635.000.001,298.000.001,584.000.001,407.000.00847.000.001,414.000.00802.0

28、00.00561.000.001,620.000.001,046.000.00551.000.001,085.000.00526.000.00484.000.001,245.000.0041.000.001,476.000.001,581.000.001,370.000.00494.000.001,533.000.00297.000.00911.000.00630.000.00461.000.00667.000.00813.000.001,174.000.001,115.000.00448.000.001,129.000.00316.000.001,279.000.00737.000.0032

29、.000.001,133.000.001,074.000.001,054.000.001,573.000.00447.000.00172.000.001,051.000.00489.000.001,686.000.00147.000.0017.000.001,628.000.0098.000.00503.000.001,446.000.00447.000.0046.000.00272.000.00367.000.00537.000.001,277.000.001,540.000.001,369.000.0024.000.00158.000.00349.000.00833.000.001,595

30、.000.001,171.000.00736.000.00369.000.00928.000.001,471.000.00802.000.00524.000.00658.000.001,184.000.001,092.000.001,157.000.00118.000.001,203.000.00631.000.00281.000.001,599.000.00434.000.00313.000.001,121.000.00635.000.00264.000.001,228.000.001,663.000.00185.000.0076.000.00318.000.001,167.000.0090

31、3.000.00267.000.00474.000.001,543.000.00829.000.00736.000.001,249.000.001,550.000.00506.000.00821.000.001,228.000.00329.000.001,457.000.00293.000.001,600.000.001,588.000.001,055.000.001,058.000.001,512.000.00716.000.00273.000.001,074.000.00190.000.00730.000.00505.000.00952.000.00937.000.00482.000.00

32、1,327.000.001,156.000.00679.000.00247.000.00122.000.00171.000.001,518.000.00314.000.001,527.000.001,369.000.00356.000.00434.000.001,279.000.00637.000.00516.000.00932.000.00265.000.001,675.000.00668.000.001,359.000.001,657.000.001,485.000.001,440.000.00965.000.00555.000.001,050.000.00519.000.00827.00

33、0.00613.000.00957.000.00563.000.0052.000.001,071.000.00211.000.00733.000.00914.000.001,473.000.00283.000.001,278.000.00886.000.00787.000.00678.000.00901.000.001,204.000.001,540.000.00293.000.001,236.000.00447.000.001,244.000.001,474.000.00556.000.0080.000.00300.000.00714.000.00252.000.001,257.000.00

34、月份1月2月3月4月5月6月采购3.2万元4.7万元2.4万元0.9万元2.6万元2.4万元销售8.7万元3.9万元3.8万元4.7万元6.5万元3.6万元7月8月9月10月11月12月合计1.7万元2.5万元2.9万元2.1万元3.6万元3.8万元32.7万元6.0万元2.4万元2.5万元3.7万元2.4万元6.2万元54.3万元稻稻壳壳儿儿表表格格模模板板使使用用说说明明（本页为说明页，用户使用模板时可删除本页内容）0101基基础础操操作作指指南南中文字体名称阿里巴巴普惠体0202字字体体说说明明0303素素材材说说明明图图片片：无无素素材材：无无 如如何何撤撤销销工工作作表表保保护护？1

35、、选中对应工作表。2、点击：审阅-撤销工作表保护。 如如何何增增加加行行数数？1、选中最后一行，鼠标放在选中区域右下角。2、当鼠标箭头变成黑色十字形时，点击鼠标左键下拉即可。【说明】模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。稻稻壳壳儿儿表表格格模模板板使使用用说说明明（本页为说明页，用户使用模板时可删除本页内容）0101基基础础操操作作指指南南中文字体名称江城正义体 300W0202字字体体说说明明0303素素材材说说明明图图片片：无无素素材材：无无 如如何何撤撤销销工工作作表表保保护护？1、选中对应工作表。2、点击：审阅-撤销工作表保护。

36、 如如何何增增加加行行数数？1、选中最后一行，鼠标放在选中区域右下角。2、当鼠标箭头变成黑色十字形时，点击鼠标左键下拉即可。【说明】模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。阿里巴巴普惠体2.0 105 Heavy 明明细细表表说说明明1、进/销汉字下拉选择，符号自动2、金额自动计算3、商品编码下拉选择，品名、规格自动 商商品品及及库库存存信信息息说说明明1、初始化商品编码、品名、规格、初始库存2、现库存自动计算 图图形形自自动动 辅辅助助表表请请勿勿删删除除 明明细细表表说说明明1、进/销汉字下拉选择，符号自动2、金额自动计算3、商品编码下拉选择，品名、规格自动中文字体名称中文字体名称中文字体名称阿里巴巴普惠体0202字字体体说说明明0303素素材材说说明明图图片片：无无素素材材：无无【说明】模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。中文字体名称江城正义体 300W0202字字体体说说明明0303素素材材说说明明图图片片：无无素素材材：无无【说明】模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。阿里巴巴普惠体2.0 105 Heavy