Case Experience
Billing Process & Timeline Reporting Enhancement for a Utility Company
Role: Business Process Manager / Billing & Settlement Supervisor
Confidentiality Statement: Due to client confidentiality, specific identifiers and data have been anonymized.
Background
I led the end-to-end mapping of a billing process for a mid-to-large-scale power generation company in the Philippines, operating within the Wholesale Electricity Spot Market (WESM) and bilateral contract arrangements. The project involved cross-functional coordination across Finance, Trading, Plant Operations, Tariff, Regulatory Compliance, and Sales teams, supporting an estimated 20 – 30+ stakeholders directly involved in the billing lifecycle. At the time, the organization had little to no fully documented or standardized billing workflow, with processes fragmented across departments, heavy reliance on manual data handling, and limited visibility into critical computations and settlement validation. Key challenges included inconsistent data sources, unclear ownership of tasks, tight regulatory timelines, and the need to align billing outputs with contractual and compliance requirements. I mapped the entire process architecture from scratch.
Details
• Led end-to-end optimization of the billing lifecycle for a country-wide power generation company, covering WESM participants and bilateral contract customers.
• Conducted detailed process reviews for metering data extraction, data validation, settlement reconciliation, invoicing, and collections monitoring.
• Developed a 1-page standardized billing timeline covering the monthly cycle responsibilities of the 18-member team.
• Collaborated with Finance, Trading, Operations, and Sales and Marketing teams to ensure alignment on market rules, energy contracts, and billing computations.
• Implemented controls for handling metering discrepancies, replacement data, and settlement variations affecting revenue.
• Created automated dashboards to track billing/invoice issuance status, receivable amount, and variance analysis.
Skills & Deliverables
The following links shows tutorials and how I used the tools in my projects.
• Billing Process Maps (BPMN) and SOP Documentation
• Standardized Reporting Structure / Billing Timeline
• Automated Excel Reporting Dashboards
• Data Validation Framework for Metering & Settlement Inputs
• RACI Matrix for Billing Responsibilities
• Billing Risk Register and Internal Control Points
Reconstructed Workflow
The workflow contains RACI notes to identify responsibilities and specify accountability. This also contains controls for audit and compliance evidence.
Mapping workflows with RACI (Responsible, Accountable, Consulted, Informed) and internal controls is crucial because it eliminates confusion in roles and ensures audit readiness. This structure is also great for automation references. Why? This streamlines automation by defining exactly what to automate, who authorizes changes, and how to maintain compliance. This way, trust is also built among large-scale operation because of data and process integrity.
Impact
• Sited for action billing submission delay by ~30–40% (based on validation gaps)
• Improved reporting turnaround time by 20–30%
• Increased confidence in process improvement
• Strengthened alignment with contractual obligations
Today, through Magayon Management Consultancy Services, I help organizations transform complex processes into structured systems that drive accuracy, efficiency and better decision-making.
Are you looking to hire to fix your messy process?
Contact me
LinkedIn Profile Send me a message to jalopez@libottayo.com
Tutorial: Excel Now Ph on YouTube
Life Update: Libot Tayo by Lily on Facebook
