Senior Accountant cum Financial Analyst
Next Level
Total years of experience :17 years, 5 Months
✓ Financial Reporting: Prepared Consolidated Financials (Balance Sheet, Income Statement, Sales
Analysis Report on monthly basis). Prepared monthly Financial Presentation. Draft various account
analysis report using SQL, Power BI, Excel Power Query & Power Pivot.
✓ Cash Flow: Developed automated up to date cash flow statement using Power BI.
✓ General Ledger: Maintains and reconcile general ledger accounts; amortizations, prepaid and
reconciling TB, ledgers & accruals.
✓ Project Accounting & Invoicing: Create project accounts in the system, maintain project-related
costing & records, including contracts and variation orders. Verify Contractor Progressive Payment
Certificates. Render invoices to clients on a timely basis according to contract terms and follow up
with Project Managers. Process bulk quantity of supplier invoices. Maintain overhead charges and other expenses to be applied to a project. Report on project profitability to management. Prepare and update cost report, cash flow and project updates. Prepare & compare budgeted cost and actual cost analysis.
✓ Accounts Payable & Receivables :
✓ VAT: Preparation, validation and submission of VAT returns. Maintain & reconcile VAT Balances on General Ledger.
✓ Developing interactive dashboards, reports and financial models using Microsoft Power BI, Power Query and Power Pivot.
✓ Liaise with Auditors: Assist in Internal and external audit activities. Preparation of audit schedules and work closely with the auditors to ensure the completion of a timely audit.
• Handled full spectrum of financial and cost accounting role (AR, AP, GL, forecasting, budgeting etc.)
• Prepare Consolidated Financials (Balance Sheet, Income Statement and Cash Flow, on monthly basis). Prepare monthly Financial Presentation.
• Draft various account analyses and reporting package using Power BI, Power Query / Power Pivot.
• Prepare monthly journal entries for Accruals, Prepaid, Provisions, etc.
• Create project accounts in the accounting system, maintain project-related records, including contracts and change orders.
• Render invoices to clients on a timely basis according to contract terms and follow up for payments.
• Review and approve costing & sales orders.
• Process supplier invoices related to a project.
• Review and approve overhead charges and other expenses to be applied to a project.
• Preparing budget for various projects undertaken by the company
• Prepare & compare projected cost and actual cost after the project completion and submit it to Board.
• Compilation of ICV ( In Country Values).
• Report on project profitability to management.
• Report to management regarding the remaining funding available for projects
• Prepare bank guarantees upon requirements.
• Approve the write-off of any project-related billings that cannot be billed to or collected from customers
• Close out project accounts upon project completion
• Compile information for internal and external auditors, as required.
• Consolidation of inter-company transactions and reconciliations
• Process Monthly Payroll: Computation of salaries, attendance, leave, fixed & variable entitlements. Handling final settlement, annual leave settlements, combined salary register and maintaining register for every employees.
• Prepare the monthly reconciliation of VAT Report, Ensure timely payment, Maintain VAT Balances on General Ledger.
Assisting senior manager in the preparation & review of annual budget process in accordance with prescribed guidelines and formats.
Month-end, quarter-end and year-end closing, preparing monthly financial reports, P& L accounts, Balance sheet, debtors aging, stock aging etc.
Consolidation of inter-company transactions and reconciliations, Bank A/C reconciliation.
Balance sheet accounts reconciliations, Record monthly journal entries for payroll, fixed assets, employee accruals, prepaid expenses, provision for utilities, sales commission etc.
Assist in Internal and external audit activities. Preparation of audit schedules and work closely with the auditors to ensure the completion of a timely audit.
Handling and reconciling petty cash (for all branches), making entries after ensuring the vouchers are signed.
Opening LC for purchase, bank guarantee for customers. Resolve all concerns and issues involved in generation of LC (Letter of Credit).
Process monthly Utility bills (Telephone, Fuel and Electricity) on time.
Ensure that all revenues and costs are correctly allocated and monitored including regular reconciliations of accounts.
Processing separate payrolls for 2 inter-companies under the group as per WPS system
• Computation of salaries, attendance, leave, fixed & variable entitlements; developing and maintaining documentation, pay-slips & controls for all payroll related activities, Handling final settlement, annual leave settlements, combined salary register and maintaining register for every employees.
Sales Accounting & Accounts Receivables
• Approve daily schedule/Sales Order after verifying & checking sales order, receipt and discounts, PO/Contract terms.
• Preparation of the daily sales report and detailed analysis of the sales on daily basis for management information and decision making.
• Prepare invoices for credit customers and send out. Follow up through email and phone contact, allocate payment after receipt.
• Monitor customer account details for non-payments, delayed payments and other irregularities.
• Review AR aging to ensure compliance.
• Journal entries and adjustments for the debtors’ accounts reconciliation.
• Scrutinizing Accounts Receivable plan and reconciliation for debtor’s ledgers; preparing schedule of outstanding liability at the year end. Analyze the Sales with targets and expenses.
• Arrange daily collection reports from retail branch managers and reconcile cash, cheque and credit card receipts with bank account and passing necessary entries on time.
• Calculate and prepare quarterly sales commission after checking the sales target of sales persons.
Effective Cash flow Management
• Managing total collections / receivables (both local and outstation) of all the corporate & Project customers on daily basis and reporting the same to centralized hub.
• Fund managing within limited fund situation and satisfying the vendors, employees and the management