I show you how to use Microsoft Excel as complete Accounting system.
Sunday, August 23, 2026
Creating 'Profit & Loss' Report Using Formulas pg 66
40 LESS : DIRECT EXPENSES
41 DEPRECIATION FACTORY 265.052.05
42 ELECTRICITY FACTORY 1,369.20
43 GUARANTEE CARD 3,031.55
44 INK SOLVENT 320.00
45 LABELLING 563.50
43 PALLET 797.99
46 MASTERBATCH 3,555.00
47 PACKING MATERIAL 2,780.02
49 UPKEEP OF PLANT 12,362.00
50
51 TOTAL DIRECT EXPENSES 289,831.31
52
53 GROSS PROFIT/(LOSS) (6,668,711.58)
54
55 LESS: ADMINISTRATIVE EXPENSES
56 ACCOMODATION 34,473.62
57 ANNUAL DINNER 4,854.22
58 ATTENDANCE ALLOWANCE-ADMIN 4,090.00
59 AUDIT FEE 2,000.00
60 BANK CHARGE 7.889.05
61 BONUS-ADMIN 56,200.00
62 COMMITMENT FEE 503.55
63 CONTAINER ALLOWANCE 13,410.80
64 DEPRECIATION-ADMIN 72,976.72
65 DONATION 200.00
66 ELECTRICITY-WORKER 544.22
67 ENTERTAINMENT 4,922.38
68 EX-GRATIA 5,000.00
69 INCOME TAX-EXPATRIATE 8,340.50
70 INTEREST-HIRE PURCHASE 2,655.36
71 INTERNET 400.00
72 LEGAL FEE 3,197.10
73 LICENCE 30.00
74 MEDICAL 8,227.66
75 NEWSPAPER & MAGAZINE 326.00
76 PETROL ALLOWANCE 3,700.00
77 POSTAGE 240.00
78 PRINTING & STATIONERY 13,988.42
79 RECRUITMENT FEE 2,301.86
80 SALARY-ADMIN 287,896.38
81 SECRETARIAL FEE 400.00
Continued
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment