Scribd
Upload
66 views4 pages

Aging of Receivables Consolidated As of December 31, 2018 Age

The document summarizes accounts receivable, loans receivable, amounts due from other government agencies and local government units, amounts due from officers and employees, other receivables, and advances to contractors as of December 31, 2018. It breaks down the amounts by age, showing amounts that are 30-60 days, 61-1 year, 1-2 years, and over 2 years past due. The largest amounts past due were loans receivables of over $4 million over 2 years past due, amounts due from officers/employees of over $5 million over 2 years past due, and advances to contractors with nearly $1 million over 2 years past due.

Uploaded by

Jonson Palmares
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
66 views4 pages

Aging of Receivables Consolidated As of December 31, 2018 Age

The document summarizes accounts receivable, loans receivable, amounts due from other government agencies and local government units, amounts due from officers and employees, other receivables, and advances to contractors as of December 31, 2018. It breaks down the amounts by age, showing amounts that are 30-60 days, 61-1 year, 1-2 years, and over 2 years past due. The largest amounts past due were loans receivables of over $4 million over 2 years past due, amounts due from officers/employees of over $5 million over 2 years past due, and advances to contractors with nearly $1 million over 2 years past due.

Uploaded by

Jonson Palmares
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

AGING OF RECEIVABLES

CONSOLIDATED
As of December 31, 2018

Age
AGENCY AMOUNT
30-60days 61-I Year 1 to 2 Years 2 Years or more
Accounts Receivable
Laur Water System
5,535,297.24 3,299,196.00 1,515,252.00 720,849.24
Concessionaires
EnzobennJohn Canteen 1,050.00 1,050.00
Old Accounts 21,249.85 21,249.85
(No Supporting
Subsidiary Ledger)
Total 5,557,597.09 1,050.00 3,299,196.00 1,515,252.00 742,099.09
Loans Receivables
AECID Livelihhod
Beneficiaries
4,380,636.00 4,380,636.00

Total 4,380,636.00 - - - 4,380,636.00


Due from NGAs
Old Accounts 870,416.00 870,416.00
Total 870,416.00 - - - 870,416.00

Due to GOCCs
Old Accounts 289,494.17 289,494.17
(No Supporting
Subsidiary Ledger)
Total 289,494.17 - - - 289,494.17
Due from LGUs
SEA K funds-Livelihood 13,895.10 13,895.10
Old Accounts 108,096.66 108,096.66
(No Supporting
Subsidiary Ledger)

Total 121,991.76 - - 13,895.10 108,096.66

Due from Other Funds 10,377,399.55 5,515,308.18 - 3,178,520.26 1,683,571.11

Due from Officers and


Employees
Alvaro G. Daus 1,502,420.00 1,502,420.00
Blas A. Canlas 3,614,732.00 3,614,732.00
Total 5,117,152.00 - - - 5,117,152.00

Other Receivables
Catalino Padilla 3,000.00 3,000.00
Aurea Reyes 11,732.65 11,732.65
Luningning Villaroman 8,622.00 8,622.00
Giovanni Agtay 5,000.00 5,000.00
Agueda Santos 981,690.39 981,690.39
Yolanda Dumaya 419,489.94 419,489.94
Concepcion Paras 8,250.00 8,250.00
Old Accounts 29,046.42 29,046.42
(No Supporting
Subsidiary Ledger)
TOTAL 1,466,831.40 - - - 1,466,831.40

Advances To
Contractors
Riverville Drilling
Services 18,483.03 18,483.03
JRS Constuctions 95,141.19 95,141.19
Forthright Construction 235,687.02 235,687.02
Framecon Builders 67,420.80 67,420.80
Sinat Engr. And
Consultancy Services 67,200.00 67,200.00
EA Padilla Builders 74,493.09 74,493.09
CADV Construction 85,508.84 85,508.84
CADV Construction 165,266.59 165,266.59
Old Accounts 158,203.97 158,203.97
(No Supporting
Subsidiary Ledger)
Jerry R. Santiago 172,800.02 172,800.02
Romantico Juatco 299,702.88 299,702.88
TOTAL 1,439,907.43 325,268.52 67,200.00 67,420.80 980,018.11
Age
Particulars Amount
30-60days 61-I Year 1 to 2 Years2 Years or more
Accounts Receivable
Laur Water System Concessionaires ### ### ### 720,849.24
EnzobennJohn Canteen 1,050.00 1,050.00
Old Accounts 21,249.85 21,249.85
Total ### 1,050.00 ### ### 742,099.09
Loans Receivables
AECID Livelihhod Beneficiaries ### ###

Total ### - - - ###


Due from NGAs
Old Accounts 870,416.00 870,416.00
Total 870,416.00 - - - 870,416.00

Due to GOCCs
Old Accounts 289,494.17 289,494.17
(No Supporting Subsidiary Ledger)
Total 289,494.17 - - - 289,494.17
Due from LGUs
SEA K funds-Livelihood 13,895.10 13,895.10
Old Accounts 108,096.66 108,096.66
Total 121,991.76 - - 13,895.10 108,096.66

Due from Other Funds ### ### - ### ###

Due from Officers and


Employees
Alvaro G. Daus ### ###
Blas A. Canlas ### ###
Total ### - - - ###

Other Receivables
Catalino Padilla 3,000.00 3,000.00
Aurea Reyes 11,732.65 11,732.65
Luningning Villaroman 8,622.00 8,622.00
Giovanni Agtay 5,000.00 5,000.00
Agueda Santos 981,690.39 981,690.39
Yolanda Dumaya 419,489.94 419,489.94
Concepcion Paras 8,250.00 8,250.00
Old Accounts 29,046.42 29,046.42
TOTAL ### - - - ###

Advances To Contractors
Riverville Drilling Services 18,483.03 18,483.03
JRS Constuctions 95,141.19 95,141.19
Forthright Construction 235,687.02 235,687.02
Framecon Builders 67,420.80 67,420.80
Sinat Engr. And Consultancy
67,200.00 67,200.00
Services
EA Padilla Builders 74,493.09 74,493.09
CADV Construction 85,508.84 85,508.84
CADV Construction 165,266.59 165,266.59
Old Accounts 158,203.97 158,203.97
Jerry R. Santiago 172,800.02 172,800.02
Romantico Juatco 299,702.88 299,702.88
TOTAL ### 325,268.52 67,200.00 67,420.80 980,018.11

You might also like