Planned and achieved aged debt targets by actively engaging with customers and resolving disputes, resulting in 70 percent decrease in 120 day balance
Reconciled complex transactions against customer payment records and suggested applicable adjustments to resolve discrepancies from previous financial years
Liaised internally with Branches, Sales and managements to identify on potential risks and discuss on the best decision to recover debts
Utilized Excel functions on D365 transactional reports to identify allocation errors and keep a detailed reconciliation records, including Vlookup / Match / Index
Developed strong customer relationship and cash inflow by proposing tailored payment plans based on account status and customer needs through calls, emails and letters
Maintained a respectful and supportive team relationship by approaching others and assisting on duties to meet weekly KPIs
Processed daily bank statement analysis and receipting, credit card payments and adjustments
Accounts Officer
Four Points by Sheraton Auckland
Auckland CBD, Auckland
06.2022 - 08.2023
Assisted in month-end and year-end Financial reportings to validate internal reports and conduct expenditure controls - include Prepaid expenses, Accruals, Inventory, and Owner's retained earnings
Performed internal audits of financial and departmental operations, identifying risks and opportunities and ensuring compliance with SOP
Reconciled daily banking transactions, including deposits, withdrawals, and transfers.
Reviewed General Ledger to ensure all invoices are entered into correct coding
Maintained the fixed asset register and depreciation schedules on a monthly basis
Managed large volume data with proficient Excel Skills- Vlookup/Match/Index formulas and Pivot tables
Completed biweekly payroll processing of employee earnings and deductions, including reimbursements and any special payments.
Generated weekly payment batch and processed payments for vendors, payrolls and expense claims
Optimized cashflow by reducing debtor aged balance by requesting immediate actions on overdue invoices until the outstanding debt is resolved
Conducted Credit Reference checks to evaluate the applicant's credit history for effective credit management research
Office Administrator / Sales Associate (Accounts)
Aotea New Zealand
Auckland
10.2021 - 05.2022
Accurately performing bank reconciliation with operations database from Infinity Software to determine monthly revenue
Reviewed and reconciled multiple forms of payments including cash, credit cards, Alipay and Afterpay
Ensured an efficient cash collection by recording cash payments and conducting a weekly deposit to the bank
Investigating data discrepancies and making necessary approach to maintain accuracy and transparency on daily sales records
Managing inventory and supply tracking, noting items requiring reorder
Calculating weekly and monthly incentive for all employees by retrieving data from their sales records
Education
Bachelor of Commerce - Finance and Economics
University of Auckland
06.2022
Bachelor of Commerce - Finance And Economics
University of Canterbury
Christchurch
11.2020
Skills
Expertise in Excel with building and applying advanced formulas
Account Reconciliation
Internal Auditing
Precision and Accuracy
Journal Entry Preparation
Debt collection
Payroll Management
Accounts Payable
Verbal and Written Communication
Languages
English
Native/ Bilingual
Korean
Native/ Bilingual
Certification
Office 2019: Microsoft Office Specialist: Excel Expert
Volunterring
Volunteering
Uniguide, University of Auckland, Feb 2022 - Jun 2022
Active participant, AIESEC, Feb 2021 – Jul 2022
Class representative, University of Canterbury Students' Association, Jul 2020 - Nov 2020