Financial Analyst
Lui O Lei Trading LLC
Total years of experience :19 years, 1 Months
• Preparing Monthly Financials, Cash Flow, Forecasting Report & Treasury, Budget Reporting & Other Internal Accounting Reports & Assisting Team For Monthly Book Closing
• Involve In Uploading Database Complete Financials Report In Axapta (ERP).
• Controlling & Managing Financial System In Microsoft Dynamics Axapta & Coordinating External & Internal Audit Relate To Stock Transfer in warehouse are accurate in Axapta & Suggest & implement improvements in accounting & report process
• Accurate report on Balance sheet, Stock, General Ledger & Sub Ledger reconciliation, BRS & Consolidated sales report with departments dimension, Cash Control, Sales Account Mapping, Stock Control & Stock Auditing
• Managing Inventory process for stock & update additional cost details in stock reports
• Preparation of report on Tacking work on Stock to bill additional cost on vendor
• Study process in Fixed Assets Management, Dimension Setup in chart of accounts for reports, ratio analysis in financials
• Mapping Apply entries on Vendor & customer on different currency for payment & receipts
• Audit the activates of departments for compliance with financials reporting
• Determining proper accountability of physical count, inventory & confirmation as appropriate on stock
• Supporting external & internal audits, Preparation of Regulatory Returns for review
• Monitoring the process of payable team & record supplier invoice, Bank Payable notes, PDC /CDC Cheque
• Functioned as an In - charge for handling all the activities in Accounts & Finance Department
• Maintaining the accounting entries for Approval & Posting using ERP (Microsoft Dynamics NAVISION 2009) & Liaising with the Juniors & optimally utilising the resource to complete the task
• Monthly Trial Balance, Audit Program, Forecasting & Income Statements to management, worked on Cash Flow report & conducting the monthly, quarterly, year ending activities & provided support to Auditor & Group Company GM Finance for reports. Administering the journal & adjustment entries, reconciliation of General Ledger, BRS, etc.
• Managed statutory relationship - Provident Fund, ESI, Professional & Labour Tax, Service Tax, Sales Tax (VAT), & quarterly filing TDS with authorities, etc. Cementing bank relationship for handling the Overdraft Account, Monthly Stock Report, Remittance Tracking on receipts, etc
• Steering the Account Receivable Management (Customer Ledger, Consolidating Customer’s Statement, Receipt Follow-Up, etc.) & Account Payable Management (Vendor Report, Payment Journal & Provision, etc.) & Mapping the Purchase & Sales Register for invoicing Customer’s proposal updation with the Sales Head for creating periodical billing of clients
• Interfaced with the HR, Admin for managing the monthly details for salary process, employee’s reimbursement process & administrative requirements, etc
• Introduced various cost saving measures in Administrative Expenses, Project Costing, etc. Streamlined the dimension process for projects in Accounting Database (Microsoft Dynamics NAV) & Successfully resolved the statutory inspection issue
• Administering all the functions, entailing Accounting, Auditing & Finance Department & Processing of the salary payment at the end of the month & Maintaining Sales Tax, VAT, Register & Quarterly Filing TDS with authorities & Organised the Monthly Audit program with Auditor’s
• Conducting weekly Internal Audit Program for drawing out program for audits in consultation with auditors & coordinating for the same & creating Daily, Weekly, Monthly Debtors & Creditors outstanding report for collections & payables workforce & Scrutinising the Debtors & Creditors position & following up receipts & payments. & maintaining Bank & Cash Book of the Head office as well as handling the General Ledger Accounting, Purchase & Sales Register
• Handling all types of internal & external auditing, statutory audit, Recording the TDS for quarterly filing, monthly VAT filing,
• Monthly Audit Program for clients, payments, stock, bank books, Carrying out reconciliation filing of statuary documents, etc. & Administering the book keeping as well as creating book for management for verification & for clients.
• Preparation of Risk Based Audit Programs, Plan, Manage, Coordinate & implement the periodical & yearly end closing document to UK Audit Firm.