Rosemarie Ofilan

VARCO VIRTUAL ACCOUNTANT ROSEMARIE C. OFILAN VIRTUAL 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 OFILAN VARCO 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 My Vision Provide real time and transparent financial performance view Diversified, multinational customer base delivering mission to success whilst retaining best talents & trends My Goals Help clients to automate accounting processes for a minimum cost whilst providing effective & efficient performance WORK BACKGROUND FULL TIME - - - Kenzie Building Services, Dubai The Yellow Bulb, Dubai LETO Restaurant, Dubai General Accountant Carwash & Repair Services General Accountant Advertisement & Marketing Agency Accountant Restaurant WORK BACKGROUND FULL TIME - - 2011 Digits Trading, Philippines Music Group, Philippines Toyota Financial Services, Philippines Audit Analyst Trading, Restaurant & Retail Financial Specialist Manufacturing & Retail Internal Auditor Automobile Financial Services WORK BACKGROUND PART TIME 2021 Investment Companies • Next Level Ltd. AUS • Synthesis Investment US • Sentegram Inc. US 2017 E-commerce Companies • Cool Gearz US • Elara Shop US • Twin Cities Commerce US • Omnivation US Real Estate Companies • Al Furjan UAE • Next Home Inc. US Accounting Firm • Global Business Outsource US • Smart Solution Group US VIRTUAL ACCOUNTANT ROSEMARIE C. OFILAN My Services 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:- ROSEMARIE OFILAN BACHELOR OF SCIENCE IN COMMERCE MAJOR IN INTERNAL AUDITING 10 Years WORKING EXPERIENCE FULL TIME Jan 2021 - July 2022 General Accountant-Kenzie Carwash Dec 2018 / Dec 2020 General Accountant - The Yellow Bulb, GOALS Automate Accounting Processes Transparent financial reporting Dubai (Advertising & Marketing Agency) Apr 2017 - Aug 2018 General Accountant - Leto, Dubai (Food and Beverage Company) Skills Mar 2015 – Feb 2017 Accounting Audit Analyst - Digits Trading Corp., Communication Philippines (Merchandising) Problem Solving Sep 2012 -Feb 2015 Financial Specialist - Music Group Technical Offshore Macau & PH (Manufacturing) Management Jun 2011 - Sep 2011 Critical Thinking Audit Assistant - Toyota Financial Services, Philippines (Auto Company) --Dubai Marina, UAE FREELANCER Since Year 2017 - 2021 Pinpoint Local UK (SEO Firm) Global Business Outsource US (Accounting 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, Xero and Clickup EXPERIENCES IN FULL REVIEW Jan 2021 - July 2022 Kenzie Building Services Dubai 1. Setup quickbooks chart of accounts and migrate data. 2. Reconciles financial discrepancies by collecting and analyzing account information. 3. Documents financial transactions by entering account information. 4. Recommends financial actions by analyzing accounting options. 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 documents. 7. Maintains accounting controls by preparing and recommending policies and procedures. 8. Provides financial information to management by researching and analyzing accounting data; preparing reports. 9. Prepares special financial reports by collecting, analyzing, and summarizing account information and trends 10. Prepares payments by verifying documentation, and requesting disbursements. 11. Reconcile account of customer and vendor to get an updated view of 12. Guides accounting clerical staff by coordinating activities and answering questions. 13. Delivered Customer Support task such as answering client’s and other stakeholders’ inquiries, booking client’s orders & maintained customer relationship management tracker. 14. 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.