Creating 'Profit & Loss' Report Using Formulas pg 65

Creating 'Profit & Loss' Report Using Formulas

We use a separate sheet in the workbook to accommodate the Profit & Loss report (or Statement).

Insert a new sheet in the same file (workbook) which has the sheet DATA and name it appropriately (This book uses the name PL). The position of the sheet is not important. You can place it anywhere among the other sheets.

A suggested structure for a Profit & Loss statement is shown here:

	A								B			C
1	SATU DUA (M) SDN BHD
2
3	TRADING, PROFIT & LOSS ACCOUNT FOR THE PERIOD ENDED AT 31-5-2002
4
5	ACCOUNTS									YEAR TO DATE	
6												AS AT 31-05-02					
7												RM
8	INCOME
9	SALE										(13,491,982.03)
10	SALE RETURN									0.00
11	NET SALES									(13,491,882.03)
12
13	LESS COST OF SALES
14 	RAW MATERIAL								5,477,199.66
15	OPENING STOCK-RAW MATERIAL					3,111,627.20
16	OPENING STOCK-SEMI FINISHED PRODUCT			470,321.60
17 	OPENING STOCK FINISHED PRODUCT				152,959.00
18	
19												9,212,107 46
20 	LESS : CLOSING STOCK						
21 	CLOSING STOCK-RAV MATERIAL - COSA			(2,746,849.68)
22	CLOSING STOCK-SEMI FINISHED PRODUCT-COSA	(260,755.60)
23	CLOSING STOCK-FINISHED PRODUCT-COSA			(364,200.00)
24	
25	TOTAL CLOSING STOCK							(3,371,005.20)
26
27	COST OF SALES								5,040,222.10
28	
29	TOTAL INCOME								(7.651,759.85)
30	
31	LESS : DIRECT LABOUR COST
32	SALARY FACTORY								617.305.96
33	ATTENDANCE ALLOWANCE-FACTORY				12,460.00
34	BONUS-FACTORY								63.371.00
35	SALARY-FACTORY-COUPON						0.00
36	FOOD ALLOWANCE-FACTORY						0.00
37	
38	TOTAL LABOUR COST							683.216.36
39	
40	LESS: DIRECT EXPENSES
41	DEPRECIATION-FACTORY						265.052.05
42	

Continued...

65