security bank account and dollar deposit

* for efficiency, i will just log here the landmark rental payments but won't actually do the deposit until mama and papa gets back

# i received the following:

from rex - 10000
7/1/19 landmark rent  (paid on 8/2/19) - 15000
7/15/19  (paid on 9/16/19) - 15000
8/1/19 (paid on 9/16/19 - 150002
# entered in quicken on 9/26 (P55k-P33,302k=P21,698 payable)
8/15/19 (paid on 10/16/19) - 15000
9/1/19 (paid on 10/16/19) - 15000
9/15/19 (paid on 11/18/19) - 15000
10/1/19 (paid on 11/18/19) - 15000
10/15/19 (paid on 12/17/19) - 15000
11/1/19 (paid on 12/17/19) - 15000
11/15/19  (paid on 1/16/20) - 15000
12/1/19 (paid on 1/16/20) - 15000
12/15/19 (paid on 2/18/20) - 15000
1/1/20 (paid on 2/18/20) - 15000
1/15/20 (paid on 3/17/20) - 15000
2/1/20 (paid on 3/17/20) - 15000
2/15/20 (paid on 4/17/20) - 15000
3/1/20 (paid on 4/17/20) - 15000
3/15/20 (paid on 5/18/20) - 15000
4/1/20 (paid on 5/18/20) - 15000
#entered in quicken 7/15/20 P240k - P84,018=P155,982

4/15/20 (paid on 7/17/20) - 15000

5/1/20 (paid on 7/17/20) - 15000

5/15/20 (paid on 8/18/20) - 15000

6/1/20 (paid on 8/18/20) - 15000

6/15/20 (paid on 9/17/20) - 15000

7/1/20  (paid on 9/17/20) - 15000

7/15/20 (paid on 10/16/20) - 15000

8/1/20 (paid on 10/16/20) - 15000

8/15/20 (paid on  11/4/20) - 15000

9/1/20 (paid on 11/17/20) - 15000

9/15/20 (paid on 11/19/20) - 15000

10/1/20 (paid on 11/19/20) - 15000

10/15/20 (paid 11/23/20) - 15000

# 30k deposit used to pay last month

11/1/20 (use deposit) - 0

11/30/20 (use deposit) - 0

7/15/21 cash envelope from tikay  P30,820 minus P18,863.44 (pie barn) - 11956

#entered in quicken 8/6/21 P206,956 minus P226,114 = -P19,158 dollar @49 = -$333

9/16/21 from unitop - 30457

9/22/21 from unitop - 30457

# 11/15/21 cashed out unitop 30457 but gave 10k to mama in st. marks and will give the rest after their quarantine

# entered in quick 8/14/22: P60,914 - P87,290 = - P26,316 / 53.77 = -$489.42

--------------------------
sub total: P562,870

minus:

# i gave the following:
papa travel money 6/11/19 - 5000

z3 service call - 2800

z3 key - 25502
# entered in quicken on 9/26 (P55k-P33,302k=P21,698 payable)
landmark tax (w/ 15% discount through dec 31) - 9486
maintenance fund: P625 X 12 months - 7500
insurance: 336 X 12 - 4032
errand fee and transpo cost for fe - 1000
papa  car home repair 12/10/19 - 5000

papa car home repair 1/15/20 - 10000

chibong 5/27/20 - 5000

jaski z3 - 25000

z3 clutch, startup repair attempt - 17000

#entered in quicken 7/15/20 P240k - P84,018=P155,982

to gikom - 10000

dhl landers quit claim - 1889

compound drain cleaning contribution - 845

10/19 2 large trash bins for compound - 700

(US bank transfer, do not include in cash entry to quicken) 11/11 $500 transfer to mama - 24500

12/9/20 landmark property tax and suhol ni fe - 11000

12/25/20 10k each for chibong rex and gikom - 30000

2/8/21 landmark dues for december january and febuary - 18584

3/28/21 earl kokseng babag expenses - 78457

4/8/21 donation to tiya ica's funeral - 5000

(paypal transaction, do not include in cash entry to quicken) 4/30/21 st marks hotel - 2852

5/17/21 landmark  assoc dues and misc 3 months - 17622

5/17/21 fe commission for landmark 37k minus 10k deposit - 27000

5/21/21 LBC lease contract - 165

6/6/21 tita doris fare/lodging and fees to tanod for aloguinsan to talk to agnes - 2000

7/14/21 chibong swabtest - 5000

7/15/21 andy bong suzara abuloy for lola conching - 5000

7/20/21 donation to tiya rosa family - 10000

# the P330,000 was broken into 2 transfers, $3,500 and $3,100 because the daily transfer limit of bank of america is $4,000

(US bank transfer, do not include in cash entry to quicken) 7/22/21 refund bowie down payment on tita angie property $3,500 - 175000

#entered in quicken 8/6/21 P206,956 minus P223,262 = -P16,306 dollar @49 = -$333

(US bank transfer, do not include in cash entry to quicken) 7/26/21 refund bowie down payment on tita angie property $3,100 - 155000

8/10/21 landmark condo dues 3 months jun jul aug - 17622

8/17/21 flowers for felix abella - 3500

9/8/21 for mr. montano - 5000

9/22/21 landmark condo dues for sep - 6181

(US bank transfer, do not include in cash entry to quicken)  9/27/21 transferred 1k to mia acct - 50000

9/28/21 z3 registration - 21500

10/6/21 assistance for mama's classmate vilma monteclaro - 5000

10/13/21 landmark condo dues for oct - 6181

(US bank transfer, do not include in cash entry to quicken)  10/14/21 transferred $3k to mia acct - 150000

(US bank transfer, do not include in cash entry to quicken)  10/21/21 transferred $500 to mia acct - 25000

10/28/21 landmark property tax P9,486 + P1k for fe expenses and suhol - 10486

11/9/21 (paypal payment, do not include in cash entry to quicken) st marks $198 - 9900

11/14/21 food to st mark - 1220

11/15/21 fruits - 350

11/16/21 fruits - 350

# entered in quick 8/14/22: P60,914 - P87,290 = - P26,316 / 53.77 = -$489.42

---------------------

sub total: P1,010,224

--------------
total: P447,354 payable to ian

#bank balance 6/11/19 - 40072

# + interest (P312) + 4 months landmark rent (P37k X 4) - P10k fe commission + 5 months unitop (P30,457 X 5)

#bank balance: 7/15/21 - 330669

# + 87.95 interest + landmark rent 37k x 5 (july, aug, sep, oct, nov)

bank balance 11/19/21 - 515757

minus P447,354 for ian

-------------------

total remaining of security bank acct: P68,403

P200k check distribution:

30k to papa car home repair (12/21/21) - 30000

150k (xmas) - 150000

5k panday gikom's roast shack (1/15/22) - 5000

9k gikom's roast shack repair (1/17/22) - 9000

5k 1/18/22 - 5000

1k to ian for balancing 1/18/22 - 1000

total: P200k

+ P857,446 from pelaez sale

minus:

from colon estate account P200k xmas checks - 200000

----------------------

P657,446

to papa car home repair 2/3/22 - 60000

to papa car home repair 2/11/22 - 1326

to papacar home repair  3/7/22 - 1275

to papa car home repair 3/23/22 - 20000

gikom's campaign - 10000

to papa car home repair 4/9/22 - 20000

to papa car home repair 4/28/22 - 1000

to papa  car home repair5/9/22 - 20000

tsa lock 5/10/22 - 530

gikom - 60000

# 8/14/22 entered in quicken P194,131 / 52.5 = $3,697.73

to papa car home repair10/30/22 - 15000

to papa car home repair 11/22/22 - 3000

to papa car home repair 11/29/22 - 30000

to papa car home repair 2/19/23 - 20700

to papa car home repair 2/22/23 - 1000

to papa car home repair 2/22/23 - 15000

to papa car home repair 3/2/23 - 30000

loan to gikom 4/28/23 - 70000

z3 suspension 4/28/23 - 43165

z3 tire and suspension alignment 4/28/23 - 5800

z3 smoke test - 500

z3 registration - 18460

z3 brake cleaning and lubrication - 4508

bday gift to charlie - 500

alin 7/2/23 - 2000

alin 7/4/23 - 2000

alin 7/8/23 - 1000

7/18/23 50% of capital gains tax for partitioning of compound lot - 334122

7/28/23 to dance choreographer - 3000

7/29/23 z3 50% down for clutch lining and pressure plate - 60000

8/14/23 property tax compound lot needed for titling - 45000

8/18/23 for gene jenisan wake - 5000

8/26/23 z3 rest of payment for clutch lining and pressure plane - 62255

8/31/23 z3 2 tires and donut reserve down payment - 21000

9/5/23 rest of payment for 2 z3 tires and donut reserve - 6348

9/19/23 via gcash for tuition of daughter of stc video editor - 7500

9/19/23 donate lechon to tiyo eloy celebration - 7500

10/14/23 gikom bday gift - 5000

11/8/23 to victoria patino - 7500

12/20/23 lahug property tax - 80367

12/21/23 rex - 20000

12/28/23 lechon for reunion - 10500

1/10/24 papa car home repair - 15000

1/19/24 reissuance of compound house title - 55000

1/29/24 papa car home repair - 15000

1/30/24 z3 parts - 23150

2/15/24 papa car home repair - 15000

3/1/24 papa - 20000

3/18/24 papa car home repair - 15000

3/28/24 atty earla lahug pagibig case - 80000

4/1/24 papa car home repair - 20000

4/3/24 joeffrey - 500

4/10/24 papa car home repair - 2000

4/14/24 papa car home repair - 20000

4/30/24 papa car home repair - 20000

5/7/24 chibong lawyer' fee - 100000

5/20/24 papa car home repair - 20000

5/21/24 mama - 5000

5/28/24 papa and mama - 50000

5/29/24 agnes - 3000

# entered in quicken 5/29/24 P1,431,375 / 55 = $26,025

----------------

total: P1,625,506 ($3,697.73 + $26,025) = $29,722.73

P657,446 - P1,625,506 = -P968,060 (negative)

- gikom 50k (8/8/2021) already in quicken

- $10,090.77 (papa versatelle use) X 55 = P554,992.35

---------------

debt to ian: P1,573,052 plus:

minus:

withdrew P200k from security bank due to estate tax shortfall - 200000

9/1 withdrew P100k from security bank due to estate tax shortfall - 100000

9/13 withdrew P16k (P100k - P84k to rex) - 16000

9/22 withdrew P70k - 70000

10/8 withdrew P40k - 40000

10/14 withdrew P30k - 30000

plus:

12/10/10: +$1,850 * 43 = 79,550 (papa's 2 plane tickets)

12/11/10: +P57,000 (opening of corporate account)

12/23/10: +P26,100 (christmas distribution)

01/03/11: +P30,000 (retitling paid to Atty. Ena Ybanez)

04/12/11: +$3800 * 43 = 163,400 (mama's tax)

06/27/11: +$2000 * 43 = 86,000 (papa and mama plane ticket and misc transfer to bowie acct)

10/20/11: -$1000 * 43 = 43,000 (mama's deposit)

-------------------

sub total: P399,050

total debt to ian as of 5/29/24: P1,972,102 + additional expenses after 5/29/24 

# did not include the P50k mama borrowed because i withdrew P50k from the security bank account

6/4/24 papa 16gb usb - 500

6/7/24 landmark taxes - 18000

6/7/24 papa car home repair - 3000

6/13/24 susan corporation application - 18600

6/27/24 3 ctc mambaling row - 4000

6/27/24 chibong atty earla psychiatrist - 35000

6/27/24 z3 emission test - 800

6/28/24 z3 registration - 12465

7/17/24 agnes tuition - 3000

8/8/24 alin angel operation - 5000

8/31/24 gian tuition - 4015

9/26/24 talisay rpt - 22443

9/27/24 rpt for andres and guadalupe - 31167

10/9/24 gian tuition - 3000

10/22/24 atty balili appearance fee compound title re-issuance - 10911

10/31/24 melvin cimafranca assistance - 5000

11/19/24 gian tuition - 4015

11/29/24 papa car home repair - 20000

12/7/24 papa car home repair - 20000

12/25/24 gian tuition - 4015

1/15/25 papa honda civic - 20000

1/24/25 geely ROD registration - 1002

1/27/25 papa - 2000

1/29/25 gian tuition - 4015

geely reg - 200

geely reg - 110

papa car home repair 2/24 - 3000

papa car home repair 3/2 - 10000

papa civic repair - 20000

cert no holdings - 240

3/9/25 gian tuition - 4015

3/14/25 papa - 5000

3/29/25 gian tuition - 4015

3/30/25 papa - 3000

3/31/ papa - 10000

4/3/25 papa - 2000

4/3/25 papa - 10000

4/3/25 maldo - 1000

4/5/25 talisay caretaker - 500

# the following is excluded because i withdraw P364,025 from security bank to cover the settlement with the crystal estate 

# 4/5/25 settlement with crystal estate - 364025

4/5/25 notarial fee for crystal estate settlement - 30000

4/7/25 lbc authority to sell - 150

4/7/25 authority to sell notarial - 500

4/26/25 charlie tuition - 6000

4/27/25 magbanua funeral donation - 5000

4/28/25 mama - 10000

4/28/25 SPA notary - 2000

4/30/25 susan - 5000

4/30/25 gian tuition - 4000

5/10/25 susan - 5000

gian - 1000

charlies tuition - 7000

gian - 4015

6/24/25 xray for health card - 240

6/25/25 charlie tutition - 14000

7/4/25 z3 towing - 3800

7/7/25 charlie tuition - 2000

7/16/25 branch 14 court insider verify estate division plan was submitted - 1500

7/18 susan business permit - 2000

8/20 charlie tuition - 6000

9/10 mactan transfer docs for atty tan - 1728

9/15/charlie tuition - 7000

9/20 gian tuition - 4015

10/4 business permit - 700

10/8 charlie tuition - 7000

10/8 wreath for neda co-worker - 5500

10/25/25 gian tuition - 4015

11/6/25 agnes - 1500

11/18/25 z3 replace starter fix ac - 23745

11/21/25  z3 smoke test - 550

11/29/25 papa car home repair - 20000

12/5/25 z3 registration - 12460

12/16/25 papa  car home repair - 15000

12/20/25 umay - 7000

12/20/25 papa  car home repair - 5000

12/24/25 papa car home repair - 15000

01/05/26 gian - 1000

01/05/26 z3 mechanic - 2650

1/6/26 papa car home repair - 5000

1/9/26 mama - 5000

1/13/26 umay - 7000

1/13/26 papa - 15000

1/14/26 banata publish extrajudicial - 690

1/15/26 talisay prop tax - 3854

1/16/26 delia dar official late checkout - 500

1/20/26 papa z3 repair - 2000

2/1/26 papa car home repair - 15000

2/12/26 umay - 7000

2/17/26 ed kintanar and apin - 15000

2/19/26 valderama bohol carp cancellation - 51000

3/12/26 umay - 7000

3/16/26 tita angie - 5000

3/16/26 mama - 5000

3/26/26 notary and lawyer fee spa and contract talisay lot sale - 700

4/1/26 tax decs - 400

4/7 umay -  7000

4/6 mama - 10000

4/3papa - 20000

4/5 talusay transfer rax lola to mama - 17382

4/6 edgar kintanar n mama - 1500000

4/10 papa -  100000

4/16 - 4 spas - 2250

4/17 maldo - 5000

4/20 agnes - 500

4/23 geely service - 7300

4/29 gian - 13000

5/13 talisay rod transfer fee - 22700

5/20 alyn - 2000

5/23 z3 headlight relay - 400

5/25 z3 smoke test - 500

5/26 fe landmark rpt - 31740

5/30  z3 registration - 10160

6/2 gian - 3000

6/2 umay - 7000

6/2 fe jamco - 781

6/10 atty balili guada house titling - 2233

6/22 change oil z3 - 4170

6/28/26 papa load - 1000

---------------

total:  2,481,356

dollar depost:

* do not log in quicken. just deduct the balance from the balance that will be included in the computation for food&groc cash

#dec 2021 in bdo dollar $13,352

minus:

P40k z3 + P5k tiya lydia + 3.7k revo change oil - 947

z3 battery (P8k/51=$157) - 157

z3 repair 3/25/22 (P127,000/51) - 2490

z3 oil filter (P1,177/51)  - 23

z3 change oil  (P2,795/51) - 55

P50k to DAR officer for bohol lot - 980

z3 clutch master P29,352/51 - 575

tip to z3 mechanic P1k/51 - 20

z3 aircon freon refill P2k - 39

3/31/22 mikah exam fee COD - 265

4/22/22 mama P20k - 392

5/10/22 to mama - 1400

5/11/22 to chibong - 400

5/25/22 z3 aircon evaporator repair pressure switch P17,987/51 - 353

5/26/22 compound drain unclock P600/51 - 12

5/31/22 z3 front brake pads P6,149/51 - 121

# entered to quicken 8/14/22

9/21/22 43 inch tv 14999/57 - 263

11/12/22 z3 repaint 20000/57 - 351

12/8/22 50k to mama 10k to papa 60k/55 - 1090

12/20/22 P20k/55 to papa - 363

2/21/23 plane ticket - 1431

3/10/23 P25k/54 to papa for bohol recovery expense - 463

3/14/23 P20k/54 to papa for pocket money travel - 370

3/15/23 P500/54 to agnes - 9

4/24/23 P5k/55 to chibong - 91

---------

$692

total debt to ian: 

P1,972,102 (as of 5/29/24) + P712,840 (5/30/24 to 2/19/26 expenses) + P1,786,216 (2/20/26 to 6/29/26 expenses) + P4,394,522 (lola laling's estate taxes) + P739,348.8 (papa's bank of america debits excluding the auto store and home improvement stores such as autozone, home depot and lowes assuming they were spent for my mazda5 and la quinta house = $12,322.48 dollars x P60 pesos)

-----------------

sub total: P9,605,828.8

minus

P40,8282 (remaining of dollar deposit $1=P59)

P252,000 (since the current tenant started renting on june 2023, there have been 21 deposits of $1,500. monthly mortgage is $1,341.83, papa gets $200. so 21 x  $200 dollars x P60 pesos = P252,000)

------------

sub total: P660,282

total: P8,944,746.8

minus deposit from talisay sale: P5,000,000

GRAND TOTAL PAYABLE TO IAN: P3,944,746.8

-------------------------------- notes and details ------------------------

* i did not include the following latest expenses because i withdrew it from the security bank account:

property tax landmark - P30,020.40

fe errands fee - P2,500

paid the landmark taxes through december for discount - P7,951.5

landmark condo dues - P13,211.14

gian tuition - P3,000

umay salary - P7,000

---------------

total withdrawn from security bank: P63,683

then i withdrew another P50,000 for apin toledo titling of lot 4127

* the details of the final accounting of lola laling's estate is in: https://ian.mywikis.wiki/wiki/LalingYogi#estate_taxes_final_accounting . here are the totals:

new expenses from last report: P19,927 (new expenses) / 4 = P4,981 for all 4 siblings so total mama payable is P2,095,336 + P4,981 = P2,100,317, while other 3 siblings payable is P795,004 + P4,981= P799,985. 

tita tess paid me P105,985 so her balance is P799,985 - P105,750 = P694,23

taxes and expenses that tita tess paid:

   - P24,750 for lola's business closure

   - P262,626 for bohol penalties:

   total: P287,376 / 4 = P71,844 mama, tita christine, and tito yogin needs to pay tita tess this amount)

* details of papa's bank of america debits excluding the auto store and home improvement stores such as autozone, home depot and lowes assuming they were spent for my mazda5 and la quinta house:

BKOFAMERICA ATM 07/08 #000009390 WITHDRWL POINT HAPPY        LA QUINTA     CA -20.00

BKOFAMERICA ATM 07/08 #000009400 WITHDRWL POINT HAPPY        LA QUINTA     CA -200.00

CHECKCARD  0714 VCN*WISCONSINVITALSSF 8662551857 WI 24445004197000882345885 -10.00

BKOFAMERICA ATM 07/18 #000002418 WITHDRWL POINT HAPPY        LA QUINTA     CA -300.00

BKOFAMERICA ATM 07/23 #000003325 WITHDRWL POINT HAPPY        LA QUINTA     CA -1000.00

07/16/24 CHENG DOU HENG T DES:IAT PAYPAL ID:1035668801610  -47.99

CHECKCARD  0724 CIRCLE K 00564 THOUSAND PALM    CA -93.74

BKOFAMERICA ATM 08/02 #000005905 WITHDRWL POINT HAPPY        LA QUINTA     CA -300.00

BKOFAMERICA ATM 08/05 #000006638 WITHDRWL POINT HAPPY        LA QUINTA     CA -100.00

09/03/2024  BKOFAMERICA ATM 08/31 #XXXXX7667 WITHDRWL DESERT GATEWAY PALM DESERT CA      -100.00

09/06/2024  BKOFAMERICA ATM 09/06 #XXXXX5742 WITHDRWL DESERT GATEWAY PALM DESERT CA      -300.00 

09/23/2024  BKOFAMERICA ATM 09/23 #XXXXX8164 WITHDRWL DESERT GATEWAY PALM DESERT CA      -300.00 

10/08/2024  BKOFAMERICA ATM 10/08 #XXXXX5711 WITHDRWL DESERT GATEWAY PALM DESERT CA      -300.00

11/15/2024  BKOFAMERICA ATM 11/15 #XXXXX5274 WITHDRWL DESERT GATEWAY PALM DESERT CA      -700.00 

11/18/2024  RO HEALTH 11/16 PURCHASE WWW.GETROMAN. NY                                    -114.00

11/25/2024  BKOFAMERICA ATM 11/25 #XXXXX2524 WITHDRWL DESERT GATEWAY PALM DESERT CA      -400.00

02/19/2025  RO HEALTH 02/18 PURCHASE WWW.GETROMAN. NY                                    -129.00

05/07/2025  Acrisure Arena 05/05 PURCHASE Palm Desert CA                                   -3.77      

05/07/2025  Acrisure Arena 05/06 PURCHASE Palm Desert CA                                   -5.39     

05/09/2025  PNP BILLPAYMENT DES:050725EK ID:XXXXX74998858 INDN:IAN CHRYSOSTOMO CRYSTA CO ID:XXXXX08324 PPD   -1071.26

05/16/2025  CIRCLE K 00564 05/16 PURCHASE THOUSAND PALM CA                                 -1.83     

05/16/2025  CIRCLE K 00564 05/16 PURCHASE THOUSAND PALM CA                                 -0.26    

05/22/2025  RO HEALTH 05/21 PURCHASE GETROMAN.COM NY                                     -129.00

05/30/2025  BKOFAMERICA ATM 05/30 #XXXXX7134 WITHDRWL DESERT GATEWAY PALM DESERT CA      -400.00 

06/13/2025  1000 PALMS GAS 06/13 PURCHASE THOUSAND PALM CA                                -74.00

06/18/2025  ACRISURE ARENA 06/16 PURCHASE THOUSAND PALM CA                                -15.00

07/02/2025  1000 PALMS GAS 07/02 PURCHASE THOUSAND PALM CA                                -50.00

07/07/2025  Acrisure Arena 07/03 PURCHASE Palm Desert CA                                   -3.77

07/09/2025  BKOFAMERICA ATM 07/09 #XXXXX6633 WITHDRWL DESERT GATEWAY PALM DESERT CA      -500.00   

07/10/2025  1000 PALMS GAS 07/10 PURCHASE THOUSAND PALM CA                                -30.07  

07/22/2025  1000 PALMS GAS 07/22 PURCHASE THOUSAND PALM CA                                -30.03      

07/22/2025  BKOFAMERICA ATM 07/22 #XXXXX4830 WITHDRWL DESERT GATEWAY PALM DESERT CA      -300.00   

07/25/2025  1000 PALMS GAS 07/25 PURCHASE THOUSAND PALM CA                                -50.03      

07/31/2025  BKOFAMERICA ATM 07/31 #XXXXX2021 WITHDRWL DESERT GATEWAY PALM DESERT CA      -500.00 

08/07/2025  PERMUTH AUTOCA 08/07 PURCHASE CATHEDRAL CIT CA                               -839.76

08/11/2025  BKOFAMERICA ATM 08/11 #XXXXX8409 WITHDRWL DESERT GATEWAY PALM DESERT CA      -500.00 

08/18/2025  AARON D ADAME 08/18 PURCHASE LA QUINTA CA                                    -213.00

08/21/2025  RO HEALTH 08/20 PURCHASE GETROMAN.COM NY                                     -129.00

08/29/2025  1000 PALMS GAS 08/29 PURCHASE THOUSAND PALM CA                                -20.10

09/02/2025  AARON D ADAME 09/01 PURCHASE LA QUINTA CA                                    -214.00

09/08/2025  BKOFAMERICA ATM 09/08 #XXXXX7806 WITHDRWL DATE PALM AND RAMO CATHEDRAL CIT CA     -500.00 

09/12/2025  BKOFAMERICA ATM 09/12 #XXXXX4684 WITHDRWL DATE PALM & RAMON CATHEDRAL CIT CA     -300.00

04/20/2026 BKOFAMERICA BC 04/18 #XXXXX5504 WITHDRWL 69135 Ramon Rd ST Cathedral Cit CA -300.00

05/05/2026 WM SUPERCENTER 05/05 PURCHASE PALM DESERT CA -13.84

05/05/2026 1000 PALMS GAS 05/05 PURCHASE THOUSAND PALM CA -127.34

05/05/2026 BKOFAMERICA ATM 05/05 #XXXXX1774 WITHDRWL DESERT GATEWAY PALM DESERT CA -300.00

05/08/2026 BKOFAMERICA BC 05/08 #XXXXX2416 WITHDRWL 78-400 Highway 11 La Quinta CA -700.00

05/13/2026 1000 PALMS GAS 05/13 PURCHASE THOUSAND PALM CA -134.29

06/08/2026 BKOFAMERICA ATM 06/08 #XXXXX5051 WITHDRWL DATE PALM & RAMON CATHEDRAL CIT CA -300.00

BANK OF AMERICA ATM 06/27 #XXXXX0003871 WITHDRWL DATE PALM & RAMON CATHEDRAL CIT CA -200.00

----------------------------

TOTAL: $12,322.48

lahug repairs

table of contents arranged according to priority. the objective is to put a competency mirror in front of our faces and judge if we should take big risks in business or construction projects.

I. electrical
II. roof
III. organizing
IV. self service laundry
V. plumbing
VI. termites
VII. cockroaches and rats
VIII. paint
IX. airbnb option
X. terrace
XI. landscaping and gardening
XII. guadalupe repairs
XIII. bathroom floor drain
XIV. expenses

---------------------------

I. electrical

a week after mama and papa left for the states, there were intermittent electrical sparks and bursting sounds in the kisame (ceiling) of the terrace. it was difficult to pinpoint which wire was causing it because it only happened about 3 times a day. i turned off the breaker switch for the terrace but it still kept happening. the current would fluctuate when it happens so at least i knew when it happened even if i'm in my room. i removed the kisame boards around the area where it happened. i looked for some burnt wires but couldn't find it. i then asked one of my helpers to stand bye so that when it happens we will know the exact location. after a few hours it sparked again and it turns out it was the wire of the fluorescent light near the tool cabinet.

it's important to know what caused it so it won't happen again and the house won't burn down. my suspicion is maybe a rat chewed on the wire. maybe it got pinned down between the beams and it got stepped on while someone was fixing the roof. but from the looks of it, it looks as if the insulation deteriorated because of the water leak and it got shorted. it's also too much of a coincidence it only happened where there was a water leak. i googled it and found out that water does cause the rubber insulation to deteriorate.

so that next time this happens again we can just turn off the problem circuit and we can continue to use the aircon of other circuits, i spent a half a day properly labeling each circuit of the service panel. it astounds me that after all this time no one bothered to label the service panel. our habit of ignoring these details is the reason why we can never grow or flourish a business. it's scary to think that a small business is much simpler than managing big building projects and we keep on thinking of developing such projects. maybe we are destined to commit the same mistakes as our elders (lola dida). so it's up to you guys. the decision is yours. i'm just giving you some important factors to consider. it's better if we play the market. diversify as much as possible geographically and across asset classes. wait for a market crash or recession then buy distressed assets and sell some when it recovers.

instead of working for your money, you can let your money work for you and go jet skiing with your grand kids. the biggest problem in america right now is job loss due to automation. mama has experienced this herself when her tanscription job was lost due to automation. call center is one of the few remaining industries that AI hasn't caught up yet. so it's very possible for america to stop outsourcing it's call centers. when this happens the unitop share can easily go from P30 million to P15 million. that's 5 avida studio condos. but if we diversify buy buying 2 rental houses in america and a recession happens in the philippines, we can smile while others are crying. mama can gladly call rex and ask rex to buy 5 avida or riala condos or 3 townhouses very cheap.

the outlets and the shower heaters of the 3 north rooms (master, ian, twins) share the same 30 amp circuit (#2).  a shower heater is about 20 amps. so if 2 shower heaters are used at the same time the breaker will trip. note that an led tv, electric fan and lamp shade are only about  0.1 amps each so they are not a factor. each shower heater should have it's own separate line. the good news is it's not that hard to run a new line from the panel to the shower heaters because the kisame is wood and there is enough space to move around the attic unlike landmark which was just 1 foot solid cement walls and ceilings all around.

8/26 update:

i mapped all the switches and outlets in lahug and posted it near the breaker panel. i also posted it on our wiki so anyone can edit/print/re-post it (https://reyondit.blogspot.com/2019/08/breaker-panel-map.html).

mama asked how we can tell the electric consumption based on the breaker mapping. here was my reply:

you don't need to map the breaker panel to estimate your electric consumption. you just need to list all your appliances,estimate the hours of operation per day, multiply with the wattage (it's labeled on the product or you can google it), divide by 1000 to get the kilowatt-hour (kwh), then multiply the veco rate which is around P12.04. the importance with mapping the breaker panel is: 1) you know if it is ok to add an appliance. example, i can't just plug a 45 inch tv and speakers in the outlet behind the piano because currently it is already overloaded if all bathrooms have a shower heater. as you can see in the breaker mapping document, the capacity is 6,600 watts. each shower heater is 3,500 watts. so the breaker will trip if all 3 shower heaters are on at the same time. the 45 inch tv is just around 80 watts but you don't want the tv to suddenly shut off in the middle of watching a show because 3 people are taking a shower at the same time. because of the mapping document, i can easily know which breaker switch i can assign the entertainment system to. breaker #13 would be the best candidate so i just need to transfer the outlet from the dining area to the wall behind the piano. breaker #14 also looks like a good candidate because a .6 hp aircon is just 500 watts and the capacity is 6,500 watts. however, the aircon surge might ruin the sensitive electronics of the entertainment system so i thought it's best to separate them. 2) the second importance for the breaker map is that when there is a problem you immediately know which breaker to switch off without having to turn off the entire house. example after you left for the states there was a wire in the terrace kisame that was sparking and popping intermittently. 3) it is also easier to test the real usage of an appliance. example, i switched off all the breaker switches except the aircon in the sala the recorded the before and after reading of the electric meter to know that the aircon in the sala will cost P12 an hour to run.

update 9/30/19:

all the electrical and energy conservation work is completed. the outlet behind the piano shares a line with the outlets in the 4 rooms and sala including the 3 shower heater outlets so it would be a bad idea to plug a 50" tv. good thing the 2 outlets in the dining area each had their own line so i moved one behind the piano and the other in the middle room for the aircon.

i was fortunate to find a surplus jalousie frame while going around the glass-aluminum shops which they sold to me for only P100 so i fixed the missing jalousie clips in the middle room. i also implemented congresswoman and future US president alexendria ocasio cortez' green new deal in the lahug house by weatherizing all the jalousies with clear tape. now it only takes about a minute for the master bedroom to cool when you turn on the aircon. this should lower the cost on electricity. the clear tape may deteriorate after a couple of years but you can pay any kid P100 to retape all the windows on all the rooms.

the 50" tv i got was a 4k UHD android TV but i can't see a difference in quality compared to mama and papa's tv which is an ordinary 32" HD. this confirms my belief that a small screen near your face is just as good as a big screen far away. the tv in mama and papa's room even has a better sound system - the speakers that angelique and tikay had a fight over long time ago (angelique took it from lola's room so  tikay got mad and all hell broke lose).

by the way i notice the stationary bike is not the "child amputator". i'm glad someone finally had the common sense to get rid of it. when i first saw children playing around it while one of them was pedaling i was so horrified because if one of them just happens to put a finger or an arm between the sprocket and chain the finger or arm will just fly off like what happened to noy shiano (or was that noy puling). i'm sure it wasn't noy magno. or maybe a child losing an arm or a finger is not such a big deal to normal people i apologize for sounding weird. because i did try to warn the adults in the house and they just ignored my warnings.

II. roof

i found the culprit of the leak (besides the obvious). i found the leak by bringing a big water bottle to the roof and slowly pouring water on each column until the leak happens. i applied vulca seal as a temporary solution.

the permanent solution is actually very simple. buy four 8X3 thin sheets (~P280 each). remove the roof nails just above this leak culprit. tap it with a flat head scew driver to initially pry it out and then finish taking it off with the claw of a hammer. then insert 2 sheets to cover about 4 feet beyond this culprit. the 2 sheets should over lap about 1 foot. then do the same below. fasten with roof nails and apply vulca seal on the roof nails.

notice in the picture there are grey dots all over the roof. those are the small holes that i covered with vulca seal. the holes are on the convex part of the roof so they don't really cause a leak but it does cause the kisame to moisten and attract termites.

i also added in my action item list to paint the roof so it lasts longer. i know it's not that expensive because roof paint is much cheaper. i can also let my helpers to do this to save money.

update 9/19/19

all the roof leaks have been fixed. please read this article because it contains important info on regular maintenance tasks to prevent future leaks such as cleaning the gutters. it also gives you an idea on how to easily fix future leaks - https://reyondit.blogspot.com/2019/09/lahug-roof-leaks.html

III. organizing

one of the reason why we lack motivation to repair and improve the house is because it's very disorganized and cluttered. it's also paralyzing to fix anything when you have to spend 30 minutes just looking for a screw driver or level tool. being organized also gives a better chance of your small business to succeed and even grow.

having a house that is like a dump site will also make it impossible to fix pest problems - rats, cockroaches and termites.

just realize that airnbn is one of the simplest ventures. if you decide to airbnb the gemsville house you will need to organize and get rid of all the junk. realize that none of you are even competent enough to do this. i'm insulting you because it's my goal to become the tita christine of the family. your emotions will immediately overwhelm you and you will be paralyzed just standing there for hours doing nothing. i'm just joking. i'm saying these things for our own good or gabby and kaila when they are 50 years old might end up going through what the crystals have to go through trying to recover the mortgaged properties from Ang. you also can't just hire someone to organize for you because they wouldn't have any clue what to throw away.

after a month of organizing, there was already a mountain of garbage in the front yard. i saw one of yogi's guitar on top of the garbage pile. i've never seen that guitar before or where it came from. good thing i saw it before the garbage truck picked it up.

here's what i wrote recently on the kitchen organizing - https://ian-crystal.blogspot.com/2019/06/prolong-your-life-by-organizing.html

update: i'm done with the herculean task of organizing the rest of the house. browse the photos to get an idea of where your things are, how to easily find documents, or where the tools and hardware supplies are located - https://reyondit.blogspot.com/2019/08/lahug-house-organization.html

IV. self service laundry

next on the list is to organize and make the laundry area decent enough so it can be a self service laundry for the neighbors. the customers can look at a wiki page to know the available slots and they can just call to reserve. we can look cool to the more intellectual customers by offering a green option (or call it low carbon footprint option) where instead of using the dryer they can hang their laundry in the front yard when the sun is out.

the revenues will be used for the house repair expenses.

V. plumbing

next is to fix the kitchen sink drain leaks.

i will also dig near my bathroom to try fix the clogged floor drain. maybe a new drain pipe needs to be installed.

also replace all the toilet flush with leak proof. they are not that expensive and it can save us from a catastrophic water bill if a valve is leaking and is undetected for days. how it works is that if there is a leak, the toilet water tank will just be empty. the toilet can still flush but you will have to wait for a minute for the water tank to fill before you can flush it. it's better than adding P10k to your water bill. this is actually what i installed in the master bedroom of the la quinta house because the tank is warped so it will always leak even if the flapper set is new. sealant did not help. if it hasn't been replaced you will notice that sometimes you will have to wait for the tank to fill before you can flush. however if the leak is slow and there is still enough water in the tank you don't have to wait it will flush immediately.

i need info from you guys on septic tank locations and how often they are usually drained.

update 9/7/19

the kitchen drain is now good as new. the grease gunk hardened like cement. i replaced the pipes that connect to the wall outlet. i tested removing the hardened grease in the old fittings and i can only remove it by chipping it off using a flat head screw driver and a hammer. this means don't bother using a drain snake or sewer rod to remove hardened grease because it won't work. luckily i was able to declog the pipe buried in the wall after 2 days of repeatedly applying eagle declogger chemical. when i got the snake to go through the other end, i attached a hose clamp (tied it with a wire) then pulled it at the other end. the hose clamp acts as a brush to remove the remaining grease gunk. i tested it by stuffing the drain pipe with rice, and sprayed it with a high pressure water hose. the chunk of rice immediately jumped out on the other end which means the drain is fully declogged. also note that i can never get the snake to pass through the L section unless someone on the other end tries to meet it with another snake (i guess it causes the snake to bend and slide through the L section).

i was thinking of  installing a grease trap but thought it's not worth it. instead, if the drain starts to slow, immediately apply eagle declogger while the grease has not hardened enough. i did not apply pvc solvent to the coupling that connects to the wall so it will be easy remove and reconnect the pipe whenever you need to apply eagle decolgger to the pipe embedded in the wall. DO NOT USE EAGLE DECLOGGER ON THE PIPES FROM THE SINK TO THE WALL because it will melt the rubber gasket of the "pvc to sink drain" compression connector (the white thingy between the orange and silver pipe in the photo). anyway it's easy to remove and disassemble so you can manually clean it. to minimize the the grease build up, i trained the staff to wipe the frying pan with paper towel before washing and posted the instructions as you can see in the photo. i also used screw sleeves to fasten the sink cabinet frame and re-enforced the broken columns with brackets. for aesthetics i moved the gasul tank inside the cabinet.

update 10/2/19:

i completed all the plumbing repairs and improvements. the water line that supplies the master bathroom got disconnected and it was a while before one of my helpers noticed there was a huge puddle of water even if it wasn't raining. it caused the water bill to skyrocket. it was a slip connection which uses solvent but our main shut off valve has a leak so there is no way for the solvent to dry. the plumber was being lazy. my solution was to use a gate valve with threaded connection because teflon works with wet connection. then i simply closed the gate valve so i can connect the line and let the solvent dry (24 hours). i also reconnected the slip connection outside of the master bathroom.

for sanitary purpose i extended the septic tank drain, kitchen sink drain, and laundry drain all the way to the canal. i just smudged vulcaseal on the drain pipes instead of solvent so it will be easier to disassemble later on if we need to

all toilet fill valves have been replaced with a leak sentry. in the states i always install this on all my properties. good thing i can also buy it here in the philippines through lazada (P750 or $15). it only fills the toilet tank when you flush the toilet. so if the flapper has a leak and you go to boracay for a month and you forgot to switch off the main water line you only waste a toilet tank worth of water. unlike the normal fill valves that continuously fills the tank whenever the water level goes down so if there is a slow leak then you waste precious water. this is especially important in talamban cebu where the water has very high levels of calcium which causes the flapper to leak. my tenant gave up always replacing the flapper and cleaning the tank to solve the leak caused by calcium deposits. instead they learned to push the flush lever down as soon as they sat down to kalibang (poo / number 2) so while they are doing their business the toilet tank will start to fill and they can immediately flush when they are done

i also installed bum guns and shower heaters on all the bathrooms.

VI. termites

i called mapecon and they quoted me P35k. i realized it's really not that complicated to inspect all the wooden parts of the house so i decided to do it myself. i will have to buy a bright rechargeable lamp and scour the attic for signs of termites (of course with the main breaker switched off). the good news is i found a source to get very potent but illegal termite dust through lazada.

of course i will also have to get rid of all the junk around the house. they are termite magnets and they also make it impossible to protect the perimeter with termite prevention chemicals (which you can buy from the hardware store).

update 2/21/19:

https://reyondit.blogspot.com/2019/09/diy-termite-inspection-treatment-and-repair.html

VII. cockroaches and rats

i thought roaches and rats have certain avenger super powers where they can pass through thick wood and cement. i thought you can only control rats by setting steel cage traps. i googled it and learned that rats can gnaw wood but it takes time for them to create a passage through wood that is half an inch thick. also if you just keep the house clean and prevent rats from getting into any food they won't come in the house.

update 9/23/19:

i'm done pest proofing the house. i blocked all the potential entrance of rats and roaches. the rats carved a hole in the kitchen door so i'm sure they will start gnawing when everyone is asleep so keep an eye on it. i also applied putty on the gaps in the ceiling edges.

the tool cabinet also had lots of rat entrances. it may not be that trivial to monitor this part so as soon as you see a rat in the house immediately isolate the area by closing the doors then setup a trap or poison and inform everyone or put a sign to keep the doors closed. and of course inspect the house again and block any holes they carved.

i also sealed all the gaps and holes in the terrace kisame.

VIII. paint

the good news is i discovered a very efficient painting technique that i can train my helpers so it will be very cheap - https://ian-crystal.blogspot.com/2018/10/how-to-avoid-paint-splatter.html

the beautiful marble liners for the kitchen (P780) i ordered via lazada already arrived.

IX. airbnb option

we can airbnb the gemsville house while i'm the only one staying  and use the revenues for the repairs. if anyone wants to stay just let me know and i can block it. gemsville is a prime location because it's near ayala. we simply need to connect to the guard house for habal habal services to ayala. or the tomboy boyfriends of my scholars can be the habal habal. i'm in the process of getting them a driver's license.

i realized those P3 million condos are really just a big box with:

1) clean walls, ceiling and floor
2) drain outlet for the kitchen sink (small kitchen modules (sink and cabinets) are cheap and easy to install).
3) exhause outlet for the kitchen module
4) bathroom

