Overview of role
An administrator is needed to reconcile the payments made to the airlines against bookings held in our reservations system. The reconciliation is performed in Microsoft Excel.
On a daily basis information needs to be updated into the system (1 ½ hours) then the charges from bank statements are analysed and reconciled to the items in our system (2 ½ hours). Items that do not reconcile need to be investigated and resolved either with our own operations department or the Airline.
The remainder of the day will be spent assisting the Operations team with other No Frills Airlines issues or the BSP team in the reconciliation of our payments to other Airlines.
The daily tasks are repetitive but require a reasonable amount of common sense and application to successfully reconcile all items. Matching items from bank statements is often not straightforward and a number of different techniques must be employed to correctly identify all charges.
An outgoing personality would also be an advantage as there will be considerable liaison with the operations and sales departments personnel.
Some Experience of using spreadsheets is important and a positive inclination towards analysis and investigation is needed. The level of excel experience is more than simple data input and will require writing some formulas and creating new spreadsheets.