Monthly Expenses 2023

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 25

Quarterly Revenue

EXPENSES
Year Month Gross Sales
Salary Utilities Supplies Gas Maintenance
2023 Electricity
Jan 55,492.50 18,130.00 8,837.00 3,850.00 12,860.00
1st
9,080.00 690.00
Quarter Feb 32,668.30 14,155.00 8,493.30
Mar 34,385.00 10,100.00 8,649.00 7,300.00
Apr 36,501.69 11,900.00 9,886.94 5,860.00 8,090.00
2nd
Quarter May 35,093.00 12,000.00 10,993.00 8,250.00 3,850.00
Jun 35,180.86 15,600.00 9,050.86 1,080.00 9,450.00
Jul 53,236.79 11,400.00 10,133.79 4,320.00 7,900.00 18,700.00
3rd
10,630.00 330.00
Quarter Aug 36,128.77 16,800.00 8,368.77
Sep 37,436.30 15,600.00 7,556.30 3,780.00 10,500.00
Oct 43,979.81 15,600.00 9,780.21 2,030.00 9,380.00 5,300.00
4th
Quarter Nov 55,523.61 18,000.00 8,873.61 16,300.00 12,350.00
Dec 49,299.34 18,000.00 10,909.34 7,800.00 12,030.00 560.00
Total Expenses NET Income declared to BIR
TAX expense

11,815.50
250
8336
764.75 122,545.80 76,475.00 1%

783.00 106,775.55 78,300.00

1,889.60 126,801.86 62,980.00 3%

1,038.00 148,802.76 34,600.00 3%

252,355.00
Quarterly Revenue
EXPENSES
Year Month Gross Sales
Salary Utilities Supplies Gas Maintenance
2023 Electricity
Jan 52,492.50 15,130.00 8,837.00 3,850.00 12,860.00
1st
9,080.00 690.00
Quarter Feb 32,668.30 14,155.00 8,493.30
Mar 34,385.00 10,100.00 8,649.00 7,300.00
Apr 36,501.69 11,900.00 9,886.94 5,860.00 8,090.00
2nd
Quarter May 35,093.00 12,000.00 10,993.00 8,250.00 3,850.00
Jun 35,180.86 15,600.00 9,050.86 1,080.00 9,450.00
Jul 53,236.79 11,400.00 10,133.79 4,320.00 7,900.00 18,700.00
3rd
10,630.00 330.00
Quarter Aug 36,128.77 16,800.00 8,368.77
Sep 37,436.30 15,600.00 7,556.30 3,780.00 10,500.00
Oct 43,979.81 15,600.00 9,780.21 2,030.00 9,380.00 5,300.00
4th
Quarter Nov 55,523.61 18,000.00 8,873.61 16,300.00 12,350.00
Dec 49,299.34 18,000.00 10,909.34 7,800.00 12,030.00 560.00
Total Expenses NET Income declared to BIR
TAX expense

11,815.50
250
8336
764.75 119,545.80 76,475.00 1%

783.00 106,775.55 78,300.00

1,889.60 126,801.86 62,980.00 3%

1,038.00 148,802.76 34,600.00 3%

252,355.00
Quarterly Revenue
EXPENSES
Year Month Gross Sales
Salary Utilities Supplies Gas Maintenance
2022 Electricity
Jan 48,080.00 24,800.00 7,867.67 5,777.00 13,552.00 1,045.00
1st
4,379.00 13,840.00 475.00
Quarter Feb 60,840.00 22,400.00 7,867.67
Mar 50,235.00 12,000.00 7,729.18 3585 18,483.00 868.00
Apr 31,945.00 18,000.00 8,886.02 12,400.00 12,030.00 2,075.00
2nd
Quarter May 58,885.00 9,000.00 2,830.00 7,800.00
Jun 60,700.00 24,000.00 11,269.46 950.00 18,920.00 510.00
Jul 51,150.00 24,000.00 10,838.24 2,220.00 20,934.00 2,330.00
3rd
3,290.00 18,074.00 450.00
Quarter Aug 53,850.00 18,000.00 10,043.58
Sep 50,034.00 18,000.00 12,732.73 4,500.00 14,650.00 290.00
Oct 42,165.00 18,000.00 11,944.83 10,405.00 9,380.00
4th
Quarter Nov 31,276.00 12,000.00 11,344.11 1,200.00 7,620.00
Dec 19,709.00 9,000.00 9,478.98 1,550.00 5,320.00
Total Expenses NET Income
TAX expense

