《案例10 創(chuàng)建多層次的分類匯總和分級顯示》由會員分享，可在線閱讀，更多相關(guān)《案例10 創(chuàng)建多層次的分類匯總和分級顯示（13頁珍藏版）》請在裝配圖網(wǎng)上搜索。
1、店店號號大大區(qū)區(qū)省省份份所所在在城城市市性性質(zhì)質(zhì)店店名名本本月月指指標標實實際際銷銷售售金金額額完完成成率率DBB001華東安徽蚌埠加盟AAAA-1617500059202.0078.94%DMG004西北內(nèi)蒙古包頭加盟AAAA-15510000072553.5072.55%DBJ001西北陜西寶雞加盟AAAA-2056000053222.5088.70%DBJ002華北北京北京加盟AAAA-1516500057255.6088.09%BJ008華北北京北京自營AAAA-0129000048519.0053.91%BJ001華北北京北京自營AAAA-013390000249321.5063.9
2、3%BJ002華北北京北京自營AAAA-01413000099811.0076.78%BJ003華北北京北京自營AAAA-01513000087414.0067.24%BJ004華北北京北京自營AAAA-016160000104198.0065.12%BJ005華北北京北京自營AAAA-017190000130105.0068.48%BJ006華北北京北京自營AAAA-01811000071124.0064.66%BJ007華北北京北京自營AAAA-01914000097924.0069.95%BJ009華北北京北京自營AAAA-02010000072650.5072.65%BJ010華北北京
3、北京自營AAAA-02111000075632.0068.76%DCS001華中湖南長沙加盟AAAA-203180000120957.5067.20%DCS002華中湖南長沙加盟AAAA-20411000074768.0067.97%CS001華東江蘇常熟自營AAAA-0429000048007.0053.34%CS002華東江蘇常熟自營AAAA-0439000027312.0030.35%CZ001華東江蘇常州自營AAAA-040150000119017.0079.34%CZ002華東江蘇常州自營AAAA-04412000083735.8069.78%CD002西南四川成都自營AAAA-13
4、712500094987.0075.99%CD004西南四川成都自營AAAA-138145000131332.0090.57%CD005西南四川成都自營AAAA-139128000102173.0079.82%CD006西南四川成都自營AAAA-140128000103908.0081.18%CD007西南四川成都自營AAAA-141152000116719.2076.79%RCD001西南四川成都自營AAAA-1425800033480.5057.73%CD008西南四川成都自營AAAA-143164000125187.0076.33%DL001東北遼寧大連自營AAAA-0011000005
5、7062.0057.06%DL002東北遼寧大連自營AAAA-002150000130192.5086.80%DL004東北遼寧大連自營AAAA-00312000086772.0072.31%DDY001華東江蘇丹陽加盟AAAA-17810000054622.0054.62%DDT001華東江蘇東臺加盟AAAA-1694000030857.0077.14%DGD001華南廣東東莞加盟AAAA-1939000073297.5081.44%DGD002華南廣東東莞加盟AAAA-19411000086530.0078.66%RDGD001華南廣東東莞加盟AAAA-1978000043431.0054
6、.29%DFJ001華東福建福建加盟AAAA-1656000031012.0051.69%DFJ002華東福建福建加盟AAAA-1668000059495.5074.37%DFJ003華東福建福建加盟AAAA-1679000051182.5056.87%FJ002華東福建福州自營AAAA-023150000143488.0095.66%FZ002華東福建福州自營AAAA-024150000133238.5088.83%FZ003華東福建福州自營AAAA-025150000144797.0096.53%FZ004華東福建福州自營AAAA-0267000059182.0084.55%DFY001華
7、東安徽阜陽加盟AAAA-1628000046661.0058.33%HZ006華東浙江富陽自營AAAA-1039000044269.0049.19%GD007華南廣東廣州自營AAAA-1118800052785.1059.98%GD003華南廣東廣州自營AAAA-11211800083692.0070.93%GD009華南廣東廣州自營AAAA-1137000042910.4061.30%DGY001西南貴州貴陽加盟AAAA-2069000060446.0067.16%DHK001華南海南?？诩用薃AAA-19812000091160.0075.97%DHK002華南海南海口加盟AAAA-199
8、12000081095.5067.58%HZ002華東浙江杭州自營AAAA-1049000053034.0058.93%HZ003華東浙江杭州自營AAAA-105150000120190.0080.13%HZ005華東浙江杭州自營AAAA-10611000081298.4073.91%HZ007華東浙江杭州自營AAAA-10710000092160.8092.16%DHF001華東安徽合肥加盟AAAA-163140000101737.0072.67%DHF002華東安徽合肥加盟AAAA-1648000060415.5075.52%DHN002華北河南河南加盟AAAA-2007000039418
9、.0056.31%DZK001華北河南河南加盟AAAA-2019500055732.0058.67%DMG002西北內(nèi)蒙古呼和浩特加盟AAAA-15611000073663.5066.97%DWL001西北內(nèi)蒙古呼和浩特加盟AAAA-1577000042953.5061.36%DHA001華東江蘇淮安加盟AAAA-17012000076487.0063.74%JN002華北山東濟南自營AAAA-05811000072584.0065.99%JN003華北山東濟南自營AAAA-0609000049939.0055.49%JN004華北山東濟南自營AAAA-06110000075841.0075.
10、84%DJN001華北山東濟南加盟AAAA-17912000097840.5081.53%DJN002華北山東濟南加盟AAAA-1807000078690.00112.41%DJY001華東江蘇江陰加盟AAAA-17114000092477.0066.06%DHN001華北河南開封加盟AAAA-20211000055254.0050.23%DYN001西南云南昆明加盟AAAA-207130000108658.0083.58%KS001華東江蘇昆山自營AAAA-0457000039792.2056.85%DLY001華東江蘇連云港加盟AAAA-1728000063523.0079.40%NC00
11、1華中江西南昌自營AAAA-0575500034068.0061.94%NJ001華東江蘇南京自營AAAA-03414000097473.0069.62%NJ007華東江蘇南京自營AAAA-035320000225713.0070.54%NJ002華東江蘇南京自營AAAA-046200000150337.2075.17%NJ003華東江蘇南京自營AAAA-0478000049262.0061.58%NJ005華東江蘇南京自營AAAA-04811000080842.0073.49%NJ006華東江蘇南京自營AAAA-0498000052031.0065.04%DNT001華東江蘇南通加盟AAAA
12、-17310000068748.5068.75%NB001華東浙江寧波自營AAAA-108150000104677.3069.78%NB002華東浙江寧波自營AAAA-10914000049917.2035.66%DMG003東北黑龍江齊齊哈爾加盟AAAA-1507000047394.5067.71%DHB001華北河北秦皇島加盟AAAA-15213000087255.5067.12%DJS001華東江蘇秦州加盟AAAA-17411000067939.0061.76%QD001華北山東青島自營AAAA-06215000084862.0056.57%QZ001華東福建泉州自營AAAA-02712
13、000033127.5027.61%QZ002華東福建泉州自營AAAA-0287000047428.0067.75%DQZ001華東福建泉州加盟AAAA-16813000066526.0051.17%DSX002華北山西山西加盟AAAA-158140000100483.5071.77%DSX003華北山西山西加盟AAAA-1595500031398.0057.09%DYC001華北山西山西加盟AAAA-1605500027749.0050.45%DST001華南廣東汕頭加盟AAAA-195180000102682.0057.05%MF010華東上海上海自營AAAA-06320000014471
14、7.0072.36%MF018華東上海上海自營AAAA-064140000143178.00102.27%MF020華東上海上海自營AAAA-0659000064120.0071.24%MF030華東上海上海自營AAAA-06610000072720.0072.72%MF003華東上海上海自營AAAA-068200000154230.0077.12%MF008華東上海上海自營AAAA-069220000185887.0084.49%MF009華東上海上海自營AAAA-0705000056165.00112.33%MF012華東上海上海自營AAAA-071190000134000.0070.53
15、%MF019華東上海上海自營AAAA-07210000080526.0080.53%MF001華東上海上海自營AAAA-073330000220182.0066.72%MF005華東上海上海自營AAAA-074200000111313.0055.66%MF007華東上海上海自營AAAA-075200000145433.6072.72%MF011華東上海上海自營AAAA-076120000105740.0088.12%MF013華東上海上海自營AAAA-077200000147275.2073.64%MF016華東上海上海自營AAAA-078180000161420.0089.68%MF017華
16、東上海上海自營AAAA-07910000088067.0088.07%MF021華東上海上海自營AAAA-080170000153762.0090.45%MF022華東上海上海自營AAAA-08111000091776.5083.43%MF023華東上海上海自營AAAA-0825000044582.0089.16%MF024華東上海上海自營AAAA-083180000196922.00109.40%MF025華東上海上海自營AAAA-084160000132376.0082.74%MF026華東上海上海自營AAAA-085300000267968.0089.32%MF028華東上海上海自營AA
17、AA-08610000089749.0089.75%MF029華東上海上海自營AAAA-087180000184037.00102.24%MF031華東上海上海自營AAAA-088150000138033.0092.02%MF034華東上海上海自營AAAA-089140000107421.0076.73%MF036華東上海上海自營AAAA-090100000102873.00102.87%SR001華東上海上海自營AAAA-091420000279503.5466.55%SR002華東上海上海自營AAAA-0924000026201.8065.50%WD001華東上海上海自營AAAA-0934
18、00000337151.6084.29%RJD001華東上海上海自營AAAA-1016000044867.0074.78%RSH002華東上海上海自營AAAA-1027000034733.2049.62%MF014華東上海上海郊縣自營AAAA-067150000134295.0089.53%FX001華東上海上海郊縣自營AAAA-09410000077594.0077.59%FX002華東上海上海郊縣自營AAAA-09511000088040.0080.04%JD001華東上海上海郊縣自營AAAA-096260000176789.6068.00%JD002華東上海上海郊縣自營AAAA-0971
19、1000089907.0081.73%MF027華東上海上海郊縣自營AAAA-09810000086219.0086.22%MF035華東上海上海郊縣自營AAAA-09910000072110.0072.11%QP002華東上海上海郊縣自營AAAA-10013000075627.0058.17%GD001華南廣東深圳自營AAAA-1148400055218.5065.74%GD002華南廣東深圳自營AAAA-11512800095128.0074.32%GD004華南廣東深圳自營AAAA-1169300084445.0090.80%GD005華南廣東深圳自營AAAA-1171020007196
20、7.0070.56%GD006華南廣東深圳自營AAAA-1186500046948.5072.23%GD008華南廣東深圳自營AAAA-1199200078171.0084.97%GD010華南廣東深圳自營AAAA-1206000044010.5073.35%DTQ001華南廣東深圳加盟AAAA-1968000049888.0062.36%SY001東北遼寧沈陽自營AAAA-004160000103890.0064.93%SY002東北遼寧沈陽自營AAAA-005160000107766.0067.35%SY004東北遼寧沈陽自營AAAA-0069000057502.0063.89%SY005
21、東北遼寧沈陽自營AAAA-007160000116300.0072.69%SY006東北遼寧沈陽自營AAAA-00811000063287.0057.53%SY007東北遼寧沈陽自營AAAA-009120000112345.0093.62%SY008東北遼寧沈陽自營AAAA-01010000080036.0080.04%SY009東北遼寧沈陽自營AAAA-01112000073686.5061.41%DHB003華北河北石家莊加盟AAAA-15316000084674.5052.92%SZ004華東江蘇蘇州自營AAAA-03613000087781.0067.52%SZ001華東江蘇蘇州自營A
22、AAA-05012000068165.0056.80%SZ002華東江蘇蘇州自營AAAA-05110000057826.0057.83%TC001華東江蘇太倉自營AAAA-0376000027738.0046.23%DHB002華北河北唐山加盟AAAA-15416000091084.0056.93%TJ001華北天津天津自營AAAA-02218000082089.0045.61%DTZ001華東江蘇通州加盟AAAA-1755000041735.0083.47%DWF001華北山東濰坊加盟AAAA-1819000054940.5061.05%DWF003華北山東濰坊加盟AAAA-18270000
23、26127.5037.33%WZ001華東浙江溫州自營AAAA-1109000070575.0078.42%WX001華東江蘇無錫自營AAAA-052320000169513.5052.97%WX002華東江蘇無錫自營AAAA-0536000046243.2077.07%WX003華東江蘇無錫自營AAAA-0548000060735.0075.92%WX004華東江蘇無錫自營AAAA-05610000069088.0069.09%DWX001華東江蘇無錫加盟AAAA-17612000085948.0071.62%DWX002華東江蘇無錫加盟AAAA-17710000079895.0079.90
24、%SZ003華東江蘇吳江自營AAAA-0556000036938.0061.56%WF001華東江蘇蕪湖自營AAAA-0388000061861.0077.33%WH010華中湖北武漢自營AAAA-1218000053487.0066.86%WH001華中湖北武漢自營AAAA-1237500041975.2055.97%WH002華中湖北武漢自營AAAA-124165000121736.0073.78%WH003華中湖北武漢自營AAAA-125230000155823.0067.75%WH005華中湖北武漢自營AAAA-12612000066227.0055.19%WH007華中湖北武漢自營A
25、AAA-1277000042190.0060.27%WH008華中湖北武漢自營AAAA-1289000053083.0058.98%WH009華中湖北武漢自營AAAA-129180000103156.0057.31%XA006西北陜西西安自營AAAA-130150000119815.5079.88%XA008西北陜西西安自營AAAA-131380000271057.7071.33%XA001西北陜西西安自營AAAA-13211000091505.0083.19%XA002西北陜西西安自營AAAA-133164000104622.0063.79%XA004西北陜西西安自營AAAA-1345000
26、035594.0071.19%XA005西北陜西西安自營AAAA-135200000139205.2069.60%XA007西北陜西西安自營AAAA-13610000077982.1077.98%XM001華東福建廈門自營AAAA-029150000115307.5076.87%XM002華東福建廈門自營AAAA-030150000106703.0071.14%XM003華東福建廈門自營AAAA-03112000098162.5081.80%XM004華東福建廈門自營AAAA-032120000108026.0090.02%XM005華東福建廈門自營AAAA-033120000127802.0
27、0106.50%YT003華北山東煙臺自營AAAA-0595000032033.0064.07%YC001華中湖北宜昌自營AAAA-1228000049880.0062.35%JS001華東江蘇宜興自營AAAA-0397000052791.0075.42%DCX001華東浙江浙江加盟AAAA-1847000041125.0058.75%DDY002華東浙江浙江加盟AAAA-1856000025843.0043.07%DHZ001華東浙江浙江加盟AAAA-1867000043769.5062.53%DJX001華東浙江浙江加盟AAAA-1879000047785.0053.09%DLH001華東
28、浙江浙江加盟AAAA-18812000054112.0045.09%DXS001華東浙江浙江加盟AAAA-18910000056516.5056.52%DYY001華東浙江浙江加盟AAAA-1908000041391.0051.74%DZJ001華東浙江浙江加盟AAAA-1913000013902.2046.34%DZS001華東浙江浙江加盟AAAA-1929000047192.0052.44%ZJ001華東江蘇鎮(zhèn)江自營AAAA-04114000073155.0052.25%CQ007西南重慶重慶自營AAAA-1448000062012.0077.52%CQ001西南重慶重慶自營AAAA-14
29、56500062033.5095.44%CQ002西南重慶重慶自營AAAA-1463000022594.1075.31%CQ003西南重慶重慶自營AAAA-147162000108316.0066.86%CQ004西南重慶重慶自營AAAA-14814300085770.5059.98%RCQ001西南重慶重慶自營AAAA-1493000015499.0051.66%CQ006西南重慶重慶自營AAAA-2089000064530.0071.70%DZB001華北山東淄博加盟AAAA-1835000034785.5069.57%毛毛利利率率毛毛利利額額銷銷售售成成本本64.67%38286.102
30、0915.9063.42%46013.9026539.6063.79%33951.3019271.2065.76%37651.4019604.2062.53%30337.1918181.8164.45%160698.0988623.4163.64%63515.0336295.9761.92%54125.8033288.2064.23%66924.4037273.6065.40%85089.3345015.6764.73%46040.2625083.7465.17%63815.6934108.3166.30%48164.3724486.1364.43%48729.1426902.8664.84%
31、78429.4042528.1062.84%46980.7027787.3059.99%28797.1819209.8261.56%16812.9310499.0758.77%69944.8749072.1361.76%51715.5032020.3061.56%58475.5036511.5062.33%81861.8049470.2062.94%64303.8037869.2061.02%63405.4040502.6061.34%71590.1045129.1073.08%24467.209013.3063.54%79541.1045645.9063.25%36089.7520972.2
32、564.51%83984.3346208.1763.86%55416.1931355.8164.42%35187.9019434.1063.24%19515.1011341.9061.84%45329.1027968.4064.22%55568.6030961.4074.66%32425.0011006.0064.03%19856.2011155.8063.84%37983.9021511.6064.81%33171.3018011.2062.01%88979.2954508.7162.01%82620.0150618.4961.46%88985.3455811.6662.00%36693.8
33、922488.1162.65%29232.9017428.1062.26%27560.5216708.4859.77%31547.6821237.4259.63%49903.1633788.8457.85%24824.0418086.3667.18%40604.9019841.1064.66%58939.7032220.3066.34%53801.5027294.0061.55%32640.3320393.6761.80%74276.1045913.9061.16%49723.8131574.5961.71%56876.7435284.0663.92%65028.9036708.1062.82
34、%37953.5022462.0063.22%24918.9014499.1062.27%34701.9021030.1063.99%47137.6026525.9064.05%27512.4015441.1065.55%50136.0026351.0061.18%44409.3128174.6960.15%30038.1019900.9061.74%46827.0829013.9263.07%61709.5036131.0063.46%49939.5028750.5065.67%60731.2031745.8063.30%34976.8020277.2070.19%76268.2032389
35、.8059.78%23785.8316006.3763.96%40626.7022896.3065.11%22180.2311887.7759.69%58179.6839293.3261.23%138198.0487514.9662.58%94077.8256259.3861.25%30173.9319088.0762.19%50275.5730566.4362.20%32365.4319665.5763.81%43865.2024883.3062.06%64963.3739713.9361.84%30870.0719047.1362.79%29757.7017636.8064.94%5665
36、9.8030595.7064.08%43537.2024401.8061.50%52189.9832672.0261.58%20401.1912726.3161.69%29256.9318171.0763.71%42386.7024139.3066.02%66339.6034143.9061.60%19341.9012056.1064.01%17760.809988.2065.26%67013.5035668.5063.01%91187.1653529.8462.41%89362.4353815.5757.55%36899.4027220.6062.16%45205.8727514.1362.
37、71%96713.8257516.1863.71%118427.4467459.5660.63%34051.2522113.7563.25%84748.9449251.0662.59%50405.0330120.9759.44%130872.8389309.1762.12%69149.0342163.9762.49%90875.0854558.5261.87%65419.7140320.2962.48%92015.9155259.2962.64%101117.1560302.8562.77%55280.6632786.3462.21%95662.4958099.5161.45%56398.33
38、35378.1761.42%27383.1617198.8461.88%121848.1975073.8162.56%82815.3849560.6262.11%166429.08101538.9258.27%52294.2037454.8061.94%113999.6970037.3161.50%84892.5553140.4562.44%67074.1940346.8164.56%66412.6636460.3486.30%241204.1438299.4055.45%14528.6511673.1562.40%210375.78126775.8270.15%31473.5713393.4
39、369.02%23971.3810761.8261.94%83183.1451111.8659.82%46415.5731178.4359.18%52101.1135938.8961.75%109162.8667626.7462.74%56411.6133495.3960.12%51830.7334388.2761.52%44358.8927751.1161.16%46254.9329372.0756.92%31429.5623788.9462.38%59336.6635791.3463.78%53857.1930587.8161.91%44552.7727414.2362.26%29230.
40、6217717.8862.63%48960.9729210.0361.34%26995.9617014.5466.64%33243.9016644.1061.96%64370.7939519.2164.41%69408.3038357.7063.71%36634.6920867.3164.79%75354.9040945.1064.46%40796.6922490.3164.51%72475.8539869.1564.10%51299.5428736.4667.59%49806.5123879.9964.39%54520.8030153.7062.89%55202.0832578.9253.1
41、3%36218.1431946.8664.66%37393.1320432.8763.62%17646.4610091.5463.30%57652.6033431.4064.53%52972.0829116.9266.37%27701.1014033.9063.73%35011.0019929.5065.74%17175.608951.9062.31%43977.3526597.6561.98%105062.1464451.3659.52%27524.4618718.7464.22%39001.9521733.0567.04%46317.4522770.5563.56%54624.303132
42、3.7063.73%50920.0028975.0061.71%22793.5514144.4564.29%39771.4022089.6062.60%33481.2320005.7761.23%25700.1116275.0963.45%77246.1544489.8563.79%99403.1456419.8662.68%41513.8624713.1462.89%26533.6015656.4063.53%33724.6019358.4063.68%65686.7037469.3066.96%80232.5039583.0066.68%180750.0090307.7063.88%584
43、55.3033049.7066.80%69884.6034737.4066.07%23518.0012076.0066.71%92861.4046343.8066.53%51883.0026099.1060.91%70232.8845074.6260.59%64653.2642049.7460.24%59132.3239030.1861.20%66110.3441915.6660.59%77431.8950370.1159.71%19127.4812905.5264.56%32200.8917679.1160.82%32107.1420683.8662.70%25784.3015340.706
44、4.03%16546.909296.1064.20%28098.5015671.0063.49%30338.9017446.1066.13%35786.3018325.7063.41%35834.7020681.8063.03%26088.9015302.1065.10%9050.804851.4063.64%30030.8017161.2061.72%45151.2628003.7463.60%39437.9022574.1062.72%38904.4023129.1056.12%12679.909914.2064.24%69583.7038732.3063.71%54643.9031126
45、.6070.08%10861.204637.8063.88%41220.6023309.4064.26%22354.9012430.60大大區(qū)區(qū)本本月月指指標標實實際際銷銷售售金金額額毛毛利利額額銷銷售售成成本本東東北北 平平均均值值121666.66786352.7955449.6030903.19東東北北 合合計計14600001036233.50665395.24370838.26東東北北 店店鋪鋪數(shù)數(shù)12華華北北 平平均均值值118387.09776023.7148507.0427516.67華華北北 合合計計36700002356735.101503718.33853016.77華華
46、北北 店店鋪鋪數(shù)數(shù)31華華東東 平平均均值值126376.14792443.5958077.2534366.35華華東東 合合計計1377500010076351.846330419.863745931.98華華東東 店店鋪鋪數(shù)數(shù)109華華南南 平平均均值值98823.529469609.4143938.8225670.59華華南南 合合計計16800001183360.00746959.91436400.09華華南南 店店鋪鋪數(shù)數(shù)17華華中中 平平均均值值119583.33376445.8948590.0527855.84華華中中 合合計計1435000917350.70583080.613
47、34270.09華華中中 店店鋪鋪數(shù)數(shù)12西西北北 平平均均值值135818.18298379.5064745.4533634.05西西北北 合合計計14940001082174.50712200.00369974.50西西北北 店店鋪鋪數(shù)數(shù)11西西南南 平平均均值值10750081102.8651740.6029362.26西西南南 合合計計17200001297645.80827849.60469796.20西西南南 店店鋪鋪數(shù)數(shù)16總總計計平平均均值值121317.30886297.3654661.6531635.71總總計計2523400017949851.4411369623.556
48、580227.89總總店店鋪鋪數(shù)數(shù)208科科目目編編碼碼科科目目名名稱稱金金額額5101主主營營業(yè)業(yè)務務收收入入-407,158.64-407,158.64510101產(chǎn)品銷售收入-407,158.64510102銷售退回-510103購物券-510104銷售折扣-5102其其他他業(yè)業(yè)務務收收入入-4,000.00-4,000.005201投投資資收收益益-5203補補貼貼收收入入-5301營營業(yè)業(yè)外外收收入入-968.49-968.495401主主營營業(yè)業(yè)務務成成本本145,243.44145,243.44540101主營業(yè)務成本145,243.44540102產(chǎn)品價格差異-540103產(chǎn)品
49、質(zhì)檢差旅費-54010301機票-54010302火車票及其他-54010303住宿費-54010304往返碼頭交通費-54010305當?shù)爻霾罱煌ㄙM-54010306出差補貼及其他 -540104其他成本-5402主主營營業(yè)業(yè)務務稅稅金金及及附附加加1,236.791,236.795405其其他他業(yè)業(yè)務務支支出出200.00200.005501營營業(yè)業(yè)費費用用327,361.14327,361.14550101工資-550102勞務費136,848.53550103養(yǎng)老保險金-550104醫(yī)療保險金-550105失業(yè)保險金-550106工傷保險金-550107生育保險金-550108職工工會
50、經(jīng)費-550109教育經(jīng)費-550110公積金-550111員工福利791.45550112加班福利129.33550113房租98,207.24550114水電費10,981.96550115電話通信費1,485.92550116辦公室郵費31.20550117辦公費11,054.09550118交通費174.43550119差旅費1,306.5955011901機票-55011902火車票及其他139.2055011903住宿費122.4055011904往返碼頭交通費51.9055011905當?shù)爻霾罱煌ㄙM63.0955011906出差補貼及其他930.00550120交際費280.00
51、550121其它218.50550122包裹郵費28.40550123包裹運費1,311.70550124包裝費-550125攝制排版費-550126目錄印刷費-550127目錄郵寄費-550128信封及其他-550129雜志廣告-550130其它廣告2,658.50550131促銷費-550132樣品費-550133攤銷費60,499.40550134折舊費1,343.90550135招聘費-550136保險費-550137汽車費-550138商場扣費-550139專業(yè)服務費10.005502管管理理費用用120.15550201工資-550202勞務費-550203養(yǎng)老保險金-550204
52、醫(yī)療保險金-550205失業(yè)保險金-550206工傷保險金-550207生育保險金-550208職工工會經(jīng)費-550209教育經(jīng)費-550210公積金-550211員工福利-550212加班福利-550213房租-550214水電費-550215電話通信費-550216辦公室郵費-550217辦公費-550218交通費-550219差旅費-55021901機票-55021902火車票及其他-55021903住宿費-55021904往返碼頭交通費-55021905當?shù)爻霾罱煌ㄙM-55021906出差補貼及其他 -550220交際費-550221其它-550222招聘費用-550223培訓費-55
53、0224修理保養(yǎng)費-550225專業(yè)服務費-550226保險費-550227倉庫用品-550228汽車費用-550229其它稅金102.15550230折舊費用18.00550231攤消費用-550232存貨盤盈虧-550233壞帳費用-5503財務費用用3,011.86550301銀行手續(xù)費620.21550302銀行手續(xù)費（信用卡）2,391.65550303匯兌損益-550304利息收支-550305現(xiàn)金折扣-5601營業(yè)外外支支出出6,567.495701所所得得稅稅-5801以以前前年年度度損益益調(diào)整整-凈利潤71613.7362科科目目編編碼碼科科目目名名稱稱金金額額5101主主營
54、營業(yè)業(yè)務務收收入入-407,158.64-407,158.645102其其他他業(yè)業(yè)務務收收入入-4,000.00-4,000.005201投投資資收收益益-5203補補貼貼收收入入-5301營營業(yè)業(yè)外外收收入入-968.49-968.495401主主營營業(yè)業(yè)務務成成本本145,243.44145,243.445402主主營營業(yè)業(yè)務務稅稅金金及及附附加加1,236.791,236.795405其其他他業(yè)業(yè)務務支支出出200.00200.005501營營業(yè)業(yè)費費用用327,361.14327,361.145502管管理理費用用120.155503財務費用用3,011.865601營業(yè)外外支支出出6,567.495701所所得得稅稅-5801以以前前年年度度損益益調(diào)整整-凈凈利利潤潤：-71613.74-71613.74
案例10 創(chuàng)建多層次的分類匯總和分級顯示
