Oilfield timesheets: keep job costing separate from payroll approval

Topics: oilfield timesheet software, oilfield labour cost allocation, job time approval, contractor timesheet records

The collision between statutory wage deadlines and oilfield cost accounting

In upstream oilfield services, drilling campaigns, and refinery turnarounds, a single field specialist's 12-hour tour serves four different accounting and legal purposes simultaneously:

1. Statutory Wage and Overtime Payment: Under the Ministry of Labour and Employment New Labour Codes, wages and overtime allowances must be calculated and disbursed within strict statutory settlement windows following the wage period.
2. Maintenance Work Order and Asset Costing: In SAP S/4HANA Cross-Application Time Sheet (CATS), craft labor hours transfer to Plant Maintenance (PM) orders (AUFK) or Project System (PS) Work Breakdown Structure (WBS) elements to build true equipment life-cycle cost histories.
3. Capitalization vs Expense Classification: Under Ind AS 16 (Property, Plant and Equipment), direct employee costs incurred in major turnaround overhauls, well workovers, or new facility commissioning qualify for capitalization only when linked to verified capital WBS elements; routine running maintenance and idle rig-standby hours must be expensed to OPEX immediately.
4. Joint Venture (JIB) and Customer Service Billing: On operated blocks or oilfield service contracts, labor hours must be split across Joint Venture partner AFEs or third-party reimbursable service tickets.

When ERP systems enforce a single combined approval gate—requiring both valid WBS/AFE cost receivers and commercial sign-off before a timesheet can transfer to HR Payroll (HR-PY)—two destructive behaviours emerge on every payroll cutoff day:

• Blocked Payslips from Costing Exceptions: If a workover AFE budget ceiling is exhausted on the 23rd of the month or a WBS element is locked for audit review, CATS rejects the entire timesheet transfer. The worker's payable hours fail to reach payroll even though they physically worked the shift.
• "Dump-Bucket" Cost Distortion: To avoid delaying their crew's pay, field supervisors bypass locked WBS elements by booking all 12 hours to whatever open "General Base Operations" cost centre accepts postings. The worker gets paid on time, but maintenance work orders show zero craft labor, capital projects under-record Ind AS 16 direct labor, and controllers spend weeks manually journaling lump-sum payroll estimates at quarter-end.

Takeaway: Decoupling payroll transfer from CO/PM/PS cost receiver status ensures workers are paid on time while preventing supervisors from hiding locked-AFE hours inside generic overhead cost centres.

Designing the two-track timesheet state machine

To maintain strict reconciliation between HR Payroll and Management Accounting (CO) in SAP S/4HANA CATS or equivalent oilfield ERP architectures, every timesheet record carries two independent status vectors tied to the same immutable timesheet_header_id:

1. Track A: payroll_approval_state

• Input Requirements: Employee ID, shift date, verified start/end timestamps, total worked hours (regular_hours, overtime_hours), location/hardship zone code, and Field Supervisor verification of physical presence.
• Independence Rule: payroll_approval_state transitions to APPROVED_FOR_PAYROLL as soon as the Field Supervisor and HR/Payroll Reviewer confirm presence and statutory working-time compliance—regardless of whether the target WBS element is locked for budget supplement or whether a customer has signed the field service ticket.
• Financial Posting: When payroll executes, gross wages debit the Payroll Labor Clearing / Absorption Account (GL 510900), establishing the exact financial denominator to be absorbed by activity cost allocations.

2. Track B: cost_and_billing_allocation_state

• Granular Activity Split: A single 12-hour tour is segmented into operational activity lines (activity_type, receiver_type, receiver_id, hours, capitalization_indicator, billable_entitlement_code).
• Ind AS 16 Capitalization Gate: Under Ind AS 16, only hours directly attributable to bringing an asset to the location and condition necessary for its intended operating capability (such as a major turnaround vessel internals replacement or new well completion) may be allocated to a Capital Work-in-Progress (CWIP) WBS element. Routine preventive inspection hours (PM01) and weather/rig standby hours (IDLE_STANDBY) are hard-blocked from posting to capital WBS receivers and must route to OPEX cost objects.
• Unallocated Labor Suspense Account (GL 510990): If a technician legitimately worked 4.0 hours on Work Order WO-2026-88412 linked to an AFE whose budget ceiling is temporarily exceeded, the supervisor still records intended_receiver = WO-2026-88412. Instead of failing the timesheet or forcing a fake cost-centre entry, the system posts those 4.0 hours temporarily to UNALLOCATED_LABOR_SUSPENSE with intended_receiver_id = WO-2026-88412 attached as metadata. The Asset Controller resolves the AFE supplement and clears the suspense queue before the T+3 month-end financial close.

Illustrative example (hypothetical scenario): 14-day hitch for a 15-person well-service crew

Illustrative scenario notice: All site volumes, defect counts, error rates, engineering hours, and INR (₹) figures below are hypothetical scenario assumptions constructed to demonstrate the control math and workflow gating. Any time or cost reductions represent modeled process/capacity estimates under these assumptions, not achieved client benchmark savings or guaranteed cash realization.

Consider a 15-person wireline and well-intervention crew working a 14-day offshore hitch (15 workers x 14 days = 210 worker-days), where each worker logs a 12.0-hour shift (10.0 regular hours + 2.0 overtime hours), totaling 2,520.0 total crew hours (2,100.0 regular hours + 420.0 overtime hours) at an internal standard absorption rate of INR 1,800 per hour (Total Labor Cost Pool = 2,520 x 1,800 = INR 4,536,000):