1,591.55

1,515.30

1,635.84

931.50
Quarterly Revenue
EXPENS
Year Month Gross Sales
Salary Utilities Supplies Gas Maintenance
Electricity
October (24-31) 28,276.00 11,944.83 5,900.00
2022 November 83,725.00 17,900.00 11,344.11 14,463.00
December 74,954.00 18,900.00 9,478.98 14,554.00
January 91,685.00 18,130.00 8,837.37 8,875.00 15,050.00 8,110.00
2023 February 78,090.00 14,155.00 10,085.00 6,550.00 12,560.00 395.00
March 1-20 63,009.00 10,100.00 8,649.75 9,600.00 8,288.00 456.00
EXPENSES Total Expenses
Commision Snacks TMX 125 Permits/Seminar Pag-ibig Monthly Misc

4,852.00
4,852.00 8000
4,852.00 8000
2,845.00 1,090.00 13,852.00 11,815.50 8000 11,927.00 108,531.87
2,875.00 1,140.00 4,852.00 250 8000 1008 61,870.00
1,745.00 860.00 4,852.00 8336 8000 2000 54,237.00
NET Income

(16,846.87)
16,220.00
8,772.00
Expenses Month of JAN

VEHICLES
Suzuki Supremo155 TMX125 Total
GAS 8400 4080 2570 15050
Maintenance 7025 560 525 8110
balance payment 9000
Total 15,425.00 4,640.00 12,095.00
32,160.00

Payroll Cut off 1-15 Cut off 16-31


Kenneth 1800 3060
Marlon 2360 1810
Dodong 1900 1500
Moises 2800 900
Extra 800 1200

Total 9660 8470


18,130.00
Supplies Amount
Umbrella seal 2700
Big mouth seal 1180
Dishwashing soap 1000
Brush 130
Slim Jug 1450
Softener salt 800
Filter 240
Office supplies 1375
Total 8,875.00

Permits Renewal Processing


BFP 500
Tax dec 182
Brgy Clearance 30
Tax order of payment 9632
doc stamp 40
Quarterly tax(oct-dec) 931.5
Yearly registration 500
Total 11,815.50

Bills
Electricity 8,837.37
TMX 125 4,852.00

Others
Snacks 1090
Commissions 2845
Mothly pag ibig 8000
misc 380
Fertilizer 5800
Deisel 3747
Gas Almera 2000
Total 23,862.00

Grand Total 108,531.87

11927
15050
Expenses Month of Feb

VEHICLES
Suzuki Supremo155 TMX125 Total
GAS
Maintenance

Total - - -
-

Payroll Cut off 1-15 Cut off 16-28 Cash advance


Kenneth 1800 1100 200
Marlon 600 1600 1015
Dodong 1375 1000 4000
Moises 3000 2600
Extra 1080

Total 6775 7380


14,155.00
Supplies Amount
Umbrella seal 1500
Big mouth seal 300
Dishwashing soap 400
Brush
Round container 4350
Softener salt
Filter
Office supplies
Total 6,550.00

Permits Renewal Processing


BFP
Notary
Tax dec
Brgy Clearance
Tax order of payment
doc stamp
Quarterly tax(oct-dec)
Yearly registration
Total -

Bills
Electricity 10,084.99
TMX 125 4,852.00

Others
Snacks
Commissions
Mothly pag ibig 8000
misc

Gas Almera 1000


Total 9,000.00

Grand Total 44,641.99


0
Expenses Month of Feb

VEHICLES
Suzuki Supremo155 TMX125 Total
GAS 6922 666 700
Maintenance
balance payment
Total 6,922.00 666.00 700.00
8,288.00

