Skip to content
FY2026 GAA: ₱6.79T
PisoScan
Home
Records
Contract awardsInfrastructure projectsCharts & statistics
Entities
Top contractorsProcuring entitiesRegions, provinces & LGUs
Budget
National budget (GAA)Agency budgetsRegions & LGUsFollow the moneyBudget stagesFY2027 proposed budget
Blockchain demo
OverviewBlocksTransactionsHow it worksVerify the chainAPI & mirror kit
Audits
COA audit opinions (LGUs)
More
About PisoScanData sourcesOpen data & OCDS export
DemoFor public education only. These blocks are built by PisoScan from published PhilGEPS records to show how a budget ledger like CADENA would work. No government agency created or signed them, and this is not an official ledger. How it works

Transaction details

API
Transaction action

CITY OF MANDAUE, CEBU Award a ₱316.5K contract to JOHN ARNE CONSTRUCTIONCities

Transaction hash:
bdee3dcf496242cef556b433c89045db33afeaf7d06546eeba77348f91426b9c
Status:
Included and unchanged
Block:
#2,256 3,757 blocks after it
Position in block:
Transaction 2 of 4
Award day:
Nov 29, 2014 (11 yrs 11 mo ago)
From:
CITY OF MANDAUE, CEBU
To:
JOHN ARNE CONSTRUCTION
Value:
₱316,522.75
Project:
Repair of 2-storey 4 classroom SBP/Herrera MFCCCII
Full record:
Open the award page

Accountability

Bill Sec. 3 and 19
Responsible agency:
CITY OF MANDAUE, CEBU
Accountable officer:
Not stated in the source. PhilGEPS does not publish who certified the award.
Certification:
Not certified No agency signed this record. Under CADENA the accountable officer would sign it with their own key.
Demo signature:
Block #2,256 signature valid Demo key, proves nothing about the governmentPublic key

Linked records: from budget to payment

Bill Sec. 5
  1. 1. Appropriation
    GAA line item · Sec. 5(b)
    The award does not say which budget line pays for it.
    Not published
  2. 2. Allotment release
    SARO / allotment · Sec. 5(c)(iii)
    Not published per project. DBM releases SAROs, but not linked to individual contracts.
    Not published
  3. 3. Cash allocation
    Notice of Cash Allocation · Sec. 5(c)(iv)
    Not published per project.
    Not published
  4. 4. Contract award
    Notice of Award (PhilGEPS) · Sec. 5(d)
    CITY OF MANDAUE, CEBU awarded it to JOHN ARNE CONSTRUCTION on 2014-11-29.
    Found
    Open
  5. 5. Contract & progress
    Contract / progress report (DPWH) · Sec. 5(d)
    No matching DPWH contract record (only DPWH contracts are listed with progress).
    Not published
  6. 6. Payment
    Disbursement voucher · Sec. 5(c)(viii)
    Not published. No public source shows how much of this contract has been paid.
    Not published
  7. 7. Completion
    Certificate of completion · Sec. 5(d)
    No completion certificate published.
    Not published
  8. 8. Audit
    COA annual audit report · Sec. 5(e)(iii)
    COA's CY2024 audit of City of Mandaue gave a "qualified" opinion on its financial statements (not specific to this contract).
    Partly
    Open

1 of 8 documents found, 1 partly. Under CADENA every step would be published within 7 working days and linked to this record.

Tamper test: try changing this record

Demo

Edit the amount as if someone quietly changed the record. Your browser re-hashes it and walks up the chain. Nothing is saved.

  1. 1. Record fingerprint changed
    stored   bdee3dcf49…426b9cnow      …
  2. 2. Block Merkle root changed
    stored   ceabe163e3…d03debnow      …
  3. 3. Block #2256 hash changed
    stored   850fd8f689…2b6b52now      …
Chain intact. The record matches its fingerprint, so the block and every block after it still line up.

Merkle proof (2 steps)

How this one record is tied to the block's Merkle root, without needing the other 3 records. Each step hashes the current value together with the sibling shown.

  1. leaf  bdee3dcf496242cef556b433c89045db33afeaf7d06546eeba77348f91426b9c
  2. 01 R d450275dd378a412bf943a6019361ccac7a8e9de76be559614eb0d827c2d5de1
  3. 02 L e64ff27f8f0d7debba4260c49242977a0a0eff8c9fe277a54a34c8aef2f58b87
  4. root  ceabe163e3c5244ce8853667f29e6af3685c46153c87e63744cc4a9c6dd03deb