福安店配货明细对账单(1)(ppt文档).xls

销售单序时簿日期商品代码商品名称规格型号数量单价金额价税合计2012-09-30 001.001.086爱之物语200*2305120600600001.001.088欣欣花梦200*2305120600600001.001.050千香格200*2301105105105001.001.092给力200*2304105420420001.001.087完美200*2305105525525001.001.068花叶玲珑200*2305105525525001.001.095星辰絮语220*2403230690690001.001.097西溪漫步220*2403230690690001.001.099凝香花弦220*2403230690690001.001.101花香伊人220*24032306906902012-09-30 001.001.103茱莉莎花园220*2403230690690001.001.105靓丽人生220*2403230690690001.001.107云蕾倩影220*2403230690690001.002.115明朗200*2301266266266001.002.146迷恋香200*230426610641064001.002.003新普街200*2302266532532001.002.005城市空间200*2302266532532001.002.006城市空间220*240428511401140001.002.026清姿兰香200*2301266266266001.002.091赞美诗200*23022665325322012-09-30 001.002.144时尚派对200*230426610641064001.002.151克里斯汀200*230426610641064001.002.127摩登派220*2402285570570001.002.154原野芬芳220*2403285855855001.002.160校园风景220*2403285855855001.002.156婀娜多姿220*2403285855855001.002.158玫园小镇220*2403285855855001.002.162艾莉莎220*2403285855855001.003.064花舞摇曳-J200*2302340680680001.003.065花舞摇曳-J220*2403360108010802012-09-30 001.003.003悠然花香200*2302340680680001.003.004悠然花香220*240336010801080001.003.018花香飞舞220*240336010801080001.003.032都市霓虹220*240536018001800001.003.034温馨一簇220*240336010801080001.003.038花镜奇缘220*240336010801080001.006.024曲线流畅200*2302350700700001.006.025曲线流畅220*240337011101110001.006.018爱的牵线220*240547023502350001.006.020爱的节奏200*23023507007002012-09-30 001.006.021爱的节奏220*240337011101110001.007.027欣欣花梦200*2302390780780001.008.038柔魅佳人200*2302410820820001.008.039柔魅佳人220*240343513051305001.008.013炫舞200*2302410820820001.008.014炫舞220*240343513051305Page 1销售单序时簿001.008.019曲直空间200*230341012301230001.008.020曲直空间220*240443517401740001.008.025圆梦200*230341012301230001.008.024恋爱花藤220*24024358708702012-09-30 001.005.036时尚之恋220*2401129932893289001.005.032思语220*240436514601460001.005.026兰蔻佳人220*240429911961196001.005.027时尚恋曲200*2302330660660001.005.028时尚恋曲220*240336510951095001.005.012约定220*2402365730730001.005.018闲适生活220*240336510951095001.005.044兰亭花絮220*240339011701170001.009.028幻境森林200*230258011601160001.009.029幻境森林220*2403600180018002012-09-30 001.009.012雅静220*240360018001800001.009.006夜纱220*240260012001200001.009.008盈盈欲滴200*2301580580580001.009.009盈盈欲滴220*240260012001200001.011.016快乐男孩150*2101178178178001.011.017快乐男孩200*2302198396396001.011.024漂亮宝贝150*2101178178178001.011.032漂亮宝贝200*2302198396396001.011.020快乐时光200*2302168336336001.011.014足球小子150*21031785345342012-09-30 001.011.015足球小子200*2303198594594001.011.018樱桃小丸子150*2103178534534001.011.019樱桃小丸子200*2303198594594001.013.001富丽堂皇被套150*210305817401740001.013.002富丽堂皇被套180*215356823802380001.013.003富丽堂皇被套200*230457835103510002.001.013浓情蜜意200*2302488976976002.001.014浓情蜜意220*240350815241524002.001.021梦之飞舞200*2302488976976002.001.022梦之飞舞220*2403508152415242012-09-30 002.001.015绚烂花季200*2302488976976002.001.027品味高贵200*2302467934934003.002.008风尚220*2401878878878003.002.010多彩的爱200*230369820942094003.002.013英皇爵士八件套180*200340812241224003.003.007淡香宜人220*2402106021202120003.004.010迪赛娜拉220*240260012001200003.004.008浓情密林220*240285817161716003.004.034龙飞凤舞220*2402125025002500003.004.001富丽堂皇十件套220*2406700420042002012-09-30 003.004.015似水莹纱220*2401105810581058004.003.006澜珊刺绣夏被180*2152118236236004.003.007澜珊刺绣夏被200*2302139278278Page 2销售单序时簿004.003.012蚕丝夏凉被180*2152117234234004.003.023薰衣草夏凉被150*2102113226226004.003.024薰衣草夏凉被200*2302135270270004.001.001牛奶润肤被150*2102135270270004.001.002牛奶润肤被200*2304205820820004.001.007大豆纤维被150*2102136272272004.001.008大豆纤维被200*23021903803802012-09-30 004.001.025尊品双胎被180*2155189945945004.001.026尊品双胎被200*230621813081308004.001.093贵族双套被150*210855440440004.001.094贵族双套被180*2151065650650004.001.086生态棉花被150*2102220440440004.001.083生态棉花被200*2302390780780004.001.084生态棉花被220*240446018401840011.001.012白被芯200*230550250250011.001.013白被芯220*240551255255007.001.001精品毛毯180*23031303903902012-09-30 007.001.002精品毛毯200*2403150450450007.001.005高级毛毯180*2303190570570007.001.006高级毛毯200*2403215645645008.001.022英伦式休闲床垫90*190355165165005.001.013富丽真空枕48*741002020002000005.001.014富丽真空枕48*120535175175005.001.015决明子枕48*741045450450005.001.016羽丝绒枕45*701040400400005.001.021香薰定型枕43*663025750750011.001.029强力枕芯+枕套45*7010181801802012-09-30 005.001.008展示枕48*74603521002100006.001.004布艺抱枕45*45808640640006.001.008靠垫芯60*60402510001000001.012.021欧陆风情床罩四件套150*1902235470470001.012.022欧陆风情床罩四件套180*2002245490490001.012.023富丽情缘床裙四件套150*1902235470470001.012.024富丽情缘床裙四件套180*2002245490490001.012.018纯棉高密床裙四件套120*190206813601360001.012.026 高密素色绣花床笠四件套120*190206813601360001.012.027 高密素色绣花床笠四件套150*19010787807802012-09-30 001.012.028 高密素色绣花床笠四件套180*200208817601760011.001.021强力枕套45*701008800800011.001.035毛巾36*7436*7420360602012-09-30 008.001.010海绵床垫150*2003000008.001.011海绵床垫180*20030002012-10-03 001.002.127摩登派220*240-1285-285-285005.001.008展示枕48*74-1735-595-595001.009.028幻境森林200*230-1580-580-5802012-10-08 011.001.021强力枕套45*70200816001600001.012.021欧陆风情床罩四件套150*1901523535253525Page 3销售单序时簿001.012.022欧陆风情床罩四件套180*2001024524502450001.012.023富丽情缘床裙四件套150*1901023523502350001.012.024富丽情缘床裙四件套180*2001024524502450005.001.015决明子枕48*74504522502250005.001.016羽丝绒枕45*702040800800011.001.029强力枕芯+枕套45*701001818001800004.001.101印花护肤二合一被200*2305180900900004.001.102印花护肤二合一被220*240520010001000006.001.004布艺抱枕45*453082402402012-10-08 004.001.056淑女型大豆纤维被220*2405121605605004.001.065印花护肤被200*2303105315315004.001.032珍品棉花被200*2305185925925011.001.039平面信封枕套45*1205015750750004.001.094贵族双套被180*2151065650650004.001.044贵妃双套被200*230815012001200004.001.104生态棉花被(风尚版)220*2402255510510004.003.012蚕丝夏凉被180*2152117234234005.001.014富丽真空枕48*1202035700700004.001.089贵妃羽绒被220*2401750750750004.001.092十孔立体被220*2405185925925004.001.107贵妃蚕丝被220*2404490196019602012-10-26 001.012.022欧陆风情床罩四件套180*2001245245245001.012.021欧陆风情床罩四件套150*1901235235235003.004.008浓情密林220*240285817161716001.012.024富丽情缘床裙四件套180*20032457357352012-11-08 001.002.162艾莉莎220*240428511401140001.002.165显赫风范200*2302275550550001.002.166显赫风范220*2402305610610001.008.044恋歌200*2302400800800001.008.045恋歌220*2402450900900001.008.041幸福定制220*2402450900900001.008.046魅惑使命200*2302400800800001.008.047魅惑使命220*2402450900900001.005.047凯蒂米娅200*2302350700700001.005.048凯蒂米娅220*24023907807802012-11-08 001.005.049伊兰黛安200*2302350700700001.005.050伊兰黛安220*2402390780780001.005.046依稀220*240339011701170001.004.009丽日220*2402325650650001.004.011华韵220*2402325650650002.001.033樱花漫舞220*240251010201020003.002.013英皇爵士八件套180*200340812241224003.004.034龙飞凤舞220*2403125037503750003.004.036永恒挚爱220*24021200240024002012-11-08 004.001.013澜珊刺绣被150*210577385385004.001.014澜珊刺绣被180*215591455455004.001.015澜珊刺绣被200*2305113565565Page 4销售单序时簿004.001.007大豆纤维被150*2105136680680004.001.008大豆纤维被200*2305190950950004.001.068新雪丽被200*2302420840840004.001.105新雪丽被220*2402455910910004.001.022九孔珍珠被200*2303142426426004.003.023薰衣草夏凉被150*2105113565565004.003.024薰衣草夏凉被200*23051356756752012-11-08 011.001.012白被芯200*23050000007.001.001精品毛毯180*2302013026002600007.001.002精品毛毯200*2402015030003000005.001.013富丽真空枕48*741502030003000005.001.014富丽真空枕48*1201035350350005.001.021香薰定型枕43*66502512501250005.001.037尊贵型羽丝绒枕48*742045900900006.001.004布艺抱枕45*45200816001600006.001.008靠垫芯60*603025750750001.012.021欧陆风情床罩四件套150*19020235470047002012-11-08 001.012.022欧陆风情床罩四件套180*2002024549004900001.012.023富丽情缘床裙四件套150*1902023547004700001.012.024富丽情缘床裙四件套180*2002024549004900001.012.019纯棉高密床裙四件套150*190207815601560001.012.027 高密素色绣花床笠四件套150*190307823402340001.012.028 高密素色绣花床笠四件套180*200308826402640001.013.006欧陆风情床单230*250303711101110001.013.007精品床单250*2501075750750011.001.001拖鞋1501150150011.001.035毛巾36*7436*7410033003002012-11-08 001.001.109奇妙世界200*2301016016001600001.001.108现代经典200*2301016016001600001.001.110漫步巴黎200*2301016016001600004.001.108珠光粉冬被200*230409538003800004.001.091珠光粉冬被220*2404012048004800007.001.003素色珊瑚绒毯150*210205210401040007.001.007素色珊瑚绒毯200*230306820402040001.011.015足球小子200*2303198594594003.004.008浓情密林220*240585842904290011.001.021强力枕套45*7010088008002012-11-10 004.001.015澜珊刺绣被200*2306113678678001.002.162艾莉莎220*240528514251425001.011.017快乐男孩200*230619811881188001.011.015足球小子200*230619811881188001.012.027 高密素色绣花床笠四件套150*190307823402340001.012.028 高密素色绣花床笠四件套180*200308826402640003.002.013英皇爵士八件套180*200540820402040001.012.020纯棉高密床裙四件套180*200208817601760004.001.107贵妃蚕丝被220*240549024502450006.001.004布艺抱枕45*45300824002400Page 5销售单序时簿004.001.026尊品双胎被200*2301021821802180004.001.025尊品双胎被180*2151018918901890005.001.033尊贵型决明子枕48*74550250250005.001.036健康安适枕40*70555275275005.001.035薰衣草裙边枕48*74550250250002.001.033樱花漫舞220*240651030603060004.001.083生态棉花被200*2302390780780004.001.084生态棉花被220*2402460920920004.001.103生态棉花被(风尚版)200*2302215430430004.001.104生态棉花被(风尚版)220*2402255510510004.001.094贵族双套被180*21510656506502012-11-10 008.001.026羊羔绒床垫150*2001010510501050008.001.027羊羔绒床垫180*2002012024002400008.001.028长毛绒床垫150*2001085850850008.001.029长毛绒床垫180*20020100200020002012-11-10 004.001.008大豆纤维被200*23020190380038002012-11-11 003.002.009风情万种220*2401858858858004.001.105新雪丽被220*2405455227522752012-11-14 011.001.021强力枕套45*70150812001200011.001.022强力枕套45*1205016800800005.001.036健康安适枕40*701055550550003.002.010多彩的爱200*230269813961396001.012.022欧陆风情床罩四件套180*2001024524502450001.012.021欧陆风情床罩四件套150*190523511751175005.001.013富丽真空枕48*74502010001000003.004.033喜临门220*2401908908908003.005.001蒙娜丽莎220*2401798798798001.006.023品味高贵220*240347014101410003.004.001富丽堂皇十件套220*24019389389382012-11-14 003.004.008浓情密林220*240-1858-858-8582012-11-14 004.001.109亲柔居家被(印花)200*2301150150150004.001.110亲柔居家被(印花)220*2401175175175004.001.111亲柔居家被(单色)200*2301150150150004.001.112亲柔居家被(单色)220*2401175175175004.001.029鸳鸯双胎被220*24014804804802012-11-14 004.001.029鸳鸯双胎被220*2402480960960004.001.109亲柔居家被(印花)200*2301150150150004.001.110亲柔居家被(印花)220*2401175175175004.001.111亲柔居家被(单色)200*2301150150150004.001.112亲柔居家被(单色)220*24011751751752012-11-15 003.004.034龙飞凤舞220*24011250125012502012-11-30 001.001.097西溪漫步220*240-3230-690-690001.002.156婀娜多姿220*240-3285-855-855001.002.146迷恋香200*230-3266-798-798001.001.095星辰絮语220*240-3230-690-690001.008.013炫舞200*230-1410-410-410001.008.014炫舞220*240-3435-1305-1305Page 6销售单序时簿001.001.099凝香花弦220*240-3230-690-690001.001.101花香伊人220*240-3230-690-690001.001.103茱莉莎花园220*240-3230-690-690001.003.032都市霓虹220*240-5360-1800-1800001.003.034温馨一簇220*240-3360-1080-1080001.002.151克里斯汀200*230-3266-798-798001.002.091赞美诗200*230-2266-532-532001.002.127摩登派220*240-1285-285-285001.009.006夜纱220*240-2600-1200-1200001.009.012雅静220*240-3600-1800-1800001.009.028幻境森林200*230-1580-580-580001.009.029幻境森林220*240-2600-1200-1200001.005.032思语220*240-4365-1460-1460001.005.018闲适生活220*240-2365-730-7302012-11-30 001.002.154原野芬芳220*240-2285-570-570001.008.046魅惑使命200*230-1400-400-400001.008.047魅惑使命220*240-2450-900-900001.002.158玫园小镇220*240-2285-570-570001.008.041幸福定制220*240-2450-900-900001.003.038花镜奇缘220*240-3360-1080-1080001.004.011华韵220*240-2325-650-650001.008.024恋爱花藤220*240-2435-870-870001.003.004悠然花香220*240-2360-720-720001.008.038柔魅佳人200*230-1410-410-410001.008.039柔魅佳人220*240-3435-1305-1305001.008.019曲直空间200*230-2410-820-820001.008.020曲直空间220*240-3435-1305-1305001.003.018花香飞舞220*240-3360-1080-1080001.002.003新普街200*230-2266-532-532001.002.006城市空间220*240-2285-570-570001.002.160校园风景220*240-3285-855-855001.009.008盈盈欲滴200*230-1580-580-580001.006.020爱的节奏200*230-2350-700-700001.006.021爱的节奏220*240-3370-1110-11102012-11-30 001.002.026清姿兰香200*230-1266-266-266001.008.025圆梦200*230-3410-1230-1230003.004.010迪赛娜拉220*240-2600-600-1200003.002.008风尚220*240-1878-878-878003.004.001富丽堂皇十件套220*240-2700-1400-1400001.012.022欧陆风情床罩四件套180*200-3245-735-735004.001.026尊品双胎被200*230-1218-218-218007.001.007素色珊瑚绒毯200*230-1068-680-6802012-11-30 001.005.048凯蒂米娅220*2402390780780005.001.015决明子枕48*742045900900008.001.027羊羔绒床垫180*2001212014401440001.011.018樱桃小丸子150*2102208416416001.011.014足球小子150*2102208416416Page 7销售单序时簿001.011.016快乐男孩150*2102208416416001.001.108现代经典200*2303160480480001.001.110漫步巴黎200*2303160480480001.001.109奇妙世界200*2303160480480001.006.018爱的牵线220*2402470940940011.001.029强力枕芯+枕套45*702018360360007.001.001精品毛毯180*2305130650650004.001.025尊品双胎被180*2155189945945004.001.026尊品双胎被200*230521810901090001.012.021欧陆风情床罩四件套150*1901023523502350001.012.023富丽情缘床裙四件套150*1902235470470001.012.024富丽情缘床裙四件套180*2004245980980004.001.109亲柔居家被(印花)200*2305150750750004.001.110亲柔居家被(印花)220*240517587587537480278688278688黄色为首批退货，红色为开业活动之后退货。绿色为退货之后所发的产品。从9月份打款总计是：303254元。发货总计是：321823元。退货是：43135元。剩余公司货款是：打款总计-（发货总计-退货总计）=303254元-（321823元-43135元）=24566元。Page 8销售单序时簿备注Page 9销售单序时簿Page 10销售单序时簿首批退货。次品首批退货首批退货Page 11销售单序时簿Page 12销售单序时簿赠送紫色深蓝Page 13销售单序时簿开业之后退货开业之后退货，有一次品开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货Page 14销售单序时簿开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货开业之后退货，次品开业之后退货，次品开业之后退货活动之后拿货活动之后拿货活动之后拿货，咖啡色+白色活动之后拿货活动之后拿货Page 15销售单序时簿活动之后拿货，深蓝色活动之后拿货活动之后拿货活动之后拿货活动之后拿货活动之后拿货活动之后拿货活动之后拿货，粉色活动之后拿货，粉色活动之后拿货活动之后拿货活动之后拿货活动之后拿货活动之后拿货黄色为首批退货，红色为开业活动之后退货。绿色为退货之后所发的产品。从9月份打款总计是：303254元。发货总计是：321823元。退货是：43135元。剩余公司货款是：打款总计-（发货总计-退货总计）=303254元-（321823元-43135元）=24566元。Page 16