Sophia (Xiaoxu) GUO
Project Accountant at TMG Builders- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
TMG Builders
-
Canada
-
Construction
-
1 - 100 Employee
-
Project Accountant
-
Apr 2018 - Present
-
-
-
-
Project Accountant
-
Aug 2016 - Mar 2018
Achievement: redesigned and implemented automated Excel workbook(VBA) for sales commissions calculation. • Experienced in full-cycle project accounting for land development projects; prepare monthly/annually financial reporting packages for company stakeholders review; reconciled bank accounts, HST/GST, and labour and costs accruals. • Conduct monthly variance analysis, budget analysis, financial analysis, and work-in-progress(WIP) analysis. • Works in conjunction with Project Managers to review and interpret contracts and purchase orders, change orders, progress draws, holdbacks, billing schedules, percentage of completions; prepare fees, cost allocations, consulting fees, draft/final invoices. • Responsible for budgets, reforecasts, job costs setup, capital projects setup, and mortgage schedules. • Reconcile weekly cash flows, vendor accounts, AP, unbilled costs, AR, and all balance sheet items. • Provide problem solving and assistance during audits and projects’ milestone meetings. Show less
-
-
-
-
Junior Accountant
-
Nov 2014 - Oct 2015
Achievement: restructured the accounting process for enhanced reporting which increase efficiency and accuracy. • Developed budget template; investigated and analyzed actual to budget variance; and developed rolling reforecasts. • Prepared cash flow projections, cash distributions to JV partners, cash flow reports, and bank reconciliations. • Responsible for cost center analysis, headcount analysis, time sheet analysis, labor forecast, hours’ analysis, T4, payroll deductions, GST/HST remittances, US Tax, and Statistics Canada Reports. • Reconciled GL accounts, A/P and A/R master lists, and B/S accounts; prepared monthly accruals and re-classing JEs. • Provided the quota report to align with the president’s decision for the building renovation projects. • Designed financial models and prepared variance analysis and HST returns for the building renovation projects. Show less
-
-
-
-
Accounting Assistant
-
Aug 2014 - Nov 2014
• Managed all aspects of accounting and taxes for clients from diverse industries; provided monthly/quarterly/year-end financial packages along with financial analysis. • Reconciled general ledger and HST/GST/QST/WSIB accounts; prepared budgets, forecasts, year-end audit working papers, government remittances, payrolls, and all other government fillings. • Reviewed financial statements vs budgets; conducted investigation into the variances, identified risks and performances, and provided in-depth analysis and recommendations. Show less
-
-
-
-
Accounting Assistant
-
Jul 2013 - Mar 2014
• Collaborated with managers to create financial forecasting and budget maximizing use of $400 budget expenditures. • Reconciled donations received and bank statements. • Collaborated with managers to create financial forecasting and budget maximizing use of $400 budget expenditures. • Reconciled donations received and bank statements.
-
-
Education
-
Brock University
Master of Business Administration (M.B.A.), Accounting -
Hainan University
Bachelor's degree, Tourism and Travel Services Management