Finance Supervisor
Qatar Airways
Total years of experience :14 years, 4 Months
QR AR Functions.
➢ Accounting of receipts on daily basis and set-off against respective invoices.
➢ Accounting of Credit memos for collection through ICCS
➢ Raising invoices in case of BSP negative billing
➢ Raising of ACMs to the agents for PLB and Incentives
➢ Review and analysis of AR ageing debtor balances, Follow up for recovery of outstanding dues
➢ Raising of ADMs for GDS Misuse/O & D violations/Chargeback through BSP link (for IATA agents) and Invoices (Non IATA agents)
➢ Verification, reconciliation and setoff of Daily CTO/ATO DSR, Cash and CC Sales collection and Deposits
➢ CC related bank receipts to be provided to HO CC posting team (SGS) for local settlements.
➢ Verification, reconciliation and setoff of BSP (FOP Cash/CC) transactions in BSP customer account
➢ Verification, reconciliation and setoff of CASS sales transactions in CASS customer account
➢ Extract from acquirer’s Merchant statements, compile, analyze and reconcile debited ARC Chargeback Cases to ensure appropriate actions are taken to protect QR’s interests.
➢ Perform Reconciliations of CNS billed Transactions at AWB level against received Settlements through CNS Paid file. This is to ensure the received settlements are accurately allocated to Invoices and where balances exist, business are provided with details for recoveries.
QDFC AR Functions.
➢ Accounting of receipts on daily basis and set-off against respective invoices.
➢ Issuing invoices to QDFC concessions for MAG, Percentage rent, Utility, Manpower, cashiering and other recharges.
➢ Issuing invoices to QR for Qmile redemption at QDFC shops.
➢ Issuing invoices for QR inter-company credit sales.
➢ Issuing invoices to Vendors for BA’s as per BA agreement on Monthly basis.
➢ Issuing rebate invoices to Vendors on yearly basis.
➢ Ensure monthly invoicing is done on given deadline
➢ Preparing balance sheet schedules.
➢ Preparing monthly dashboard for QDFC and F&B
➢ Monthly Website Sales and Qmile Sale Reconciliation.
➢ Receiving invoices from supplier and verification of invoices as per purchase order and contract.
➢ Booking invoices in Oracle AP module and forwarding the same to respective departments for approvals.
➢ After receiving approved invoices from different departments verifying the HODs signature as per specimen signatures provided by HIA COO Office.
➢ Checking of payment terms as per purchase orders or contracts.
➢ Calculation of penalty for delay in completion of work or delivery of goods and shortage of etas for manpower invoices as per PO or contract terms.
➢ Processing payments of due invoices in monthly batch.
➢ Assisting lead officer to prepare payment release plan.
➢ Releasing the payments as per payment plan.
➢ Preparing daily bank reconciliation.
➢ Following up with bank for payment non-debited and reversal payments queries.
➢ Getting fixed deposit rates from bank and placing FDs for HIA.
➢ Handling performance bond and advance payment bank guarantees for HIA.
➢ Handling and reimbursement of petty cash expenses of different HIA departments as per petty cash policy.
➢ Submitting balance sheet schedules on quarterly basis
Issuing EBT and EMD for Qatar Airways and Other airlines.
➢ Collection of excess baggage payment for QR and other airlines.
➢ Issuing EMD and EBT for excess baggage collection.
➢ Updating porterage tags sale in SharePoint.
➢ Monthly porterage tags sales reconciliation and tallying with Oracle General Ledger balance.
➢ Updating credit card sales in share point and daily reconciliation with bank statements.
➢ Helping seniors in making bank deposit and reconciliation with bank deposit slips.
➢ Preparing Journal Voucher for EBT Porterage and Oryx Lounge for daily basis and uploading in Oracle.
➢ Preparing different reports as per finance department requirement.
➢ Preparing Qatar Airways Weekly EBT sales reports.
➢ Updating EBT EMD reports of Qatar Airways in Share point.
➢ Segregating EBT audit and office for Qatar Airways and other airlines.
• Maintain bank account; cash counting & deposit to bank.
• Preparing trial balance & Profit & Loss Account and Balance sheet.
• Bank Reconciliation & ledger Account Reconciliation
• Assist with completion of necessary statistical reports as requested.
• Maintain daily and monthly expense and invoice report on excel.
• Type word process documents as needed.
• Verifying and checking all the all-party ledger accounts for T.D.S. deductibility.
• Prepare & finalize VAT Returns, CST, Service Tax & TDS Return
• Making Details of C-Form, ST-38
• Maintain Inventory Record on Computer.
• Stock Reconciliation Statement.
• Entries of cash Book, Sales Bills & Purchase Bills etc
• Making Vouchers & Entries in Computer.
Maintaining financial records and establish and preparation of Trial Balance up to Finalization of Balance Sheet and preparation of Financial statement, Preparation & Posting of vouchers entry, Ledger posting, verification and reconciliation.
Maintaining relationship with customer and follow up for outstanding payments.
Keeping company cash records properly & preparation various reports
Preparing company Cash flow report
Calculate and prepare Payroll and other Bills
Examine and analyze Journal and Ledger Entries, Bank Statement, Expenditures, other
Accounting and Financial Records
Reconciliation of Bank accounts, Suppliers and Customers Accounts
• Maintained Daybook, Sales, Purchase & Stock Registers, Sales returns
• Daily data entry of sales, purchase and stock
• Maintain cash and bank book
• Cross check daily sales and deposit to bank.
• Bank reconciliation
• Supporting Senior Accountant for preparing TB, P&L Account and Balance sheet.
• Handled Bank Reconciliation.
• Key member for annual inventory team
• Support Senior Accountant for all administrative work