ACCOMPLISHMENT REPORT

Provincial Accounting OfficeProvincial Capitol of Laguna

EVELYN T. VILLANUEVAPROVINCIAL ACCOUNTANT

INTERNAL AUDIT DIVISION

1.Pre-audited all payments, fund transfers and remittances.

a. Reviewed and checked supporting documents of disbursement vouchers and payrolls to determine correctness of computations and completeness of requirements and to determine compliance to prescribed rules and regulations.

ACCOMPLISHMENT REPORTFISCAL YEAR 2010

- Payrolls for salaries and wages, subsistence, laundry allowance, hazard pay, honorarium, bonus, 13th month pay, clothing allowance, productivity, overtime and per diems of permanent, casual, job order, contractual and contract of services.

- Payrolls for honoraria of consultants and other claimants for services performed.

- Payrolls for financial assistance for the BNS, BHWs, Bantay Lawa, SPES, MAFC, Senior Citizens, Scholars, calamity victims and etc.

- Cash advances for special projects/field operations, petty cash fund, emergency purchases and food for patients in our hospitals, inmates of the Women and Children in Crisis Center and Drug Rehabilitation Center in Magdalena, Laguna.

Disbursement vouchers for release of loans. Disbursement vouchers for payment of bank loans (principal and interest payments).

Labor payrolls for infrastructure projects undertaken by administration.

Claims for goods and services delivered and infrastructure projects completed.

Other payments made for utilities expenses, repairs and maintenance of PPE, donations, membership dues, expenses related to seminars and training, remittances of trust liabilities and fund transfers.

TOTAL PAYROLLS – 15,329

TOTAL DISBURSEMENT VOUCHERS- 20,338

TOTAL LIQUIDATION REPORTS - 323

2. Participated in the physical count of all inventories, property, plant and equipment of the provincial government as member of the Physical Inventory Team.

3. Maintained index of payments made to suppliers, contractors and private individuals/organizations.

4. Maintained index of payments made to all employees and officers of the PGL.

5. Reviewed and certified propriety and completeness of supporting documents of liquidation reports of all cash advances.

6. Attended appraisal of properties recommended for disposal.

7. Prepared accountant’s advice of local check disbursements.

e

ACCOUNTING DIVISION

1. Prepared, reviewed and approved journal entry vouchers for the following financial transactions. – 33,000 JOURNAL ENTRY VOUCHERS.

a. Cash advances (includes the establishment of payroll and liabilities accounts)

b. Payments made to suppliers for delivery of supplies and materials and to constructors for infrastructure projects.

c. Payments for Utilities Expense, Repairs and Maintenance , donations, insurance, other prepayments and release of retention money.

d. Fund transfers.e. Payments of accounts payables.

f. Remittances to GSIS, PAG-IBIG, PHILHEALTH, BIR, LBP, QUEDANCOR, PNB and DBP.

g. Receipts and deposits of all income accounts, funds received as subsidy and/or trust fund from the national and other government or non-government agencies and organizations.

h. Receipts of receivables.i. Liquidations of all cash advances granted.j. Issuances of supplies and materials.k. Dropping of disposed/condemned assets.l. Setting up of payables, receivables and other unearned

income and accruals of expenses.m.Other adjusting and closing entries.

2. Monitored and verified all subsidiary ledgers.3. Prepared monthly bank reconciliation statements and

quarterly bank, accounting and treasury reconciliation statements.

General Fund – 10 bank accounts Special Education Fund – 1 bank account Trust Fund - 7 bank accounts4. Prepared Quarterly Status of Cash Advances Granted to

Disbursing Officers and to Employees and the preparation of demand letters to the accountable officers.

5. Issued Certificates of Clearances as to Cash Accountabilities.6. Issued certificates of availability of funds.7. Prepared and submitted liquidation reports for trust funds

received from national government agencies and other non-governmental organizations.

8. Submitted monthly and year-end financial statements. (12 SETS each for General Fund, SEF and Trust Fund)

