(1) Create a new Excel 20 10 worksheet and name it "Income Statement".
(2) Enter the text, set the cell format and add a border, as shown in Figure 7- 1 17.
(3) Open the' Old Bookkeeping' worksheet, select the cell area A2: 1 10, and create a data with reference to the previous steps.
Pivot table, in which "account code" and "account name" are selected as the row label, and "total item: debit fund" is set as the column label.
Amount "and" Total Item: Credit Amount ",the name of the PivotTable report is set to" Journal Summary ",and the result is shown in Figure 7- 1 18.
(4) Return to the income statement, edit the "current period" of "main business income", select cell B5, and enter the formula.
"=SUMIF([ periodical. Xls] Journal summary table! A: A, 500 1, [Journal. Xls] Journal summary table! D: d) ",press Enter] to confirm, and the calculation result will be displayed in cell B5, as shown in Figure 7- 1 19.
(5) Similarly, edit the formulas of "Current Period" for "Main Business Cost" and "Main Business Tax and Surcharge".
Select cell B6 and enter the formula "=SUMIF([ journal. Xls] Journal Summary! " ! A, 5002, [Journal. Xls] magazine
Summary table! C:C)”； Select cell B7 and enter the formula "=SUMIF([ journal. Xls] journal summary table rA:A, 5004, [journal. Xls] Journal summary table! Colonel: Colonel, press Enterl to confirm, and the calculation result is shown in Figure 7- 120.
(6) Edit the "Current Period Number" formulas of "Operating Expenses", "Financial Expenses" and "Management Expenses". Select cell B9,
Enter the formula "=SUMIF([ journal. Xls] Journal summary table! A, 5003, [Journal. Xls] Journal summary table! C:C)”； Select Bl0 cell and enter the formula "=SUMIF([ journal. Xls] Journal Summary! " ! A, 50 12, [Journal. Xls] Journal summary table! C: c) ":select the cell B 1 1 and enter the formula" =SUMIF([ journal. Xls] Journal summary table! A: A, 50 1 1. [log. Xls] Journal summary table! Colonel: Colonel. Enter] Confirm that the calculation result is shown in Figure 7- 12 1.
(7) Edit the "Current Period" of various profit formulas, select cell B8 and enter the formula "-B5-B6-B7": select cell B 12 and enter the formula "= B8-B9-BLO-BLL"; Select cell B 16 and enter the formula "= b12+b13+b14-b15"; Select cell B 18 and enter the formula "=B 16-B 17". Enter] respectively, the calculation results are shown in figure 7- 122.
(8) Edit "Cumulative Number" of "Main Business Income", select cell C5, and enter the formula "=SUMIF([ GL. xls]"
General ledger! A: A, 500 1, [GL. xls] GL！ E: e) ",press enter] to confirm, and the calculation result will be displayed in C5 cell, as shown in Figure 7- 123.
(9) Edit "Cumulative Number" of "Main Business Cost" and "Main Business Tax and Surcharge" in the same way.
Type. Select C6 cell and enter the formula "=SUMIF([ GL. xls] GL！ A: A, 5002, [GL. xls] GL！ :D)； Select cell B7 and enter the formula "=SUMIF([ GL. xls] GL！ A, 5004, GL. xls] GL！ : D University). Press Enterl to confirm, and the calculation result is shown in Figure 7- 124.
(10) Edit the cumulative formula of operating expenses, financial expenses and management expenses. Select C9 list
In the cell, enter the formula "=SUMIF([ GL. xls] GL！ A, 5003, [GL. xls] GL！ D: d) ":Select cell Cl0 and enter the formula" =SUMIF([ GL. xls] GL！ A: A, 50 12, [GL. xls] GL！ :D)； Select the Cll cell and enter the formula "=SUMIF([ GL. xls] GL！ A, 50 1 1, GL. xls] GL！ : D University). Enter] Confirm that the calculation result is shown in Figure 7- 125.
(1 1) Edit the Cumulative Number of each profit formula, select cell C8, and enter the formula "= C5-C6-C7"; choose
Cell C 12, enter the formula "-C8-C9-ClO-Cll": select cell C 16, and enter the formula "= c12+c13+c14-c/"
Select the cell C 18 and enter the formula "=C 16-C 17". Enter] to confirm, and the calculation result is shown in figure 7- 126.
As shown in the figure. At this point, the design and production of the income statement is completed.