Accounts Assistant | VLOOKUP / Pivot Tables

The Supreme HR Advisory Pte Ltd; Singapore; On-site; SGD 28,000 - 42,000; Full time

Job summary

The Supreme HR Advisory Pte Ltd in Singapore is seeking a detail-oriented Accounts Payable/Receivable Assistant to join our finance team at Changi Airfreight Centre. This role handles invoicing, statements, AR ageing, costings, and monthly closings, using Excel functions like VLOOKUP, XLOOKUP, and Pivot Tables.

Training will be provided and you will liaise with customers and vendors. The position offers a structured 5.5-day workweek (alternate Saturdays), with working hours 9am–6pm, and

Qualifications

• Diploma in Accounting/Finance required.
• Experience with Excel functions (VLOOKUP, XLOOKUP, Pivot Tables) is an advantage.
• Training will be provided.

Responsibilities

• Handle accounts payable and receivable.
• Follow up on customer payments and update 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 AR ageing reports and Statements of Account (SOA).
• Reconcile invoices and accounts, 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

Excel: VLOOKUP, XLOOKUP, Pivot Tables

Education

Diploma in Accounting/Finance

Job description

• Working days: 5.5 days (Alternate Sat)

• Working hours: Mon – Fri 9am – 6pm, Sat 9am – 1pm

• Location: Changi Airfreight Centre

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.

Requirement

• Diploma in Accounting, Finance or related field.

• Training will be provided

• With knowledge of Microsoft Excel; experience with VLOOKUP, XLOOKUP and Pivot Tables is an advantage.