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 12/10/19 - 5000
papa 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 (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 2/3/22 - 60000

to papa 2/11/22 - 1326

to papa 3/7/22 - 1275

to papa 3/23/22 - 20000

gikom's campaign - 10000

to papa 4/9/22 - 20000

to papa 4/28/22 - 1000

to papa 5/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 papa10/30/22 - 15000

to papa 11/22/22 - 3000

to papa 11/29/22 - 30000

to papa 2/19/23 - 20700

to papa 2/22/23 - 1000

to papa 2/22/23 - 15000

to papa 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 - 15000

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

1/29/24 papa - 15000

1/30/24 z3 parts - 23150

2/15/24 papa - 15000

3/1/24 papa - 20000

3/18/24 papa - 15000

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

4/1/24 papa - 20000

4/3/24 joeffrey - 500

4/10/24 papa - 2000

4/14/24 papa - 20000

4/30/24 papa - 20000

5/7/24 chibong lawyer' fee - 100000

5/20/24 papa - 20000

5/21/24 mama - 5000

5/28/24 papa and mama - 50000

5/39/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:

# 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 - 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 - 4000

9/26/24 talisay rpt - 22443

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

10/9/24 gian tuition - 3000

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 

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