JPS O&M Management Platform

Total O&M

—

YTD · Actual

🔒 Payroll & Benefits

—

vs Budget —

Non-Payroll O&M

—

vs Budget —

Total Variance (vs Bud)

—

Fav = under budget

Payroll % of Total

—

Budget: —

FY LE vs FY Budget

—

LE: — · Bud: —

R&O Impact on LE

—

Risk: — · Opp: —

Avg FX Rate (JMD/USD)

—

YTD average

Monthly O&M — Actual vs Budget vs LE

Actual vs Budget by Line (YTD)

O&M by Nature — YTD Summary

Apr 2026 YTD

Line Item	Actual	Budget	Variance	Var %	LE	LE vs Bud	FY LE	Full Year Bud	Run Rate%	💬
Loading…

Multi-Year O&M Trend

Quarterly Tracking

Cost Category Split (YTD)

FX Impact Analysis

💱

Select year and load data to see FX impact analysis

Payroll by Component — Monthly

Payroll vs Budget Waterfall

Payroll Detail by Nature

Component	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	YTD Actual	YTD Budget	YTD Var	FY Budget
Loading…

Payroll GL Drill — Cost Centre Summary

🔒 Confidential

Upload payroll GL data to see cost-centre breakdown

Non-Payroll Spend — Monthly Trend

Actual vs Budget by Line (YTD)

Non-Payroll O&M Detail

Line Item	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	YTD Actual	YTD Budget	Variance	Var%
Loading…

IFRS 16 — Lease Adjustments

Lease Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	YTD	FY Budget
No IFRS 16 data loaded

GL Transaction Search

—

GL Transactions

Period	CC	CI	FERC	Job No	Description	Tran Type	Amount (US$)	Amount (J$)
Upload GL data to enable drill-through

Risks & Opportunities Register

Category	Description	Amount (J$M)	Division	CIG	Impact Type	LE Date	Notes
Upload Risk & Opportunities file to populate register

FX Rate Schedule — JMD/USD

Period	Budget Rate	Actual/Forecast Rate	Variance	FX Impact (US$M)
Loading FX rates…

📂

Uploads moved to JPS Data Manager

All data uploads (GL, LE/Actuals, Payroll GL, FX Rates, Budget/AOP) are now centralised in the JPS Data Manager. This ensures a single source of truth and prevents duplicate uploads across platforms.

Open JPS Data Manager ↗

Available uploads: GL Actuals · Budget/AOP · O&M Data · Sales & Billing · Payroll GL · FX Rates

GL Transaction Detail Upload

Expects: Metabase Download format — sheet "YTD MAR 2026" or similar. Columns: Originated By, Posted Week, Sub Doc Type, Transaction Type, Item Name, Doc No, Doc Desc, Transact Line Num, Gl Period, Gl Accounts, Gl Journal Name + amount columns.

Payroll rows (FERC 92000) are automatically routed to the confidential payroll GL table. Non-payroll rows go to GL detail.

📂

Drop Excel file here or click to browse

Accepts .xlsx / .xls · Metabase YTD export format

Monthly LE / Actuals Upload

Expects: April OM 2026.xlsx format — "Consolidated" or entity sheet. Row labels in column B (01. PAYROLL, 02. OVERTIME…), month dates in row 1.

Entity: Version: Currency:

📊

Drop LE / Actuals Excel here

April OM 2026.xlsx style — Consolidated or entity sheet

Payroll GL Dump Upload

Expects: Metabase Download "Payroll Dump" sheet. Columns: Cc, Ci, FERC, Job No, then monthly period columns (January-26, February-26…).

🔒

Drop Payroll Dump Excel here

Metabase "Payroll Dump" sheet format

FX Rate Upload

Expects: FX Forecast format — row 1: header, row 2: "Budget 2026" with monthly rates in columns.

Rate Type:

💱

Drop FX Forecast Excel here

