Mary Grace Rebueno

Mary Grace Ligores -Rebueno, CMA City Address: Brgy. Cruzada, Legazpi City, Albay Philippines 4500 Contact Nos. : + -/+ - E-mail Addresses:--Skype ID: mary.grace.ligores ELIGIBILITY: Certified Management Accountant (CMA) EMPLOYMENT HISTORY: ONLINE/ HOME BASED JOBS Dunn Wysely LLC- US Accounting Firm Senior Bookkeeper November 1, 2019 to June 15, 2020 Duties and Responsibilities: 1. Managed end to end bookkeeping services to clients- Ecommerce (Amazon and Shopify), Distributing Companies, Repair Shops and manufacturing companies. 2. Prepares Weekly Financial reporting such as SKU reporting, KPI, Weekly sales target. 3. Cashflow Forecasting and Budgeting 4. Provides Management Advisory Services such as Strategic Planning, Business Planning and budgeting. 5. Super user of Amazon Seller Central, Quickbooks and Xero. 6. Data migration and provide start up financial system account. 7. Supervise 5 bookkeepers. Accounting system, Software applications and technical skills: 1. Quickbooks Online, Desktop and Xero 2. Amazon Seller Central, Shopify and Ebay 3. A2x, Gusto (bank feeds), ADP (Payroll) 4. Fluidly.com (Cashflow tool) Turner Invest LLC- London, UK- Service Accommodation and Investment Company Finance Manager July 7, 2017 to October 22, 2020: Duties and Responsibilities: 1. Maintaining books of all companies- bank feeds clearing, sales invoices, purchases and bills, prepayments, accruals and advances. 2. Prepares timely financial statements- weekly, monthly, quarterly and year – end. 3. Prepares Investor’s financials on monthly basis and provides inputs and write ups on the result of financial position and performance. 4. UK Tax preparation- VAT and Corporate tax. 5. Prepares UK Payroll for 10 employees and 6 Virtual assistants (Philippine based). 6. Prepares and maintaining Cashflow Management. a. Budget and financial planning- 5 year forecast b. Daily Cash Position c. Investor’s cashflow d. Cashflow per Service Apartments. 7. Manage the finance team process- bills and payments, collections and Sales invoicing. Page 1 8. Coordinate directly to the investors, operation managers and directors of the company for the ff: a. Investor’s financial results b. Sales targets, actual sales monitoring c. Expense Claims d. Key Performance Indicators (KPI). 9. Super user of Xero, Newbook (Booking system) and data integration. 10. Create, prepares and implement Process Flow Documents for Finance. Accounting system, Software applications and technical skills: 1. Xero 2. Newbook 3. Airbnb, Booking.com, Stripe, Online banking, Paypal 4. Fluidly.com (Cashflow tool) CG Trade - U.S. E- Commerce online business (through Onlinejobs.ph) Accountant and Inventory Analyst – Project Based January 2017 to July 2017: Duties and Responsibilities: Inventory Management: 1. Manage Amazon and Ebay Sales orders by order reconciliation of sales and purchases. 2. Ensure daily sales monitoring are done and reported to the Operation Manager. 3. KPI preparation for inventory inflow and outflow. 4. Data entry of customers and vendors in the system (Quickbooks and Webui) 5. Assist Customer Service issues in regards with the refunds, claims. 6. Ensure effective inventory management are held and accurate reporting. Finance a. To assist in the administration of a range of Finance procedures and to ensure that the use of resources is adequately monitored and controlled. b. Contribute to the planning, development and monitoring of support services and financial management. c. Prepares Financial Statement report to the Management using Amazon Seller transaction details. d. Reconciliation of orders, sales and profits. e. Reconciliation of Paypal transactions against Quickbooks transactions. f. Account classification for tax filings. g. Preparation of Standard Operating procedures for Finance and Accounting. h. Prepares weekly and monthly Financial reports dealing with Profit and Loss by product margin, geographic location and consolidated profit and loss for three companies. i. Recording of financial transactions in Quickbooks. Accounting system, Software applications and technical skills: - Quickbooks and Xero - WebUi, Freshdesk, Dear Inventory - Amazon Seller, Ebay and Shopify Page 2 Wicked Weasel Apparel Australia (through Onlinejobs.ph) Senior Bookkeeper July 2015 to December 2016: Duties and Responsibilities: • • • • • • • • • • • • • • Preparation of Profit and Loss Accounts and Balance Sheets End of month journal entries Bank, Paypal and Sales Reconciliation Management of purchasing, coding and GL impacts Payroll management and processing (weekly) for up to 100 employees including superannuation, PAYG, leave adjustments, etc. Domestic and International creditor pay runs Cash flow forecast review and management Liaise with external accountants regarding tax & financial statement preparation Assist auditors as required, including ensuring audit file is complete Budget preparation and management of budgeting process Other tasks as may be requested by the Directors BAS Filing and Lodging GST Reconciliation for sales and purchases Tax Account Reconciliation Standard Operating Procedures creation and implementation OFFICE BASED EXPERIENCES Shell Shared Services B.V. Asia (Providing Services to Shell Canada Limited) 19th Floor Solaris One, Corner Dela Rosa Street, Legaspi Village, Makati City, Philippines November 28, 2011 to June 30, 2015: Position: Financial Accountant (NGL Division) Duties and Responsibilities: a. Financial Reporting ➢ Prepare monthly trial balance and exported the NGL financial statement to GSAP for the consolidation of all Shell Canada Limited operating units. ➢ Monitoring of all GL Accounts especially the Cash in Bank, Accounts Receivable, Accounts Payable, and Taxes. ➢ Make a thorough analysis of Profit and Loss statement. ➢ Prepare Financial Analysis and forecasting and reported to Finance Advisor from Shell Canada. ➢ Overall in charge for month end, quarterly end and annual closing of books. ➢ Overall in charge for reconciliation of taxes. ➢ In charge for the Group reporting package for consolidation and quarterly reportorial. b. Compliance Reporting 1. Internal Reporting ➢ Prepares monthly Cash Flow Forecasting to the Treasury Manager which is based in Krakow, Poland. ➢ Prepares Transfer Pricing Report for Shell Canada NGL Division and delivered to Revenue and Oil Accountants across Shell Canada, Shell US and Shell Netherlands. ➢ Prepares Global Performance Monthly Performance (GPMR) for credit aging review analysis of Credit Management. 2. External Reporting ➢ Monthly submission of Price calculation statements to all Point Tupper location vendorsit pertains to monthly flow of pricing in Nova Scotia, Canada to all purchases NGL products. ➢ Prepares monthly Inventory report to National Government of Alberta in Canadaconsists of monthly inventory receipts and deliverables of NGL products with corresponding prices. ➢ Prepares monthly submission of Purchase and Sales transactions reporting to National Energy Board of Alberta, Canada- consists of detailed report of all Purchases and Sales transactions of Shell’s NGL division. Page 3 ➢ Coordinating to Bureau of Internal Revenue and Local Taxing Authority of Alberta, Canada for the monthly Gross revenue Tax, Harmonized Sales Tax payments and local tax payments. c. Other ad- hoc roles ➢ Maintains Status of Accounts Reporting (SOAR) - pertains to monthly task of account reconciliation and reported to Manage Closed Team for overall consolidation and financial impact reporting. ➢ Assist the Billing and Settlement Analyst on the issues like billing issues, credit issues and GL account definition. (November 28, 2011 to September 25, 2013) Position: Financial Analyst (Agreement -NGL Division) Duties and Responsibilities: a. Financial Performance 1. Increases productivity by developing automated applications; eliminating duplications; coordinating information requirements for the following: ➢ Sales Invoices- validates the accuracy of billings to customers by scrutinizing the stock and pricing bookings. ➢ Purchase Statements- validates the timeliness of payments to vendors by matching the vendor’s records to Shell’s bookings. ➢ Approval and issuance of credit/debit memos. ➢ Avoidance of duplicate and incorrect billings and payments. 2. Analyzing the trends of revenues and expenses through: ➢ Preparation of Key Performance Indicator (KPI) monthly in able to deliberate the flow of revenue ad expenses. It also indicates the invoice accuracy and timeliness, stock recording performance and account reconciliation performances. ➢ Provides account reconciliations for receivables, payables and cash in banks. 3. Preparing spreadsheets, graphs, and charts to help illustrate financial trends. 4. Presenting financial information to Shell Canada’s counterparts. 5. Performing revenue and expense forecasts in order to make financial decisions. 6. Creating and reviewing financial records. 7. Coordinates to Cash and Credit Application team for the issues and queries with regards to billings. 8. Coordinates to Payment team and banks for the issues and queries of payments. b. Ad hoc roles/ Focal Positions ➢ Focal Role for Critical Incidents/Business Incidents (CCI/BCI) review- monitors the potential financial and compliance incidents of the team. ➢ Focal point for monitoring of FINSTA payments of the team. c. Special Projects ➢ Stock Inventory Reconciliation of Shell Canada Upstream. It pertains to managing stock reconciliation of Fuels, Barrels and Oil products between Shell and their Partners. ➢ General Ledger Reconciliation of Accounts Payable, Accounts Receivable and Dummy Accounts for Shell LPG Division. Former clients: a. Shell Canada- LPG and Chemicals Division b. Shell US Chemicals c. Shell India Limited Accounting system, Software applications and technical skills: a. SAP R3 b. Online payment system- Bank of Canada and JP Morgan Chase c. SAP Business Planning and Consolidation d. Entero One e. Bank Confirmation System (BCS) f. Business Financial Consolidation (BFC) g. Business Warehouse (BW) Reporting Page 4 Rapu-Rapu Processing, Inc. –a Rapu-Rapu Pollymetallic Project of LG International Group of Companies (Korea) (Providing Mining of Copper and Zinc minerals) Rapu- Rapu, Albay and Ortigas Center. Pasig City, Philippines (June 15, 2009 to September 15, 2011) Position: Corporate Treasury Accountant (Supervisory) Duties and Responsibilities: a. Treasury Management ➢ Prepares Daily Cash Position and monitors all the cash in and out transactions from all intercompany accounts. ➢ Supervising Treasury Assistants in preparation of checks and assures the accuracy and correctness of the details. ➢ Monitors the fund transfers, petty cash fund, Revolving Funds and Dollar Reserves. ➢ Prepares Bank reconciliations- monthly and annually. ➢ Posting all the cash disbursements and receipts in Pronto (Accounting System). ➢ Budgeting the cash reserves and allocates to various disbursements like payment to suppliers, contractors, payroll and foreign payments. ➢ Prepares and reconciles all cash advances attributed to Employees and Expatriates. ➢ Assist the suppliers and bank concerns. ➢ Reconciles Cash Advances to Employees, Supplier’s account on a monthly basis. ➢ Reports directly to the Treasury Manager and CFO the Cash Position daily and weekly especially the remittance from LG International (Mother Company). ➢ Conduct Cash Management Analysis, Treasury cash flows actual and forecasting. b. Compliance Reporting ➢ Monitors and focal point for the submission of tax payments to the BIR. -Excise taxes-Expanded withholding taxes, Compensation taxes -Local taxes ➢ Administers other tax issues of the Company. c. Ad hoc Roles ➢ Supervise and maintain controllership and migration of the SAP system for Corporate Finance Group. ➢ Assist the Treasury Manager for the Company’s Internal Control Review (Special Project). Accounting system, Software applications and technical skills: a. SAP R3 b. Pronto System c. Online payment banking system- BDO and Metrobank Acyatan & Company, CPAs- a Member of DFK International, London –Auditing Firm 12th Floor, The Columbia Tower, Ortigas Extension, Mandaluyong City, Philippines November 22, 2006 to November 4, 2008 Position: External Auditor- Senior Auditor Duties and Responsibilities: A. External Audit Description: To express an opinion into the financial statements with reasonable assurance and fairness of the financial statements of the clients. a. It involves audit fieldwork which comprise of examining the documents for the issuance of the financial statements. b. It involves year- end physical inventory counting and observing the valuations of the assets and other resources. c. Issuance of annual income tax return to all clients. B. Bookkeeping Services * Supervises the preparation of the financial reports for Management, external audit, taxation and other legal reporting purposes. * Reports directly to the President the financial condition and the results of operation of the Company. Page 5 * Performs analysis of selected accounts or transactions. * Performs other related functions assigned by the President or by higher Management. * Recording of daily transaction of the Company. * Prepares the financial statements to be reported to the client for approval. * Prepares SSS/PHIC/HDMF remittances for the clients. * Prepares payroll for the client’s employees. * Prepares BIR remittances like withholding taxes, VAT returns, Income tax returns and other payments to the BIR. C. Other Services a. Special Audit ➢ Cash and Receivables Audit ➢ Accounting System Audit ➢ Rehabilitation/ Re- organization audit ➢ Tax Audit Former clients: Audit Services: a. Rural banks and real estates in Quezon and Bicol province b. Distributor Companies c. Cold Storage services Bookkeeping Services: a. b. c. Sole proprietors-selling of jewelries Holding companies Philippines representative branches based in Singapore Isetann Department Store, Inc. Carriedo, Sta. Cruz, Manila, Philippines February 1 to July 17, 2006 Position: Expense Processing Clerk and Accounts Payable Clerk- CONTRACTUAL BASIS Duties and Responsibilities: ➢ Processing the company expenses and remittances to all government agencies like SSS, Philhealth and Pag-ibig. ➢ Processing of terminal pay of the employees. ➢ Preparing the monthly tax remittances of the company to the BIR. ➢ Reconciling the monthly expenses from the journal to the subsidiary ledger accounts. ➢ Preparing of gift cheques requested by the Merchandising Department. ➢ Processing the monthly electric, water and telephone expenses of the company. Accounting system, Software applications and technical skills: a. Oracle EDUCATIONAL ATTAINMENTS: January 6, 2013 to April 6, 2013 Certified Management Accountant (CMA) Program Institute of Certified Management of Accountants-Australia ( c/o Executive Managers of the Philippines)-Crowne Plaza, Ortigas Center, Pasig City College Degree- Polytechnic University of the Philippines- Sta.Mesa,Manila Philippines Bachelor of Science in Accountancy Secondary Education- Colegio de San Pascual Baylon- Obando, Bulacan - Academic Achiever Elementary Education- Colegio de San Pascual Baylon- Obando, Bulacan Page 6 SEMINARS/ CONFERENCES/ TRAININGS ATTENDED: April 2019 Cashflow and Workflow Management Institute of Certified Management of Accountants-Australia ( c/o Executive Managers of the Philippines)-Crowne Plaza, Ortigas Center, Pasig City January 2017 Intuit Quickbooks Online ProAdvisor Program Certification- Asia QBO Global Training Team- Intuit June 2015- July 2015 7 Habits of Highly Effective People Shell Shared Services Asia B.V.- Makati City August 2013 -September 2013 Active Based Learning (ABL)- Receiving and Giving Feedback Shell Shared Services Asia B.V. Makati City August 2012 Active Based Learning (ABL) –Effective Stakeholder Engagement Shell Shared Services Asia B.V. Makati City May 10-11, 2012 Lean Six Sigma –Yellow Belt Training Shell Shared Services Asia B.V. Makati City December 1-10,2010 SAP (R3) System Training and Implementation LG International Group-Korea- Project Team Member Rapu-Rapu Albay ______________________________________________________________________________________ PERSONAL Born on July 30, 1984 in Manila, Philippines under the Filipino Citizenship, Married. Excellent skills in Management Accounting, Auditing, Treasury and Taxation with significant exposures in various fields of industries like Oil Company, Mining and External Auditing. Technical proficiencies in the field of Financial Reporting, Group reporting, General and Financial Accounting, Management Accounting, Treasury Management, Taxation in the Philippines and Canada. Having a depth technical skills and knowledge in Accounting systems like SAP R3, Entero One, JDE Systems, FINSTA, Pronto System, and MYOB. Excellent in MS Word, MS Excel formulas and techniques, MS PowerPoint Presentation, and making graphs and charts. I can speak In English and Filipino fluently, flexible, hardworking, self-motivated, reliable, responsible and a team player. HONORS/ AWARDS RECEIVED: January 2014 Center for Finance Lead Awardee Shell Shared Services Asia B.V. October 2013 & August 2013 Center for Finance Lead Awardee Shell Shared Services Asia B.V. April 2013 Managed Hydrocarbon Inventory (MHI) Extra Miles Awardee Outstanding Employee of the 1st Quarter 2013 Shell Shared Services Asia B.V. October 2012 Managed Hydrocarbon Inventory (MHI) Extra Miles Awardee Outstanding Employee of the Year Shell Shared Services Asia B.V. January to March 2012 And August 2012 Center for Finance Lead Awardee Shell Shared Services Asia B.V. Page 7 AFFILIATIONS: January 3 2017 to Present July 1, 2013 to Present Intuit Quickbooks ProAdvisor QBO Global Team- Intuit ASIA Institute of Certified Management Accountants Australia REFERENCES Mr. Greg Bio Audit Manager- Acyatan & Co., CPAs Ortigas Avenue, Mandaluyong City Mr. Ryan Suarez Team Manager–Shell Shared Services B.V. Asia Makati City I hereby certify that above information are true and correct. ______________________ Applicant’s Signature Page 8 Page 9