Republic of the PhilippinES

DEPARTMENT OF EDUCATION
Division of Sorsogon Province
AGING OF ADVANCES FOR OPERATING EXPENSES
As of July 31, 2020

1990101000 -- Advances for Operating Expenses

Liquidation as of
Cash Advances Balance as of Cash Advances as Liquidation as of Balance as of June30,
Schools Category Cluster Senior Bookkeeper District School ID Accountable Officer December 31,
of Dec. 31, 2019 December 31,\ 2019 of June 30, 2020 June30, 2020 2020
2019

1 AGUADA ES Elem 12 Maricris Balbedina Magallanes South MILO H. ROMANO - 137,351.00 137,351.00 -
2 BITON ES Elem 12 Maricris Balbedina Magallanes South JOSEPH A. MELLANTE - 176,538.50 176,538.50 -
3 BULALA ES Elem 12 Maricris Balbedina Magallanes South LILIAN L. FUNGO 832.67 832.67 65,865.40 82,383.40 (16,518.00)
4 BUSAY ES Elem 12 Maricris Balbedina Magallanes South RAYNO H. LUCENARIO - 84,230.30 81,016.79 3,213.51
5 CADITAAN ESElem 12 Maricris Balbedina Magallanes South EUSTACIO A. BERMAS - 239,875.00 191,900.00 47,975.00
6 EDUARDO LEEElem 12 Maricris Balbedina Magallanes South ANGELOU V. BUBAN 2,084.72 1,420.00 664.72 363,375.00 359,978.74 3,396.26
7 GINANGRA ESElem 12 Maricris Balbedina Magallanes South HELEN T. DE HITTA - 110,831.75 107,786.18 3,045.57
8 LAPINIG ES Elem 12 Maricris Balbedina Magallanes South LEONARDO O. LAGUERTA 5,814.39 5,814.39 - 158,489.45 113,206.75 45,282.70
9 MAGSAYSAY EElem 12 Maricris Balbedina Magallanes South TERESITA M. FRILLES - 71,250.00 71,250.00 -
10 MALBOG ES Elem 12 Maricris Balbedina Magallanes South JERRAN P. HICOM - 74,812.50 74,812.50 -
11 PAWIK ES Elem 12 Maricris Balbedina Magallanes South JANET H. SAMSON 62.84 62.84 135,375.00 133,279.50 2,095.50
12 SALVACION EElem 12 Maricris Balbedina Magallanes South ROXAN G. OLIVAR 24.70 24.70 97,769.25 97,767.07 2.18
13 SIUTON ES Elem 12 Maricris Balbedina Magallanes South CECILIA B. SABADO - 230,371.20 230,371.20 -
14 TULA-TULA SU
Elem 12 Maricris Balbedina Magallanes South NANCY S. BELANDO - 138,539.45 98,959.62 39,579.83
8,819.32 7,234.39 1,584.93 2,084,673.80 1,956,601.25 128,072.55

Prepared by: Certified Correct:

MARICRIS D. BALBEDINA PAUL ANDY D. DEBLOI

Senior Bookkeeper Accountant III
 No of Months Total Outstanding
% OF LIQ
Downloaded
Monthly MOOE Cash Advances Less than 30 days 31-90 days 91-365 days Over 1 year Over 2 yrs 3 yrs and above Total

100.00% #DIV/0! - - -
100.00% #DIV/0! - - -
125.08% #DIV/0! (15,685.33) (15,685.33) -
96.18% #DIV/0! 3,213.51 3,213.51 -
80.00% #DIV/0! 47,975.00 47,975.00 -
99.07% #DIV/0! 4,060.98 4,060.98 -
97.25% #DIV/0! 3,045.57 3,045.57 -
71.43% #DIV/0! 45,282.70 45,282.70 -
100.00% #DIV/0! - - -
100.00% #DIV/0! - - -
98.45% #DIV/0! 2,158.34 2,158.34 -
100.00% #DIV/0! 26.88 26.88 -
100.00% #DIV/0! - - -
71.43% #DIV/0! 39,579.83 39,579.83 -
93.86% -
-
-
-
D. DEBLOIS -
-
-
-
-
To check

