obligation vs disbursement jan-june
DESCRIPTION
zxxzzxTRANSCRIPT
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of DECEMBER 31, 2014
Account Title Code Total
A. PERSONAL SERVICES JANUARY FEBRUARY MARCH 1ST QUARTER Salaries and Wages - Regular 5010101000 428,995.00 418,274.52 464,199.44 1,311,468.96 Salaries and Wages - Casual 5010102000 44,000.00 42,000.00 45,428.58
Personnel Economic Relief Allowance 5010201000 0.00 Clothing/Uniform Allowance 5010204000 0.00 Performance Based Bonus 5010204000 0.00Productivity Enhancement Incentive 5010299014 Productivity Incentive Allowance 5010208000 42,000.00 42,000.00 Year End Bonus 5010214000 0.00 Cash Gift 5010215000 0.00 Life and Retirement Insurance Contributions 5010301000 51,479.20 49,255.00 55,954.96 156,689.16 PAG-IBIG Contributions 5010302000 2,100.00 2,400.00 4,500.00 PHILHEALTH Contributions 5010303000 5,100.00 4,875.00 5,550.00 15,525.00 ECC Contributions 5010304000 2,200.00 2,100.00 2,400.00 6,700.00 Other Personnel Benefits 5010499900 0.00B. MAINTENANCE & OTHER OPERATING EXPENSES 0.00 Traveling Expenses - Local 5020101000 7,417.00 5,463.00 14,469.00 27,349.00 Training Expenses 5020201000 700.00 350.00 1,050.00 Office Supplies Expenses 5020301000 27,200.00 25,744.00 28,570.00 81,514.00Accountable Forms 5020302000 0.00Drugs and Medicines Expenses 5020307000 724.00 724.00Gasoline, Oil and Other Lubricants 5020309000 1,000.00 1,000.00Other Suppplies Expenses 765 0.00Water Expenses 766 0.00 Telephone Expenses - Mobile 5020502000 1,200.00 600.00 1,800.00 Transportation and Delivery Expenses 5029904000 0.00Janitorial Services 5021202000 6,000.00 6,000.00 12,000.00Security Services 5021203000 2,000.00 2,000.00 2,000.00 Repairs and Maintenance - Sch. Bldg. 5021304002 0.00 Fidelity Bond premiums 5021502000 1,500.00 3,375.00 4,875.00Other Maintenance and Operating Expenses 5029999000 505.00 505.00
TOTAL - 576,591.20 564,965.52 663,571.98 1,667,700.12
MOOE 44,817.00 PS
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of DECEMBER 31, 2014
APRIL MAY JUNE 2ND QUARTER JULY AUGUST SEPTEMBER 3RD QUARTER442,539.00 400,686.00 432,077.06 1,275,302.06 424,995.72 424,995.72
44,000.00 40,000.00 42,000.00 42,000.00
0.00 0.00105,000.00 105,000.00 0.00
0.00 0.00
0.00 0.00196,943.00 196,943.00 0.00
51,000.00 51,000.00 0.0051,480.88 47,106.76 49,538.44 148,126.08 49,310.04 49,310.04
2,100.00 2,100.00 2,100.00 6,300.00 2,100.00 2,100.005,100.00 4,675.00 4,900.00 14,675.00 4,900.00 4,900.002,200.00 2,000.00 2,100.00 6,300.00 2,100.00 2,100.00
0.00 0.000.00 0.00
19,067.50 19,067.50 13,129.50 13,129.500.00 0.00
19,554.00 19,554.00 32,250.00 32,250.000.00 0.000.00 0.000.00 0.000.00 10,000.00 10,000.000.00 0.000.00 0.000.00 0.00
6,270.00 6,270.00 0.000.00 0.000.00 0.000.00 0.000.00 0.00
697,311.38 744,510.76 532,715.50 1,848,537.64 580,785.26 - - 538,785.26
43,348.00 43,895.50 46,737.07 642,618.77 803,593.07 530,431.15
685,966.77 847,488.57 577,168.22
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of DECEMBER 31, 2014
Charged to AllotmentCharged To Income/Other Funds
Others(As Authorized by Law)Current Year Prior Year Total Current YearPrior Year Total
OCTOBER NOVEMBER DECEMBER 4TH QUARTER0.00 3,011,766.74 3,011,766.740.00 - 0.00
0.00 - 0.000.00 105,000.00 105,000.000.00 - 0.000.00 - 0.000.00 42,000.00 42,000.000.00 196,943.00 196,943.000.00 51,000.00 51,000.000.00 354,125.28 354,125.280.00 12,900.00 12,900.000.00 35,100.00 35,100.000.00 15,100.00 15,100.000.00 - 0.000.00 - 0.000.00 59,546.00 59,546.000.00 1,050.00 1,050.000.00 133,318.00 133,318.000.00 - 0.000.00 724.00 724.000.00 1,000.00 1,000.000.00 10,000.00 10,000.000.00 - 0.000.00 1,800.00 1,800.000.00 - 0.000.00 18,270.00 18,270.000.00 - 0.000.00 - 0.000.00 4,875.00 4,875.000.00 505.00 505.00
- - - - 4,055,023.02 - 4,055,023.02
Certified Correct:
SHERYLLE B. GUINARES Senior Bookkeeper
ps - mooe 43,348.00
43,348.00
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of JUNE 30, 2015
Account Title Code Total
A. PERSONAL SERVICES JANUARY FEBRUARY MARCH 1ST QUARTER Salaries and Wages - Regular 5010101000 428,995.00 418,274.52 464,199.44 1,311,468.96 Salaries and Wages - Casual 5010102000 44,000.00 42,000.00 45,428.58
Personnel Economic Relief Allowance 5010201000 0.00 Clothing/Uniform Allowance 5010204000 0.00 Performance Based Bonus 5010204000 0.00Productivity Enhancement Incentive 5010299014 Productivity Incentive Allowance 5010208000 42,000.00 42,000.00 Year End Bonus 5010214000 0.00 Cash Gift 5010215000 0.00 Life and Retirement Insurance Contributions 5010301000 51,479.20 49,255.00 55,954.96 156,689.16 PAG-IBIG Contributions 5010302000 2,100.00 2,400.00 4,500.00 PHILHEALTH Contributions 5010303000 5,100.00 4,875.00 5,550.00 15,525.00 ECC Contributions 5010304000 2,200.00 2,100.00 2,400.00 6,700.00 Other Personnel Benefits 5010499900 0.00B. MAINTENANCE & OTHER OPERATING EXPENSES 0.00 Traveling Expenses - Local 5020101000 7,417.00 5,463.00 14,469.00 27,349.00 Training Expenses 5020201000 700.00 350.00 1,050.00 Office Supplies Expenses 5020301000 27,200.00 25,744.00 28,570.00 81,514.00Accountable Forms 5020302000 0.00Drugs and Medicines Expenses 5020307000 724.00 724.00Gasoline, Oil and Other Lubricants 5020309000 1,000.00 1,000.00Other Suppplies Expenses 765 0.00Water Expenses 766 0.00 Telephone Expenses - Mobile 5020502000 1,200.00 600.00 1,800.00 Transportation and Delivery Expenses 5029904000 0.00Janitorial Services 5021202000 6,000.00 6,000.00 12,000.00Security Services 5021203000 2,000.00 2,000.00 2,000.00 Repairs and Maintenance - Sch. Bldg. 5021304002 0.00 Fidelity Bond premiums 5021502000 1,500.00 3,375.00 4,875.00Other Maintenance and Operating Expenses 5029999000 505.00 505.00
TOTAL - 576,591.20 564,965.52 663,571.98 1,667,700.12
MOOE 44,817.00 46,361.00 45,639.00 PS
TOTAL PS AND MOOE JAN - JUNE 3,606,349.76 GMS JAN - JUNE
LESS: MOOE Jan - June 271,820.50 SALARIES 65,488.00
TOTAL PS 3,334,529.26 6,600.00 LESS: TOTAL PS OF GMS 112244 6930TOTAL PS - REGULAR 3,222,285.26 5940LESS: RLIP 304,815.24 84,958.00 GRAND TOTAL PS -REGULAR 2,917,470.02 PERA 8000
CLOTHING 5000PIA 2000YEB 8186CASH GIFT 2500HDMF 400PHIC 800ECC 400TOTAL PS 112,244.00
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of JUNE 30, 2015
APRIL MAY JUNE 2ND QUARTER JULY AUGUST SEPTEMBER 3RD QUARTER442,539.00 400,686.00 432,077.06 1,275,302.06 424,995.72 424,995.72
44,000.00 40,000.00 42,000.00 42,000.00
0.00 0.00105,000.00 105,000.00 0.00
0.00 0.00
0.00 0.00196,943.00 196,943.00 0.00
51,000.00 51,000.00 0.0051,480.88 47,106.76 49,538.44 148,126.08 49,310.04 49,310.04
2,100.00 2,100.00 2,100.00 6,300.00 2,100.00 2,100.005,100.00 4,675.00 4,900.00 14,675.00 4,900.00 4,900.002,200.00 2,000.00 2,100.00 6,300.00 2,100.00 2,100.00
0.00 0.000.00 0.00
19,067.50 25,505.00 8,370.00 52,942.50 13,129.50 13,129.500.00 0.00
19,554.00 20,010.00 36,227.00 75,791.00 32,250.00 32,250.000.00 0.000.00 0.000.00 0.000.00 10,000.00 10,000.000.00 0.000.00 0.000.00 0.00
6,270.00 6,270.00 0.000.00 0.000.00 0.000.00 0.000.00 0.00
697,311.38 790,025.76 577,312.50 1,938,649.64 580,785.26 - - 538,785.26
44,891.50 45,515.00 44,597.00 3,606,349.76
EDNA GUILLERMO MEMORIAL NHSDETAILED BREAKDOWN OF OBLIGATION
As of JUNE 30, 2015
Charged to AllotmentCharged To Income/Other Funds
Others(As Authorized by Law)Current Year Prior Year Total Current YearPrior Year Total
OCTOBER NOVEMBER DECEMBER 4TH QUARTER0.00 3,011,766.74 3,011,766.740.00 - 0.00
0.00 - 0.000.00 105,000.00 105,000.000.00 - 0.000.00 - 0.000.00 42,000.00 42,000.000.00 196,943.00 196,943.000.00 51,000.00 51,000.000.00 354,125.28 354,125.280.00 12,900.00 12,900.000.00 35,100.00 35,100.000.00 15,100.00 15,100.000.00 - 0.000.00 - 0.000.00 93,421.00 93,421.000.00 1,050.00 1,050.000.00 189,555.00 189,555.000.00 - 0.000.00 724.00 724.000.00 1,000.00 1,000.000.00 10,000.00 10,000.000.00 - 0.000.00 1,800.00 1,800.000.00 - 0.000.00 18,270.00 18,270.000.00 - 0.000.00 - 0.000.00 4,875.00 4,875.000.00 505.00 505.00
- - - - 4,145,135.02 - 4,145,135.02
Certified Correct:
SHERYLLE B. GUINARES Senior Bookkeeper
ps - mooe 43,348.00
43,348.00
EDNA GUILLERMO MEMORIAL NHST R I A L B A L A N C E
As of DECEMBER 31, 2014
Particulars Account Code Debit Credit Treasury Deposit 1010401000 623.27 School Buildings 1060402000 480,024.96 Accumulated Depreciation - Sch. Buildings 1060402100 64,800.00 Other Property, Plant and Equipment 1069999000 122,025.00 Accounts Payable 2010101000 2,263.25 Due to Officers and Employees 2010102000 90,736.75 Other Payables 2999999000 881.65 Government Equity 3010101000 537,508.27 Subsidy Income from National Government 4030101000 7,810,393.72 Salaries and Wages-Regular 5010101001 5,163,772.31 Salaries and Wages-Casual 5010102000 15,246.24 Personnel Economic Relief Allowance (PERA) 5010201000 528,000.00 Uniform/Clothing Allowance 5010204000 110,000.00 Productivity Incentive Allowance 5010208000 32,000.00 Year - End - Bonus 5010214000 425,936.50 Cash Gift 5010215000 109,000.00 Productivity Enhancement Incentive 5010299012 110,000.00 Performance Based Bonus 5010299014 75,000.00 Life and Retirement Insurance Contributions 5010301000 617,469.25 PAG-IBIG Contributions 5010302000 26,400.00 PHILHEALTH Contributions 5010303000 61,200.00 ECC Contributions 5010304000 26,400.00 Other Personnel Benefits 50104999000 42,119.81 Traveling Expenses 5020101000 148,328.93 Training Expenses 5020201000 34,838.00 Office Supplies Expenses 5020301000 240,818.34 Accountable Forms 5020302000 1,300.00 Drugs and Medicines Expenses 5020307000 1,367.50 Gasoline, Oil and Lubricants 5020309000 9,528.50 Telephone Expenses 5020502000 2,700.00 Transportation and Delivery Expense 5029904000 9,600.00 Janitorial Services 5021202000 5,880.00 Fidelity Bond Premium 5021202000 4,875.00 Repairs and Maintenance - Sch. Bldg. 5021304002 62,755.27 Security Services 5021203000 6,000.00
Other Maintenance and Operating Expenses 10059899000 32,858.00
TOTAL 8,506,325.26 8,506,325.26 -
Certified Correct :
SHERYLLE B. GUINARESSenior Bookkeeper
DEPARTMENT OF EDUCATION REGION XI
EDNA GUILLERMO MEMORIAL NATIONAL HIGH SCHOOLNuing, JAS, Davao del Sur
As of DECEMBER 31, 2014
2033-9010-81 2033-9010-90 2033-9011-112033-9011-03NCA RECEIVED/DISBURSEMENT PS MOOE AP TL TOTAL Balance Forwarded 312.75 638.56 951.31 NCA NO. ROXI-14-0008671 dated 7/10/2014 640,000.00 45,000.00 685,000.00 NCA NO. ROXI-14-0021494 dated 12/10/201 110,000.00 110,000.00
-
TOTAL NCA RECEIVED 750,312.75 45,638.56 - - 795,951.31 -
ACIC NO. 14-12-008 DTD 12/2/2014 5,353.00 5,353.00 ACIC NO. 14-12-009 DTD 12/4/2014 37,484.97 37,484.97 ACIC NO. 14-12-017 DTD 12/4/2014 40,499.67 40,499.67 ACIC NO. 14-12-018 DTD 12/18/2014 31,519.21 31,519.21 LDDAP-ADA NO.101101-12-044-2014 8,486.96 8,486.96 LDDAP-ADA NO.101101-12-045-2014 2,800.00 2,800.00 LDDAP-ADA NO.101101-12-046-2014 308,103.13 308,103.13 LDDAP-ADA NO.101101-12-047-2014 123,819.14 123,819.14 LDDAP-ADA NO.101101-12-048-2014 40,626.48 40,626.48 LDDAP-ADA NO.101101-12-049-2014 110,000.00 110,000.00
TOTAL 663,054.59 45,637.97 - - 598,692.56 Add/(Less) Checks Previously issued but Subsequently CancelledAdjustmentDate Check No. ACIC No. Amount
Balance Forwarded 12/31/14 87,258.16 0.59 87,258.75 -
Certified Correct:
SHERYLLE B. GUIÑARESSenior Bookkeeper
3-Dec 553,054.59
18-Dec18-Dec18-Dec18-Dec
312.75
Department of EducationRegion XI
Division of Davao del SurEDNA GUILLERMO MEMORIAL NATIONAL HIGH SCHOOL
Nuing, JAS, Davao del Sur
SUMMARY OF TRAFor the Month of DECEMBER, 2014
PS1600 1601-E
TOTALMOOE MOOE
eFPS41,687.52 41,687.52
310.62 310.62103.54 103.54
Adjustment -0.06TOTAL 41,687.52 310.56 103.54 42,101.68
Certified Correct:
SHERYLLE B. GUIÑARESSenior Bookkeeper
NAME GROSS TAX BASE
CLEAREX 12270.8 12270.8
LJ KIDS PAPER AND PRINTS 6156 6156
41,687.52 414.10
5% 3% 1% TOTAL
368.124 122.708 490.832
184.68 61.56 246.24
0.00 552.80 184.27 737.07
MONTHLY REPORT OF DISBURSEMENTSFor the Month of OCTOBER, 2014
Division : Davao del SurName of School:Edna Guillermo Memorial NHS
PARTICULARSCURRENT YEAR BUDGET PRIOR YEARS' BUDGETPRIOR YEARS' OBLIGATIONTRUST LIABILITIES
OTHERSTOTAL
REMARKSPS MOOE CO TOTAL PS MOOECO TOTAPSMOOECOTOTAL PS MOOECOTOTA PS MOOE COTOTALNotice of Cash Allocation 640,000.00 45,000.00 685,000.00 640,000.00 45,000.00 685,000.00 MDS Checks Issued 663,054.59 45,637.97 708,692.56 663,054.59 45,637.97 708,692.56 Advice to Debit AccountTOTAL DISBURSEMENTS 663,054.59 45,637.97 708,692.56 663,054.59 45,637.97 708,692.56Balance NCA 0.00 0.00 0.00 -23,054.59 -637.97 -23,692.56Tax Remittance Advice 41,687.52 414.10 42,101.62 41,687.52 414.10 42,101.62Cash Disbursement CeilingNon-Cash Availment Authority
TOTAL 704,742.11 46,052.07 750,794.18 704,742.11 46,052.07 750,794.18
Certified Correct:
SHERYLLE B. GUINARESSenior Bookkeeper
MONTHLY REPORT OF DISBURSEMENTSFor the Month of DECEMBER, 2014
Division : Davao del SurName of School:Edna Guillermo Memorial NHS
PARTICULARSCURRENT YEAR BUDGET PRIOR YEARS' BUDGETPRIOR YEARS' OBLIGATIONTRUST LIABILITIES
OTHERSTOTAL
REMARKSPS MOOE CO TOTAL PS MOOECO TOTAPSMOOECOTOTAL PS MOOECOTOTA PS MOOE COTOTALNotice of Cash Allocation 493,000.00 46,000.00 539,000.00 493,000.00 46,000.00 539,000.00 MDS Checks Issued 72,018.88 42,837.97 114,856.85 72,018.88 42,837.97 114,856.85 Advice to Debit Account 591,035.71 2,800.00 593,835.71 591,035.71 2,800.00 593,835.71 TOTAL DISBURSEMENTS 663,054.59 45,637.97 708,692.56 663,054.59 45,637.97 708,692.56Balance NCA 0.00 0.00 0.00 0.00 0.00 0.00Tax Remittance Advice 41,687.52 414.10 42,101.62 41,687.52 414.10 42,101.62Cash Disbursement CeilingNon-Cash Availment Authority
TOTAL 704,742.11 46,052.07 750,794.18 704,742.11 46,052.07 750,794.18
Certified Correct:
SHERYLLE B. GUINARESSenior Bookkeeper
SUMMARY LIST OF CHECKS ISSUED AND CANCELLEDFor the Month of DECEMBER, 2014
Division : Davao del SurName of School: Edna Guillermo Memorial National High School
DATE ACIC NO./LDDAP NO. MDS ACCOUNT NO. 2033-9010-81PS
12/4/2014 14-12-017 40,499.67 12/18/2014 14-12-018 31,519.21 12/3/2014 101101-12-044-2014 8,486.96
12/18/2014 101101-12-046-2014 308,103.13 12/18/2014 101101-12-047-2014 123,819.14 12/18/2014 101101-12-048-2014 40,626.48 12/18/2014 101101-12-049-2014 110,000.00
Sub-Total 663,054.59Less: Subsequently
TOTAL 663,054.59
Certified Correct:
SHERYLLE B. GUIÑARES Senior Bookkeeper
SUMMARY LIST OF CHECKS ISSUED AND CANCELLEDFor the Month of DECEMBER, 2014
Division : Davao del SurName of School: Edna Guillermo Memorial National High School
DATE ACIC NO. MDS ACCOUNT NO. 2033-9010-90MOOE
12/2/2014 14-12-008 5,353.00 12/4/2014 14-12-009 37,484.97 12/3/2014 101101-12-045-2014 2,800.00
Sub-Total 45,637.97Less: Subsequently
TOTAL 45,637.97
Certified Correct:
SHERYLLE B. GUIÑARES Senior Bookkeeper
CHECK DISBURSEMENT JOURNALEDNA GUILLERMO MEMORIAL NATIONAL HIGH SCHOOL Report No. 2014-11-011
As of DECEMBER 31, 2014 LBP 02033-9010-90
DATE ACIC/ADA NO. PAYEECREDIT DEBIT SUNDRY
108 412 751 753 755 759 761 Ref.Amount
Debit Credit
1010404000 2020101000 5020101000 5020201000 502030100012/2/2014 260962 SHERYLLE B. GUINARES 3,971.00 3,653.00 318.00 12/2/2014 260963 SHERYLLE B. GUINARES 1,382.00 1,382.00 12/3/2014 101101-12-045-2014 JOEY PATRICK A. HISOLA 1,400.00 1,400.00 12/3/2014 101101-12-045-2014 EDWIN O. CATUBAY 1,400.00 1,400.00 12/4/2014 260964 A.L.MONTINOLA ENTERPRISES 9,939.97 414.16 10,354.13 12/4/2014 260965 HERMIE O. SENOSA 27,545.00 10,424.00 2,570.00 4,492.25 412.50 2,000.00 5021304002 778.00
10059899000 6,867.25
Total 45,637.97 414.16 18,259.00 2,888.00 14,846.38 412.50 2,000.00 7,645.25
Recapitulation: 46,052.13
Traveling Expenses 5020101000 18,259.00Training Expenses 5020201000 2,888.00Office Supplies Expenses 5020301000 14,846.38Drugs and Medicine Expenses 5020307000 412.50Gasoline, Oil and Other Lubricants 5020309000 2,000.00Repairs and Maintenance - School Building 5021304002 778.00Other Maintenance and Operating Expenses 10059899000 6,868.25 Due to BIR 2020101000 414.16
Cash National Treasury-MDS 1010404000 45,637.97
46,052.13 46,052.13
Certified Correct: -
SHERYLLE B. GUINARESSenior Bookkeeper
AccountCode
P PP
751 753 755 7615138 300 494.75 5004490796
10424
2754510545 17000
300
Edna Guillermo Memorial National High School ReportCheck Disburesement Journal No. 2014-012-012As of DECEMBER 31 , 2014 LBP 02033-9010-81PS
DATE Check No. PAYEECREDIT DEBIT SUNDRY
108 412 413 414 - premium 414 - MPL 415 439 701 711 731 732 - premium 439 Ref.Amount Debit
1010404000 2020101000 2020102000 2020102003 5010304000 2020103000 2020104000 2999999000 501010100 5010201000 5010301000 5010302000 299999900012/3/2014 ADA BTR 1,886.96 1010401000 1,886.96 12/3/2014 ADA RICHELYN MAE CABANILLA 6,600.00 5010214000 6,600.00 12/4/2014 282392 HDMF 9,765.06 2,200.00 2020103000 2,200.00
2020103002 5,365.06 12/4/2014 282393 DEPED-DIVISION OF DVO. DEL SUR 7,250.01 7,250.01 12/4/2014 282394 SHERYLLE B. GUINARES 23,484.60 5010499000 23,484.60
ADA EDNA GUILLERMO MNHS 85,064.13 27,576.09 25,450.02 36,602.18 1,400.00 4,622.96 3,437.50 119,446.57 275,599.45 28,000.00 ADA EDNA GUILLERMO MNHS 4,052.68 755.00 1,473.66 20.00 100.00 200.00 11,772.66 16,374.00 2,000.00 ADA EDNA GUILLERMO MNHS 59,729.90 13,356.43 11,685.87 700.00 1,575.00 47,624.87 120,672.07 14,000.00 ADA BENEFFICIAL LIFE 679.00 679.00 ADA BENEFFICIAL LIFE 436.50 436.50 due to rlip ADA FORTUNE LIFE INS. CO.,INC. 1,746.00 1,746.00 ADA CITY SAVINGS BANK 82,065.76 82,065.76 ADA CITY SAVINGS BANK 6,805.73 6,805.73 ADA CITY SAVINGS BANK 37,282.59 37,282.59 ADA ONE NETWORK BANK 30,240.84 30,240.84 ADA ONE NETWORK BANK 4,403.71 4,403.71 ADA ONE NETWORK BANK 6,159.03 6,159.03
ADA RUBERTINO L. MARIANO 2,000.00 2,000.00 ADA PHIC 6,762.50 2020104000 3,437.50 ecc
5010303000 3,325.00 ADA PHIC 400.00 2020104000 200.00
5010303000 200.00 ADA PHIC 3,150.00 2020104000 1,575.00 ps - phic
5010303000 1,575.00 ADA GSIS 33,933.16 33,933.16 ADA GSIS 63,452.20 2020102000 25,450.02
5010304000 1,400.00 2020102003 36,602.18
ADA GSIS 1,964.88 1,964.88 loans - salary ADA GSIS 1,593.66 2020102000 1,473.66
2020102003 20.00 5010304000 100.00
ADA GSIS 15,581.16 15,581.16 loans - policy ADA GSIS 12,385.87 2020102000 11,685.87
5010304000 700.00 12/18/2014 ADA BTR 1,774.94 1010401000 1,774.94 12/18/2014 ADA SERYLLE B. GUINARES 10,884.51 5010499000 10,884.51 12/18/2014 282395 KAREN ORBUDA 15,246.24 5010102000 15,246.24 12/18/2014 282396 HDMF 9,022.96 2,200.00 2020103000 2,200.00
2020103002 4,622.96 12/18/2014 282397 DEPED-DIVISION OF DVO. DEL SUR 7,250.01 7,250.01 12/18/2014 ADA EDNA GUILLERMO MNHS 70,000.00 70,000.00 12/18/2014 ADA EDNA GUILLERMO MNHS 5,000.00 5,000.00 12/18/2014 ADA EDNA GUILLERMO MNHS 35,000.00 35,000.00
663,054.59 41,687.52 38,609.55 36,622.18 - 2,200.00 4,622.96 5,212.50 178,844.10 414,645.52 44,000.00 51,479.20 4,400.00 184,319.18 272,009.50 970,853.40 970,853.40
Treasury Deposit 1010401000 3,661.90 -
Salaries and Wages - Regular 5010101000 414,645.52
Salaries and Wages - Casual 5010102000 15,246.24
Personnel Economic Relief Allowance(PERA) 5010201000 44,000.00
Other Bonuses and Allowanes 110,000.00
Year End Bonus 5010214000 6,600.00
Cash Gift 5010215000
Life and Retirement Insurance Contributions 5010301000 51,479.20
PAG-IBIG Contributions 5010302000 4,400.00
PHILHEALTH Contributions 5010303000 5,100.00
ECC Contributions 5010304000 2,200.00
Other Personnel Benefits 5010499000 34,369.11
Due to BIR 2020101000 41,687.52
Due to GSIS - RLIP 2020102000 38,609.55 38,609.55
Due to GSIS - SALARY LOAN 2020102003 36,622.18 36,622.18
Due to PAG-IBIG 2020103000 4,400.00 2,200.00
Due to PAG-IBIG - MPL 2020103002 9,988.02 4,622.96
Due to PHILHEALTH 2020104000 5,212.50 5,212.50
Other Payables 2999999000 184,319.18 178,844.10 Certified Correct:
Cash National Treasury - MDS 1010404000 663,054.59
TOTAL 970,853.40 970,853.40 SHERYLLE B. GUINARES
- - Senior Bookkeeper
AccountCode
PP
413
734
415
413
413
GENERAL JOURNALFor the Month of DECEMBER, 2014
Name of School: Edna Guillermo Memorial National High School Fund: 101
Date JEV NO. Particulars Account Code Ref.Amuont
Debit Credit 12/31/2014 GJ2014-12-058 Cash National Treasury-MDS 1010404000 640,000.00
Subsidy Income from National Government 4030101000 640,000.00
To record ANCAI No. ROXI-14- 0008671 dated 7/10/14 of PS account for the month of DECEMBER, 2014.
12/31/2014 GJ2014-12-059 Cash National Treasury-MDS 1010404000 45,000.00 Subsidy Income from National Government 4030101000 45,000.00
To record ANCAI No. ROXI-14- 0008671 dated 7/10/14 of MOOE account for the month of DECEMBER, 2014.
12/31/2014 GJ2014-12-060 Cash National Treasury-MDS 1010404000 110,000.00 Subsidy Income from National Government 4030101000 110,000.00
To record ANCAI No. ROXI-14- 0021494 dated 12/18/14 of PS account for the month of DECEMBER, 2014.
12/31/2014 GJ2014-12-061 Due to BIR 2020101000 414.10 Subsidy Income from National Government 4030101000 414.10
To record EFPS MOOE Account for the month ofDECEMBER, 2014
12/31/2014 GJ2014-12-062 Due to BIR 2020101000 41,687.52 Subsidy Income from National Government 40301010 41,687.52
To record EFPS PS Account for the month ofDECEMBER, 2014
12/31/2014 GJ2014-12-063 Others Payables 2999999000 5,208.59 Cash Treasury Deposit - Regular 1010401000 5,208.59 To record Certificate of National Deposited Collection deposited at Bureau of Treasury
12/31/2014 GJ2014-12-064 Subsidy Income from National Government 40301010 87,258.75 Cash National Treasury - MDS 1010404000 87,258.75
PS = P 87,258.16MOOE = P .59TOTAL =To record lapsed NCAs for the month of DECEMBER, 2014
12/31/2014 GJ2014-12-065 Office Supplies Inventory 1040401000 2,263.25 Accounts Payable 2010101000 2,263.25 To record Account Payable - Montinola Enterprises.
12/31/2014 GJ2014-12-066 Office Supplies Expense 5020301000 2,263.25 Office Supplies Inventory 1040401000 2,263.25 To close Office Supplies Inventory account.
12/31/2014 GJ2014-12-067 Traveling Expenses 5010101000 4,455.00 Training Expense 5020201000 700.00 Gasoline, Oil and other Lubricants 5020309000 1,000.00 Repairs and Maintenance - Sch. Building 5021304002 950.00 Other Maintenance and Operating Expenses 1005989900 8,631.75 Due to Officers and Employees 2010102000 15,736.75
12/31/2014 GJ2014-12-068 Other Bonuses and Allowances 5010204000 75,000.00 Due to Officers and Employees 2010102000 75,000.00
1,024,832.21 1,024,832.21 RECAPITULATION:
Cash National Treasury-MDS 1010404000 795,000.00 87,258.75 Others Payables 2999999000 5,208.59 Office Supplies Inventory 1040401000 2,263.25 Office Supplies Expense 5020301000 2,263.25 Traveling Expenses 5010101000 4,455.00 Performance Based Bonus 5010299014 75,000.00 Training Expense 5020201000 700.00 Gasoline, Oil and other Lubricants 5020309000 1,000.00 Repairs and Maintenance - Sch. Building 5021304002 950.00 Other Maintenance and Operating Expenses 1005989900 8,631.75 Due to BIR 2020101000 42,101.62 Cash Treasury Deposit - Regular 5,208.59 Office Supplies Inventory 1040401000 2,263.25 Accounts Payable 2010101000 2,263.25 Due to Officers and Employees 2010102000 90,736.75 Subsidy Income from National Government 4030101000 87,258.75 837,101.62 TOTAL 1,024,832.21 1,024,832.21
Certified Correct:
SHERYLLE B. GUINARES
Senior Bookkeeper
montinola
18,000.00
EDNA GUILLERMO MEMORIAL NATIONAL HIGH SCHOOLNuing, JAS, Davao del Sur
STATUS OF CASH ADVANCESAs of DECEMBER\ 31, 2014
Object CASH ADVANCE GRANTED LIQUIDATEDNATURE OF PAYMENTCode Amount Check No./ADA NO. Date Amount Check No./ADA NO. Date
PS NONE
TOTAL PS -
MOOE NONE
TOTAL MOOE - -
GRAND TOTAL - -
Certified Correct:
SHERYLLE B. GUINARESADAS III
Compatibility Report for DECEMBER.xls Run on 1/10/2014 13:25
Minor loss of fidelity
20
37
The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
# of occurrences
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
'Check DJ PS'!E10:K10
'Check DJ PS'!E11:E14
'Check DJ PS'!M13:N13
'Check DJ PS'!S13:S16
'Check DJ PS'!E16
'Check DJ PS'!E18
'Check DJ PS'!E21
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
6Defined Names
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.
Compatibility Report for AUGUST REPORTS.xls Run on 8/14/2014 10:32
Minor loss of fidelity
42
The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
# of occurrences
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
'DISBURSEMENT'!AC9:AC10
'DISBURSEMENT'!B24:B26
'DISBURSEMENT'!B29
'DISBURSEMENT'!B33
'DISBURSEMENT'!B36:B37
'DISBURSEMENT'!H41:I42
'Obligation'!AC9:AC10
'Obligation'!B24:B26
'Obligation'!B29 'Obligation'!B33
'Obligation'!B36:B37
'Obligation'!H41:I42
'CHECK DJ MO'!H8:J8
'CHECK DJ MO'!L8
'CHECK DJ MO'!J22:J24
'CHECK DJ MO'!E26:E28
'CHECK DJ MO'!W8:W18
27
'Check DJ PS'!E57
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
6Defined Names
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.
Compatibility Report for DECEMBER - REPORTS.xlsRun on 1/9/2015 16:03
Minor loss of fidelity # of occurrences
46
The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
'DISBURSEMENT'!AC9:AC10
'DISBURSEMENT'!B26:B28
'DISBURSEMENT'!B31
'DISBURSEMENT'!B35
'DISBURSEMENT'!B38:B39
'DISBURSEMENT'!H43:J44
'OBLIGATION (2)'!AC9:AC10
'OBLIGATION (2)'!B26:B28
'OBLIGATION (2)'!B31
'OBLIGATION (2)'!B35
'OBLIGATION (2)'!B38:B39
'OBLIGATION (2)'!H43:J44
'CHECK DJ MO'!H8:J8
'CHECK DJ MO'!P14
'CHECK DJ MO'!J19:J21
'CHECK DJ MO'!J24
'CHECK DJ MO'!W8:W15
'Check DJ PS'!E57
'GEN JOURNAL'!D61
'GEN JOURNAL'!D74
27
Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.
6Defined Names
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.