Account Assistant [ Pivot Table / Training Provided ]

The Supreme HR Advisory Pte Ltd; Singapore; On-site; SGD 3,600 - 5,400; Full time

Job summary

The Supreme HR Advisory Pte Ltd in Singapore seeks an organised accounting professional to manage payables, receivables, and monthly closing activities. You will prepare AR ageing, SOA, reconcile invoices, and liaise with customers and vendors to ensure timely payments.

Proficiency in Excel, including VLOOKUP, XLOOKUP and Pivot Tables, is essential. This role supports process improvement and cost-saving initiatives within a dynamic team.

Qualifications

• Experience with accounts payable/receivable and monthly closing processes.
• Ability to prepare AR ageing reports and Statements of Account (SOA).
• Familiarity with vendor invoices, rates, and cost verification.

Responsibilities

• Handle accounts payable and receivable.
• Follow up on customer payments and update customer statements.
• Manage invoicing, payments, and collections.
• Handle costing and monthly closing.
• Liaise with customers and vendors.
• Check supplier invoices, vendor rates and costs.
• Maintain payment schedules and follow up on outstanding payments.
• Prepare and update AR ageing reports and Statements of Account (SOA).
• Reconcile invoices and accounts, and resolve discrepancies.
• Prepare financial reports and assist with audit documentation.
• Use Excel functions such as VLOOKUP, XLOOKUP and Pivot Tables.
• Maintain accurate financial records and follow company procedures.
• Support process improvement and cost-saving activities.
• Cover work for team members when required.
• Perform other duties assigned by management.

Skills

Accounts payable

Accounts receivable

Invoicing

Costing

Monthly closing

Liaise with customers

Liaise with vendors

Reconciliation

AR ageing

Audit documentation

Tools

Excel

VLOOKUP

XLOOKUP

Pivot Tables

Job description

Job Description

• Handle accounts payable and receivable.
• Follow up on customer payments and update customer statements.
• Manage invoicing, payments and collections
• Handle costing and monthly closing.
• Liaise with customers and vendors.
• Check supplier invoices, vendor rates and costs.
• Maintain payment schedules and follow up on outstanding payments.
• Prepare and update AR ageing reports and Statements of Account (SOA).
• Reconcile invoices and accounts, and resolve discrepancies
• Prepare financial reports and assist with audit documentation.
• Use Excel functions such as VLOOKUP, XLOOKUP and Pivot Tables.
• Maintain accurate financial records and follow company procedures.
• Support process improvement and cost-saving activities.
• Cover work for team members when required.
• Perform other duties assigned by management.

Koh Kheng Guan R1980385

The Supreme HR Advisory Pte Ltd 14c7279