-
-
(15,685.33)
3,213.51
47,975.00
4,060.98
3,045.57
45,282.70
-
-
2,158.34
26.88
-
39,579.83
-128072.55
0
#VALUE!
0
#VALUE!
#VALUE!
0
0
0
 Republic of the PhilippinES
DEPARTMENT OF EDUCATION
Division of Sorsogon Province
AGING OF ADVANCES FOR OPERATING EXPENSES
As of July 31, 2020

1990101000 -- Advances for Operating Expenses

Cash Advance, Cash Advances, to Liquidation , this Liquidation , to

Schools Category
ClusterSenior Bookkeeper District School ID Accountable Officer Balances
this month date month date

AGUADA ES 12 Maricris Balbedina Magallanes South114250 MILO H. ROMANO 137,351.00 137,351.00 137,351.00 137,351.00 -
BITON ES 12 Maricris Balbedina Magallanes South114251 JOSEPH A. MELLANTE 176,538.50 176,538.50 141,198.71 35,339.79 176,538.50 -
BULALA ES 12 Maricris Balbedina Magallanes South114252 LILIAN L. FUNGO 65,865.40 65,865.40 49,737.35 32,646.05 82,383.40 (16,518.00)
BUSAY ES 12 Maricris Balbedina Magallanes South114253 RAYNO H. LUCENARIO 84,230.30 84,230.30 81,016.79 81,016.79 3,213.51
CADITAAN ES 12 Maricris Balbedina Magallanes South114254 EUSTACIO A. BERMAS 191,900.00 47,975.00 239,875.00 191,900.00 191,900.00 47,975.00
EDUARDO LEE CHAN MEMOR12 Maricris Balbedina Magallanes South114255 ANGELOU V. BUBAN 302,812.50 60,562.50 363,375.00 299,677.40 60,301.34 359,978.74 3,396.26
GINANGRA ES 12 Maricris Balbedina Magallanes South114256 HELEN T. DE HITTA 110,831.75 110,831.75 107,786.18 107,786.18 3,045.57
LAPINIG ES 12 Maricris Balbedina Magallanes South114257 LEONARDO O. LAGUER 113,206.75 45,282.70 158,489.45 113,206.75 113,206.75 45,282.70
MAGSAYSAY ES 12 Maricris Balbedina Magallanes South114258 TERESITA M. FRILLES 71,250.00 71,250.00 71,250.00 71,250.00 -
MALBOG ES 12 Maricris Balbedina Magallanes South114259 JERRAN P. HICOM 74,812.50 74,812.50 59,857.65 14,954.85 74,812.50 -
PAWIK ES 12 Maricris Balbedina Magallanes South114260 JANET H. SAMSON 112,812.50 22,562.50 135,375.00 112,812.50 20,467.00 133,279.50 2,095.50
SALVACION ES 12 Maricris Balbedina Magallanes South114261 ROXAN G. OLIVAR 97,769.25 97,769.25 78,214.07 19,553.00 97,767.07 2.18
SIUTON ES 12 Maricris Balbedina Magallanes South114262 CECILIA B. SABADO 191,976.00 38,395.20 230,371.20 191,858.01 38,513.19 230,371.20 -
TULA-TULA SUR ES 12 Maricris Balbedina Magallanes South114263 NANCY S. BELANDO 118,748.10 19,791.35 138,539.45 98,959.62 98,959.62 39,579.83
1,850,104.55 234,569.25 2,084,673.80 1,734,826.03 221,775.22 1,956,601.25 128,072.55
12,794.03
Prepared by: Certified Correct:

MARICRIS D. BALBEDINA PAUL ANDY D. DEBLOIS

