Microsoft Excel Teacher
Ex-pert
Total years of experience :14 years, 11 Months
●Teach Microsoft office Excel and scale up the skills of professionals by creating customized lessons.
● Organize workshop to CMAs (Institute of management accountant, Lebanon 2020).
• Ensure the smooth running and controlling of the accounting department's operation in 3 countries (Lebanon, UAE, KSA).
• Liaise with external auditors, lawyers, public authorities, customers and others, where appropriate.
• Prepare and monitor end of month management reports, consolidation and financial statements under IFRS.
• Posting and processing journal entries to ensure all business transactions are validly recorded on QBO.
• Develop new processes and review the revenue cycle and revenue recognition.
• Evaluate the efficiency and relevance of the internal control procedures and adjust where appropriate.
• Ensure that the company adheres to local tax and regulations in KSA, UAE, and Lebanon.
• Oversee the submission of VAT in KSA, UAE, and GOSI in KSA. Submit ESR, ultimate beneficial owner UBO in UAE.
• Review accruals, depreciation, and prepayment.
• Reconcile gateway payments ( checkout, Telr)
• Manage DMCC portal
• Calculate depreciation and capitalization.
• Reconcile related parties accounts.
• Led the implementation of the ERP.
• Monitored daily accounting and billing operations and banks/cash reconciliations.
• Managed legal cases in coordination with the company legal advisor.
• Managed and monitor monthly payroll (Tax on salary, NSSF calculations).
• Provided and interpreted financial information and reports.
• Monitored inventory transactions and inventory adjustments.
• Stock Configuration and auditing.
• Developed standardized operating procedures (SOPs) for the department.
• Coordinated with external auditors to ensure that tax reporting is carried out properly.
• Oversaw the budget as per the price structure of each stock keeping unit.
• Developed Frameworks for Sales Team monthly commissions and incentives.
• Provided cost accounting and financial reports (P&L, Balance Sheet, Cash Flow Statements).
• Submitted a monthly report to the administrative team.
• Divided and scheduled the logistical duties of each driver.
• Followed-up on pick-up and drop-off operations.
• Performed internal audit on several areas of work/several departments and recommend a course of action.
• Employed restrictions and improve the financial worksheets using advanced Excel skills (Macros, VBA)
• Conducted investigation for inventory and stock discrepancies when needed.
• Performed spot checks ( Cash count, Quality Assurance.... ) in 18 branches.
• Assessed the reliability of certain financial data and accounting reports.
• Issued reports followed by recommendations to foster the workflow in branches and head office.
• Delivered financial reports such as : Trial Balance, difference of exchange, banks interest...
• Implemented restrictions and grant access to staff on the accounting system. As well as, create users for new employees.
Undertook debts collection, follow up and analysis of all overdue outstanding debts from clients.
Delivered guides, and give advice to branches on how to well deal with claims from customers.
Contributed in minimizing provision figure (target over 80%), furthermore developed strategy to reduce delinquency by 15 %.
Prepared analysis of bad debts by delivering charts and tables to the director.
Established and Maintained Great Customer Relationships to Maximize Account Performance.
Finalization of Accounts for the Management and Audit.
Performed receivables duties for 1500+ accounts.
Prepared the Balance sheet, P&L, financial ratios, cash flow, Bank Reconciliation Statement
Monitor, examine, and audit various financial statements.
Diminished errors in accounts payables by 80%.
CMA candidate