Meta PixelAnnual Audit Report 2024 — Municipality of Dauin — Page 43

Page 43 of 107

Page 43
2.3 The Municipal Accountant further stated that the assessment roll, which served as her
    basis for the computation of the RPT Receivable and SET Receivable, was provided
    to her by the Municipal Assessor at the end of the previous year. It was generated
    through the iTax System, software for taxation that the Municipality availed of from a
    private service provider.

2.4 Telephone inquiries with the Municipal Accountant and Municipal Treasurer revealed
    that the total assessed value of real properties reflected in the assessment roll as of
    December 31, 2023, which was generated through the iTax System, was overstated
    due to the duplication of real properties.

2.5 They explained that some real properties that had already been transferred through
    sale were listed in the system under both the previous and the new owners, treating
    them as separate properties. As a result, these were counted twice in the assessment
    roll.

2.6 In addition, properties that were originally under a mother title but later subdivided
    and sold to multiple vendees were still recorded in the iTax System under both the
    original mother title and the newly created subdivided lots, again resulting in
    duplication.

2.7 The Municipal Treasurer further stated that there is a possibility that real properties
    subjected to sale multiple times have been listed in the assessment roll under various
    owners. She mentioned that since the implementation of the iTax System in CY 2010,
    it has not been updated regarding the duplication of entries for real properties.

2.8 Both the Municipal Accountant and the Municipal Treasurer acknowledged that the
    Municipality's outdated iTax System resulted in an overstatement of the total assessed
    value of real properties, which served as the basis for calculating the RPT Receivable
    and SET Receivable. However, they were unable to readily determine the extent of
    the overstatement.

2.9 In view of the foregoing, the balance of RPT Receivable and SET Receivable
    accounts amounting to ₱10,401,020.48 and ₱10,889,513.31, respectively, as of
    December 31, 2024, is unreliable.

2.10 We recommended and Management agreed to identify all duplicate real
     property entries in the assessment roll and require the service provider of the
     iTax System to update and cleanse the database accordingly to ensure the
     accuracy of the assessed values used for tax receivable recognition.

2.11 We further recommended and the Municipal Accountant agreed to prepare the
     necessary adjusting entries to reflect the accurate balances of the RPT and SET
     Receivable accounts in the financial statements once the amount of
     overstatement of the RPT Receivable and SET Receivable is determined.



                                                                                        34