Senior Bookkeeper Accountant III
1990101000 -- Advances for Operating Expenses 5020101000 5020201000 5020301000 5020399900 5020302000 5020308000 5020321000 5020322001

Semi- Semi-
Expendable Expendable
Traveling Office Supplies Accountable Medical Dental and
Schools Accountable Officer Date/LR No. Training Expenses Other Supplies expenses -Machinery & -Furniture
Expenses - Local Expenses Forms Expenses Laboratory Supplies Expenses
Equipment and Fixture
Expense Expense

AGUADA ES MILO H. ROMANO

BITON ES JOSEPH A. MELLANTE 1,350.00 9036 16885
BULALA ES LILIAN L. FUNGO 3,100.00 29546.05
BUSAY ES RAYNO H. LUCENARIO
CADITAAN ES EUSTACIO A. BERMAS
EDUARDO LEE CHAN MANGELOU V. BUBAN 1,655.00 23,625.00 6400 18125
GINANGRA ES HELEN T. DE HITTA
LAPINIG ES LEONARDO O. LAGUERTA
MAGSAYSAY ES TERESITA M. FRILLES
MALBOG ES JERRAN P. HICOM 1,080.00 5,735.85
PAWIK ES JANET H. SAMSON 1,790.00 6,570.00 8608 2499
SALVACION ES ROXAN G. OLIVAR 8,630.00
SIUTON ES CECILIA B. SABADO 1,098.00
TULA-TULA SUR ES NANCY S. BELANDO
6,973.00 - 47,660.85 - - 24,044.00 67,055.05 -
 5020401000 5020402000 5020502000 5020503000 5021299000 5029902000 5021304000 5021502000 5029904000 5029999000 3010101000 2020101000

Repairs and
Maintenance - Transportati
Printing and Other Maintenance
Telephone Expenses Other General School Fidelity Bond on and Accumulated Cash
Water Expenses Electricity Expenses Internet Expenses Publication and Operating Due to BIR
- Landline/ Mobile Services Buildings & Premiums delivey Surplus Collecting
Expenses Expenses
Other expenses
Structures

1000 4000 550 2518.79

2950 1,032.10 1799 6300 1050 2634.76

1000 999 4590 1550

1000
920 10003
6250 29981.19 1184

2,950.00 1,032.10 3,000.00 2,798.00 16,550.00 6,060.00 29,981.19 - - 16,305.79 - 2,634.76

Total Liquidation

-
35,339.79
32,646.05
-
-
60,301.34
-
-
-
14,954.85
20,467.00
19,553.00
38,513.19
-
221,775.22
 Department of Eucation
DIVISION OF SORSOGON

STATUS OF CASH ADVANCES AND SETTLEMENT

District: Juban
School: Sablayan HS
Cluster No.: 11
Accountable Officer/ SchoolHead: Ranil Millares
Particulars
Add: Cash Advances Granted
Particulars Check No Date Amount

MOOE-JAN 101101-02-94-2019 02/23/19 32,615.40

MOOE-FEB
MOOE-MAR 101101-04-207-2019 04/17/19 16,307.70
MOOE-APR 101101-04-206-2019 04/17/19 16,307.70
MOOE-MAY 101101-06-301-2019 06/04/19 16,307.70
MOOE-JUN 101101-06-327-2019 06/18/19 16,307.70
MOOE-JUL 101101-07-364-2019 07/08/19 16,307.70
MOOE-AUG 101101-09-528-2019 09/15/19 32,615.40
MOOE-SEP
MOOE-OCT 101101-11-664-2019 11/07/19 48,923.10
MOOE-NOV
MOOE-DEC 195,692.40
Cash Advances Granted as of to Date 195,692.40
Less: Liquidation As of to Date
Particulars Date LR no. Amount

MOOE-JAN 4/12/2019 19-04-1298 9,549.50