the gemsville house can easily have 4 airbnb units.

X. terrace

i made sure it will be very easy to change the screen later on. you just need to remove 2 screws to remove the frame.

XI. landscaping and gardening

for the landscaping i decided to keep it minimal - just decent enough for hostel/airbnb guests. the biggest problem was the very strong and foul smell of cat poo. they like to defacate in soft soil because it's easy for them to cover it. i planted carabao grass so it will be harder for them to cover their poo and hopefully they will take a shit somewhere else. if this does not solve the problem i think the most humane solution would be to relocated the stray cats to the forests of babag. i utilized mama's plants including the small seedlings so they get watered regularly. the backyard will be mostly camote foliage. aside from aesthetic purposes, it will be a good source of regular healthy snacks and emergency food in times of calamities and disasters. i also planted 3 calamansi seedlings to cover the drain canal area. i was suppose to just replace the 2 dead calamansi plants but there was a tire in the backyard which the basurero won't accept so i decided to just use it for a 3rd calamnsi plant. on the other corner i'm planting onions, tomatoes and sili.

the screen filter for the rain tank collapsed so i replaced it and made it more robustly fastened. i also revived the compost pit because it was converted into a garbage dump.

lastly, i planted some grapes and made a koi pond.

XII. guada repairs

for simplicity, i will just include here the guada repairs because i will be including the expenses in the lahug expenses. here is the collage of the photos:

