| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||
2 | YOUR COMPANY NAME | |||||||||||||||||
3 | Monthly Profit and Loss Statement | |||||||||||||||||
4 | For the Year Ended MM/DD/YYYY | |||||||||||||||||
5 | ||||||||||||||||||
6 | ||||||||||||||||||
7 | Show Categories | |||||||||||||||||
8 | Revenue | |||||||||||||||||
9 | ||||||||||||||||||
10 | Cost Of Goods Sold | |||||||||||||||||
11 | ||||||||||||||||||
12 | Total Expenses | |||||||||||||||||
13 | ||||||||||||||||||
14 | Net Profit / Loss | |||||||||||||||||
15 | ||||||||||||||||||
16 | ||||||||||||||||||
22 | ||||||||||||||||||
23 | CATEGORY | TREND | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD | |||
24 | REVENUE | ₱87,137.00 | ₱50,964.00 | ₱86,259.00 | ₱79,607.00 | ₱71,341.00 | ₱88,114.00 | ₱59,503.00 | ₱64,060.00 | ₱71,160.00 | ₱60,826.00 | ₱52,063.00 | ₱69,167.00 | ₱840,201.00 | ||||
25 | COST OF GOODS SOLD | ₱33,324.00 | ₱26,542.00 | ₱41,047.00 | ₱29,883.00 | ₱45,828.00 | ₱40,046.00 | ₱38,135.00 | ₱36,655.00 | ₱40,328.00 | ₱32,649.00 | ₱48,086.00 | ₱48,494.00 | ₱461,017.00 | ||||
26 | TOTAL EXPENSES | ₱18,170.00 | ₱17,385.00 | ₱16,587.00 | ₱18,128.00 | ₱18,608.00 | ₱16,934.00 | ₱16,446.00 | ₱17,697.00 | ₱18,155.00 | ₱17,847.00 | ₱17,832.00 | ₱19,582.00 | ₱213,371.00 | ||||
27 | NET PROFIT / LOSS | ₱35,643.00 | ₱7,037.00 | ₱28,625.00 | ₱31,596.00 | ₱6,905.00 | ₱31,134.00 | ₱4,922.00 | ₱9,708.00 | ₱12,677.00 | ₱10,330.00 | -₱13,855.00 | ₱1,091.00 | ₱165,813.00 | ||||
28 | ||||||||||||||||||
29 | REVENUE | TREND | JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | YTD | |||
30 | Sales Revenue | ₱89,297.00 | ₱51,817.00 | ₱85,600.00 | ₱80,295.00 | ₱72,998.00 | ₱87,088.00 | ₱61,207.00 | ₱65,849.00 | ₱71,072.00 | ₱61,317.00 | ₱51,889.00 | ₱66,560.00 | ₱844,989.00 | ||||
31 | Other Revenue | ₱6,857.00 | ₱7,684.00 | ₱8,962.00 | ₱7,541.00 | ₱6,804.00 | ₱7,376.00 | ₱6,711.00 | ₱5,743.00 | ₱6,303.00 | ₱7,988.00 | ₱7,786.00 | ₱9,786.00 | ₱89,541.00 | ||||
32 | Sales Discounts | -₱4,609.00 | -₱4,091.00 | -₱3,785.00 | -₱3,876.00 | -₱4,669.00 | -₱3,339.00 | -₱4,909.00 | -₱3,667.00 | -₱3,013.00 | -₱3,668.00 | -₱4,578.00 | -₱3,476.00 | -₱47,680.00 | ||||
33 | Sales Returns, allowances and others | -₱4,408.00 | -₱4,446.00 | -₱4,518.00 | -₱4,353.00 | -₱3,792.00 | -₱3,011.00 | -₱3,506.00 | -₱3,865.00 | -₱3,202.00 | -₱4,811.00 | -₱3,034.00 | -₱3,703.00 | -₱46,649.00 | ||||
34 | TOTAL | ₱87,137.00 | ₱50,964.00 | ₱86,259.00 | ₱79,607.00 | ₱71,341.00 | ₱88,114.00 | ₱59,503.00 | ₱64,060.00 | ₱71,160.00 | ₱60,826.00 | ₱52,063.00 | ₱69,167.00 | ₱840,201.00 | ||||
35 | ||||||||||||||||||
36 | COST OF GOODS SOLD | TREND | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD | |||
37 | Cost of raw materials | ₱6,719.00 | ₱1,884.00 | ₱7,489.00 | ₱7,037.00 | ₱8,340.00 | ₱8,883.00 | ₱3,176.00 | ₱2,715.00 | ₱7,862.00 | ₱4,710.00 | ₱4,158.00 | ₱9,662.00 | ₱72,635.00 | ||||
38 | Cost of parts used | ₱6,851.00 | ₱6,443.00 | ₱5,265.00 | ₱3,580.00 | ₱7,785.00 | ₱6,300.00 | ₱1,382.00 | ₱9,373.00 | ₱9,652.00 | ₱3,355.00 | ₱2,023.00 | ₱5,143.00 | ₱67,152.00 | ||||
39 | Direct labor costs | ₱3,189.00 | ₱3,753.00 | ₱3,192.00 | ₱1,533.00 | ₱7,499.00 | ₱3,980.00 | ₱7,884.00 | ₱9,727.00 | ₱5,852.00 | ₱6,705.00 | ₱9,774.00 | ₱6,065.00 | ₱69,153.00 | ||||
40 | Overhead costs | ₱3,499.00 | ₱5,245.00 | ₱6,343.00 | ₱5,148.00 | ₱2,413.00 | ₱6,877.00 | ₱7,859.00 | ₱2,460.00 | ₱3,712.00 | ₱7,415.00 | ₱9,736.00 | ₱7,735.00 | ₱68,442.00 | ||||
41 | Inventory Adjustments | ₱2,487.00 | ₱4,367.00 | ₱8,972.00 | ₱3,694.00 | ₱8,480.00 | ₱4,447.00 | ₱8,393.00 | ₱2,514.00 | ₱2,780.00 | ₱4,581.00 | ₱5,776.00 | ₱4,491.00 | ₱60,982.00 | ||||
42 | Freight and Shipping | ₱6,386.00 | ₱1,698.00 | ₱3,679.00 | ₱3,804.00 | ₱8,444.00 | ₱5,668.00 | ₱4,213.00 | ₱5,510.00 | ₱9,444.00 | ₱2,250.00 | ₱6,882.00 | ₱9,579.00 | ₱67,557.00 | ||||
43 | Depreciation | ₱4,193.00 | ₱3,152.00 | ₱6,107.00 | ₱5,087.00 | ₱2,867.00 | ₱3,891.00 | ₱5,228.00 | ₱4,356.00 | ₱1,026.00 | ₱3,633.00 | ₱9,737.00 | ₱5,819.00 | ₱55,096.00 | ||||
44 | TOTAL | ₱33,324.00 | ₱26,542.00 | ₱41,047.00 | ₱29,883.00 | ₱45,828.00 | ₱40,046.00 | ₱38,135.00 | ₱36,655.00 | ₱40,328.00 | ₱32,649.00 | ₱48,086.00 | ₱48,494.00 | ₱461,017.00 | ||||
45 | ||||||||||||||||||
46 | GROSS PROFIT/LOSS | ₱53,813.00 | ₱24,422.00 | ₱45,212.00 | ₱49,724.00 | ₱25,513.00 | ₱48,068.00 | ₱21,368.00 | ₱27,405.00 | ₱30,832.00 | ₱28,177.00 | ₱3,977.00 | ₱20,673.00 | ₱379,184.00 | ||||
47 | ||||||||||||||||||
48 | EXPENSES | TREND | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD | |||
49 | Automobile | ₱1,951.00 | ₱1,114.00 | ₱1,619.00 | ₱1,862.00 | ₱1,027.00 | ₱1,105.00 | ₱1,872.00 | ₱1,167.00 | ₱1,053.00 | ₱1,111.00 | ₱1,335.00 | ₱1,682.00 | ₱16,898.00 | ||||
50 | Rented Equipment | ₱1,227.00 | ₱1,794.00 | ₱1,548.00 | ₱1,796.00 | ₱1,209.00 | ₱1,828.00 | ₱1,390.00 | ₱1,846.00 | ₱1,704.00 | ₱1,900.00 | ₱1,087.00 | ₱1,749.00 | ₱19,078.00 | ||||
51 | Insurance | ₱1,442.00 | ₱1,537.00 | ₱1,238.00 | ₱1,836.00 | ₱1,981.00 | ₱1,219.00 | ₱1,244.00 | ₱1,596.00 | ₱1,270.00 | ₱1,288.00 | ₱1,935.00 | ₱1,975.00 | ₱18,561.00 | ||||
52 | Job expenses | ₱1,157.00 | ₱1,389.00 | ₱1,033.00 | ₱1,177.00 | ₱1,825.00 | ₱1,950.00 | ₱1,252.00 | ₱1,417.00 | ₱1,050.00 | ₱1,585.00 | ₱1,227.00 | ₱1,613.00 | ₱16,675.00 | ||||
53 | Legal and Professional Fees | ₱1,639.00 | ₱1,035.00 | ₱1,408.00 | ₱1,039.00 | ₱1,218.00 | ₱1,472.00 | ₱1,024.00 | ₱1,185.00 | ₱1,743.00 | ₱1,316.00 | ₱1,934.00 | ₱1,893.00 | ₱16,906.00 | ||||
54 | Maintenance and Repair | ₱1,799.00 | ₱1,936.00 | ₱1,118.00 | ₱1,305.00 | ₱1,194.00 | ₱1,519.00 | ₱1,008.00 | ₱1,001.00 | ₱1,919.00 | ₱1,213.00 | ₱1,055.00 | ₱1,896.00 | ₱16,963.00 | ||||
55 | Meals | ₱1,707.00 | ₱1,030.00 | ₱1,654.00 | ₱1,250.00 | ₱1,679.00 | ₱1,181.00 | ₱1,692.00 | ₱1,363.00 | ₱1,722.00 | ₱1,204.00 | ₱1,065.00 | ₱1,953.00 | ₱17,500.00 | ||||
56 | Office Expenses | ₱1,434.00 | ₱1,415.00 | ₱1,240.00 | ₱1,713.00 | ₱1,868.00 | ₱1,309.00 | ₱1,454.00 | ₱1,968.00 | ₱1,989.00 | ₱1,706.00 | ₱1,606.00 | ₱1,129.00 | ₱18,831.00 | ||||
57 | Rent or Lease | ₱1,304.00 | ₱1,915.00 | ₱1,401.00 | ₱1,482.00 | ₱1,465.00 | ₱1,145.00 | ₱1,059.00 | ₱1,900.00 | ₱1,382.00 | ₱1,931.00 | ₱1,961.00 | ₱1,556.00 | ₱18,501.00 | ||||
58 | Utilities | ₱1,393.00 | ₱1,014.00 | ₱1,563.00 | ₱1,551.00 | ₱1,882.00 | ₱1,385.00 | ₱1,264.00 | ₱1,028.00 | ₱1,120.00 | ₱1,271.00 | ₱1,677.00 | ₱1,339.00 | ₱16,487.00 | ||||
59 | Vehicle Expenses | ₱1,655.00 | ₱1,583.00 | ₱1,635.00 | ₱1,721.00 | ₱1,439.00 | ₱1,808.00 | ₱1,228.00 | ₱1,337.00 | ₱1,379.00 | ₱1,725.00 | ₱1,057.00 | ₱1,707.00 | ₱18,274.00 | ||||
60 | Miscellaneous Expenses | ₱1,462.00 | ₱1,623.00 | ₱1,130.00 | ₱1,396.00 | ₱1,821.00 | ₱1,013.00 | ₱1,959.00 | ₱1,889.00 | ₱1,824.00 | ₱1,597.00 | ₱1,893.00 | ₱1,090.00 | ₱18,697.00 | ||||
61 | TOTAL | ₱18,170.00 | ₱17,385.00 | ₱16,587.00 | ₱18,128.00 | ₱18,608.00 | ₱16,934.00 | ₱16,446.00 | ₱17,697.00 | ₱18,155.00 | ₱17,847.00 | ₱17,832.00 | ₱19,582.00 | ₱213,371.00 | ||||
62 | ||||||||||||||||||
63 | NET PROFIT/LOSS | ₱35,643.00 | ₱7,037.00 | ₱28,625.00 | ₱31,596.00 | ₱6,905.00 | ₱31,134.00 | ₱4,922.00 | ₱9,708.00 | ₱12,677.00 | ₱10,330.00 | -₱13,855.00 | ₱1,091.00 | ₱165,813.00 | ||||
64 | ||||||||||||||||||