GOVERNORPROVINCIAL LEGISLATIVE BODY/SANGGUNIANPROVINCIAL TREASURERCOMMISSION ON AUDIT

PAYROLL AND REMITTANCE DIVISION

1. Updated computation of monthly salaries by posting salary deductions and printed payrolls of permanent employees and corresponding remittance lists.

2. Prepared remittance vouchers of various payroll deductions and corresponding government shares.

3. Issued certifications pertaining to Salaries and Deductions.

4. Issued certifications of remittances.

5. Created Electronic Remittance File (ERF) for GSIS Premiums and Loans of all employees every month (including additional premiums applicable to salary increments).

7. Prepared and submitted to the BIR the Alphalist (Alphabetical List of Employees from whom Taxes were withheld) and certified BIR Forms 2316.

8. Approved GSIS loans through G-WAPS.

ADMINISTRATIVE DIVISION

Provides administrative services, such as, but not limited to :

1. Prepared annual budget and project procurement management plan of accounting department.

2. Monitored, checked, and verified employees’ daily attendances.3. Prepared and submitted reports of employees’ tardiness and

absenteeism.4. Maintained inventory file of equipment of Accounting Office.5. Prepared documents for procurement of office supplies and

equipment and prepares appropriate documents pertaining to distribution of supplies and equipment to employees.

6. Recorded and filed incoming and outgoing letters, communication, memoranda, office reports and other official documents.

7. Management of Personnel File.8. Maintained cleanliness and orderliness of the office.

FINANCIAL REPORTSFISCAL YEAR 2010

PROVINCE OF LAGUNAGENERAL FUNDBALANCE SHEET

AS OF DECEMBER 31, 2010

PROVINCE OF LAGUNAGENERAL FUNDBALANCE SHEET

AS OF DEC. 31,2010

CURRENT ASSETS1758471350.76

59%

INVESTMENTS56000067.07

2%

PROPERTY, PLANT AND EQUIPMENT1141793079.26

38%

OTHER ASSETS47604945.57

2%

TOTAL ASSETS₱ 3,003,869,442.66

CURRENT ASSETS

INVESTMENTS

PROPERTY, PLANT AND EQUIPMENT

OTHER ASSETS

General Fund

CASH1138413658.75

64.74%

RECEIVABLES230062938.61

13.08%

INVENTORIES383192528.76

21.79%

PREPAYMENTS3819944.87

0.22%

OTHER CURRENT ASSETS2982279.77

0.17%

CURRENT ASSETS₱ 1,758,471,350.76

CASH

RECEIVABLES

INVENTORIES

PREPAYMENTS

OTHER CURRENT ASSETS

General Fund

CURRENT LIABILITIES285970699.47

10% LONG TERM LIABILITIES162500000

5%DEFERRED CREDITS

55818669.622%

GOVERNMENT EQUITY2499580073.57

83%

TOTAL LIABILITIES AND EQUITY₱ 3,003,869,442.66

CURRENT LIABILITIES

LONG TERM LIABILITIES

DEFERRED CREDITS

GOVERNMENT EQUITY

GENERAL FUND

TOTAL ASSETS3003869442.66

50%

TOTAL LIABILITIES504289369.09

8%

TOTAL EQUITY2499580073.57

42%

BALANCE SHEETASSETS = LIABILITIES AND EQUITY

TOTAL ASSETS

TOTAL LIABILITIES

TOTAL EQUITY

General Fund

PROVINCE OF LAGUNAStatement of Operations

For the Year Ended December 31, 2010

GENERAL FUND (Laguna University)

Income 31,182,320.00P Add : Unappropriated Surplus, Beg. 31,325,915.61P Continuing/Unexpended Allotments, Beg. 3,859,638.98 35,185,554.59 Total 66,367,874.59P Less : Expenditures Personal Services 9,663,971.03P Maintenance and Other Operating Services 7,188,332.20 Capital Outlay 1,559,432.52 Total 18,411,735.75 Balance 47,956,138.84P Less : Expenditures Charged to Continuing Appropriations/Allotments Unexpended Allotments, Capital Outlay 1,871,274.22 Net Results of Operations 46,084,864.62P

