excel進(jìn)銷存賬本

1、ExcelExcel進(jìn)進(jìn)銷銷存存記記賬賬本本 V2.0V2.0免免費(fèi)費(fèi)試試用用版版http:/商商品品進(jìn)進(jìn)貨貨銷銷售售記記錄錄打打印印單單據(jù)據(jù)當(dāng)當(dāng)前前庫庫存存銷銷售售圖圖表表供供貨貨商商客客 戶戶簡(jiǎn)單易用、輕松管理一次性注冊(cè)，終身使用。錄入數(shù)據(jù)后，輕松統(tǒng)計(jì)技術(shù)支持QQ：109419250電子郵件：客客 戶戶返回主界面 商商品品編編碼碼商商品品類類別別商商品品名名稱稱規(guī)規(guī)格格型型號(hào)號(hào)進(jìn)進(jìn)貨貨單單價(jià)價(jià)進(jìn)進(jìn)貨貨數(shù)數(shù)量量單單位位合合計(jì)計(jì)進(jìn)進(jìn)貨貨日日期期進(jìn)進(jìn)貨貨人人pj-750-01pj-750-01鉆鉆機(jī)機(jī)配配件件 蝶蝶形形彈彈簧簧75075050.0050.009 9塊塊450.00pj-750-0

2、2pj-750-02鉆鉆機(jī)機(jī)配配件件 卡卡盤盤卡卡瓦瓦75075030.0030.003030個(gè)個(gè)900.00pj-750-03pj-750-03鉆鉆機(jī)機(jī)配配件件 異異徑徑接接頭頭沖沖擊擊器器100.00100.001 1個(gè)個(gè)100.00pj-750-04pj-750-04鉆鉆機(jī)機(jī)配配件件撥撥叉叉75075080.0080.005 5個(gè)個(gè)400.00pj-750-05pj-750-05鉆鉆機(jī)機(jī)配配件件前前端端蓋蓋750750120.00120.003 3個(gè)個(gè)360.00pj-750-06pj-750-06鉆鉆機(jī)機(jī)配配件件 4242活活絡(luò)絡(luò)水水辯辯750750180.00180.003 3個(gè)個(gè)5

3、40.00pj-750-07pj-750-07鉆鉆機(jī)機(jī)配配件件 5050活活絡(luò)絡(luò)水水辯辯750750180.00180.005 5個(gè)個(gè)900.00pj-750-08pj-750-08鉆鉆機(jī)機(jī)配配件件調(diào)調(diào)節(jié)節(jié)塊塊75075015.0015.009 9塊塊135.00pj-750-09pj-750-09鉆鉆機(jī)機(jī)配配件件鑲鑲條條75075015.0015.009 9個(gè)個(gè)135.00pj-01-1pj-01-1油油1818號(hào)號(hào)齒齒輪輪油油 180kg180kg1 1桶桶pj-01-2pj-01-2油油 2020號(hào)號(hào)透透明明機(jī)機(jī)油油170kg170kg1 1桶桶pj-01-3pj-01-3油油 4646

4、號(hào)號(hào)抗抗磨磨液液壓壓油油 170kg170kg1 1桶桶pj-01-4pj-01-4油油 6868號(hào)號(hào)抗抗磨磨液液壓壓油油 170kg170kg1 1桶桶pj-02pj-02液液壓壓膠膠管管 液液壓壓膠膠管管19*2*1019*2*10米米160.00160.003030根根4,800.00pj-03pj-03鉸鉸接接頂頂梁梁178.00178.00100100個(gè)個(gè)17,800.00pj-750-10pj-750-10鉆鉆機(jī)機(jī)配配件件壓壓蓋蓋70.0070.002 2個(gè)個(gè)140.00pj-1250-1pj-1250-1鉆鉆機(jī)機(jī)配配件件 卡卡盤盤卡卡瓦瓦12501250個(gè)個(gè)pj-1250-2pj

5、-1250-2鉆鉆機(jī)機(jī)配配件件 卡卡盤盤交交接接螺螺栓栓 12501250個(gè)個(gè)pj-650pj-650鉆鉆機(jī)機(jī) 鉆鉆機(jī)機(jī)65065035,500.0035,500.001 1臺(tái)臺(tái)35,500.00pj-04pj-04鏈鏈條條鉆鉆 鏈鏈條條式式探探水水鉆鉆 KHYD90KHYD90 9,450.009,450.002 2臺(tái)臺(tái)18,900.00pj-rhb-1pj-rhb-1 乳乳化化泵泵配配件件80/2080/20半半圓圓環(huán)環(huán)80/2080/2012.0012.006 6付付72.00pj-rhb-2pj-rhb-2 乳乳化化泵泵配配件件 主主閥閥閥閥座座80/2080/206.006.0020

6、20付付120.00pj-rhb-3pj-rhb-3 乳乳化化泵泵配配件件 密密封封圈圈80/2080/2012.0012.006060個(gè)個(gè)720.00pj-rhb-4pj-rhb-4 乳乳化化泵泵配配件件 交交替替閥閥80/2080/20350.00350.001 1套套350.00pj-rhb-5pj-rhb-5 乳乳化化泵泵配配件件 調(diào)調(diào)壓壓彈彈簧簧80/2080/2010.0010.004 4個(gè)個(gè)40.00pj-rhb-6pj-rhb-6 乳乳化化泵泵配配件件 滑滑塊塊定定位位塞塞 80/2080/202.502.501212個(gè)個(gè)30.00pj-rhb-7pj-rhb-7 乳乳化化泵泵

