Automating P&L Reporting for a US Fiber-Optic Telecommunications Provider

InfoVision delivered an AI-powered Finance Automation Platform for a leading US fiber-optic telecommunications provider, replacing a fully manual, Excel-dependent monthly P&L process with a governed, automated web application. The engagement showcases InfoVision’s ability to embed AI natively in the development lifecycle. The result: thousands of GL rows processed automatically each month, zero manual spreadsheet operations, and full audit traceability, transforming a slow, error-prone finance workflow into a reliable, scalable reporting platform.

About the Customer

The customer is an American telecommunications company operating a high-speed fiber-optic broadband network across the Pacific Northwest. Its finance team manages a complex multi-segment General Ledger (GL) structure that feeds monthly Profit & Loss reporting across the organization.

Business Challenge

Each month, the finance team produced P&L reports by manually extracting Trial Balance data from the Infinium GL system, trimming account codes, running VLOOKUPs, and refreshing pivot tables. The process had become operationally unsustainable:

• Time-consuming: significant analyst hours were consumed each reporting cycle with no automation
• Error-prone: manual data handling across thousands of GL rows with no systematic validation
• Unauditable: no versioning, change tracking, or accountability trail existed for any mapping decisions
• Structurally fragile: 99 new GL codes were added every month, requiring Excel reports to be rebuilt from scratch each cycle

The business needed a scalable, automated, and auditable solution that could eliminate manual dependency and give the finance leadership real-time visibility into P&L performance.

InfoVision’s Solution

InfoVision designed and delivered a purpose-built Finance Automation Platform.  This platform comprised a full-stack web application that automated the end-to-end P&L generation process, replacing Excel entirely and introducing enterprise-grade governance. The platform was built across five core components:

• Trial Balance Rollup Engine
  A two-layer automated ingestion pipeline processing 15,000 to 16,000 GL rows per month. It parses account codes across six segments and classifies them against 15,646 entries into a six-level financial hierarchy, replacing all manual VLOOKUP-based mapping.
• P&L Computation Engine
  Programmatic computation of Gross Profit, EBITDA, EBIT, and Net Income directly from Trial Balance data, delivered through an interactive web-based P&L system with drill-down capability and one-click Excel export.
• Fallout Queue Management
  Automated identification and prioritization of unmapped GL accounts, sorted by financial frequency, allowing the finance team to resolve gaps without developer involvement.
• Admin and Audit Framework
  A self-service admin console for managing GL code additions and Revenue/OpEx mappings, with full change versioning (user, timestamp, before and after values) and role-based access control across Admin, Finance User, and Read-Only roles.
• SSO-Enabled Web Application
  A secure enterprise web interface with Single Sign-On via corporate Identity Provider using JWT RS256 token authentication, replacing spreadsheet workflows with a governed, accessible platform.

Business Impact

The platform delivered measurable operational and financial impact across the client’s reporting function:

Operational Efficiency

• Eliminated the multi-step manual Excel process from the monthly reporting cycle entirely
• Self-service admin console removed dependency on developers for all GL maintenance tasks
• Fallout Queue prioritization significantly reduced time spent resolving unmapped accounts

Financial Accuracy and Governance

• Automated computation of all P&L KPIs
• Full change versioning with user, timestamp, and before/after audit trail for every mapping decision
• Consistent, repeatable P&L output with no manual reformatting or reconciliation risk

Scalability

• Platform absorbs 99+ new GL codes added each month without requiring any report rebuilding
• Six-level financial hierarchy classification supports the client’s complex multi-segment P&L structure
• Architecture designed to scale with growing GL complexity over time

Finance Leadership Visibility

• Web-based P&L dashboard with interactive drilldowns replaces static monthly report delivery
• One-click Excel export supports downstream stakeholder distribution
• Real-time access eliminates the wait-for-report cycle for finance leadership

Why InfoVision

InfoVision combined deep ERP integration experience, full-stack engineering capability, and an AI-accelerated delivery model to transform a process that had long been accepted as a manual burden. Claude AI was embedded natively into the development lifecycle enabling a lean team to deliver a production-grade enterprise platform with speed and precision.