MOOE-FEB 4/12/2019 19-04-1297 22,975.00
MOOE-MAR 5/30/2019 19-06-1959 11,870.00
MOOE-APR 5/30/2019 19-06-1960 20,800.00
MOOE-MAY 6/21/2019 19-06-2374 15,950.00
MOOE-JUN 7/5/2019 19-07-2654 16,540.00
MOOE-JUL 8/20/2019 19-08-3309 15,965.41
MOOE-AUG 15,971.00
MOOE-SEP 16,378.75
MOOE-OCT 14,837.25
MOOE-NOV 15,829.00
MOOE-DEC 19,026.49
Settlement of Cash Advances As of to Date 195,692.40
Unliquidated Cash Balance as of to Date -

Breakdown of Unliquidated Cash Balance:

Prior Years -
Current Year - 2018 -
Total -

Prepared by: Certified:

Maricris D. Balbedina Paul Andy D. Deblois

Senior Bookkeeper Accountant III
1990101000 -- Advances for Operating Expenses

Schools Category ClusterSenior Bookkeeper Name of PSDS District School ID Accountable Officer REF NO. FROM
 Cash Fidelity Bond
TO Remarks
Accountability Premium
1990101000 -- Advances for Operating Expenses

Schools Category ClusterSenior Bookkeeper Name of PSDS

Bagalayag ES ELEMENTARY 13 Maricris Balbedina

Bagong Sirang ES ELEMENTARY 13 Maricris Balbedina
Bogna ES ELEMENTARY 13 Maricris Balbedina
Castilla Central Central SchoolELEMENTARY 13 Maricris Balbedina
Cogon ES ELEMENTARY 13 Maricris Balbedina
Dancalan ES ELEMENTARY 13 Maricris Balbedina
Dulangan ES ELEMENTARY 13 Maricris Balbedina
La Union ES ELEMENTARY 13 Maricris Balbedina
Libtong ES ELEMENTARY 13 Maricris Balbedina
Maracabac ES ELEMENTARY 13 Maricris Balbedina
Milagrosa ES ELEMENTARY 13 Maricris Balbedina
Monte Carmelo ES ELEMENTARY 13 Maricris Balbedina
Oras ES ELEMENTARY 13 Maricris Balbedina
Pandan ES ELEMENTARY 13 Maricris Balbedina
Saclayan ES ELEMENTARY 13 Maricris Balbedina
San Isidro ES ELEMENTARY 13 Maricris Balbedina
San Rafael ES ELEMENTARY 13 Maricris Balbedina
Tomalaytay ELEMENTARY 13 Maricris Balbedina
Minanticaan ES ELEMENTARY 13 Maricris Balbedina
Oras National HS Sec 13 Maricris Balbedina
Milagrosa National HS Sec 13 Maricris Balbedina
Pandan HS Sec 13 Maricris Balbedina
 Cash Advances, to Liquidation, to
District School ID Accountable Officer
date date

Castilla East 114099 Ma. Hazel EStuaria

Castilla East 114100 Pablo ESpinola
Castilla East 114101 Cristito Berja
Castilla East 114102 Ma. PraxidES Flavia Kiblasen
Castilla East 114103 Edmar Lebitinia
Castilla East 114104 Nancy Habulan
Castilla East 114105 Erma A. LESano
Castilla East 114106 Arnulfo Chavez
Castilla East 114107 Roland Dayanghirang
Castilla East 114108 Ma. TerESa Jintalan
Castilla East 114109 Rowell A. Dichoso
Castilla East 114110 Teddy JAnola
Castilla East 114111 MaritES Tan
Castilla East 114112 Edgar jarabejo
Castilla East 114113 Jayson Rapason
Castilla East 114114 Jane Jerao
Castilla East 114115 Marissa Llanto
Castilla East 114116 LourdES JESalva
Castilla East 175019 Gina M. Laurinaria
Castilla East 302210 Belly FuentES
Castilla East 302235 Mary Jean Castillo
Castilla East 302239 Joel Agripa
Transmitted to COA Untransmitted,
Date of Transmittal Remarks
(Amount) Balance

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