Effect of removing items in Pivot Table for Profit & Loss report p 71 72

If we look at the above, we will see the item NR. Now, remember that it is not a Profit & Loss item but indicate a Balance Sheet item. So, we don't want to see this item in the report. To remove from the report, here are the steps:

1. Click on the little downward arrow-head on the right side of PL-CATEGORY cell.

2. A list will appear.

3. Remove the check mark on the left of NR item.

4. Click OK.

5. The new report will exclude NR item.

6. The resulting Grand Total figure is the accumulated profit until end of the year.

	A						B
2
3	Sum of RM–NET
4 	PL-CATEGORY					Total
5	ADMIN EXPENSE					542-007 88
6	COMPANY TAX					4,637.08
7	COST OF SALE					5,840,222.18
8	DIRECT EXPENSE					289 801 31
9	INCOME						(13,491,962.00
10	LABOUR COST					693,216.96
11	NR						19,159.807.08
12	OTHER INCOME/EXPENSE				(957 274.79)
13							(11,960,539.28
14	OK		Cancel				119,926.38
15

NOTE3

If we remove check mark for all the items in the list except the items INCOME and COST OF SALE, we will get the Gross Mangin for the year

If we remove check marks for all the items except the items INCOME, ADMIN EXPENSE. COST OF SALE, DIRECT EXPENSE, LABOUR COST and OTHER INCOME EXPENSE, we will get the Profit Before Tax for the year figure.

If we remove check marks for all the items except the items INCOME, ADMIN EXPENSE, COST OF SALE, DIRECT EXPENSE, LABOUR COST, OTHER INCOME/EXPENSE and COMPANY TAX, we will get the Profit After Tax for the year figure.

71

If we remove check marks for all the Items except the item INCOME, ADMIN EXPENSE, COST OF SALE, DIRECT EXPENSE and LABOUR COST, we will get Operating Profit for the year figure.

If we mark only the items INCOME, COST OF SALE, LABOUR and DIRECT EXPENSE, we will get the Gress Profit figure.

The above report is the most basic form of our Profit & Loss report created using Pivot Table operation. It shows only the categories in the Profit & Loss. It does not show what accounts under each category