Households
4,286
Active waste accounts
Businesses
614
Active establishments
Waste Collectibles
₱1.84M
Waste billing YTD
Waste Collected
₱1.56M
84.8% efficiency
Complaints
28
Environmental cases
For Inspection
7
Complaint inspections
Tree Requests
38
No objection / clearance
Total Collected
₱1.66M
Waste + Other Collections
Waste Billing & Collection Trend
Monthly billed amount versus actual collection
Environmental Service Activity
Monthly complaints and tree-related requests
Complaint Type Analysis
Environmental complaints grouped by complaint type
Tree No Objection / Clearance by Request Type
Distribution of requests under the Tree No Objection / Clearance module
Household Registry
Maintain household accounts used for waste billing and collection.
Households
Registered household waste accounts
| Household ID | Household Head | Address | Members | Waste Account | Status | Action |
|---|---|---|---|---|---|---|
| HH-000124 | Roberto Santos | Barangay 2 · Purok 3 | 5 | Monthly Residential | Active | |
| HH-000125 | Maria Reyes | Barangay 4 · Mabini Road | 4 | Monthly Residential | Active | |
| HH-000126 | Pedro Lim | Barangay 3 · National Highway | 6 | Monthly Residential | Active | |
| HH-000127 | Liza Mendoza | Barangay 5 · Purok 1 | 3 | Monthly Residential | Inactive |
Household Details
Selected record
Household ID
HH-000124
Household Head
Roberto Santos
Address
Purok 3, Barangay 2, Barotac Nuevo, Iloilo
Members
5 Persons
Waste Fee
₱50.00 / Month
Reminder: Search the person's name first. If the person is not found, refer him/her to the People Registry Administrator for registration.
Business Registry
Maintain establishment records used for waste billing.
Business Accounts
Active and retired establishments
| Account No. | Business Name | Owner | Classification | Barangay | Monthly Fee | Status | Action |
|---|---|---|---|---|---|---|---|
| BUS-000031 | ABC Carwash | Juan Dela Cruz | Service Establishment | Barangay 3 | ₱100.00 | Active | |
| BUS-000032 | Sunrise Bakery | Ramon Flores | Food Establishment | Barangay 2 | ₱100.00 | Active | |
| BUS-000033 | JZH Chicken Poultry Farm | John Yap Ahhi | Agricultural Business | Barangay 4 | ₱150.00 | Active |
Waste Fee Settings
Configure waste billing rates used by household and business accounts.
| Fee Code | Account Type | Description | Billing Cycle | Amount | Status | Action |
|---|---|---|---|---|---|---|
| WF-001 | Household | Residential Waste Collection Fee | Monthly | ₱50.00 | Active | |
| WF-002 | Business | Commercial Waste Collection Fee | Monthly | ₱100.00 | Active |
Other Fee Settings
Fees for environmental certifications and clearances.
| Document / Service | Fee | Status | Action |
|---|---|---|---|
| Certificate of No Objection | ₱300.00 | Active | |
| Clearance for Tree Cutting | ₱300.00 | Active | |
| Clearance for Tree Trimming | ₱300.00 | Active | |
| Clearance for Tree Pruning | ₱300.00 | Active | |
| Clearance for Transport of Trees | ₱300.00 | Active |
Waste Billing
Generate, monitor, and collect household and business waste charges.
Billing Accounts
Current waste collectibles
| Account | Payer | Type | Billing Period | Collectible | Collected | Balance | Status |
|---|---|---|---|---|---|---|---|
| HH-000124 | Roberto Santos | Household | Jan–Aug 2026 | ₱400.00 | ₱400.00 | ₱0.00 | Paid |
| BUS-000031 | ABC Carwash | Business | Jan–Aug 2026 | ₱800.00 | ₱500.00 | ₱300.00 | With Balance |
Receive Payment
Sample split payment
Selected Account
BUS-000031 · ABC Carwash
Balance: ₱300.00
₱
₱
Environmental Complaint
Register complaints, conduct inspection, endorse validated cases, and monitor Mayor action.
Total Complaints28
Draft5
For Inspection7
Endorsed to Mayor5
Complaint Registry
Monitor complaint status and workflow
| Complaint No. | Subject | Complainant | Respondent | Barangay | Date Filed | Status | Action |
|---|---|---|---|---|---|---|---|
| EC-2026-0029 | Illegal Dumping Along Roadside | Pedro Cruz | For Verification | Barangay 2 | Aug 28, 2026 | Draft | |
| EC-2026-0028 | Alleged Fly Infestation | Maria Santos | JZH Poultry Farm | Barangay 4 | Jul 01, 2026 | For Inspection | |
| EC-2026-0024 | Open Burning of Garbage | Anonymous | Reyes Family | Barangay 5 | Aug 06, 2026 | Endorsed to Mayor | |
| EC-2026-0019 | Wastewater Discharge | Liza Mendoza | ABC Carwash | Barangay 3 | Jul 15, 2026 | For MENRO Action |
Complaint Process Flow
MENRO and Mayor-side status progression
1
Complaint Entry
Encode complaint and evidence.
Draft2
Inspection
Validate and upload inspection report.
For Inspection3
Endorse to Mayor
Forward validated complaint.
Endorsed to Mayor4
Mayor Disposition
Return official action document.
For MENRO Action5
MENRO Action
Receive and implement instructions.
Action ImplementedEnvironmental Action & Certification
Mayor-side review of MENRO-endorsed environmental complaints and tree certification / clearance requests.
Total Endorsed7
Complaints2
Tree Requests5
Returned to MENRO1
Endorsed Environmental Transactions
Incoming MENRO transactions requiring Mayor action
| Reference | Source | Subject / Document | Person / Applicant | Barangay | Requirement | Status |
|---|---|---|---|---|---|---|
| EC-2026-0024 | Complaint | Open Burning of Garbage | Anonymous / Reyes Family | Barangay 5 | Action / Disposition | For Review |
| TC-2026-0045 | Tree Request | Certificate of No Objection | Jufel Noreen T. Viajar | Brgy. Tabuc-Suba | Mayor Certification | For Review |
| TC-2026-0039 | Tree Request | Clearance for Tree Cutting | Maria Reyes | Barangay 4 | Mayor Clearance | Returned to MENRO |
Action / Disposition Document Preview
Official Mayor document
Republic of the Philippines
Province of Iloilo
Municipality of Barotac Nuevo
OFFICE OF THE MUNICIPAL MAYOR
ACTION / DISPOSITION REPORT
FOR COMPLIANCE
Reference: EC-2026-0024
Subject: Directive on Open Burning Complaint
After review of the MENRO endorsement and inspection findings, the respondent is directed to undertake the following:
- Cease open burning immediately.
- Allow MENRO compliance validation.
- Coordinate with concerned offices when necessary.
BRYANT PAUL Q. BIRON
Municipal Mayor
Tree No Objection / Clearance
Certificate of No Objection and tree cutting, trimming, pruning, and transport clearance requests.
Draft4
Endorsed3
Certificate Ready2
For Payment6
For Release5
Released18
Requests
Tree certification and clearance registry
| Request No. | Document Type | Requestor | Barangay | Tree Species | Fee | Status | Action |
|---|---|---|---|---|---|---|---|
| TC-2026-0045 | Certificate of No Objection | Jufel Noreen T. Viajar | Brgy. Tabuc-Suba | Mahogany & Coconut | ₱300.00 | Endorsed | |
| TC-2026-0039 | Clearance for Tree Cutting | Maria Reyes | Barangay 4 | Acacia | ₱300.00 | Certificate Ready | |
| TC-2026-0036 | Clearance for Tree Trimming | Pedro Lim | Barangay 3 | Narra | ₱300.00 | For Payment |
Tree Request Workflow
MENRO → Mayor → Payment → Release
1
Request Details
Applicant, property, trees, and requirements.
Draft2
MENRO Endorsement
Prepare Endorsement Letter.
Endorsed3
Mayor Review
Prepare certificate / clearance.
For Review4
Returned to MENRO
Signed document is returned.
Certificate Ready5
Payment
Trigger payment process.
For Payment6
Release
Print and release document.
ReleasedRepublic of the Philippines
Municipal Government
Municipal Environment and Natural Resources Office
Collection Summary Report
January 01, 2026 to August 31, 2026
| Barangay | Household Collectible | Business Collectible | Total Collected | Outstanding |
|---|---|---|---|---|
| Barangay 1 | ₱120,000 | ₱38,000 | ₱142,500 | ₱15,500 |
| Barangay 2 | ₱146,000 | ₱41,000 | ₱168,400 | ₱18,600 |
| Barangay 3 | ₱132,500 | ₱44,000 | ₱153,300 | ₱23,200 |
Report Filters
Report coverage and output
Republic of the Philippines
Municipal Government
Municipal Environment and Natural Resources Office
Environmental Complaint Report
January 01, 2026 to August 31, 2026
| Complaint No. | Date Filed | Type | Barangay | Subject | Status |
|---|---|---|---|---|---|
| EC-2026-0028 | Aug 30 | Illegal Dumping | Barangay 2 | Roadside dumping | For Inspection |
| EC-2026-0024 | Aug 27 | Waste / Sanitation | Barangay 5 | Open Burning | Endorsed |
| EC-2026-0019 | Jul 15 | Water / Drainage | Barangay 3 | Wastewater Discharge | For MENRO Action |
Report Filters
Environmental service reports
Audit Trail
System-wide activity history for accountability and monitoring.
| Date / Time | User | Office | Module | Activity | Reference | IP / Device |
|---|---|---|---|---|---|---|
| Sep 16, 2026 · 09:14 AM | MENRO Admin | MENRO | Environmental Complaint | Endorsed complaint to Mayor | EC-2026-0024 | Municipal Network |
| Sep 16, 2026 · 09:03 AM | MENRO Staff | MENRO | Environmental Complaint | Uploaded inspection report | EC-2026-0028 | Municipal Network |
| Sep 16, 2026 · 08:42 AM | Mayor Office | Mayor | Action & Certification | Returned tree clearance | TC-2026-0039 | Municipal Network |
| Sep 16, 2026 · 08:15 AM | Collector | Treasury | Waste Billing | Posted payment | OR-004128 | Municipal Network |