Job Description

General Information

Country: Malaysia

State: Kuala Lumpur

City: Lingkaran Syed Putra

Office Location: The Gardens South Tower, Mid Valley - Suites 26.01 & 27.01, Level 26 - &27 - - -

Date posted: 26-May-2023

Business Function: Accounting/Finance

Position Type: Full-Time/Regular

Description

The Financial Analyst will be supporting Financial Controller for all aspects of finance, management reporting, local statutory and tax, forecasts, cashflow, credit and treasury functions for the South East Asia (SEA), Japan and Korea organization.

Works closely with SEA, Japan and Korea sales team, sales support team and finance team on invoice coordination, order backlog, cashflow, forecasts, variance analysis, local collections, local statutory compliance and any other administration and issues impacting Steelcase\'s business in SEA, Japan and Korea.

Responsibilities:

1. Month end Routine - General Ledger function

• To book all prior month adjustment entry (if any) with proper supporting documents / analysis / finding / request from other, etc
• Prepare checklist / schedules to ensure all entries are timely posted for Salary and payroll taxes, Prepayment Charge out, Bank Reconciliations, etc.
• Monitor and reconcile stock / inventory (actual vs system)
• Run FX Revaluations for all open items AR, AP, banks (foreign currency), loan and any other monetary items
• Wire payment arrangement
• Promissory notes preparation
• Responsible to prepare a comprehensive schedules for all balance sheets items by day 10 after closing.
• Be proactive to recommend adjustment or reclassification or improvement during schedules preparation.

2. Month end Reporting

• Perform backlog variance check with HDS to ensure Sales recognized for the month.
• Review backlog report for monthly forecast projection.
• Perform trend analysis on margin and seek sales team clarification on huge variances vs projected margin.
• Refresh PS2 report and Product Line report to ensure Sales and OI tie to \xe2\x80\x9cComparison P&L report\xe2\x80\x9d. Work with FIS and Corporate Finance team to rectify any inaccuracy.
• Compile OPEX based on nature - by month and by sub-market. Perform trend analysis, track cost overrun
• Prepare KE24 Report - compile YTD Sales and COGs by sales order and by customer for monthly workbook analysis.

3. Post Month end Report

• Prepare Dealer sales Ultimate Customer Report to ensure accuracy of ultimate customer ID. Work with OFT to rectify incorrect ID.
• Refresh PS2 report for dealer sales, check sales and margin by region and margin variance against target. Seek sales team clarification on huge variances
• Review Regional Sales dashboard prepare by BPS team.
• Prepare Low margin pool and mock up reports.
• Prepare cashflow forecast report which include reviewing ARAP Interco and customer aging, sales collection and deposit report to forecast collection and payment for future 4 months
• Prepare and reconcile Quarterly Sales and Margin report between HDS and SAP for commission computation.

4. Weekly Sales Dashboard

• Review Salesforce Report to ensure sales pipeline for each market by sales person are correctly reflected and highlight to sales team on variances.
• Consolidate weekly sales forecast and outlook report by sub-market based on sales summary for each sub market managers.
• Review Backlog report and seek for clarification if backlog aged

2 months. * Run weekly Order Intake Report to have visibility on future backlog/sales.

• Participate in collection meeting with Sales support team

5. Financial and Tax Audit

• Assist Financial Controller in Annual Tax and Audit activities.

6. Process Documentation, Improvement and system support

• Continuously maintain and assist to improve General Ledger processes / reports / analysis by recommending leaner or efficient process or leverage best practice from others.
• Documenting all processes (existing and new) and continuously review them.
• Actively involved in SAP process improvement, new module implementation and be a user support to other colleagues

7. Business Partner

• Responsible for other ad-hoc reports, presentation slides for business cases that might be requested by Sales team or assigned by Financial Controller.
• Work closely with OFT and Sales support team on HDS Invoicing and Margin dispute issues.
• Work closely with Finance team on monthly closing activities.

Steelcase