FROILAN JOIE L. BARILA, CPA
#237 Lilac Street, West Fairview Quezon City, NCR Philippines
- /-/-/ skype: froilanbarila
CAREER OBJECTIVE:
Challenging positions that can provide the modest avenue to hone, utilize, and enhance my technical skills and knowledge as a Certified Public Accountant and such other fields of expertise related to my chosen career.
PROFESSIONAL QUALIFICATION
Certified Public Accountant (C.P.A)
License Registration Number -
Valid until – July 1, 2019
HIGHLIGHTS OF QUALIFICATIONS
Senior Accountant – Responsible for the preparation of financial statements ( Income Statement, Balance Sheet, Bank reconciliations) of 3 fuel retailing company, computation for semi monthly payroll, computation of VAT and other ad hoc reports and documents.
Senior Auditor (Internal) - Overall task is to ensure the accuracy, completeness and validity of the accounting transactions entered into the system ( Quickbooks or Spreadsheet). Determine critical points in the system that might lead to fraudulent reporting and employee theft, witness inventory count and spot audit and various financial analyses.
Special Audit – Handles special cases of other subsidiaries; bank reconciliations, tax matters, account reconciliations, and other ad hoc tasks.
Financial Advisor - Implementation of FIFO costing method and FIFO inventory system, Cost-Volume-Profit Analysis (CVP Analysis) to maximize income potential and movement of cash.
Support in setting up of Accounting system, policies and procedures to newly opened business.
General Accounting Analyst – Account reconciler of general accounts of one of the largest retailing company in North America (Bank Reconciliations, Prepayments and Accrual reconciliations, Amortizations of lease and depreciation schedules, month – end closing of books, preparation of Financial statements and financial analysis.
Junior Auditor (External) – Support for the external audit function under supervision on an immediate head – Field work, preparation of Financial Statements (Balance Sheet, Income Statement, Bank Reconciliation), filing and payment of applicable taxes and dues.
People Management – Ability to handle individuals (Accountants) with different nationalities and workplace to keep the weekly, monthly and annuals goals are achieved with efficiency.
EMPLOYMENT SUMMARY
September 05, 2016 to July 7, 2017 Senior Accountant
Snowy Mountains Engr. Corporation - ROHQ
March 20, 2012 to April 30, 2016 Accountant
Al Mutabagani Health Services Group
Riyadh, Jeddah, Yanbu, Jubail and Dhahran
Industry Exposure: Retailing (Cosmetics), Head Office / Intercompany accounting and Consolidation.
General Role:
Accounts Receivable Accountant
Daily Tasks:
Upload and process sales from Sales invoice module to Oracle system and General Ledger.
Receive collections from customers, update outstanding accounts and prepare bank deposits.
Enter Sales returns (Credit memorandum) to individual customer’s accounts and General Ledger.
Enter Debit memorandum in cases of over collection, error on application of collection, and excessive sales return.
Answer to queries of customer and sales representatives.
Daily reconciliation of cash received and deposited.
Monthly and Period Close Tasks:
Preparation of Aging of Accounts Receivable as of month end.
Preparation of Customer’s Statement of Accounts for confirmation.
Prepare Accounts Receivable, Sales, and Sales returns and collections reconciliations against General Ledger.
Prepare Adjustments for any discrepancies found on reconciliations.
Prepare Ad-Hoc reports as needed.
Intercompany Accountant
Daily Tasks and Period Close Tasks:
Confirm and validate intercompany charges.
Enter intercompany charges to General Ledger.
Answer to queries of accountants from sites with regards to charges.
Prepare debit / credit memorandum to sites.
Prepare Intercompany Statement of Accounts.
Reconcile Intercompany records as against confirmations from sites.
Prepare necessary entries for reconciliation.
Fixed Assets Accountant
Period Close Tasks:
Enter Additions on Fixed Assets as of period close.
Enter Transfer, Retirement, and Sale as maybe necessary.
Generate month end report on net book values of Fixed Assets.
Payroll Accountant
Period Close Tasks:
Confirm correctness of attendance summary as against to individual time sheets.
Prepare monthly payroll for Head office and Pharmaceutical employees and reflect on General Ledger.
Prepare payment slip and individual computations.
Prepare check and bank payment voucher’s and fund transfer form for bank transfers.
Prepare computation for employees availing vacations and reflect on General Ledger.
Bank Reconciliation and Cash flow
Period Close Tasks:
Prepare monthly bank reconciliations for the Head Office and the Pharmaceuticals and Cosmetics Division upon bank statement availability.
Update monthly Cash position.
Prepare monthly Cash flow (Projected & Actual) for the Head Office and Pharmaceuticals and Cosmetics Division.
Financial Statements Preparation / Consolidation / Analysis
Balance Sheet
Profit and Loss Statement
Cash flow Statement
July 4, 2010 to February 29, 2012 Senior Accountant / Auditor
Ramon S. Ang Group of Companies
Premier Capital Venture Corporation
Industry Exposure: Petroleum Company, Aircraft Charter, and Heavy Equipment rentals.
General Role:
As a Senior Accountant in a Group of Companies my primary role revolves around Accounting and Auditing fields, I perform as an accountant or Auditor on other companies that make us flexible. Our accounting tasks includes entering transactions on a day to day basis, monitoring and reconciliation of accounts, aging of past due accounts, preparation and analysis of Financial Statements (Balance Sheet, Income Statement, Cash Flow Statement, Statement of Equity), filing and preparation of VAT among others. Out Auditing Tasks includes checking the accuracy or entered figures in the system based on supporting documents and proofs, updates on the past due accounts, updates on the government imposed requirements, cash and inventory counts and special audits.
Daily and Weekly Tasks:
Input Transactions thru QuickBooks or Spreadsheet
Accounts Reconciliation
Aging of past due accounts
Check preparation for payments
Cash transfer reconciliations
Logging in of documents received as support.
Daily checking of Checks for billing and payments from other subsidiaries and affiliates
Visitation on Government sites for updates.
Monthly Tasks:
Preparation of Financial Statements (Balance Sheet, Income Statement, Cash flow Statement and Statement of Equity.
Witness of monthly Inventory count.
Preparation and payment of payroll.
Bank Reconciliation preparations.
Issue resolutions on items with conflict.
July 1, 09 – Mar. 31, ’10 General Accounting Analyst
IBM BUSINESS SERVICES
UP Ayala Technohub, Diliman Quezon City
Industry Exposure: Retailing, Food and Beverage, Financial Services
General Role:
As a general accounting analyst my primary role is to maintain specific accounts for assigned business areas for our client Sara Lee that is based on North America. Our job includes normal day to day entries, adjusting, correcting and reclassifications (through SAP) updating amortization tables, bank reconciliations, and other account specific reconciliations. We also communicate with individuals in the assigned business areas to confirm the above said entries and even with banks.
Daily and weekly accounting task:
Monitor and upload book and bank transactions through TRecs for reconciliation.
Matching of book and bank items by the TRecs application and spreadsheet.
Monitor plant originated accounting entries for supporting documents, accuracy and completeness – email responsible party if there are inquiries and resolutions.
Accounts reconciliation specifically with 7 – day reconciliation deadlines.
Update unusual items and issues log with corresponding resolutions.
Update aging items log and email responsible party for clearing or resolutions.
Check weekly payroll deduction postings on plants.
Check postings on miscellaneous items account for unusual entries and email responsible party for clearing.
Respond to plant specific inquiries by plant accountants and other parties.
Compilation and filing of bank statements for bank reconciliations for plants.
Adjusting, correcting and reclassification of entries if appropriate and back up explanation and supporting documents.
Monthly and Period close tasks:
Account reconciliations and upload on Trecs for monthly reconciliations
Items clearing on aged and unusual items on the miscellaneous items account.
Accomplish tasks listed in the period close checklist and send to plant financial manager for checking.
Monitor postings on the expense accounts for accuracy and support documents.
Check amortization on prepaid items.
Prepare accounting entries for accruals of expense, salary deductions, amortizations and other plant specific entries
Generate Financial Statements thru SAP and perform financial analysis.
Log any findings upon the financial analysis and email responsible party for resolution.
Closing of books of accounts of the plants under responsibility.
May 23, ’08 – June 15, ’09 Junior Auditor / Accountant BOTE, ALVAREZ & Associates
Novaliches, Quezon City
Industry Exposure: Retailing, Food and Beverage, Liquefied Gas Refilling Company, Drug Stores.
General Role:
Entered the firm as on the job trainee that is taught primarily to gather and prepare the data for the audit from invoices and books, confirm footings, transfers gathered data to the worksheet, prepares adjusting entries and generates financial statements and supporting schedules and notes. After training, requested to handle the audit of two franchise client’s and an LPG Refilling Corp under supervision.
Daily and Monthly tasks:
Field work to client for data gathering purposes.
Preparation of Financial Statements ( Statement of Financial Position, Performance and Cash flow)
Filing and Payment of tax dues, VAT and other payables.
Inventory count.
Bank reconciliations
Presentation and discussion of Financial Statements prepared to the client.
Preparation of other government mandated and client requested reports.
Issue resolutions and other ad – hoc documents.
February 10- May 31’ 07Support Personnel
COMMISSION ON ELECTIONS
Hagonoy, Bulacan.
March 31 – June 5 ’06Job Order Casual COMMISSION ON ELECTIONS
Hagonoy, Bulacan
Industry Exposure: Government agency
General Role:
As a support personnel we are tasked to suffice the needed manpower for both the preparation and the culmination jobs of the election proper (for the National Election) these includes the transport and distribution of election paraphernalia’s, ballot boxes, election supplies, and maintaining the peace and order, etc.
Daily tasks:
Sorting and repacking of elections paraphernalia’s and supplies.
Transport and distribution of those paraphernalia’s to remote sitio’s for election consumption.
Update of voters records.
Entry of newly registered individuals.
Printing of voters list
Deleting non – active voters
OVERALL SUMMARY
More than 7 years of collective experience in major aspects of Accounting namely; Auditing (internal and external), General accounting, Accounts Reconciliations, Financial Advisory, and special audits.
About a year of experience on office and admin works of a Government agency.
Expertise focuses accounting and audit of retail enterprises (food and beverage, petroleum products, Liquefy petroleum refilling company, bakeshops and drug stores).
Hands on experience on a multinational retail company accounting and internationally recognized accounting software (S.A.P, Auto JE and TRecs) applications.
Hands on experience in various accounting software accepted globally.
Ability to easily comprehend on new knowledge and system to be used in work.
Intense desire to learn new technologies and willingness to work on shift and holidays
Industrious and can work well under pressure
Amenable of working on a diversified environment and workplace.
Good command of both spoken and written English.
Meaningful professional experiences from domestic to international companies.
Experience in Process migration from Australia to Philippine companies.
Freelance work exposure.
ACCOUNTING SOFTWARE HANDLED
EPICOR
S.A.P ( R3 Version )
Oracle Financials Applications ( 11i version )
JD Edwards
TRECS Applications ( Total Reconciliation Solutions)
I.F.C.A Applications (Information for competitive Advantage)
QuickBooks Desktop and Online Accounting Software
XERO
MYOB
COMPETENCIES / SKILLS
Advance computer literacy (Microsoft Applications)
Knowledgeable in various office equipment operations
Hands on experience in filing and data archiving
Computer operations and word typing
Good oral and communication skills
EDUCATIONAL ATTAINMENT:
COLLEGE:NATIONAL COLLEGE OF BUSINESS AND ARTS - FAIRVIEW
Bachelor of Science in Accountancy
Fairview, Quezon City
2004 - 2009
SECONDARY:NORTH FAIRVIEW HIGHSCHOOL
Auburn Street, North Fairview Quezon City
2000 - 2004
PRIMARY:FAIRVIEW ELEMENTARY SCHOOL
West Fairview, Quezon City
1996 – 2000
TRAININGS AND SEMINARS
Title Date
Customer Service Training July 3 & 6, 2009
(Conducted by Dominique Anne V. Zapata)
Effective Business Writing July 7 – 8, 2009
(Conducted by Ashly L. Marquez and Chester Lawrence Caras)
Problem – Solving Decision making July 9, 2009(Conducted by Edgardo Agustin E. Navarro)
Advanced Excel TrainingJuly 23 – 24, 2009 (Conducted by Wilkins Win Wong)
PERSONAL DATA
Date of Birth: July 1, 1987 Nationality: FilipinoSex: MaleHeight: 5’7”
Birthplace : Manila, PhilippinesReligion : Roman Catholic Civil Status: Married
CHARACTER REFERENCES:
Shall be furnished upon request