7、配配件件 承承壓壓塊塊80/2080/209.009.003 3個(gè)個(gè)27.00pj-rhb-8pj-rhb-8 乳乳化化泵泵配配件件連連桿桿80/2080/20160.00160.003 3條條480.00pj-rhb-9pj-rhb-9 乳乳化化泵泵配配件件 墊墊片片80/2080/201.001.001212個(gè)個(gè)12.00pj-rhb-10pj-rhb-10 乳乳化化泵泵配配件件 墊墊片片80/2080/202.002.001212個(gè)個(gè)24.00供供貨貨商商備備注注返回主界面 返回主界面 商商品品編編碼碼商商品品類類別別商商品品名名稱稱規(guī)規(guī)格格型型號(hào)號(hào)銷銷售售單單價(jià)價(jià)銷銷售售數(shù)數(shù)量量單單位

8、位合合計(jì)計(jì)日日期期欠欠款款金金額額供供貨貨商商凈凈利利潤(rùn)潤(rùn)返回主界面 銷銷售售出出貨貨單單客戶： 日期：序序號(hào)號(hào)商商品品名名稱稱數(shù)數(shù)量量單單位位單單價(jià)價(jià)金金額額備備注注123456合計(jì)金額(大 寫)0制單：核對(duì)：簽收：返回主界面 商商品品編編碼碼商商品品類類別別商商品品名名稱稱規(guī)規(guī)格格型型號(hào)號(hào)進(jìn)進(jìn)貨貨統(tǒng)統(tǒng)計(jì)計(jì)銷銷售售統(tǒng)統(tǒng)計(jì)計(jì)庫庫 存存凈凈利利潤(rùn)潤(rùn)數(shù)數(shù) 量量單單價(jià)價(jià)合合 計(jì)計(jì)數(shù)數(shù) 量量合合 計(jì)計(jì)pj-750-01鉆機(jī)配件蝶形彈簧750950.00450.0000.0090.00pj-750-02鉆機(jī)配件卡盤卡瓦7503030.00900.0000.00300.00pj-750-03鉆機(jī)配件異徑接

9、頭沖擊器1100.00100.0000.0010.00pj-750-04鉆機(jī)配件撥叉750580.00400.0000.0050.00pj-750-05鉆機(jī)配件前端蓋7503120.00360.0000.0030.00pj-750-06鉆機(jī)配件42活絡(luò)水辯7503180.00540.0000.0030.00pj-750-07鉆機(jī)配件50活絡(luò)水辯7505180.00900.0000.0050.00pj-750-08鉆機(jī)配件調(diào)節(jié)塊7509135.0000.0090.00pj-750-09鉆機(jī)配件鑲條7509135.0000.0090.00pj-01-1油18號(hào)齒輪油180kg10.0000.001

10、0.00pj-01-2油20號(hào)透明機(jī)油170kg10.0000.0010.00pj-01-3油46號(hào)抗磨液壓油 170kg10.0000.0010.00pj-01-4油68號(hào)抗磨液壓油 170kg10.0000.0010.00pj-02液壓膠管液壓膠管19*2*10米304,800.0000.00300.00pj-03鉸接頂梁10017,800.0000.001000.00pj-750-10鉆機(jī)配件壓蓋2140.0000.0020.00pj-1250-1鉆機(jī)配件卡盤卡瓦125000.0000.000pj-1250-2鉆機(jī)配件 卡盤交接螺栓125000.0000.000pj-650鉆機(jī) 鉆機(jī)65

11、0135,500.0000.0010.00pj-04鏈條鉆鏈條式探水鉆KHYD90218,900.0000.0020.00pj-rhb-1乳化泵配件80/20半圓環(huán)80/20672.0000.0060.00pj-rhb-2乳化泵配件主閥閥座80/2020120.0000.00200.00pj-rhb-3乳化泵配件密封圈80/2060720.0000.00600.00pj-rhb-4乳化泵配件交替閥80/201350.0000.0010.00pj-rhb-5乳化泵配件調(diào)壓彈簧80/20440.0000.0040.00返回主界面 年年銷銷售售報(bào)報(bào)表表月月份份總總銷銷量量?jī)魞衾麧?rùn)潤(rùn)10.000.0

12、020.000.0030.000.0040.000.0050.000.0060.000.0070.000.0080.000.0090.000.00100.000.00110.000.00120.000.00合合計(jì)計(jì)0.000.00月月銷銷售售報(bào)報(bào)表表日日期期總總銷銷量量?jī)魞衾麧?rùn)潤(rùn)2008/8/10.000.002008/8/20.000.002008/8/30.000.002008/8/40.000.002008/8/50.000.002008/8/60.000.002008/8/70.000.002008/8/80.000.002008/8/90.000.002008/8/100.000.

13、002008/8/110.000.002008/8/120.000.002008/8/130.000.002008/8/140.000.002008/8/150.000.002008/8/160.000.002008/8/170.000.002008/8/180.000.002008/8/190.000.002008/8/200.000.002008/8/210.000.002008/8/220.000.002008/8/230.000.002008/8/240.000.002008/8/250.000.002008/8/260.000.002008/8/270.000.002008/8/280.000.002008/8/290.000.002008/8/300.000.002008/8/310.000.00合合計(jì)計(jì)0.000.002008/8/12008/8/82008/8/152008/8/222008/8/29000001111111234567891011120.0000.400.500.600.700.800.901.00返回主界面 2008/8/12008/8/82008/8/152008/8/222008/8/29000001111111234567891011120.0000.400.