Controllership & Reporting
GL / R2R, month-end close, consolidation, governance reporting, balance-sheet controls and reconciliations.
23+ years across controllership, FP&A, global shared services, payroll operations, audit, compliance and governance — with multi-country experience and senior stakeholder exposure.
Vaidheeswaran Subramanian is a senior finance professional with progressive experience across manufacturing and global shared-services organizations. His background spans controllership, budgeting and forecasting, payroll transitions, audits, compliance, working capital, management reporting and enterprise-system transformation.
He has supported finance operations across India, Singapore, the US, UK, Netherlands, Malaysia, UAE and African markets, and has worked with senior stakeholders up to CFO/MD level.
GL / R2R, month-end close, consolidation, governance reporting, balance-sheet controls and reconciliations.
Budgeting, forecasting, management reporting, performance tracking and decision support for business leaders.
Finance transitions, offshore operations, SAP FI/CO transformation, stabilization and process automation.
Internal controls, statutory and tax audits, due diligence, compliance coordination and governance cadence.
Cash planning, treasury support, payment processing, intercompany accounting and working-capital management.
Cross-functional leadership, administration, team management and stakeholder engagement up to CFO/MD level.
These case studies are built around responsibilities documented in the professional experience — FP&A, payroll migration, SAP transformation, controllership, reconciliations, treasury and governance. The Excel workflow layer demonstrates how advanced spreadsheet capability can be applied to those finance problems.
Based on: Spices Consolidation / Edible Nuts FP&A
A structured planning model for consolidating entity-level actuals, budgets and forecasts into one management view, with drill-down variance analysis and scenario control.
Power QueryPower PivotXLOOKUPLETSUMIFSDynamic ArraysPivotChartsBased on: 11-entity Nigeria payroll migration
A control workbook for validating migrated employee and payroll data across entities, isolating exceptions before payroll sign-off and improving traceability during transition.
Normalize payroll files with Power Query → create employee/entity control keys → run duplicate, missing-record and gross-to-net checks → calculate month-on-month movement thresholds → route exceptions to an owner and sign-off tracker.
Power QueryXLOOKUPCOUNTIFSConditional FormattingException DashboardBased on: OFS-to-SAP transformation & stabilization
A migration-control model connecting legacy balances to SAP structures and creating a repeatable cutover reconciliation process for finance sign-off.
Maintain legacy-to-SAP mapping tables → load trial balances through Power Query → validate GL/account mappings → bridge pre/post migration balances → flag unmapped or out-of-tolerance items → maintain issue, owner and closure logs.
Power QueryMapping TablesXLOOKUPPivotTablesData ValidationControl TotalsBased on: GL controllership, month-end close & balance-sheet reconciliations
A structured close framework to combine account reconciliations, ageing, movement analysis and task ownership into a single review environment.
Import GL extracts → classify accounts and owners → auto-populate reconciliation schedules → compare opening, movement and closing balances → identify aged/unusual items → summarize status through close and risk dashboards.
Power QueryFILTERUNIQUESUMIFSPivotTablesAgeing BucketsBased on: treasury, cash planning, inventory and working-capital responsibilities
A rolling liquidity and working-capital model designed to help finance teams anticipate cash requirements and focus management attention on collection, payment and inventory drivers.
Load AR/AP and cash inputs → classify maturity buckets → build rolling weekly cash view → calculate working-capital indicators → apply scenario assumptions → surface upcoming cash pressure and overdue exposures.
Power QueryRolling ForecastSUMIFSScenario DriversPivotChartsSparklinesBased on: FMR for Arise Benin and multi-country governance reporting
A controlled reporting pack that standardizes monthly financial KPIs, variance commentary and entity-level review into a repeatable management cadence.
Refresh standardized data tables → calculate KPI and variance layers → create exception flags → generate entity summaries and management views → lock review versions and maintain commentary/sign-off fields.
Power QueryStructured TablesLETDynamic ArraysPivotChartsPower BI ReadyUniversity of Madras · 1998–2000
National College, Tiruchirappalli · 1995–1998