我想汇总得到这样的效果:
利 润 表 (当月) I N C O M E S T AT E M E N T
项 目 行 次 上海 浙江
I T E M S NO. 上海 杭州 嘉兴 温州 宁波 金华 台州 浙江A 浙江B 浙江C
产 品 销 售 收 入 Sales 1 3,877,854.01 3,218,053.60 4,189,452.82 4,666,272.08 2,805,833.02 1,685,361.66 - - -
其中:出口产品销售收入 Including: Export sales 2 - - - - - - - - -
减:销售折扣与折让 Less: Sales discounts and allowances 3 63,087.15 117,540.31 2,374.42 36,265.40 97,930.78 - - - -
4 - - - - - - - - -
5 - - - - - - - - -
产 品 销 售 净 额 NET SALES 6 3,814,766.86 3,100,513.29 4,187,078.40 4,630,006.68 2,707,902.24 1,685,361.66 - - -
减: 产品销售税金及附加 Less: Sales tax 7 48.24 710.11 5,086.84 - - 1,286.14 - - -
产品销售成本 Cost of sales 8 3,348,365.33 2,971,988.55 3,820,967.34 4,169,453.58 2,523,701.44 1,485,981.98 - - -
Including: Cost of export sales 9 - - - - - - - - -
10 - - - - - - - - -
11 - - - - - - - - -
产 品 销 售 毛 利 GROSS PROFIT ON SALES 12 466,353.29 127,814.63 361,024.22 460,553.10 184,200.80 198,093.54 - - -
减: 销 售 费 用 Less: Selling expenses 13 373,777.31 220,008.65 209,987.67 390,616.42 337,672.44 101,771.55 - - -
管 理 费 用 General and administrative expenses 14 - - - - - - - - -
财 务 费 用 Financial expenses 15 -2,495.61 -627.17 -904.77 -820.59 -1,011.92 -940.96 - - -
其中:利息支出(减:利息收入) Including: Interest expenses(Less interest income) 16 -2,725.61 -716.59 -990.27 -1,038.49 -1,201.42 -980.96 - - -
汇兑损失(减:汇兑收益) Exchange Loss(Less exchange gains) 17 - - - - - - - - -
18 - - - - - - - - -
19 - - - - - - - - -
产 品 销 售 利 润 PROFIT ON SALES 20 95,071.59 -91,566.85 151,941.32 70,757.27 -152,459.72 97,262.95 - - -
加:其他业务利润 Add: Income from other operations 21 - - - - - - - - -
22 - - - - - - - - -
23 - - - - - - - - -
营 业 利 润 OPERATION PROFIT 24 95,071.59 -91,566.85 151,941.32 70,757.27 -152,459.72 97,262.95 - - -
加:投 资 收 益 Add: Income from investments 25 - - - - - - - - -
营 业 外 收 入 Non-operating income 26 - - - - - - - - -
补 贴 收 入 Subsidies 27 - - - - - - - - -
减:营 业 外 支 出 Less: Non-operating expenses 28 - - - 6,457.55 - - - - -
加:以 前 年 度 损 益 调 整 Add: Adjustment to profit & loss brought forward 29 - - - - - - - - -
30 - - - - - - - - -
利 润 总 额 TOTAL PROFIT 31 95,071.59 -91,566.85 151,941.32 64,299.72 -152,459.72 97,262.95 - - -
减:所 得 税 Less: Income tax 32 - - - - - - - - -
净 利 润 NET PROFIT 33 95,071.59 -91,566.85 151,941.32 64,299.72 -152,459.72 97,262.95 - - -
而输入的时候都是每个分公司自己输入自己的当月数据 |