Zhiyu Wang CPA MBA
Group Accountant at RLDatix- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Chinese Native or bilingual proficiency
-
English Professional working proficiency
Topline Score
Bio
Experience
-
RLDatix
-
United States
-
Software Development
-
700 & Above Employee
-
Group Accountant
-
Oct 2020 - Present
Analyze the key recuring costs like lease, insurance, hosting fees, and legal consultancy costs, based on the historical financial data, to identify the major variances, avoid any unexpected and omitted costs against to the budget across the 6 operating entities.Oversees the seasonal one off and material costs and provide concise explanation of the variance analysis between the forecast and actual costs to the budget manager.Develop and monitor the excel dashboard report to manage 30+ external debts accounts including the principal balances, YTD accrued interests, projected interest payments and amortizing the costs of the debts, compared with the total cash on hand across the group to foresee the liquidity. Present the dashboard to the director of the global accounting to assist in the cash transfer planning to meet the debt covenants.Review Bank balances and reconciliations for 15+ bank accounts in different currencies at month end to ensure the accuracy of the cash balances on accounts to assist in solvency modeling analysis.Review and revise 40+ intercompany accounts, oversee all transfer prices transaction across the group.Create the excel template for prepayment and accrual costs to process 100+ journals monthly to facilitate journal entries preparation at month end and keep multiple mandatory fields in consistency and accuracy; supervise and train the responsible team members on the utilization of the template to increase the month end process efficiency and ensure compliance of the accounting policies.Supervise and train 5 new team members in accounting processes, facilitating tools and the accounting systems to smooth the hands on work transition and build redundancy for crossover backup.
-
-
Senior Financial Analyst
-
Aug 2019 - Oct 2020
-
-
Financial Analyst
-
Mar 2016 - Jul 2019
-
-
-
Badlands Paintball Inc
-
Sporting Goods
-
1 - 100 Employee
-
Accountant
-
Aug 2014 - Jul 2015
Responsible for the day-to-day accounting functions of accounts receivable and assisting in accounts payable. Managed the maintenance of the books of account. Assisted with month end close and preparation of financial reports.• Process day end balancing for wholesale accounts and retail stores, reconcile petty cash, and make adjusting entries to correct variances.• Create and upgrade daily and monthly reconciling sheets to be much more effective and accurate. • Perform monthly reconciliations for gift cards, corporate credit cards, bank accounts and general ledger accounts.• Verify purchase orders with vendor invoices and reconcile and approve payments for entry into accounting system.• Redesign price match report to save 80% of time by getting rid of redundant copy works. • Contact vendors regarding any discrepancy of invoices and payments and contact customers regarding overdue accounts.• Assign bills pay date, review and issue payment and reimbursement checks.• Assist the Accounting Manager with month end, quarter end, year-end tasks and all other accounting duties as assigned. • Prepare weekly aged accounts receivable and accounts payable reports for senior management.
-
-
-
Tianbao Travel Limited
-
China
-
Leisure, Travel & Tourism
-
1 - 100 Employee
-
Accounting Analyst
-
Jul 2013 - Aug 2014
Responsible for the day-to-day downloading, processing, and adjusting invoices from all sources. Investigated and resolved discrepancies in complicated and mistaking duplicated invoices. Responsible for sales reports and any other Ad hoc reports. • Created a matching table with advanced formulas in Excel, which saved at least 90% of time and ensured 100% accuracy for a crucial task.• Examined and modified over 1000 invoices within one day to provide accurate sales information on a management report at events of sales campaign.• Processed an average of 400 invoices on daily basis including coding, matching and verifying payment amounts on each invoice• Investigate account discrepancies and reconcile to general Ledger.• Assisted accounting manager with monthly balance sheet reconciliation and preparation of monthly financial reports.
-
-
Junior Accountant
-
Dec 2012 - Jul 2013
Responsible for the day-to-day accounting functions of accounts receivable and accounts payable. Address and resolve non-routine, complicated and unexpected issues. Overseen the maintenance of books of account. Assisted with month end close and preparation of financial reports.• Overseen daily cash flow and process daily cash receipts for all branches.• Performed billing, payment allocation and collection following established protocols, to tight deadlines.• Collected outstanding balance on all accounts by contacting the customers by multiple ways.• Prepared and maintained customer’s monthly reconciliation schedules.• Prepared daily reconciliation for all bank accounts and process adjustments to correct any variances.• Verified vendor invoices and reconciled and approved payment for entry into accounting system.• Assisted the accounting manager with month end close and any projects as assigned.
-
-
-
-
Bookkeeper Co-op
-
Apr 2012 - Sep 2012
Responsible for day-to-day data entry into accounting system, and handled any project assigned by supervisor. • Entered vendors information and invoice data into accounting system• Collected receipts and expense claim form, reviewed and added to next pay-check file.• Completed any required investigation into backup documents. Responsible for day-to-day data entry into accounting system, and handled any project assigned by supervisor. • Entered vendors information and invoice data into accounting system• Collected receipts and expense claim form, reviewed and added to next pay-check file.• Completed any required investigation into backup documents.
-
-
Education
-
Schulich School of Business - York University
Master of Business Administration - MBA, Business Administration and Management, General -
Concordia University
Bachelor's degree, Accounting