Breakdown: Unapppropriated Surplus, end 41,880,932.38P Continuing/Unexpended Allotments, end 4,203,932.24 Total 46,084,864.62P

PROVINCE OF LAGUNAStatement of Operations

For the Year Ended December 31, 2010

GENERAL FUND ( Exclusive of Laguna University )

Income 1,842,181,648.07P Add : Supplemental Budget Nos. 1 to 4 340,630,000.00 Total 2,213,993,968.07

Add : Unappropriated Surplus, Beginning net of SB's 895,771.04P Continuing/Unexpended Allotments, Beg.net of SB 115,854,221.55 Continuing/Unallotted Appropriations, Beg. 36,277,608.91 153,207,601.50 Total 2,335,839,249.57P Less : Expenditures Personal Services 607,884,940.22P Maintenance and Other Operating Services 860,463,870.73 Capital Outlay 231,965,336.35 Financial Expenses 57,742,139.03 Total 1,758,056,286.33 Balance 577,782,963.24P Less : Expenditures Charged to Continuing Appropriations/Allotments Unexpended Allotments, Capital Outlay 76,582,528.01P Unallotted Appropriations, Capital Outlay 24,553,922.13 101,136,450.14 Excess of Income Over Expenditures 476,646,513.10P Add : Net of Prior Years' Adjustments 13,515,240.59 Net Results of Operations 490,161,753.69P

Breakdown: Unapppropriated Surplus, end 133,118,887.75P Continuing/Unexpended Allotments, end 110,786,193.24 Continuing/Unallotted Appropriations 246,256,672.70 Total 490,161,753.69P

PROVINCE OF LAGUNAStatement of Operations

For the Year Ended December 31, 2010

GENERAL FUND

Income P 1,873,363,968.07

Add : Supplemental Budget Nos. 1 to 4 340,630,000.00

TotalP 2,213,993,968.07

Add : Unappropriated Surplus, Beg. (net of SBs) P 32,221,686.65

Continuing/Unexpended Allotments, Beg(net of SBs)

119,713,860.53

Continuing/Unallotted Appropriations, Beg. 36,277,608.91

188,213,156.09

Total P 2,402,207,124.16

Less : Expenditures

Personal Services P 617,548,911.25

Maintenance and Other Operating Services 867,652,202.93

Capital Outlay 233,524,768.87

Financial Expenses 57,742,139.03

Total 1,776,468,022.08

Balance P 625,739,102.08

Balance P 625,739,102.08

Less : Expenditures Charged to Continuing Appropriations/Allotments Unexpended Allotments, Capital Outlay

P 78,453,802.23

Unallotted Appropriations, Capital Outlay

24,553,922.13

103,007,724.36

Excess of Income Over Expenditures P 522,731,377.72

Add : Net of Prior Years' Adjustments 13,515,240.59

Net Results of Operations P 536,246,618.31

Breakdown:

Unapppropriated Surplus, end P174,999,820.13

Continuing/Unexpended Allotments, end

114,990,125.48

Continuing/Unallotted Appropriations

246,256,672.70

Total P536,246,618.31

PROVINCE OF LAGUNAComparative Statements of Operations

For the Years Ended December 31, 2010 and 2009GENERAL FUND

2010 2009

Income 1,873,363,968.07P 1,748,051,922.75P

Add : Supplemental Budget/s for the year 340,630,000.00 46,758,004.68 Total 2,213,993,968.07P 1,794,809,927.43P

Add : Unappropriated Surplus, Beginning net of SB's 32,221,686.65P 20,136,794.70P

Continuing/Unexpended Allotments, Beg.net of SB's 119,713,860.53 36,428,940.50

Continuing/Unallotted Appropriations, Beg.net of SB's 36,277,608.91 119,460,000.00

Total 188,213,156.09 176,025,735.20 Total 2,402,207,124.16P 1,970,835,662.63P

Less : Expenditures

Personal Services 617,548,911.25P 534,991,970.12P