these are the expenses:

4 pcs pvcs coupling - 112
1 kilo alambri - 80
4 pcs 2" pvc (atlanta heavy duty) - 1000
pvc cap - 40
2 pcs pvc elbow - 90
pvc cap and elbo - 75
pvc pipes - 1065
--------------------------

total: P2,462

XIII. bathroom floor drain

i was finally able to hire a plumber (joel our neighbor) to put a new floor drain for room 1 CR. the quote was P10k. included in the fee is checking the septic tank level and find out where that mystery drain (corner of the house where z3 is parked) goes to. i tried to fill it up with water and after 30 minutes it still did not fill up meaning it probably goes to the septic tank (no water was coming out of the drain outlet at the canal). another possibility is it simply goes underground. this is important because if it goes to the septic tank that means we have a convenient connection in case the very old pundido drains of the room 1 or room 2 CR collapses we can just create new drains that connect to this without having to break tiles and dig inside the house (just pvc pipes running outside the house). note that since the drain of room 1 CR they are working on is not a shower drain or sink drain (the water is not that dirty and it only gets utilized when someone takes a shower without closing the curtians), then it's ok to dump it to this mystery hole even if it just goes under the ground and not to the septic tank or drain outlet to the canal.

they just started working but here are the photos of their progress.

here's the finished result:

XIV. expenses

the airbnb/hostell earnings will be used to pay off all the expenses for lahug. after that all future earnings will go to mama and papa. for simplicity i will just include here the non operational expenses for airbnb such as the bedsheets. i will also include mama's and papa's expenses such as z3 and piano repair and z3 registration

guadalupe drain repair expenses - 2462

vulca seal - 470
putty - 105
2 drill bits - 100
roof - 280
vulca seal - 470
screws - 40
shelf liner - 706
basurero tip - 400
switch - 184

2 faucets - 300
2 sink strains - 1200
paint, brushes, rollers - 1000
paint, sink drain misc - 1500
drain tube extender - 140
paint roller - 46
caulk n gun - 280
leak sentry toilet valve - 1043
drill repari - 640
paint - 190
paint - 700
wood glue - 69
muriatic - 25
mop - 563
vulca seal - 340
paint - 700

cargador tip - 40
paint, vulca seal, wall putty, rugby, floor tiles - 1877
socket and bulbs - 555
muriatic - 85
shovel - 249
steel cabinet duplicate - 50
paint and drain cover - 722
2 bulb sockets and switch - 95
gate valve - 53
paint - 566
folder rack - 139
paint, screen, plywood - 3562
clear tape - 70
muriatic - 105
sacks and containers - 330
screen vinyl - 30
masking tape - 77
glass wall - 23469
caulk, doors, board, brackets - 4424
plate stands - 180

