Rosemarie Ofilan

ROSEMARIE OFILAN BACHELOR OF SCIENCE IN COMMERCE MAJOR IN INTERNAL AUDITING 10 Years WORKING EXPERIENCE FULL TIME Aug 2022 - Sep 2023 General Accountant- Falcon Pool Jan 2021 - July 2022 GOALS Automate Accounting Processes Transparent financial reporting General Accountant-Kenzie Building Dec 2018 / Dec 2020 General Accountant - The Yellow Bulb, Dubai (Advertising & Marketing Agency) Skills Apr 2017 - Aug 2018 Accounting General Accountant - Leto, Dubai Communication (Food and Beverage Company) Mar 2015 – Feb 2017 Problem Solving Audit Analyst - Digits Trading Corp., Technical Philippines (Merchandising) Management Sep 2012 -Feb 2015 Critical Thinking Financial Specialist - Music Group Offshore Macau & PH (Manufacturing) --Dubai Marina, UAE PART TIME Year 2020 Global Business Outsource US (Accounting Firm) below assigned projects: Pinpoint Local UK (SEO Firm) (Investment/Trading Companies) Browse next for further details. Synthesis Investment US, Sentegram Inc. US, Next Level AU (e-Commerce) Elara Shop US, Twin Cities Commerce US,Omnivation US (Real Estate Companies) Al Furjan UAE, Next Home Inc. US, Smart Solution US Source IT Technology - (SAAS Company) "Working experience of 10 years in the field of accounting and auditing; Versatile in various accounting software. Promoting virtual assistance to startup and midsize companies in this generation where advance technology is abundant, thus aiming to automate accounting processes for a minimum cost yet providing effective & efficient performance as I value trust and quality service to my clients." TECHNICAL SKILLS Quickbooks Online & Desktop, SAP, Tally, Oracle System, Excel Formula Account Management, Account & Bank Reconciliation, Sales Tax & VAT Filing (FTA Portal), Budgeting & Cash Flow Forecast ,Microsoft AX Dynamics Profit & Loss statement Reconciliation, Balance Sheet Reconciliation, Payroll IFRS & GAAP Principle, ASANA, Slack, Timecamp, Payoneer, EXPERIENCES IN FULL REVIEW Aug 2022 - Sep 2023 Falcon Pool, Dubai 1. Reconciled financial discrepancies by collecting and analyzing account/journal entrie particularly customer’s account and resolve any related issues of payment, billing or statement. Moreover, reviewed bank, cash receipts and card receipts daily against the posted transactions in quickbooks. 2.Reviewed financial transactions and corrected journal entries in qbo such as sales and payment transactions of 200 clients, bills of vendors ensuring expenses were categorized correctly, inventory with delivery note reconciled to its purchase order and bills with full back up of files 3. Recommended financial actions by analyzing accounting options and best for company's current condition. 4. Summarizes current financial status by collecting information; profit and loss statement, project and other reports such as daily reporting of cash receipts, cash flow, revenue, expense and stock tracker. 5. Substantiates financial transactions by auditing required documents like contract/LPO. 6. Maintains accounting controls by reviewing, abiding process and recommending policies and procedures of transactions that has lapses/gaps. 7. Provides financial information to management by researching and analyzing accounting data; preparing reports through a financial dashboard presenting through power BI such as budget whilst tracking actuals to escalate significant variance per budgeted project and profit and loss by department every end of the month. 8. Reconciled, prepared and submitted VAT report to RTA. 9. Guides accounting clerical staff by coordinating, delegating activities and answering questions. 10. Act as a back up for employees on leave. Technical Skills Used: Quickbooks, Excel, Customer & Vendor Account Management, Account & Bank Reconciliation, VAT Filing, Budgeting, Payroll, Profit & Loss statement, Profit Analysis and Cash Flow Forecast EXPERIENCES IN FULL REVIEW Jan 2021 - July 2022 Kenzie Building Services Dubai 1. Setup quickbooks chart of accounts and migrate data from tally to quickbooks. 2. Reconciled financial discrepancies by collecting and analyzing account/journal entries. 3. Reviewed financial transactions by entering correct journal entries in quickbooks. 4. Recommended financial actions by analyzing accounting options and best for company's current condition. 5. Summarizes current financial status by collecting information; preparing balance sheet, profit and loss statement, project and other reports. 6. Substantiates financial transactions by auditing required documents like contract/LPO. 7. Maintains accounting controls by abiding process and recommending policies and procedures of transactions that has lapses/gaps. 8. Provides financial information to management by researching and analyzing accounting data; preparing reports through a financial dashboard in excel. 9. Prepares payments by verifying documentation, tracking the budget and requesting disbursements according to budget threshold. 11. Reconciled account of customer and vendor to get an updated view of statement, revenue and expense account. 12. Guides accounting clerical staff by coordinating, delegating activities and answering questions. 13. Act as a back up for employees on leave; Delivered Customer Support task such as answering client’s and other stakeholders’ inquiries, booking client’s orders & maintained customer relationship management tracker. Delivered Human Resource task such as creating memorandum and implementing new policies and procedures, manage employee relations by addressing demands and other issues, recruitment and payroll processes. Technical Skills Used: Quickbooks, Excel, Customer & Vendor Account Management, Account & Bank Reconciliation, VAT Filing, Budgeting, Payroll, Profit & Loss statement, Balance Sheet preparation, Profit Analysis and Cash Flow Forecast EXPERIENCES IN FULL REVIEW Dec 2018 / Dec 2020 General Accountant - The Yellow Bulb, Dubai (Advertising & Marketing Agency) 1. Recommended and implemented Quickbooks as financial accounting system to achieve efficient accounting processes. 2. Executed data migration from Tally ERP 9 to Quickbooks and setup the Chart of Accounts. 3. Maintained general accounting system (Quickbooks) and secured financial information by completing database backups weekly. 4. Secured approvals prior to payment processing by verifying documentation, and requesting disbursements according to Accounts Payable/AP schedule. 5. Analyzed weekly the customer Accounts Receivable/AP aging to reassess credit limit and ensure timely collection. 6. Verified monthly the time sheets of employees prior to releasing salaries. 7. Reviewed financial transactions against contracts or agreements to verify the transactions authenticity. 8. Reconciled quarterly the sales and purchases transactions for VAT filing in FTA portal. 9. Reconciled book of accounts to create financial statements such as profit and loss, balance sheet, statement of cash flow and budgets according to schedule. 10. Recommended financial actions based on financial analysis conducted. 11. Weekly report of financial dashboard that shows sales, expenses, receivable, payable, income and financial ratios for a transparent financial status notification to shareholder. 12. Maintained financial security and confidentiality by following internal controls, company policy and procedures in order to keep customer confidence and protect operations. 13. Communicate and coordinate with other departments, suppliers, clients and other external parties. 14. Provided support to auditors during end of year reconciliation of financial statements Technical Skills Used: Tally, Quickbooks, Excel, Account Management, Account & Bank Reconciliation, VAT Filing, Budgeting, Payroll, Trial Balance, Profit & Loss statement & Balance Sheet preparation, DMCC Filing, Cash Flow Forecast EXPERIENCES IN FULL REVIEW Apr 2017 - Aug 2018 General Accountant - Leto, Dubai (Food and Beverage Company) 1. Responsible for daily accounting journal entries related to AR, AP, Expenses, Payroll, Asset, Liability and Capital accounts by analyzing and reviewing authenticity of the transactions 2. Weekly reporting of the company’s financial status in terms of sales, expenses, bank accounts through financial dashboard 3. Weekly assessment of Accounts Receivable Aging to ensure timely collection and Accounts Payable Aging for timely approval prior to disbursements 4. Monthly close GL and reporting cycle and quarterly report of financial statements 5. Balances books periodically and prepares profit and loss, income, and balance sheet statements 6. Performed reconciliation of sales and purchases for VAT filing to Federal Tax Authority of Dubai 7. Liaised with various departments, clients, suppliers, regulatory agencies and other third parties to process further necessary transactions, requirements and resolve any issues 8. Provided support to external auditors during year end reconciliation of financial statements 9. Performed special, ad-hoc projects as requested Technical Skills Used: Interpersonal Skills, Tally, Oracle POS, Microsoft Excel, Cash Management, Bank Reconciliation, Bookkeeping, VAT Filing, Financial Reporting, Budgeting, Cash Flow Forecast, Petty Cash Mar 2015 – Feb 2017 Audit Analyst - Digits Trading Corp., Philippines (Merchandising) 1. Prepared audit scope, audit program and identify risk areas by understanding organizations objectives, structure, policies, processes, internal controls, standards and regulations. 2. Performed SOX 404 control testing, attribute testing, walkthrough, root cause analysis, gap analysis. 3. Assessed compliance and examine records according to financial regulations thru testing accounting transactions and system test scripts of general ledger, balance sheet, profit and loss statements, cash receipt, cash disbursement and inventory practices and documentation. 4. Prepared memoranda and audit work papers by documenting audit substantive test, findings and recommendation. 5. Communicate audit progress with stakeholders to highlight unresolved issues and prepare final audit report with recommendations. 6. Identify loopholes & recommend risk aversion measures and cost savings Technical Skills Used: Oracle System, Microsoft Visio, VBA Visual Basic Application, Process Flowchart, Gap Analysis, IT General Controls, Risk Management, Cash Count, Inventory Audit, Business Process Audit, Financial Audit, Compliance per Standards and Contract EXPERIENCES IN FULL REVIEW Sep 2012 -Feb 2015 Financial Specialist - Music Group Offshore Macau & PH (Manufacturing) Accounts Payable Management 1. Vendor Account Management per subcontractor/supplier 2. Processed petty cash and employee expenses and cash disbursement 3. Monthly payroll preparation, Bank and vendor reconciliation, AP Aging reporting 4. Prepared payment voucher and journal voucher per outgoing transactions, Input VAT calculation. Prepared balance sheet and profit and loss statement. 5. Prepared cash flow budget and forecast for sound decision making and accounting for prepayments, accruals, assets and depreciation transactions. Accounts Receivable Management 1. Data migration duties from Microsoft Dynamics AX to SAP and checked SAP test scripts 2. Bank reconciliation, inter-company and customer’s account reconciliation, cross check pricing and quantity of invoices against packing slip prior payment & shipment. 3. Prepared revenue report, credit and collection reports, daily cash report, (SOA) statement of account per customer on a monthly basis. 4. Processed cash applications, verified and posted cash payment receipts, verified credit card payments, applied appropriate tax calculation. 5. Prepared direct debit and fund transfer and checked settlements of discounts & grants. 6. Processed and resolved salesforce on queue as part of CRM Customer Relationship Management. 7. Calculated output VAT, discounts, interest, commissions, proportions & percentages. 8. Monitored and analyzed AR Aging and initiated correspondence with customers for collection of outstanding balances or overdue items. Technical Skills Used: SAP, Microsoft AX Dynamics, Salesforce, Account Management, Bank Reconciliation, Financial Reporting, Variance Analysis, Budgeting and Forecasting, Bookkeeping, VAT, Petty Cash, Payroll Accounting, Revenue and Expense Reporting Jun 2011 - Sep 2011 Audit Assistant - Toyota Financial Services, Philippines (Auto Company) 1. Liaised with Team Managers on a regular basis, performed work and provided related deliverables. 2. Maintained working knowledge of the User Guides and assisted Auditors in resolving issues arising in their work/delivery of services. Technical Skills Used: Oracle System, Microsoft Visio, VBA Visual Basic Application, Process Flowchart, Gap Analysis, IT General Controls, Risk Management, Anti Money Laundering Act Compliance Authentication Certificate & Reference shall be given upon request. GARCO GENERAL ACCOUNTANT ROSEMARIE COFILAN GENERAL ACCOUNTANT introduce ABOUT ME 10+ years working experience as accountant. Aiming to automate accounting minimum processes cost yet for a providing effective & efficient performance as I value trust and quality service of my clients. ROSEMARIE cOFILAN PROFILE My Philosophy Embracing technology and creating solutions that enable my clients to become more efficient, identify opportunities for change, and grow their businesses. My Mission Give you the right figures to help in your financial decision making. My Vision Diversified, multinational customer base delivering mission to success whilst retaining best talents & trends My Goals Provide transparent financial view for a minimum cost whilst providing effective & efficient performance WORK BACKGROUND FULL TIME - Falcon Pool, Dubai General Accountant Contracting Company - Kenzie Building Services, Dubai General Accountant Contracting Company - The Yellow Bulb, Dubai General Accountant Advertisement & Marketing Agency WORK BACKGROUND FULL TIME - LETO Restaurant, Dubai Accountant Restaurant - Digits Trading, Philippines Audit Analyst Trading, Restaurant & Retail - Music Group, Philippines Financial Specialist Manufacturing & Retail WORK BACKGROUND PART TIME 2020 Investment Companies • Next Level Ltd. AUS • Synthesis Investment US • Sentegram Inc. US Real Estate Companies • Al Furjan UAE • Next Home Inc. US 2020 E-commerce Companies • Cool Gearz US • Elara Shop US • Twin Cities Commerce US • Omnivation US • Smart Solution Group US Accounting Firm • Global Business Outsource US GENERAL ACCOUNTANT ROSEMARIE COFILAN Experience In Review BILLING - Sales Invoicing - Accounts Receivable Mgt. - Customer Account Mgt. PAYABLES - Bills or Expense Posting - Accounts Payables Mgt. - Vendor Account Mgt. - Expense Categorization GENERAL ACCOUNTING - Journal Entries Posting - Bank Reconciliation - Balance Sheet and Profit & Loss Reconciliation FINANCIAL REPORTING - Financial Analysis - Financial Dashboard Creation - Verify and prepares financial reports BILLING PAYABLES GENERAL ACCOUNTING Manages your sales invoicing that enables you to view your best performing product/service and customer's outstanding balances. Manages your expenses whilst optimizing cash and credit capacity by managing the timing and flow of purchase. Journalizing entries, reconciling your accounts in order to verify accuracy of posted transactions prior to financial reporting. FINANCIAL REPORT SAMPLES What I can offer you Real time view of your financial performance in order to track, analyse and report your business income and expenses. How I work? Approach 1 Account Assessment Approach 2 Prepare findings, clear queries & recommend Approach 3 Timely Reporting of financial transactions through real time dashboard Approach ACCOUNT ASSESSMENT Knowing your business account or company structure to incorporate best accounting policies & standards. Approach Findings Give a striking overview of the problem and explain it briefly. Questions Your insights and feedback matters to improve financial accuracy and process efficiency. Recommendations Frame the findings effectively to execute accordingly. Approach 40 FINANCIAL DASHBOARD Where is your company currently at? Visualize with a graph to highlight important developments. 30 20 10 0 Item 1 Item 2 Item 3 Item 4 Item 5 READY TO HELP YOU! CONTACT ME! Mobile & Whatsapp: - Email:-Skype:-