Reporting Manager - Ireland
- Full-time
Company Description
Publicis Groupe is one of the world's largest advertising agency holding companies and a global marketing, communications, and digital transformation leader. We utilize the Power of One operating model to integrate and develop competencies to increase business value for existing and future clients.
Publicis Re:Sources is Groupe's Shared Services Platform, a centralized function supporting 63 markets and servicing a network of prestigious agencies across the globe. We have grown to 5,000+ professionals operating 40 shared service centers (SSCs).
We provide technology solutions and business services, including finance, accounting, information technology, global security, legal, payroll and benefits, procurement, tax, real estate, treasury, and risk management, to help Publicis Groupe agencies do what they do best: create and innovate for their clients.
Job Description
Statutory Accounting
- Assist in the preparation of statutory accounts for Re:Sources UK on yearly basis mainly relating to the MMS Ireland entities.
- Dealing with internal and external audit queries during year-end.
- Liaising with internal tax and legal specialists.
Management Accounting
Reporting
- Monthly reporting of the actuals for nine companies (Irish and UK)
- Preparation of ad hoc financial analysis and reports as requested by the Statutory Reporting Manager
- Assist Re:Sources accountants with reporting and accounting queries as and when required
- Manage relationship with auditors, answering queries as needed to ensure timely completion of audit.
Completion of Hyperion reporting packs for review and approval by CFO
- Review final number and book tax journals.
- Extract key reporting information from SAP, review and upload into Hyperion: (4 files) P&L, BS, Inter-company payables and Inter-company receivables
- Upload excel files to Hyperion using Smartview, including, Interco P&L analysis, headcount and salary. Create and upload separate excel forms for Fixed assets and aged payables/receivables etc
Monthly Reconciliation of Inter-company
- Load inter-company AP and AR from SAP into Hyperion
- Generate file from SAP and load into Hyperion
- Liaise with agencies globally to rectify any mismatches.
Review AP and Debtors ledger
- Check AR ageing from SAP agrees to the control account and investigate errors
Monthly revaluation of bank, AP and AR currency balances
- Input details and run System calculates automatically when details are put in
- Post FX revaluation journal (reversing) in SAP
Balance sheet and income statement analytical review
- Income Statement: Ensure that the month on month changes look reasonable and prepare commentary
- Balance Sheet: Perform a variance analysis to ensure most GL accounts have remained similar month on month and prepare commentary
- Investigate large variances from expectations
Hedges
- Identification and issuance of necessary hedges as needed
- Coordinate with Treasury department to ensure all necessary hedges are accurately in place
Prepare monthly balance sheet review packs
- Containing: Balance Sheet reconciliations with lead schedules. Trial Balance (TB). Inter-company mismatch report. TMS reconciliation. Action item list. Hyperion to GL (SAP) mapping
- Raise issues and questions and bring them to the attention of Finance Director's in monthly balance sheet reviews
Arrange and chair monthly balance sheet review meetings with FDs
- Ensure direct reports set up their meetings
- Chair meetings. Answer / ask questions and follow up action points
Ad hoc management reporting and analysis as required
- Prepare analysis for the auditors for hard close and year end
- Identify and clear problems such as AP ledger not equalling GL
Treasury
- Manage and assist the management accountant’s running of daily and monthly treasury reports in Avantguard Treasury Management System, ensuring reconciliations of the results across multiple international entities are performed
- Taking ownership of resolution any Treasury Management System issues that may arise.
- Managing relationship with Corporate team to enhance Treasury Management System functionality.
- Assist agencies with any treasury management queries or problems in Avantguard Treasury Management System.
Review Bank Reconciliations
- Get bank recs from the bank rec team and ensure they match to the GL and query any large balances
Management
Support Management Accountant
- Answer queries, provide procedural guidance, review files
- Ensure documentation is standardised and all work is correct and completed by deadline
- Check action items are sent out after balance sheet review meetings. Answer queries as they arise
- Explain accounting concepts and how to run TMS, SAP, AP/AR and Hyperion reports
Financial Planning &Analysis
Budgets/Forecasts
- Prepare the monthly and/or quarterly reporting of rolling forecast for multiple entities
- Manage the production of commentary explaining variance against budget on monthly basis for the company
Unblock and re-block vendors for revaluation purposes
- Unblock vendor (go into vendor info in SAP and un-tick)
- Run revaluation
- Block vendor (go into vendor info in SAP and tick)
Qualifications
- Educated to degree level
- Accounting qualification (e.g. ACA, ACCA,CIMA)
Experience
- Minimum of 5 years’ experience – including at least 2 years post qualified.
- Qualified in financial reporting through IFRS
- Experience with UK and Irish VAT treatment
- Experience in FRS101 and FRS102
- Experience with multi-currency companies
- Experience with taxation concepts
- Experience managing and reviewing work of junior accountants
- Experience completing month end reporting process
- Experience in identifying necessary hedges and issuance when required
- Confident and out-going with an ability to deal with staff at all levels
- Good communication skills, both written and oral.
- Diligent with strong attention to detail.
Other Skills
- Advanced Excel and desktop software skills,
- Proficiency with SAP, Hyperion and Avantguard Treasury Management System is essential.