FX_Forecast_Mar2026 style

Risks & Opportunities Upload

Expects: Payroll Risks & Opportunities.xlsx format — columns: Categories, Amounts $(M), Division, CIG, cost type impact, LE adjustment dates, Notes.

⚠️

Drop Risks & Opps Excel here

Payroll Risks & Opportunities.xlsx format

Upload History

File	Type	Uploaded	Rows	Version	Status
No uploads yet

Scenario Analysis — Cost Reduction

Model cost reduction scenarios. Adjustments apply to all 12 months of the current LE. Positive % = savings. Apply to LE Grid writes to the LE Input page for review before submitting.

👷 Headcount Scenarios

Tip: Enter FTE reduction target. Avg cost/FTE derived from LE payroll ÷ implied headcount (J$'000/month). Net saving = FTE × avg × 12 months.

🔧 Non-Payroll Cost Reduction (%)

Effective From:

Apply across: 12 months

Impact Summary — Current LE vs Scenario

LE Input — Latest Estimate vs AOP

Currency:

LE Input (editable) AOP / Budget (read-only) Favourable variance Unfavourable variance

Loading…

⚡ LE Engine — How It Works

Step 1 — Closed Months

Periods marked closed by admin use the posted Actual as the LE. Locked — engine will not overwrite. Target: GL uploaded & period closed Day 1 AM.

Step 2 — Open Months

Open months use analyst-selected method per cost line: Auto run-rate, Manual amount, Hold flat, AOP, or Manual variance. R&O adjustments applied. Target: updated Day 1 PM.

Step 3 — Engine Run

Click Calculate & Write LE to upsert all LE rows. Run once per month after period close. Finance Manager reviews output. Target: Day 2 AM.

Step 4 — Submit

Dashboard LE column and FY LE card update immediately. Analyst submits to Finance Hub — version locked. Target: Day 2 PM. Full cycle: 2 working days.

Formula: LE (closed) = Actual | LE (open) = analyst method per line | FY LE = Σ all 12 months ± R&O | Target: 2-day close

Run Engine

Select entity and year, preview the output, then write to database. Recalculate after each month's actuals are posted.

Entity

Year

📊 LE Input — Per Month by Cost Line

Entity

Year

Select an entity to load the LE input grid.

🗺 Entity Cost Center Mapping

Map cost centers to entities for IPP_MAG, IPP_MUN, CB_ELEC, CB_STM. These don't appear as top-level divisions in the source GL — mappings drive how their costs are attributed during LE calculation and GL reporting.

Add Mapping

Cost Center

Cost Item Group (optional)

Entity

Note

Cost Center	Cost Item Group	Entity	Note	Action
Loading mappings…

👥 Users

➕ Invite User

⚡ LE Engine

🗺 Entity Mapping

🔍 Audit Trail

🗄 Data Management

🔐 Centralised User Management
User access for all JPS apps is managed centrally in the Admin Portal. Contact your system administrator to: invite new users, change roles, reset passwords, or deactivate accounts.

Platform Users

Email	Name	Role	Status	Updated	Actions
Loading…

Role definitions:
🔴 admin — full access, user management, data management, all payroll
🟣 payroll_analyst — payroll + non-payroll full access, upload, no admin
🟢 analyst — non-payroll full access, uploads (non-payroll), no payroll detail
⚪ viewer — non-payroll read-only, no uploads, no payroll

Invite New User

Creates a Supabase auth account. A temporary password is generated — share it with the user via a secure channel. They can change it on first login.

Full Name

Email Address

Platform Role

Audit Trail —

Timestamp	User	Role	Action	Target	Old Value	New Value
Loading audit trail…

⚡

LE Engine has moved

Use the LE Engine item in the left nav under LE Management.

🗺

Entity Mapping has moved

Manage cost center → entity mappings in the LE Engine page.

Data Management

⚠️ All operations below are irreversible. Each action is logged to the audit trail.