muriatic brush paint - 139
screen rubber sidings - 90
toilet hose, couplings, 4 5watt bulbs, toilet seat cover - 1357
white enamel, brush, 2 1x2x8 wood - 406

1.5hp samsung split ac - 43699
angle valve hoses faucet - 750
2 leak sentry toilet fill valves - 1837
hand broom, sealant, storage box - 559
cloth for couch - 735
screen door lock - 270
flex hose for split ac - 720
electrical wires for split ac - 692
split ac install - 7500
split ac electrical line and vacuum labor - 2500
door hinges, door knob, spoke shave - 881
trash bags - 200
3 mirrors - 605
bulbs, door knobs, plugs - 1716
lazada mapecon f3 powder - 918
plywood and woods - 1252
mirror - 109
zonrox n muriatic - 84
jalousue cut and parts - 175
faucet, hoses, wood, putty, wood glue - 1603
vulcaseal - 335
clear tape to weatherize windows - 128
transparent roof, paint, roller - 1841
roof sheets, paint brush, bulb socket - 2085
fix piano - 19000

floor wax - 209
wall putty - 220
2 shower water heater, outlet for aircon, angle valve, cabinet drawer rail, 2 bum guns - 16310
drawer knob, faucet, couping, screws, toilet seat, teflon tape - 1651
wall putty, liquid nai - 354
2 liquid nails - 494
garbage collection - 3700

