Karry Ni Email & Phone Number

-Post accounts payable and accounts receivable based on invoices and cheques received; create journal entries and post in Sage in a timely manner-Prepare monthly expense breakdown and revenue analysis using Excel; visualized results using power BI to identify drivers causing spending increase and provided recommendations-Generate projections and retention report. Work closely with executives to help them make better decisions-Analysis Revenue, payroll and commissions. Working with manager to create commission structures and report by using xlookup, sumifs and countif-Prepare semi-monthly payroll, record and allocate commissions to correct team members based on more than 1000 accounts from retailer’s report. Apply to and keep tracking different government grants, company revenue and expenses -Prepare GST return and other tax returns when required-Identify outstanding issues such as missed payments for flowing contracts, developed strong conflict resolution ability and communication skills through interacting with retailers regards to monthly revenue questions

-Post accounts payable and accounts receivable based on invoices and cheques received; draft journal entries for Finance Officer to review and post in QB in a timely manner, help Finance Officer prepare payroll-Use Excel to calculate monthly fees for each community league; prepare, review, and issue monthly invoices to over 150 community leagues across the Edmonton region to collect operating funds for EFCLPrepare monthly bank and credit card reconciliation using QB bank reconciliation module; identify potential outstanding issues such as deposit in-transit over 10 days or cheques not deposited to Finance Officer-Assisted Finance Officer in expense breakdown and analysis using Excel; visualized results to identify drivers causing spending increase and provided recommendations to senior management