DEADLINE: 15/11/2024

Revenue Accounting Consultant

Full-time

We are hiring a Revenue Accounting Consultant

The airline has implemented the Amadeus Revenue Accounting system to manage its complex revenue accounting needs. The complexity of airline revenue accounting, driven by dynamic pricing models, ancillary revenues, and varied ticketing policies, requires specialized expertise. Uganda Airlines recognizes the need for expert guidance to build a robust Passenger Revenue Accounting (PRA) function that aligns with global standards and leverages technology for optimal revenue management. This focus aims to enhance revenue accounting processes to support growth and efficiency.

  1. Objectives of the Consultancy

The primary objectives are to:

  • Perform a full assessment of current PRA processes within the first three months and implement at least three industry-standard improvements to enhance accuracy and efficiency by the end of the consultancy term.

 

  • Deliver a comprehensive training program and transfer knowledge on critical revenue accounting areas, with a target of having 100% of the PRA team proficient in key processes within six months.

 

  • Implement auditing controls and system optimizations to decrease identified revenue leakage by 20% within the first six months of consultancy.

 

  • Ensure full compliance with IATA and IFRS standards within three months and establish documented procedures to support continuous improvement and regulatory adherence for future operations.

 

    4.Scope of Work

The consultant will be expected to deliver on the following

# Area of focus Detail
4.1 Comprehensive PRA Assessment 

 

  • Conduct a detailed assessment of existing the Amadeus Revenue Accounting system and processes.
  • Benchmark against industry best practices to identify gaps and opportunities.
4.2 Customized Training & Capacity Building 

 

  • Provide practical, hands-on session to build competency in managing critical PRA processes such as handling of sales data, maintenance of fares, taxes and agents commission, proration (MPA/SPA), refunds processing, refunds application handling on BSP link, handling of EMD, auditing of fares, commissions and taxes, unreported sales, creation of ADM/ACM and upload to BSP/ARC, ADM/ACM Administration, flown data processing, SPA Management, PRL and uplift data reconciliation, EMD uplift processing, Sales and flown data reconciliation and balance of differences, interline billing, fare management, and reconciliations.
4.3 Revenue Leakage Minimization: 

 

  • Implement robust auditing processes to identify and mitigate revenue leakage sources, such as uncollected cancellation fees, fare discrepancies, and tax settlements.
  • Develop automated checks and balances to prevent common errors and fraud in ticketing and revenue recording.

 

4.4 System Integration & Optimization: 

 

  • Support the integration and optimization of existing revenue accounting systems, ensuring seamless data flow between GDS, reservation systems, and PRA platforms.
  • Recommend enhancements to support real-time revenue recognition, enabling faster and more accurate financial reporting.
4.5 Compliance & Regulatory Alignment: 

 

  • Ensure all PRA processes comply with IATA, IFRS, and local regulations.
  • Develop and document standard operating procedures (SOPs) to guide PRA activities.
4.6 Mentorship and support: 

 

  • Provide ongoing mentorship and support to ensure the sustainability of improvements.
  • Conduct periodic reviews and evaluations to measure the impact of the training and process changes.
4.7 Revenue Accounting Support & System Integration 

 

  • Offer guidance on optimizing the existing Amadeus Revenue Accounting system and integrating new features to enhance efficiency and accuracy.
  • Assist in the configuration and use of systems for better data management and reporting.
  • Automation Solutions: Support the integration of automated revenue accounting systems to streamline processes, improve efficiency, and reduce manual errors.
  • Interfacing with GDS/Reservation Systems: Ensure seamless integration between Global Distribution Systems (GDS), reservation platforms, and revenue accounting system for accurate data flow.
4.8 Interline Revenue Management: 

 

  • Train PRA staff on handling interline billing, managing prorate agreements, and settlements through IATA’s Clearing House and BSP (Billing and Settlement Plan).
  • Establish robust procedures for effective interline revenue management.
4.9 Revenue Assurance & Audit: 

 

  • Implement procedures to ensure data integrity and prevent revenue leakage.
  • Train the team in conducting regular audits and establishing controls to recover missed revenues.
  • Hand hold the Revenue Accounting team and optimize the Amadeus Sales Audit tool

 

4.10 Revenue Integrity & Assurance Services:
  • Fare Auditing: Ensure that all tickets and fares processed comply with published or agreed rates, preventing revenue leakage from incorrect fares or tax calculations.
  • Revenue Integrity: Implement systems to verify the integrity of revenue data, identifying potential errors or missed revenues early in the billing cycle.
4.11 Revenue Optimization through Analytics:
  • Data-Driven Insights: Incorporate advanced analytics into revenue accounting processes, allowing the airline to make informed decisions on pricing strategies, sales performance, and route profitability.
  • Real-Time Reporting: Develop real-time financial reporting systems to monitor key revenue metrics, offering immediate insight into performance against financial targets.
4.12 Revenue Recognition & IFRS Compliance:
  • Accounting Compliance: Train staff on international financial reporting standards (IFRS) relevant to revenue recognition, ensuring compliance with global accounting rules.
  • Deferred Revenue Management: Establish practices for managing and recognizing deferred revenue from unflown tickets or advanced bookings.
4.13 Dispute Management & Interline Accounting:
  • Dispute Resolution Process: Implement procedures to handle and resolve disputes with partner airlines regarding interline billing, ensuring timely settlement.
  • Interline Billing Automation: Train staff on automating interline billing processes using IATA’s systems, ensuring accurate and efficient financial settlements with partners.