grass scissors, sand paper - 289
liquid nails, caulk gun, paint brush, masking tape - 339
30 pcs vynil floor tiles - 3315
2 pcs vynil floor tiles, liquid nails, 2 bulbs - 766

curtains and rods - 1688
curtains and clamps - 460

floor towels, curtains - 817
muriatic and baygon - 401
hooks - 49
basurero tip - 300

floor mats - 538
liquid nails, brackets, hose - 281
screws and ductape - 218
carabao grass - 2000
3/4" plywood - 1400

foam and bedsheets - 1638
electric fan - 999
2 faucets and teflon tape - 354
locks and light switch - 369
revo registration - 4800
toilet hose and door stopper - 299
gasul hose - 200
hose nozzle - 515
bermuda seeds - 182
vulca seal - 455
pvc pipes for drain - 756
pvc elbow - 50
3 calamansi seedlings - 750
50" android tv 4k uhd - 25990
hoseclamp - 34
ej nso and license costs (staff development expense) - 7630
3 month labor costs june to september - 53378

#receivable of P277,015 entered to quicken 9/26/19

pvc pipe, elbow, coupling - 400
gemsville hoa sep 2018 to sep 2019 - 6500
dog abortion - 800
bunk bed and 2 foams - 11800
guadalupe septic suction - 3500
guadalupe drain pvc coupings solvent - 492
CR 1 drain - 12000

#receivable of P35,492 entered to quicken 7/15/20

---------------------
total:

(for more of my knowledge bombs, click the "ian's knowledge bombs" banner at the top of this article and choose any article in the table of contents that piques your interest)