revenue:
paypal payments (amounts are in dolars)
8/28/2020 paypal 20.03
9/6/2020 paypal 19.97
9/17/2020 paypal 20.05
9/20/2020 paypal 20.01
9/22/2020 paypal 20.02
10/4/2020 paypal 20.02
10/23/2020 paypal 20.02
11/17/2020 paypal 40.20
11/20/2020 paypal 60.31
11/25/2020 paypal 20.16
11/27/2020 paypal 40.31
11/29/2020 paypal 20.15
12/1/2020 paypal 20.15
12/4/2020 paypal 40.37
12/19/2020 paypal 20.18
12/20/2020 paypal 20.18
12/24/2020 paypal 40.36
12/26/2020 paypal 20.15
12/27/2020 paypal 20.15
12/31/2020 paypal 20.19
1/1/2021 paypal 20.19
1/2/2021 paypal 20.18
1/13/2021 paypal 20.19
1/17/2021 paypal 20.20
1/23/2021 paypal 20.18
1/30/2021 paypal 20.18
2/6/2021 paypal 20.17
4/16/2021 paypal 40.10
4/17/2021 paypal 20.05
4/23/2021 paypal 20.07
4/23/2021 paypal 20.04
4/25/2021 paypal 20.09
4/26/2021 paypal 20.09
5/2/2021 paypal 20.09
5/3/2021 paypal 20.09
5/3/2021 paypal 20.09
5/13/2021 paypal 20.26
5/14/2021 paypal 20.26
5/21/2021 paypal 20.25
5/23/2021 paypal 40.48
5/26/2021 paypal 40.37
5/28/2021 paypal 20.28
5/31/2021 paypal 20.34
6/5/2021 paypal 20.32
6/12/2021 paypal 20.31
6/13/2021 paypal 20.30
6/14/2021 paypal 20.30
6/18/2021 paypal 40.30
6/19/2021 paypal 19.99
6/20/2021 paypal 19.99
6/21/2021 paypal 19.93
6/27/2021 paypal 39.97
7/2/2021 paypal 39.42
7/3/2021 paypal 19.70
7/4/2021 paypal 19.70
7/6/2021 paypal 11.81
7/7/2021 paypal 23.36
7/10/2021 paypal 11.64
7/11/2021 paypal 11.65
7/11/2021 paypal 11.65
7/12/2021 paypal 19.30
7/17/2021 paypal 19.20
7/19/2021 paypal 19.20
7/21/2021 paypal 19.29
7/29/2021 paypal 19.23
7/30/2021 paypal 19.37
7/31/2021 paypal 19.40
8/2/2021 paypal 19.40
total: $1,571.95 (P48.5) = P76,242.34
# entered in quicken on 8/6/21
cash payments from guests:
9/19 cash - 1150
10/9 cash - 1000
10/17 to 10/18 cash - 2000
12/21 cash - 1000
5/16 cash - 2000
5/29 cash - 1000
6/3 cash - 1200
6/24 cash - 1000
6/26 cash - 1000
7/19 cash - 1000
7/20 cash - 1000
7/23 cash - 1400
total cash = P14,750
total cash = P14,750
cancellations/refunds because no medical certificate or swimming pool was closed:
?? - 2000
?? - 1000
12/21 - 1000
12/27 - 1150
1/1 - 1000
1/14 - 1000
1/18 - 1000
4/14 - 970
5/2 - 970
7/4 - 400
total refund: P10,490
total refund: P10,490
total cash flow (cash revenue - cash refund) as of 8/6/21 = P4,260
# entered in quicken on 8/6/21
total (cash inflow + paypal) as of 8/6/21 = P80,502.34 (as of 8/2/21)
---------
cancellations/refund (outflows):
8/8/21 refund closed pool - 400
8/19/21 refund - 673
# total as of 12/30/21 = P1,073
paypal inflows:
10/25 to 26 - 776
10/26 to 28 - 1552
10/28 to 30 - 1552
10/30 to 31 - 776
10/31 to 11/1 - 776
11/9 to 12 - 2328
11/12 to 14 - 1552
11/14 to 17 - 3104
11/18 to 22 - 3104
11/24 to 25 - 776
11/25 to 29 - 3104
11/29 to 12/1 - 1552
----------
total: P20,952 + P16k rent = P37k
expense for period: 37,397
paypal inflows:
3/1/23 $11.3 x 55 - 621
3/4/23 $34.46 x 55 - 1895
3/23/23 $42.84 x P54 - 2313
cash inflows:
8/15/21 day extension - 300
8/19/21 - 700
9/1/21 jeffrey hinkle rent for september P18k minus P7k commission to rowena - 11000
# P18k security deposit will be returned to tenant
10/13/21 jeffrey hinkle october rent - 18000
11/3/21 jeffrey hinkle nov rent - 18000
12/3/21 jeffrey hinkle dec rent - 18000
# total as of 12/30/21: P66,000
12/31/21 jeffrey hinkle jan rent - 18000
2/2/22 jeffrey hinkle feb rent - 18000
3/1/22 jeffrey hinkle march rent - 18000
6/14/22 john sahimi 6/15 to 7/15 rent - 15000
7/14/22 john sahimi 7/16 to 8/15 rent - 15000
# entered to quicken on 8/14/22: P150,000 - P1,073 refund = P148,927 (total inflow: P148,927 - P120,408 = P28,519 at 52.5 = $543.22)
8/15/22 john sahimi 8/16 to 9/16 rent - 15000
9/16/22 john sahimi 9/16 to 10/10 rent - 12000
11/7/22 airbnb cash for nov 6 to 9 - 2400
11/9/22 airbnb cash downpayment for jan 11to 16 - 2000
3/5/23 laura beltran for 3/5/23 to 4/5/23 - 15300
3/12/23 referral commission to condo admin evelyn cinco - 5000
4/4/23 laura beltran for 4/5/23 to 5/5/23 plus pro rated share of electric bill - 17695
5/6/23 laura beltran for 5/5/23 to 6/5/23 - 15000
6/10/23 laura beltran for 6/5/23 to 7/5/23 - 15000
7/10/23 laura beltran for 7/5/23 to 8/5/23 - 15000
8/24/23 laura beltran for 8/5/23 to 9/5/23 - 15000
10/9/23 laura beltran - 2000
10/12/23 raphael ygreko minus chairs and curtains expenses - 7000
11/3/23 raphael ygreko minus kitchen repairs - 12000
12/3/23 raphael ygreko minus bathroom repairs - 7500
12/23/23 raphael ygreko - 15000
1/31/24 raphael ygreko - 15000
3/7/24 raphael ygreko - 15000
4/3/24 raphael ygreko - 13100
5/9/24 raphael ygreko - 15000
# entered to quicken on 5/27/24 total inflow = P230,995 - P225,815 = P5,180 / 55 = $94.18
----------
total: P380,995
6/3/24 festus akoto - 15000
7/31/24 festus akoto - 15000
10/10/24 festus akoto - 20000
10/17/24 festus akoto - 10000
12/8/24 festus akoto - 10000
---------
june to december: 6 months X 15k = 90k
total paid: 70k
due: 20k
# total paypal inflow from 8/6/21 to 8/14/22: $804.40 x 50 = P40,220
------------------
P421,215
+
# total paypal inflow from 8/15/22 to 5/24/24: $1,202.87 X 52 = P62,549
(pdf statements from paypal: https://drive.google.com/drive/folders/1tIc6q99IIQbOOOWtL9fh0ZDu9HP8C3bM?usp=drive_link)
# total revenue as of 5/27/24: P483,764 - P1,073 + P80,502 = P565,539 = P565,339
expenses:
* note: the cleaning is P100 per check in and laundry is P100 per check in which will be assessed in the final account. Example, as of 9/22/21 there has been 80 bookings with 10 cancellations for a total of 70 check ins. this means the cleaning and laundry expense is 70 X P200 = P14,000.
5 blankets and 3 bedsheets - 1292
3 towels - 405
water bill for sep - 241
duplicate keys - 300
10/20 condo dues (3465), water, electricity - 5300
11/26 condo dues (3465), water, electricity - 5000
12/22 condo dues (3465), water, electricity - 6200
1/2 new stove - 869
1/21 condo dues (3465), water, electricity - 5200
2/19 condo dues (3465), water, electricity - 4600
3/2/4 condo dues (3465), water electricity - 3677
4/22 condo dues (3465), water electricity - 4228
5/18 condo dues (3465), water electricity - 5833
6/18 condo dues (3465), water electricity - 7324
7/2 duplicate keys - 150
7/15 condo dues (3465), water electricity - 8559
misc expenses from icloud notes (laundry soap, etc ...) - 1028
# entered in quicken on 8/6/21
#total expenses as of 8/6/21 = P66,758
8/23 condo dues (3465), water electricity - 6552
9/1/21 electricity and water - 3221
9/8/21 property tax for 2021 - 7196
9/8/21 tax clearance for ROD requirement - 120
9/22/21 ROD registration fees - 32402
9/28/21 condo dues - 3500
11/3/21 condo dues - 3465
12/3/21 condo dues - 3465
12/3/21 registry of deeds IT service fee for title annotation - 198
12/14/21 veco account deposit - 7495
12/14/21 wena ebao fee for processing veco - 3000
12/31/21 condo dues - 3465
3/1/22 condo dues for jan and feb 4455 x 2 - 8910
4/15/22 condo dues for march - 8107
5/18/22 condo dues for april - 7488
5/31/22 condo dues for may - 4455
5/31/22 water and electricity - 9869
7/15/22 condo dues for may - 7500
# entered to quicken on 8/14/22: P120,408 (total inflow: P148,927 - P120,408 = P28,519 at 52.5 = $543.22)
8/15/22 condo dues for june - 7500
9/16/22 condo dues for july - 7442
10/24/22 condo dues for sep - 7516
10/24/22 property tax 2022 - 7592
11/29/22 condo dues for oct - 7784
11/29/22 condo dues for nov - 8031
airbnb guest refund - 1552
brackets - 215
11/29/22 electric bill for 10/23 to 11/23 - 6474
12/29/22 condo dues for dec - 7974
12/29/22 electric bill for 11/23 to 12/23 - 6407
1/31/23 condo dues for jan - 8202
1/31/23 electric bill for 12/23 to 1/23 - 6684
3/3/23 condo dues for feb - 8078
3/3/23 electric bill for 1/23 to 2/23 - 8539
3/5/23 new tenant request for cleaning products - 1599
3/5/23 new tenant request for cleaning products - 46
3/5/23 new tenant request for cleaning products - 621
3/5/23 new tenant request for cleaning products - 554
3/31/23 condo dues for march - 7946
4/4/23 electric bill for 2/23 to 3/23 - 3973
5/3/23 condo dues for april - 7549
5/6/23 chair - 400
5/6/23 aircon cleaning and declogging of condensate drain - 2000
5/6/23 fix bathroom sink drain leak and toilet flapper leak - 500
5/6/23 induction stove - 2580
5/23/23 condo dues for may - 7500
6/22/23 condo dues for june - 7378
8/4/23 mailed title to nikki - 1227
8/9/23 condo dues for july - 7115
9/2/23 condo dues for aug - 7408
9/29/23 condo dues for sep - 7111
11/3/23 condo dues for oct - 7317
11/30/23 condo dues for nov - 7475
12/30/23 condo dues for dec - 7382
1/31/24 property tax - 8300
2/12/24 condo dues for jan - 7253
3/14/24 condo dues for feb - 7258
4/3/24 condo dues for mar - 7133
5/9/24 condo dues for apr - 8200
# entered to quicken on 5/27/24 total inflow = P230,995 - P225,815 = P5,180
misc expense logged in iphone notes - 6795
refund to airbnb guest, brackets - 1767
# entered to quicken on 5/29/24 expense: P8,562.25 / 55 = $156.68
------------------
# total expenses as of 5/27/24 = P414,991
6/12/24 condo dues for may - 7180
6/24/24 condo dues for june - 7124
7/31/24 condo dues for july - 7259
9/6/24 condo dues for august - 7171
10/9/24 condo dues for september - 8000
11/15/24 condo dues for october - 6550
12/9/24 condo dues for november - 7603
# from 8/28/2020 to 5/27/2024, there were 129 airbnb check-ins X P200 (cleaning and laundry) = P25,800
total income as of 5/27/24: P565,339 - P414,991 = P150,348 - P25,800 = P125,348 / 45 months = P2,785/month