全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

多公司年度损益汇总表

收藏
  • 多公司年度损益汇总表-表格模板多公司、多月份的报表有很多，本案例用损益表来举例，讲解如何把多表整合进一个表中，通过下拉列表切换出每个分公司的全年数据一览表。,,损益表融美公司2018年损益数据一览表,融美公司,项 目行次1月2月3月4月5月6月7月8月9月10月11月12月,一.主营业务收入1.0469948.0183185.3254577.67457990.5441432.0435777.46353045.32496122.1683188.9345269.17780626.01058786.3, 主营业务成本2.0357398.42106850.7184329.74312343.39325434.0300888.78243521.27329104.86419121.18222436.06397633.33757716.14, 营业费用3.0, 主营业务税金及附加4.0,二.主营业务利润7.0112549.5876334.670247.93145647.11115998.0134888.68109524.05167017.24264067.72122833.11382992.67301070.16, 加:其他业务利润9.03035.30932344490.16427954279.743377565390.046124837268.711648738924.052926133917.751713533434.258832488041.708095383141.595373597248.384480019371.36333938, 减:管理费用10.083285.4159620.5364091.475683.7360921.4273226.0569344.9970453.182799.4376805.093934.7995062.81, 财务费用11.0, 其中:利息支出净额,三.营业利润14.032299.479323470586.682926144096.8117135189309.99809549169.7053736296306.26448215378.713339, 加:投资收益15.01551.0, 补贴收入16.01310.0675.0530.01735.0596.06430.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.033850.479323471896.682926144771.8117135189839.99809550904.7053736296902.26448221808.713339, 减:所得税26.0, 净利润30.033850.479323471896.682926144771.8117135189839.99809550904.7053736296902.26448221808.713339,,盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,575.0329.0354.0720.0503.0743.0597.0616.0,895.0806.0420.0322.0377.0502.0322.0631.0,802.0707.0690.0499.0317.0638.0464.0640.0,842.0768.0515.0650.0898.0794.0804.0484.0,670.0348.0730.0753.0373.0369.0666.0544.0,勤美公司420.0=HLOOKUP(B9,A1:H6,3,0),,损益表,43130.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.06818857.423003608.5900969.021529327.5469948.0414055.42185590.0132237.98183121.0, 主营业务成本2.05457673.392509806.09781443.01148253.0357398.42337345.04121958.9677018.38124450.5, 营业费用3.0, 主营业务税金及附加4.010082.641699.08383.64,二.主营业务利润7.01351101.39493802.41119526.02379375.5112549.5876710.3863631.0446835.9658670.5, 加:其他业务利润9.055561.523342236593.51525.3878951693576.829036773035.30932342929.12296558540.3643841396583.419656631777.58008048, 减:管理费用10.0679154.51338888.3850244.397154.5283285.4127545.53283.046587.932165.5, 财务费用11.086926.9186968.73-41.82, 其中:利息支出净额,三.营业利润14.0640581.49334232299.479323428282.5800805, 加:投资收益（施乐美橙利润）15.01551.01551.0, 补贴收入16.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0642132.49334233850.479323428282.5800805, 减:所得税26.05145.15145.1, 净利润30.0636987.39334233850.479323423137.4800805,,损益表,43159.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.02633437.361021715.0304193.0383493.06183185.3300314.0124580.0161867.0154090.0, 主营业务成本2.01983305.88874184.28234460.0307567.5106850.7269784.5460348.0632532.897578.0, 营业费用3.0, 主营业务税金及附加4.04816.12226.22589.9,二.主营业务利润7.0645315.38147530.7269733.073699.3676334.630529.4664231.94126744.356512.0, 加:其他业务利润9.0138749.98329102071.887139.624148621740.33395434490.16427952429.934306757971.771527537463.201208055443.07386562, 减:管理费用10.0395730.75155936.2639696.055169.2559620.5317308.92875.041084.8124040.0, 财务费用11.084695.6684695.66, 其中:利息支出净额,三.营业利润14.0303638.9532937915.0738656, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0303638.9532937915.0738656, 减:所得税26.0720.0720.0, 净利润30.0302918.9532937195.0738656,,损益表,43189.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.06119450.952707402.0794572.681599169.0254577.67314491.6135584.0211697.0101957.0, 主营业务成本2.04739083.312128410.81716321.01226674.3184329.74214973.3359335.53148358.060680.6, 营业费用3.0, 主营业务税金及附加4.02189.02189.0,二.主营业务利润7.01378178.64578991.1978251.68370305.770247.9399518.2776248.4763339.041276.4, 加:其他业务利润9.046925.516834419895.09741.6611211131.637316624279.743377562716.918812562807.92066531133.0042364596219.6313049, 减:管理费用10.0675720.52388514.2539237.257796.364091.422683.22569.062270.9738558.2, 财务费用11.0129064.68129064.68, 其中:利息支出净额,三.营业利润14.0620318.9568348937.8313049, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0620318.9568348937.8313049, 减:所得税26.0720.0720.0, 净利润30.0619598.9568348217.8313049,,损益表,43220.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.06687975.92886453.01161350.01225862.6457990.5318854.0352655.0139427.0145383.8, 主营业务成本2.05387332.412214732.391084097.01031715.0312343.39292588.27268982.8683094.099779.5, 营业费用3.0, 主营业务税金及附加4.010435.72258.08177.7,二.主营业务利润7.01290207.79671720.6177253.0191889.6145647.1126265.7383672.1448155.345604.3, 加:其他业务利润9.059756.378067929546.53002.487680278823.720685045390.046124831339.68219552955.1480838371595.295293499103.49800493, 减:管理费用10.0699327.75392805.4143868.955000.175683.7325830.96495.547236.3152406.9, 财务费用11.0111396.8111465.09-68.29, 其中:利息支出净额,三.营业利润14.0539239.6180682300.89800493, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0539239.6180682300.89800493, 减:所得税26.0720.0720.0, 净利润30.0538519.6180681580.89800493,,损益表,43250.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.06074249.42703754.8855860.01228084.0441432.0359319.0125925.0152525.0207349.6, 主营业务成本2.04904567.252205332.26740513.0965706.0325434.0318569.1997375.899322.0152315.0, 营业费用3.0, 主营业务税金及附加4.06264.942993.03271.94,二.主营业务利润7.01163417.21498422.54115347.0259385.0115998.040749.8128549.249931.0655034.6, 加:其他业务利润9.080780.388870747411.35761.176417927131.521298617268.711648731276.802742694071.696572561396.507221546462.6729686, 减:管理费用10.0591868.51261145.4341682.184472.960921.4235907.522743.048661.3456334.8, 财务费用11.0110534.44110534.44, 其中:利息支出净额,三.营业利润14.0541794.6488715162.4729686, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0541794.6488715162.4729686, 减:所得税26.04007.84007.8, 净利润30.0537786.8488711154.6729686,,损益表,43281.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.05664010.162503881.2838339.0965004.0435777.46364933.0170302.0250640.0135133.5, 主营业务成本2.04552797.492107342.1697401.0751090.5300888.78347632.08110101.93147552.090789.1, 营业费用3.0, 主营业务税金及附加4.04768.992390.02378.99,二.主营业务利润7.01106443.68396539.1140938.0211523.5134888.6817300.9260200.07100709.0144344.4, 加:其他业务利润9.092866.931261950504.01165.34687187302.6111763048924.052926134626.116903259146.829510469404.085521728793.88835216, 减:管理费用10.0573308.97263323.5745469.872784.273226.0521288.5610757.165268.2221191.47, 财务费用11.0144449.43144479.03-29.6, 其中:利息支出净额,三.营业利润14.0481552.211262139071.51117670586.682926131946.8183522, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.01595.0285.01310.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0483147.211262139356.51117671896.682926131946.8183522, 减:所得税26.03195.83195.8, 净利润30.0479951.411262139356.51117671896.682926128751.0183522,,损益表,43311.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.05212055.912301159.9599445.0971018.3353045.32564525.19185672.799806.0137383.5, 主营业务成本2.04299135.831961922.49543026.0759467.0243521.27543471.2101966.2748224.097537.6, 营业费用3.0, 主营业务税金及附加4.08411.783371.55040.28,二.主营业务利润7.0904508.3339237.4156419.0208179.8109524.0521053.9983706.4346541.7239845.9, 加:其他业务利润9.0164407.672887127349.888027.225021813997.169437253917.751713538172.901024921839.323015132566.932213288536.49046068, 减:管理费用10.0470850.55190581.5345051.5978976.769344.9923518.74596.036901.921879.14, 财务费用11.0106984.57106984.57, 其中:利息支出净额,三.营业利润14.0491080.852887133200.26943744096.811713526503.2504607, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.01303.0628.0675.0, 17.0, 减:营业外支出18.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0492383.852887133828.26943744771.811713526503.2504607, 减:所得税26.03195.83195.8, 净利润30.0489188.052887133828.26943744771.811713523307.4504607,,损益表,43342.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.07231338.372915101.04641337.72035171.0496122.1650102.25114488.98195446.0183569.3, 主营业务成本2.05544941.722290759.14570395.01483911.0329104.86558658.6495537.36120914.095661.72, 营业费用3.0, 主营业务税金及附加4.04030.192160.01870.19,0.785824953772,二.主营业务利润7.01682366.46624341.970942.7549100.0167017.2491443.6118951.6272661.8187907.58, 加:其他业务利润9.088224.658060470246.03296.20164306718.3038264043434.258832481102.59857073330.140526575609.615861487.538800199, 减:管理费用10.0559310.17259099.3844276.4360869.4570453.127615.425748.7255148.236099.47, 财务费用11.0138103.54137992.67-9.13120.0, 其中:利息支出净额,三.营业利润14.01073177.40806297495.85488948.85382652175.6488002, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.02542.02542.0, 17.0, 减:营业外支出18.020915.020915.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.01054804.40806276580.85491490.85382652175.6488002, 减:所得税26.03640.83640.8, 净利润30.01051163.60806276580.85491490.85382648534.8488002,,损益表,43373.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.07658996.963129940.0720947.01485931.5683188.9510053.11194301.95215749.0718885.5, 主营业务成本2.06041451.572659271.51642560.01098395.0419121.18452223.67112332.2116291.0541257.01, 营业费用3.0, 主营业务税金及附加4.04944.142680.02264.14,0.8496237979,二.主营业务利润7.01612601.25470668.4978387.0384856.5264067.7257829.4481969.7597193.86177628.49, 加:其他业务利润9.047155.918255614182.03208.894335433322.320756048041.708095386155.695834935083.760623141724.285275415437.25333526, 减:管理费用10.0533812.15157265.5948294.6392750.682799.4318807.06445.7361490.865958.37, 财务费用11.0177982.96177982.96, 其中:利息支出净额,三.营业利润14.0947962.058256149601.94295428.220756189309.998095, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.01086.0556.0530.0, 17.0, 减:营业外支出18.058570.3558570.35, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0890477.70825691031.59295984.220756189839.998095, 减:所得税26.0, 净利润30.0890477.70825691031.59295984.220756189839.998095,,损益表,43403.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.05838768.32589593.0815657.3904667.05345269.17425920.3148327.48195965.0413369.0, 主营业务成本2.04687919.182197610.67776302.5690424.0222436.06353078.3763449.5111662.0272956.08, 营业费用3.0, 主营业务税金及附加4.05172.742100.03072.74,0.848631684593,二.主营业务利润7.01145676.38391982.3339354.8212143.05122833.1172841.9384877.9881230.26140412.92, 加:其他业务利润9.054424.906786110542.229459.979432259818.690303983141.595373598548.282712947639.623862662360.440604692914.07449603, 减:管理费用10.0526405.38139643.3941164.5393854.2276805.040343.72369.549715.582509.54, 财务费用11.0156133.53156089.26-28.7373.0, 其中:利息支出净额,三.营业利润14.0517562.376786106791.9128136.25030449169.7053736, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.02948.01213.01735.0, 17.0, 减:营业外支出18.028562.7428562.74, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0491947.63678678229.16129349.25030450904.7053736, 减:所得税26.0, 净利润30.0491947.63678678229.16129349.25030450904.7053736,,损益表,43434.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.06954003.282591261.0883116.01411135.0780626.0488155.0188512.28160198.0451000.0, 主营业务成本2.05305409.362157126.97744843.01102150.5397633.33395492.8898008.1796383.0313771.51, 营业费用3.0, 主营业务税金及附加4.09109.372274.06835.37,0.832462252934,二.主营业务利润7.01639484.55434134.03138273.0306710.5382992.6792662.1290504.1156979.63137228.49, 加:其他业务利润9.077781.011607442077.06808.194753032694.383168397248.38448001305.7619310576277.508132422420.187468319949.59167416, 减:管理费用10.0547249.62175660.9138779.3393622.8593934.7923837.31694.055756.1664964.27, 财务费用11.098591.5898591.58, 其中:利息支出净额,三.营业利润14.01071424.36161201958.54215782.033168296306.26448, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.01103.8507.8596.0, 17.0, 减:营业外支出18.016300.016300.0, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.01056228.16161185658.54216289.833168296902.26448, 减:所得税26.0, 净利润30.01056228.16161185658.54216289.833168296902.26448,,损益表,43464.0,项 目行次全部盛世博美宸美公司勤美公司融美公司振美公司联美公司润美公司桦美公司,一.主营业务收入1.07427213.083183485.13806350.01122101.01058786.3564511.95183464.0253692.0254822.7, 主营业务成本2.06041549.012784681.77691341.0881911.0757716.14482678.04163532.04142024.02137665.0, 营业费用3.0, 主营业务税金及附加4.017178.923060.014118.92,二.主营业务利润7.01368485.15398803.36115009.0237130.0301070.1681833.9119931.9697549.06117157.7, 加:其他业务利润9.0252938.386281214804.659141.43132395820.2612272789371.36333938671.17549749352.726776346066.115661432710.66245487, 减:管理费用10.0722678.32326980.6237336.87105402.8595062.8139177.74795.054374.559547.97, 财务费用11.0103784.66103817.96-33.3, 其中:利息支出净额,三.营业利润14.0794960.556281182809.43132580.711227215378.713339, 加:投资收益（施乐美橙利润）15.0, 补贴收入16.07341.0911.06430.0, 17.0, 减:营业外支出18.0157731.94157731.94, 加:以前年度损益调整20.0,四.利润总额(亏损以"-"号表示)25.0644569.61628125077.49133491.711227221808.713339, 减:所得税26.0, 净利润30.0644569.61628125077.49133491.711227221808.713339,,=HLOOKUP($A$2,INDIRECT("'"&C$3&"'!D3:K23"),ROW(2:2),0),=HLOOKUP(查找值,查找区域,返回行数,精确查找),=INDIRECT("'"&C$3&"'!D3:K23")
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
财务汇总表-淘宝销售记账汇总.xls
财务汇总表-淘宝销售记账汇总.xls

