# 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
--------------
total: P447,354 payable to ian
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
sub total: P562,870
minus:
# i gave the following:
papa travel money 6/11/19 - 5000
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
# 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,982to 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
10/22/24 atty balili appearance fee compound title re-issuance - 10911
10/31/24 melvin cimafranca assistance - 5000
11/19/24 gian tuition - 4000
11/29/24 papa - 20000
12/7/24 papa - 20000
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
No comments:
Post a Comment