Payroll Cut off 1-15 Cut off 16-28 Cash advance


Kenneth 2100
Marlon 2500
Dodong 2700
Moises 2200
Extra 600

Total 10100 0
10,100.00
Supplies Amount
Umbrella seal 2000
Big mouth seal
Dishwashing soap 1200
Brush
Slim Jug
Softener salt
Filter 4400
UV Sterilizer 2000
Total 9,600.00

Permits Renewal Processing


BFP
Notary 250
Tax dec
Brgy Clearance
Tax order of payment
doc stamp
Quarterly tax(oct-dec)
Yearly registration
Total 250.00

Bills
Electricity 8,649.75
TMX 125 4,852.00

Others
Snacks
Commissions
Mothly pag ibig 8000
misc
Abuloy 2000
Deisel
Gas Almera
Total 10,000.00

Grand Total 51,739.75


8288
Feb
GAS Snack Maintenance commision Supplies extra labor
Multicab Supremo TMX
1 50 350 60
2 80 165
3 200 70 85
4 500 30
5 800 300 100 130
6 500 80 45 60
7 160
8 500 500 300 80 85
9 730 50 170
10 500 70 105
11 300 95 70
12 500 160
13 700 100 195
14 300 70 115
15 500 70 140
16 500 500 50 130
17 100
18 500 60
19 300 150 300 100 195 300
20 500 130
21 100 30 180
22 450 135 200
23 450 300 70 120
24 500 40 35
25 75 180
26 975 20
27 130
28 700 20

Total 9605 1950 1800 1140 395 2875 70 860

13355
extra labor
Mar
GAS Snack Maintenance commision Supplies extra labor
Multicab Supremo TMX
1 140 110
2 100 45 140 1400
3 540 5
4 1000 100 216 55
5
6 60 110
7 638 35 2000
8 1000 105
9 300 200 60 5
10 100 180
11 500 2000
12 150 100 5
13 500 200 75
14 750 50 55 100
15 216 60 185 3000
16 600 35
17 80
18 750 80 210 1200 400
19 144 80 160 200
20 500 300 70 150
21
22
23
24
25
26
27
28

Total 6922 666 700 860 456 1745 9600 600

8288
extra labor
DATE Commission Snack
1/2/2023 150 60
1/3/2023 95
1/4/2023 95
1/5/2023 105 60
1/6/2023 120
1/7/2023 65 130
1/8/2023 130 60
1/9/2023 135
1/10/2023
1/11/2023 135 60
1/12/2023 5
1/13/2023 95
1/14/2023 80
1/15/2023 140 60
1/16/2023 70
1/17/2023 40 80
1/18/2023 20
1/19/2023 40
1/20/2023 130 70
1/21/2023 110 80
1/22/2023 85 80
1/23/2023 270 80
1/24/2023 50
1/25/2023 185
1/26/2023 80
1/27/2023 115
1/28/2023 75
1/29/2023 80
1/30/2023 145 60
1/31/2023 130 80
2845 1090
Jan-23

DATE Multicab T155 T125 Total


1/2/2023 800
1/3/2023 500
1/4/2023 330
1/5/2023 550 70
1/6/2023 400
1/7/2023 400 130
1/8/2023 500
1/9/2023 350
1/10/2023 400 200
1/11/2023 1000
1/12/2023
1/13/2023 300
1/14/2023 870 370
1/15/2023
1/16/2023 300 200
1/17/2023
1/18/2023
1/19/2023 1000 300
1/20/2023 700 200
1/21/2023 300
1/22/2023 300
1/23/2023
1/24/2023 1000 500 300
1/25/2023
1/26/2023
1/27/2023 400
1/28/2023 700 200
1/29/2023
1/30/2023 180
1/31/2023 1000 300
8400 4080 2570
Total 15,050.00
Maintenance
Replcement of
engine
sprocket 100
Labor 50
Clutch cable 150
LAbor 30
Painting 425
100
150
Change oil 300
80
Flat bar 380
GI Pipe 500
2265

You might also like