Kavya Project

← Back to all projects

Case study 03 Portfolio knowledge project

Period Close, Intercompany & Reporting Pack

A month-end operating model that sequences subledger readiness, intercompany alignment, tax/cash checkpoints, GL lock, and a practical OTBI / Smart View reporting pack.

Knowledge / portfolio case study only. Not employment history or named client work.

Read full case study Contact Kavya

Objective

Create a repeatable close that finance can run every period — with dependency-based timing, intercompany match windows, and a lean reporting pack leadership can trust.

Close calendar design

  1. D-3
    Pre-close readiness AP/AR/Assets/Cash cutover reminders, open hold aging, and incomplete transaction sweep.
  2. D-1
    Subledger completion Final operational posting windows and exception freeze points.
  3. D0
    Intercompany & tax checks Match windows, unresolved items policy, tax/cash integrity checkpoints.
  4. D+1
    GL review & adjustments Trial balance review, suspense cleanup, approved journals only.
  5. D+2
    Reporting pack OTBI / Smart View refresh, variance notes, distribution list confirmation.
  6. D+3
    Period lock Soft-close to hard-close with named owner sign-off.

Intercompany alignment

  • Transaction types and trading partner expectations documented
  • Match window and unresolved-item escalation path
  • Elimination readiness notes for later FCCS consolidation work
  • Balance integrity checks before management reporting distribution

Reporting pack outline

  • Trial balance by ledger / entity
  • P&L and balance sheet management views
  • Key variance and flash metrics
  • Intercompany outstanding summary
  • Suspense / clearing account monitor
  • Distribution list, refresh owner, and validation owner

OTBI and Smart View are treated as delivery channels for a defined pack — not a random report catalog.

Approach

  1. Build the calendar by dependency, not by module silo.
  2. Attach owners and evidence expectations to each gate.
  3. Design reporting pack before adding optional analytics noise.
  4. Connect operational close quality to EPM consolidation readiness.

Controls & risks

  • No hard-close without checklist completion and owner attestation
  • Late entries after freeze require documented exception approval
  • Risk: report distribution before validation — mitigated by dual-owner refresh/validate model

Oracle modules in focus

Period Close General Ledger Intercompany Tax checkpoints Cash Management OTBI Smart View Financial Reporting

Deliverables

Close calendar & RACI Intercompany checklist Reporting pack index Variance review prompts Freeze / exception policy Distribution & validation sheet

Outcomes

  • A close playbook that shows process discipline and systems awareness
  • Reporting artifacts that feel ready for workshop or interview deep-dives
  • Natural bridge into FCCS, ARCS, and Narrative Reporting case studies
← Previous Next: EPM Planning →