Exporting from Tourplan a list with the arrivals; FIT and Groups, of a period.

​

3.1 How to create the FIT Arrival list

• Log in into Tourplan

• Operational Reports > Tour Summary

• Page 1

  • Select Travel Date: 1 Month before until 1 Month after

  • Booking Status: tick CD to CU+GD+PC+XA to XB
    (to select all confirmed bookings)

• Page 4 FIT Credit- to select only No

• Page 5 Booking Type - Fast Book only!

• Click on Export > Save as IR/SC FIT ARR LIST DAY.MONTH.csv  in P:/Credit Control/FIT ARR LIST 2014     

• Save as type ‘’comma separated values’’  > .csv

 

3.2 How to create the FIT Arrival list on the excel table

• Open Excel File

• Delete following Columns: Booking Status, Date Entered, Pax, EDG, Currency, Comission, Profit Value, Profit PC and Columns Coach/Guide to Country

• Add a column called Balance which will correspond to the outstanding balance of the file

  • Enter the formula = Invoiced - received

  • Extend the Formula to the whole Column by double-clicking on the right corner of the Cell

• Add a column called Not invoiced (between Agent&Invoiced) which will corresponds to the amount left to be invoiced or credited. (amount that appears in ‘’to be invoiced’’ in accounts summary in fastbook or groupbook)

  • Enter the formula = Agent - invoiced

  • Extend the Formula to the whole Column by double-clicking on the right corner of the Cell

• Add a column called Comments in the end

• Sort the column Balance from smallest to largest

• Delete all overpayments and zero balances (if already invoiced and received)

• Sort the column Travel Date from oldest to newest

​

The invoices are created in a bulk every 3 days and at least 4 weeks before arrival of the clients so we have some time to chase.