Client & Agency Service Closely collaborate with other Working Capital Managers and Analyst to prepare monthly Working Capital (AR and AP) reporting for all Omnicom Media Group agencies Run reporting and aggregate Working Capital data from multiple sources (Mediaocean, Microsoft D365, Cognos); create custom reports in Excel, as directed Efficiently load Working Capital data to Hyperion Financial Management (HFM), identifying and resolving issues before submission while meeting internal deadlines Reconcile Working Capital data to General Ledger data within HFM monthly Monitor Accounts Receivable balances - Review ARs by agency/region/client and identify issues Collaborate closely with Budget Project Managers (BPMs), Finance Directors (FDs), and other internal staff to optimize collections and ensure timely payment Assess monthly cash forecast submissions by the BPMs for accuracy Submit weekly updates on cash status to senior management Ability to effectively summarize Working Capital data and provide detailed explanations of specific account balances, including past due amounts, unbilled media/revenue, negative working capital, and year-over-year investment variances, for monthly meetings with senior management Organize and schedule AR and Cash Forecast status meetings with BPMs/FDs Run inquiries on client credit viability through an external system (Allianz) and assist in establishing credit insurance limits; provide reports upon request Monitor and assist in the reconciliation of unapplied cash through monthly meetings with BPMs and ad hoc inquiries Identify potential offsets/write-offs on aging and work with BPMs to resolve
Job Classification
Industry: Advertising & MarketingFunctional Area / Department: Finance & AccountingRole Category: FinanceRole: Financial AnalystEmployement Type: Full time