Meta PixelAnnual Audit Report 2024 — Province of Negros Oriental — Page 30

Page 30 of 161

Page 30
  SUMMARY OF RECEIVABLES:                                                                2024                                 2023
 Loans and Receivable Accounts                                                       ₱   1,831,092.96                  ₱      1,819,964.59
 Inter-Agency Receivables                                                               91,635,078.36                        88,643,773.40
 Intra-Agency Receivables                                                               49,934,080.32                         9,435,272.73
 Advances                                                                               60,491,396.71                        58,535,702.78
 Other Receivables                                                                      93,062,196.52                        89,577,751.52
 Total                                                                               ₱ 296,953,844.87                 ₱     248,012,465.02

As of December 31, 2024, the ageing analysis of receivables is as follows:

                                          Current up to      31 days to         >1 yr up to      >2yrs up to
   Code               Account                                                                                       >5 Years            Total
                                              30d              1 year              2 yrs            5 yrs
 10301020      RPT Receivable                      0.00               0.00               0.00             0.00              0.00              0.00
 10301060      Loans Receivable-LGU                0.00               0.00              0.00              0.00        270,666.67        270,666.67
 10301070      Interests Receivable          169,165.44               0.00              0.00              0.00              0.00        169,165.44
 10301990      Loans Receivables-O                 0.00               0.00              0.00              0.00      1,391,260.85      1,391,260.85
 10303010      Due from NGAs                       0.00         200,000.00      3,622,284.25      2,852,000.00      2,229,070.10      8,903,354.35
 10303020      Due from GOCCs                      0.00               0.00              0.00              0.00        125,000.00        125,000.00
 10303030      Due from LGUs              21,590,289.33      27,954,483.33     22,582,145.43      5,254,745.22      6,874,734.11     84,256,397.42
 10304050      Due from Other Funds       40,583,656.14         213,657.22          2,153.00        188,691.91      8,945,922.05     49,934,080.32
               Advances for                                                                                                           4,344,895.06
 10305010                                  1,844,543.00       1,623,600.00        496,500.00              0.00        380,252.06
               Operating Expenses
 10305020      Advances for Payroll          658,282.25         327,927.91             (0.01)            (3.88)     2,415,903.72      3,402,109.99
 10305030      Adv. Disbursing Officer             0.00      16,898,550.00     26,452,626.00      3,500,000.00      3,484,977.77     50,336,153.77
               Advances for Officers                                                                                                  2,408,237.89
 10305040                                          0.00         465,734.29        199,591.68        825,984.00        916,927.92
               and Employees
               Receivables-                                                                                                          25,096,321.86
 10306010                                          0.00         319,428.00      6,945,000.00     17,374,860.82        457,033.04
               Disallowances/Charges
               Due from Officers and                                                                                                    804,105.29
 10306020                                          0.00         103,797.72        109,896.98        242,793.85        347,616.74
               Employees
 10306030      Due from NGOs/POs                    0.00      1,000,000.00               0.00       400,000.00      4,467,050.00      5,867,050.00
 10306990      Other Receivables            7,000,000.00     14,806,161.00     32,769,623.86      1,142,641.22      6,687,642.96     62,406,069.04
 Total Receivables                        ₱71,845,936.16    ₱63,913,339.47    ₱93,179,821.19    ₱31,781,713.14    ₱38,994,057.99   ₱299,714,867.95
 Total Allowance for Impairment                                                                                                       2,761,023.08
 Total Receivables, Net of Allowance for Impairment                                                                                ₱296,953,844.87


As of December 31, 2023, the ageing analysis of receivables is as follows:

                                          Current up to      31 days to        >1 yr up to       >2yrs up to
   Code               Account                                                                                       >5 Years            Total
                                               30d             1 year             2 yrs             5 yrs
 10301020      RPT Receivable                       0.00              0.00              0.00              0.00              0.00              0.00
 10301060      Loans Receivable-LGU                 0.00              0.00              0.00              0.00        270,666.67        270,666.67
 10301070      Interests Receivable           158,037.07              0.00              0.00              0.00              0.00        158,037.07
 10301990      Loans Receivables-O                  0.00              0.00              0.00              0.00      1,391,260.85      1,391,260.85
 10303010      Due from NGAs                  622,284.25      3,000,000.00              0.00      2,852,000.00      2,229,070.10      8,703,354.35
 10303020      Due from GOCCs                       0.00              0.00              0.00        125,000.00      1,500,000.00      1,625,000.00
 10303030      Due from LGUs               22,083,556.03     23,446,196.55     18,091,048.78      9,239,277.21      7,105,013.89     79,965,092.46
 10304050      Due from Other Funds           130,537.01        168,131.53          4,703.00        185,979.14      8,945,922.05      9,435,272.73
               Advances for
 10305010                                   3,919,446.50         42,818.70               0.00             0.00        380,252.06      4,342,517.26
               Operating Expenses
 10305020      Advances for Payroll          341,632.38              (0.01)            (2.57)            (1.31)     2,415,903.72      2,757,532.21
 10305030      Adv. Disbursing Officer       870,000.00      41,269,089.00      3,500,000.00        318,835.13      3,259,913.45     49,217,837.58
               Advances for Officers
 10305040                                           0.00        450,863.81         25,984.00        821,240.00        919,727.92      2,217,815.73
               and Employees
               Receivables-
 10306010                                   6,945,000.00              0.00     21,969,725.59        588,499.40        481,033.04     29,984,258.03
               Disallowances/Charges
               Due from Officers and
 10306020                                           0.00        388,709.39        167,777.61         76,018.05        352,688.94        985,193.99
               Employees
 10306030      Due from NGOs/POs                    0.00        250,000.00        200,000.00        200,000.00      4,467,050.00      5,117,050.00
 10306990      Other Receivables            2,850,000.00     42,311,094.60        609,170.39      2,142,641.22      6,689,692.96     54,602,599.17
 Total Receivables                        ₱37,920,493.24   ₱111,326,903.57    ₱44,568,406.80    ₱16,549,488.84    ₱40,408,195.65   ₱250,773,488.10
 Total Allowance for Impairment                                                                                                       2,761,023.08
 Total Receivables, Net of Allowance for Impairment                                                                                ₱248,012,465.02




                                                                                                                                                25