Maintenance and Other Operating Expenses 867,652,202.93 737,179,429.95

Capital Outlay 233,524,768.87 148,623,928.38

Financial Expenses 57,742,139.03 60,265,802.92

Total 1,776,468,022.08 1,481,061,131.37 Balance 625,739,102.08P 489,774,531.26P

Less : Expenditures Charged to Continuing

Appropriations/Allotments

Unexpended Allotments, Capital Outlay 78,453,802.23P 17,307,035.91P

Unallotted Appropriations, Capital Outlay 24,553,922.13 67,080,391.09

Total 103,007,724.36P 84,387,427.00P

Excess of Income Over Expenditures 522,731,377.72P 405,387,104.26P

Add : Net of Prior Years' Adjustments 13,515,240.59 3,456,051.83

Net Results of Operations 536,246,618.31P 408,843,156.09P

Breakdown :

Unapppropriated Surplus 174,999,820.13P 171,851,686.65P

Continuing/Unexpended Allotments 114,990,125.48 165,713,860.53

Continuing/Unallotted Appropriations 246,256,672.70 71,277,608.91

Total 536,246,618.31P 408,843,156.09P

PROVINCE OF LAGUNASPECIAL EDUCATION FUND

BALANCE SHEETAS OF DECEMBER 31, 2010

CURRENT ASSETS237557896.63

12.65%

PROPERTY, PLANT AND EQUIPMENT1639936184.13

87.33%

OTHER ASSETS3403750.02%

TOTAL ASSETS1,877,834,455.76

CURRENT ASSETS

PROPERTY, PLANT AND EQUIPMENT

OTHER ASSETS

Special Education Fund

CURRENT LIABILITIES44955657.61

2%

GOVERNMENT EQUITY1832878798.15

98%

TOTAL LIABILITIES AND EQUITY1,877,834,455.76

CURRENT LIABILITIES

GOVERNMENT EQUITY

Special Education Fund

TOTAL ASSETS1877834455.76

50%

TOTAL LIABILITIES44955657.61

1%

TOTAL EQUITY1832878798.15

49%

BALANCE SHEETASSETS = LIABILITIES AND EQUITY

TOTAL ASSETS

TOTAL LIABILITIES

TOTAL EQUITY

Special Education Fund

PROVINCE OF LAGUNAComparative Statements of Operations

For the Years Ended December 31, 2010 and 2009SPECIAL EDUCATION FUND

2010 2009

Income 180,507,666.68P 257,600,454.51P Add : Supplemental Budget/s for the year 130,333,468.28 33,000,000.00 Total 310,841,134.96P 290,600,454.51P

Add : Unappropriated Surplus, Beginning net of SB's 52,313,866.64P 48,952,565.21P Continuing/Unexpended Allotments, Beg.net of SB's 4,334,705.00 24,917,833.28 Continuing/Unallotted Appropriations, Beg.net of SB's Total 56,648,571.64 73,870,398.49 Total 367,489,706.60P 364,470,853.00P Less : Expenditures Personal Services 4,041,835.30P 9,844,589.57P Maintenance and Other Operating Expenses 120,602,496.89 28,471,426.34 Capital Outlay 99,160,691.34 125,723,137.17 Financial Expenses Total 223,805,023.53 164,039,153.08 Balance 143,684,683.07P 200,431,699.92P Less : Expenditures Charged to Continuing Appropriations/Allotments Unexpended Allotments, Capital Outlay 4,334,705.00P 13,449,660.00P Unallotted Appropriations, Capital Outlay Total 4,334,705.00P 13,449,660.00P

Excess of Income Over Expenditures 139,349,978.07P 186,982,039.92P Add : Net of Prior Years' Adjustments 5,405,495.34 Net Results of Operations 144,755,473.41P 186,982,039.92P

Breakdown : Unapppropriated Surplus 86,078,784.75P 175,513,866.64P Continuing/Unexpended Allotments 57,446,688.66 11,468,173.28 Continuing/Unallotted Appropriations 1,230,000.00 Total 144,755,473.41P 186,982,039.92P