Yating Yang Email & Phone Number

Auckland, New Zealand

- Business Analysis: Monitoring and analysing business performance and margins on a weekly basis.- Payroll: Managing payroll for a pool of more than 1000 casual workers using PayHero. Reconciling timesheets and staff attendance reports using Microsoft Excel and Google Sheets, utilizing functions such as VLOOKUP, XLOOKUP, MATCH, INDEX, SUMIF, COUNTIFS, and Pivot Tables.- Bookkeeping: Performing bank reconciliation in XERO, preparing and managing accounts receivables and payables, and handling invoice preparation and bill management.- Workflow Management: Designing, scheduling, and managing workflows for the accounting department.

Auckland, New Zealand

- Taxation Preparation and Filing: Ensured timely and accurate filing of GST Returns, PAYE, and Annual Income Tax Returns, ensuring compliance with accounting rules and standards.- Project Accounting: Oversaw project financials, including preparation, analysis, and review of project budgets, costs, and forecasts. Managed month-end closing for project financials and monitored monthly cash flows. Managed development loan applications, requirements, and lending accounts for projects. Projects involved: an NZ$80m (HK$384m approx.) commercial and residential project, two residential housing developments, and several renovation projects.- Bilingual Reporting: Prepared, analysed, and presented bilingual reports (English and Chinese) for stakeholders, ensuring they were reader-friendly, understandable, and provided meaningful insights.- Company Management: Oversaw and managed the company's business operations, ensuring efficient and effective operation of finance and accounting, human resources, and office administration departments - Day-to-day Accounting Function: Ensured numeric accuracy and compliance with accounting standards. Managed bank reconciliations, accounts receivables and payables, verified invoices and receipts, established and maintained invoice processing processes, and managed payroll processing and management using Xero and Microsoft Excel.