4.14 Advanced Financial Reconciliation:
  • Automated Reconciliation: Implement automated reconciliation tools to compare sales, revenue, and cash flow data across multiple systems, ensuring consistency and identifying discrepancies.
  • Payment Reconciliation: Ensure the accurate recording of payments received through various channels like online bookings, agency sales, and credit card transactions
4.15 Knowledge Transfer & Documentation:
  • Develop comprehensive documentation, including Standard Operating Procedures (SOPs) and training manuals.
  • Provide ongoing mentorship to ensure smooth transition and sustainability.

Deliverables

# Deliverable Description Timeline
5.1 Initial Assessment and Process Mapping Report A comprehensive report detailing the evaluation of current PRA processes and system functionality, including complete process maps. This will highlight bottlenecks, inefficiencies, and provide actionable recommendations for optimization. By the end of Month 1 

 

5.2 Training Program and Materials A tailored training program with session outlines, materials, and process mapping guides. The training will cover critical PRA processes and workflows, ensuring the team fully understands the optimized workflows. This program will be delivered over the first three months. Completed by Month 3 

 

5.3 Workshops and Hands-On Training Sessions  A series of practical workshops and on-site training sessions, running from the second to the sixth month. These sessions will cover key revenue accounting processes, integrating process mapping to ensure a clear understanding of each workflow and its improvements. Ongoing from Month 2 to Month 6
5.4 System Optimization and Process Integration Report A detailed report summarizing the improvements made to the Amadeus Revenue Accounting system and the integration of these optimizations into the airline’s operations. Updated process maps will reflect the enhanced workflows and their alignment with industry best practices. By the end of Month 6 

 

5.5 Revenue Leakage Control Framework 

 

Development and implementation of an auditing and control framework to reduce revenue leakage. This framework will include process maps to identify and mitigate potential risks and inefficiencies in PRA workflows. Implemented by Month 6
5.6 Compliance and Process Documentation 

 

Comprehensive documentation, including Standard Operating Procedures (SOPs), guidelines, and process maps, ensuring all processes comply with IATA and IFRS standards. This will be submitted by the fourth month to institutionalize improved processes. Completed by Month 4
5.7 Ongoing Mentorship and Knowledge Transfer Continuous mentorship and knowledge transfer from Month 1 to Month 12, with regular evaluations of the PRA team’s progress. Process maps will be utilized to enhance understanding and retention of the improved workflows. A final evaluation of the mentorship will be included in the closing report. Throughout the Consultancy Term 

 

5.8 Final Report A conclusive report submitted at the end of the initial consultancy term, assessing the impact of the project, including measurable improvements in process efficiency, revenue assurance, and team competency. The final report will also include updated process maps of the optimized workflows and recommendations for future improvements.

Consultant Qualifications

The ideal consultant should posses

  • Extensive Experience in Airline Revenue Accounting: Demonstrated expertise in managing the airline revenue accounting function, including the ability to assess, optimize, and enhance critical PRA processesu regulations, including interline billing, revenue recognition, and compliance with international standards such as IFRS. Familiarity with the latest trends and best practices in airline revenue management systems is crucial.

 

  • In-depth Knowledge of IATA Regulations and Revenue Management Systems: A deep understanding of IATA regulations, including interline billing, revenue recognition, and compliance with international standards such as IFRS. Familiarity with the latest trends and best practices in airline revenue management systems is crucial.

 

  • Experience with Amadeus Revenue Accounting (Added Advantage): Experience in utilizing and optimizing the Amadeus Revenue Accounting system will be a significant advantage. The consultant should be able to assess its current implementation, provide recommendations for improvement, and support integration with other systems.

 

  • Proven Track Record in Revenue Assurance and Audit Procedures: The consultant must have a successful history of implementing robust revenue assurance frameworks and audit controls, designed to minimize revenue leakage and ensure data integrity within the PRA function.

 

  • Strong Communication and Training Skills: Excellent communication skills, with the ability to convey complex processes and systems to diverse teams. The consultant should also have a proven ability to mentor and train PRA staff, ensuring sustainable improvements and knowledge transfer.

 

  1. Proposal Submission Requirements

Interested consultants should submit a proposal including:

  1. Technical Proposal:
  • Methodology and approach for delivering the services outlined in the scope of work.
  • Detailed work plan with timelines and deliverables.
  • Consultant’s profile, highlighting relevant experience and qualifications.
  • References from similar past engagements.
    1. Financial Proposal:

 

  • Detailed cost breakdown, including professional fees, travel expenses, and other costs.
  • Payment terms and conditions.

 

  1. Evaluation Criteria

Proposals will be evaluated based on the following:

  • Relevance and quality of the proposed methodology and work plan.
  • Consultant’s expertise and experience in airline revenue accounting.
  • Cost-effectiveness of the financial proposal.
  • References and past performance on similar projects.

 

  1. Contract term:

One (1) year renewable

CLICK HERE TO APPLY

Uganda Airlines - Jobs in Uganda

About Uganda Airlines

Industry: Accounting
Location: Entebbe, Uganda
Uganda Airlines, the national carrier, operates as a traditional legacy airline and is dedicated to operational excellence and financial integrity.

Share job on social media

More Jobs

NGO

Project & Research Officer

Empower Through Health

Procurement & Logistics

analysis