财务汇总表-淘宝销售记账汇总

仓库发货日汇总损益表.xlsx
仓库发货日汇总损益表.xlsx

仓库发货日汇总损益表

成本核算明细表及汇总表.xls
成本核算明细表及汇总表.xls

成本核算明细表及汇总表

应收应付汇总表(自动计算）.xlsx
应收应付汇总表(自动计算）.xlsx

应收应付汇总表(自动计算）

收入支出自动汇总表.xls
收入支出自动汇总表.xls

收入支出自动汇总表

财务年度利润总表.xlsx
财务年度利润总表.xlsx

财务年度利润总表

财务收支汇总表.xls
财务收支汇总表.xls

财务收支汇总表

企业全年营业利润表年度损益表.xlsx
企业全年营业利润表年度损益表.xlsx

企业全年营业利润表年度损益表

财务收支汇总表.xls
财务收支汇总表.xls

财务收支汇总表

年度应收应付汇总表.xls
年度应收应付汇总表.xls

年度应收应付汇总表

年度利润表分析汇总统计表.xlsx
年度利润表分析汇总统计表.xlsx

年度利润表分析汇总统计表

营业汇总表.xls
营业汇总表.xls

营业汇总表

模板单价：￥19.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以19.99元购买此模板
  • 页数：15页
  • 时间：2019-11-18
  • 编号：20184463
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

伊格

设计作品207

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服