1. Track A (Payroll Execution at Day 15 Cutoff):
   • All 210 daily shift records (2,520.0 hours) are verified by the Well Site Supervisor against platform POB and shift logs.
   • 100.0% (2,520.0 hours, INR 4,536,000 standard cost absorption pool) transfers cleanly to HR Payroll on cutoff day with zero blocked payslips.
2. Track B (Activity Cost & Billing Classification across 2,520.0 hours):
   • 1,380.0 hours (54.76% — INR 2,484,000): Routine production well slickline maintenance across 8 open SAP PM work orders (OPEX_MAINTENANCE, BILLABLE_REIMBURSABLE). Approved immediately by Maintenance & Commercial Billing.
   • 660.0 hours (26.19% — INR 1,188,000): Major subsea Christmas tree overhaul and tubing hanger replacement under Capital WBS WBS-CAP-WELL14-OVHL (CAPEX_IND_AS_16_ELIGIBLE). However, 180.0 hours (INR 324,000) of this block hit a locked AFE supplement threshold on Day 11. Those 180.0 hours automatically park in UNALLOCATED_LABOR_SUSPENSE carrying intended_receiver = WBS-CAP-WELL14-OVHL, and are cleared by the Asset Controller on Day 16 once the AFE supplement is countersigned.
   • 300.0 hours (11.90% — INR 540,000): Rig waiting-on-weather (WOW) and crane wind-limit standby. The system blocks these 300.0 hours from being capitalized to WBS-CAP-WELL14-OVHL under Ind AS 16 rules and routes them to CC-OFFSHORE-STANDBY-OPEX (OPEX_NON_PRODUCTIVE_STANDBY, BILLABLE_STANDBY_RATE).
   • 180.0 hours (7.14% — INR 324,000): Tool redressing rework caused by an internal seal assembly error. The Commercial Billing Reviewer classifies these hours as OPEX_INTERNAL_REWORK and NON_BILLABLE_CONTRACTOR_ABSORBED so the operator customer is never invoiced for internal rework.
3. Reconciliation Identity:
   • Payroll Total Hours (2,520.0) == OPEX Maint (1,380.0) + CAPEX WBS (660.0) + Standby OPEX (300.0) + Internal Rework OPEX (180.0) = 2,520.0 hours (Variance = 0.0 hours, INR 0 unallocated at month-end close).

Takeaway: Every worked hour in the payroll pool is accounted for in controlling, while idle weather standby is excluded from Ind AS 16 capitalization and internal rework is excluded from customer billing.

Technical implementation: bifurcated timesheet JSON schema

{
  "timesheet_header_id": "CATS-O050-20261018-0912",
  "worker_id": "EMP-WS-7741",
  "shift_date": "2026-10-18",
  "total_verified_hours": 12.0,
  "supervisor_verification": {
    "supervisor_id": "SUP-WS-201",
    "verified_at_utc": "2026-10-18T19:10:00Z",
    "physical_attendance_confirmed": true
  },
  "track_a_payroll": {
    "payroll_approval_state": "APPROVED_FOR_PAYROLL",
    "regular_hours": 10.0,
    "overtime_hours": 2.0,
    "offshore_hardship_day": 1,
    "payroll_transfer_batch_id": "HRPY-202610-B2",
    "standard_absorption_rate_inr": 1800.0,
    "total_absorption_credit_inr": 21600.0
  },
  "track_b_cost_and_billing_lines": [
    {
      "line_no": 1,
      "hours": 8.0,
      "activity_type": "WELL_INTERVENTION_OVERHAUL",
      "intended_receiver_type": "WBS_ELEMENT",
      "intended_receiver_id": "WBS-CAP-WELL14-OVHL",
      "receiver_lock_status": "LOCKED_AFE_SUPPLEMENT_PENDING",
      "interim_posting_account": "GL-510990-UNALLOCATED-LABOR-SUSPENSE",
      "ind_as_16_capitalizable": true,
      "billing_classification": "BILLABLE_OPERATING_RATE",
      "cost_allocation_state": "PARKED_IN_SUSPENSE_PENDING_AFE"
    },
    {
      "line_no": 2,
      "hours": 4.0,
      "activity_type": "WAITING_ON_WEATHER_STANDBY",
      "intended_receiver_type": "COST_CENTER",
      "intended_receiver_id": "CC-OFFSHORE-STANDBY-OPEX",
      "receiver_lock_status": "OPEN",
      "interim_posting_account": null,
      "ind_as_16_capitalizable": false,
      "billing_classification": "BILLABLE_STANDBY_RATE",
      "cost_allocation_state": "POSTED_FINAL"
    }
  ]
}

Acceptance tests and operational readiness thresholds

Summary and next actions

1. Decouple CATS payroll transfer from CO receiver validation: Configure time-sheet processing so supervisor verification of attendance releases Track A hours to HR Payroll immediately, regardless of WBS or AFE budget status.
2. Deploy an Unallocated Labor Suspense account: Route hours targeting locked WBS elements or pending AFEs into a dedicated clearing account that retains the intended work order or AFE tag for controller resolution before month-end close.
3. Enforce Ind AS 16 capitalization filters on activity codes: Block non-productive weather standby, rig move waiting time, and internal rework hours from posting to capital WBS elements.
4. Separate internal rework from customer billing: Require commercial billing review on service timesheets so paid technician rework hours are absorbed as internal OPEX rather than invoiced to clients.