Accounts and Admin Officer
BIN HARMAL TRAVEL AGENCY (GSA Emirates Airlines)
Total years of experience :14 years, 10 Months
• Checking and reconciling the issued Air Tickets, Hotel Vouchers and Insurance by the travel consultant against system sales report in order to properly record daily sales.
• Encoding and computing of commission using Back Office Sales Sytem (BOSS).
• Generating of Sales Report per Airline as requested by the client companies.
• Detailed Recording of Receipt Vouchers in order to reconcile with the Bank Statements Generated. Encoding new City Codes for IATA based Destinations.
• Controlling of Petty Cash and handling Daily Cash Sales to be deposited to the bank.
• Verifying invoices for Clients that corresponds with the LPO provided.
• Receiving cheque payments from clients together with the credit card settlement for every month. Monitoring the Receipt Vouchers using spreadsheets to have immediate reference.
• Duly monitors the transmittal of documents to clients and suppliers via manual records and online system by courier providers.
• Handles Tender/Bidding Participation for both private and government clients.
• Using Global Distribution Systems such as Amadeus, Emquest-Sabre, Galileo for reconciling ticket sales.
• Attended the comprehensive VAT Seminar of Ministry of Finance and undergone a VAT Training under Time Training Center.
• Prepares letters to different offices such as Partners, Government Offices and Utility Companies. Controls the Service Level Agreement for contracts.
• Initiates the Sales Summary Report form system to spreadsheets using various formulas and functions.
• Duly monitors Post Dated Cheques (PDCs) and creating a notification to deposit due cheques.
• Created various formats for Audit Letter, Credit Request, Client Registration Facility.
• Handles Purchasing functions and IT related transactions especially email configuration and Network Troubleshooting.
• Checking of Sales Report from 7 Branches of Figaro’s Pizza across Abu Dhabi, Dubai and Sharjah both cash and credit card sales.
• Prepares the Daily Sales report submitted to the Finance Manager and Operations Manager.
• Compares the Target Sales against the Actual Sales from weekly and monthly reports.
• Encodes the prepared sales report in Microsoft GP Accounting System.
• Creation of Microsoft Excel Macro Command to generate the Sales Report Template for the 7 Branches.
• Attends monthly inventory to facilitate variance analysis between Actual Sales and Goods released.
• Performs bank reconciliation from cash deposited and sales report generated.
• Generates store performance reports based on sales and top selling items from the menu.
• Receive trade & non-trade payables from Project Control Division, Financial Analysts of Abreeza Mall & Residences
• Encode payable transactions to Transaction Reference Monitoring Report and regularly updates the file.
• Updates Cash Balance Summary for Money Market Placement purposes, oversees the expected disbursement per week to anticipate cash for money market.
• Sends request for Check Preparation to Aprisa Manila for voucher preparation.
• Prepare checks for payable transactions and maintains bank account balances for disbursements and deposits.
• Prepare Check Monitoring Report for General Deposit, General Disbursement & BPI Paseo Account of Abreeza Mall.
• Send Day’s Report of scanned & emailed payables to site operations head.
• Prepares template & requests for Vendor Master Data creation.
• Perform Cash Clearing & Document Reversal for payable transactions.
• Request for Check Cancellation Form for cancelled checks.
• Filing and sorting of paid transactions.
• Handle communications of Vendor queries regarding payables.
• Generate Form 2307 for Vendors using SAP as requisite for tax filing at Bureau of Internal Revenue.
• Handling Banana Export Sales for Japan, China, Korea, Russia and Middle East Countries (e.g UAE, KSA).
• Receive and allocate Shipping Advice for Banana Export Sales both Containerized and Chartered Loading.
• Submits Price, Bill of Materials and Box Costs upload template to SAP technicians.
• Prepares sales order templates for Export Sales.
• Issues the Delivery Receipt for Banana Export Sales.
• Encode goods receipt on SAP for Direct Loading Shipment of bananas.
• Requests Transfer of Materials (Cartons) from Packing Houses to Port Operations.
• Prints Commercial Invoices submitted to Marketing Department.
• Prepares Containerized and Chartered Loading Report for Bookkeeping Section.
• Computes total sales volume per period and year to date summary.
• Executes PowerPoint Slides for Bookkeeping Reports especially on Overhead Details.
• Performs reconciliation of total sales volume per week, period and year to date using actual data and system data.
• Performs Aging of Accounts Receivable.
• Prepares Supervisor’s Report for the summary of receivables ageing submitted to the Finance Manager.
• Attends Periodic and Quarterly Inventory for boxes, plastics and pallets.
Collaborated with a partner to do a research on the "Traits and Profitability of Franchised Business in Davao City" This includes the Education, Financial Capability and Awareness of the upcoming franchisee in owning a franchised business. Attended the Seminar on "Writing the Review of Related Literature"
STRATEGIC PLANNING: PRIVATIZATION OF MOTOR VEHICLE INSPECTION SYSTEM (MVIS) IN THE PHILIPPINES
