Millennium Furniture

JOB SUMMARY

The Senior Material Accountant is responsible for ensuring the accuracy and timeliness of material related financial data, including AP booking, costing, inventory movement, and reporting.

This role plays a key part in optimizing reporting processes using Generative AI tools (e.g., ChatGPT, Copilot, Gemini), advanced Excel tools (Power Query, VBA), supporting audits, and collaborating across departments to maintain financial integrity.

ESSENTIAL DUTIES & RESPONSIBILITIES

1. Material Costing & Analysis

• Monitor and validate approved material prices vs. vendor invoices and system standards.

• Analyze Purchase Price Variance (PPV), Material Usage Variance (MUV), and actual vs. standard cost.

• Prepare monthly cost roll-up reports and COGS analysis.

• Support material price forecasting and sourcing cost-saving reviews.

2. Inventory Management

• Track inventory movement and ensure accurate system transactions.

• Prepare daily, monthly, yearly inventory movement reports and variance analysis.

• Lead year-end stock take planning and consolidation.

• Convert inventory valuation from standard to actual cost for customs liquidation.

3. Accounts Payable & Reconciliation

• Oversee three-way matching (PO, invoice, GRN) for raw material purchases.

• Ensure timely and accurate AP booking and reconciliation.

• Support monthly VAT reporting and external audits.

4. Reporting Optimization

• Develop and maintain automated reports using Generative AI tools (e.g., ChatGPT, Copilot, Gemini), Power Query, VBA, and advanced Excel.

• Streamline reporting workflows to reduce manual effort and improve accuracy.

5. Cross-functional Collaboration

• Work closely with Purchasing, Production, and Customs teams to ensure data consistency. • Other tasks assigned by manager

MINIMUM QUALIFICATIONS

1. Education

▪ Required Bachelor’s Degree in Finance, Accounting, or related field..

2. Experience

▪ 5 years in manufacturing finance, preferably in sizeable manufacturing FDI companies Related to Material Cost accountant or similar role

3. Knowledge of:

▪ Computerized accounting software, plus knowledge of ERP

▪ Account Payable, Costing, Inventory, Payment and Invoice checking

▪ Strong understanding of purchasing, production, GL booking, and invoice management processes

4. Skills and Abilities

• Technical Skills:

Strong and confident with excel reports

Advanced Excel (Power Query, VBA, PivotTables) needed

ERP systems (AS400, SAP, Mapics/IFM)

• Language:

Good on comunicate in English (written and spoken)

Soft Skills: Detail-oriented, analytical, proactive, strong teamwork and communication.

EQUIPMENT USED

▪ Computer:

MS Office and AS400 and ERP (Mapics/IFM)

▪ Calculator

▪ Copier

▪ Phone

MENTAL & PHYSICAL DEMANDS/WORKING CONDITIONS

1. Mental Effort

▪ The ability to maintain a concentrated effort over extended periods of time.

▪ Ability to meet deadlines

▪ Attention to detail

2. Physical Requirements

▪ Sits for extended periods of time

▪ Stands and walks/moves to different locations as needed

3. Working Conditions

▪ Works in office environment with extended period of time looking at computer terminals.